Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Displaying Emojis from imported files

  • ferdeng
  • ferdeng's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 3 months ago #179194 by ferdeng
Displaying Emojis from imported files was created 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!
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 3 months ago #179217 by DenisChenu
Replied by DenisChenu on topic Displaying Emojis from imported files
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 , plugin development .
I don't answer to private message.
The topic has been locked.
  • ferdeng
  • ferdeng's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 3 months ago #179218 by ferdeng
Replied by ferdeng on topic Displaying Emojis from imported files
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).
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 3 months ago #179233 by DenisChenu
Replied by DenisChenu on topic Displaying Emojis from imported files
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 , plugin development .
I don't answer to private message.
The topic has been locked.
  • ferdeng
  • ferdeng's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 3 months ago #179239 by ferdeng
Replied by ferdeng on topic Displaying Emojis from imported files
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.
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 3 months ago - 5 years 3 months ago #179240 by DenisChenu
Replied by DenisChenu on topic Displaying Emojis from imported files
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 , plugin development .
I don't answer to private message.
Last edit: 5 years 3 months ago by DenisChenu.
The topic has been locked.
  • ferdeng
  • ferdeng's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 3 months ago #179241 by ferdeng
Replied by ferdeng on topic Displaying Emojis from imported files
So you exported as TSV, edited the question (added an emoji) with Libre, saved as txt again, imported and it's working?
The topic has been locked.
  • ferdeng
  • ferdeng's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 3 months ago #179269 by ferdeng
Replied by ferdeng on topic Displaying Emojis from imported files
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.
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 3 months ago - 5 years 3 months ago #179281 by DenisChenu
Replied by DenisChenu on topic Displaying Emojis from imported files

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 , plugin development .
I don't answer to private message.
Last edit: 5 years 3 months ago by DenisChenu.
The topic has been locked.
  • ferdeng
  • ferdeng's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 3 months ago #179324 by ferdeng
Replied by ferdeng on topic Displaying Emojis from imported files
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...
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 3 months ago #179333 by DenisChenu
Replied by DenisChenu on topic Displaying Emojis from imported files
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 , plugin development .
I don't answer to private message.
The topic has been locked.
  • ferdeng
  • ferdeng's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 3 months ago #179362 by ferdeng
Replied by ferdeng on topic Displaying Emojis from imported files
Of course!
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose