Generate XSL for File to mail interface

[Former Member]

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

[Former Member]

not possible with XSL

[former_member223322]

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

[abhay_rajhans2]

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'

[Former Member]

HI there,

Thank you so much for your reply.

I want to do this through XSL or JAVA Mapping.

Please tell me if it is possible.

Thanks,

Iqbal