Importing data into existing form

[flip3]

Hello,

I have a form with around 80 submissions. The submission ID starts from 0. I have also old submission records which I would like to import into the same form but before the current submission IDs. So the current submissions must be changed to somewhat starting from 300 and then the old entries will be imported starting with 0.

What is the best approach for this? Can I simply manually change the submission IDs in MySQL or are they linked to other tables which also need to be updated? Will the counter automatically continue from the highest submission ID in database once I change the IDs? I don't want anything to be overwritten.

I found thi module but I don't understand what is meant by "empty forms"?
http://modules.formtools.org/submission_id_manager/

Philip

[Joe]

Hello,

I have a form with around 80 submissions. The submission ID starts from 0. I have also old submission records which I would like to import into the same form but before the current submission IDs. So the current submissions must be changed to somewhat starting from 300 and then the old entries will be imported starting with 0.

What is the best approach for this? Can I simply manually change the submission IDs in MySQL or are they linked to other tables which also need to be updated? Will the counter automatically continue from the highest submission ID in database once I change the IDs? I don't want anything to be overwritten.

I found thi module but I don't understand what is meant by "empty forms"?
http://modules.formtools.org/submission_id_manager/

Philip

Hi Philip,

The Submissions ID Manager will only allow you to edit the next submission ID. It can not edit or revise existing IDs. So you could import your current data and then set the submission ID to 300 in the Submission ID Manager and then next for submission will start at 300.

You can indeed change the ID automatically in MySQL the other tables use the Form ID so the data in the form field will not cause issues in other tables. The auto incrementing IDs will continue from the ID that you set in the submission account manager.

Hope this helps!