Mass import of previous events

[lgel-sw]

We have just imported our database of contacts into our CiviCRM install (some 30k). Each person we know from a 'source' - which is most often an event (~700 uniques). I found that I can import participants, once the events have been added.

Is there a way to mass import the previous (~700) events? I only have a title of the event, but could make up a date, type and status I guess. Doing this import manually would be a big pain...

[Michael McAndrew]

Hey there,

You can't import events via the UI, I am afraid.

If you have command line access, ane workaround I am aware of is the following

Have a look at https://github.com/civicrm/civicrm-core/blob/master/bin/csv/import.php and https://civicrm.org/blogs/xavier/api_batch_tools

The blog post should give you good background, and the github link the latest syntax.

Not sure how techy you are / if this is the kind of answer you are looking for, but hopefully it helps you.

[Fabian_SYSTOPIA]

Also, this Extension may be helpful: https://civicrm.org/extensions/api-csv-import-gui

In case you use the extension, I would appreciate a short feedback on how it went as we may need to do a similar task soon ourself

[Michael McAndrew]

Wowser - that extension slipped me by (and it looks v. cool)

[CiviTeacher.com]

I found that use of a PHPMyAdmin tool allows you to easily import simple event information via CSV such as: start date, title, etc into the civicrm_event table within the CiviCRM database.