Loading special characters while using process chain

[Former Member]

Hi experts,

I face something strange.

While maintaining Dimension Members using web interface, there is no problem; and descriptions well appear

Nevertheless, while I'm using the standard process chain to load members from flat file, system converts french é, à, ù etc... with special characters, like this.

does someone already met that king of thing ?

any idea to solve this ?

tks a lot :

Olivia.

[former_member186338 · Accepted solution]

Hi Olivia,

You present the screenshot of the import file preview (can be some incorrect symbols). But what is the result of the import in the dimension administration?

Vadim

[Former Member · Accepted solution]

Hi Vadim,

Tks for your prompt reply

actually, results remains the same as the screen shot bellow can show it :

Tks a lot,

Olivia

[former_member186338 · Accepted solution]

Currently can only confirm the same:

Have to be: AshanАшан (in Russian)

Vadim

[Former Member · Accepted solution]

Ok Tks Vadim

I'm going to open an OSS Message.

Keep the forum updated

[former_member186338 · Accepted solution]

Ups, the solution is easy - just save the text file in the notepad as unicode!

Import will be correct!

Vadim

[Former Member · Accepted solution]

Good Idea.

I've just tried it.

but, while using UNICODE, that's mean I use TAB in transformation file, which seems correct to me.

But, System make somthing strange when i m trying to validate my data file :

[former_member186338 · Accepted solution]

How tab is related to unicode file format??? Tested with comma and it was fine.

[Former Member · Accepted solution]

mm;

I forgot something, or...

while i save in Unicode, i do not have COMA in my file, but TAB.

I don't understand where I'm wrong ?

I use this extension of excel :

[former_member186338 · Accepted solution]

To test - save as non unicode with comma then open text file in notepad and save as unicode. Test

[Former Member · Accepted solution]

Well, when im trying to save Excel to non Unicode to coma, i only have the choice of ";"

when i m trying to save txt from Notepad, I have these choice :

[former_member186338 · Accepted solution]

In Excel save it:

Rename the saved file from csv to txt

then open it in notepad:

Replace all ";" to ","

Save it as unicode:

Sorry for Russian notepad

Юникод = Unicode

Vadim

P.S. Tomorrow I will test TAB separated import... But looks like your Excel extension is not working properly...

[former_member186338 · Accepted solution]

P.S. And instead of replacing ";" by "," you can simply use:

DELIMITER=;

in transformation file!

[Former Member · Accepted solution]

Ok Great , Thanks a lot Vadim,

This save me