EDI Changelog

24.9.2

Refactor GoogleSheetVersionUpdate DLL discovery and sheet update logic

Assigned to: Gavin
Updated: 17 March 2026

• Added regex-based DLL filtering to target specific Sandfield/SAL Messaging assemblies, excluding Tests, Migrator, and TestHarness

• Added configurable subdirectory scanning via new IncludeSubdirectories app setting

• Rewrote sheet update logic to support adding new column headers for machines and new rows for unmatched addins

• Removed unused dependencies

• Added TestHarness console project for local testing

24.9.1

Replace Octopus Deploy with Azure Pipeline Artifacts

Assigned to: Nikhil
Updated: 27 February 2026
Ticket: https://sandfield.atlassian.net/browse/CD-411 

• Replaced Octopus deploy steps with Azure Pipeline artifact publishing

24.9.0

Fixed Partner Settings Edit fields pre-filling with undefined.

Assigned to: Remus
Updated: 01 January 2026

• Pressing Edit now correctly fills the Key and Value fields with the setting's current values.

24.8.1

Use application/xml as default webservice response content type

Added by: Eve
Assigned to: Eve
Updated: 4 December 2025

• Default web service content type will now be overridable by transport settings (still application/xml by default).

24.8.0

Preserve Partner from Interchange for Portal Out Processes

Added by: Nikhil
Assigned to: Nikhil
Updated: 17 November 2025

• Added PreservePartnerFromInterchange checkbox to Process configuration (Portal Out processes with destinationType = Messaging)

• Added PreservePartnerFromInterchange property to PartnerEvent class

• Modified Interchange.cs DeliverToMessaging() to pass Partner.PartnerID when PreservePartnerFromInterchange is enabled

• Allows Portal Out processes to stamp MSG.Message with EDI Interchange Partner instead of transport's default partner

24.7.1

Fix a bug where synchronous messages would get stuck in "Sending" status indefinitily.

Fix a memory leak in the engine

Added by: Scott
Assigned to: Scott
Updated: 25 November 2025

24.7.0

Highlight DataElement Attributes

Added by: Gavin
Assigned to: Gavin
Updated: 16 October 2025

Work With Module:

• Support highlighting DataElement attributes

• Make it directly jump to the highlight after clicking nodes in the message structure

• Support highlighting the nodes in the message structure panel

24.6.2

Remove TinyMCE references

Added by: Nikhil
Assigned to: Nikhil
Updated: 16 October 2025

• Removed all references of TinyMCE

24.6.1

Fix Copying EDIFACT Message Standards

Added by: Eve
Assigned to: Eve
Updated: 13 October 2025

Work With Module:

• Fix loading of EDIFACT message standards without page IDs, which happens while copying one.

24.6.0

Add ability to store and load Assembly References from Database

Added by: Nick
Assigned to: Nick
Updated: 21 August 2025

Work With Module:

• Add maxAllowedContentLength setting in the Web.config

• Improve Function Test Error logging in general, including the Function Test

• On the Assembly Reference Page:

  • Add Storage Type option that allows the user to select either Disk or Database (Disk is default)

  • When the user selected Database, it allows the user to upload & download the Dll file

• On the Function Page:

  • Improve the error message when failed to import

  • Fixed up some UI when importing the function -> not showing the Return Type value

  • Refactored the HTML part in the Function js file

  • Update the Assembly Reference tab and add a new column that indicates where it is stored (Db or Disk)

  • Improve validation when inserting Assembly Reference to the function -> Cannot insert dupliate AR

Engine:

• Improve the dictionary CrossfireFunctions with ConcurrentDictionary

• Improve error message for missing connection string is not provided before running the SQL function

• Add support to load Assembly Reference from database

24.5.3

Use the default keep for days setting for processes

Assigned to: Gavin
Updated: 5 September 2025

• Use the default keep for days setting for processes

24.5.2

Improve the stability of the engine

Added by: Gavin
Assigned to: Gavin
Updated: 05 August 2025

• Improve the stability of the engine

24.5.1

Fix margins in dashboard

Added by: Gavin
Assigned to: Gavin
Updated: 04 August 2025

• Fix margins in dashboard

24.5.0

Fixing text qualifier in Engine

Added by: Nick
Assigned to: Nick
Updated: 31 July 2025

• Incorrectly parsed double quote character in CSV

• Improve error message if Delimeter message standard is not set up correctly

• Upgrade Messaging in Engine TestHarness

