The CollegeNET event import service allows you to import events into 25Live from any non-SIS third party data source (for example, Outlook) provided you can convert them to CSV format.
There are three steps to the import.
- Create a CSV file of the events you want to import, following specific formatting rules.
- Import the CSV file using the instructions below.
- Review and correct any error and warning messages from the import.
The primary purpose of this process is for one-time imports of large amounts of events, such as when you are converting from another calendar system. However, the import process can be used to update/overwrite existing events as long as they share an EVENT_ID. (Note: this can only be used to update events that were previously imported through the same process.)
Note: Required preparation
Make sure you have all of the following before beginning the import process:
- The import requires a username in the System Administrator (-1) security group.
- CSV import must be enabled for your environment by CollegeNET. Contact your Series25 account manager at firstname.lastname@example.org for more information.
- We recommend using a good text editor with global search and replace functionality (such as Notepad++) as well as a spreadsheet program capable of exporting to .csv (such as Microsoft Excel, Open Office Calc, or CSVed).
Importing a CSV File
Follow these steps to import events into 25Live:
- Select the Data Import Tool from the Go to Tool section of the 25Live More menu.
- In the top-right of the Data Import Tool dashboard, select Import Events CSV
- Click Choose File to find and select the CSV file containing the events you want to import into 25Live. See CSV Event Import Formatting Guidelines for instructions on formatting this file.
- Once a file is selected, click Import File.
- If the file is improperly formatted, you will receive the following message: *.csv was not uploaded successfully. Please ensure that you are using a valid CSV file. Check the file, ensure that all the column headers are correct, and contact email@example.com for further assistance with formatting.
- If the file is accepted, congratulations! You will receive an email with the details of the import. Continue to the next step to determine if there are any import warning or error messages that require your attention.
Check your email inbox for a message with the import results. This message can be a little technical if you are unfamiliar with it, so here's a closer explanation of its contents.
The import process for group [Import ID = 2381] into SaaS environment 'yourschool' has been completed on 2020-12-28T11:22:21.820-08:00.
- The Import ID can be helpful if you need to contact Support with issues about the import that are deeper than formatting problems.
- The SaaS environment name indicates whether you imported to a production or test environment. Test environments end with an extra 't'.
Out of a total of 100 event(s):
80 loaded successfully without issue
15 loaded with warnings
5 failed to load due to errors
- If your CSV file included more than 500 events, they may be split up into separate import processes with their own email notifications.
- Warnings indicate that some portion of an event could not be imported as described in the file.
- Errors indicate that an event was not imported at all, usually due to problems with the event type or the date.
For a quick view of import errors/warnings for the events, which are transformed to vCal format, in [Import ID = 2381]:
For more detail regarding vCal import errors/warnings in general, see:
Check for Import Problems via 25Live
This automated message was sent to firstname.lastname@example.org by CollegeNET SaaS Support.
- The WebServices link returns all the warning and error messages from the import. You can see the same messages (as well as messages from other imports) in the Series25 Import Messages area described below.
- In addition to the help article linked in the email, please also see CSV Event Import Error and Warning Messages for import messages.
- Alternatively, you can run the SIS Import Messages report in 25live Reports for errors and warnings.
- Update your CSV file with any necessary changes and follow the steps above again to reimport it. You may find it more efficient to edit your CSV file and only reimport the events that had warning or error messages.
If you've run through the directions and are still experiencing issues, please contact our Support team.