on 10-16-2006 6:03 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
check out this
https://www.sdn.sap.com/irj/sdn?rid=/webcontent/uuid/e7b06b5c-0501-0010-3c80-f82a07c9838a#posted [original link is broken]
Regards,
Prakash
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.