Help on Receiver content conversion

[Former Member]

Hello All

I am converting xml file to a flat file . I am doing this to convert the Purchase order into EDIFACT D97A format.

The XML file I have is

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

- <EDIFACT>

- <UNB>

- <UNB01>

<UNB0101>UNOC</UNB0101>

<UNB0102>2</UNB0102>

</UNB01>

- <UNB02>

<UNB0201>ABC</UNB0201>

</UNB02>

- <UNB03>

<UNB0301>DEF</UNB0301>

</UNB03>

- <UNB04>

<UNB0401>080623</UNB0401>

<UNB0402>0629</UNB0402>

</UNB04>

<UNB05>846</UNB05>

</UNB>

- <UNH>

<UNH01>8</UNH01>

- <UNH02>

<UNH0201>DELFOR</UNH0201>

<UNH0202>D</UNH0202>

<UNH0203>97A</UNH0203>

<UNH0204>UN</UNH0204>

</UNH02>

</UNH>

</EDIFACT>

I need it in a flat file of this format

UNBUNOC:2O0013000144HOESCHHECKER080623:0629+846'

UNH8DELFOR:D:97A:UN'

Can any one give me the file content parametes for this please. I tried it myself but i am not able to achieve the flat file as shown above.

Thank you

Sudheer

[Former Member]

tyhank you

[GabrielSagaya]

Please try this one!!

Recordset Structure : UNB,UNB01,UNB02,UNB02,UNB03,UNB04,UNB05,UNH,UNH01,UNH02,UNH0201,UNH0202,UNH0203,UNH0204

UNB.fieldNames=UNB01,UNB02,UNB03,UNB04,UNB05

UNB.fieldSeparator +

UNB01.fieldNames=UNB0101,UNB0102

UNB01.fieldSeparator :

UNB01.endSeparator +

UNB02.fieldNames=UNB0201

UNB02.fieldSeparator :

UNB02.endSeparator +

UNB03.fieldNames=UNB0301

UNB03.fieldSeparator :

UNB03.endSeparator +

UNB04.fieldNames=UNB0401,UNB0402

UNB04.fieldSeparator :

UNB04.endSeparator +

UNB.endSeparator '

UNH.fieldNames=UNH01,UNH02

UNH.fieldSeparator +

UNH02.fieldNames=UNH0201,UNH0202,UNH0203,UNH0204

UNH02.fieldSeparator :

UNH02.endSeparator +

UNH.endSeparator '

[Former Member]

Hi Gabriel

When i tried as u suggested , the communication channel monitoring says that

'UNB05.fieldSeparator' is missing

We can't five a fieldSeperator for UNB05 because it doesn't have any subelements under it.

Thanks , and do you have any other suggestions?

[Former Member]

HI

Refer the following links

Configuring the Receiver File/FTP Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/95/bb623c6369f454e10000000a114084/frameset.htm

File Content Conversion for Unequal Number of Columns

/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns - FCC

Content Conversion (Pattern/Random content in input file)

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file - FCCFile Content prameters for the Receiver Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/frameset.htm

cheers

[former_member181962]

Hi,

I think you may have to create X2E conversion programs using seeburger mapping designer and deploy them on to the Xi server.

Later you have to specify the name of the conversion program in the module configuration tab of the receiver Seeburger AS2 adapter.

Regards,

Ravi

[Former Member]

Hi Ravi

We have decided not use the seburger adapter as this only one scenario where we will be using flat files. So I have decided to do it using FCC , Is it possible to achieve this using FCC ?

[former_member181962]

Try as explained heer:

http://www.riyaz.net/blog/index.php/2008/02/19/xipi-file-content-conversion-for-simple-structure/

Regards,

ravi

[Former Member]

To even simplfy my requirement , The xml file i have is

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

<EDIFACT>

<UNB>

<UNB01>

<UNB0101>UNOC</UNB0101>

<UNB0102>2</UNB0102>

</UNB01>

<UNB05>846</UNB05>

</UNB>

</EDIFACT>

The flat file i need is

UNOC:2+84'

The content parameters i ahve used are

Recordset Structure : UNB,UNB01

UNB.fieldSeparator +

UNB01.fieldSeparator :

UNB01.endSeparator +

UNB.endSeparator '

with these i am getting