Module News in August 2017 – See the Change Log here…
Repository Job Server: You can now switch between Repositories while having a Job Server Windows Service running simultaniously. You can even run jobs on the local Job Server linked to another repository concurrently.
License More streamlined procedure for installing license key and you no longer need to restart the program.
FileTransport SharePoint User Columns: New syntax for dynamically substituting a user name that does not exist on the target SharePoint environment with another. You can hardcode the user name like this:
or you can use it dynamically in expressions like this:
[Created] + ';[mydomain\newuser]'
Notice the the square brackets denotes a dynamic substitution.
FileTransport Job Log entries for files uploaded with version history now has detailed information on the version history applied for the file in context.
Excel New non-visual Table option that do not show any Table formatting and inherits the formatting in the sheet.
Excel Visual and Non-visual Tables can now be configured to suppress columns headings and Tables can be configured to show the special row Totals.
Excel When creating a Table the area the table will occupy is now cleared in advance. This makes it easier an less error prone to update existing workbooks where someone accidently have added data within the table area.
Excel 2 new advanced configuration settings: ExcelCache, ExcelVisible.
Excel Encapsulation of user defined Excel logic that prevents Excel from closing workbooks properly leading to memory leaks and unstable Excel session.
DataTransport For-Each-Row now show details in progressbar when running in interactive mode.
DataTransport Appeon InfoMaker 2017 : Added support for pointing directly to InfoMaker Report Library Files.
DataTransport New system Parameter “DataTransportCount” reflects the number of rows/Items that have been processed. This is particularly useful when you want to do some actions only when something exists or has been created like running PowerShell or applying a PnP Provisioning Template to a new SharePoint site just created using another DataTransport component.
DataTransport InfoMaker: Support for Appeon InfoMaker 2017
DataTransport InfoMaker: PDF generation. Ghostscript printer driver eliminated. Everything is now built in.
DataTransport InfoMaker: Library distribution. Windows user no longer needed to have write permissions for programfolder. InfoMaker Report PBL is now loaded from the temp folder.
DataTransport InfoMaker: New output types TXT, CSV, Excel.
DataTransport InfoMaker: Job Log information revised and output file is now embedded.
DataTransport InfoMaker: Support for External databases so now you can retrieve reports from any database and even use as input to any target in another component by using the new XLSX, TXT,CSV output types.
Database When you save a Database Connections then a local 32 bit ODBC Data Source is created with the same name and connection parameters as used by Fusion. This makes it much easier to create reports with tools like Appeon InfoMaker 2017
Database When you save a Database Connections then a local 32 bit ODBC Data Source is created with the same name and connection parameters as used by Fusion. This makes it much easier to create reports with tools like Appeon InfoMaker 2017
SharePoint Support for “copy version history” on MOSS 2007.
Parameters Documentation columns and filter options added. Makes it much easier to navigate when you have like 500-1000 parameters.
Components Properties window is no longer modal and you can have properties open for multiple components simultaneously. Also the layout has been optimized for easier documentation writing and viewing.
System Windows Server 2016 and Windows 10 certified runtime engine.
Module News in July 2017
CtrlSync Now CtrlSync has its own installation program (OntolicaCtrlSync.exe) and separate licensing structure.
DataTransport Built-in support for MS Access 2003-2016. No need anymore for creating external ODBC data source.
DataTransport UI extended to help define keys for CRUD actions where source result set is joined with target to select rows/Items to process.
DataTransport For-Each-Row Target: Excel session caching added (performance increase when generating for example 10000 individual Excel files.)
MDM When merging 2 Contacts a Logbook instance is now generated with detail information about deleted rows.
DataTransport Text file source no longer need header line. You can specify that the file has no header, then default column names are generated. Example. Field001, Field002, …
DataTransport Excel source can now reference a range of cells within a sheet or a named area. Example: “MyNamedBlock” or “My Sheet!C9:F200”
DataTransport Database target: When switching to SQL you are now prompted to generate default SQL script.
Module News in June 2017
DataTransport Enhanced to work with no source data set. Perform operation entirely using parameters and constants and can now be called directly from a For-Each-Row loop
SQL New “Refresh button” to update the internal database with table navnes and column names. Useful when you paste table name or column names while constructing SQL statements and tables have been modified since the database connection was created..
DataTransport InvalidData.txt report can now be opened directly from the second data preview without having to open the job log.
FileTransport SkippedFiles.txt & InvalidData.txt reports can now be opened directly from the second file preview without having to open the job log.
FileTransport Version History Copy now works significantly faster when many minor versions exist for the source file.
Database ODBC interface now handles drivers like FileMakerPro 15 that are not fully compatible with the ODBC metadata function calls.
Module News in May 2017
DataTransport SharePoint target: Value pairs related to LookUp columns are now added to the Job Log. This makes it much easier to track when a value does not resolve correctly.
SharePoint MOSS 2007 CAML does not support the IN clause. Fusion now encapsulates the IN query criteria and generates an OR construct instead.
SharePoint CAML filters can now use SQL Query result set (single column) as parameter for an IN criteria. This gives you extensive flexibility in selecting individual Files or Items to process in the FileTransport or DataTransport components based on databases or TXT/CSV files.
DataTransport SharePoint Delete Operations now show performance statistics.
SharePoint “Copy version history” Now has criteria for oldest date and number of versions.
SharePoint Extended Retry mechanism for handling unstable network connections.
SharePoint PnP provisioning Engine updated to v 2.15 (May release)
CtrlSync Documentation updated: Group based subscriptions
Install Automatic shutdown and restart of Job Server Services and CtrlSync multitasking processes when upgrade is initiated from within Ontolica Fusion (Check-For-Updates)
CtrlSync The Free-Edition has been extended to allow 3 CtrlSync Users or Subscriptions with no limits in functionality or volume.
Module News in April 2017
FileTransport Copy version history from one SP Library to another within same or different site, or to a different folder within the same Library. (minor versions are not copied)
DataTransport Update SharePoint List:The update-key values are added to reports and to job log entries making tracking and analysis easier.
Job Server New column in the job list showing e-mail notification settings for the job.
CtrlSync Full support for SharePoint on-premises 2010
CtrlSync Subscriptions can now be grouped. Each user can subscribe to multiple groups of subscriptions. Each Subscription can belong to multiple groups.
CtrlSync Video: Presentation with Demo
CtrlSync Video: Installing CtrlSync on SharePoint
CtrlSync Support for HTTPGet for “Offline Check” in CtrlSync job start.
CtrlSync Step-by-step Installation procedure now has video guide.
CtrlSync Local source folders are now automatically created. This enables for automatic rollout to users of indirect-2-way sync setups.
CtrlSync Subscription defined as “Sync Source to Target (1-way)” is now flagging target files on local drives and FileShares as ReadOnly.
Job Server SMTP.DK is now included as free E-Mail service within Ontolica Fusion.
Job Server Job Result can now be e-mailed using own SMTP server.
SharePoint Support for list type Survey.
Module News in Marts 2017
DataTransport Enhanced job logging for Excel automation.
DataTransport New ability to apply PnP Provisioning Template to sites created on the fly.
DataTransport Options for Subsites List have been simplified.
FileTransport New property enables you to flag files copied/synced to FileShares or Local drives as ReadOnly.
DataTransport Performance increase (110% ) when Updating SharePoint Items using custom keys.
General Expression evaluation performance increase (150%). This is a global enhancement for all dynamic expressions.
Excel Support for irregular table-column-names.
Excel Support for using # in Sheet name. The # character is replaced by a timestamp. This enables for accumulating multiple sheets of data in a single workbook each named uniquely..
Module News in February 2017
DataTransport Using “Files and Folders” as source now include the Created and Modified timestamps for Folders.
FileTransport Now you can reference child Managed Metadata tags by using this syntax: [My parent tag label][My child tag label]
FileTransport Extraction af Metadata from Office Files now supports Custom Properties. Also added a new global function GetOfficeFileProperty for use in expressions.
DataTransport Enhanced multitasking leading to greater speed (20 – 70%) when Updating / Creating items. (On O365 standard tennant we have measured Create 2000 items pr. minute based on batch of 24000)
Module News in January 2017
Excel Dynamic Sheet generation when updating existing workbook. Specifying # as suffix to the sheet name ( MySheet#) will lead to an new sheet being generated with # replaced by a timestamp.
PnP Support for the new March 2017 version 2.13 of the PnP Provisioning Engine.
DataTransport FileTransport New Recycle Bin option for all “DELETE” operations. You can then configure permanent delete or send to Recycle Bin. Implemented for Windows File System and SharePoint (including ordinary List Items.)
Job Server Enhanced and simplified Windows Service configuration.
General CtrlSync for SharePoint Server Mode for OneDrive replication and backup – single og multiple accounts.
FileTransport “Folder option: Synchronize. This enables you to perform both One-Way and Two -Way sync where files and folders not matching the source are deleted. Note that Two-way sync requires 2 components with identical but switched Source/Target. The 2 Components can use either the same or different options and filters etc.
DataTransport FileTransport New Support for Dynamic Component Invocation based on a Parameter. You can now insert a Parameter as the Component to invoke. At runtime the return value from the Parameter is resolved to a Component name and that component is then invoked.
Module What’s new in Version 4.43 – October 2016See the Change Log here…
SharePoint Parameter support in Connections is added (SharePoint, Database, FTP). You can just change the parameter value and then it is reflected in all referenced connections. Parameters can be global for all Fusion users or individual for each user. This is quite nice in environments with many connections that requires regular password change or requires access using different credentials for each Fusion user.
General The Windows System Tray now has a Fusion Icon from where you can access the program.
DataTransport Internal-data as Source is now available also when Master Data Management is disabled.
Job Log The job Log is now automatically truncated gradually on the Batch Server without blocking for other concurrent jobs.
Module What’s new in Version 4.42 September 2016See the Change Log here…
BatchServer Handling of : “Server machine reboot”. Component jobs that were running when the server machine was rebooted will now be automatically rescheduled or restarted according to the Components job schedule.
PowerShell Error handling: New error message added to job log that shows the native PowerShell exception message. Fatal errors where the script can not execute at all is handled with a specifc message
Components The Job log sessions are now automatically truncated to 100 sessions. You can configure the number of sessions to retain for for each component or globally for all Components.
SharePoint DLL Update: CSOM 16.1.5626.1200 & PnP.Core 2.7.1609.3 (September 2016)
Module What’s new in Version 4.40 August 2016See the Change Log here…
Components Video toolbar button that opens the “Video Library” .
General The “Video Library” is now an independent window. Option to “Stay as topmost window”. Individual or all videos that auto-play can be disabled.
ControlPanel Linked-In support and discussion forum now accessible from top-banner.
Module What’s new in Version 4.39 August 2016See the Change Log here…
FileTransport FTP support. You can now copy/move files between FTP sites, SharePoint Document Libraries and FileShares.
General Ontolica Fusion Free Edition. This is the standard installation. If you have a Licence no changes are made. If not then an extra set of features now have no limitations.
ControlPanel New Toolbar buttons for Repository Backup/Restore/Select. Updated layout for Components with new description column saved with each Component. Tooltip enhanced.
MasterData Activation can now be done by double clicking the pre-installed folder Master Data Management Components.
Collection Easier Enable/Disable of Scripting (PowerShell/ Database SQL). Options are moved to Script-Tab’s. Default enabled. New hyperlink and documentation added.
DataTransport CSV/TXT Driver and description updated. Sample syntax for SQL SELECT on .TXT and .CSV files added.
DataTransport Source specification: When Excel or Text file is selected as Source a file selection prompt is displayed.
DataTransport Target specification: When Text file or XML is selected a default filename is added. Automatic name sequence numbering is enabled: MyFile_1.txt MyFile_2.txt ….
FileTransport, DataTransport “Create new Connection” in the Connection Drop Down Menu. Gives easier access to creating a new Connection. Also if an Incomplete Connection is selected the the Properties are automatically opened.
FileTransport, DataTransport “Auto edit incomplete Connection”. When selecting an incomplete Connection, the Edit-Connection-Properties will automatically open.
Database, FTP, SharePoint New “Metadata Refreshed” DateTime column shows when the connection was refreshed. This new property is now widely used to indicate connections not yet complete.
Module What’s new in Version 4.33 August 2016See the Change Log here…
Collection Support for execution Conditions. This effectively gives you “Cross Platform Workflow” capabilities.
MasterData Facelift applied to standard layouts and various dialog boxes.
DataTransport Advanced DateTime filtering in query result. Quarters, Weeks, days, relative intervals etc.
DataTransport New Hyperlink to edit Database Connection Properties.
Module Version 4.32 July 2016See the Change Log here…
Functions GetDirectory ( window title , start path ). Select a directory. Returns directory path or ‘’ if cancelled.
DataTransport Query: Blank folder name is now interpreted as Root-folder.
FileTransport Folder dates now display in the “Action Preview”. Also added to all relevant reports.
FileTransport SP to SP Content Type: Automatic column mapping now maps the column Content Type to Content Type Id. Both Label and GUID values are matched combined or independently.
FileTransport Content Type Label is now automatically set when Content Type Library is selected.
FileTransport Content Type automatic fallback: When a Content Type (dynamically specified using rules and expressions) does not exist then fallback is made to the Content Type defined in the component or if none defined then ten one in the library.
SharePoint Managed Metadata: Tag Label is now matched independent of case and leading/trailing space to Term GUID.
SharePoint Managed Metadata: Job log for Tags is now more readable.
SharePoint Handling of very slow SharePoint servers where the famous “error 500” is thrown.
Job Log New r-click menu on “Copied” Job Log rows enables you to quickly open the source/target destinations for a particular file.
SharePoint O365, 2013, 2016 Office Dev. PnP Core Libraries updated to 2.5.1606.3
SharePoint 2013 – New GitHub package design for CSOM 16.1.5xxx
Module Version 4.28 (June2016)
Master Data Data Import: Enhanced key management with automatic relation detection.
FileTransport Folders: Modified & ModifiedBy is now populated with information. Works in all directions : SF to SP, SP to SP, SP to FS, FS to FS.
SharePoint Office 365 new throttling error types. Fusion now recovers automatically and applies different upload approach when necessary.
FileTransport Fast “Rename File” support. By using “Move” you can now move the file to a new name within the same or different folder. The value of Modified & ModifiedBy can optionally be retained. There is full support for all dynamic calculations etc. Note that you can rename using wildcards in the filename. So *.PDF will rename all files to have .PDF as extensions.
FileTransport Wild card specification enhanced Now supports files with no extensions. Example: ..\myfolder\*. This wildcard will retrieve any file without an extension
SharePoint New Connection Property: Local Filter for Blocked File Types
DataTransport SQL Database Target will now detect dynamic “CREATE TABLE” statements. and automatically load table name and metadata for use in the UI.
Collection The Collection Component it is now running with Multitasking.
SharePoint Content Type Management. Set the Content Type on new or existing Items.
SharePoint Support for SharePoint On-Premises 2016.
Excel Use Internal named Tables as source in DataTransport. Optionally refresh the Table linked to external data.
SharePoint Site Provisioning Create/Update/Delete Sites in BULK.
SharePoint Support for the Office Dev. PnP provisioning Engine.
FileTransport Dynamic Site support: Upload to SharePoint and automatically create Site, based on standard or WSP template.
PowerShell Run parametrized PowerShell from the Collection Component.
DataTransport For Each Row – Execute Component. You can reference Column values from any Component, row-by-row.
Module Type Version 4.09 (April 2016)
SharePoint New Site Provisioning Create/Update/Delete Sites in BULK.
FileTransport New Dynamic Site support: Upload to SharePoint and automatically create Site, based on standard or WSP template.
PowerShell New Run parametrized PowerShell from the Collection Component.
DataTransport New For Each Row – Execute Component. You can reference Column values from any Component, row-by-row.
Job Log New Report tab” to concatenate and analyse the embedded report files and export to CSV or Excel.
DataTransport Enhanced Excel target now supports named cells, and has been greatly simplified and face lifted.
Batch Server Enhanced Windows Service configuration can now set the account name.
Module Type Version 2.63 (November 2015)
Documentation New Topic covering Fusion concept and use-cases
FileTransport Enhancement Drag&Drop” support. By dropping files on the File Transport component a “File Selection” filer is automatically created.
DataTransport New CSV/TXT driver that enables retrieve filtering and conditional data append.
DataTransport New No-Coding” user interface for Database Create, Read, Update, Delete (CRUD). (This is an addition to the existing advanced SQL scripting.)
DataTransport New Support for 3 party drivers for Line of Business Systems . This enables 2-way integration with MS Dynamics CRM/AX/NAV, SAP NetWeaver, OData services, etc.
DataTransport New Preview of pending actions for database targets. (also raw SQL)
SharePoint Enhancement Support nested match on Managed MetaData. “:“ … “Cars:Ford”
Module Type Version 2.17 (June 2015)
SharePoint Enhanced Data & File Transport can now handle 1.000.000 items per session.
DataTransport New SQL Data type specification”. This enables easy data type conversion from source to target. For example when you want to insert a text value into a numeric column.
DataTransport Enhanced DropDown column list now includes the physical column name. makes it easier to understand when working on sites with different languages..
FileTransport Enhanced DropDown column lists now includes the physical column name. makes it easier to understand when working on sites with different languages..


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment