XML Export Scenario for Sales Orders

Hi @Harshita 

To create an export scenario:

1.Create a Excel file with the appropriate field schema and data
2.Open the data provider and name the provider,Upload a Excel file that has been created in the data provider 
3.Open the export scenario screen.
4.Create a new export scenario and give it a descriptive name.
5.Choose the data source and select the desired fields.
6.Configure additional options and settings.
7.Save the scenario and test it with sample data.
8.Run the export scenario to generate the final XML file.
9.Verify the exported XML file for accuracy and completeness.

The above steps outline the process of creating an export scenario using an Excel file as the data source.

Hope, it helps.!

Regards,

Sweta

I am also trying to understand the capability of XML Export scenarios. When creating a Data provider with XML provider type you can attach a sample xml file which is valid XML but you get the error that started this thread. From another case and the help it appears that that you can import and successfully export an xml structure which represents a flat structure with column headings and rows, eg 

<Root>

<Columns>

  <Column>DocumentDesc</Column>

  <Column>InvoiceNumber</Column>

</Columns>

<Rows>

<Row>

  <Item>The name of the document</Item>

  <Item>123456</Item>

</Row>

</Rows>

</Root>

However you cannot import a normal tree XML Structure (even using ‘tree’ in the data provider paramater for xml format) like below :

<Root>

  <Invoice>

    <Description>The name of the document</Description>

    <InvoiceNumber>123456</InvoiceNumber>

    <Lines>

      <Line>

        <GLCode>123456</GLCode>

        <Value>123.22</Value>

      </Line>

    </Lines>

  </Invoice>

</Root>

As the help suggest if you want ‘other formats’ use the API. Is this correct ?