Welcome, Guest
Username: Password: Remember me

TOPIC: 800.000 tokens????

800.000 tokens???? 1 year 7 months ago #93115

  • Serafim
  • Serafim's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 114
  • Thank you received: 2
  • Karma: 2
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???? 1 year 7 months ago #93166

  • Fred
  • Fred's Avatar
  • OFFLINE
  • Gold Lime
  • Posts: 163
  • 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???? 1 year 7 months ago #93169

  • Serafim
  • Serafim's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 114
  • Thank you received: 2
  • Karma: 2
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???? 1 year 7 months 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???? 1 year 7 months ago #93180

  • holch
  • holch's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 2852
  • Thank you received: 359
  • Karma: 124
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???? 1 year 7 months ago #93182

  • holch
  • holch's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 2852
  • Thank you received: 359
  • Karma: 124
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.
Moderators: ITEd
Time to create page: 0.123 seconds
Donation Image