Skip to Content
author's profile photo Former Member
Former Member

File content conversion in Sender Adapater for multiple occurances

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

Add comment
10|10000 characters needed characters exceeded

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 12:38 PM

    i would be giving the fieldNames and field Seprators also

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 07:28 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 02, 2006 at 07:30 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Shabarish V Nair

      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

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 01:50 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded