Is it possible to export data automatically?

  • Profile Image
    carldarby
    Asked on February 06, 2020 at 05:41 AM

    Hi.

    Can you tell me how I can schedule an export of the data into a csv and save the file somewhere, or can I obtain access to the data from our local SQL server and query the data into our database?

    Thanks.

  • Profile Image
    Jed_C
    Answered on February 06, 2020 at 05:48 AM

    It is not possible to export form data to csv file automatically, however, there is an option to integrate a form with Google SpreadsheetsHow-to-Integrate-Form-with-Google-Spreadsheet.

    Also, you could send submissions to your MySQL Database: How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP

    Let us know if you need any further assistance.

  • Profile Image
    carldarby
    Answered on February 06, 2020 at 05:56 AM

    Is it possible to send submissions to our Microsoft SQL Database?

  • Profile Image
    Jed_C
    Answered on February 06, 2020 at 06:13 AM

    You can use automate.io to integrate Jotform and your MS SQL server https://automate.io/integration/jotform/sql-server.

  • Profile Image
    carldarby
    Answered on February 06, 2020 at 06:18 AM

    Thanks Jed - I've had a look at that link and it says that the integration between Jotform and MS SQL is still in development???

    Any ideas?

  • Profile Image
    gerardw
    Answered on February 06, 2020 at 06:23 AM

    You can check out the earlier guide shared by my colleague where in you can send submissions to your DB using PHP: https://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP 

  • Profile Image
    carldarby
    Answered on February 06, 2020 at 06:39 AM

    So you can use PHP to send submissions into MS SQL as well as MySQL?

  • Profile Image
    Jed_C
    Answered on February 06, 2020 at 07:08 AM

    Yes, you'll need to write your own PHP script that connects to your MSSQL or MySQL server. You can try the PHP script written by the user who tried to connect it with MSSQL using PHP.

    Here's the link https://www.jotform.com/answers/1184132.

  • Profile Image
    carldarby
    Answered on February 26, 2020 at 07:23 AM

    Hi there.  Before I go ahead and pay for someone to write a php script to connect the MS SQL server with Jotform, can you tell me if this solution is possible if I do not use a thank you page.  Currently, upon form submission, I have it set to go back to a custom menu page which has a button for each of the forms in use.

    Thanks.

  • Profile Image
    carldarby
    Answered on February 26, 2020 at 07:24 AM

     Also, is it possible to query the submission database from external, or only by use of webhooks?

  • Profile Image
    Jed_C
    Answered on February 26, 2020 at 08:47 AM

    can you tell me if this solution is possible if I do not use a thank you page. — No, it's not possible without sending a POST to your server. You'll need POST method to send Jotform submission to your server and store it to your own database using PHP script.

    is it possible to query the submission database from external, or only by use of webhooks? — Once data is stored in your own server, it will now be accessible to you for query.

    If you are asking about submission query via Jotform, you can pull data via API, there a lots of ways to do it.

    Guide: https://api.jotform.com/docs/#submission-id

    ex. https://api.jotform.com/submission/{submissionID}?apiKey={apiKey}