Tracking forms not imported into ACT database

  • Profile Image
    Michael Irwin
    Asked on June 09, 2014 at 02:18 PM

    We have an existing account with you as Kars-R-Us.  From time to time one of the submitted forms does not make it into our database.  We're sending the form information to Outlook, and then using the program Northwoods Web Prospect to import the form information into our ACT database.  I suspect the issue we're having is in the Outlook program, because the forms arrived into Outlook but were not properly routed to be exported to the Web Prospect program.

    1) Do you have a suggestion for a more efficient way to import the form information?

    2) Does Jot Form generate a log of all transactions that we can use as a cross check against what's been imported?

    Your assistance is appreciated,

    Michael Irwin

  • Profile Image
    Answered on June 09, 2014 at 04:05 PM

    Thank you for contacting us.

    I am not an ACT database user, so it is hard for me to suggest any import alternatives.

    1. For example, if you use HTML form email alerts, you might try switching to plain Text mode emails to see if that makes any difference for importing into database.

    Also, we support Excel/CSV form submission data export. It is probably that you can import downloaded Excel/CSV into your database.

    More advanced option is a webhook method. It can send HTTP post data to notification URL that in theory can process the data and forward it to your database, but it will not work without custom programming.

    How to Setup Webhook with Jotform

    2. I think that the Northwoods Web Prospect software is not connected with the Jotform, so that we do not have any import logs on our side.

    All the form entries can be found on a form Submissions page.

    Please let us know if you need any further assistance on this. We will be happy to help.