Text File Encoding

[Former Member]

Hello everybody,

I am running an interface in MII that processes csv files genereated by another system and then passes the contained data to the SAP QM Module. I am currently facing problems with specific german characters ä,ö,ü. I assume the problem is the encoding. I use a TextLoader Action Block to read the content of the csv file. Is there a possibility to define the used encoding or to do some conversion in the MII Workbench to receive the characters ä,ö,ü properly?

Kind Regards,

Matthias

[Former Member · Accepted solution]

Matthias,

where do you experience the problems? When reading the file into MII, or when receiving the data in SAP?

I had a similar problem, but the other way round. I received data from SAP with Umlaute in MII via RFC (MII 12.0, using UTF-8 in the connection MII to SAP). In MII, the Umlauts came as unreadable characters (I used trace and Text Saver to check). However, I could build a function which converts the signs back into "readable" characters. I just copied the unreadable characters and build a "translation" XML to be used in the function as I new the positions of each Umlaut in the RFC.

Maybe you can use this way in the other direction.

Michael

[Former Member · Accepted solution]

Michael,

the problem with the German Umlauten in the Message Listener is a bug in <=xMII 12.0 SP5. This bug is fixed

with xMII 12.0 SP6.

Regards

Pedro Iglesias

[Former Member · Accepted solution]

Hi Michael,

I had another look on this. The problem occurs already when I fetch the file from the subsystem server on the MII server. I use an FTP Input block to do this. Any idea how to handle Umlaute via FTP?

Thank you,

Matthias

[Former Member · Accepted solution]

Matthias,

what MII version do you use?

I have tested on a 12.0.2 system, FTP Input a file with Umlaut, stored it in MII (web://) and did a Text Load and Traced it. All characters have been displayed correctly.

Maybe its a problem with the Java version on the server?

Michael

[Former Member · Accepted solution]

Hello Michael,

We use Version 12.0.8 Build(24).

I've made a similar test on our environment. The subsystem server is a windows server while MII is running on linux servers. I've created a textfile containint "ä,ö,ü,ß" with different encodings (I used Notepad's "save as" options) on the windows server and transferred them via an FTP Input Action Block into the MII workbench (web://). These are my results:

ANSI file is not transferred correctly

Unicode file is not transferred correctly

UTF-8 file is transferred correctly

So a solution for my problem would be to do the csv export at the subsystem side using a UTF-8 encoding.

Matthias

[Former Member · Accepted solution]

Hello again,

I've opened an SAP OSS Call and will provide additional information as soon as available.

Matthias

[Former Member · Accepted solution]

A text File with Umlaute can be loaded properly using the HTTP Post Action Block since there you have the possibility to choose the encoding of the source file, see also Thread

This solved my initial problem.

Regards,

Matthias