CSV import is not complete

  • Post date

Home › Forums › Calendar Products › Events Calendar PRO › CSV import is not complete

Viewing 14 posts - 1 through 14 (of 14 total)
  • Author
    Posts
  • July 15, 2015 at 9:31 am #986662
    Thomas
    Participant

    Hello, I am trying to import a csv file. The CSV Importer works and reports that the events were imported but I can not find the events in the overview. Only some events I can see. There is a CSV file with about 320 events. Can you help me?

    July 15, 2015 at 9:34 am #986663
    Thomas
    Participant

    Import Ergebnisse

    This is the message after importing:

    Import abgeschlossen!

    Eingefügt: 311
    Aktualisiert: 16
    Übersprungen: 0
    Die Import Statistiken oben bedeuten folgendes:

    Eingefügt:: Ein neues Element wurde erfolgreich eingefügt.
    Aktualisiert: Ein Element mit dem gleichen Namen und/oder Startdatum wurde gefunden. Das existierende Element wurde mit den neuen Werten aus der Datei aktualisiert.
    Übersprungen: Es wurde eine Zeile in der CSV Datei gefunedn, weche nicht importiert werden konnte. Unten finden Sie mehr Informationen zu den ungültigen Zeilen.

    July 15, 2015 at 3:15 pm #986800
    Barry
    Member

    Hi Thomas,

    I’m sorry to hear you have hit up against some problems.

    Eingefügt: 311
    Aktualisiert: 16
    Übersprungen: 0

    So it sounds like 311 new events were created and 16 existing ones were updated – 327 events in total. I can’t view your site without credentials as its protected by HTTP authentication, but I’d love to take a look at your main events page and also perhaps see a copy of your CSV data.

    Note that while you cannot upload files directly to the forum at this time, if you upload them to your WordPress site or a service like Dropbox you can then link to the download URL via a private reply.

    Can you facilitate that?

    July 15, 2015 at 10:53 pm #986886
    Thomas
    Participant

    This reply is private.

    July 16, 2015 at 6:53 am #986949
    Barry
    Member

    Hi Thomas,

    Can you give me the direct URL for your main events page? For some reason I seem to be landing on what looks like a non-WordPress site and cannot navigate to the events page.

    Thanks!

    July 16, 2015 at 10:26 pm #987296
    Thomas
    Participant

    This reply is private.

    July 17, 2015 at 7:06 am #987354
    Barry
    Member

    Oddly, it seems to randomly drop back to a different (non-WP) site as I navigate across it, but thanks – I’m able to take enough of a look.

    In any case, I’d suggest trying this one more time – however you need to save your CSV data in UTF-8 format (as described in the CSV import screen):

    Upload a properly formatted, UTF-8 encoded CSV file. Not sure if your file is UTF-8 encoded? Make sure to specify the character encoding when you save the file, or pass it through a conversion tool.

    Right now it appears to be encoded using some other scheme.

    Can you give that a try?

    July 20, 2015 at 9:01 am #987871
    Thomas
    Participant

    This reply is private.

    July 20, 2015 at 9:42 am #987881
    Barry
    Member

    Hi Thomas,

    You’re welcome to use private replies but can I ask you reserve them for those occasions where you are sharing confidential information (for instance, a URL you prefer not to disclose publicly)? When overused, private replies tend to render forum topics unreadable for other members of the community who might benefit from them in the future 🙂

    The web-tool on your side is not working properly with my file. So I have to try on and still need some time. Do you have any tip?

    Sorry to hear that.

    How are you creating the file in the first place – does that application you are using provide any options to change the way the file is saved?

    July 20, 2015 at 10:24 pm #988237
    Thomas
    Participant

    unfortunately there are no options for the export in csv

    July 20, 2015 at 10:55 pm #988240
    Thomas
    Participant

    This reply is private.

    July 21, 2015 at 6:07 am #988302
    Barry
    Member

    Hi there!

    So although there are different definitions of CSV, it’s important to note that The Events Calendar insists on commas for separation between fields, rather than semi-colons.

    In the case of the file you linked to there, you are using semi-colons (and I would be surprised if it imported correctly).

    So, to summarize, besides being UTF-8 encoded the data needs to be in this sort of format:

    Title,          Start Date,  Start Time, ...
My Event,       2015-08-01,  12:00, ...
Another Event,  2015-08-15,  15:00, ...
Something Else, 2015-09-02,  08:00, ...

    Does that help?

    July 22, 2015 at 3:00 am #988765
    Thomas
    Participant

    Hi Barry,
    yes, now the import works properly.
    There is a useful tutorial for saving a CSV file as UTF-8:
    http://www.csvimproved.com/de/frequently-asked-questions/916-save-a-csv-file-as-utf-8
    Thank you very much
    Best regards
    Thomas

    July 22, 2015 at 7:04 am #988830
    Barry
    Member

    Great, I’m glad it’s all resolved (thanks also for sharing that link) 🙂

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