Statistician's PC: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
Line 14: Line 14:
** Starting 2023, only one license for Julie Mojica is being paid by the Critical Care Program.  The other license is being paied by Dr. Kendiss Olafson.  
** Starting 2023, only one license for Julie Mojica is being paid by the Critical Care Program.  The other license is being paied by Dr. Kendiss Olafson.  
* Have been used for  Canada Vital Sign Monitor until 2014 and [[Critical Care Program Quality Indicator Report]] up to present
* Have been used for  Canada Vital Sign Monitor until 2014 and [[Critical Care Program Quality Indicator Report]] up to present
=== Transferring SQCPack8  to new computer ===
On your current laptop, open SQCpack. Then go to Menu at the top and then click on Database. You will see near the top of the window information regarding the database you currently have open.
For instance, I am connected to a Single-user database and the specific database location/file is listed.
If I needed to move this database to a new computer, I would go to that folder location and would grab a copy of the SampleDatabase.mdf file as well as the SampleDatabase_log.ldf
On the new laptop, install SQCpack. HERE is the link on our site for the installation file for version 8. Then you can paste copies of your database .mdf and log.ldf files in a new spot of your choosing. Then you can open SQCpack and go to Menu – Database and at the bottom expand the Single-user SQCpack database (hit the Show button) and then you can click on the “Open a single-user SQCpack database”. Browse to the location of the .mdf file.
You have now connected to your database.
The other important note about moving things to a new computer is if you made charts that were based on external sources (Excel files, Access files, etc). Those files would need to be copied/moved to the new computer as well. Keep in mind that when you made Charts within SQCpack to point to any external sources, like an Excel file on your desktop, that it is looking for an .xlsx file in a specific file path. If you move those external files to the new computer and change their file path location, that can break the connection to those charts. You might need to edit the Charts to repoint them to the right files.
=== Problem in SQC Pack ===
Error encountered:  The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
Please follow the steps below. You can also pass this along to your IT team.
Try the following steps exactly as written.
# Go to http://www.microsoft.com/en-us/download/details.aspx?id=13255
# Download "AccessDatabaseEngine.exe" and save it somewhere (Do NOT download the x64 version)
# Open Command Prompt from the start menu
# Type "Start" followed by the file path to AccessDatabaseEngine.exe and finally end it with /passive
It will look something like: C:\Users\root>Start C:\Users\root\Desktop\AccessDatabaseEngine.exe /passive
=== Legacy Issue in Chart Runner Lean Software ===
=== Legacy Issue in Chart Runner Lean Software ===
==== Microsoft Access Runtimes to deal with bit-wise and Office Version incompatibility ====
==== Microsoft Access Runtimes to deal with bit-wise and Office Version incompatibility ====

Revision as of 13:18, 2023 February 7

This page contains information that might be required by anyone who needs to do a re-build on the Statistician's computer.

Special Software installed

SAS

  • looks like this can be run with the standard Shared Health install now
  • Yearly license is made thru University of Manitoba. Contact Person Melanie Hamel. See details in shared folder S:\MED\MED_CCMED\Julie\Software_License_Renewal\SAS Renewal.
  • The Statistician Julie Mojica is also a staff of University of Manitoba.

SQCPack

  • Started Date : 2012-2021 (Chart Runner), 2021 SQC Pack 8
  • Yearly license is made thru PQ Systems. Contact person is Marilou Brown. See details in shared folder S:\MED\MED_CCMED\Julie\Software_License_Renewal\CharRunner Renewal
  • Chart Runner Lean stopped its upgrading 2021 and has been replaced by SQC pack in 2021.
  • Two licenses for the Statistician of CCMDB Julie Mojica and Dr. Kendiss Olafson from the Outcomes Improvement Team
    • Starting 2023, only one license for Julie Mojica is being paid by the Critical Care Program. The other license is being paied by Dr. Kendiss Olafson.
  • Have been used for Canada Vital Sign Monitor until 2014 and Critical Care Program Quality Indicator Report up to present

Transferring SQCPack8 to new computer

On your current laptop, open SQCpack. Then go to Menu at the top and then click on Database. You will see near the top of the window information regarding the database you currently have open.

For instance, I am connected to a Single-user database and the specific database location/file is listed. If I needed to move this database to a new computer, I would go to that folder location and would grab a copy of the SampleDatabase.mdf file as well as the SampleDatabase_log.ldf

On the new laptop, install SQCpack. HERE is the link on our site for the installation file for version 8. Then you can paste copies of your database .mdf and log.ldf files in a new spot of your choosing. Then you can open SQCpack and go to Menu – Database and at the bottom expand the Single-user SQCpack database (hit the Show button) and then you can click on the “Open a single-user SQCpack database”. Browse to the location of the .mdf file. You have now connected to your database.

The other important note about moving things to a new computer is if you made charts that were based on external sources (Excel files, Access files, etc). Those files would need to be copied/moved to the new computer as well. Keep in mind that when you made Charts within SQCpack to point to any external sources, like an Excel file on your desktop, that it is looking for an .xlsx file in a specific file path. If you move those external files to the new computer and change their file path location, that can break the connection to those charts. You might need to edit the Charts to repoint them to the right files.

Problem in SQC Pack

Error encountered: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Please follow the steps below. You can also pass this along to your IT team.

Try the following steps exactly as written.

  1. Go to http://www.microsoft.com/en-us/download/details.aspx?id=13255
  2. Download "AccessDatabaseEngine.exe" and save it somewhere (Do NOT download the x64 version)
  3. Open Command Prompt from the start menu
  4. Type "Start" followed by the file path to AccessDatabaseEngine.exe and finally end it with /passive

It will look something like: C:\Users\root>Start C:\Users\root\Desktop\AccessDatabaseEngine.exe /passive


Legacy Issue in Chart Runner Lean Software

Microsoft Access Runtimes to deal with bit-wise and Office Version incompatibility

With Office/Access 2019 installed,

CHARTRunner encountered an issue while displaying your chart. The chart settings need to be edited. 
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
  • #SAS 9.4 gives the following error:
ERROR: Connect: Class not registered 
ERROR: Error in the LIBNAME statement.

The solution is for someone with admin rights to install the following, in that order:

  1. 2013 Runtime - use the 64-bit one
    • regular install
  2. 2010 Runtime - use the 32-bit one, not the 64-bit one
    • run this from the command line with /passive parameter, ie AccessRuntime.exe /passive to avoid bitwise incompatibility error

2010 fixes CHARTRunner, 2013 SAS, so if only one is still required only install that runtime.

Related articles

Related articles: