Skip to Content
avatar image
Former Member

Receiver File Content Conversion concerns

Dear SAP experts,

Need your advise regarding File Content Conversion.

I have here the XML,

<?xml version="1.0" encoding="UTF-8" ?>

http://pg.com/xi/tom/connect/edi">

<SLI_root> ---> this is the root node of 'CSVFileName' and 'SLI'

<CSVFileName>Globus_20080306</CSVFileName>

<SLI> ---> this is the root node of the below fields

<PERIO>20071222</PERIO>

<EAN>737052018164</EAN>

<ILN>4304452000004</ILN>

<SALES>16</SALES>

<TURNO>120</TURNO>

<PERFL>W</PERFL>

<SUBSFL>X</SUBSFL>

<SALUN>ST</SALUN>

<CURRENCY>EUR</CURRENCY>

<STOCK>000000000</STOCK>

<STOUN>ST</STOUN>

</SLI>

<SLI>

<PERIO>20071222</PERIO>

<EAN>737052018232</EAN>

<ILN>4304452000004</ILN>

<SALES>3</SALES>

<TURNO>38.699997</TURNO>

<PERFL>W</PERFL>

<SUBSFL>X</SUBSFL>

<SALUN>ST</SALUN>

<CURRENCY>EUR</CURRENCY>

<STOCK>000000000</STOCK>

<STOUN>ST</STOUN>

</SLI>

<SLI>

.

.

.

.

</SLI_root>

</ns0:CSV>

CSV --> The Message Type of the XML.

SLI_root is under CSV

CSVFileName and SLI are under SLI_root

PERIO, EAN, ILN.. etc. are under SLI

SLI_root is under CSV.

CSVFileName and SLI are under SLI_root.

PERIO, EAN, ILN,... fields are under SLI.

The parameters i've set in Content Conversion are:

Recordset Substructure: SLI_root,SLI

SLI_root.endSeparator: 'nl'

SLI_root.fieldSeparator: 'nl'

SLI.addHeaderLine: 3

SLI.headerLine: PERIO;EAN;ILN...

SLI.fieldSeparator: ;

My output should be,

PERIO;EAN;ILN;SALES;TURNO;PERFL;SUBSFL;SALUN;CURRENCY;STOCK;STOUN

20071222;737052018164;4304452000004;16;120;W;X;ST;EUR;00000000;ST

20071222;737052018164;4304452000004;16;120;W;X;ST;EUR;00000000;ST

20071222;737052018164;4304452000004;16;120;W;X;ST;EUR;00000000;ST

The parameters i've set in Content Conversion are:

SLI_root.endSeparator: 'nl'

SLI_root.fieldSeparator: 'nl'

SLI.addHeaderLine: 3

SLI.headerLine: PERIO;EAN;ILN...

SLI.fieldSeparator: ;

SLI.endSeparator: 'nl'

When i've run my scenario, the output is this,

Globus_20080306;20071222;737052018164;4304452000004;16;120;W;X;ST;EUR;000000000;ST

20071222;737052018232;4304452000004;3;38.699997;W;X;ST;EUR;000000000;ST

20071222;737052018263;4304452000004;1;12.9;W;X;ST;EUR;000000000;ST

20071222;737052018294;4304452000004;1;10.45;W;X;ST;EUR;000000000;ST

The header lines are not present and the value of CSVFileName (Globus_20080306) was inserted in my values.

Kindly advise what is wrong on my parameters set.

Or is there something missing in my configs.

Or i will change my structure of XML ?

Thank you very much!

Fred

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 06, 2008 at 02:49 PM

    Fred,

    Could you give me the snapshot of your receiver channel?

    raj.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Justin Santhanam

      Hi Raj,

      Is it ok if you give me the snapshot of the correct configurations in the Receiver File Adapter that must be set for the UDF you've given me last time to work?

      Hoping for your consideration.

      Thank you very much!

      Fred