- Daniel MillsAsked on April 10, 2012 at 01:48 PM
I would like to download the data to a database in house rather than just get it by email over a secure replication of the data. Is this possible? Do you have someone I can talk to about this kind of thing or other delivery options. I want to secure the communication, but not have to do it in any manual process.
- fxrAnswered on April 10, 2012 at 02:02 PM
Unfortunately, there is no sort of API, at this time, to connect to your JotForm submission database.
You can, however, download submission data in Excel or CSV format and use that to populate your database.
One possible option for automating the process of updating your own database is to generate a HTML report of your submissions and have a script hosted on your server parse that HTML file, extracting the necessary from it.
Of course this is an involved process and would take a skilled programmer to generate that script for you.
- gori-mathewAnswered on April 10, 2012 at 02:11 PM
I have more details here, in addition to my colleague's above response.
While there is no direct solution available at the moment, it is possible to indirectly integrate your JotForm form submissions into your Mysql database in a number of ways:
A) Use the Send Form Post Data feature to add the data to your database indirectly. You will need to write some PHP (or other programming language) server side code to insert the data to your database.
B) Export your form submissions into an Excel/CSV File and import it into your database. For instructions on how to export submissions in JotForm, please click here.
C) Purchase the JotForm Application License. This way you can have complete control over your data. You can also customize the source code according to your needs.
We hope you find this information useful.
- jeanettebmzAnswered on April 10, 2012 at 02:14 PM
Another possible option that might accomplish what you are looking for , is to insert form submissions Data into a MySql database, using PHP
But , like my colleague has stated above, there is a programming process involved on this . And probably you might have another type of database server
But, here it is the guide , I hope it helps