The following warnings occurred:
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.31 (Linux)
File Line Function
/global.php 783 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.31 (Linux)
File Line Function
/global.php 783 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined variable $newpmmsg - Line: 40 - File: global.php(841) : eval()'d code PHP 8.1.31 (Linux)
File Line Function
/global.php(841) : eval()'d code 40 errorHandler->error
/global.php 841 eval
/printthread.php 16 require_once
Warning [2] Undefined array key "style" - Line: 909 - File: global.php PHP 8.1.31 (Linux)
File Line Function
/global.php 909 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined property: MyLanguage::$lang_select_default - Line: 5024 - File: inc/functions.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions.php 5024 errorHandler->error
/global.php 909 build_theme_select
/printthread.php 16 require_once
Warning [2] Undefined array key "additionalgroups" - Line: 7162 - File: inc/functions.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions.php 7162 errorHandler->error
/inc/functions.php 5044 is_member
/global.php 909 build_theme_select
/printthread.php 16 require_once
Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions.php 1415 errorHandler->error
/inc/functions.php 1370 fetch_forum_permissions
/printthread.php 76 forum_permissions
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 165 errorHandler->error



Form Tools
Importing data into existing form - Printable Version

+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: Importing data into existing form (/showthread.php?tid=2240)



Importing data into existing form - flip3 - Oct 22nd, 2012

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


RE: Importing data into existing form - Joe - Nov 20th, 2012

(Oct 22nd, 2012, 7:20 PM)flip3 Wrote: 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!