Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Reset or modify participant ID's

  • Simyo1
  • Simyo1's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 10 months ago #108151 by Simyo1
Reset or modify participant ID's was created by Simyo1
Is there a possibility to reset or modify the consecutive participant ID's?


Thank you
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
9 years 10 months ago #108152 by holch
Replied by holch on topic Reset or modify participant ID's
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?

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

The topic has been locked.
More
9 years 10 months ago #108154 by Ben_V
Replied by Ben_V on topic Reset or modify participant ID's
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"
Code:
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
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose