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

  • Profile Image
    memaxt
    Asked 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
    Charlie
    Answered 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
    memaxt
    Answered 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
    Boris
    Answered 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
    memaxt
    Answered 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
    Charlie
    Answered 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.