search

DNNCommunity / DNN.Survey

MIT License
7 stars 8 forks source link

Export Survey Result To Csv In Persian Show unusual character #61

Closed behzadvahidpour closed 2 years ago

behzadvahidpour commented 3 years ago

Export Survey Result To Csv In Persian Show unusual character

Steps to reproduce the behavior:

  1. Add Survey with Answers in Persian Lag
  2. Try To export Result To CSV

Survey Survey_Results_1166_1400-02-27-022054.zip

MaiklT commented 3 years ago

As this is not really readable to me (and Persian characters are unusual in my culture, so I don't know which characters are unusual), I guess this is the behaviour that Excel always opens CSV files as ANSI encoded, but they are UTF-8 encoded when they come from the web.

Try the following: Open the CSV file with an editor, that is able to change the encoding (e.g. Notepad++), and change the encoding to ANSI. Then save the file, and try to open it with Excel again. That should do it.

MaiklT commented 2 years ago

As there was no answer to this in the last 6 months, I close this issue assuming that the answer above was correct.