Upgrade Notes

How to upgrade 

Run the upgrade script which can be found in the Upgrades folder - Upgrade_Script_BOSServer.sql. The upgrade script will upgrade the database from any previous version to the latest version. Download and copy the latest BOSServer.exe to the BOSServer folder. The Version number appears in the title bar of the application.

Enhancements and Fixes

Ver 25.01 - 16/07/2025 - Exe only

• Fixed: The Currency Updating service required SSL so we enabled TLS.

Ver 24.01 - 22/01/2024 - Exe and Script

HTTP Request Enhancements

• Request Headers and Request Headers SQL fields have been added.

• The Template button can now be used to generate templates in the Request Headers and Body Tabs.

• The Content-Type field has been removed in favor of adding Content-Type to the Request Header.

• The Token field, along with functionality to automatically fetch a token, has been removed.

Ver 23.03 - 26/04/2023 - Exe only

File Exchange - Files are now prefixed with a timestamp integer before they are copied to the Rejected/Imported folder - this prevents duplicate file names.

Fixed: A 'string literal exceeded maximum size... ' error was returned when trying to import large text files.

Ver 23.02 - 07/03/2022 - Exe only

An Actions button was added to the Home window - click the Actions button to select and execute the File Exchange Services. This makes it easier to select a file from your local drive and import it to a database on a cloud server.

An optional NOTE output parameter has been added to the File Exchange SQL - this can be used to return an error message based on verification of the file that is imported.

Fixed: The Currency import was returning an error after Currency Freaks once again reverted to JSON by default.

Ver 23.01 - 04/01/2022 - Exe only

HTTP Requests - Sundry fixes and enhancements.

Fixed: The Currency Updates service was fixed to support the new XML format from Currency Freaks. NB. Prior versions will NOT update currencies correctly.

Ver 22.06 - 20/06/2022 - Script and Exe

An HTTP Requests service has been added. See HTTP Requests 

Email Notifications can now also be used to update data - eg. to flag records that have been sent.

Fixed: Email Import - When an email was in MIME format, the Body was not successfully imported.  

Ver 22.05 - 08/06/2022 - Exe only 

An Import Text option has been added to the File Exchange service - this allows you to import an entire text file.

Ver 22.04 - 30/03/2022 - Exe only 

• The following change from the previous upgrade was reversed as it was causing duplicate email notifications to be sent: The action procedures have been updated to prevent the application from 'Not Responding' while Actions are executed. (Application.ProcessMessages)

• The Email Import Service was updated - notably, the input variables required in the SQL have been changed. A Template function has been added to generate the SQL that uses a standard procedure to import emails.

Ver 22.03 - 09/03/2022 - Exe only 

• The File Exchange - Export procedure was updated to make the process more robust.

• Updated the log for File Exchange - Export to be less verbose - only one line is generated when an Action is executed.

• A Clear Log function has been added to the main menu.

• The action procedures have been updated to prevent the application from 'Not Responding' while Actions are executed. (Application.ProcessMessages)

• Error trapping has been improved in all the modules.

Ver 22.02 - 23/02/2022 - Script and Exe

• XML  Files can now be imported (The XML parsing functionality is limited - see File Exchange )

• Email Import - This is a new Service that was added. See Email Import  

• A Find Panel has been added to all the grid views. 

• The redundant Notification and Datasnap components and code were removed.

Ver 22.01 - 14/02/2022 - Exe only

• Added Menu > Enable DB Monitor

• Fixed spacing in Headers

Ver 2021.01 - 19/10/2021

• The Currency Update functionality has been upgraded to work with the new RoE X and RoE / model used in BOS Enterprise.

• The database connection parameters are now extracted from the BSDB.ini file located in the same folder as BOSServer.exe.

• The Data Exchange action has been updated to support MS SQL2014

Ver 2021.01  - 13/08/2021

• The login functionality has been removed and the application now opens to the Activity log.

• The Scheduler is now automatically started when the application is started.

• Database Connection/Disconnection logging now includes the address of the Server

• The Data Exchange action has been enhanced to serve  as a Data Update action on the Target Database

Ver 2021.01 - 09/07/2021

• Fixed: In certain cases, a 'No FTP List Parsers have been found' error was returned when connecting to an FTP site.

Ver 2021.01 - 16/03/2021

• Updated the interface so that the Log displays on the opening screen - and added a Menu item to Save log to file

• The database connection is now selected from a QEDB.ini file which must be placed in the same folder as the executable.  This allows for a different Port No. to be used.

• Added a new File Exchange Action to Export Files (Any format) and import .csv files. See File Exchange 

• Added Copy functionality to the Email Action

• Fixed: When currencies were updated, a username wasn't assigned to the audit - now 'Auto' is assigned as the username