Importing events from sql table

[Chris]

Hi

I see in the admin section there is an import events option - but in
iCal and Outlook CSV format. I have current events on the site i am
working on in a SQL 8.0 table.

Can convert that table to one of these options? if so, how?

Thank you!

Chris

[TJ]

There's a few ways to do this. The first and probably least amount of
effort is just to write a script that graps events from your table and
inserts them into the Kalendar events table.

The second method is slightly more complex but a lot better for the
long term. In the Kalendar.cfc theres a method called getCalendar
which does the query to get the events from the Kalendar events table.
You could add in your query and do a union. This might take some fancy
footwork to map the fields appropriately. You could also extend the
component and override that method entirely, although you will have to
be familiar with extending CFCs.

The third method would be replacing the query in the above method to
use your own and modify the code to match your data. The array that
method builds (CalendarEvents) is all that is needed to populate the
calendar.

As a general rule, when I implement Kalendar for clients, I am rarely
using Kalendar's events table. I am generally using an events table
from an existing application and overriding the getCalendar method to
utilize the client's data.

[Chris]

Thank you!