We are migrating from a Microsoft Exchange system to Google Apps for business. One of the things not supported by Google Apps is categories in calendar events. However, some users have critical information in the event categories which we cannot afford to lose.
What we need is a script which can be run once, to place the category applied to every calendar event at the front of the title of the event.
Title: Do the washing up; Category: Domestic
Title: Domestic - Do the washing up; Category: Domestic
Note that the category should still be retained in the event, it is duplicated into the event title.
We have already migrated users (categories in events are retained in the locally stored outlook calendar, but not synced to Google's servers) so this needs to be able to run on an outlook calendar with google apps sync installed. Needs to support Outlook 2010.