Import Reoccurring Events via CSV

[cevans]

Is there a way to import reoccurring events through a CSV?

[Andras]

Hi cevans,

Unfortunately importing recurring events is not possible, neither from CSV, nor from any other source.

To be exact, from other sources you can import recurring events, but they will be imported and single events, not as a series.

Sorry.

Cheers,
Andras

[cevans]

Is there any way to do it through direct SQL scripting?

I guess my question is, which tables are touched and with what meta data when a reoccurring event is created?

[Andras]

It’s kinda tricky but you can definitely try.

When you create a recurring event, then the following happens.

An entry in wp_posts will be created for every occurrence, where the parent_ID is the ID of the first event. (screenshot)

All events will have an entry in wp_postmeta with serialized data of the recurrence rules, like this: https://cloudup.com/cY96_XLsU16

And of course all events will have their other regular metadata: https://cloudup.com/cnM3JTGUoxs

I think this is about it.

Andras

[cevans]

Is it possible to use the REST API to create recurring events?

[Andras]

No, that is not yet possible. 🙁

A.

[cevans]

Is there any way you can send over the data requirements in something other than image files? The last one came through too small to see anything.

[Andras]

I’m sorry it didn’t go through right before. Here it is anew: https://cloudup.com/cDoXRgc8CdP

You can get this info from the database by creating a recurring event, then selecting from wp_postmeta the entries where the ‘post_id’ = the ID of the recurrence.

Hope this helps.

Andras

[Support Droid]

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

[Author]

Posts