Note - These instructions apply from Version 2 of the Database Configuration Utility which improves upon older versions. Older versions may be missing steps.
To set up a new ProCal server the Transmille Database Configuration Utility must be run.
The latest version of the utility is attached to this support article.
Note - This computer only needs to be run ONCE unless you are upgrading the database for Version 6.
- After launching the utility an automatic scan for SQL Servers on your network is started.
- After approximately 15 seconds the drop-down box will be filled with all SQL Servers that were found on your network, ensure that the correct SQL Server is selected. If the server is not visible please contact your IT support provider for assistance as there is a firewall configuration issue between the 'server' and your computer.
- Select the correct server from the dropdown list and a larger menu will appear.
- If your system administrator has provided a Username and Password for you to connect under, enter these in the Username and Password boxes. If the SQL Server has been set up as recommended by Transmille the Username and Password boxes are already pre-filled.
- Click the 'Test Connection to SQL Server' button. If an incorrect username or password has been entered an error box will appear.
- If the connection succeeded, the 'Check for ProCal Database' button will be enabled. To proceed with the setup, click this button.
On a new installation, a message will appear prompting you to create a new Database. After you are sure that this is the SQL Server that you wish to use for your ProCal installation click 'Yes'.
The Utility will now proceed with creating the database tables.
If the utility displays an error during this process, please contact Transmille for further assistance.
The utility will display a prompt asking if the user wishes to install default procedures or import procedures from a previous version of ProCal.
Clicking YES will show a browser dialog allowing the user to navigate to the folder that holds their procedures. If this is a NEW installation, do not change the directory and click OK as the default (C:/ProCal/Procedures) will already be selected. If an existing installation is being upgraded, navigate to the folder that procedures are stored in.
Clicking NO will not import/create procedures, allowing users to start with a blank database.
If YES has been selected, the above window appears. Upon clicking OK it will disappear and the utility will start the process of importing procedures. For large libraries, or network stores this will take a few minutes. Typical conversion times are less than 5 minutes to import all procedures.
The progress bar in the bottom left of the window will cycle until procedures are imported. Please let the utility run and do not click close.
After the procedures have been imported, a final window will appear, prompting the user to create their laboratory information. This information will appear on certificates and paperwork generated by the system.
The Laboratory Name, Address Line 1 and ALL environmental conditions are mandatory. Clicking 'Save Information' with these fields blank will highlight incorrect fields in Red and not allow this step to be completed.
Environmental conditions are numerical entry only, for example Lab Humidity Allowance is an entry of 20 for environmental conditions of +/- 20% RH. All values are integer and do not allow decimal entry (i.e. 1'C is allowed, 1.5'C is not allowed).
After completing the required fields, click 'Save Information'. If data entry is valid the input form will disappear.
The utility has now configured the database for use by ProCal, ProCal-Track and ProSales V6.
To create settings for ProCal to connect, click the 'Create Connection String'. The utility will create files in the C:/ProCal/Connection Settings folder that is to be copied to each computer that will connect to the server. It is important that this step is completed if non default passwords are being used.
Update Log :
22nd September 2017 - Utility updated to create additional table and populate with default information
25th June 2018 - Updated utility to the latest version
4th October 2018 - Updated utility to the latest version, changing the default password for the SQL Instance that is installed by the installer
13th February 2019 - Updated utility to Version 2, including support for upgrading procedures and configuring laboratory information. New installer includes .Net 4.5 web installer if target computer does not have this installed