[SOLVED] problem export csv with persian character

[samani]

hi...
i want export my list to csv but that cell has persian character incorrect rendering in Excel.
for example if my word in the cell is : ??? 2
then when i export to csv it show: ?????? 2 in the Excel.
i change unicode of my table and column but not different...
how to solve it?

 

[samani]

I find new thing, if i open that csv file with Notepad, my character is ok and if i add one Space at the end of file and save it and then open with excel it is correct loading persian character.
what i your advise for solve it?
is fabrik support OpenDocument Spreadsheet export instead CSV?

 

[troester]

In list settings/Publishing/CSV
you can select "CSV" or "Excel CSV"
you can set the file encoding

Try which combination is working for your characters.

 

[samani]

thank you troester and i do all you say but the problem not resolved...

 

[troester]

A field with ??? is exported correctly on my site with ExcelCSV=YES and File encoding= UTF8, file opening directly in Excel.

 

[samani]

you say right ... i have a mistake and solved but when i use ExcelCSV=YES , then column is not correct and each column separator is ";"
how can i set up to show each column in excel corresponding to database? such as when we set CSV File format=CSV .

 

[samani]

thank you ....
i find that ... i must use , in delimetter field in the setting page for csv