Issues in the generated Excel file of form submissions

  • ImagesAlberta
    Asked on April 14, 2015 at 3:27 PM

    I have a form called Annual Competition - General.  I downloaded an excel report on Sunday to check it and it was fine. I did not change the form .  I needed the report on Monday - by 3:00 PM.  On Monday the report had data in the wrong  report columns, perhaps due to empty fields on the form.  I tried multiple reports, and tried removing quotation marks from my form.  No luck.  It took two people 4 hours to reconstruct the report from email notifications.  As we use Excel VBA code to transfer data from your reports into our worksheets, you might imagine data in the wrong columns is not the best situation.  It would "help me better" if this doesn't happen again.  to be fair, it has not happened before, with my other forms which often report user leaving some fields  blank.

     

    I think that in one case, even the top header of the form had errors / garbage.

     

     

    BTW - the email address control sometimes drops characters.  I don't believe user error.
  • Welvin Support Team Lead
    Replied on April 14, 2015 at 4:57 PM

    Hi,

    Our apologies. We have an issue with Excel and CSV report yesterday and this problem could be related to it. Our developers made an update and fixed it already. I did try it in your form and everything is fine. Please try again and let us know if the generated excel file still gives you some issues.

    If there are errors, please take a screenshot and post it here so we can submit it to our developers for further review.

    For the email address issue, will take care of it here: http://www.jotform.com/answers/552590

    Thank you.