Imports

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?

CSV

Follow these steps:

  1. Navigate to your organization page and then your group page.
  2. In the right side of your group page, click on 'Manage imports'.
  3. From the bottom of the list, click on 'Import events from a CSV file'.
  4. Select the appropriate group to import the events into, upload your csv file and click 'Save'.
Click on 'Manage imports'.
Go to 'Imports' overview from the right side link on the group page.

iCalendar

Importing events from Google Calendar

  1. Log in to an account that has access to the calendar.
  2. On the left, locate the calendar you want to import from.
  3. Click on the vertical triple dot icon next to the calendar name and select "Settings and sharing".
  4. Click on "Integrate calendar" in the left menu.
  5. Select and copy the "Public address in iCal format". It should look something like this:
    https://calendar.google.com/calendar/ical/fwefwg43gewgwef32rf23%40group.calendar.google.com/public/basic.ics
  6. 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.

  1. Log in to the profile you want to import events from.
  2. Go to https://www.facebook.com/events/.
  3. On the right side, locate the "Upcoming events" link and right-click it.
  4. Click "Copy link location" or "Copy link address".
  5. Paste the link into the URL field. It should look something this:
    webcal://www.facebook.com/ical/u.php?uid=100001565486451&key=fewWQERr32f-hRr2
Facebook events.
On your Facebook event page, locate the "Upcoming events" link and right-click it.

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:

  • start_date
  • end_date
  • address
  • address_extra_information
  • title
  • description
  • results

The rows after the first row contain the events to be imported.
Example:

1 start_date end_date address address_extra_information title description results
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

Required
Dates are required for each event and must match the ISO 8601 format: YYYY-MM-DD HH:MM.
Example: 2016-12-13 11:00

Address

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

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?

  1. First go to the import page.
  2. Click on Unpublish to unpublish the import and all its events.
Click on 'Unpublish'.
Unpublish your imported events.

When you unpublish your import, all its events are unpublished.