CSV imports and duplicate events

Home Forums Calendar Products Event Aggregator CSV imports and duplicate events

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #1384145
    Sally Richardson
    Participant

    Hi – I use the csv import to import events into the calendar from our Access database.
    This used to work extremely well, but I now find that duplicate events are often being created.

    Example A: I import an event with no start time – marked as an all day event. I then import the same event again but with the start time now included. Result: the import will no longer recognise the event as being the “same one” but with an amendment – and instead creates a duplicate event.

    Example B: I import an event with no venue. I then import the same event again but with the venue now included. Result: the import will no longer recognise the event as being the “same one” but with an amendment – and instead creates a duplicate event.

    In the past this worked beautifully: if the event title was still the same and on the same date it simply updated the record if the start time changed or the venue changed -but no longer!

    Please could you tell me:
    a) what criteria is used with the CSV import to determine whether an event already exists? Event title plus date plus??
    b) perhaps I need to have a unique identifier for each event? I can easily provide this within the CSV file as our database holds a unique ID for each event – but I have not seen this as a field on the CSV import?

    Many thanks!

    #1385271
    Cliff
    Keymaster

    Hi, Sally. Sorry you’re experiencing this.

    If this is the bug I’m thinking it is, it was introduced as of The Events Calendar version 4.4 — does that possibly ring true with your experience?

    FYI: I marked this thread as Pending Fix, which means it should receive a reply once the applicable fix has been released. I cannot guarantee when it will be fixed as it’s in the development team’s hands now. They need to assign it, code it, test it, and schedule it for release.

    I apologize for this issue and appreciate your understanding and patience.

    #1386442
    Sally Richardson
    Participant

    Hi – thanks for your help. It is hard to tell whether or not it started around that time…..
    Can you tell me a little about the specific bug though, so that we can be confident my problem will be resolved when the bug you mention gets fixed? Is is only with CSV imports, or more general? Or just send me a link to a thread which covers it? Many thanks!

    #1388740
    Cliff
    Keymaster

    The bug is specific to CSV importing. Basically, it doesn’t have the logic to detect if a likely match exists (i.e. avoid duplicate and update vs. create new every time and possibly create duplicates).

    That’s as much as I’ve got for you. I hope it helps in some way.

    #1520588
    Victor
    Keymaster

    Hi Sally!

    Just wanted to share with you that a new release of our plugins is out, including a the tribe_events_import_event_duplicate_matches filter that facilitates the addition of some matching rules to prevent duplicates.

    Find out more about this release → https://theeventscalendar.com/maintenance-release-week-15-april-2018/

    Please update the plugins and let us know if the fix works for your site.

    Best,
    Victor

    #1537186
    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

Viewing 6 posts - 1 through 6 (of 6 total)
  • The topic ‘CSV imports and duplicate events’ is closed to new replies.