I am wanting more information on your service and possiblities to integrate data with a database

  • Profile Image
    Daniel Mills
    Asked 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.

  • Profile Image
    fxr
    Answered 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.

    http://www.jotform.com/help/44-How-to-Export-Form-Data-to-Excel

    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. 

    http://www.jotform.com/help/chapter-6-Reports

    Of course this is an involved process and would take a skilled programmer to generate that script for you. 

  • Profile Image
    gori-mathew
    Answered on April 10, 2012 at 02:11 PM

    Hi,

    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.

  • Profile Image
    jeanettebmz
    Answered 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

    Jeanette