Welcome to the LimeSurvey Community Forum

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

800.000 tokens????

  • Serafim
  • Serafim's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
11 years 1 month ago #93115 by Serafim
800.000 tokens???? was created by Serafim
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 topic has been locked.
More
11 years 3 weeks ago #93166 by Fred01
Replied by Fred01 on topic 800.000 tokens????
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 topic has been locked.
  • Serafim
  • Serafim's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
11 years 3 weeks ago #93169 by Serafim
Replied by Serafim on topic 800.000 tokens????
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 topic has been locked.
More
11 years 3 weeks ago #93174 by kris01
Replied by kris01 on topic 800.000 tokens????
Maybe you can split up to file or use BigDump ( www.ozerov.de/bigdump/ ) directly to SQL.
Should this work for you?
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
11 years 3 weeks ago #93180 by holch
Replied by holch on topic 800.000 tokens????
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.

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
11 years 3 weeks ago #93182 by holch
Replied by holch on topic 800.000 tokens????
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.

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose