Import App: Submission date from the csv file is not being imported.

  • Profile Image
    emucoe
    Asked on November 28, 2018 at 09:08 PM

    Hello,

    After using the Import App to upload records from another source, the "Submission Date" of the imported records displays the date and time of the import, not the date and time indicated in the date column of the .csv file.

    1. Is there a way to undo the import?

    2. Will the Import App properly import records with an older date, or will it always set the submission date as the import date and time?

  • Profile Image
    ashwin_d
    Answered on November 29, 2018 at 02:08 AM

    1. Is there a way to undo the import?

    There is no way to undo submission import. The only possibility is to delete the submissions from your form's submission page. The following guide should help you how to delete submission:  https://www.jotform.com/help/377-How-to-Delete-Form-Submission-Data 


    2. Will the Import App properly import records with an older date, or will it always set the submission date as the import date and time?

    Can you please share the screenshot of one of the records you are trying to import and also the form in which you want to import the date? Do get back to us on this and we will take a look.

    We will wait for your response.

  • Profile Image
    emucoe
    Answered on November 29, 2018 at 09:28 AM

    Thanks for the helpful info on deleting just a particular set of data by date range.

    Attached is a screenshot showing .xlsx data file header, and result, and a .csv file header, and result.

    1543501675import screenshots.png

  • Profile Image
    ashwin_d
    Answered on November 29, 2018 at 10:52 AM

    Is it possible for you send us the csv file to us? Please send the file to us in email at support@jotform.com and we will try to import it in your cloned form.

    Please ensure the subject line of the email as "Thread #1656985"

    We will wait for your response.

  • Profile Image
    emucoe
    Answered on November 29, 2018 at 02:50 PM

     I sent the email, at 11:06 AM, 14 minutes after getting your message.

  • Profile Image
    Mike
    Answered on November 29, 2018 at 05:44 PM

    I was unable to locate your email. However, the issue is most likely related to the formatting.

    Excel converts dates into numbers, so this will not work properly for import unless you somehow convert dates to the text.

    In CSV, the format must match the template format. Again, if you save it in Microsoft Excel, the format might be different.

    Here is a default format example (using Notepad++ editor):

    You can do a test import using the next file:

    https://shots.jotform.com/mike/files/1656985.csv

    Thank you.

  • Profile Image
    emucoe
    Answered on November 30, 2018 at 12:31 PM

    Mike,

    Thanks for the pointer. When I created the .csv file using a different application (Numbers, instead of Excel) and tested, it imported the date records as expected.

  • Profile Image
    John_Benson
    Answered on November 30, 2018 at 03:14 PM

    Is the issue resolved? 

    If yes, please disregard this reply. Thank you.