complex file content conversion

[Former Member]

Hi all

How can we do file content conversion for the following sender message structure.

MT_PurchaseOrder

-->Order (unbounded)

-

---

>Header (1)

-

---

>Name

-

---

>Address

-

---

>Item (unbounded)

-

---

>MatNo

-

---

>Units

-

---

>Price

Note:<b> Order is repeated no of times , in each order Header occurs one time and Items can occurn no of time.</b>

CSV FILE with keyfield

1,CITI,Hyderabad

2,PLOAN,10,250000

2,HLOAN,20,350000

1,CBI,Banglore

2,PLOAN,15,300000

2,HLOAN,30,350000

Thanks

[Former Member]

HI,

See the below links

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter - FCC

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter - FCC

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

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file - FCC

/people/harrison.holland5/blog/2006/12/20/xi-configuration-for-mdm-integration--sample-scenario - FCC - MDM

/people/shabarish.vijayakumar/blog/2006/04/03/xi-in-the-role-of-a-ftp - FCC

/people/prateek.shah/blog/2005/06/14/file-to-r3-via-abap-proxy - FCC

/people/mickael.huchet/blog/2006/09/18/xipi-how-to-exclude-files-in-a-sender-file-adapter - EOIO - File

http://help.sap.com/saphelp_nw04/helpdata/en/ee/c9f0b4925af54cb17c454788d8e466/frameset.htm - cc

http://help.sap.com/saphelp_erp2005vp/helpdata/en/95/bb623c6369f454e10000000a114084/content.htm - fcc cOUNTER

Regards

Chilla..

[Former Member]

Hi Prasad,

do the below for file content conversion:

documnet name:MT_PurchaseOrder

recordset name: Order

recordset structure: Header,1,Item,*

recordset Sequence : Ascending

key field name : Key

key type : string case-sensitive

Key-Value pair:

Header.keyFieldValue '1'

Header.fieldSeparator ','

Header.fieldNames Name, Address

Item.keyFieldValue '2'

Item.fieldSeparator ','

Item.fieldNames MatNo, Units, Price

do the above configuration........save it and activate the comm channel....

Hope this helps you.

Thanks,

Rajeev Gupta

Message was edited by:

RAJEEV GUPTA

[former_member181955]

Hi

I have done everything same.

But i did not find recordset seq in comm channel.

thanks

Nemalikanti

[Former Member]

Hi Prasad,

It is Recordset Sequence : Ascending in comm channel.

Thanks,

Rajeev Gupta