Adding the Common Worship Lectionary to your calendar

We've found a great website that makes the Common Worship Lectionary freely-available as a CSV format file, and that works seamlessly with the Calendar module's event importer - it's available here.

From the Home page, click into the Download area.

Select the correct liturgical year and tick the lectionary options you require.

At the end of the page is a section where you can select the download type - select Outlook csv file and click Fetch Almanac. Do consider making a donation to support the ongoing service they provide. Save the CSV 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.

ChurchSuite now displays a preview of the first 5 records in your CSV file so that you can 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 your 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 the Lectionary import, only the Subject, Start Date and Description fields are important - 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 needs to be imported into the event "Name" field in ChurchSuite. The yellow warning triangle will disappear once an Import As field has been selected.

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 next to their name. 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 an opportunity to fix or remove the invalid data.

Continue working through and resolving each error in the list. Note that you can Pause or Cancel an event import at any time. You can also Process event 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 surfaced on the Imports tab. From here you can Resume or Cancel 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 your lectionary, the file may take a few moments to process. Once successfully completed, the imported Lectionary events are grouped together in an Import category - located in the Categories section of the module. You may find it helpful to rename the category to something like "Lectionary".

Filtering your Calendar by the "Lectionary" category will display your successfully imported Lectionary!

After import, the Lectionary will be visible to Calendar module users. However, you can optionally increase visibility to those viewing your events calendar in My ChurchSuite, Connect and/or Embed - simply filter the Events section by the "Lectionary" category (in the Advanced Search), select all events and then use the batch Actions to Edit and change the Visibility settings of the selected Lectionary events.

Still need help? Contact ChurchSuite Contact ChurchSuite