The Database Management offers clean-up and maintenance features for your TeamCal Pro database.

Clean up old templates and daynotes

Image: Manage database - Cleanup old records

Once you have used TeamCal Pro for a few months you may want to delete user absence records and day notes of the past. Enter the year and the month of the date that you want to use as the key date (data including this month and before will be deleted).

...

You need to confirm the deletion by typing in "CLEANUP" in the confirmation text box.

Delete database records

Image: Manage database - Delete records

You will find an easy way here to erase a large amount of data from your database.

...

You need to confirm the deletion by typing in "DELETE" in the confirmation text box.

Export database

Image: Manage database - Export database

You can export specific tables or the complete database from within TeamCal Pro's Database Maintenance page. In the "Table to export" drop down list select the table you want to export, or just leave the selection to "All" which will export all tables. Chose one of the formatting options that you would like the data to be presented. You can chose between 'CSV', 'SQL' and 'XML'. You can also decide where you want the output of the export to go. Select 'Browser' if you just want to see the data in your browser window. Select 'File Download' if you want to save the export to a local drive.

Restore database

Image: Manage database - Restore database

TeamCal Pro supports backup and restore of the database. A file downloaded via 'Download Database Dump' in the Administration menu can be used to restore the database here. Click the [Browse] button to select a file from your local hard drive. Then click [Restore] to restore your TeamCal Pro database.

...