Import descriptions including special characters from flat file

[gunesbt]

Hi all,

I want to upload employee master data from file in BPC 10.0 .Very naturally employee descriptions include special chars like ü,ö etc. Those chars are accepted if we input them manually in web interface but when we upload data from excel, it is shown in web interface strangely.I think the problem starts immediately after we upload data to server from file.Because after we upload data to server, we preview the file for descriptions,but we see that the characters are shown strangely which are the same in web interface.

I want to know why it is accepted if we input descriptions manually in web but not if we uplaod from flat file in excell?Is there a way to import descriptions including special chars from flat file?

Note that I tried both import master data from flat file and import descriptions from flat file packages seperately and I succeeded to import descriptions for both but I can not see the characters in web properly.

[former_member186338 · Accepted solution]

Can you provide details?

[gunesbt · Accepted solution]

Hi Vadim,

Could you write the detail you need if you need more?

Descriptions are shown in web like this : ( if I preview the file after I upload to server, it is shown the same)

���DEM �ZDEM�R EVREN

my csv file :

ID	DESC
9999	ÖZDEMİR EVREN

Transformation file is just two lines:

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ;

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=

ROUNDAMOUNT=

*MAPPING

ID=ID

EVDESCRIPTION=DESC

LANGU=*str(TR)

package name for this transformation file : import description

[former_member186338 · Accepted solution]

Looks like you are using ANSI encoded text file. Try Unicode.

[gunesbt · Accepted solution]

That's exactIy the case.I was surprised because my file was opened properly by notepad.

Thanks a lot.

[GuglielmoP]

Hello,

currently i have the same issue with special characters in Emigall.

how you solve this problem?

[former_member186338]

Ask a new question!!!