Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:

TOPIC: Reset or modify participant ID's

Reset or modify participant ID's 2 years 7 months ago #108151

  • Simyo1
  • Simyo1's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
Is there a possibility to reset or modify the consecutive participant ID's?


Thank you
The administrator has disabled public write access.

Reset or modify participant ID's 2 years 6 months ago #108152

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 5417
  • Thank you received: 806
  • Karma: 239
No, I don't think so. You might be able to change them via MySQL, but I am not sure what kind of impact this will have.

However, why would you need to change the participant IDs?
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | [url=https://manual.limesurvey.org/Workarounds[/url]

If you found this answer helpful and it saved you some time please consider a [url=https://donate.limesurvey.org[/url] to the...
The administrator has disabled public write access.

Reset or modify participant ID's 2 years 6 months ago #108154

  • Ben_V
  • Ben_V's Avatar
  • Offline
  • Platinum Lime
  • Posts: 1894
  • Thank you received: 467
  • Karma: 118
Hello,

As proposed by Holch, you can do it via MySql. Using the following syntax will:

1) Delete all your responses of your survey (no need to desactivate the survey)
2) Reset the 1st participant ID for this survey to "1"
TRUNCATE TABLE lime_survey_123

Replace "lime_survey_123" by the correct table name (the most of the time, just adapt "123" with the correct survey ID)
BenoƮt

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
All LS releases => bit.ly/1VMuTDu | 2.06lts => bit.ly/1Qv44A1
Demo surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
The administrator has disabled public write access.
Time to create page: 0.230 seconds
Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form