What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    How to export the values of the Matrix Dynamique widget from Outlook email to MS Access database?

    Asked by memaxt on July 02, 2015 at 06:37 AM

    Hi All,

    I've using the Matrix Dynamique containing 2 Fields:

    Name / Registration

    when I export the data it appears like this:

    NameRegistrationMax123Bob567

    Is there away I can seperate the headings and values entered? this is going to fall into a database but the corrent format isnt working.

    for example:

    Name,Registration,Max,123,Bob,567

    Many thanks

    Max

  • Profile Image
    JotForm Support

    Answered by Charlie on July 02, 2015 at 09:40 AM

    Hi,

    May I know how you are exporting it? Are you exporting the submissions as an excel file in your submissions page?

    In my end, this is how it looks like:

     

    The Matrix Dynamique field are split by "," and the columns by ":".

    If you want, you can try sending the submission data via POST using PHP and directly sending it to a MySQL database. Here's a guide for that: http://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP.

    I hope that helps.

  • Profile Image

    Answered by memaxt on July 02, 2015 at 09:48 AM

    I've connected my access database to my outlook.

    So I what I do it import the email contents into MS Access, but its coming through as NameRegistrationMax123Bob567 with the delimiters removed from the email.

    Does that make sense?

  • Profile Image
    JotForm Support

    Answered by Boris on July 02, 2015 at 11:10 AM

    If I understand you correctly, you are using your Email Notifications as the source of your data, and you then put this data into your MS Access database.

    I believe that the problem lies in how you are getting your data into Access. Please use one of the following methods to feed data into your MS Access database instead:

    1. As my colleague Charlie has suggested, you can use this guide to see how to forward data to your databases - How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP

    2. You can use something like the Excel or CSV submissions or Excel / CSV reports, and copy data from there.

    The problem in the method you are using now is that you are trying to pull data directly from the email body, and data in the email is presented inside a table which your software can't properly see as delimited fields. Your software sees the data in the table as a single continuous field.

    Using method 1 that was suggested by my colleague as well, data would be forwarded in a manner like this:

    Please let us know if you need further assistance with your forms, we will be happy to help.

  • Profile Image

    Answered by memaxt on July 02, 2015 at 11:14 AM

    Many thanks for your reply.

    You are exactly right!

    Unfortuantly our MySQL provider does not allow remote access thus not allowing me to link MS Access to MySQL which would of been the preferred method.

    I cant use the EXCEL / CSV export as I need it to arrive in my MS Access database as and when the email comes in. I've Automated Access to check for new emails.

    Is there no way i can PARSE the fields in access? or apply a script to the Matrix?

    Many thanks again

    Max

  • Profile Image
    JotForm Support

    Answered by Charlie on July 02, 2015 at 11:46 AM

    I'm sorry, but I have little knowledge with the setup your have regarding exporting Outlook emails in your MS Access database.

    Other than the mentioned methods by my colleague, Boris, I am unable to think of another way to do this. The Matrix Dynamique widget is also loaded in the widgets server, using a script would not change the delimiter of the fields in the email notification.

    Thank you for understanding.