This article is best for system administrators. Too small? Click here.
Editing Events in Bulk
We maintain a page where you can export, import, update and delete events in bulk. You can download a set of events (CSV) from this page to a spreadsheet, edit the events on that spreadsheet, and then upload it back to PlusPlus.
As an admin, you can view the Events import/export page by navigating to Menu > Dashboard > Events, and clicking the Bulk Import button at the top. There, you can filter the results by event name and date/time range.
(Please note: the Events Dashboard at Menu > Dashboard > Events only allows exports and is not formatted for input. Use only the Bulk Events page listed above for this process.)
Once you have the set of events you want, click the “Export CSV” button on the upper-left. Your browser will download a report in CSV (Comma-Separated Value) format, which you may view using any spreadsheet editor.
Guide to columns:
– ID: Unique identifier of this event in PlusPlus. If empty, we’ll create a new event. Otherwise, we’ll attempt to update the existing event corresponding to that id.
– Event Type: Name of the event type that this event is part of. It needs to exactly match the name of an existing event type.
– Name: Mandatory field. Event name.
– Presenters: Comma-separated list of presenters’ emails.
– Organizer: Mandatory field. Email of the event organizer.
– Co-Organizer: Email of the event co-organizers.
– Description: Event description, in text or HTML format.
– Cover: URL to the cover image. Ideal size is 640×360.
– Topics: Comma-separated list of Categories.
– Timeslot: Mandatory field. Comma-separated list of timeslots in format of m/d/yyyy h:mma, (e.g 3/16/2018 9:00am)
– Duration: Total duration of this event in decimal hours, e.g. 4.5.
– Room: Name of the room where the event takes place. Please note: if you have the settings “Enable Google Calendar Resources for Events” or “Enable Google Calendar Resources for Coaching Sessions” activated at Menu > Settings > Calendar Integration, you can not change this field if you want to import the file.
– Extra Info: Text field for any additional event info; this will be included in the notifications triggered by the event.
– Location: Mandatory field. Name of the event location. It needs to exactly match the name of one of the existing locations on your system.
– Enrollment Link: URL to the site where attendees would complete the enrollment, if applicable.
– Enrollment Instructions: Instructions to attendees on what to do to complete the enrollment.
– Enrollment Cap: Maximum attendees allowed In Person. 0 means no limit.
– Waitlist Cap: Maximum size of the Waitlist for In Person Events. 0 means no limit.
– Online Enrollment Cap: Maximum attendees allowed for Online Events. 0 means no limit.
– Online Waitlist Cap: Maximum size of the Waitlist for Online Events. 0 means no limit.
– Enrollment Opens: How early users can enroll to the event. Can not be changed.
– Private: If set to 1, this event is private. 0 means it’s public.
– Is Online: If set to 1, this event can be attended online. 0 means It cannot be attended online.
– Is In Person: If set to 1, this event can be attended in person. 0 means It cannot be attended in person.
– Watch Link: The link to view the event online, if available.
– DELETE: If set to 1, we’ll attempt to delete the event with this event id. 0 means to nothing.
To edit data, you first need a properly formatted CSV file. The easiest way to get such file is to do an export first (see above). You can then remove the records that you don’t care about changing.
Then, you can perform any of the operations on the spreadsheet:
Modify events: You may change the data on any of the columns except for Id. However, some of the other columns have other restrictions; see the above list for specifics.
Create new events: By leaving the Id column blank, that row will be interpreted as a new event. The only mandatory fields are Name, Date, and Location.
Delete events: If the Delete column is set to “1”, the event with that Id number will be deleted.
Importing the data is a three-step process:
Load up the CSV filter: At Menu > Events, click “Choose File”, select the edited CSV (ensure that the file is in *.csv format), and wait for the blue bar to fill, indicating that the file is ready. Then click “Import CSV”.
Check for any errors: At the next page, you may see a list of errors and warnings. If so, navigate back, correct the mistakes in your file, save it, and go back to Step 1. If there are no errors, you will see the message “No errors found. Proceed?”, and you may go on to Step 3.
Proceed with the import: Click “Run Import”. If successful, you will see a message telling you how many events were created, updated, and deleted.
Disclaimer: Our platform only supports creating/editing/deleting up to 150 events at a time. To edit more than 150 events, you need to split them into multiple CSV files with up to 150 events and upload one by one.
Notes on columns
If the event doesn’t have a Cover URL, the import process will get the image from the Event Type, if there’s one specified.
The columns Duration, Room and Extra Info must have one entry, or the same number of entries, as the Timeslot column. If they have the same number of entries, they get mapped to the corresponding session. If they have only one entry, they will be replicated to each timeslot. If any of those columns have a different number of entries an error will arise.
If you are creating a new event, specifying the Event Type will import the cover image from that type into the new event. Later changes to the Event Type will not propagate to previously-created events.
An event will be deleted if the Delete field is set to 1. The id field will represent which event to delete.
If you want to leverage the info that's already available at the event type level so that you don't have to repeatedly use redundant info in the CSV file, set the field to [inherit]. This helps to treat the event type as the source of truth for this common info and helps to accidentally "overwriting" it for the events. The inheritable fields are: Name, Presenters, Organizer, Co-Organizer, Description, Cover, Topics, Location, Enrollment Link, Enrollment Instructions, Enrollment Cap, Waitlist Cap, Online Enrollment Cap, Online Waitlist Cap, Private, Is Online, and Is In Person.