cancel
Showing results for 
Search instead for 
Did you mean: 

converting CSV file coming as string in one of the field of xml to XML

Former Member
0 Kudos

Hi ,

we have the below requirement where the dat type is :

DT_MESSAGE

field1 Data

field2 DataString

the csv file of the below format will be sent in the DataString field of xml .

Source;EIX3;Date;080526;Charge;70199;Si;.42 ;Fe;.20 ;Cu;.00 ;Mn;.027 ;Mg;.49 ;Cr;.0007 ;Ni;0 ;Zn;.01 ;Ti;.01 ;Ag;0 ;B;0 ;Ba;0 ;Be;0 ;Bi;0 ;Ca;0 ;Cd;0 ;Co;0 ;Ga;0 ;Na;0 ;Nb;0 ;Pb;0 ;Sb;0 ;Sn;0 ;Sr;0 ;V;0 ;Zr;0 ;Al;0 ;P;0 ;Hg;0 ;Li;0 ;Alloy;606044;Alloy_Hy;AC10;Diametre;152;Client;IMPOL

Source;EXF3;Date;080811;Charge;71460;Si;.04 ;Fe;.10 ;Cu;.002 ;Mn;.003 ;Mg;.002 ;Cr;.0006 ;Ni;.003 ;Zn;.014 ;Ti;.000 ;Ag;0 ;B;0 ;Ba;0 ;Be;0 ;Bi;0 ;Ca;0 ;Cd;0 ;Co;0 ;Ga;0 ;Na;0 ;Nb;0 ;Pb;.0010 ;Sb;0 ;Sn;.000 ;Sr;0 ;V;.001 ;Zr;0 ;Al;99.8 ;P;0 ;Hg;0 ;Li;0 ;Alloy;400101;Alloy_Hy;831B9901;Diametre;PFA;Client;DANFOSS

Source;EXF3;Date;080813;Charge;71535;Si;9.55 ;Fe;.12 ;Cu;1.05 ;Mn;.01 ;Mg;.38 ;Cr;.0008 ;Ni;.00 ;Zn;.01 ;Ti;.01 ;Ag;0 ;B;0 ;Ba;0 ;Be;0 ;Bi;0 ;Ca;.0011 ;Cd;0 ;Co;0 ;Ga;0 ;Na;.0006 ;Nb;0 ;Pb;.0010 ;Sb;.0003 ;Sn;.00 ;Sr;.0002 ;V;0 ;Zr;0 ;Al;0 ;P;.0008 ;Hg;0 ;Li;.0001 ;Alloy;444205;Alloy_Hy;Al AS9C1;Diametre;PFA;Client;TEKSIDPL

Source;EXF3;Date;080813;Charge;71538;Si;9.57 ;Fe;.12 ;Cu;1.01 ;Mn;.01 ;Mg;.39 ;Cr;.0008 ;Ni;.00 ;Zn;.01 ;Ti;.01 ;Ag;0 ;B;0 ;Ba;0 ;Be;0 ;Bi;0 ;Ca;.0007 ;Cd;0 ;Co;0 ;Ga;0 ;Na;.0004 ;Nb;0 ;Pb;.0010 ;Sb;.0004 ;Sn;.00 ;Sr;.0002 ;V;0 ;Zr;0 ;Al;0 ;P;.0007 ;Hg;0 ;Li;.0001 ;Alloy;444205;Alloy_Hy;Al AS9C1;Diametre;PFA;Client;TEKSIDPL

Source;EIX3;Date;080813;Charge;71539;Si;.06 ;Fe;.19 ;Cu;.00 ;Mn;.00 ;Mg;.00 ;Cr;0 ;Ni;0 ;Zn;.01 ;Ti;.01 ;Ag;0 ;B;0 ;Ba;0 ;Be;0 ;Bi;0 ;Ca;0 ;Cd;0 ;Co;0 ;Ga;0 ;Na;0 ;Nb;0 ;Pb;0 ;Sb;0 ;Sn;0 ;Sr;0 ;V;0 ;Zr;0 ;Al;99.71 ;P;0 ;Hg;0 ;Li;0 ;Alloy;107070;Alloy_Hy;AC99.7;Diametre;152;Client;ARO TUBI

where the starting field is Sorce of each row .

I need to parse the above csv using xslt or java mapping .

The target structure xml is

DT_Target

row 0 to unbounded

field 1 Source

field2 Date

field3 Charge

.........

field n Client

can anyone help me how to parse and map to the target.what could be the better method to do it.

Thanks and Regards,

Rajesh

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Rajesh,

1) You can create a custom Adapter module and get the required xml structure.

2) Or, you can handle the current structure in a java mapping.

OR

If you dont want to write a Java adapter module or mapping:

Call StrictXml2Plain bean in the module processor and conver the existing xml structure to a plain csv structure.

Then call the CallSapAdapter and use File Content Convertion. Hope this works.

Regards,

Aravind

former_member207622
Contributor
0 Kudos

You can use xsl mapping to retrieve that payload ina single field and map it to target

Please check these links

/people/michal.krawczyk2/blog/2005/11/01/xi-xml-node-into-a-string-with-graphical-mapping

regards

Ninad

Answers (1)

Answers (1)

Former Member
0 Kudos

Thanks for the Input we are using ABAP Mapping for converting XML String and mapping to target