Willkommen, Gast
Benutzername: Passwort: Angemeldet bleiben:

THEMA: 800.000 tokens????

800.000 tokens???? 1 Jahr 6 Monate her #93115

  • Serafim
  • Serafims Avatar
  • OFFLINE
  • Expert Lime
  • Beiträge: 114
  • Dank erhalten: 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...
Der Administrator hat öffentliche Schreibrechte deaktiviert.

800.000 tokens???? 1 Jahr 6 Monate her #93166

  • Fred
  • Freds Avatar
  • OFFLINE
  • Gold Lime
  • Beiträge: 163
  • Dank erhalten: 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
Der Administrator hat öffentliche Schreibrechte deaktiviert.

800.000 tokens???? 1 Jahr 6 Monate her #93169

  • Serafim
  • Serafims Avatar
  • OFFLINE
  • Expert Lime
  • Beiträge: 114
  • Dank erhalten: 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...
Der Administrator hat öffentliche Schreibrechte deaktiviert.

800.000 tokens???? 1 Jahr 6 Monate her #93174

  • kris
  • kriss Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 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?
Der Administrator hat öffentliche Schreibrechte deaktiviert.

800.000 tokens???? 1 Jahr 6 Monate her #93180

  • holch
  • holchs Avatar
  • OFFLINE
  • LimeSurvey Team
  • Beiträge: 2643
  • Dank erhalten: 313
  • Karma: 115
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!
Der Administrator hat öffentliche Schreibrechte deaktiviert.

800.000 tokens???? 1 Jahr 6 Monate her #93182

  • holch
  • holchs Avatar
  • OFFLINE
  • LimeSurvey Team
  • Beiträge: 2643
  • Dank erhalten: 313
  • Karma: 115
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!
Der Administrator hat öffentliche Schreibrechte deaktiviert.
Moderatoren: ITEd
Ladezeit der Seite: 0.176 Sekunden
Donation Image