Import error: date for all day events

  • Post date

Home › Forums › Calendar Products › Events Calendar PRO › Import error: date for all day events

Viewing 9 posts - 1 through 9 (of 9 total)
  • Author
    Posts
  • August 31, 2015 at 10:06 pm #1000778
    Tim
    Participant

    Hi all

    A bunch of imports on my site have imported with a start date of 1970.

    Here’s an example for an all day event

    10/24/2015 6:30:AM 10/24/2015 yes

    Seems to be no pattern for this?

    September 1, 2015 at 8:19 am #1000897
    Barry
    Member

    Hi Tim,

    Just to confirm – are you using the CSV import tool, or are you importing via WordPress’s XML-based importer, or something else?

    If it is the first of those – our own CSV import tool – would it be possible for you to share the actual CSV data, perhaps via Pastebin, Gist or some similar service (rather than dropping it directly into the forum)?

    Thanks!

    September 1, 2015 at 3:57 pm #1001050
    Tim
    Participant

    Hey Barrie
    Using the TEC importer (not WordPress).

    Can’t access pastebin from work, try this: Gist

    Should be able to copy and paste into Excel?

    Tim

    • This reply was modified 10 years, 7 months ago by Tim.
    September 1, 2015 at 8:24 pm #1001087
    Barry
    Member

    Hi Tim,

    Am I correct in thinking that you are using tab separation there (rather than commas)?

    Can you try using actual commas, or configure whatever application you are using to generate the CSV to do so and try again? I realize some applications like Excel default to tab-based separators, but it is usually configurable.

    Thanks!

    September 1, 2015 at 8:42 pm #1001092
    Tim
    Participant

    Try again Barry, same link!

    September 2, 2015 at 6:54 am #1001209
    Barry
    Member

    Thanks Tim, that looks a little better – the last thing to amend is the time formats. I’m afraid that:

    5:30:AM

    Is not understood by the parser – in fact it seems to confuse it completely! Can you alter any times like this and drop that final colon, so you end up with:

    5:30 AM

    Let me know if that helps!

    September 2, 2015 at 3:45 pm #1001496
    Tim
    Participant

    Thanks Barry
    This worked.

    I have reimported and all looks well, except instead of updating existing events, it created a lot of new ones.

    So I guess I’ll clear that DB table and reimport?

    Tim

    September 3, 2015 at 7:07 am #1001601
    Barry
    Member

    Sorry to hear that, Tim.

    Generally speaking it should intelligently update things but, perhaps due to formatting and other issues, it was unable to identify the earlier imports.

    In that case it may be better to delete the previous set of events and re-import them, yes.

    September 18, 2015 at 7:05 am #1006383
    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 9 posts - 1 through 9 (of 9 total)
  • The topic ‘Import error: date for all day events’ is closed to new replies.