I’m working with an encrypted XLS form in KoboCollect, and use ODK Briefcase for decrpytion. For MPC questions all data decrypts perfectly. The only problem is with the text responses, as Arabic text is still gibberish after decryption:
Dear Yanokwa,
Thank you very much! It was indeed the problem of UTF-8. It is solved now by importing the CSV data in Excel, while ensuring UTF-8 unicode is selected in the 'file origin' drop-down.
Apologies for commenting on an old post, but I was wondering if you are also plagued by line breaks in Arabic texts when importing the data. I’ve been fixing these line breaks manually, but I would very much like to find a way to automate this process, as it’s quite time consuming.
Hi @pax_hossain
We're glad you're here. When you get a chance, please introduce yourself on this forum thread. I'd also encourage you to add a real picture as your avatar because it helps build community!
could you provide more details?
What exactly are you doing?
What versions of our tools do you use?
Maybe you could attach your form as a sample?
Thanks for your reply, @Grzesiek2010! I was hoping it was a common issue that did not require much additional explanation. As this does not seem to be the case, I created a new topic. I hope I have answered your questions there!