Special Characters missing File 2 File Scenario

[former_member200386]

Dear Experts,

I am facing a issue in file 2 file scenario. Interface is working fine without any issues but some special p characters are missing at receiver end. The output files are coming like below example.

Example: in the file

The correct first name is Benoit with a "^" over the i
The userid is OCHSB5206

In the file it appears as: ;Benoît

~ is coming instaed of ^..

Please suggest me how can i solve this issue.

Thanks & Regards,

Pavan

[nils_buerckel]

Hi Pavan,

please have a look at SAP note 1150217.

You can e.g. copy and paste "Benoît" into a txt file and open it with the notepad editor in Windows 7.0. The editor detects the encoding correctly and shows "Benoît". This means your result is correct (if you want to have it based on UTF-8), but the tool used to display the data expects a different encoding.

Best regards,

Nils Buerckel

[former_member556603]

Hi Pavan,

Please use Encoding Type: CP1252. Also please find the below link:

http://msdn.microsoft.com/en-us/library/cc195054.aspx

http://www.cp1252.com/

Thanks,

Maruthi Satya Kumar

[former_member200386]

Hi Maruthi,

Thanks for the quick response. I tried to find the root cause for this prblm.

I opened the source file from my sender file directory file name is Benoît

and i downloaded the SXMB_MONI Inbound payload and checked  it appears as Benoît.

it means problem is in the PI only. 

I checked your suggested sites.

Whcih end i need to use this encoding type?

Sender side comm chnanel (File NFS) or receiver SFTP channel end?

If at receievr end what will be syntax?

text/plain;charset=CP1252? is this correct?

Thanks & Regards,

Pavan

[former_member556603]

Hi Pavan,

Receiver File Encode : cp1252

Thanks,

Maruthi Satya Kumar

[former_member200386]

Hi Maruthi,

Thanks for the response. I am using SFTP adapter with FCC at receiver and. in module configuration

currently i am  using  this parameter for character encoding

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

you want me to change this to

Transform.ContentType  as text/plain;charset=cp1252

i got this mail from end user regarding this error.

Thanks Pavan,

We have had our operations group remove the pgp encryption from the file being sent to the daily upload via ftp and we see that the data appears to be corrupt at that point however it has not been imported yet using the Unicode (UTC-8). Engineering continues to investigate.

In this mail they are stating that they are using UTC-8 encoding. will cp1252 encoding will solve my prblm?

Please suggest me

Thanks & Regards,

Pavan

[former_member556603]

Hi Pavan,

Yes, Use the given encoding in your development system and test it.

Thanks,

Maruthi Satya Kumar

[former_member200386]

Hi Maruthi,

Thanks for the response, I have changed encoding type as cp1252 as you suggested , once i got the feed back from the third party, i'll let you know .

Thanks,

Pavan

[former_member200386]

Hi Maruti,

I gotr feed back from third party team, still same error persists. I used encoding type cp1252 in the receiver SFTP channel.

Is it possible to solve this issue using UDF?

Thanks & Regards,

Pavan

[Former Member]

Hi Pavan,

If the encoding do not help you, we can try with a simple XSLT mapping which may resolve the issue.

Kindly test using the below mapping .

<xsl:stylesheet version="1.0"

xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:output method="xml" encoding="ISO-8859-1"/>

<xsl:template match="/">

<xsl:copy-of select="*" />

</xsl:template>

</xsl:stylesheet>

Thanks,

Swetha.

[gagandeep_batra]

hi pavan,

Can you check without pgp encryption module also.

Regards

Gagan

[iaki_vila]

Hi Pavan,

Do you need any mapping transformation?, if you dont need it you can pass file to file without ESR development, in binary mode, and in this way you will not do any internal transformation that could affect to the encoding.

Regards,

[former_member200386]

Hi Amit,

My scenario is file(FCC) 2 SFTP(FCC) with PGP encryption. As you suggested i changed encoding type to

text/plain;charset=ISO-8859-1. in SFTP comm channel parameter.

I will check with the end user and update you.

Thanks & Regards,

Pavan

[former_member200386]

Hi Amit,

I have changed Encoding type to ISO-8859-1.Still the same error persists.

Actual file Name: Benoît

Error :In the output  file it appears as: ;Benoît

Please suggest me how can solve this issue.

Thanks & Regards,

Pavan

[Former Member]

Hello,

I think u have to use ISO-8859-1 encoding for these french characters.

Thanks

Amit Srivastava

[former_member200386]

Hi Amit,

Thanks for the quick response. As per my requirement we need to use UTF-8 encoding only.

Thanks & Regards,

Pavan

[Former Member]

Hello,

I had also faced the same encoding problem in my current project where french characters were getting distorted and eventually i used ISO-8859-1 encoding to overcome this issue.

BTW, what's ur scenario - NFS -> FTP or vice versa?

Thanks

Amit Srivastava