You may want to create many events at once, for example from Google Spreadsheets. To accomplish this, you can create a CSV file and import it to your group.
On this page:
- How do I import events?
- How should a CSV file be formatted?
- Timezones and dates
- How do I delete imported events?
- How do I unpublish imported events?
How do I import events?
Follow these steps:
- Navigate to your organization page and then your group page.
- In the right side of your group page, click on 'Manage imports'.
- From the bottom of the list, click on 'Import events from a CSV file'.
- Select the appropriate group to import the events into, upload your csv file and click 'Save'.
Importing events from Google Calendar
- Log in to an account that has access to the calendar.
- On the left, locate the calendar you want to import from.
- Click on the vertical triple dot icon next to the calendar name and select "Settings and sharing".
- Click on "Integrate calendar" in the left menu.
- Select and copy the "Public address in iCal format". It should look something
- Paste the link into the URL field.
Importing events from Facebook
Note: Facebook does not offer iCalendar support for group pages. To import
events from a Facebook group page, you can create a Facebook profile and invite
that profile to any events from your group page that you want to import.
- Log in to the profile you want to import events from.
- Go to https://www.facebook.com/events/.
- On the right side, locate the "Upcoming events" link and right-click it.
- Click "Copy link location" or "Copy link address".
- Paste the link into the URL field. It should look something this:
How should a CSV file be formatted?
A CSV file must adhere to the following format.
The first row must contain the following column names:
The rows after the first row contain the events to be imported.
|2||2016-12-13 11:00||2016-12-13 13:00||Kultorvet, Copenhagen, Denmark||By the fountain||My custom title||My custom description||leafleting | 4 | 0 | 1 | 0 | 1000 | Flyer design B|
Start date and end date
Dates are required for each event and must match the ISO 8601 format: YYYY-MM-DD HH:MM.
Example: 2016-12-13 11:00
The address of an event should be a proper address.
Any extra location information, such as "By the fountain", "Room B", etc. that aren’t part of a real address should be added to the address_extra_information column instead. If possible, use addresses with city and country appended.
Example: Grenzacherstrasse 10, Basel, Switzerland
Results consist of six values:
- import name of result
- participant count
- duration in minutes, hours, days
- quantifiable result value
Values are separated by the "vertical bar" character ( | ). Each row can contain
another result for the same event.
Example: leafleting | 9 | 30 | 2 | 0 | 4000
This reads: a leafleting result | 9 participants | duration: 30 minutes | 2 hours | 0 days | 4000 leaflets
Timezones and dates
The dates of events will be imported relative to the selected groups timezone. For example, if the imported event has a start time of 11:00 am, and the group selected for the import has the timezone "Europe/Copenhagen (UTC +1)", the start time will be 11:00 am (UTC +1).
How do I delete imported events?
You cannot delete imported events, but you can unpublish them, making them unaccessable to anyone but managers of the organization that the events belongs to.
How do I unpublish imported events?
- First go to the import page.
- Click on Unpublish to unpublish the import and all its events.
When you unpublish your import, all its events are unpublished.