Strange, illegible fonts 
Author: Gabriel K.
Visited 1705,
Followers 1,
Shared 0
Hello,
when I manage to create a .csv file and want to upload it to the shopping cart, I see plenty of illegible fonts instead of letters with diacritics. I use czech, slovak and hungarian languages. :-l
Posted on the
... in the CSV file saving options select the character encoding in UTF-8 ...
(IT) ... nelle opzioni di salvataggio del file CSV selezionare la codifica dei caratteri in UTF-8 ...
.
ciao
.
Hello Gabriel ,
try try to follow KolAsim's advice and let me know.
Author
Hello, Riccardo,
I tried to make so in Excel 2010 and LibreOffice 6.0 too. I managed to create a .csv file (attached) in MS Excel, everything seems O.K., but after uploading it to WebSite X5 13 Pro, the text changes. :-(
Hello Gabriel
Try this - it is converted to UTF 8.
But some of the characters seemed to be a bit funny - so maybe it was wrong already in the file.
BUT - try this and please tell if it is OK.
Then I tell what to do.
If it is not OK then we must try something else.
Hello again Gabriel
Look here : https://support.assetbank.co.uk/hc/en-gb/articles/115005205928-How-to-save-a-tab-delimited-UTF-8-encoded-file-in-Excel
If you have a file that is a csv-file but is in the Unicode and not the Unicode(UTF-8), then you could use
Notepad++ to convert from Ansi to Unicode(UTF-8)
In excel it looks like this when using save as in 2010 :
Please tell us the outcome.
Author
Hello, John, KolAsim and Riccardo.
I followed all your advices step by step, tried all methods, but it's even worse. :-| Maybe, I'll have to write it again...
Hello, your file NEW.CSV ... seems to me regular ...Waiting for the STAFF and other experts, I can not try in the program, which I do not have, but you try to import this same CSV, lightened, reduced to 11 lines, attached here ...
... when you import the CSV into the Calculation Sheet (I use OO.o.Calc), you must use only the (;) as the only seed separator field, and you should delete the first column "ID", because it is WebSiteX5 that assigns the various IDs ...
... when you save the CSV file, (before importing it), you must always select the (;) to separate the fields, and select the UTF-8 character encoding ...
.
Hello
.
(IT) - Ciao, il tuo file NEW.CSV ... a me sembra regolare...
In attesa dello STAFF ed altri esperti, io non posso provare nel programma, che non ho, ma prova tu ad importare questo stesso tuo CSV, alleggerito, ridotto ad 11 righe, qui in allegato...
... quando importi il CSV nel Foglio di Calcolo (io uso OO.o.Calc), devi usare solo il (;) come unico seme separatore di campo, e dovresti eliminare la prima colonna "ID", perchè è WebSiteX5 che assegna i vari ID...
... quando poi salvi il file CSV, (prima di importarlo), devi selezionare sempre il (;) per separare i campi, e selezionare la codifica caratteri UTF-8...
.
ciao
.
Author
Hello, KolAsim,
your file is PERFECT!
It was loaded correctly.
It seems to me that this weekend I will have no time to "play" with the original file, maybe next week.
But MANY THANKS to you, and wish you a nice weekend.
Gabriel.
... OK ...
... gute Arbeit ... 