Importing
How can I Import Appointments and Other Items from Previous versions of the Calendar?
Applicable Versions: Free, Full, Pro
Version 5.4 of CC Calendar consolidates all the calendar tables into a single file. Thus, in order to take advantage of the new version, you’ll want to import your appointments, etc. into the new tables in CCCalendar.fp7
Toward the end of the layout list in CC Calendar you’ll find a list of layouts corresponding to the tables formerly in other files of CC Calendar. In most cases all you have to do is make sure you have all your records in the found set in your older files and the import these into the relevant tables in CC Calendar.fp7 After you import each table, be sure to reset its serial number (field beginning with “Prime...”) to be one higher than the last record created.
There are just a few things to be aware of in some tables.
CCCalAppts: this is the table for appointments. Importing by matching names will work for recent versions of the calendar.
SettingsApptTypes, SettingsTypesColors, SettingsUsers. These tables are virually unchanged from recent versions of the calendar so importing by matching names works well. Note that you only have to import SettingsTypesColors if you’ve added your own colors or renamed some of the existing colors.
SettingsValues. This table should also be imported using matching names; though there are so few settings here, you can just configure the settings again on the Admin / Settings screen instead of importing. Note that the Mac and Win offset fields are no longer used in version 5.4 and have been deleted.
Related Items A. (Full and Pro Only) This table has been converted into a to-do list in the Pro Version. If you were using Related Items A (and only that, not related Items B) simply import your related items A record into the OtherItems table described below. If you were using both related items A and B you may wish to modify the to-do list? into something you can use for your related items A records. In the Full Version this table has been renamed “Other Items A” and aside from the field prefixes, the fields remain the same. So, while using “matching field names” won’t work on the import (because of the change in field name prefixes), there are very few fields here and they are easy to align.
Other Items. This table was formerly called “Related Items B”. If you weren’t using this feature of the calendar, you don’t need to import items here. If you were using this you’ll find the tables remarkably similar with the exception that the field perfixes have been renamed. While this means you can’t use “matching field names” on your import, there are very few fields here and they are easy to align.
