Start arrow Support arrow Hilfe-Foren
LimeSurvey Forums
Welcome, Guest
Please Login or Register.    Lost Password?
Re:How to delete all the "Not Completed" users? (1 viewing) (1) Guest
Go to bottom Favoured: 0
TOPIC: Re:How to delete all the "Not Completed" users?
#18102
Effenberg (Visitor)

How to delete all the "Not Completed" users? 2 Months, 3 Weeks ago  
I have about 500 users that have not completed my survey. Looking at the tokens interface and calling some of these users, I see many of them have mistyped e-mail address when registering for the survey (never received the invitation with the URL, besides people that lost their e-mail invitations, etc.

I need to exclude them from the database, so they can visit the registration page again and try to answer the survey one more time.

Deleting each of this 500 manually by clicking at the "D" buttons at the tokens interface will take a life time, and I need this to be done within the next couple hours, because they will be invited to visit the registration page (by phone and e-mail) by the end of the day.

Anyone got a tip?
 
Logged Logged  
  The administrator has disabled public write access.
#18108
bobc55 (User)
LimeSurvey Team
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
Re:How to delete all the "Not Completed" users? 2 Months, 3 Weeks ago Karma: 0  
you could delete the records by using phpMyAdmin with the following command:

delete from token_<surveyID>
where completed='N';
 
Logged Logged  
  The administrator has disabled public write access.
Go to top