.csv import is overwriting the event title and location

[Krista]

Hello,

I’ll try and be as concise as possible 🙂

I am using Events Calendar to share events for a sports association. I have a calendar that is a consolidation of events for several teams, using category to filter the specific team. On any given night there could be events running at the same date/time at different locations (see my attachment in the next message), for different teams usually practices.

I know that category isn’t a value that ECP uses to verify uniqueness, so, in my UTF8 .csv file I concatenate the Category into the event title, knowing that the event title + date + time make it a unique entry. Here’s where it gets weird. No matter what the title, if the 2nd event has the same time/date, it overwrites the first.

Example (shown with spaces for ease of reading)

TITLE, Location, Start Date, Start Time, End Date, End Time
————————————————————————-
Peewee 3 COMP-Tryout ,Bell Centennial Arena,18-Apr-16, 6:00 PM, 18-Apr-16, 7:30 PM ~ SLUG: /event/tyke-3-Comp-Tryout/
Tyke 1 Practice, Johnny Leroux (Stittsville), 18-Apr-16, 6:00 PM, 18-Apr-16, 7:30 PM ~ SLUG: /event/tyke-3-Comp-Tryout/

As you can see from the above, the original entry becomes overwritten by the second in the import file – like it is ignoring the title all together on the second entry (even though it uses it to create the slug for the first).

And – to top it off, the location is changed to a location that isn’t one of the ones that is related to either of these 2 events as written in the import file.

Any ideas?

[Krista]

This reply is private.

• This reply was modified 10 years ago by Krista. Reason: Added link to WP sub

[Krista]

This reply is private.

[Krista]

Playing some more with this – it definitely looks like it is ignoring the title when it is importing and is only using the date time. If I change the start time from the 2nd line of the example to 6:01 PM the items import correctly and the slugs are properly reflected. Can you reproduce, and is there a pending bug fix?

TITLE, Location, Start Date, Start Time, End Date, End Time
————————————————————————-
Peewee 3 COMP-Tryout,Bell Centennial Arena,18-Apr-16,6:00 PM, 18-Apr-16, 7:30 PM ~ SLUG: /event/tyke-3-Comp-Tryout/
Tyke 1 Practice, Johnny Leroux (Stittsville),18-Apr-16,6:01 PM,18-Apr-16,7:30 PM ~ SLUG: /event/tyke-1-Practice/

[Nico]

Hi Krista,

Thanks for reaching out and also for the detailed report of the issue, which I could reproduce locally.

I’m also having some issues when importing venues, and looking at your other report I guess we might be hitting some issues with the csv file. I’ll run some additional tests on this, and let you know about the issue.

Playing some more with this – it definitely looks like it is ignoring the title when it is importing and is only using the date time. If I change the start time from the 2nd line of the example to 6:01 PM the items import correctly and the slugs are properly reflected.

I could also reproduce this and find it probable that the importer is using the event start/end dates and times to see which event it should override. I’ll dig into the code of the plugin to see if this is correct and to see if there’s any chance of changing this behaviour.

I’ll be back to you when I have a chance to take a deeper look at this issue,
Best,
Nico

[Krista]

Thanks Nico. I have also validated that if I change the end times I can import them as well.

[Krista]

This reply is private.

[Nico]

This reply is private.

[Nico]

Hi Krista,

Thanks for the patience here! The issue in this thread and in the other one you created seems to be caused by the same bug. Please be sure to check my last reply about the fix.

Do you think we are good to close this one and continue our communication in the other one which is being followd by two more users?

Please let me know about it,
Have a great weekend,
Nico

[Nico]

Hi there,

Just wanted to inform that maintenance release 4.1.3 is out. The update includes a fix for this issue.

Please update the plugins to the latest version and re-test to see if the fix works for you.

Best,
Nico

[Support Droid]

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