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 a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

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 a 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 a 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 a 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.