+- 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: Copy forms in MySQL (/showthread.php?tid=1676)
Copy forms in MySQL - Jan - Oct 7th, 2011
Hello,
First thanks to Ben and Joseph.
They offer good help backstage.
Now another question.
How can I copy complete forms in phpMyAdmin?
I know, there is a simple copy button.
What I need to know is witch fields I need to copy to make a complete form work in formtools.
I can change ID numbers of the forms myself and then import again to MySQL.
What more do I need to change?
(the reason: I give every user his/her own form so it stays private. It is just a lot of work to make new forms over and over again..)
Thanks,
Jan
RE: Copy forms in MySQL - Ben - Oct 7th, 2011
Hi Jan,
Have you checked out the Form Backup module?
http://modules.formtools.org/form_backup/
That might be what you need: it lets you make complete copies of a Form Tools form, so they can be used as backups or to re-assign to different clients.
The problem with doing it with phpMyAdmin is the data and configuration for a single form is spread over multiple tables. You can't just copy over data because the IDs for different tables need to be unique for each form.
The Form Backup module does all the nasty stuff for you: it duplicates the necessary database records and that sort of stuff, so you don't need to worry about it.
Hope this helps!
- Ben
RE: Copy forms in MySQL - Jan - Oct 7th, 2011
Hello Ben,
I go try that.
Thanks a lot!
RE: Copy forms in MySQL - Jan - Oct 9th, 2011
Briljant, it works!
Just one more (maby stupid) question.
Is it somehow possible to copy all forms at once?
I am happy with the module anyway, but maby I can save some more work :-)
Thanks!
RE: Copy forms in MySQL - Ben - Oct 10th, 2011
Hey Jan,
Ooh, good idea! That would make a nice addition to the module. But right now, I'm afraid it's only one by one.
All the best -
Ben