24.4.2

Rename Health Check Stored Procedure Parameter

Added by: Nick
Assigned to: Nick
Updated: 31 July 2025

• Rename Health Check Stored Procedure Parameter

24.4.1

Authentication Bug Fix

Added by: Nikhil
Assigned to: Nikhil
Updated: 30 July 2025

• Get the username and password from the auth header first and then fallback to user it from the request body if not present in the header.

24.4.0

Improve Function Test UX

Added by: Nick
Assigned to: Nick
Updated: 21 July 2025

• Improve function test error message by showing it under the function. Was showing it via the windows pop up message.

• Improve the error message by only showing the exception message and not the stacktrace.

• When executing the function in Engine, there's a parameter that let you choose to throw a detailed exception or just exception message only.

24.3.1

Insert Function Bug

Added by: Nick
Assigned to: Nick
Updated: 12 June 2025

• Previously, when we insert functions, we insert the blank EntityID as 0 instead of null. So we had an issue when we were trying to look up the functions.

24.3.0

Updated OPCC to return full error response

Added by: Lennox
Assigned to: Lennox
Updated: 3 June 2025

• Updated incoming and outgoing OPCC endpoints to capture the response message and pass it back to the Web API transport

24.2.12

Public Holiday Importer - Subtract Days

Added by: Eve
Assigned to: Eve
Updated: 17 July 2025

• Add ability to subtract days in public holiday importer.

24.2.11

Remove initial size from all string builder constructors - hopefully reduce memory usage

Added by: Scott
Assigned to: Scott
Updated: 10 July 2025

• Remove initial size from all string builder constructors - hopefully reduce memory usage. When using dotMemory, a lot of these were found to be empty or near empty

24.2.10

Add content-type header to the OutgoingHttp WebAPI

Added by: Nick
Assigned to: Nick
Updated: 12 May 2025

• Add content-type header to the OutgoingHttp WebAPI

24.2.9

Update Web Service & EDI WorkWith Web.config

Added by: Nick
Assigned to: Nick
Updated: 24 Apr 2025

• Updated the Identity and ServiceName in Web.config

• Added <pages validateRequest="false"/> in Web.config

• Added <httpCookies httpOnlyCookies="true" requireSSL="true" /> in EDI Web.config

24.2.8

Fix Azure Pipeline - tag automated pipeline

Added by: Nick
Assigned to: Nick
Updated: 19 Mar 2025

• Fixing Azure Pipeline, failed to build because the project is referencing missing files in bin folder

24.2.7

Fix Azure Pipeline - tag automated pipeline

Added by: Nick
Assigned to: Nick
Updated: 19 Mar 2025

• Fixing Azure Pipeline, failed to build because the project is referencing missing files in bin folder

24.2.6

Fix all the dependency issues on EDI WorkWithModule

Added by: Nick
Assigned to: Nick
Updated: 18 Mar 2025

• EDI WorkWithModule is now using the new version of nugets without any login issue

• Upgrade Messaging nuget, which remove the SixLabors security patches

24.2.5

Update messaging, remove unused nugets

Added by: Scott
Assigned to: Scott
Updated: 12 Mar 2025

• Update messaging, remove unused nugets

24.2.4

Add better error logging to the XPathValue built in function

Added by: Scott
Assigned to: Scott
Updated: 12 Mar 2025

• Add better error logging to the XPathValue built in function

24.2.3

Fix bugs on Bulk Export page and Process page

Added by: Gavin
Assigned to: Gavin
Updated: 07 Mar 2025

• Fix the null reference error on Crossfire Admin -> Bulk Export page when user doesn't have permissions to ALL of the following objects: Functions, MessageStandards, Processes.

• Fix a UI bug on Process page.

24.2.2

Fix the previous engine change - adding text qualifier message standard

Added by: Nick
Assigned to: Nick
Updated: 06 Mar 2025

• The position can be any number below 0 and we didn't account that.

24.2.1

Downgrade Microsoft.Identity.Client to 4.56.0

Added by: Nick
Assigned to: Nick
Updated: 03 Mar 2025

• Downgrade Microsoft.Identity.Client to 4.56.0

24.2.0

Implement OAuth2 feature to Crossfire Service V2

Added by: Nick
Assigned to: Nick
Updated: 14 Feb 2025

• Implement OAuth2 feature to Crossfire Service V2

24.1.38

Fix text qualifier in delimited message standard

