User manual

Microgate Srl P. 68 / 74
3.5.2 DATABASE
Witty Manager manages all data (athletes, tests, results, settings, etc.) in a database file (Sql Server CE
format with the extension .SDF). Most users can use a single file for managing all information, which by
default is called 'Witty.sdf' and is located in the following directory:
Documents\Microgate\Witty Manager
This directory can change depending on the operating system used and the language, but typing it into the
address bar of an Explorer Window, the correct folder will be opened automatically. Some examples are
shown here (<YourUserName> is the user name for logging into Windows):
Windows XP Italian: C:\Documents and Settings\ <YourUserName> \Documenti\Microgate\Witty Manager
Windows XP English: C:\Documents and Settings\ <YourUserName> \ My Documents\Microgate\Witty Manager
Windows VISTA/7/8: C:\Users\ <YourUserName> \Documents\Microgate\Witty Manager
etc.
If there is an error in loading the database (file moved or deleted), Witty Manager will report this error
when the program is launched, offering to search for the database or continue. In the latter case, Witty
Manager will create a new empty database.
The software allows to manage multiple databases (one at a time) for particular requirements: for example,
a team trainer may want to separate the tests of one season from the ones of another season (but if they
are separated, it will not be possible to compare them or study their evolution), or a free-lance consultant
carrying out tests for various customers may need to create a database for each team he/she is going to
test.
It is also possible to export data into a database to transfer them from a PC to another one or give them to
a customer, who can check them with the freeware available at www.microgate.it/witty.
The available commands are listed below: