How can I automatically export to FireBird SQL or .CSV?

  • Profile Image
    BeyondBody
    Asked on December 29, 2020 at 01:03 AM

    We have indemnity forms which the customer fills in at first.

    We are also using Omni Accounts as our Accounting software.


    The goal is: to take the customer information from the indemnity form submission,

    and have it automatically input the data as a customer account to the Firebird SQL database...

    Can Jotform do this?


    Alternatively, If there is any way to automatically generate & save/mail a .csv file from the form submission? (Omni is capable of automatic import of .csv files)

    PLEASE HELP

    https://studio57online.co.za/bbmindemnity/

    https://www.omniaccounts.co.za/


    Thanks

    -Rick

  • Profile Image
    Patrick_R
    Answered on December 29, 2020 at 01:37 AM

    Hello Rick! Please find answers to your queries below:

    - The goal is: to take the customer information from the indemnity form submission, and have it automatically input the data as a customer account to the Firebird SQL database... Can Jotform do this?

    With Jotform, you can collect the submission data as a POST request on your web scripts like PHP; you'll then need to write your own code to insert that data into your database.

    Here is a guide that explains this process in detail: how-to-send-submissions-to-your-mysql-database-using-php

    - Alternatively, If there is any way to automatically generate & save/mail a .csv file from the form submission? (Omni is capable of automatic import of .csv files)

    On every form submission; submitted data is emailed; but this is not in CSV format. This is in HTML/Text format. You can read about it here: explanation-of-email-notification-and-autoresponder-settings

    CSV submission data is available as CSV report. This is a real-time report and is updated as soon as a submission is received. This guide describes how you can create a CSV report: how-to-create-a-csv-report

    Please note that this CSV report will consist of all submissions.

    I hope this information helps. If you have any questions; let us know.

    Thank you!