Welcome to the LimeSurvey Community Forum

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

Cannot upload CSV file

  • RBIQA100
  • RBIQA100's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 9 months ago #201803 by RBIQA100
Cannot upload CSV file was created by RBIQA100
Please help it has been days now. I cannot upload the CSV file (I am using MacBook).
The message is:

Failed to create token entries
52 records in CSV
52 records met minimum requirements
0 records imported
Warnings
52 records with invalid email address removed

    I have attached my CSV file...not sure what is wrong with it...
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 9 months ago - 3 years 9 months ago #201806 by Joffm
Replied by Joffm on topic Cannot upload CSV file
There are quotes around each single line.
So each program will read this as one entry.

Meaning there is neither an entry "firstname" nor "lastname" nor "email",
but only one word "firstname;lastname;email"

Remove the quotes.

Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless
Last edit: 3 years 9 months ago by Joffm.
The following user(s) said Thank You: DenisChenu
The topic has been locked.
  • RBIQA100
  • RBIQA100's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 9 months ago #201807 by RBIQA100
Replied by RBIQA100 on topic Cannot upload CSV file
Thank you for the prompt response. I am sorry but I am a bit challenged when coming to understanding CSV. The quotes are the ; ?

e.g. derekbuchlerfrodo.dodo@gmail.com or
Derek Buchler frodo.dodo@gmail.com
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 9 months ago - 3 years 9 months ago #201809 by DenisChenu
Replied by DenisChenu on topic Cannot upload CSV file
quote == "

And : Use Libreoffic Calc

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: 3 years 9 months ago by DenisChenu.
The topic has been locked.
  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 9 months ago #201833 by tpartner
Replied by tpartner on topic Cannot upload CSV file
Create at least one token in the GUI, export the token list and edit the resulting CSV file in Libreoffice Calc (as Denis suggests).

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose