Release Notes
Below you will find History of changes made to Data Synchronisation Studio and Ouvvi from 2023 (Version 6). For releases prior to version 6 please see our older release notes.
2023
6.0. 3260 - 09/06/2023
- FEATURE: Can now connect to Ouvvi Projects from Data Sync
- UPDATE: Back end now uses .NET Standard in preparation for .NET Core and uses the framework .NET V4.8
- UPDATE: Connector structure has been re-organised in preparation for .NET Core
- OUVVI: UI changes made, navigation at top and overlays to improve usability.
- OUVVI: Connections support OAuth and can be viewed, added and edited from the UI (rather than only being uploaded).
- OUVVI: Forms based authentication now available with Azure AD support
- OUVVI: IP Filtering now possible
- OUVVI: Optimization of back-end processes
6.0. 3274 - 20/07/2023
- UPDATE: Actipro Library to V23.1.1
- FEATURE: Add LOOKUP ARRAY function to Calculated Columns
- UPDATE: Ignore the Name attribute in Active Directory since you cannot write to it.
- FEATURE: Create Scheduled Task from Run Tool menu.
- UPDATE: Change the Installer to use InnoSetup
- FEATURE: New JSON API connector
- FEATURE: OUVVI Upgrade Ouvvi V4 to V6.
- CHANGE: OUVVI Update DB Schema and add constraints to Configuration and Registry Tables.
- FIX: OUVVI prevent infinite cache of Graph EMail credentials.
6.0. 3284 - 11/08/2023
- FEATURE: Add OpenFile action to JSON API connector.
- FEATURE: Add AuthorizationHeader authentication option to JSON API Connector.
- FIX: Authentication in LOOKUP from JSON API Connector
- UPDATE: Validate OAuth configuration before authorization and return appropriate error message.
- FEATURE: Enable Editing Connection Properties directly from Connection Library Tree View.
- FEATURE: Capture Exceptions from Data Sync and re-throw to enable more detailed exceptions from Connector on different thread.
- FIX: Loading referenced Assemblies from Connector Attributes to prevent exception from Dynamic/Project Automation.
6.0. 3286 - 17/08/2023
- FIX: Run Tool browse button to *.dsrun Run Project file.
- FIX: Active Directory escaping CN/DN when containing leading or trailing spaces.
- FIX: OUVVI fix to call SignalR notification when called via the Start Project API.
- FIX: OUVVI do not check DB schema on account login to prevent login loop when schema change required.
- FIX: OUVVI Catch Exception and write detailed Log in AgentWorker.Process
6.0. 3310 - 02/11/2023
- FIX: Suppress OAuth2 Browser Script errors.
- CHANGE: Change Licensing to require license key to run Compare.
- CHANGE: Change Activation back to simple License Key activation window.
- FEATURE: Add Incremental Lookup to Dynamics CRM FetchXml connector.
- FEATURE: SQL Server, SQL Client, ADO.NET convert ArrayTypes to Strings in writer to prevent DataType errors.
- FEATURE: SQL Server allow selection of OleDB driver to use.
- FEATURE: Create SQL Table Wizard to include SQL Script in Error Message.
- FEATURE: Enable Ignoring Calculated Column errors to prevent getting stuck.
- FEATURE: Throw exception in FileSystem provider if Directory is not found.
- FIX: Active Directory check range of FileTime Int64 is less than 9999/12/31
- FEATURE: Add UpdateSourceRow to SharePoint Online connector.
- FEATURE: Json API Connector Supports Writing via BuiltIn function and Callback writer.
- FEATURE: Json API Connector Supports data paging by next page index.
- OUVVI Release 6.0.3310
2024
6.0. 3332 - 25/01/2024
- FEATURE: Add process Identity to Log
- FIX: Create SharePoint Column when using Encryption Key
- CHANGE: Default property code snippit to default to string.
- FEATURE: Delete DSCache files on Startup.
- CHANGE: Update nuget package references to latest versions.
- FEATURE: Add SetParameterValue API to JSON API connector.
- FEATURE: Expand the {Datasource.Name} value in JSON API connector Json Writer.
- FEATURE: Add the ability to Filter Target Rows with a Datasource filter like you can the source.
- CHANGE: Optimize the FileStore to reduce GC memory pressure.
- FEATURE: Improve DataSync startup performance.
- FEATURE: Allow setting NULL property on Columns in NULL/Empty provider.
- FEATURE: Add ARM64 support for Windows 11 on Apple Silicon in Parallels.
- FIX: Open in RunTool from Start Page
- FIX: Active Directory Group Members when a group member list exceed 1500 users.
- FIX: JSON API connector DELETE operation.
- FIX: Unregister Event Handlers in Ouvvi Powershell and Cmd Handler.
- FIX: OUVVI prevent startup failure on Duplicate configuration setting.
- FEATURE: OUVVI add Project Status change Step Handler.
- FEATURE: OUVVI Capture Trigger exceptions in Log.
- OUVVI Release 6.0.3332
6.0. 3334 - 29/01/2024
- FEATURE: Method to add rows to DataTable store from Dictionary and Object
- FEATURE: Ouvvi handle input errors for TimeSpan Trigger types
- FIX: Ouvvi Trigger service failing if Time Triggers returned exception.
- OUVVI Release 6.0.3334
6.0. 3336 - 06/02/2024
- CHANGE: Revert Microsoft.SharePoint.Client back to older version since new version had an internal dependency on Microsoft.Data.SqlClient which we do not want to include at this time.
- OUVVI Release 6.0.3336
6.0. 3340 - 28/02/2024
- FIX: Task Scheduler dll missing from build causing errors creating scheduled tasks
- FIX: Create custom Data Sync connector template project.
- FEATURE: Add DataSchema Extensions from V8 for looping around schema columns.
- OUVVI Release 6.0.3340
6.0. 3368 - 23/05/2024
- FEATURE: Add PKCE support for OAuth connections enabled for Salesforce, Dynamics and SharePoint connections
- FEATURE: Sync up checkbox on Synchronise window with Project SucFailOnErrorStatus
- FEATURE: Prevent Calculated Columns being dropped when there is a compile error.
- FEATURE: Convert types to string before Testing in CompareTargetIsNullOrEmpty
- FEATURE: JSON API: Handle response when 204:NoContent
- FEATURE: JSON API: Add mode to JsonDefaultWriter to include Columns.KeyColumns in Update and Delete operations.
- FEATURE: JSON API: Add Modes for AllKeys and AllIdentifiers in Default Writer
- FEATURE: JSON API: Update Json Pager to support Index Paging
- FEATURE: JSON API: Add OAuth2 Password Grant
- BUG: JSON API: Fix when Lookups not saving in Project File.
- FEATURE: Open Xml: Improve Excel Data Type handling and auto convert some values to the actual type i.e. Dates/TimeSpan etc.
- FEATURE: Add new Connector FileTable to Read/Write Excel/Csv/Xml files directly from SharePoint document libraries.
- BUG: Fix for Target Filter when you have a dynamic column in the Schema Map.
- BUG: Fix when you close application after saving
- BUG: Fix saving window layout
- FEATURE: Move Schema Map properties to collapsible pane on right.
- FEATURE: New connector for SQL Azure using Entra ID authentication
- FEATURE: Salesforce: Add DateTime handling property to configuration to adjust to Local or UTC date times.
- BUG: Fix when Schema Map has a column name with the same name as a dependency column.
- FEATURE: Change evaluation mode to allow projects to run without license key, limited to 3000 rows and 20 columns.
- FEATURE: OUVVI: Add object usage report
- FEATURE: OUVVI: Add custom Project Start page with options
- FEATURE: OUVVI: Update SharePoint, Salesforce and Dynamics to use PKCE with OAuth connections.
- FEATURE: OUVVI: Update Deployment manager to check File Version rather than Product Version in assemblies.
- FEATURE: OUVVI: Add SQL Azure to connection library options
- BUG: OUVVI: Fix Ouvvi Apps Import/Export when column names contain spaces
- BUG: OUVVI: Agent Settings service cache was not expiring
- OUVVI Release 6.0.3368
6.0. 3378 - 10/10/2024
- FEATURE: OAuth2 Certificate support for SharePoint Online, Dynamics, SQL Azure, JSON API Tool.
- FEATURE: SharePoint Online can now use Application level permissions with OAuth2 and certificate based authentication.
- FEATURE: Ouvvi TimeTrigger now has a End Time to prevent trigger running outside of scheduled time window.
- FEATURE: JSON API Tool connector can how access a parent Json Element via Parent-Path property.
- FEATURE: Evaluation Mode can now test the Run Tool and Scheduled Tasks for 60 days.
- OUVVI Release 6.0.3378