800.000 tokens????

More
4 years 3 months ago #93115 by Serafim
Serafim created the topic: 800.000 tokens????
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 2 months ago #93166 by Fred01
Fred01 replied the 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

Please Log in to join the conversation.

More
4 years 2 months ago #93169 by Serafim
Serafim replied the 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...

Please Log in to join the conversation.

More
4 years 2 months ago #93174 by kris01
kris01 replied the 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?

Please Log in to join the conversation.

More
4 years 2 months ago #93180 by holch
holch replied the 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'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 2 months ago #93182 by holch
holch replied the 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'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.

Start now!

Just create your account and start using Limesurvey today.

Register now