Welcome, Guest
Username: Password: Remember me

TOPIC: Update survey email addresses through the backend database

Update survey email addresses through the backend database 2 years 1 day ago #87037

  • AndrewS
  • AndrewS's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 1
  • Karma: 0
Hi all,

We currently have a survey underway with about 50,000 requests. It has been discovered that 4,000 of these shouldn't be part of the survey.

Now this might sound a bit strange but I've never used Limesurvey myself. My role in this is that when the survey is finished I will be provided with an csv file of the survey results. At this point I can easily remove the 4,000 requests.

The issue at the moment is we don't want thouse 4,000 requests to be emailed whenever a reminder is issued during the survey. I've been told it's not possible to exclude those records from the reminders.

I've done a bit of investigation and it looks feasible to connect to the backend MySQL database and run a simple SQL updating the email address in the token table to something else (a valid but unused email account etc) for those 4,000 requests (which I can identify by one of the attribute fields in the table).

Does anyone see any problems with this quick workaround solution? I can't see any dependencies on the email field, or any indication that it would cause problems if it was changed through the backend database.

PS. If deleting the whole record in the token table (if it hasn't been completed) is an option too, let me know :)

Thanks

Rgds,
Andrew
The administrator has disabled public write access.

Re: Update survey email addresses through the backend database 2 years 1 day ago #87062

  • tpartner
  • tpartner's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 4264
  • Thank you received: 801
  • Karma: 368
I don't think there is any problem with removing the cases that have not completed the survey.

I've done the same thing in a smaller scale by export/modify/import the token table.
Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

LimeSurvey is open-source and run entirely by volunteers so please consider donating to support the project.
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.093 seconds
Donation Image