Module News in October 2017 – See the Change Log here and the RoadMap here
General Support for WorkPoint 365/On-Premises – SharePoint document sharing and collaboration platform.
(General architecture and on-prem datatypes)
General Faster start of Ontolica Fusion when having many SharePoint Connections.
FileTransport Dynamic URL’s : Support for varying columns og dynamically referenced sites. So the target sites does not need to have the same columns as the template site.
FileTransport Dynamic URL’s : UI for setting up dynamically referenced sites has been simplified.
FileTransport SharePoint Dynamic Source URL/UNC: Automatic append of wildcard if not specified.
FileTransport SharePoint Source: 30% better performance on retrieval of source file information.
DataTransport For-Each-Row loop processing is now significantly faster.
DataTransport For-Each-Row now have a new preview option to run the for-each without calling the referenced Component. This is useful when designing and testing individual parameterized sub components.
DataTransport Job Log Item-Create/Update format revised for easier reading.
DataTransport SQL target: x20 faster job logging of executed SQL Statements. This is significant when you execute >10.000 statements in one job.
DataTransport SharePoint Delete operations: Performance optimized fase 1 (before the delete actually happens) in some cases up to x20. This is significant when deleting >25000 items in one job.
DataTransport SharePoint Delete operations: The Title column is now included in action preview and reports.
Module News in September 2017
Mapping list Import data source: Create and configure an Import Component to import values (eg. user mappings, product names etc.) from SharePoint, Database or CSV file.
Mapping list Import clipboard: Paste values (eg. user mappings, product names etc.) to a Mapping list from the Windows Clipboard. Just select an area in Excel then Copy and Paste. This makes it easy to quickly setup mappings for users, product names etc.
Import UI facelift to make it more “like” DataTransport. The Import Component imports data into optimized table structures in the local Repository. It is powerful for data staging and Master Data Management. Also it is extremely useful for populating and updating local Mapping lists for user names, products etc. You can import from SharePoint Lists, Databases and CSV.
File & DataTransport SharePoint Target: New “User mapping list” option. Define that one user name should be replaced by another. When a user do not validate on the SharePoint Target and the user is not listed in the mapping list and no Alternate user is specified then the user name is automatically added to this list. When you run the job interactively or in test mode you are prompted to edit the mapping list.
File & DataTransport SharePoint Target: New “User not found” option. Define an alternate user name to use whenever a user name do not validate on the SharePoint Target. If specified with a mapping list also, then no entry is automatically added to the mapping list.
File & DataTransport SharePoint Target: New report “MappedUsers.txt”. Documents how Source user names have been mapped to other names on the Target.
File & DataTransport SharePoint Source: New “user name column format” option. Specify how user names are returned from SharePoint. Options are:
Name ID;#Name Login name Domain\Login name E-mail
This is particularly useful to choose the best format when validating the user name against your Target ActiveDirectory/SharePoint.
DataTransport New Mode option:“Make reports, skip user validation” this is useful when doing reporting and you do not want to validate if users actually exists on the SharePoint Target.
FileTransport Copy Version History: Added support for Minor Versions.
FileTransport New property to enable reporting without user validation. This is especially useful when making inventory reports on Document Library Version History.
DataTransport New property (SharePoint Target): Refresh Connection before target processing.
DataTransport For-Each-Row: New button to explicitly update and show the dynamically referenced Parameters. This was previously only done when saving the Component.
FileTransport New property: Refresh Connection before target processing. This is useful when users are adding new Managed Metadata Tags and you have batch jobs that utilizes the automatic Managed Metadata tagging functionality.
FileTransport “Test-mode”: New Option to configure the component to always run in test-mode. This is useful when you want to do reporting and use the Job Log report files as input. to other components.
FileTransport Performance increase 50% when copying SharePoint Version History.
FileTransport The report completed_files.txt now includes version history information.
File & DataTransport Test Mode: The completed_files.txt Job Log report now has version history information. Note that all reports in the Job Log can work as input to a DataTransport. This lets you you transfer the raw data or pre-aggregated data to any target (SQL, Access, Excel, SharePoint List, etc..) for analysis and reporting or for post processing.
DataTransport “0 Source Rows” : New Option to to handle that situation. Actions are: Continue, Signal a Warning, Signal an error
Job Log New scrolling and filter buttons.
Parameters New Parameter [<JobLogReportPath>] That points to the temp folder specific for a job where all Job Log Reports are temporarily stored. This is useful when you want to do some processing based on the results from the last session.
Module News in August 2017
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 Dynamic Source & Target redirection URL/UNC fields are now resizable.
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:
mydomain\olduser;[mydomain\newuser]
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: New “Call Tree View” tab page that shows the called components and all of its subcomponents. Great for exploring how components are referenced.
DataTransport Site existence check optimized. User defined logic for component action after Site creation revised and fine tuned to facilitate pre-scripting in PowerShell (Property bags etc.) before applying PnP Provisioning Template.
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..

Feedback

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