This is a description of the annual calendar load, as of 2007.

We are using the node_import module. The input to this module is a CSV file. Each line has to contain:

start,end,title,categories

start and end are timestamps in the format:

yyyy-mm-dd hh:mm

The categories are the names of the categories from the Calendar Event Types list. You can list these with admin/taxonomy/4. Multiple categories must be separated with vertical bar (|) characters.

If the end field is empty, the event is treated as whole-day.

Before loading the calendar, you have to (a) clean out all the old calendar entries and (b) disable the jscalendar module from the admin/modules page. After loading, you have to re-enable jscalendar.

Deleting the old entries requires a somewhat dangerous recipe. I think it best to state that a qualified person who googles the problem will find the recipe. I'm squeamish about leaving it here.

To load, you open the admin menu, click on content, then click on the import menu item that appears, and work along the wizard.

Note that I've never been given the right format. I've written a series of python scripts that allow me to save from Excel into a CSV file and then fix that file up to be loadable.