Sender File Adapter-Content conversion for a tab delimited file

[Former Member]

Hi all,

I have a FIle to IDoc scenario, where the File is with the structure Header,Detail,Trailer.

Header and Trailer are with fixed field lengths, whereas the detail records are tab delimited.(Functional spec says delimited by H'05').

I have given the parameters as follows:

Header.keyFieldValue H

Header.fieldFixedLengths 1,1,4,1,8

Header.fieldNames a,b,c,d,e

Header.endSeparator 'nl'

Detail.fieldNames a,b,c,d,e,f

Detail.fieldSeparator '0h05'

Detail.keyFieldValue LOA

Detail.endSeparator 'nl'

Trailer.fieldFixedLengths 1,1,8

Trailer.fieldNames a,b,c

Trailer.keyFieldValue T

ignoreRecordsetName true

In SXMB_MONI, I get the payload with just the Header and Trailer and not the detail records, even though my file has so many records in it.I m pretty sure, this happens because of my Detail.fieldSeparator parameter.

Can anyone please help me with this?What is the correct value for this parameter?

Thanks a lot in advance!

Anjana.

[Former Member · Accepted solution]

You have to use 0x09 for TAB. You can see the example of TAB delimited file in this blog..

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

[Former Member · Accepted solution]

Sarvesh,

Thanks for the blog link.'0x09' did not work for me.But copying the tab from a notepad and pasting it at the parameters worked!

Thanks a lot for the help!

Anjana.

[Former Member]

Thanks for the help!!

[baskar_gopalakrishnan2]

>>>Detail.fieldSeparator '0h05'

Detail.fieldSeparator = '0x09' (tab delimited)

[Former Member]

I have tried '0x09' and it is not pulling the Detail records from the file in the payload.

Thanks,

Anjana.

[Former Member]

Make sure your detail record structure is having 0..unbounded occurrence. If possible provide the whole FCC parameters here..

[stefan_grube]

first of all make sure with a hex editor that the hex code of the delimiter sign is really 05. This is an odd character, as the normal tab is hex 09.

when you have confimred it, check online help for file adapter config for the correct entry of hex codes. I think it is something like '0x05',

Edited by: Stefan Grube on Feb 10, 2011 6:43 PM