Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC: Can I reset the {SAVEDID} so it starts again at 1 after I delete all responses?

Can I reset the {SAVEDID} so it starts again at 1 after I delete all responses? 1 year 9 months ago #92846

  • guelphpeter
  • guelphpeter's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 36
  • Thank you received: 1
  • Karma: 0
Thanks so much Benoit,

the TRUNCATE did indeed resolve the issue for me - really appreciate your help !

Peter
The administrator has disabled public write access.
The following user(s) said Thank You: Ben_V

Can I reset the {SAVEDID} so it starts again at 1 after I delete all responses? 5 days 12 hours ago #114664

  • mattZee
  • mattZee's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
There is also another workaround if you don't have access to the database.

1. Export the survey structure (you need the surveyname.lss file).

2. Open the *.lss file in an editor and find the line:
<autonumber_start><![CDATA[99]]></autonumber_start>

3. Replace 99 by 1 to start the SAVEDID with 1 or with any other value you like.

4. DELETE the original survey (otherwise the next step will generate a new survey with a NEW SURVEYID)

5. Add a new survey by import and select the manipulated survey.lss file.

DONE.
Last Edit: 5 days 12 hours ago by mattZee. Reason: typo
The administrator has disabled public write access.
  • Page:
  • 1
  • 2
Moderators: ITEd
Time to create page: 0.152 seconds
Donation Image