We cannot import csv file

  • Post date

Home › Forums › Calendar Products › Community Events › We cannot import csv file

Viewing 9 posts - 1 through 9 (of 9 total)
  • Author
    Posts
  • February 9, 2016 at 3:20 pm #1070491
    Karen
    Participant

    We have tried importing a csv file with 120 events. It will not upload.

    This is the message:

    Import Result

    Import complete!

    Inserted: 120
    Updated: 0
    Skipped: 0

    The import statistics above have the following meaning:

    Inserted: A new item was inserted successfully.
    Updated: An item was found with the same name and/or start date. The existing item was updated with the new value from the file.
    Skipped: A row was found in the CSV file that could not be imported. Please see below for the invalid rows.

    February 9, 2016 at 4:14 pm #1070505
    Karen
    Participant

    This reply is private.

    February 10, 2016 at 7:24 am #1070870
    Geoff
    Member

    Hi Karen and sorry for the trouble here with importing!

    Are you by chance able to share a copy of the CSV file, perhaps via Dropbox or some other file-sharing service? I’d like to try importing it myself and compare it to another CSV file to see if there are any inconsistencies.

    Thanks!
    Geoff

    February 10, 2016 at 7:36 am #1070880
    Karen
    Participant

    This reply is private.

    February 10, 2016 at 10:21 am #1070938
    Karen
    Participant

    This reply is private.

    February 10, 2016 at 2:15 pm #1071091
    Geoff
    Member

    Hi Karen,

    Thanks so much for sharing the file–this is super helpful!

    It looks like there are special characters in the names of the events and they need to be encoded to standard UTF-8 in order to work.

    I went ahead and made the conversion and that allowed all the events to import correctly. Try downloading this copy (right click and Save Link As) and giving it another go.

    Thanks!
    Geoff

    February 10, 2016 at 2:42 pm #1071099
    Karen
    Participant

    Thanks Geoff,

    That fixed the problem. Can you tell me which characters are not acceptable?

    February 10, 2016 at 2:58 pm #1071100
    Karen
    Participant

    This reply is private.

    February 11, 2016 at 7:19 am #1071524
    Geoff
    Member

    Awesome, I’m glad that helped Karen! Thanks for following up to let me know.

    It’s not so much that any one specific character was off, but that the entire file was encoded as a non-UTF-8 file. Depending on the program used to edit CSV files (e.g. Excel), you can change the formatting to UTF-8, re-save the file, then import from there.

    Is there a way to remove the Find out more >> link? We dont have additional information for the event.

    Yes, that can be removed using the answer in this thread.

    I see you’ve marked this thread as Resolved so I will go ahead and close it, but please feel free to hit us with a new one if any other questions pop up–we’d be happy to help. 🙂

    Cheers!
    Geoff

  • Author
    Posts
Viewing 9 posts - 1 through 9 (of 9 total)
  • The topic ‘We cannot import csv file’ is closed to new replies.