Read File record by record

[Former Member]

Hi All,

I have to read File using File/FTP Adapter and read record by record.

How to do this?

Appreciate ur help?

Thanks

[Former Member]

Hi Kumar,

You have to use File content Conversion in the sender adapter with "Recordsets per message = 1".

And you have to mention the Recordset structure(Ex: Header,1,Detail,*) and key values.

Check the following links for details:

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

http://help.sap.com/saphelp_nw04/helpdata/en/0b/9a50465ccf84479e39a6d50c90fb3f/frameset.htm

Regards,

Rakesh.

[STALANKI]

use this blog /people/sravya.talanki2/blog/2005/08/16/configuring-generic-sender-file-cc-adapter

It will help u to read file record by record.

[MichalKrawczyk]

Hi,

>>>and read record by record.

if you have a flat file then specify:

Recordsets per Message = 1

if you have an xml message then it's not possible

in standard to read record by record

Regards,

michal

[Former Member]

If i have below file, how do you know the number of records to be considered as one message ?

Between each header/trailer, u may have 1 to n detail records.

and then 1-n total records (header thru trailer) in afile.

i want to consider header thru trailer as one message.

for example, i want to consider below records as 2 messages.

H,000316673B,war,316673,Mr.,John P.,Farrell,,,,5410,W14,Rd,Mesick,MI,49668,,231-885-1232

J,000316673B,war,,?,X

L,000316673B,war,22600,1,20.00

H,000324793A,war,324793,,,,,Watertown Police Department,attn: Pam Kwosniewski,119 S,Maple,St,Watertown,SD,57201,,605-882-6210

J,000324793A,war,4459015970,?,$

L,000324793A,war,64483,2,40.00

H,000327995A,war,327995,,,,,Farmers Savings Bank,attn: David Wingert,17 W,2nd,St,Remsen,IA,51050,,712-786-1143

J,000327995A,war,5396550163612414,10/01/05,M

K,000327995A,war,332296,Mr.,David,Wingert,,,,,PO Box 26,,Remsen,IA,51050-0026,,

L,000327995A,war,22620R,1,20.00

[MichalKrawczyk]

Hi,

>>>>If i have below file, how do you know the number of records to be considered as one message ?

if H means header for example you just put

the whole structure header, line in the

content conversion parameters

and then at every header occurance a new message

should be created

BTW

but I don't know what is the key for header in your example as there are more then two H in this one

Regards,

michal

[Former Member]

The sample data show there are two records with each one header - 'H'.

so i should put xml.header.recordsetsPerMessage=1 ?

to consider each header thru trailer as one message?