Importing Events

Locating the Import Template

  1. Navigate to the control panel
  2. Click on Site Content
  3. Click on Import
  4. Choose the type of content you want to Import from the enabled App list. Learn how to Enable an App

Content that can be imported will have a link to a downloadable excel spreadsheet template. (see image below)

event csv template image

Importing Events - Navigating the Downloadable Template

Events Template Site View
(zoom in for a closer look)
events template site view

Note: The first row is reserved for the field titles and optional taxonomy vocabulary fields. Do not remove or alter text in the first row from the template.

COLUMN A: Event Title
event title excel spreadsheet

COLUMN B: Event Body (Text Content)
Note: It is recommended to add the HTML version of your text in this field.

Please be aware if you are inserting a large amount of text here, the import might result in missing content because it will not be able to handle large amounts of text. Please avoid using ASCII characters in your text as this will result in import errors.events text excel spreadsheet

COLUMN C: Event Start Date & Start Time
NOTE: Date & Time must be entered as, Oct 2 2018 3:20pm or Oct 02 2018 3:20pm otherwise, import will stop and show error message.

events start date excel spreadsheet

COLUMN D: Event End Date & End Time
NOTE: Date & Time must be entered as, Oct 2 2018 3:20pm or Oct 02 2018 3:20pm otherwise, import will stop and show error message.

event end date time excel spreadsheet

COLUMN E: Event Location
event location excel spreadsheet

COLUMN F: Event Registration
If your event requires registration, type ON in the field, otherwise leave blank.
event registration excel spreadsheet

COLUMN G: Event Files (Images or documents)
Note: This field is optional. Files added here will import over as attached downloadable files.

Files should be entered here as URL paths.These files should already exist either on your site or on an external site. You cannot upload a local file from your computer here. To learn how to add files to your site prior to import, see Adding Files.
event files excel spreadsheet

COLUMN H: Event Created Date
Note: This field is optional.

Leaving this field blank will result in all imported events having the same date (date of import), this is different then the event start/end date.
event created date excel spreadsheet

COLUMN I: Event Path (URL Path)
Add the URL path ending here. For example, instead of adding help.theopenscholar.com/events/my-event, you'll just need to add my-event.
event link path excel spreadsheet

Importing more than 100 Events at one time is not permitted. If your CSV file is over 100 rows, you will receive an error.

Saving your CSV File

Make sure to save your CSV file using the UTF-8 file format to ensure that your contents are imported without issue.

The Import Process

  1. Navigate to the control panel
  2. Select Site Content
  3. Click Import
  4. Select Event
  5. Upload the event.csv file
    event file upload
  6. Click Submit
  7. Navigate to Site Content > Browse > Content > Type: Events to view events.

Import iCal File

  1. Click to Expand Site Content
  2. Click to expand Import and select Event
  3. Select iCal 
  4. Upload your iCal file 


     
  5. Submit.
  6. Go to Content in the Control Panel and the first entry will be your newly imported iCal post. 

Updated: 11Oct18