How To: Support TLS 1.2 Connections in the Business Intelligence Module

HighGear's Business Intelligence Module by default uses a different type of database connection to connect to the database server than the main HighGear application. Its particular connection type does not support TLS 1.2. Therefore, if TLS 1.0 and TLS 1.1 are disabled on the SQL Server, you will encounter the following error whenever the Business Intelligence Module or the main HighGear application need to talk to the database server: System.Data.OleDb.OleDbException:...

read more

How To: Point HighGear to a new Database Server

Pointing HighGear to a new database location and copying another HighGear database onto that new database server is a complicated process, and it must be performed precisely as described in this document. There is no danger of data loss or corruption on the source server, but the destination server will not operate correctly unless the entire process is performed correctly. Also, the same version of HighGear BPM software must be installed on both the source server and the destination server....

read more

How To: Use Ola Hallengren’s SQL Server Maintenance Solution

Any good database maintenance plan will include the core tasks of backups, integrity checks, index checks, and other types of maintenance tasks. One such tool that has been highly recommended for the last several years is the SQL Server Maintenance Solution created by Ola Hallengren (https://ola.hallengren.com). The SQL Server Maintenance Solution is supported on SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, and SQL Server 2014. To implement the SQL Server Maintenance...

read more

How To: Delete Users in HighGear

It is inevitable that a HighGear user will need to be deleted so that they no longer have access to HighGear. Fortunately, HighGear is able to handle such a situation without losing any data that the user was working on. This means that any data including tasks, audit trail history, comments and any other work will be preserved. To delete a user, you will need to search for the user in the Contacts page. Once you have click on the Users Profile, scroll down to the bottom right hand corner and...

read more

Installation: HighGear Software System Requirements

The following is a basic set of minimum requirements for the HighGear server system. A more advanced coverage of the topic and a checklist is available in the HighGear Installation Requirements Checklist support document. Server Software Supported Operating Systems Windows Server 2016 (recommended) Windows Server 2012 R2 (recommended) Windows Server 2012 Windows Server 2008 R2 Supported Database Servers SQL Server 2016 (recommended) SQL Server 2014 (recommended) SQL Server 2012 (recommended)...

read more

Installation: HighGear Software Installation Instructions

Check the System Requirements and ensure the system is operating correctly. Close any running applications. Run HighGear Setup, and follow the prompts. If you want to install HighGear with a separate database server, you should run the setup program on the web server. Next, the configuration utility will appear. Click Ok to continue. Note: Throughout the configuration utility, you can click on the small "?" buttons for help on individual fields. Most of the fields on the Database Configuration...

read more

How To: Create a Basic BI Report in HighGear

The steps below will walk you through the basics of creating a BI report in HighGear. The end result will be a report shows a list of tasks that have reached the high alert level and who is assigned to them. Click on the Business Intelligence tab under the Report page and click on Add a New Report. You will be on the page where you design the report. Under the Data panel, you will select two check boxes. There are “Jobs” and “Job Contact Names” Click Next Step to go the Ordering panel. Here...

read more

How To: Import Special Characters in a CSV File

Importing a CSV File with special characters such as é, require that the file be saved in a UTF-8 format. The rest of this article describes how to import the files without losing the special characters.  After all the data has been entered into Excel, the workbook needs to be saved as a CSV file. To do this, switch to the File tab, and then click Save As. Alternatively, you can press F12 to open the same Save As dialog.  In the Save as type box, choose to save your Excel file as CSV (Comma...

read more

How To: Troubleshoot HighGear Software’s Scheduling Service

HighGear uses a scheduling service to run a number of backend services for HighGear. There are times when the scheduling service is not running or stops. The purpose of this article is to describe some of the side effects of when the service is not running and what to do when that happens. The HighGear Scheduling Service is a Windows service that is a loop that runs once per minute. The service loops through the HighGear database on the server and checks it for scheduled. Here is a list of...

read more

How To: Clear the Cache in Internet Browsers on Mac

Chrome Click on the Chrome menu  on the browser toolbar Select Tools. Click Clear Browsing Data In the dialog that appears, select the checkboxes for the types of information that you want to remove. But be sure to include Empty the cache. Use the menu at the top to select the amount of data that you want to delete. Select beginning of time to delete everything. Click on Clear browsing data on the bottom. Your browser cache is now empty. Close HighGear and try again Firefox Click the menu...

read more