Adding the Common Worship Lectionary to your calendar
We've found a useful website resource that makes the Common Worship Lectionary freely available as a CSV format file, and works seamlessly with the Calendar module's event import functionality - it's available here.
From the Home page click on the Download area.
Select the liturgical year and expand/select the Lectionaries, Collects and Other options as required. Then click CSV download and follow the on-screen instructions to save the file to your desktop.
You're now ready to import the file!
Import the Common Worship Lectionary into your calendar
From the Events section of the Calendar module, click Import events.
Click Choose file and navigate to and select the CSV file you prepared earlier. Then click the Upload CSV File.
A preview of the first 5 records in the CSV file is shown, enabling you to check that the CSV Header fields are correctly mapped to the right field in ChurchSuite - the Import As column shows which field in ChurchSuite the data from the CSV file will be assigned to. Any CSV Header fields not matched to a ChurchSuite field are distinguished by a yellow warning triangle and will not be imported...
For a Lectionary import only the Subject, Start Date and Description fields are relevant - we'll ignore the other two headers. Use the drop-down Import As selector to choose the correct ChurchSuite field that the CSV Header item should be mapped to. As shown below, "Subject" is not a recognised CSV Header and should be imported as the event "Name" in ChurchSuite.
Once you are satisfied that all CSV Header fields will be Imported As the correct field in ChurchSuite - as shown below - click Import All Records to complete the import. Alternatively, click Cancel if you discover an issue that needs to be addressed in your CSV file.
The import progresses to the Preview/Edit stage. Valid events are distinguished with a green tick. Invalid lectionary events requiring attention are distinguished with a yellow warning triangle and details of the Errors are provided. You can View, Edit (to fix the invalid data) or Remove an event from the import.
Typical lectionary errors are long event names that exceed the max. 100-character limit supported by ChurchSuite. Selecting Edit for an event with an error will surface full details of the invalid data, providing you with an opportunity to fix or remove the invalid data. Note that you can Pause or Delete an event import at any time. You can also Process events at any time - only valid events will be processed and imported; invalid events with errors will remain in the "Preview/Edit" until resolved or removed.
To resume a Pending import, click Import events from the Events section of the Calendar module. Partial/incomplete imports are listred on the Imports tab. From here you can Resume or Delete a partial import. Resuming an import takes you back to where you last left off.
Having resolved all remaining errors you can now Process to complete the import. A success message confirms the completion of a successful import.
Depending on the size of the lectionary it may take a few moments to process. Once completed, the imported Lectionary events can be seen grouped in a new event Category called "Imported" - located in the Categories section of the module. You may find it helpful to Edit and rename the category to "Lectionary".
Filtering your Calendar by the "Lectionary" category will display your successfully imported Lectionary!
The Lectionary is visible to Calendar module users only. However, you can optionally extend lectionary event visibility to those viewing your events calendar in My ChurchSuite, Connect and Embed. To do this, use the Advanced search to filter the Events section by the "Lectionary" Category, select all events and use the batch Actions to Edit and change the Visibility settings of the selected Lectionary events.
