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

Trouble in CSV to CSV

Hi Experts,

I am trying to send a CSV file and get back a CSV file.

my parametsr are as below:

Doc name: ven_mt(as msg type)

doc name space: urn:sendnamespace

record set name: REC (1st sub elemnt data type in the defined structure)

rec set structure: STRC (structure name)

field separator: ,

end separator: 'nl'

field anmes: venid,venname,vencity,vencountry

similar fashion in receing channel also.

My file is getting processed but the problem is , I am getting only the first field in the output file. rest 3 fileds are not seen in the o/p files.

Can any one tell me where am i going wrong?

Thanks

kiran

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    Posted on Oct 16, 2006 at 05:09 PM

    Hi,

    Are you sure your Sender File adapter is proper and in SXMB_MONI you are getting the expected payload XML. Also in SXMB_MONI your output XML payload is as expected.

    Check this link for configuring the Receiver Content conversion.

    http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

    Please post the receiver content conversion settings.

    Regards,

    Prakash

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      The content conversion parameters for sender and receiver commn channels differ. Look into the link Prakash has given. For more help give us your source and target xml structure along with the content conversion parameters..

      Regards,

      Jai Shankar.

  • author's profile photo Former Member
    Former Member
    Posted on Oct 16, 2006 at 05:48 PM

    frnds tx for ur quick replies.

    i had already given the parametrs i used and their values.

    pl let me know if u need any more

    thanks

    kiran

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 18, 2006 at 02:20 AM

    tx prakash,

    it works fine now. I brought a chage in the structure of the data type and it works fine.But another issue is it converts CSV to CSV and its creating a unique file for each record I am sending. Is this the problem from occurences or due to any other reason.

    can u let me no

    any clues pl?

    regds

    kiran

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      You mean to say it is creating sperate files for each and ever record in the input file. Hope you have'nt done any extended interface determination with multimapping. For each execution how many entries you are having in the SXMB_MONI, if it is equal to number of records. Then the problme is in the sender adapter you hace set Records per message as 1. Make that field blank or give *.

      Regards,

      Prakash

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2006 at 02:16 AM

    Hi prakash,

    I could find n no of msgs in xsmb_moni for n records that each receiver is receiving based on the condition routing.

    Probably as u guessed, I set that structure to 1. I need to change that value today after i go off n try.

    Tx prakash. u n bhavesh are helping us a lot in this forum. can u tell me how 2 award points also...

    keep up ur good work

    regds

    kiran

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2006 at 10:31 AM

    hi frnds my problem got solved.

    I brought two changes

    1. Sending side data type shud be declared as :

    data type name -> rec set -> strc name -> fields

    and receiver system as follows

    data type name -> strc name -> fields

    This change allowed me 2 convert whole CSV to CSV but creates a file for each record it processed

    2. Instead of ADD TIME STAMP, I used create / append.

    This created a file instead of creating a single file each record it processed.

    Thanx prakash, Bhavesh n all others

    Keep up the good work . I shall also try 2 do my best

    Regds

    Kiran

    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.