+- 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: Reset Form ID (/showthread.php?tid=987)
Reset Form ID - pinkfrankenstein - Dec 19th, 2010
I develop locally on my computer and then upload to a server. Is there a way to reset what Form Tools sets as the Form ID ?
I find that I am still tweaking my forms and having to recreate them in Form Tools which makes the form_ID get out of sync with the one on the server.
Can I manually go into the database and set/reset this?
RE: Reset Form ID - michatmaster7 - Dec 20th, 2010
Subscribed to this thread. Excellent question for us perfectionists.
RE: Reset Form ID - Hannes - Dec 26th, 2010
Hey there,
in function there is no advantage, so you might think twice if it makes sense for you to change the form id.
- FormID is defined in mysql database "ft_forms" (if prefix is as default "ft_").
- The field "form_id" in this database defines the form id.
- The form database must be renamed/created to "ft_form_[formID]".
Hannes
RE: Reset Form ID - Ben - Dec 26th, 2010
Yeah - this is one of those nagging little things that are hard to resolve.
Funnily enough, I had the same objection to the submission ID - it would end up getting out of whack between my testing environments, so I ended up writing a simple little module to allow resetting/changing the next submission ID counter - including emptying the data & resetting to zero.
http://modules.formtools.org/submission_id_manager/download.php
For the form ID, you'll need to run a "TRUNCATE ft_form_X" SQL query on your table to completely reset the form ID. However, that will empty all the data out of it too.
All the best -
Ben
RE: Reset Form ID - pinkfrankenstein - Dec 26th, 2010
As a work around I've created a small PHP form config file that has not only the server name but also the Form_ID. It lives outside of my development directory so that I don't accidentally replace it.
So there is one on my server and one on my local machine with the appropriate information. Works really well for development.
RE: Reset Form ID - michatmaster7 - Dec 26th, 2010
Wow. Sad that I never thought of extensions for FT before. I just perused that whole section. The Submission ID Manager actually answers another question I was going to have, so thank you in advance
RE: Reset Form ID - Ben - Dec 30th, 2010
haha no worries.
And pinkfrankenstein - thanks for posting your solution!
- Ben
RE: Reset Form ID - ron77hays - Feb 16th, 2011
Quote:As a work around I've created a small PHP form config file that has not only the server name but also the Form_ID. It lives outside of my development directory so that I don't accidentally replace it.'
Is it also possible to have it inside?