SportsTrak is written using PC-Soft Windev. The data files used here are its proprietary HFSQL ISAM files. Rather than being in the cloud, the data is stored locally, usually in the same folder as the SportsTrak program.
The combined files form a relational data base. This means that data in one file can connect to data in another. For example, each student has an ID and that ID is used in the CompList file, the Results file, and possible others. Data files have the extension FIC Most files have an Index, stored in the NDX file. The data for all carnivals is saved in the one set of files. The Carnival file stores details of multiple carnivals, each with a unique ID. This ID is used in other tables to distinguish between carnivals. For example, AgeGroup will hold multiple age groups, often identical but they are each stored with a Carnival ID. When you set a carnival to be the Current Carnival, you will only see the Age Groups that have that Carnival ID. These data files should not be accessed by any other means than through SportsTrak. Otherwise they can be corrupted. The illustrated data is based on my files as ST3000 is being developed. There are 11 Carnivals represented here. Sorted by size gives an indication of the relative file sizes on disc. Two files are encrypted: the Student File and the Authority file |
|
|