File content conversion in Sender Adapater for multiple occurances

[Former Member]

Hi ,

I am mapping from flat file to idoc .

My flat file is a tab demilited

Since the idoc would have structure

like header , lineitem , schedule

in my flat file conversion

i am giving recordset structure

as header,1,lineitem ,,schedule,

since lineitem would be repeated many times

Bt if i give * i need to give a keyfieldname

which would mean that keyfieldname has to appaer in header and schedule .

since in my case my Column values in header , lineitem and schedule are different

how can i do the file conversion in this case

i can doing something like this

header.keyFieldValue ""

schedule.keyFieldValue ""

header.keyFieldInStructure ignore

schedule.keyFieldInStructure ignore

i am not even sure if thats the correct way

Thanks

Amit

[Former Member]

Hi,

I dealt with a similar situation where I wasnt able to deal with the file data in the content conversion level.

I read the entire records into individual fields and then handled it using java mapping.

If you can provide the sample data it would be more clear.

[Shabarish_Nair]

if you are gonna give;

header,1,lineitem ,,schedule,

then a key field is needed in content conversion and i beleive you intend to say u dont have a keyfield for any of these fields. Can you confirm the same !!!

Since you dont have a keyfield, the next best way to read the file wud be ina record-row fashion. Chk - /people/sravya.talanki2/blog/2005/11/29/night-mare-processing-huge-files-in-sap-xi

[Former Member]

Hi Shabarish ,

Yes i dont have a key filed for any of these.

I am looking at your blog now .

hope i can get some soution

[Former Member]

I dont have a particular large file to read but i dont have any anything in common in header and line .

still not sure how to go about this

[Shabarish_Nair]

Ok !! Then try to read it in a record - row kind and then handle the logic in the mapping

[Former Member]

i am not sure how wld i do that

since the i/p file wld be coming fromthe client and it can contain

header 1.a.....................header 1.z

line 1.a.......................line1 .z

promsie1.a........promise1.z

.....

.....

.....

line n.a.........................line n.z

pomisen.a.........promisen.z

And i need to map it to idoc thing

ORDERSSP.ORDERS05

Thks

Amit

[Former Member]

Hi Amit,

Take a look at these...

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

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

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

cheers,

Prashanth

P.S Please mark helpful answers

[Former Member]

i would be giving the fieldNames and field Seprators also

[Former Member]

Hi Folks,

any idea on this . beacuse without giving keyfieldName i get the following error

Sender Adapter v2723 for Party '', Service 'filetofile_bs':

Configured at 2006-08-01 09:15:57 UTC

History:

- 2006-08-01 09:15:57 UTC: Error: Conversion initialization failed: Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found:

Mandatory parameter 'xml.keyfieldName': no value found

Thanks

Amit