Added by: Nick
Assigned to: Nick
Updated: 10 Feb 2025

• Previously, if there's a newline character in a cell, it will actually go to the new line instead of counting that character into the cell even though the text qualifier is specified.

24.1.37

Fix validating function name in the mapping

Added by: Nick
Assigned to: Nick
Updated: 03 Feb 2025

• Previously, it does not check if the function name exists or not. So it will not clear the look up field when it is using an invalid function name.

• Also made the function not a required field, as we previously never validate that field. (If we make it a required field, it will complain it when we try to save the process)

24.1.36

Fix "Insecure cookie setting"

Added by: Nick
Assigned to: Nick
Updated: 16 Jan 2025

• Fix "Insecure cookie setting: missing Secure flag"

24.1.35

Fix notification message

Added by: Nick
Assigned to: Nick
Updated: 13 Jan 2025

• Use process name for the process field, instead of ServiceProvide.Name 

24.1.34

Add different favicons

Added by: Scott
Assigned to: Scott
Updated: 09 January 2025

• Add different favicons

24.1.33

Fix a bug when reading CDATA XML elements out of order

Added by: Scott
Assigned to: Scott
Updated: 09 January 2025

• Fix a bug when reading CDATA XML elements out of order. There is logic to start searching elements from the beginning, but it does not contain the CDATA nodeReader.NodeType logic

• https://mainfreightit.atlassian.net/browse/EUCRF-267 

24.1.32

Upgrade Scheduling nuget

Added by: Nick
Assigned to: Nick
Updated: 15 Nov 2024

• Upgrade Scheduling nuget

24.1.31

Updated WebService

Added by: Jacob
Assigned to: Jacob
Updated: 14 Nov 2024

• Added new backend functionality to accept the GetLifecycle WebMethod call.

24.1.30

Clean up

Added by: Nick
Assigned to: Nick
Updated: 13 Nov 2024

• Add "URL Rewrite" in Web Service V2, so no more manual config fix

• Clean up and update the nugets to match the version with Crossfire and scheduling

• Vulnerable patching System.Text.Json -> 8.0.5

24.1.29

Update pipeline

Added by: Nick
Assigned to: Nick
Updated: 06 Nov 2024

• Missing deadman switch pipeline

• Remove EB Test pipeline

• Fix typo

24.1.28

Improve monitoring function

Added by: Nick
Assigned to: Nick
Updated: 05 Nov 2024

• Improve monitoring function

24.1.27

Missing images

Added by: Nick
Assigned to: Nick
Updated: 25 Oct 2024

• Missing images in /Source/Sandfield.EDI.Admin.WorkWithTheme/Image/Layout

24.1.26

Update web.config

Added by: Nick
Assigned to: Nick
Updated: 18 Oct 2024

• Update Web.config

24.1.25

Forgot to update moment.js

Added by: Nick
Assigned to: Nick
Updated: 20 Sept 2024

• Updated moment.js in messaging, but forgot to update here

• Remove all debug="true"

24.1.24

Remove all Database Migrations in this solution

Added by: Nick
Assigned to: Nick
Updated: 07 Oct 2024

• Remove all Database Migrations in this solution because will be using the newer database migration

24.1.23

Added MessageAttachment Index

Added by: Jacob
Assigned to: Jacob
Updated: 20 Sept 2024

• Added Index IX_MessagePrimaryID on table MessageAttachment. This was causing issues with the purger if there were many messages with attachments.

24.1.22

Fix missing dll

Added by: Nick
Assigned to: Nick
Updated: 17 Sept 2024

• Missing Sandfield.SALCore.PasswordSecurity.dll when deploying it

24.1.21

Fix Life Cycle & Web Service

Added by: Nick
Assigned to: Nick
Updated: 12 Aug 2024

• Full Life Cycle was showing Inbound "direction" even though it is an Outbound Message Archive.

• And the Status was not showing because it is a null.

• The reason is causing this is because it is joining the Interchange table, however the message is getting route, so it won't show up at all.

• Add max request in web service in web.config

24.1.20

Fix a bug when checking for unsafe file types

Added by: Gavin Cheng
Assigned to: Gavin Cheng
Updated: 13 Aug 2024

• Fix a bug when checking for unsafe file types

24.1.19

Fix web service again

Added by: Nick
Assigned to: Nick
Updated: 09 Aug 2024

• Fix web service response where it includes the aspx content

24.1.18

Fix web service response

