CSV Import failing on Description HTML field

  • Post date

Home › Forums › Calendar Products › Events Calendar PRO › CSV Import failing on Description HTML field

  • This topic has 4 replies, 2 voices, and was last updated 8 years ago by Brendan.
Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • April 11, 2018 at 6:13 am #1504201
    Brendan
    Participant

    Here is the CSV I’m trying to import with all my events: https://www.dropbox.com/s/waka1b41oqlay47/ticket-import-all-fields-test.csv?dl=0

    I’m not sure if the importer is correctly handling the double quotes or what exactly is happening, but it imports fine when I remove the Description field.

    I’m guessing this is some kind of an importer bug, but are there any suggestions for getting the description imported so this doesn’t have to be done one-by-one?

    April 11, 2018 at 8:03 am #1504344
    Brendan
    Participant

    When importing the above file, not all of the events import and the fields start to shift into the wrong columns. As far as I can see, the CSV file properly escapes special characters by using double quotes “” and quotes around commas.

    April 12, 2018 at 11:41 am #1505881
    Sky
    Keymaster

    Brendan,

    I’m sorry to hear that you’re having problems with the CSV import. I will try to help you get this figured out.

    I took a look at your csv file, and I discovered an “&” that hasn’t been escaped. It is in “Ladies Sip & Swing 2018.”

    I changed the & to & and the csv then imported all the events correctly. So change the above to “Ladies Sip & Swing 2018”

    Edit: I am unable to get this to show without it being resolved into the “&” symbol. I am attaching a pic:

    I do see some characters that aren’t resolving due to non UTF-8 format, but that isn’t preventing it from importing.

    Give that a try and let me know if it works for you.

    Thanks,
    Sky

    April 12, 2018 at 11:45 am #1505891
    Brendan
    Participant

    Ok, good to know for the future. I was bumping up against a deadline so I went and added the descriptions manually but I will watch out for this.

    April 12, 2018 at 11:47 am #1505897
    Sky
    Keymaster

    Brendan,

    Great! Glad I could help.

    Let us know if you have any questions or issues in the future.

    Thanks,
    Sky

    May 4, 2018 at 9:35 am #1523043
    Support Droid
    Keymaster

    Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

    Thanks so much!
    The Events Calendar Support Team

  • Author
    Posts
Viewing 6 posts - 1 through 6 (of 6 total)
  • The topic ‘CSV Import failing on Description HTML field’ is closed to new replies.