Import CSV problem with Greek characters
hi, i’m importing questions without problem using CSV file (only five questions just for test).
The problem is that i cannot import questions or answers if one of those is on Greek language. If the question or answer contains Greek characters nothing importing.
Thanks for the support.
Hi makis,
would you be able to provide the contents of your CSV?
Right now my best guess is that the issue is some UTF8 character encoding issue on your site, but it would be very useful to see the real data so I can try and recreate on my end as well.
the contents of csv file…
MyQuiz_001,Greek Ελληνικά,AAA,BBB,CCC,DDD,EEE,FFF,,,,,2
MyQuiz_001,Ελλάδα,answer1,answer2,answer3,answer4,,,,,,,1
MyQuiz_001,This is the third question,A,B,C,D,E,F,,,,,2
MyQuiz_001,This is the fourth question,Αλφα,Βήτα,Δελτα,Έπσιλον,Ζήτα,Θήτα,,,,,4
I just want to start by apologizing for the late response here.
I’m still looking into this, but hope to have a working solution for you tomorrow.
Hi makis,
Unfortunately, I’ve been unable to replicate this issue on my own end, which means that the issue is either the file itself, or something about your server configuration.
Copy/pasting exactly what you sent into a text editor and saving as a CSV allowed me to upload and import without issue.
When you try to upload, do you get any error messages? What about within the browser console (F12 on your keyboard).
What happens if you, for example, try to load the file in MS Excel, or Google Sheets?
Right now, my best guess is that one of two things is happening for you.
- Improperly formatted CSV.
I can verify that the contents of your CSV are accurate, but perhaps something about the way the file is saved is the issue. Try opening/creating your file into Google Sheets and then downloading (under the file menu) as a CSV. You can do the same in Excel as well if you prefer.
- Your server if rejecting the file and or contents.
For this, take a look at any security plugins you may have installed and see if anything shows up in the logs regarding your file. You can also take a look at the Documentation page I have a problem with the CSV importer section.
In there, I outline some possible things to look at.
thanks for the answer.
When i try to upload, i don’t get any error messages, but the Quiz is empty.
I’m trying with Google Sheets….the file contains unreadable character (where there was the Greek characters).
Can you give me the file that you use without problems?
Sure. Here is the exact file that I used: https://file.io/3huyg39Daej7
The error that you are getting sounds like an encoding error. When you saved the file, the encoding it was saved as did not have compatibility with those characters. The standard character set is UTF8
Everything is OK! with the downloaded file.
Respond to thread
This thread has been closed / marked as resolved.
You can reply to this thread, but it might be better to start a new thread if you need help.
You can also upload images to imgur and paste the links here. Just make sure that your images don't include any sensitive information.
Submit