Added by: Nick
Assigned to: Nick
Updated: 09 Aug 2024

• Fix web service response where the logic was incorrect

• Update SettingXml to SettingsXml

24.1.17

Update Azure Pipeline

Added by: Nick
Assigned to: Nick
Updated: 07 Aug 2024

• Update Azure Pipeline for package Sandfield.SAL.EDI.Web.ServiceV2

24.1.16

Fixing folder path in DB Migration

Added by: Nick
Assigned to: Nick
Updated: 31 July 2024

• Fixing folder path in DB Migration

24.1.15

Updated version of messaging

Added by: Nick
Assigned to: Nick
Updated: 31 July 2024

• Updated Messaging references to 24.2.5

24.1.14

Missing Show Inactive filtering for some WKW objects

Added by: Nick
Assigned to: Nick
Updated: 24 July 2024

Missing Show Inactive filtering for some WKW objects

24.1.13

Log the errors on the message instead of in the log files

Added by: Gavin Cheng
Assigned to: Gavin Cheng
Updated: 29 July 2024

• Log the errors on the message instead of in the log files

24.1.12

Fix settings for empty cData Nodes

Added by: Eve Ryan
Assigned to: Eve Ryan

• Fixed error when a mapping produces empty cData nodes when
  the remove empty elements setting on the message standard is
  set to "Convert empty elements to short tags" or is marked with ##EMPTY##
  for "defined on data element". These empty cData nodes will now be removed.

24.1.11

Include TLS 1.2 on Webservice HTTP Request

Added by: Jacob
Assigned to: Gavin

• This update adds TLS 1.2 to the SecurityProtocol before creating the request.

24.1.10

Updated version of messaging

Added by: Lennox Young
Assigned to: Lennox Young
Updated: 17 July 2024

• Updated Messaging references to 24.2.3

24.1.9

cXML Support for web service responses

Added by: Eve Ryan
Assigned to: Eve Ryan

• Fixed cXML response not being returned when enabled on the incoming transport

• Fix error due to reloading settings

24.1.8

Fix engine location

Added by: Nick
Assigned to: Nick

• Fix engine location.
  The engine location was having two dash "\" and the external system table was not updated as well.

24.1.7

Fix to Message Attachment Validation

Added by: Jacob Clark
Assigned to: Jacob Clark

• There was an off by one error, as well as an unwanted side effect of altering/removing items from the attachment ArrayList.

24.1.6

Update error message when importing duplicate message standards

Added by: Gavin Cheng
Assigned to: Gavin Cheng

• Update error message when importing duplicate message standards, to include the Message Standard name.

24.1.5

Fix variable in code for migration

Added by: Nick
Assigned to: Nick

• Fix variable in code for migration

24.1.4

Fix variable in code for migration

Added by: Nick
Assigned to: Nick

• Fix variable in code for migration

24.1.3

Update External System Engine path location

Added by: Nick
Assigned to: Nick

• Update External System Engine path location, because we moved the engine to subfolder.

24.1.2

Fixed Entity checking on PreRendering

Added by: Nick
Assigned to: Nick

• Entity ID is null when open New Code List. We shouldn't do entity checking for it.

24.1.1

Fixed building options

Added by: Lennox
Assigned to: Lennox

• Updated the EDI SALCore proj file to mark all proc and function sql files as embedded resources and build all dependencies.

24.1.0

Upgraded EDI SALCore to .NET Standard

Added by: Lennox
Assigned to: Lennox

• Upgraded SALCore from .NET Framework to Standard

24.0.5 - 24.0.6

Fixed migrations

Added by: Nick
Assigned to: Nick

• Fixed migrations

24.0.4

Move engine to subfolder

Added by: Nick
Assigned to: Nick

• Move engine to subfolder. Was in the engine root folder and was causing quite a lot of dependency issue.

24.0.3

Permission checking SP was all over the place

Added by: Nick
Assigned to: Nick

• There were 2 versions of permission checking SP in 2 different database. Fixed it by properly using the SP in the correct database.

24.0.2

Fixing open new function stuck bug

Added by: Nick
Assigned to: Nick

• After we added the function test, when we open a new function, it will be stuck at loading because it is trying to load the tests for the function.

24.0.1

Fix dependencies

Assigned To: Lennox Young
Added By: Lennox Young

• Updated salcor dependencies to 3.4.1

• Updated scheduling dependencies to 21.2.1

• Updated messaging dependencies to 24.0.3

• Fixed broken migrations