Import Events

[lanetterm]

The interface does not seem to provide a way to import events into civicrm. I am comfortable doing this kind of work at the database level. I was looking for documentation or someone with information on what tables besides the event table will need to be touched. Specifically, when an event is created what records in what tables are created?

thanks for any help

lanette

[Kiran Jagtap]

Hello lanetterm,

We use civicrm_event table to store event data.

Instead of direct firing queries on db,  I'd recommend to take a look for our event api's
which would allow you to create events.

kiran

[lanetterm]

If this was something I would be doing frequently the api would be the way to go. But this is just a one time import of events. Approximately 1500 of them, more than I want to manually add. I wanted to figure out what exactly is created when an event is created, so that I can recreate that.

thanks again

lanette

[DerekL]

I had a similar situation, ended up using D7's Batch API along with Civi's API3. End result was pretty nifty, and painless though it doesn't have the field matching,error handling, or progress bar niceties the built-in import tools show off.

[Donald Lobo]

hey derek:

would be great if you could publish this code on github under a nice open source license I suspect a few people will be able to build on it and use it for their needs and potentially improve it

lobo

[DerekL]

I'm in the process of porting the lessons I learned over to participations and event contributions imports as well, when that's done I'll release so that it can be crowd-improved, my code is entry level but well documented.

[jdaniluk]

Here's one person that would like a way to do a one-time import of events.  I'd like to import about 250 past events.  I don't need to import the participants, and I can ignore the fees, but I do need to be able to import some custom event fields.

[sonicthoughts]

Was wondering if there was ever an import event script written?  tempted to go right into the db .

[mwurpts]

Can anyone provide some guidance for us to do this? We have 140 past events that we need to import along with participants. We are not concerned with fees. We just want a consistent record of participation with contact information.

Can I just add a record to the civicrm_event table to add an event? All fields look pretty straight forward, except I'm not sure what to do with: loc_block_id. Or, are there more tables that are affected?

Thank you.

[Laryn]

This extension may help anyone who comes to this thread looking for help on importing events:
API csv Import GUI

This extension facilitates uploading CSVs via the CiviCRM import interface. Useful for bulk uploading events or campaigns etc...