CSV import not working at all

  • Post date

Home › Forums › Calendar Products › Events Calendar PRO › CSV import not working at all

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • June 2, 2016 at 12:50 pm #1121813
    eva
    Participant

    Hello

    I have tried too many times. I am attaching this file, it is supposed to be venues. When I click import, it says PK.

    I saved with UNI 8 in Numbers.

    Thanks

    Eva

    June 2, 2016 at 10:07 pm #1122041
    Geoff B.
    Member

    Good evening Eva and welcome to the Events Calendar Support forum!

    Thank you for reaching out to us.

    We are sorry to hear about the difficulties you have been experiencing with the CSV import.
    I would love to help you with this topic.

    As a first troubleshooting step, could you please provide us with your complete system information in a private reply using the instructions found in the following link?

    https://theeventscalendar.com/knowledgebase/sharing-sys-info/

    Secondly, would it be possible for you to send me a link to the CSV file you are using (through something like google drive or Dropbox for example) ? This way I could run some tests with it.

    Best regards,

    Geoff B.

     

    June 3, 2016 at 9:17 am #1122219
    eva
    Participant

    This reply is private.

    June 3, 2016 at 11:41 pm #1122451
    Geoff B.
    Member

    Hello Eva,

    Thank you for your answer, for the system info (although a piece seemed to be missing (when you scroll down from that screen) and the file sample.

    I believe I have found the cause of the issue.

    When you open the CSV file, there seems to be an extra column at line

    Telemark Døveforening Tordenskjoldsgt. 15 Døves Hus Porsgrunn 3921 Norge http://www.tedf.no

    If you correct the file by deleting Porsgrunn (or moving it elsewhere in another existing cell) AND by moving every following cell back to the left, the number of columns for each row will be the same and the file will work.

    Telemark Døveforening Tordenskjoldsgt. 15 Døves Hus 3921 Norge http://www.tedf.no

    Let me know if that helps.

    Have a great day!

    Geoff B.

    June 6, 2016 at 8:50 am #1123030
    eva
    Participant

    This reply is private.

    June 6, 2016 at 12:32 pm #1123138
    Geoff B.
    Member

    Good afternoon Eva,

    Please try the following csv file that contains the fix: https://www.dropbox.com/s/g1wqhkelvpddvm7/test-data-venues111_fixed.zip?dl=0

    I have tested this and it works great.

    As stated earlier, there is an issue with a specific line that’s causing an extra column.

    Let me know how that goes.

    Best regards,
    Geoff B.

    June 21, 2016 at 9:35 am #1129932
    Support Droid
    Keymaster

    This topic has not been active for quite some time and will now be closed.

    If you still need assistance please simply open a new topic (linking to this one if necessary)
    and one of the team will be only too happy to help.

  • Author
    Posts
Viewing 7 posts - 1 through 7 (of 7 total)
  • The topic ‘CSV import not working at all’ is closed to new replies.