Instructions for Downloading and Installing the CMS System and/or Updates
PRINT THIS PAGE BEFORE STARTING THE
PROCESS
From the website, www.jabr.com , choose the CMS Support / Update
Option
You will be taken to the Support/Updates
page. Click CMS Updates to navigate to
the download page.
In this page:
·
You will
see the major changes that are included
·
If
you choose to update you can. (note: if you are
getting the expiration message in CMS, or the page indicates you need to
update, then you need to update)
·
The Date of
the last release
·
Information
about what programs need to be updated
·
Information
about what changes have been made to this update.
To download the program updates,
click the option at the bottom of the page.
You will be taken to www.swapdrive.com login screen, where JABR
stores updates.
You will be asked for your
login, password and domain
Username = (You will have
received this in an e-mail, or call JABR)
Password = (You will have
received this in an e-mail, or call JABR)
Domain = jabr.com
In the swap drive screen click
the box in the upper left corner that instructs you to “click here to see
shared drives’ and pick the “CMS Program” option. Then click the “Go!” button.
You will then see the files
available for download.
For the 7-15-2004
you need to download the following files:
For the CMS portion of the
update download:
·
CMS.EXE
·
Standard.EXE
·
If your operating
system is Windows 95, or Windows 98 you may need to download mdac_typ.exe
v
If you have
installed mdac_typ.exe before, you will not need to do it again
For the security portion of the
update Download
·
CMSecurity.exe
To download a file
·
Right click
on the file you want to download
·
Choose the
Save Target As…. option
·
Choose the
location you wish to save the file, and click Save
When the download is complete,
You will be notified.
To install the downloaded files,
open the folder where you saved the file and double-click the file.
The .exe files are
self-extracting and default to the location of the default installation
location. If you changed the location during installation of the product,
you will need to click the Browse button and find the appropriate location for
the file you are updating.
Click the Unzip button and the
Self-Extractor will place the file in the appropriate folder
If you are using a network, you need to replace the CMS.mde file on
ALL OF THE WORKSTATIONS. If you are in a CITRIX or Terminal Server
environment, type in the destination folder for the cms.mde file. If you
run CMS on a stand-alone computer, the self-extracting program will update the
file automatically.
After you download the files, you will need
to install them, and run the database comparison routine that is in the
security module, Dataset Administration. This will bring your dataset in line
with the updates to the system.
YOU WILL NEED FULL NETWORK
ACCESS TO THE FILE TO DO THIS PROCESS
Table Analysis Tool
The table analysis tool is where the update is done.
BEFORE STARTING
THIS PROCESS
1) Backup your production Data. Make sure no is working in CMS by checking the folder where your Guidata is. There should only be one Guidata file. If there is a Guidata.lbd file, the size will be approx. 1KB, someone is still using CMS.
2) When everyone is out of CMS make a copy of GUIData (right click and copy it) paste it in the same place or anywhere else you wish to store it.
3) Test your copy of GUIData by relinking and verifying that it is working – maybe even open tables thru access to check for corrupted tables.
4) For extra safety, thru Microsoft Access in Tools, Database Utilities you might want Repair and Compact the GUIData.
To use the Table Analysis Tool you must have the following components:
1. A Standards database – This is downloadable from the JABR web site and contains the current tables and fields in the latest revision of the CMSÓ system.
2. Production Dataset – The default name for the production dataset is GUIData.mdb. This is the dataset that contains all the information stored as a result of input from the CMSÓ system. During the installation process the file was put somewhere on your system.
You can locate the file in the bottom left corner of the “About” screen in the CMSÓ system.
To use the Analysis Tool, first click the “Browse” button on the top line, “Compare from Table”… of the tool and locate the standard.mdb file.
Note: Use the most recent Standard File that has been downloaded from the Web. This file will have a date in the name. (Example: Standard7-14-04.mdb)
When you do, either double click the file or click the “Open” button and the location will be filled in.
Next find the production data (GUIData.mdb or if the name has been changed, that file) by clicking the “Browse” button, “Compare to Table”….
A “Compare” Button will appear after this step is completed. Click it and when the tables are updated you will be notified.
The system will also report the number of tables that have been looked at and updated.
NOTE: If you have
created queries in the production data set the update process may not work. If
you create queries with names that are similar to tables in the system the
process will not work.
The safest place to create queries is in a different location.
Re-link the tables using the
Tools, Refresh option in the menu.
If there are any questions, please call JABR
technical support at 210.651.3155.