CAI ENGINE

1.2.0

Excel message standard format

Added: 2026-10-20
Added by: Scott Ferguson
Ticket: https://sandfield.atlassian.net/browse/CF-46422

• Reads Excel workbooks (.xlsx, .xlsm, .xlsb and .xls).

• Columns are matched by header name, handles merged headers, multiple tables per sheet, and total rows.

1.1.0

Auto-generated EDI acknowledgements (CONTRL / 997 / 999)

Added: 2026-10-20
Added by: Scott Ferguson
Ticket: https://sandfield.atlassian.net/browse/CF-46421

• Generates CONTRL, 997 or 999 acknowledgements for an existing mapping with a single helper call.

• Malformed interchanges get a proper reject.

• Optional "always accept" setting matches the old engine.

1.0.0

Initial release

Added: 2026-10-14
Added by: Scott Ferguson
Ticket: https://sandfield.atlassian.net/browse/CD-460

• Production release.

0.4.0

Error notifications, monitoring and auto-recovery, API functions, PDF reading and expanded EDI standards

Added: 2026-10-06
Added by: Scott Ferguson
Ticket: https://sandfield.atlassian.net/browse/CD-460

• Error handlers per mapping: ignore, custom email, record in Orders Portal, or forward to another mapping.

• Error emails are batched into summaries, with templates customisable per entity.

• Live telemetry per mapping and per server.

• Real health checks, with automatic restart when the engine stays unhealthy.

• Retry limits end infinite retry loops.

• API functions, function tests, and mocked function calls in system tests.

• Reads PDFs: labels, regions and tables spanning several pages. Can also split PDFs.

• More EDI standards: HL7, NCPDP, VDA, EANCOM, IATA and HIPAA.

0.3.0

Messaging handoff, dynamic-code guardrails, Message Standard validation

Added: 2026-08-03
Added by: Scott Ferguson
Ticket: https://sandfield.atlassian.net/browse/CD-460

• Legacy Messaging hands messages to the engine and sends the mapped output.

• Messages are routed by subject, sender, recipient, file name or content.

• Mapping code is sandboxed: risky APIs are blocked and runaway loops are stopped.

• Validation rules on message standards: required, length, range and allowed values.

• Mappings update live without a restart.

• Runs as a Windows service with a health endpoint.

0.2.0

System test diff, mapping providers, EDI standard support, and compilation endpoint

Added: 2026-05-22
Added by: Scott Ferguson
Ticket: https://sandfield.atlassian.net/browse/CD-460

• Smarter system test diff that ignores control numbers and BOMs.

• Code lists, EDI counters, saved values and SQL functions are available to mappings.

• Compile check returns errors without deploying.

0.0.0 - 0.1.0

Project architecture setup, initial prototype, and system tests

Added: 2026-04-07 to 2026-05-11
Added by: Scott Ferguson
Ticket: https://sandfield.atlassian.net/browse/CD-460

• Maps delimited, XML, JSON, fixed width, EDIFACT, X12 and Tradacoms, synchronously or asynchronously.

• System test endpoint.

CAI PORTAL

1.11.1

Deploy uses the target's external system and type settings

Added: 2026-10-27
Added by: Scott Ferguson
Ticket: https://sandfield.atlassian.net/browse/CF-46420

• Deployed transports and servers take their assembly and class settings from the target environment.

• Those fields no longer show as differences in the deploy preview.

1.11.0

Excel message standard format

Added: 2026-10-20
Added by: Scott Ferguson
Ticket: https://sandfield.atlassian.net/browse/CF-46422

• Excel is now a message standard format.

• System tests and messages accept Excel workbooks, with a sheet-by-sheet preview.

• The preview shows merged cells, error cells, formulas, hidden rows and a workbook map.

• The AI assistant understands workbook layouts when writing Excel mappings.

• PDF and Excel payloads can be downloaded as the original file.

1.10.0

Auto-generated EDI acknowledgements (CONTRL / 997)

Added: 2026-10-20
Added by: Scott Ferguson
Ticket: https://sandfield.atlassian.net/browse/CF-46421

• "Create CONTRL / 997 mapping" builds a ready-to-run acknowledgement mapping in one click.

• Acknowledgement mappings follow version changes, are removed with their parent mapping, and deploy with it.

• Optional "always accept" setting matches the old engine's behaviour.

• The AI assistant knows the acknowledgement helpers.

1.9.1

Post go-live performance and bug fixes

Added: 2026-10-20
Added by: Scott Ferguson
Ticket: https://sandfield.atlassian.net/browse/CF-46420

• Large listings no longer time out. Counts stop at 10,000+, with a "Count exact" button.

• Faster dashboard, with its data shared between viewers.

• Crossfire Messages still shows results when a legacy source fails.

• Fixed long transport passwords, over-long text fields and the Lifecycle tab error.

• Files can be dragged onto the AI assistant.

1.9.0

Authentication methods, deploy caller identity, and web farm support for background jobs

Added: 2026-09-12
Added by: Scott Ferguson
Ticket: https://sandfield.atlassian.net/browse/CD-460

• API functions: mappings can call external APIs, with stored secrets and token caching.

• Function tests, plus mocked function calls in system tests.

