MachForm Community Forums » MachForm 2

1. EoinByrne
   Member

   Hi,

   what is the best way to go about getting the data out of teh MachForms database? Is it possible to go directly to the MySQL DB?

   Regards,
   Eoin

   Posted 14 years ago #
2. 

   redityo

   Basically you can directly go to MySQL backend and get the data from there. But I think easier to get the form data by export the entries to excel or csv files from machform admin.

   ---

   MachForm Support

   Posted 14 years ago #

3. EoinByrne
   Member

   Thanks for that. I wanted to skip out the MySQL-> CSV -> import type steps. I'm looking art doing something that refreshes every hour or so. I really wanted to automat the process.

   How complex is the MySQL schema behind the forms? Once you figure it out for one form is it pretty much the same for the others?

   Cheers,
   E.

   Posted 14 years ago #
4. 

   redityo

   Each form has it own table, for example table "form_4" refer to form 4 , so you can query that table to get the data. However, You might be need to join the table for some field like drop down. You can see this link for further information :

   http://www.appnitro.com/forums/topic/drop-downs-and-mysql?replies=11

   http://www.appnitro.com/forums/topic/mysql-question?replies=5

   ---

   MachForm Support

   Posted 14 years ago #

RSS feed for this topic

Reply

You must log in to post.