This is a guide on how to upgrade Pronestor Room & Catering to latest version.
The upgrade will involve server software and Pronestor Outlook Add-in for customers using the add-in
IMPORTANT - please do a backup of your current installation, files and database - in case a roll-back will be required. (see section later in this document on how to find the application folder and database)
IMPORTANT - for larger installations we do strongly recommend that a test environment is used to validate upgrade before applying to production environment
UPGRADE - server side
- Have you ensured a full backup and roll back strategy?
Files/application/database must be backed up as described later in this article
- Download the upgrade file to the server hosting Pronestor Room & Catering - request download link from Pronestor
- Unzip the zip file so an "UpgradeFolder" is created within the root folder of the current installation (see "Locating the server side Web application folder and database" to find the folder)
- Navigate to the Upgradefolder
- Go to IIS, locate the Application pool "ProNestor", and stop this Pool.
- Run the "Verify.bat" to ensure that everything is located correct - if it fails, read the error before resuming
- Run the "FULL_UPGRADE.bat" to start the upgrade.
- Go to IIS, locate the Application pool "ProNestor", and start this Pool.
When done - please login on to the Pronestor solution via web to validate the upgrade.
UPGRADE - Exchange Sync Service
- Download the latest ExchangeBookingSyncService file to the server hosting Pronestor Room & Catering - request download from Pronestor
- Unzip the "ExchangeBookingSyncService.zip" to a temporary folder
- Stop the "ExchangeBookingSyncService" via Services in Windows
- Copy all files EXCEPT the "ExchangeBookingSyncService.exe.config" from the temporary folder to the location of the current installed ExchangeSyncService
- Start the "ExchangeBookingSyncService" via Services in Windows
UPGRADE - Pronestor Outlook add-in
- Login to Pronestor Room
- Choose Administration->Settings->Other Settings
- Create the installers
The updated add-in can be distributed using
- Automatic upgrade - Let Pronestor auto update the users add-ins by enabling the "Enable automatic Outlook Add-In upgrades"
- Manually upgrade - download and run the MSI for the matching Outlook version
- Managed distribution - download the MSI and configure your software disbutribution software to update the add-in.
Locating the server side Web application folder and database
- Open Internet Information Service
- Locate the web site or directory called "Pronestor"
- Right click and choose "Browse" - this will open a File Explorer where the application is installed
- Within the application folder open the configuration folder
- Open the connectionStrings.config with notepad - the connection string including database server references will be listed in this file
This service is only relevant and available for customers with sync module and Exchange co-existence!
- Open Services (services.msc) on the Web Server
- Locate the service "ExchangeBookingSyncService"
- Right click and choose "properties" - the folder is shown in the section "path to executables"
- If using a virtual environment - please take a snap shot of the full instance
- If using a physical server - please take backup of the web folder and sync service folder
(please check section above for locating web folder and sync service folder)
- Make full database backup of the Pronestor database
(please check section above for locating the database)
Please check other folder and files that might have been applied to server since last upgrade, to ensure these as well.
IMPORTANT - A rollback may only be performed if NO user data/booking datahas been saved to the Pronestor Room & Catering application. If doing so any way - booking information will be lost and unforsesen issues may occur after roll back. We DO NOT support nor recommend such scenarios!
Steps involved in a roll back
- Stop application pool for Pronestor Web Site
- Stop Sync service
- Restore database from backup set
- Restore files into the web folder from backup of web folder and sync service
(set permissions write permission on license, app_data, content folder in Pronestor folder - for the application pool user)
- Restore Sync Service files
- Start Sync Service
- Start Application pool
ISSUES DURING UPGRADE
- If the ExchangeBookingSyncService can't be shut down - please try the following
- Open task manager - and locate PID for process within the Details tab
- Open Powershell - and subsitute the XYZ with the PID
taskkill /f /pid 20428