Anonymous Login
2017-01-24 03:58 CET

View Issue Details Jump to Notes ] Related Changesets ]
IDProjectCategoryView StatusLast Update
08899Bug reports[All Projects] Survey participants (Tokens)public2014-04-17 09:29
Assigned ToDenisChenu 
Product Version2.05+ 
Target Version2.05+Fixed in Version 
Summary08899: When importing token data from CSV file the invitation date is ignored
DescriptionWhen importing token data from CSV file the invitation date is ignored and set to "N" even though a correct date exist.
Steps To ReproduceImport the attached token file.
Additional InformationThis problem also occurs at Limesurvey 2.0 build 131206
TagsNo tags attached.
Complete LimeSurvey version number (& build)131206
I will donate to the project if issue is resolvedNo
BrowserGoogle Chrome
Database & DB-VersionMySQL 5
Operating System (Server)Linux
Webserver software & versionApache
PHP Version5.3
Attached Files

parent of 08961closedDenisChenu importing tokens: 2 "new" fields "Email status" and "Language" not filled causes bug on send email invitations 



DenisChenu (developer)

Last edited: 2014-03-26 18:59

View 2 revisions

It's in concept [*] .....

Remove : ,'completed','invited','reminded','remindercount'

And don't remove 'usesleft' ... silly

Think i add 2 option:
- Reset Token status
- Reset email status

Token status : remove usesleft and completed
Email status : remove 'invited','reminded','remindercount'

Your advice for the language string ?

* A really silly concept, i understand now why i have problem when importing completed token .... really silly concept


Mazi (developer)

Denis, I would NOT create any additional setting for this at all. If the date exist, it should be imported.
Same for all other data sets listed above.


DenisChenu (developer)

Yes, but i think some user need 'resetting',

If i put a new function 'import token' => i don't update anything when importing (leave whole date and state), but actually it's the case since 1.92 (and surely before).

$allowedfieldnames=array('firstname','lastname','email','emailstatus','token','language', 'validfrom', 'validuntil', 'usesleft');

We can not change this without control.


c_schmitz (administrator)

I think too that such a function (additional setting) would make more sense if it is part of the survey grid (indeed it was in the past but was lost).


DenisChenu (developer)

I make a quick fix for 2.05 : just disallow tid.
All other can be imported, i just try with bad information in date to see if we have to fix it.

If user want to reset completes : he can remove the column before upload.

For 2.06:
- Token import need to be updated : use Yii token model
- Add the reset function


Mazi (developer)

Sounds good, thanks!


DenisChenu (developer)

Fix committed to master branch:


DenisChenu (developer)

Last edited: 2014-03-27 10:58

View 2 revisions

According to dev discussion : don't remove any exitng field except tid .;
This allow to import invited/sent to 'DONT SEND' ;)


c_schmitz (administrator)

2.05+ Build 140404 released.

+Related Changesets

-Issue History
Date Modified Username Field Change
2014-03-24 15:09 Mazi New Issue
2014-03-24 15:09 Mazi File Added: tokens_657996.csv
2014-03-26 10:56 DenisChenu Assigned To => DenisChenu
2014-03-26 10:56 DenisChenu Status new => assigned
2014-03-26 18:58 DenisChenu Note Added: 29548
2014-03-26 18:59 DenisChenu Note Edited: 29548 View Revisions
2014-03-26 19:34 Mazi Note Added: 29549
2014-03-27 08:44 DenisChenu Note Added: 29551
2014-03-27 10:07 c_schmitz Note Added: 29559
2014-03-27 10:14 DenisChenu Note Added: 29562
2014-03-27 10:42 Mazi Note Added: 29564
2014-03-27 10:57 DenisChenu Changeset attached => LimeSurvey master 7461a732
2014-03-27 10:57 DenisChenu Note Added: 29566
2014-03-27 10:57 DenisChenu Resolution open => fixed
2014-03-27 10:58 DenisChenu Note Added: 29567
2014-03-27 10:58 DenisChenu Status assigned => resolved
2014-03-27 10:58 DenisChenu Note Edited: 29567 View Revisions
2014-04-04 10:26 c_schmitz Note Added: 29664
2014-04-04 10:26 c_schmitz Status resolved => closed
2014-04-17 09:29 DenisChenu Relationship added parent of 08961
2016-12-08 10:39 c_schmitz Category Tokens => Survey participants (Tokens)
+Issue History