• AI Compare mode answers who changed what across versions, and why.

• Filters apply as you type and cancel outdated queries.

• Keyboard shortcuts across the whole app.

• Times can be shown in your local or the server's time zone.

• Web farm support for background jobs.

• Deploy requests identify the user making them.

• Tighter security headers.

1.8.1

UX/UI improvements: listings, landing pages, keyboard shortcuts

Added: 2026-10-08
Added by: Max van Ijsselmuiden
Ticket: https://sandfield.atlassian.net/browse/CD-460

• Module landing pages with live counts, e.g. "N failing" transports.

• Docked filter rail beside listings, and an "Updated x mins ago" indicator.

• Keyboard shortcuts: hold Ctrl to see them, press ? to list them.

• "Failing" transport filter and tag.

• Message content search is first in the message filters.

1.8.0

Quality-of-life & visibility improvements, cross environment / cross customer integration deployment, and Engine V3 dashboard telemetry

Added: 2026-08-11
Added by: Scott Ferguson
Ticket: https://sandfield.atlassian.net/browse/CD-460

• Deploy integrations across environments and customers, with a field-level diff preview.

• Bulk reprocess, delete and archive run in the background with a progress dialog.

• Engine V3 telemetry on the dashboard and a Telemetry tab on each mapping.

• History tab on objects shows who changed what, when, and the previous value.

• Listings remember your results, page and scroll position.

• Integration canvas: snap to grid, multi-select, and live processing timestamps.

• One-click enable and disable with undo.

1.7.1

Messaging, Scheduling & Security modules with legacy compatibility

Added: 2026-09-04
Added by: Max van Ijsselmuiden
Ticket: https://sandfield.atlassian.net/browse/CD-460

• Cleaner object pages, with status shown in the header.

• Redesigned snooze.

• Slimmer navigation.

• Calmer listings with real empty states

1.7.0

Messaging, Scheduling & Security modules with legacy compatibility

Added: 2026-08-04
Added by: Scott Ferguson
Ticket: https://sandfield.atlassian.net/browse/CD-460

• Messaging module: transports, servers, routes, messages, archives, certificates and notifications. Ported from the old EDI portal.

• Scheduling module: schedules, groups and steps with auto-generated descriptions. Ported from the old EDI portal.

• Security module: users, groups, a permission tree and MFA reset. Ported from the old EDI portal.

• Entities are created in one step across all three databases.

• Legacy data appears in Crossfire listings, and legacy pages open with single sign-on.

• Clone integrations between entities and partners, and publish drafts to live.

• Flow and Lifecycle tabs trace a message end to end.

• Bulk actions, in-browser attachment previews and zip download.

• Dashboard detects server downtime

1.6.0

Integrations planning workspace

Added: 2026-06-11
Added by: Scott Ferguson
Ticket: https://sandfield.atlassian.net/browse/CD-460

• Visual canvas for planning mappings, transports, routes and external systems per partner.

• New Code Lists, SQL Functions, bulk reprocessing and a system test listing.

• Full UI restyle.

1.5.0

AI-assisted Mapping and Message Standard authoring

Added: 2026-06-09
Added by: Scott Ferguson
Ticket: https://sandfield.atlassian.net/browse/CD-460

• AI generates mappings and message standards, asks clarifying questions and remembers decisions.

• AI learns from system test results.

• AI jobs show progress and can be cancelled.

1.4.0

Crossfire Mapping, Message Standard, Message, and System Test authoring pages

Added: 2026-04-30
Added by: Scott Ferguson
Ticket: https://sandfield.atlassian.net/browse/CD-460

• Mapping and Message Standard pages with versioning and an in-browser code editor.

• AI assistant panel and version compare for mapping logic.

• System tests: run, bulk run, baselines, expected vs actual diff and whitelist rules.

• Message pages: content, references and lifecycle, with reprocess and edit.

• Create a system test straight from a real message.

• Access is restricted by entity throughout.

1.3.0

Partner and Entity page baseline, reusable object/listing patterns, and formatting standards

Added: 2026-04-29
Added by: Scott Ferguson
Ticket: https://sandfield.atlassian.net/browse/CD-460

• Partner and Entity pages, ported from the old EDI portal.

• Faster server-side filtering, sorting and paging.

1.2.0

Code cleanup, frontend refactor, and Countries reference page

Added: 2026-04-23
Added by: Scott Ferguson
Ticket: https://sandfield.atlassian.net/browse/CD-460

• Module navigation (Crossfire, Messaging, Scheduling, Security) with a collapsible sidebar.

• Dark theme across the app.

1.1.0

Dashboard - graph for more than 1 hour

Added: 2026-04-16
Added by: Josh Shiu
Ticket: https://sandfield.atlassian.net/browse/CF-305

• Dashboard time window of 1, 2, 4, 8 or 24 hours.

1.0.0 - 1.0.5

Dashboard

Added: 2026-01-14 to 2026-04-16
Added by: Josh Shiu
Ticket: https://sandfield.atlassian.net/browse/CF-305

• Live dashboard showing server health, SQL disk space, message throughput, deliveries and schedules.

• Throughput and delivery figures match the old EDI portal.