Reset or modify participant ID's

More
3 years 6 months ago #108151 by Simyo1
Simyo1 created the topic: Reset or modify participant ID's
Is there a possibility to reset or modify the consecutive participant ID's?


Thank you

Please Log in to join the conversation.

More
3 years 6 months ago #108152 by holch
holch replied the 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'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in to join the conversation.

More
3 years 6 months ago #108154 by Ben_V
Ben_V replied the 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"
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)

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!