on 05-17-2009 9:19 PM
hello friends:
I needed output file as with xml tags at beginning and ending and inbetween csv file
Eg for the desired output
<Main>
<Header>
<H1> headertext1 </H1>
<H2> headertext2 </H2>
</Header>
<BODY>
A,123,445,455, KUM1ABC
B,XX, YY,ZZ,KUM2ABC
B,12a,446,457,KUM3ABC
B,12b,447, 458,KUM4ABC
B,12c,448,459,KUM5ABC.
</BODY>
</Main>
1. I am receiving a table from sap rfc as source and mapped inside XI to a target structure.
COL1 COL2 COL3 COL4 COL5
A 123 445 455 KUM1ABC
B XX YY ZZ KUM2ABC
B 12a 446 457 KUM3ABC
B 12b 447 458 KUM4ABC
B 12c 448 459 KUM5ABC
2,Create Target structure
Target Structue:
Node
Header
H1
H2
Data
C1
C2
C3
C4
C5
3.At Receiver communication channel i used FCC with Body.fieldSeparator as ',' and i am getting the output as below with total csv file .How to get xml tags at beginning and at ending and in between csv file?
Output:
headertext1
headertext2
A,123,445,455, KUM1ABC
B,XX, YY,ZZ,KUM2ABC
B,12a,446,457,KUM3ABC
B,12b,447, 458,KUM4ABC
B,12c,448,459,KUM5ABC
thanks for reading my message! any clues are appreciated
Do not use FCC for this. Instead define the XM strucuture as you want in the message mapping and then map the way you want using some UDFs.
VJ
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You use like below.
Use StrictXml2PlainBean to convert the file in .csv format.The same like FCC paramters .
[http://help.sap.com/saphelp_nw70/helpdata/EN/44/748d595dab6fb5e10000000a155369/content.htm]
After that use adapter module and add the xml tag in the file.
Module should be present like,
1.StrictXml2PlainBean
2.Custom Adapter module
3.CallSapAdapter
Regards,
Prakasu.M
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
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.