HOW TO: Upgrade

v2.5.0.0 Sept 2024

API DOWNLOAD

https://drive.google.com/drive/folders/1eTaE-EB3i-c-frJHNvxv-rjGXq_mzI8f

Important Notice - Upgrading to 2.5.x

If you are upgrading from a version below 2.5.0 an extra step is required prior to running the installer, this is due to an update in the encryption algorithm used for the database connection strings in the applications appSettings.json configuration file.

• Delete the flaikResortService application (Control Panel -> Installed Apps - Uninstall)

• Delete the flaikResortService from 'Services'

Example commands to delete the service after install (as Administrator)
// Powershell v6+ example
Get-Service -Name 'Flaik*Staging*' | Remove-Service

// Command Prompt
sc delete FlaikResortServiceStaging

• Delete the Program folder from "C:\Program Files"

Upgraded Process

1 | Download the Installation Media

• Flaik Resort Service Setup-2.x.xx.0-Staging-x64.msi

• Flaik Resort Service Setup-2.x.xx.0-Release-x64.msi

2 | Run the Install

Double Click the msi package to start the Install, accepting the prompts.

3 | Confirm the contents of the appsettings.json file

The installer will have placed a new appsettings.json file in the ProgramFiles directory. We suggest using that file. You will need to

1. Set your POS Type (RTP = 1 , Siriusware = 2) if unsure pelase ask us or you can view the setting in the old file

2. Copy in your API key - if you don't have that please contact us.

3. Configure the database connection strings - sample below.

flaik encrypts the API and database values on startup. While installing we recommend keeping a copy in plain text either in a password manager or on your desktop.

Connection strings are encrypted after first run - please see below for format
"apiKey": "{API Key Here}",
    "flaikDatabaseConnectionString": "Data Source={your value here};Initial Catalog={your value here};User ID={your value here};Password={your value here};MultipleActiveResultSets=True;TrustServerCertificate=True;Connect Timeout=15",
    "resortDatabaseConnectionString": "Data Source={your value here};Initial Catalog={your value here};User ID={your value here};Password={your value here};MultipleActiveResultSets=True;TrustServerCertificate=True;Connect Timeout=15",

4 | Run the Database Scripts

Go to the Flaik Resort Folder on the application server: C:\Program Files\Flaik Resort Service and browse to the SQL folder in order to locate the SQL scripts that need to be executed to update the database schema. There are two scripts for the flaik database schema and scripts specific to your POS. Ensure you select the correct database after opening the scripts as USE statements are not included.

Flaik Database - All Upgrades	\SQL\1. FlaikUpdateScript.sql \SQL\2. FlaikStoredProcedures.sql
RTP|One Installations	\SQL\RtpOne\1. RTPOneRole.sql \SQL\RtpOne\2. RTPOneStoredProcedures.sql
Siriusware-v4 Installations	\SQL\Siriusware\1.SiriuswareCommon.sql \SQL\Siriusware\SiriusSQL-v4\2. SiriuswareRole.sql \SQL\Siriusware\SiriusSQL-v4\3. SiriusSQLStoredProcedures.sql
Siriusware-v5 Resorts Only	\SQL\Siriusware\1.SiriuswareCommon.sql \SQL\Siriusware\Siriusware-v5\2. SiriuswareRole.sql \SQL\Siriusware\Siriusware-v5\3. SiriusSQLStoredProcedures.sql

5 | Restart the Windows Service

6 | Test

In Internet Browser from Server, note that Internet Explorer will attempt to download the json response, chrome or firefox will display the response. Replace localhost as necessary if you are not on the server when hitting the health check url.

Staging	http://localhost:8002/health
Production	http://localhost:8001/health