This section will walk you through updating the system tables in toxiCALL®. This important process will ensure you have the latest details available from our FLEX Updates™ distribution server.
The Toxicall Tools Menu shows the options for checking system tables. The two methods available are described below.
System Tables Update Notice
For toxiCALL®administrator accounts, you may be greeted with a popup system reminder if a system table is out of date when starting toxiCALL®. This non-obtrusive reminder will automatically clear within a few seconds.
What details can be updated by System Tables? #
System Tables are designed to minimize the need for toxiCALL® updates by allowing a distribution of metadata which helps define how toxiCALL® works. This is a simple process but provides a great deal of flexibility with toxiCALL® and your changing business needs.
- Validation Rules
- Reports
- Dashboards
- Pre-defined Lookup Lists to include
- Call Types
- Genders
- Clinical Effects
- Therapies
- Routes
- Scenarios
- Outcomes
- Survey Forms
- Keycuts
- More!
One significant advantage of toxiCALL® is that you can also create and update your lookup values, reports, dashboards, validation rules, etc. While toxiCALL® does distribute these items, you can override them to suit your specific business needs.
Update From Web #
Updating the system tables from the web is a simple process. This will connect to our toxiCALL® Web Server to ensure you have the latest updates. From the Ribbon Bar:
- Select the Tool menu option
- Select Check System Tables
- Observe the list of Syste Tables which require an update
- Select one or all tables which require an update.
- Note the “Out of date” indicates a newer version is available.
- Select the Filter row item to filter which tables require updating.
- Click Update All or Update Selected as needed.
Choose Yes to confirm your selection.
Observe the updated status as the tables are released.
After the tables are released, a summary is displayed.
Update from Files #
Backup Only
This feature has been implemented as a potential backup. This is not the primary method used for updating System Tables.
When updating the system tables from a file, you will need to ensure you have the file provided by CAS Support. Please reach out to our team if you do not already have this file ending with a “toxupdate” extension.
To proceed, select Check System Tables From File. Locate and select the file on your computer then choose open.
After selecting the file, then choose the Update All button. This will start the import process.
Known Issue
It will be necessary to update the system tables twice in version 5.0.8623 or earlier.
Single File Update
It is possible to select one or more files if needed. This should be done at the direction of toxiCALL® Support. In this case you will select the necessary file(s) then choose OK.
Once the Summary screen is shown be sure to hit the Save button. Rollback will undo the system table updates.
Now perform these steps a second time to resolve a known issue in v5.0.8623 and earlier.
System Tables should now be updated!
For a new database you can proceed with importing Validation Rules and other data samples which are not yet available through the FLEX Updates™.
