800.000 tokens????

More
4 years 1 month ago #93115 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...

Please Log in to join the conversation.

More
4 years 4 weeks ago #93166 by Fred01
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

Please Log in to join the conversation.

More
4 years 4 weeks ago #93169 by Serafim
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...

Please Log in to join the conversation.

More
4 years 4 weeks ago #93174 by kris01
Maybe you can split up to file or use BigDump ( www.ozerov.de/bigdump/ ) directly to SQL.
Should this work for you?

Please Log in to join the conversation.

More
4 years 4 weeks ago #93180 by holch
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'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in to join the conversation.

More
4 years 4 weeks ago #93182 by holch
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'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in to join the conversation.