Open Hub with Foreign Character Set

[Former Member]

We have an Open Hub that exports customer master data.  While most of the customer information is entered in English, some is entered in Chinese.  My Open Hub exports junk data - ìœ ë‹ˆì˜¨í†µìƒ|서울특별시 - instead of the Chinese characters.  I need the English to export in English, and the Chinese to export in Chinese as the junk characters are of no use to the folks in China...

[former_member209895]

Hi Tracy,

     Where are you writing this data into ? A table or a file.. If its a file (notepad) then you might need to make use of a chinese fonts (may be install them):

http://superuser.com/questions/211378/how-to-display-chinese-characters-on-notepad

If its a table in the same system then it should display coz the data appears in your source infocube. But still you could go through the below for some help:

http://scn.sap.com/community/data-warehousing/blog/2012/04/23/chinese-characters-data-display-issue

http://scn.sap.com/thread/1392059

Hope this helps,

Regards,

  Manohar. D

[Former Member]

I had our Basis team update change the logon for the RFC connection to have no language - that didn't fix the issue completely.

The open hub is writing to a csv file - if I view the data through AL11 - I can see the Chinese Characters - when I get to Excel (or when our Pervasive server picks it up), it 's back to the 'garbage' characters.

I can export the master data to a spreadsheet through rsa1 and get the characters, but need the open hub to do this nightly.

Thanks!

[former_member209895]

Hi Tracy,

    Thats a good news. If on AL11 you are able to see the chinese characters as they are then it clearly indicates that the Open Hub is doing its job right and posting the values as they should be. Also if exporting master data to excel is also correct then SAP export is also working fine.

Please try to open the CSV as excel and notepad and check if values appear right:

If they do then we have successfully isolated the issue to CSV format, and we atleast have a direction on further research.

Hope this helps, Kindly try the suggested option and revert back.

Regards,

  Manohar. D

[Former Member]

Opening in Notepad or WordPad doesn't show the correct symbols either.  I can export as xml or txt and they appear correctly.  However, the txt file says it is fixed length - but it is not a true fixed length file and there are no options to change on the fixed length. We are now working on getting the xml to import correctly.