Serendipity conversion from WebCalendar
Posted: Fri Aug 08, 2008 10:15 am
I used the "WebCalendar" quite a long time: http://www.k5n.us/webcalendar.php
Now I converted data to the s9y. If someone has need for it, this lines of SQL were used for the conversion:
After this I filled some fields more, nothing critical, but I don't remember.
See result here: http://www.geocaching-events.de/
Now I converted data to the s9y. If someone has need for it, this lines of SQL were used for the conversion:
Code: Select all
insert into `events_entries` (id, timestamp, title, body, author) SELECT cal_id, unix_timestamp(`cal_date`+" "+`cal_time`),cal_name,cal_description, cal_create_by FROM `webcal_entry` where `cal_access`="P"
insert into `event_entryproperties` (`entryid`,`property`,`value`) SELECT cal_id, "ep_access", "public" FROM `webcal_entry` where `cal_access`="P"
See result here: http://www.geocaching-events.de/