To migrate your Oracle Calendar (CorporateTime) entries to Microsoft Outlook:
- Export your Oracle Calendar entries into a data file, then
- Import the file into Outlook 2007.
Optionally, you may then want to tweak your Outlook calendar entries, as Exchange treats some items differently.
Export Your Oracle Calendar Data
- Sign in to your Oracle Calendar.
- On the File menu, choose Export Data...
- Select vCalendar file.
- Note: If you choose iCalendar, your tasks won't export.
- Click Continue.
- Under Period:, select a suitable range.
- Note: You can go as far back in time as you need, and proceed into the future if you already have appointments planned. The longer the time period you select, the longer it will take to make the export file.
- Under People/Resources:, be sure that the calendar selected is the correct one to export.
- Then click the Browse... button to choose a location and name for the export file (keep .vcs at the end of the file name).
- Note: Make sure you remember where this file is located, because you will have to find it again when you import the file into Exchange. Your computer's desktop is the easiest place to find the file.
Import Your Oracle Calendar Data into Outlook 2007's Calendar
- Open Outlook 2007, and sign in if necessary.
- On the File menu, choose Import and Export...
- Note: You may have to hit the double arrow >> to see this option.
- Under Choose an action to perform: select Import an iCalendar or vCalendar file (.vcs).
- Click Next.
- Browse to the location where you saved the export file from Oracle Calendar.
- Note: This may require you to change the Files of type: to vCalendar Format (*.vcs).
- Once you locate the file, click on it to select, and click OK.
- Note: A window may appear asking how you would like to open the calendar. Your options are: Open as New, Import, or Cancel. Open as New will create another calendar, Import will insert the data into the current calendar, and Cancel will abort the import process.
Tweak Your Outlook Calendar Entries
Now that you have imported your Oracle Calendar (CorporateTime) entries in Outlook 2007, you may want to tweak certain items that your Outlook calendar treats differently.
- Daily Notes and Day Events - In Outlook, these appear with a start time around 12:00 am on the scheduled date instead of a "note" for the day, as in Oracle Calendar.
- Fix: Open the calendar entry and manually change it. Check the All day event checkbox, then click Save and Close. Or, change each appointment's time from midnight to the correct start and end times.
- Recurring appointments - The import process “breaks” them, so they are no longer linked together in Exchange. Outlook treats recurring meetings as individual appointments.
- Fix: You can either leave them un-linked, or re-create the recurring meetings in Exchange.
- Attendee information - The names of others invited to meetings will not transfer when importing into Exchange.
- Fix: You can either leave the meeting as is, without information about others who are invited, or for meetings in the future, you can re-create the appointment in Exchange and invite others to join you.
- Notes - Notes about appointments in Oracle Calendar will not transfer to Exchange.
- Fix: Import these into a spreadsheet format to keep for future reference, if you need an archive.