KeystoneIntranet - Recent changes [en]

Keystone Cloud Tunnel (Cloudflare)

Jquinn — Fri, 28 Aug 2026 13:52:37 GMT

Installation & Configuration of Customer Server

← Older revision		Revision as of 13:52, 28 August 2026
Line 44:		Line 44:

	===Existing Customer Setup===		===Existing Customer Setup===
	# ~~Download the web~~ update on the server ~~and release it so workstations will update. Once released '''do not''' Restart Keystone~~.		# Transfer Keystone update to the server.
	# Install the update on the server using the EXE. This will show the services screen during the update where Keystone Cloud Tunnel can be selected.		# Install the update on the server using the EXE. This will show the services screen during the update where Keystone Cloud Tunnel can be selected.
	# Make sure the files are in the settings folder before you install the service.		# Make sure the files are in the settings folder before you install the service.
	# C:\ProgramData\GivenHansco\Keystone\Settings folder		# C:\ProgramData\GivenHansco\Keystone\Settings folder
			# Once the update is complete and Cloudflare is setup. Load the update via system maintenance -> Updates -> Load Update.
			## This will release the update to all other workstations.

	==Website Setup==		==Website Setup==

External APIs

Pmorey — Wed, 26 Aug 2026 18:31:08 GMT

← Older revision		Revision as of 18:31, 26 August 2026
Line 1:		Line 1:
			==Introduction==
			<p>Keystone supports several external integrations with various vendors through APIs provided by the Keystone REST server.</p>

			==APIs==

	{\| border="3" cellspacing="0" cellpadding="3" class="wikitable"		{\| border="3" cellspacing="0" cellpadding="3" class="wikitable"
	! External Vendor		! External Vendor

External APIs

Pmorey — Wed, 26 Aug 2026 18:29:01 GMT

Created page with "{| border="3" cellspacing="0" cellpadding="3" class="wikitable" ! External Vendor ! API Version ! API Base URL ! API Key Caller Name ! Functions Supported ! Keystone Version |- | AICrete | 2 | /rest/ext/AICrete/v2 | exaicrete | | 5.3.3 |- | Giatec | 2 | /rest/ext/GiaTec/v2 | exgiatec | | 5.2.8 |- | Quadrel | 2 | /rest/ext/Quadrel/v2 | exquadrel | | 5.3.3 |- | SalesForce | 2 | /rest/ext/salesforce/v2 | exsalesforce | | 5.0 |- | Salesinsight | 2 | /rest/ext/salesinsight/v2..."

New page

{| border="3" cellspacing="0" cellpadding="3" class="wikitable"
! External Vendor
! API Version
! API Base URL
! API Key Caller Name
! Functions Supported
! Keystone Version
|-
| AICrete
| 2
| /rest/ext/AICrete/v2
| exaicrete
|
| 5.3.3
|-
| Giatec
| 2
| /rest/ext/GiaTec/v2
| exgiatec
|
| 5.2.8
|-
| Quadrel
| 2
| /rest/ext/Quadrel/v2
| exquadrel
|
| 5.3.3
|-
| SalesForce
| 2
| /rest/ext/salesforce/v2
| exsalesforce
|
| 5.0
|-
| Salesinsight
| 2
| /rest/ext/salesinsight/v2
| exsalesinsight
|
| 5.3.4
|-
| Slabstack
| 1
| /rest/ext/slabstack/v1
| exslabstack
|
| 5.3.3
|-
| Stonemont QC
| 1<BR>2
| /rest/kbcqciapi1<BR>/rest/ext/stonemont/v2
| (none)<BR>exstonemont
|
| 5.2.8<BR>5.2.8
|}

Main Page

Pmorey — Wed, 26 Aug 2026 18:13:50 GMT

External/Third Party Devices

← Older revision		Revision as of 18:13, 26 August 2026
Line 81:		Line 81:
	:[[Payroll: Federal & State Electronic Filing Guides]]		:[[Payroll: Federal & State Electronic Filing Guides]]

	===External/Third Party ~~Devices~~===		===External/Third Party Integrations===
	:[[Device Server and Device Aggregator]]		:[[Device Server and Device Aggregator]]
	:[[Device Aggregator/Device Server Issues]]		:[[Device Aggregator/Device Server Issues]]
Line 88:		Line 88:
	:[[Notification Devices]]		:[[Notification Devices]]
	:[[HaulHub (Tickets to State DOT)]]		:[[HaulHub (Tickets to State DOT)]]
			:[[External APIs]]

	===Interbase Database===		===Interbase Database===

Ticket Form Fields

Jquinn — Wed, 26 Aug 2026 17:44:29 GMT

How to Print a Mix Design

← Older revision		Revision as of 17:44, 26 August 2026
(2 intermediate revisions by the same user not shown)
Line 75:		Line 75:
	FEE_PAID (TOTAL FEE PAID)		FEE_PAID (TOTAL FEE PAID)
	PAY_CLASS (SHOWS THE PAY CLASS USED)		PAY_CLASS (SHOWS THE PAY CLASS USED)
			</PRE>

			==How to Print a Mix Design==
			<PRE>
			DETAIL 4
			LENGTH XX
			FIELD COMP_PRODUCT_CODE
			FIELD COMP_QTY_ASSEMBLY
			FIELD COMP_UMS
			FIELD COMP_DESCRIPTION_1
			FIELD COMP_INGREDIENT_TYPE_DESC
	</PRE>		</PRE>

User Alerts

Pmorey — Tue, 25 Aug 2026 23:32:41 GMT

@@ Line 1: / Line 1: @@
 Keystone supports User Alerts which are used to communicate important information to Keystone users.
-CCTALERT table
+==CCTALERT table==
-The key to this feature is the CCTALERT table in the CCWSYS database.
+<p>The key to this feature is the CCTALERT table in the CCWSYS database.</p>

User Alerts

Pmorey — Tue, 25 Aug 2026 23:11:07 GMT

Created page with "Keystone supports User Alerts which are used to communicate important information to Keystone users. CCTALERT table The key to this feature is the CCTALERT table in the CCWSYS database."

New page

Keystone supports User Alerts which are used to communicate important information to Keystone users.

CCTALERT table

The key to this feature is the CCTALERT table in the CCWSYS database.

Main Page

Pmorey — Tue, 25 Aug 2026 23:10:06 GMT

Common System Topics

← Older revision		Revision as of 23:10, 25 August 2026
Line 72:		Line 72:
	:[[Keystone Installation and Configuration]]		:[[Keystone Installation and Configuration]]
	:[[Command Import]]		:[[Command Import]]
			:[[User Alerts]]

	===Common Software Topics===		===Common Software Topics===

KServer JSON Files

Pmorey — Tue, 25 Aug 2026 23:04:58 GMT

Actions

@@ Line 79: / Line 79: @@
 | JSONValue representing generator value (if v4 not specified)
 | obtain a database generator value (once per request)
 |-
 | KBackupFileKey(v1, v2)

Keystone Cloud Tunnel (Cloudflare)

Hhildreth — Thu, 13 Aug 2026 13:12:34 GMT

Website Setup

← Older revision		Revision as of 13:12, 13 August 2026
(3 intermediate revisions by the same user not shown)
Line 9:		Line 9:
	===Creating a New Tunnel===		===Creating a New Tunnel===

	Creating a new tunnel requires several steps. These steps have been consolidated into a single Windows Command Batch file. Currently, this resides on the Keystone Internal Build Testing server (192.168.2.232.)		Creating a new tunnel requires several steps. These steps have been consolidated into a single Windows Command Batch file. Currently, this resides on the Keystone Internal Build Testing server (192.168.2.232)

	# Connect to the internal build testing server (you can ~~teamviewer~~ or RDP.)		# Connect to the internal build testing server (you can TeamViewer or RDP.)
	# Open a Windows Command prompt.		# Open a Windows Command prompt.
	# Type: CD \CCGH\CFTUNNEL		# Type: CD \CCGH\CFTUNNEL
Line 33:		Line 33:
	# Click the 3 dots to the right of "API Credentials", select "New Record", select "Cloudflare Tunnel" as the record type and enter "Cloudflare Tunnel" as the name:		# Click the 3 dots to the right of "API Credentials", select "New Record", select "Cloudflare Tunnel" as the record type and enter "Cloudflare Tunnel" as the name:
	#:[[Image:Keeper_cloudflare_2.jpg\|border]]		#:[[Image:Keeper_cloudflare_2.jpg\|border]]
	# On the record screen, enter the "Tunnel Name" and "Tunnel ID" from the previous step (cut & paste from your command prompt window.) For the KSTunnel.~~JSON~~ box, you need to open the KSTunnel.json file that you downloaded and cut & paste the contents of this file into the box:		# On the record screen, enter the "Tunnel Name" and "Tunnel ID" from the previous step (cut & paste from your command prompt window.) For the KSTunnel.json box, you need to open the KSTunnel.json file that you downloaded and cut & paste the contents of this file into the box:
	#:[[Image:Keeper_cloudflare_3.jpg\|border]]		#:[[Image:Keeper_cloudflare_3.jpg\|border]]

Line 41:		Line 41:
	Perform the standard Keystone installation process. When the screen appears where you select which services to install, be sure that Keystone Cloud Tunnel is checked. When you click Next, you will see the following prompt:		Perform the standard Keystone installation process. When the screen appears where you select which services to install, be sure that Keystone Cloud Tunnel is checked. When you click Next, you will see the following prompt:
	:::image goes here		:::image goes here
	At this point, upload the two files downloaded after the tunnel was created into the C:\ProgramData\GivenHansco\Keystone\Settings folder (this folder should already have been created by the setup program.) Once the files are uploaded, click Next and proceed normally.		At this point, upload the two files downloaded after the tunnel was created into the C:\ProgramData\GivenHansco\Keystone\Settings folder (this folder should already have been created by the setup program). Once the files are uploaded, click Next and proceed normally.

	===Existing Customer Setup===		===Existing Customer Setup===
Line 53:		Line 53:
	# Access the Business		# Access the Business
	# Change the Following:		# Change the Following:
	# Keystone Connection String = DNS Name from the ~~Cloud Flare~~ Setup (https://ksXXXXXX.ghapi.net ~~(See~~ example ~~Below~~)		# Keystone Connection String = DNS Name from the Cloudflare Setup (https://ksXXXXXX.ghapi.net -- see example below)
	# Keystone Port = 443		# Keystone Port = 443
	# Keystone API Key = (Using the Support Tool) (If existing API key ~~exists~~ you can leave alone)		# Keystone API Key = (Using the Support Tool) (If existing API key is present you can leave alone)
	# Remove Keystone ~~relay~~ Connection field		# Remove Keystone Relay Connection field
	[[File:Cloudflare setup.jpg]]		[[File:Cloudflare setup.jpg]]
	[[File:Cloudflare setup2.jpg]]		[[File:Cloudflare setup2.jpg]]

Keystone Cloud Tunnel (Cloudflare)

Jquinn — Wed, 12 Aug 2026 18:09:53 GMT

Website Setup

← Older revision		Revision as of 18:09, 12 August 2026
(6 intermediate revisions by the same user not shown)
Line 44:		Line 44:

	===Existing Customer Setup===		===Existing Customer Setup===
	# Download the web update on the server and release it so workstations will update.		# Download the web update on the server and release it so workstations will update. Once released '''do not''' Restart Keystone.
	# Install the update on the server using the EXE. This will show the services screen during the update where Keystone Cloud Tunnel can be selected.		# Install the update on the server using the EXE. This will show the services screen during the update where Keystone Cloud Tunnel can be selected.
			# Make sure the files are in the settings folder before you install the service.
			# C:\ProgramData\GivenHansco\Keystone\Settings folder

	==Website Setup==		==Website Setup==
Line 51:		Line 53:
	# Access the Business		# Access the Business
	# Change the Following:		# Change the Following:
	# Keystone Connection String = DNS Name from the Cloud Flare Setup (ksXXXXXX.ghapi.net (See example Below)		# Keystone Connection String = DNS Name from the Cloud Flare Setup (https://ksXXXXXX.ghapi.net (See example Below)
	# Keystone Port = 443		# Keystone Port = 443
	# Keystone API Key = (Using the Support Tool)		# Keystone API Key = (Using the Support Tool) (If existing API key exists you can leave alone)
			# Remove Keystone relay Connection field
	[[File:Cloudflare setup.jpg]]		[[File:Cloudflare setup.jpg]]
	[[File:Cloudflare setup2.jpg]]		[[File:Cloudflare setup2.jpg]]
	[[File:Cloudflare setup3.jpg]]		[[File:Cloudflare setup3.jpg]]


	==Last Steps==		==Last Steps==
	# Make sure Paul is aware of the customers that are moved from Keystone Relay		# Make sure Paul is aware of the customers that are moved from Keystone Relay
	# '''(If a customer has a third party interface do not remove the relay at this time -- 8.6.26)''' Make sure the relay is disabled or uninstalled Command prompt - (sc delete ksrelay_service)		# '''(If a customer has a third party interface do not remove the relay at this time -- 8.6.26)''' Make sure the relay is disabled or uninstalled Command prompt - (sc delete ksrelay_service)

Notification Devices

Pmorey — Tue, 11 Aug 2026 13:02:17 GMT

EMAILSMTP Parameters

← Older revision		Revision as of 13:02, 11 August 2026
(One intermediate revision by the same user not shown)
Line 653:		Line 653:
	\|-		\|-
	\| SHOWPCTERROR		\| SHOWPCTERROR
	\| Show or hide "% ~~Error~~" in ingredient list		\| Show or hide "Variance" and "Variance %" in ingredient list
	\| Y/N		\| Y/N
	\| Y		\| Y
Line 768:		Line 768:
	\|-		\|-
	\| SHOWPCTERROR		\| SHOWPCTERROR
	\| Show or hide "% ~~Error~~" in ingredient list		\| Show or hide "Variance" and "Variance %" in ingredient list
	\| Y/N		\| Y/N
	\| Y		\| Y

Main Page

Pmorey — Sat, 08 Aug 2026 13:57:33 GMT

← Older revision		Revision as of 13:57, 8 August 2026
Line 30:		Line 30:
	:[https://givenhansco.sharepoint.com/Lists/Share%20Calendars/Color%20Calendar.aspx Company SharePoint Calendar]		:[https://givenhansco.sharepoint.com/Lists/Share%20Calendars/Color%20Calendar.aspx Company SharePoint Calendar]
	\|		\|
			:[[Support_Alerts#Stop_Windows_Updates_during_Keystone_Update_-_8/8/2026 \|Stop Windows Updates during Keystone Update]] 8/8/2026
	:[[iSolved Keystone Integration]] Jan. 2025		:[[iSolved Keystone Integration]] Jan. 2025
	:[[Support_Alerts#Keystone_Relay_Server_fails_to_start_-_10/19/2025 \|Keystone Relay Server fails to start]] 10/19/2025		:[[Support_Alerts#Keystone_Relay_Server_fails_to_start_-_10/19/2025 \|Keystone Relay Server fails to start]] 10/19/2025

Support Alerts

Pmorey — Sat, 08 Aug 2026 13:56:24 GMT

← Older revision		Revision as of 13:56, 8 August 2026
Line 1:		Line 1:
			==Stop Windows Updates during Keystone Update - 8/8/2026==

			PROBLEM: When performing a Keystone update that contains long-running database updates, Windows may decide to install updates and reboot the PC.

			EXPLANATION: Windows can install updates at any time and may decide to reboot the PC if necessary to complete the updates if it thinks the PC is "idle." When a Keystone update is in progress and upgrading the company database, since there is no user interaction (keyboard/mouse) Windows may mistakenly believe that the PC is idle and that it is OK to reboot.

			SOLUTION: Temporarily "pause" the Windows update service.

			# Start a Command Prompt as Administrator.
			# Type: <b>net stop wuauserv</b>
			# When the Keystone update is complete, type: <b>net start wuauserv</b>

	==Keystone Relay Server fails to start - 10/19/2025==		==Keystone Relay Server fails to start - 10/19/2025==

Keystone Cloud Tunnel (Cloudflare)

Jquinn — Thu, 06 Aug 2026 17:23:06 GMT

Last Steps

← Older revision		Revision as of 17:23, 6 August 2026
(13 intermediate revisions by the same user not shown)
Line 44:		Line 44:

	===Existing Customer Setup===		===Existing Customer Setup===
	~~(TBD - the idea is to download~~ the web update and release it so workstations will update~~, but install~~ the update on the server using the EXE. This will show the services screen during the update where Keystone Cloud Tunnel can be selected.)		# Download the web update on the server and release it so workstations will update.
			# Install the update on the server using the EXE. This will show the services screen during the update where Keystone Cloud Tunnel can be selected.

			==Website Setup==
			# Navigate to Manage Business
			# Access the Business
			# Change the Following:
			# Keystone Connection String = DNS Name from the Cloud Flare Setup (ksXXXXXX.ghapi.net (See example Below)
			# Keystone Port = 443
			# Keystone API Key = (Using the Support Tool)
			[[File:Cloudflare setup.jpg]]
			[[File:Cloudflare setup2.jpg]]
			[[File:Cloudflare setup3.jpg]]


			==Last Steps==
			# Make sure Paul is aware of the customers that are moved from Keystone Relay
			# '''(If a customer has a third party interface do not remove the relay at this time -- 8.6.26)''' Make sure the relay is disabled or uninstalled Command prompt - (sc delete ksrelay_service)

File:Cloudflare setup3.jpg

Jquinn — Wed, 05 Aug 2026 17:27:58 GMT

Jquinn uploaded File:Cloudflare setup3.jpg File uploaded with MsUpload

New page

File uploaded with MsUpload

File:Cloudflare setup2.jpg

Jquinn — Wed, 05 Aug 2026 17:27:01 GMT

Jquinn uploaded File:Cloudflare setup2.jpg File uploaded with MsUpload

New page

File uploaded with MsUpload

File:Cloudflare setup.jpg

Jquinn — Wed, 05 Aug 2026 17:25:58 GMT

Jquinn uploaded File:Cloudflare setup.jpg File uploaded with MsUpload

New page

File uploaded with MsUpload