Data Store Advanced Overview
The Data Store is meant to be, for each user, a central location for certain types of information. Information that is stored in the Data Store comprises:
| Information Type | Description |
|---|---|
| File meta data | Stores information about Working Papers files such as location, version information, compression state as well as meta data related to each file. |
| Terminology | Stores shared terminology for use in Working Papers. |
| Security users | Stores list of users available for use in Working Papers security. |
| Security groups | Stores Global group information; group properties and user assignment to these groups. |
| Shared settings | Stores Data Store configuration information. Ex. Database GUID, security ID, file tracking settings |
| Local Settings | Stores information about the state of the Personal Data Store such as the last time the store was synced and against which Data Store (Personal Data Store Only). |
Other than Local Settings, which is contained only in a Personal Data Store, the above information will be contained in both the Personal Data Store and the Data Store. If the user has specified a Data Store, then the information will be synchronized between the user's Personal Data Store and the Data Store. If multiple users connect to the same Data Store, then the information will be synchronized between all connected users.
The Personal Data Store is contained within a folder called C:\Users\<user account name>\AppData\Local\CaseWare. The files within this folder are stored as xBase database files. The Data Store is either contained in a SQL database if an SQL Data Store is being used or in a “Data Store” Windows folder if an xBase Store is being used. The table names are as follows:
| File(s) | Personal Store | Data Store (xBase) | Data Store (SQL) |
|---|---|---|---|
| File meta data | files.dbf | files.dbf | TrackedFiles |
| Terminology | terms.dbf | terms.dbf | Terminology |
| Security users | users.dbf | users.dbf | Employees |
| Security groups | groups.dbf | groups.dbf | SecurityGroups |
| Shared settings | shprefs.dbf | shprefs.dbf | SharedSettings |
| Local Settings | prefs.dbf | n/a | n/a |
| Addition file. Points to the location of the Data store. | storeinfo.cws | storeinfo.cws | n/a |
By default the Data Store always uses the Personal Data Store to retrieve any information because it should always contain accurate information due to synchronization (except when the Data Store is offline, in which case information will become stale as expected) and it is always guaranteed to be online.
To ensure a correct and up-to-date list of client files, always manipulate a client file using Working Papers. For example, use File | New or File | Copy Components to create a new client file rather than copying the file through Windows Explorer.
