Pound Sign (u00A3) in Sender SFTP Channel - using MessageTransormBean

[Former Member]

Hi,

I am reading a csv file using Seeburger SFTP Sender Communication channel.

One of the field has pound sign like £250 forTution

With default UTF-8 codepage I am geting a square symbol instead of £ sign.

I tried to set codepage to ISO-8859-1 and windows-1252 and other UTF code pages using MessageTransformBean's Transform.ContentType = text/xml;charset=ISO-8859-1

They are giving some other special characters for £ sign.

What is the correct code page we should use to read £ sign correctly into payload. Any suggestions are greatly appreciated.

Regards,

Ramesh

[stefan_grube · Accepted solution]

> I tried to set codepage to ISO-8859-1 and windows-1252 and other UTF code pages using MessageTransformBean's Transform.ContentType = text/xml;charset=ISO-8859-1

The Transform.ContentType is the target code page, so it does not make sense to use ISO-8859-1 here.

Put the code page in the processing part of the communication channel, use file type = text, file encoding = ISO-8859-1

[Former Member · Accepted solution]

Thanks for your reply Stefan.

As I am using Seeburger SFTP adapter rather than File dapter,I do not have "file encoding" option.

In this case, should we use some other standard module like TextCodepageConversionBean?

I tried to use TextCodepageConversionBean with Conversion.charset = ISO-8859-1.

With this also I am getting Square symbol instead of pound sign.

I am putting modules in this order 1)TextCodepageConversionBean 2) sftp ( Seeburger standard mandatory module) 3) Message TransoformBean ( to convert csv data into XML) 4) CallSAPAdapter

Any suggestions are really appreciated

Regards,

Ramesh

[stefan_grube · Accepted solution]

> I tried to use TextCodepageConversionBean with Conversion.charset = ISO-8859-1.

This is also the target codepage.

What might help is following:

add two entries of MessageTransormBean.

the first entry has

Transform.ContentType = text/plain;charset=ISO-8859-1

the second has

Transform.ContentType = text/xml;charset=UTF-8

and also the conversion

[Former Member · Accepted solution]

Thank you very much Stefan. That did the trick.

[Former Member · Accepted solution]

Thank you Stefan! That helped me too. I have only one additional remark.

My problem was that this solution didn’t work at the beginning because the line

Plain2XML Transform.Class com.sap.aii.messaging.adapter.Conversion

was always the first line. Every time I tried to put the ContentType line in the first row it becomes the second after saving.  So I’ve done the following trick. I added the MessageTransformBean twice with the names Plain2XML_Step1 and Plain2XML_Step2 (in this order). In the module configuration part I added the following three lines:

Plain2XML_Step1 Transform.ContentType text/plain;charset=iso-8859-1

Plain2XML_Step2 Transform.Class com.sap.aii.messaging.adapter.Conversion

Plain2XML_Step2 Transform.ContentType text/xml;charset=utf-8