Navigation

Introduction to TimeSprite
The TimeSprite Monitor
The Main TimeSpite Application
TimeSprite Settings
How you spent your time
Journal
Creating a Timesheet
Grouping Data
Editing Groups
Editing Data
Adding Time
Exporting Data to CSV files
Exporting and Importing Data
The TimeSprite Database
Changing the Database Location
Compacting the Database
FogBugz Integration Introduction
Setting up the FogBugz connection
Exchanging data with FogBugz

Changing the Database Location

If necessary, you can change the location of the TimeSprite database.

To change the location for recording time:

  1. Select File->Change Database Location... from the TimeSprite Monitor menu.
  2. Select the location where you want the database.
  3. The TimeSprite Monitor will change the database location then close, so that you can move the existing database if necessary.
  4. Restart the TimeSprite Monitor (Start->All Programs->TimeSprite->TimeSprite Monitor). If there is no database in the new location, it will be created automatically.

The main TimeSprite application will also use this database the next time it opens.

To view data from a different database:

  1. In the main program, select File->Open Database... from the TimeSprite Menu.
  2. Choose the database to open.

The TimeSprite Monitor will continue to use its current database. Changing the database in the main program does not affect the monitor. This allows you to view data from different databases without affecting time recording.

If you select View Data from the monitor, TimeSprite will always open the database that the monitor is currently using.

Managing databases

If you choose to change the database location, there are some points to be aware of:

  1. We do not recommend putting the database on a network drive.
  2. When the database is in use, a file will be created with the same name as the database file with the suffix "-journal". This file is used to ensure that the database is consistent even if the program crashes. It is deleted automatically when it is no longer required. If you manually delete this file, you are likely to corrupt the database. You should treat this file as part of the database file, and if it exists it needs to be moved or copied at the same time as the database file (or, preferably, open TimeSprite so that it will be cleaned up automatically before moving or copying the database).