on 05-25-2010 1:34 PM
HI there,
Can somebody please tell me how to write xsl for the file to mail interface.
I am getting only payload in the file and I want to convert that payload into xml so that I can map in PI.
I tried with FCC but it doesn't work so the only option is via XSL mapping or JAVA mapping but unfortunately I don't know any of them, so can somebody please help me and write XSL for me if possible.
Source File
ACK3|24052010095354|4BC8612A7A530073E100800024590A61|1005241738SPBC8612A7A5000|D0000018|SXI|75130|(INFO) File Sent|PAYMENTS
and I want the target file
<ns0:ContentContainer xmlns:ns0="http://s.com/xi/10/lite">
<payload>ACK3|24052010095354|4BC8612A7A530073E100800024590A61|1005241738SPBC8612A7A5000|D0000018|SXI|75130|(INFO) File Sent|PAYMENTS</payload>
</ns0:ContentContainer>
Thanks,
Iqbal
not possible with XSL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Muhammad,
Could you please tell me on what settings you did in FCC? Because using the FCC you should be able to convert the given flat file data in to an XML record.
~Vaas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Iqbal,
The below mentioned do not seems to be difficult using FCC.
In FCC mention following parameters. And provide required structure as message type in content conversion paramter.
Recordset Structure : row,*
row.fieldNames: payload
row.fieldSeparator: 'nl'
row.endSeparator: 'nl'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
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.