Maintain public calendar based on database on web-server

[mohella]

Hello!

I'm trying to figure out the best way to maintain a public Google
calendar, and keep it in sync with my calendar on our website that are
maintained and stored in a database on the server.

At first I hoped that there would be an opportunity to maintain a XML-
document that the Google calendar would read from, but as fas as i
have found out, this is not possible?

I'm currently looking into make a way to insert/update/delete events
as I do the same at my website, but I'm thinking that might be
difficult.

Has anyone done this, and do you have any hints on what would be the
best way to have this done?

I'm working on a Coldfusion server, but the way to solution would be
similar for any web-server-side-languages I guess.

[bickerdyke]

IMHO syncing is too complicated.

You should keep your data in ONE place. Either completly on the google-
Side, or on your server side.

For keeping it on google-side: Just embedd the calendar display into
your site. If you want to add/edit/remove events from your side, you'd
need to have your website using the gdata-api to do so. Not exactly
easy, but not rocket science either.

Post by mohella
At first I hoped that there would be an opportunity to maintain a XML-
document that the Google calendar would read from, but as fas as i
have found out, this is not possible?

Thats already close... The solution is NOT an xml-file, but a ical or
ics file that can be displayed in google calendar. (Add Additional
Calendar and then just point to your ical file) That way round, your
data will be completly stored within your website and only displayed
in google. No complicated syncing needed.

Post by mohella
Has anyone done this, and do you have any hints on what would be the
best way to have this done?

Did my best... :-)

Post by mohella
I'm working on a Coldfusion server, but the way to solution would be
similar for any web-server-side-languages I guess.

have you looked for already existing coldfusion modules?

[mohella]

Thank you. That is helpful!

Post by bickerdyke
You should keep your data in ONE place. Either completly on the google-
Side, or on your server side.

This was my intention, do all editing from my site and then "mirror"
the changes to a calendar which anyone can add to their Google
calendar.

Post by bickerdyke
Thats already close... The solution is NOT an xml-file, but a ical or
ics file that can be displayed in google calendar. (Add Additional
Calendar and then just point to your ical file) That way round, your
data will be completly stored within your website and only displayed
in google. No complicated syncing needed.

Does anyone know of a good place to see samples of a ics-file
correctly formatted for Google? With both all-day events and ordinary
events?

[bickerdyke]

Post by mohella
Does anyone know of a good place to see samples of a ics-file
correctly formatted for Google? With both all-day events and ordinary
events?

Create a calendar within google with the types of events you want to
use and download it as ics-file. (In the calendar settings tab there
is a link to the ics-version of it for displaying the google calendar
in other apps.)

I'd expect the exported ics to be similar to the ics thats needed for
import...