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"
After this I filled some fields more, nothing critical, but I don't remember.
See result here: http://www.geocaching-events.de/