Import Data App: Dates not importing correctly

  • stevedellar
    Asked on March 19, 2017 at 2:37 PM

    I imported one record into https://eu.jotform.com/submissions/60492174138355 using your import.io ap

     

    I ended up with over 400 imported and the dates are not correct.

     

    Here is the link to the data to be uploaded 

    https://docs.google.com/spreadsheets/d/19LpFZXNDpcOdJdQiubK-Y0VIIFbfBeJot7zLSdrPljI/edit?usp=sharing

    Can you help

     

    Cheers

     

     

  • Mike
    Replied on March 19, 2017 at 3:37 PM

    Excel stores dates as sequential serial numbers, so this might be a reason of the issue. Our import tool cannot convert those serial numbers to the dates.

    Please try with dates formatted as a Text. It should help with the import.

    Import Data App: Dates not importing correctly Image 1 Screenshot 20

    The empty form entries are most likely corresponding to the empty spreadsheet rows.

    If you need any further assistance, please let us know.

  • stevedellar
    Replied on March 19, 2017 at 4:18 PM

    With excel you cannot remove empty rows.  

     

    This is having an impact on my download limits

  • stevedellar
    Replied on March 19, 2017 at 4:26 PM

     

     

     

     

     

     

     

  • Welvin Support Team Lead
    Replied on March 19, 2017 at 4:45 PM

    You should have the option to delete empty rows in the excel file. 

    http://www.techrepublic.com/blog/microsoft-office/a-quick-way-to-delete-blank-rows-in-excel/

    You seem to have provided us a screenshot. Unfortunately, it failed to appear on this forum. Please note that we cannot accept inline attachments. You have to access this thread, click the image tool to upload, as per our guide here: https://www.jotform.com/answers/277033.