German umlauts :Sender File Adapter

Hi,

I am trying to configure Sender File adapter,but it is not working properly for German umlauts.

I have tried encoding UTF-8, UTF-16, ISO-8859-1,ISO-8859-2, ISO-8859-5 but none of them are working.

Can anyone please help me out in this.

Thanks a lot.

Regards,

Shweta

SAP Managed Tags:
SAP Process Integration

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (2)

First of all you have to figure out, which encoding the file has.

Open the file with Internet Explorer. Choose View -> encoding from Menu and choose different encodings, until the Umlauts are displayed correctly.

Regards

Stefan

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Stefan,

This was a good test.I did the same and found that file looks perfect with encoding UTF-8.

But I had already tried this and it didn't work.

Kindly let me know if this is fine:

1) File type Text

2) Encoding UTF-8

3)Transfer Mode Binary(I tried text too)

4) Using File type and encoding in ASMA (I tried both-use ASMA and not using the same)

5) Do I need to add any modules for encoding too?

Kindly let me know.

Thanks a lot for your help.

Regards,

Shweta

When your file is UTF-8, then I cannot understand where I could have any issue at all. At what place do you see wrong data? In SXMB_MONI? Or at receiver side?

Regards

Stefan

Hi Stefan,

In SXMB_MONI,if I check the payload in Inbound Message,there itself ,I can see that the umlauts have been converted to junk characters.As a result,the created attachment(csv) is also having the same content with these junk characters instead of umlauts.

Hence,this is the problem with file adapter which sends incorrect data to mail adapter and hence resulting CSV also has this incorrect data.

I hope I could explain it in a better way now.

Thanks.

Regards,

Shweta

A plain text file will displayed in ANSI by default. This is a Windows behaviour.

When you see characters like this: Åu203A

then you see UTF-8 characters displayed as ANSI.

So your file is correct, open it with Internet Explorer and check the encoding there.

Regards

Stefan

Hi Stefan,

Sorry if I am not able to understand.

The result is a csv file which has invalid characters.

I can see the contents of input file in Internet explorer with UTF-8 encoding correctly.

But I need to know the settings in File adapter so that the file is converted correctly with umlauts.

Thanks.

Regards,

Shweta

Have you watched the resulting csv fiel with Internet explorer as well?

Which encoding seems to be accurate?

Hi Stefan,

When I open the CSV file with Internet Explorer,I can't see any option for encoding.

Also,the content is incorrect(with junk characters).

Thanks.

Regards,

Shweta

How do the junk characters look like? What parameters have you put into the channel?

Hi Stefan,

Mörlen gets converted to MÃu0192Â¶rlen.

I am using

1) File type Text

2) Encoding UTF-8

3)Transfer Mode Binary(I tried text too)

4) Using File type and encoding in ASMA (I tried both-use ASMA and not using the same)

Is it fine or do I need to add some modules,I tried using MessageTransformBean with ContentType = text/plain;charset="UTF-8" as well as "ISO-8859-1"

Thanks.

Regards,

Shweta

Shewata,

Check what is the char set it is taking while forming CSV file. go to Messaging system of adapter and check for mail adapter and see the detailedmessage and check the content type and char set used there

if it is different try to change that char set to your desired one. Just give a try

Rajesh

Hi Rajesh,

Thanks for the reply,but the problem lies at File adapter only as I cannot see correct characters in payload on Inbound message in SXI_MONITOR.

The same is passed to mail adapter.

Regards,

Shweta

it happened same for me that i was not able too see data in middleware but target file was as expected.

so i just wanna try this.(not sure in this case may be...i mentioned just a try)

Rajesh

Hi Shweta,

Looking at your thread, i simulated the same scenario.

tried to read the germna umlauts with the sender file adapter. Got exactly the same problem you described.

Solved the problem by changing the "file type" under the processing tab to "binary".!

the file is still in the .txt format on the directory.

all the best

Raghu

Edited by: Raghu KB on Mar 18, 2009 8:39 PM

Hi Rajesh,

I tried giving charset in module conf in Mail adapter.

