If you turn it on, it’ll show you the necessary code to use it. It completely replaces the event management in the site so that all data is drawn from the other site. Essentially, it allows you to share a calendar between multiple sites, but maintain it only in one of the sites.
Thread Starter
kevjon
(@kevjon)
Thanks Joe, very helpful.
I have 2 calendars on separate sites so can I combine them before setting up the common database link? Otherwise I guess I have to re-enter all the events from one site into the other before making the link in the first.
Presumably just setting up the link on one site would erase all the existing events on the site. If it added to them this would be great!
There’s really no built-in way to merge two datasets of My Calendar. You can use something like phpMyAdmin to export one database and then import that into the other; but you’ll need to be careful, because you’ll need to make sure you get a SQL export that will allow you to insert the events as new rows, rather than inserting them with their existing event IDs (which will undoubtedly collide with the IDs in the other database.)
If you do this, only insert the events table, and *not* the occurrences table, then use the ‘Re-generate occurences table’ option on the settings page to re-create that table from the new database information.
Thread Starter
kevjon
(@kevjon)
Thanks Joe – pretty much what I expected. I’ll think about it!