Displaying Emojis from imported files

More
5 months 3 days ago #179194 by ferdeng
Dear all,

I have the following problem.

I exported my survey as txt, edited it and imported it again. Everything works great.

The only thing that doesn't work are emojis.
For example, my imported txt contains a grinning Emoji. I saved the txt encoded survey to be imported as UTF-8. Everything works after the import process, except for the emoji which is displayed as ????.

I also tried adding "<meta charset="UTF-8">" at the beginning of the question as a code, but that didn't change anything. Strangely, when I manually edit the question in LS and just paste the emoji, it's displayed correctly. So it seems that LS can display emojis, the problem must be with the import process.

How can I fix this?

Thanks in advance!

Please Log in or Create an account to join the conversation.

LimeSurvey Partners
More
5 months 3 days ago #179217 by DenisChenu
I'm sure you use excel, this is a broken tool : use LibreOffice calc : www.libreoffice.org/download/download/

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand .
An error happen ? Before make a new topic : remind the Debug mode .
The following user(s) said Thank You: LouisGac

Please Log in or Create an account to join the conversation.

More
5 months 3 days ago #179218 by ferdeng
Dear Denis,

thanks for your reply. Indeed, I first tried to do this with excel, but I didn't even manage to import one single question. That's why I already did everything in libre office. But don't get me wrong, the Emoji is also correctly display in Libre (as a Emoji, not as a codepoint). And even in the txt when I open it with the editor (still as the real emoji).

Please Log in or Create an account to join the conversation.

More
5 months 2 days ago #179233 by DenisChenu
But then : where it'sdiplay has not an emoji ?

I check myself : seems OK

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand .
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in or Create an account to join the conversation.

More
5 months 2 days ago #179239 by ferdeng
If it do it manually (by that I mean editing a question in Limesurvey directly), it works, yes.
If I import my survey from a txt document (and exported survey I manipulated to add more questions), everything except for the emojis works. I only get to see ???? instead of the emoji. I tried both encoding as ASCII and UFT 8.

Please Log in or Create an account to join the conversation.

More
5 months 2 days ago - 5 months 2 days ago #179240 by DenisChenu
When is say i check i
- Export as TSV
- Update with LibreOffice
- Save as TSV (UTF8, tab separator)
- Import

And it's OK

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand .
An error happen ? Before make a new topic : remind the Debug mode .
Last edit: 5 months 2 days ago by DenisChenu.

Please Log in or Create an account to join the conversation.

More
5 months 2 days ago #179241 by ferdeng
So you exported as TSV, edited the question (added an emoji) with Libre, saved as txt again, imported and it's working?

Please Log in or Create an account to join the conversation.

More
5 months 2 days ago #179269 by ferdeng
Even tried the following thing now: I imported the manipulated survey with emojis, they're not shown (only ????). They I exported this version again, edited with libre office (replaced ???? with the emoji), imported again to Limesurvey. But still, it's only displayed as ???? again.

Please Log in or Create an account to join the conversation.

More
5 months 1 day ago - 5 months 1 day ago #179281 by DenisChenu

ferdeng wrote: So you exported as TSV, edited the question (added an emoji) with Libre, saved as txt again, imported and it's working?

Yes



I add another emoji, save as utf8 : and it's OK



PS : another idea : linux rules !

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand .
An error happen ? Before make a new topic : remind the Debug mode .
Attachments:
Last edit: 5 months 1 day ago by DenisChenu.

Please Log in or Create an account to join the conversation.

More
5 months 1 day ago #179324 by ferdeng
Thanks for trying this! Are they also displayed correctly when you store them inse a question? And if you test the survey? I don't know what I could do differently...

Please Log in or Create an account to join the conversation.

More
5 months 13 hours ago #179333 by DenisChenu
Yes

Can you send me a sample (not working) tsv file ?
Here is mine

File Attachment:

File Name: limesurvey...3731.zip
File Size:3 KB

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand .
An error happen ? Before make a new topic : remind the Debug mode .
Attachments:

Please Log in or Create an account to join the conversation.

More
5 months 5 hours ago #179362 by ferdeng
Of course!
Attachments:

Please Log in or Create an account to join the conversation.

More
5 months 4 hours ago #179369 by DenisChenu
It's OK on my 2 server … (5.6 and 7.2 / linux)


Maybe related to server … maybe try to report the issue with all information

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand .
An error happen ? Before make a new topic : remind the Debug mode .
Attachments:

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!