Then in payload of Inbound message and Request Message mapping,it says "XML page has an error"

Regards,

Shweta

Hi,

Thanks a lot.

I tried file type binary in sender file adapter,but it still didnt work for me.

Can you please confirm that you used:

ASMA(Adapter Specific Message Attributes) if yes,then what should i select

Transfer mode

Any modules did u use?

Regards,

Shweta

I have not used ASMA nor any modules. i have done basic configuration of sender file adapter..

my file contains the charectars ÄÖÜäöüéèà

with the file type text, i got the charectars in the inbound message: Ãu201EÃu2013Ãu0153Ã¤Ã¶Ã¼Ã©Ã¨Ã

i guess, this is what you are facing.

after changing the file type to binary .. the prob is solved...

lemme know ur result

Edited by: Raghu KB on Mar 18, 2009 8:45 PM

> 1) File type Text

> 2) Encoding UTF-8

> 3)Transfer Mode Binary(I tried text too)

Both should be fine.

> 4) Using File type and encoding in ASMA (I tried both-use ASMA and not using the same)

This is useless, as this does not influence the payload.

Is this a plain text file? Or is it XML, HTML, Excel, ... ?

Hi,

Sorry,I did the same

but it doesnt work for me.

Regards,

Shweta

Hi Stefan,

But this setting doesn't work:

This is a text file ex- abc(without any extension) saved on R/3 server.

17.03.2009;0004485908;4800042113;AG-HMC151E;1,000;ST;31.03.2009;Bechtle IT-XYZ;ABC. 114;ABC-Mörlen;DE;61239;;000010;00010

Do I need to use a module?

Is it a problem with File adapter or mail adapter?

Thanks.

Regards,

Shweta

Edited by: Shweta Walaskar on Mar 18, 2009 4:55 PM

So your scenario is: R/3 -> File -> PI -> Mail?

I think the issue is in the mail adapter, specially in the mail receiver client.

You could try to add following module to the Mail adapter:

AF_Modules/MessageTransformBean Local Enterprise Bean transform

transform Transform.Contenttype text/plain;charset="UTF-8"

Regards

Stefan

Hi Stefan,

I have already added this module exactly in the same way.

But can you please confirm the sequence

Module :

localejbs/AF_Modules/PayloadSwapBean Local Enterprise Bean swap

localejbs/AF_Modules/MessageTransformBean Local Enterprise Bean Transform

Transform.ContentType text/plain;charset="UTF-8"

Transform.ContentDisposition attachment;filename="ABC.csv"

Also,I noticed one thing

The content is corrupted in SXI_MONITOR but it is correct in payload of File as well as Mail adapter in Message Monitor(RWB)

Thanks.

Regards,

Shweta

Do you have an attachment in the message? You said, that you have one file.

The payload is not corrupt in SXI_MONITOR, it is a display issue.

Hi Stefan,

Yes,The input file is placed on R/3 and is picked up by File Adapter.

I get a CSV file as an attachment to the mail which contains corrupted data.

Regards,

Shweta

I do not talk about mail attachment, I want to know if you have 2 payloads in SXI_MONITOR, as you use the PayloadSwapBean.

Hi Stefan,

Sorry for the confusion.

No,I have one payload only in SXI_MONITOR.

Thanks.

Regards,

Shweta

So do not use the PayloadSwapBean, use the MessageTransformBean only once. Use the charset which the receiver of the mail expects. If you use UTF-8, make sure that the receiver of the mail can handle UTF-8, otherwise use another charset

Regards

Stefan

Hi Stefan,

Thanks.I'll try this and let you know.

But how do we know the charset which the mail receiver expects so that I set the same in my receiver CC.

Regards,

Shweta

By asking?

This should be part of the scenario specification.

Well,I have removed PayloadSwapBean now

still getting same results.

Any clue to find the charset of mail adapter?

Regards,

Shweta

There is no charset in mail adapter. You have to use the MessageTransformBean to set the correct encoding with the parameter ContentType.

But the question is not, what you see when you open the file with an editor, the question is, which encoding is used.

You could try

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

Let me know what you see then.

Hi Stefan,

