cancel
Showing results for 
Search instead for 
Did you mean: 

Trouble in CSV to CSV

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member206604
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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.

Answers (4)

Answers (4)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

former_member206604
Active Contributor
0 Kudos
Former Member
0 Kudos

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

former_member206604
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

former_member206604
Active Contributor
0 Kudos

Hi,

Check out this link

If you again face the same problem let us know, also please post your target XML with the strucutre and the content conversion paramter.

Regards,

Prakash