Forum Stats

  • 3,770,408 Users
  • 2,253,104 Discussions
  • 7,875,445 Comments

Discussions

How to Rearrange Columns in Output csv File

rmunene
rmunene Member Posts: 61 Blue Ribbon
edited Mar 21, 2018 5:23AM in SOA Suite Discusssions

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

Tagged:

Best Answer

  • RakeshKr
    RakeshKr Member Posts: 401 Silver Badge
    edited Mar 20, 2018 12:31PM Accepted Answer

    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.

Answers

  • rmunene
    rmunene Member Posts: 61 Blue Ribbon
    edited Mar 19, 2018 4:45AM

    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>

    pastedImage_0.png

  • RakeshKr
    RakeshKr Member Posts: 401 Silver Badge
    edited Mar 20, 2018 12:31PM Accepted Answer

    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
    rmunene Member Posts: 61 Blue Ribbon
    edited Mar 21, 2018 5:10AM

    Thanks RakeshKr,

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

    pastedImage_0.png

  • RakeshKr
    RakeshKr Member Posts: 401 Silver Badge
    edited Mar 21, 2018 5:23AM

    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.

    rmunene
This discussion has been closed.