I have tried charset="ISO-8859-1" also and got the same results.

I have opened the input file with Internet Explorer and checked the encoding(UTF-8) thats what I told you before.

But when I try to open the CSV attachment in IE,I cant see any option for encoding.

Regards,

Shweta

rename the csv file to .txt and try again.

Hi Stefan,

I did the same and now I can't see the correct characters by selecting any of the encoding options available in IE for this file.

Regards,

Shweta

or does this mean,my charset setting in receiver mail adapter isn't working

The problem is that the MessageTransformBean assumes that the incoming file is in ISO-8859-1 and tries to convert it to UTF-8, so you cannot use the MessageTransformBean here.

What happens, when you omit that?

Hi Stefan,

If I omit that too,where would I specify the payload as mail attachment,content type and file name?

Regards,

Shweta

Could you first check, if the issue is here, and discuss anything else later?

Try:

Transform.ContentType text/plain

no charset

Hi Stefan,

tried.same results

Doesnt work as well

Regards,

Shweta

Hi Stefan,

If I remove MessageTransformBean too,then I get payloadxxxx.xml file as an attachment.

The content looks like:

The XML page cannot be displayed

Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later.

Invalid at the top level of the document. Error processing resource 'file:///C:/Documents and Settings/Administrator/Deskto...

17.03.2009;sssssssss;aaaaa;12345;1,000;ST;31.03.2009;XYZ;ABC;Ober-Mörlen;DE;rrrrr

Now the encoding is correct.

The issue is the MessageTransformBean.

btw: Which XI version and SP do you use?

XI3.0 SP17

Regards,

Shweta

So I think note 960501 is already implemented in your system (SPS 2 for SP17)

You should open an OSS ticket for this, as this behaviour is not correct.

Regards

Stefan

Hi Stefan,

Yes,this would be better as we have tried all possible options.

I will do this and update you regarding this issue.

Thanks a lot for your help and support.

Regards,

Shweta

Hi,

Now one more test, in my receiver mail adapter,I changed the file name from abc.csv to abc.txt

and it works fine.

So the problem is only with csv.Any clue?

Thanks.

Regards,

Shweta

alas great it worked

Rajesh

No,but I need CSV not txt

and it doesnt work for CSV.

So I still have the problem

Can anyone please suggest anything for this?

It would be a great help

Thanks.

I have done some tests in my system and it works fine. I recommend to apply the latest patch for your system, as SP17 is really old.

Regards

Stefan

Hi Stefan,

Thanks for the reply,I would suggest the same to them and have raised an OSS call too,but still haven't heard anything from SAP.

But as this was important to fix it on priority,so we have decided to use a workaround.

If I try to open the input file with Excel(after saving it as .csv ),I can see the same corrupted characters.

Hence ,I have advised them if it is possible for them to create the files in Unicode format so that it will be handled correctly by XI.

I understand,this is not the correct way and XI should be able to change the charset,but somehow this doesn't work in our system.

Thanks a lot for your kind help.

Regards,

Shweta

ISO-8859-1 should work.

make sure you choose the File type as TEXT option and give the encoding.

Else can you just try with binary and see if it works?

What is the exact error that you get?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Shabarish,

Thanks a lot for the reply.

I have done the same,using file type as text and encoding ISO-8859-1.

It doesnt give any error,but creates invalid characters for German umlauts like MÄu201AÅu203Arlen for Mörlen

The result is almost same(some other junk character) if I select file type as binary without providing encoding scheme.

What could be the solution then?I tried setting ASMA too (selecting File Type and File encoding) but still it doesnt work.

Kindly suggest.

Thanks again.

Regards,

Shweta

Give a try:-

Can u check whether Xi system is uni code compatible or not? Check the RFC destination for XI in SM 59 and there is a unicode option check all the tabs i dont remember the tab name.

chirag

Hi Chirag,

I have checked SM59.

Unicode option is checked.

Can you please let me know the configuration of File sender and mail receiver.

I have mentioned the current configuration in this thread.

Thanks.

Regards,

Shweta

Ask a Question

Top Q&A Solution Author

User

Count