File Conversion Scenario

[former_member191528]

Hello All,

We have a scenario where we are getting an header and a recordset with multiple items. The data comes in as a text file. The extension is xlr

The header structure is as follows :

Name : John

Last Name : Doe

Date of Birth : 07/04/1776

The repeatable items structure is as follows :

House Number City State Country

123 LA California USA

456 Austin Texas USA

How do we read this data using FCC ?

Your help is highly appreciated.

Thanks,

Kiran

[baskar_gopalakrishnan2 · Accepted solution]

THe requiement is so simple. You can use recordset structure in the sender channel as header,1,items,*. Please search scn for fcc sender scenario. There are some useful links to do fcc configuration.  Please see below links http://help.sap.com/SAPhelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm http://saptechnical.com/Tutorials/XI/Contentconversion/page1.htm http://www.riyaz.net/sap/xipi-file-content-conversion-for-simple-structure/75/

[former_member191528 · Accepted solution]

Thanks Bhaskar !! The issue is that we don't have a unique key for both the header and the items structure. How do we deal with that issue ?

[baskar_gopalakrishnan2 · Accepted solution]

Please glance this link and see whether this is helpful in your case http://scn.sap.com/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-pro...You might also want to see this link using messagetransformationbean for the key field problem. http://scn.sap.com/people/gabrielsagayaselvam.panneerselvam/blog/2009/08/31/solve-key-field-problem-...

Message was edited by: Baskar Gopalakrishnan