Import Updating Events That Are Not Duplicate

[accesswinnipeg]

Hello,

I am importing a Baseball Sports Schedule CSV…

There are times that the event title will be the same, ie:
Goldeyes vs. RailCats

becasue the Goldeyes will play the RailCats 6 times in a season.. but the dates will be different.

However, the CSV import plugin seems to be ‘updating’ instead of ‘inserting’ the multiple events even though they have different dates.

Is there a way to disable the ‘update’ feature temporarily so i can insert multiple events with the same event title but different start dates?

[Barry]

Hmm, sorry you’re facing difficulties.

What you’re describing should already be accommodated and if I test this out locally with some CSV that includes 3 events with the same name – but on different dates -they are indeed created separately.

Would it be possible to take a peak at your CSV data (perhaps you could share via a Dropbox link, or via Pastebin, or similar)?

Thanks!

[accesswinnipeg]

Thank for the reply Barry,
Here is my CSV data via Pastebin:
http://pastebin.com/M2YN3mts

[accesswinnipeg]

Please note that there is no end date for these events. just a start date and time.

[Barry]

Hi accesswinnipeg,

Unfortunately there appears to be an issue with the importer right now. By themselves the date and time formats you are using are just fine – when combined though they are effectively of a format PHP can’t use (or can’t reliably use … did you happen to note the date of any imported events was set to 1970? That may not have happened for all of them, though).

In the meantime, though it may not seem the most intuitive way to write down dates and times, can you use these formats and see if the situation improves:

• yyyy-mm-dd for dates (ie, 2014-04-28)
• hh:mm:ss for times, using 24hr format (ie 15:30:00)

Let me know if that works (and we’ll certainly log an issue to make some changes here).

[Barry]

@accesswinnipeg: actually (!) … I think I’ve misinterpreted what I was seeing – though it still boils down to an issue with date formats.

If you are going to use forward slashes such as “26/05/2014” you need to be mindful that this will be interpreted as month/day/year which may result in confusion as there is no 26th month. If you prefer dd/mm/yyyy notation, which is what you appear to be using, then you need to use hyphens rather than slashes: dd-mm-yyyy (otherwise the runtime cannot tell apart the two formats and in some cases there will be failures where the month is out of bounds).

I hope that clarifies things and sorry for the initial confusion!

[accesswinnipeg]

Thanks Barry, I reformed the dates/time in the raw file and everything imported properly this time.

[Barry]

Excellent!

[Author]

Posts