The LimeSurvey Fund-Raiser 2012 is complete. Thank you for donating a total of 25,000 USD!     List of donors »
Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username?
  • Page:
  • 1

TOPIC: 800.000 tokens????

800.000 tokens???? 2 months 2 weeks ago #93115

  • Serafim
  • Serafim's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 80
  • Karma: 1
Hi there, how many tokens can we insert? I have a client database of 800.000 clients, how do I insert this as tokens? And there´s the other problem of any excel file as a maximum of lines...
The administrator has disabled public write access.

800.000 tokens???? 2 months 2 weeks ago #93166

  • Fred
  • Fred's Avatar
  • OFFLINE
  • Gold Donor
  • Posts: 162
  • Thank you received: 5
  • Karma: 3
That sounds like a lot of tokens. You can just import a CSV file, no?

Would you have to email 800,000 invitations also?

Excel 2010 can have a maximum of 1,048,576 rows by 16,384 columns
The administrator has disabled public write access.

800.000 tokens???? 2 months 2 weeks ago #93169

  • Serafim
  • Serafim's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 80
  • Karma: 1
Well, 800.000 is a way to say, an example, but it could reach that number, but someone knows the maximum number of tokens in limesurvey?

And there's one other problem I found, the server may have a maximum of size file to upload, in my case bigger than 2mb was a problem, but it as been solved. But limesurvey doesn't say it's too big, it just says it doesn't find the file...
The administrator has disabled public write access.

800.000 tokens???? 2 months 2 weeks ago #93174

  • kris
  • kris's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 7
  • Karma: 0
Maybe you can split up to file or use BigDump (www.ozerov.de/bigdump/) directly to SQL.
Should this work for you?
The administrator has disabled public write access.

800.000 tokens???? 2 months 2 weeks ago #93180

  • holch
  • holch's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 1972
  • Thank you received: 156
  • Karma: 80
Where is the problem? Create dummy token information and try to upload it. You'll see what the result is.

The limit of LS should be limit of your MySQL database. And of course the maximum file size that your server allows to upload.
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds
If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.

800.000 tokens???? 2 months 2 weeks ago #93182

  • holch
  • holch's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 1972
  • Thank you received: 156
  • Karma: 80
Just created a file with 300.000 tokens (2 columns - token and email).

XLSX file was about 3MB, csv file was 5,61 MB. So you can do an estimate for the size.
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds
If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.
  • Page:
  • 1
Moderators: DenisChenu, ITEd
Time to create page: 0.202 seconds
Donation Image