Hi,

I have found a couple of threads in the forum along this theme but they don't seem to answer my query fully.

I made a survey live today with about 40 questions and my token table contained just over 4000 participant details. I started sending out the invites and have been tracking the study since about 1pm. Between that time and now we have had 116 respondents come to the survey and start. It looks, from the data, that all have completed and I have received 116 emails telling me that those surveys have been submitted.

But, here's the puzzling thing. An 'N' registered in the completed field. When I look at the tokens table I only see about 47 records where the Complete field is set to 'Y'.

As you can imagine this makes it difficult to administer reminder emails or give my client reliable feedback.

I do have access to the dB, so is there a way I can edit the records with a bit of SQL to update the completed field to 'Y'. Is the token Complete field different to the Complete field displayed on the Statistics screen? And finally, is there a fix for this so I don't have to manually update the records?

Thanks in advance
Paul

Hi Paul


I do have access to the dB, so is there a way I can edit the records with a bit of SQL to update the completed field to 'Y'.


Sure, just issue an update command on the table.

update xy_table set completed='Y'

(will set all records to completed = y)


Is the token Complete field different to the Complete field displayed on the Statistics screen? And finally, is there a fix for this so I don't have to manually update the records?

Depends what version you are using? If you are using the latest version please report this to the bugtracker.

Thank you!

Hi Paul,

I have a similar problem. As it seems until now no one could reproduce this (although I can). Maybe you can contribute to the bug report or create a new one.
http://bugs.limesurvey.org/view.php?id=2193

Ciao
Joe

I have added a supposed fix. Please test and feed back.

The fix is the latest SVN Carsten, yes?

Cheers
Paul

c_schmitz wrote:
Hi Paul

Sure, just issue an update command on the table.

update xy_table set completed='Y'

(will set all records to completed = y)


Hi Carsten,

Just had a look at the survey_surveynumber table and there is no field called completed that I can set to "Y". Am I looking at the wrong dB table? There is a date submitted field. Does the software look for a date and then just display a "Y" on the statistics screen if a date is recorded? If so, would just setting a date prior to today work?

Cheers
Paul

The completed field can be found at the lime_tokens_12345 table (depending on your survey settings).

Mazi,

That isn't any good. From the look of Carstens post it sounds like there should be a field in the completed results table (survey_xxxxx). The tokens table contains all tokens, in my case, over 4000. So if I issue an update completed field set to "Y" SQL command ALL 4000+ records are set to "Y". Not good as we then won't be able to send any reminder emails.

Somewhere there must be a field that flags the respondent as a complete. If it is the tokens table then that isn't what Carsten mentioned and also if you can link the tokens table to the responses table then you have blown all anonymity. All of a sudden I can check who said what = BAD.

Cheers
Paul

Hello Paul,

I am sorry. I meant the submitdate field, of course.
That is what submitted results separates from incomplete results.

Brilliant. Cheers Carsten.