[Plugin: Events Manager] Bulk Import Event Upload

Wow guibo! That is totally amazing! I owe you! All I need to do now is to figure out how to map the event start date and time – couldn’t see how to map this (and therefore what fields I need in my csv file for date and time)…. but can see it defaults to adding the import date and time – any clues welcome!!

Marcus and Guibo – I have had another look at this. Essentially I cannot see (when the list of fields is listing for mapping purposes) a field for time or location. So I cannot eg map the event time in the csv file to the event time in the event record it will create. I do however see there is a custom field creator – but do I need to know the exact format to use in each case for this to work? I believe I need
Start date
End date
Start Time
End Time
Location name
Location address
Location town
particularly as without some of the above I cannot make a event live anyway. Also, what format of date is required to be accepted?

Masses of questions but this MAY, if it can work, be an incredibly useful partner to your won excellent software and avoid the need for your own development work??? And useful to many people too?

take a look at our wp_em_… tables

the field names match those, but with a _ prefixed, so e.g.

Start Date = _event_start_date

Thanks very much and once I know this can work I will happily buy the pro version of course.
I do not know where to find the “our wp_em_… tables” (pointer?) but I tested the start date in the meantime. First problem was that dates are assumed to be in American format (WP Ultimate CSV Importer is American maybe) but I was able to resolve that by changing the format round in the source csv file. It worked! BUT, although it shows the start date correctly on the list of events imported, it doesn’t seem to have been added correctly into the record itself, which still shows a blank start date. ie when I try to “publish” (setting aside the absence of location details for the moment!) it prompts me to use the date picker…….
Should I give up or keep trying? Obv need to pay for your time at some point too!!

Further to the above – I have now tested start and end TIME and theywork beautifully and update the record correctly..

tashminia-
I assumed you were able to bulk upload? If so, how did you handle the post_id and event_id columns?

Hi – no I am afraid I gave up because I didn’t know what to do about the dates not being added properly….. I am now trying a different plugin which has an auto upload from an ics file url but that has problems too! I will get there in the end!!

It is a great plugin with all the formatting features etc. But if you don’t use the booking part and can’t upload a slew of events for readers, it seems to just create more work. But it is nice to cross reference entries throughout your blog with shortcodes.

I once tried to use another very cool calendar with smooth info transitions and pop ups etc., but unfortunately it clashed with something else and broke my site (be careful which calendar you add!)

So yes, please please get an import feature.
But still a great plugin otherwise.

Using xlsx and some php please find a work in progress plugin here :

https://github.com/soixantecircuits/wp-events-manager-importer

Please watchout this is a alpha and does not support lots of “import” features… stills it allow to be faster on importing events.

Cheers..

p.s: not in the wordpress depot because code not fully cleaned up and tested.

thanks for sharing;

@gabrielstuff
Do you have any documentation about your importer?

I want to know which fields are imported?
A – Title
B – Place?
C – Date?

Your plugin breaks RSS-Feeds.

I’m getting the error: “”line 1, column 1: Blank line before XML declaratio”” when validating my rss feed.

Found the solutiong edit wp-events-manager-importer-master/emi.php:
and delete last 2 empty lines