Regarding File Content Conversion

[Former Member]

Hi All,

Here i have a problem in reading flat file by using Fixed length conversion.

Source structure should be appered as:( for example)

<Name_MT>

<Record>

<Header>

<Sno>

<Sname>

<Line>

<Sno>

<Address>

<Details>

<Sno>

<City>

</Record>

</Name_MT>

I confused at giving Recordset Structure.But I was able to create upto to the structure mentioned below.

<Name_MT>

<Record>

<Header>

<Sno>

<Sname>

<Line>

<Sno>

<Address>

<Details>

<Sno>

<City>

</Record>

</Name_MT>

But here (if u compare with above structure) Header and Line are coming in same level. But Line should be substructure of Header.

Comments are welcome.

Thanks.

[Former Member]

Hi Nani,

Specify the below in your comm channel:

Document Name : Name_MT

RECORDSET NAME: Record

RECORDSET STRUCTURE:Header,*

In Name , value

Header.fieldFixedLengths - lengths of fields

Also go through the below link:

http://help.sap.com/saphelp_nw04/helpdata/en/0d/5ab43b274a960de10000000a114084/frameset.htm

Hope this solves your query.

Thanks,

Rajeev Gupta

Message was edited by:

RAJEEV GUPTA

[Former Member]

Hi,

Go through the following blogs for the File Content Conversion of sender file adapter.

<a href="/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30 File adapter</a>

<a href="/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter File adapter for a file with Fixed lengths</a>

Regards,

Joslyn

[Former Member]

with file adapter will get same sturcure then if you nested structure then you need to Use XSLT mapping to convert into nested structure.

please reward points

Thanks

Sreeram.G.Reddy

[prabhu_s2]

dear nani

check <a href="/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30 to send a flat file with various field lengths and variable substructures</a>

PS: Award points to all helpfull replies