Page 1 of 1

Formbrowser export/import submissions?

Posted: Thu May 16, 2013 4:23 pm
by JiiPee
Hi, is there a way to export/import formbrowser submissions from one cmsms installation to another?

Can I just install fresh formbuilder to new site and then copy over all the files from old sites modules/formbuilder?

Form builder forms were easy to copy just export/import in xml format.

Re: Formbrowser export/import submissions?

Posted: Thu May 16, 2013 7:54 pm
by applejack
JiiPee wrote: Can I just install fresh formbuilder to new site and then copy over all the files from old sites modules/formbuilder?
No not in the same way as Formbuilder. You can either copy the whole of the existing site and then just delete what content you don't need. Or set up a fresh install including Formbrowser, export the table(s) relating to Formbrowser from the existing database and import into the new database on the command line if you have access.

Re: Formbrowser export/import submissions?

Posted: Fri May 17, 2013 7:05 am
by JiiPee
Hi and thank you!

Do you know if those database tables could be copied with phpmyadmin? If they could, would you let me know, please.

Re: Formbrowser export/import submissions?

Posted: Fri May 17, 2013 12:28 pm
by applejack
I generally don't use phpmyadmin but use the command line instead.

*** dumping a mysql table to a file (MySql statements)
mysqldump -uuser -ppassword -hhost databasename tablename1 tablename2 > sql.txt

*** uploading sql commands (or a dump) back into mysql
mysql -uuser -ppassword -hhost databasename < sql.txt

Re: Formbrowser export/import submissions?

Posted: Fri May 17, 2013 12:56 pm
by cfra2701
Hi,

Just pay attention because certain tables in formbrowser have an "id" like field which is not auto incremential!! Which means it is incremented another way, I don't know which, but the result is that it becomes buggy.