How to Rearrange Columns in Output csv File

rmunene

Hi.

I have an interface that was developed to pick an xml file & convert to csv. The party receiving the csv want the columns to be arranged differently than they are at the moment. How can I achieve this?

https://www.dropbox.com/s/r196bmimgzdzg11/sca_svcEpromisToHyperion.jar?dl=0

RakeshKr

Instead of doing it manually. Open the composite, double click the FTP adapter which is writing file.

When you hit step 6, click on the icon beside search, another popup will come up. Go through with that and adjust your csv file.

rmunene

I attempted dragging the elements in the capture below and deployed but the composite failed  with the following error

<fault>

<bpelFault>

        <faultType>0</faultType>

        <bindingFault xmlns="http://schemas.oracle.com/bpel/extension">

            <part name="summary">

              <summary>Exception occurred when binding was invoked.

Exception occurred during invocation of JCA binding: "JCA Binding execute of Reference operation 'writeReport' failed due to: Translation Error.

Translation Error.

Error while translating message to native format.

Please make sure that the payload for the outbound interaction conforms to the schema.

".

The invoked JCA adapter raised a resource exception.

Please examine the above error message carefully to determine a resolution.

</summary>

            </part>

            <part name="code">

              <code>null</code>

            </part>

            <part name="detail">

              <detail>Element 'ownershipType' not expected.</detail>

            </part>

        </bindingFault>

      </bpelFault>

  </fault>

  <faultType>

<message>0</message>

  </faultType>

</messages>

RakeshKr

Instead of doing it manually. Open the composite, double click the FTP adapter which is writing file.

When you hit step 6, click on the icon beside search, another popup will come up. Go through with that and adjust your csv file.

rmunene

Thanks RakeshKr,

error below came up. Do you know which sample file is needed?

RakeshKr

Get a sample csv file.

Open the file hyperionTarget.xsd and go to source.

<xsd:appinfo>NXSDSAMPLE=/E:/epromistohyperion.csv</xsd:appinfo>

Update the /E:/epromistohyperion.csv based on where you are going to keep the sample file.

Run the wizard again.