Copy forms in MySQL

[Jan]

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

[Ben]

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

[Jan]

Hello Ben,

I go try that.
Thanks a lot!

[Jan]

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!

[Ben]

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