Upgrading QC-CALC to version 4.0
Print Friendly View
written: 09/07/2018
last modified: 03/28/2019
PREREQUISITES
  • If you are running a version of QC-CALC prior to 3.4, install a 30-day evaluation copy of QC-CALC Real-Time 3.4 from the Downloads page of this website.
  • If you are already using QC-CALC 3.4, update to the latest revision.
  • Use the Help > Update QCC Files... menu within the latest revision of QC-CALC Real-Time 3.4 to update all of your QCC files to the revision that is needed for the 4.0 conversion process.
INTRODUCTION
This article gives the general steps to upgrade your existing copies of QC-CALC 3.4 to QC-CALC 4.0. There are generally two steps; upgrading the software itself and converting your existing data (QCC files) to the new format (QCQ files). If you are choosing to use SQL Server, there is an additional setup step of creating the database and assigning permissions. If you use the Create Database button on the Tools > Options > Data Storage screen (when SQL Server is selected at top), the wizard will create the database and assign a user account for you. The only thing you will need to know is the server name where SQL Server is installed and a system administrator account that has the permissions to create a database.

STEPS
1. Installation
This involves installing the software and copying all settings from your previous version. As outlined above, start with the data collection software (QC-CALC Real-Time, Gagestation, QC-Gage).

  1. Install QC-CALC 4.0 on the same PC as QC-CALC 3.x if possible. If not possible, proceed to the "Copying Settings Manually" section after installation is finished.
  2. On first run of QC-CALC Real-Time, a message will appear saying QC-CALC 3.x was detected and offers an opportunity to copy your settings forward. Choose Yes to keep your previous version's settings and use them with 4.0. QC-CALC will copy all settings and related files from 3.4 and use them going forward. If you are using the Administrative Tools, 4.0 will automatically be redirected to the same user group as your previous version.
  3. If you are using SQL Server as the database type, go to the Tools > Options > Data Storage area and choose "MS SQL Server" from the Data Storage Type list. Enter your connection information into the 4 fields on the Data Storage screen then click the Test Connection button to complete the SQL connection.
Note: Report templates will not be copied from the old version, but there is a new Template Converter application that can help you convert any customized report templates you may have to the new 4.0 version. If you have not customized your report templates, you do not have to convert anything. Just use the default templates that are installed with QC-CALC 4.0 instead. To convert the templates, select use Help > Launch Template Converter menu and follow the instructions within the program. 

2. Copying Settings Manually

Note: Skip this section if you installed QC-CALC 4.0 on the same PC as your previous version.

  1. Shut down any previous version of the software that is running. This will ensure you are not writing to the settings files as they are being copied.
  2. Copy the following files from the old version's directory (i.e. c:\Prolink\QC-CALC 3.4\) to the new directory (i.e. c:\ProgramData\Prolink\QC-CALC 4.0\). Due to Microsoft's software requirements there are two new directories in QC-CALC 4.0; the ProgramData directory and the Users\Public directory. The directories are typically the ones shown below unless you installed QC-CALC in a non-default directory. In this case, the lowest folder will differ slightly in name.
ProgramData directory: C:\ProgramData\Prolink\QC-CALC 4.0
Users\Public directory: C:\Users\Public\Prolink\QC-CALC 4.0

Warning: Copy the files listed here ONLY!

Copy the following files to the ProgramData directory:
  • Admin.ini - This may be hidden. Turn on "hidden files" in Windows Explorer.
  • AskValues.ini
  • ConvertTemplates.ini
  • QC-CALC SPC-ScreenSettings.ini
  • QC-CALC.ini
  • QCCalcOverrides.ini
  • QC-CALC-RT.ini
  • QC-CALC-SPC.ini
  • RealTimePlots-ScreenSettings.ini
  • TrainingCmm.ini
  • Update.ini
Copy the following files to the Users\Public directory:
  • AssignableCauses.dat
  • CorrectiveActions.dat
  • *_setup.txt - Files of this style may or may not exist depending on your machine type (i.e. modus_setup.txt or metris_setup.txt). If they exist, copy them.
3. Data Conversion
You must convert your existing data files (QCC) to the new format (QCQ or SQL Server) in order to use them in 4.0. It is important to note that converting your QCC files to QCQ or SQL Server does not change your QCC files in any way. It only copies the data and settings within them to the new database.

Note: This conversion is required even if you already have your data in SQL (via EDL) as many of the settings for individual QCC files are ignored by EDL. The conversion process in this case will only bring those settings over to SQL since the data is already there.

  1. Shut down any previous versions of software to stop any new data from being collected during the conversion process.
  2. In QC-CALC Real-Time 4.0, choose Help > Launch Data Converter.
  3. By default, the From value is set to "QCC files" and the To value is set to "QCQ". As the To value, choose either "QCQ" or "SQL Server" as needed. Click Next.
  4. On the Source screen, navigate to the path where there are QCC files at the top. You can then choose to convert all files or choose a specific list that will be converted. Click Next.
  5. On the Destination screen, do the following based on database type:
    For QCQ files: Choose the new path where your QCQ files will be stored. This will typically be on your network. If you are on the local PC, choose C:\Users\Public\Prolink\QC-CALC 4.0\Data\. Click Next.
    For SQL Server: Type the connection information (Server, Database, User ID, and Password). Click Next.
  6. On the Additional Settings screen, choose the Assignable Cause or Corrective Action Files if they were used in 3.4 and click Next. For SQL Server, optionally choose to enter a location in the Location settings box at the top.
  7. On the Process screen, click Start Conversion. The conversion process will start and progress will be displayed throughout the process. If you have a lot of QCC files, you may want to start this on a Friday night to allow time to process.
Once the process is complete, it is recommended that you remove all QCC files (copy them to an archive location) to prevent future confusion. This includes all satellite files that go with the QCC files including files with the extensions QCN, NTS, P11, EIF, ET3, etc.

Applies To

GageStation v.4.00
QC-CALC Enterprise v.4.00
QC-CALC Real-Time v.4.00
QC-CALC SPC v.4.00

Category

General Program Information
See more articles in this category