Calendar based on spreadsheet (Google or Excel)

[kdvs]

Hi all,

does anyone of you know if it's possible to use a spreadsheet to as a database for a calendar (a list of events)? I.e. have a spreadsheet with columns like date, time, event, artist etc and translate that information into an online calendar.

Thanks!

[Dr.CSS]

If you are using CGCalendar it most likely has an import function like a lot of his modules do...

[Jeff]

You could make a UDT to read the spreadsheet and fill Smarty variables than process a Smarty template (either from CGCalendar or own you make yourself).

Reading from a CSV would be the easiest, but there are libs for reading an Excel file, and Google has an API to enable reading from a Google Spreadsheet.

Yes it is possible, depending on your time and/or budget.

[kdvs]

Thanks Jeff and Dr.CSS!