Search

*Next version.
Please note that Ontolica Fusion Roadmap features and dates for future versions are subject to change without notice.
Module
Type
Features committed for version 6.13 – January 2018
DataTransport
New
…

Fusion CtrlSync Desktop
We continuously work to add new and exciting features, this is the latest release.
Version
Product
Generally Available (GA)
6.1
Fusion CtrlSync
January 2018
DOWNLOAD – Fusion CtrlSync
QUICK…

Frequently asked question
Question!
Are there any limitations to my license?
Are there any maintenance fees?
Can I purchase without a Credit Card?
Can I upgrade or change my subscription?
Do you offer a monthly subscription?
Do you offer a consultant…

On some systems Fusion can crash with a Windows “BEX” error
This problem is registered on Windows Server 2008
The solution can be to run Fusion in compatibility mode with Windows 7
Procedure:
In the Fusion program folder: (C:\Program Files…

Run PowerShell from Fusion Collection Component
The PowerShell Script execution is handled from the Collection Component.
From here script can run BEFORE and AFTER the referenced Components (if any), are executed.
Special PowerShell commands are available to…

Do more with SharePoint than ever before.
Perform your tasks Interactively or Scheduled.
No coding Required, and it is FAST!
Introduction to your new Automation Tool for SharePoint…
CtrlSync for SharePoint
25 Fusion…

Fusion is for people to get data & files in, out and around in SharePoint.
Automated or visually step by step, without PowerShell or asking for any developer assistance.
It may be difficult to attribute if you have never seen it
– Fusion is a product virtually in…

Integrating with Microsoft OneDrive
OneDrive is just a SharePoint Site with one Document Library. So CtrlSync for SharePoint is automatically compatible and individual users OneDrive can easily be added as Subscription.
You can extend…

Review
Ontolica Fusion Partner, Value-added Reseller
3rd party support by Ontolica Fusion
SAVE TIME!
“Using Fusion for migration and content transformation in WorkPoint is second to none. I have had 2 specific projects where Fusion saved me countless…

Review
Ontolica Fusion Partner, Value-added Reseller
3rd party support by Ontolica Fusion
MIGRATE FAST!
“ I have used Fusion on several projects and it simply makes my WorkPoint migration jobs so easy, even with complex file distribution logic.…

Ontolica Fusion
Yes, we offer fixed-term subscriptions for 1, 3, 12, 24 or 36 months.
Ontolica Search & Preview
Sorry – not at this time
Ontolica Support & Service
We offer a full range of Support & Service Assurances, but only as a yearly subscription at this…

Edition
End Points
Free Edition
3
Standard Edition
25
You can then purchase additional endpoint license packs of 100 or 500 .
To deploy CtrlSync you create an installation package from the machine where the licensed…

Ontolica Fusion is preconfigured with an Installation Package named CtrlSync for SharePoint
The first time Ontolica Fusion starts then the user is prompted to select the configuration of choice.
The default configuration is CtrlSync for SharePoint.
Next the user is…

What’s in it for me?
Ontolica Fusion enables you to complete complex Projects & Tasks without?
BE EMPOWERED!
You will perform tasks you never thought possible without a single line of code
HOT FEATURES
Distribute/Migrate documents to multiple Document…

Ontolica Fusion have been upgraded.
Description for: CtrlSync for SharePoint
You can continue to use your existing Repository or choose to install an additional.
Having multiple Repositories enables you to separate different projects from each other.
Using the…

You are up and run with the FREE TRAIL in minutes
Fusion – FREE TRIAL
No cost and No commitments
You are up and run in minutes: Install & Upgrade Quick Guide
See Ontolica Fusion in action
Video Quick Guide – How to accelerate tasks & projects in…

..Professional management of SharePoint data and files is unthinkable without PowerShell. And for good reason, all the necessary access to the lower level functionality hidden by the UI is there!
PowerShell is great in many ways but the larger and more complex scripts…

What’s in it for me?
MIGHT BE USEFUL IN SOME CASES!
If you need to do complex tasks like version-history copy or database interfacing Ontolica Fusion could be right for you.
System Developer:
Using Fusion for migration and content transformation in…

Ontolica Fusion imports Lotus Notes Documents including embedded files and attachments into SharePoint.
Many vendors provide so-called “Easy Notes migration tools”.
But at the end of the day the result can seem nice but in a real-world SharePoint…

Dynamic data collection across thousands of Sites/Lists
Business Intelligence is based on a data set. Ontolica Fusion can collect and consolidate the data set in an automated way without any coding!
In a traditional BI setup building the data set is a matter of…

Ontolica Fusion Desktop
A subscription renewal license, where the feature scope depends on the edition type acquired
Limitations: Edition type only
A renewable license (usually annual) including maintenance during the coverage period.
The license is automatically…

Extensively compliments of Sharegate
General: No-code solutions
Sharegate is for manually copy (migrate) of FileShares and SharePoint Site structure and content. The working approach is with a high degree of visual “Drag&Drop”.
Exclusive for…

SAVE TIME – GET DATA & FILES MOVING!
With Ontolica Fusion you can significantly reduce the economic investment as well as risk and complexity of PowerShell development for SharePoint.
Less or no Programming. Faster results for all your SharePoint…

Ontolica Fusion Desktop
A subscription license, where the pricing is based on the perceived value of the solution and how it will be used
This consumptive license has a basic fixed annual subscription fee.
The utility-pricing can be based on a budget and result…

What’s in it for me?
YOUR NO-CODE DREAM TOOL!
If your responsibility includes getting data & files in, out and around in SharePoint, manually or as automated jobs then Ontolica Fusion is right for you.
WOW!
I suggested a little improvement in functionality…

Easy Automation for SharePoint
Predictable, Safe and Fast!
Boost your deliveries and work quality.
Do more with SharePoint than you ever thought possible – safely and at high speed
Migrate/Replicate File Shares at high speed – - – …

Ontolica Fusion Desktop
A non-expiring software license to use with or without Software Maintenance, Support & Service, where the scope, flexibility, and pricing are based on the edition type with the needed features.
Optional: Software Maintenance, Support &…

Ontolica Fusion can not migrate a BLOG site directly from one Site to another in one go.
However you can migrate most of the content step by step .
Follow these steps:
Copy the files in the Document Libraries.
Make a note of the relative URL’s for…

How can I do more with SharePoint without running PowerShell scripts?
…To automate tasks like copying files and pushing data around, PowerShell is the natural tool used by consultants and technical support staf.
However PowerShell scripts are…

Central Management of files pushed to Desktops or Server File Shares
- AUTOMATIC AND WITH NO USER INTERACTION. Secure and Simple concept
Manage all users file subscriptions and monitor their activity from one standard Team Site
“Manage…

The Fusion Batch Server can run components as scheduled batch jobs.
It is installed automatically and uses the same configuration settings as the client.
It runs independently on the same or another machine as the Fusion control panel.
The server can run as a…

Recommendations for updating List items with data from any data source
General background: SharePoint Architecture for List Item Update
To programmatically update Items in SharePoint Lists and Libraries the only way SharePoint allows that is by specifying the unique…

Business and organization worldwide become more productive with Ontolica
THE BEST FROM ONTOLICA
by Surfray
New and relevant Ontolica success stories from all over the world will continue to be published
Select the business or organization who have solved there…

Whats in it for me?
GET SHAREPOINT & POWERSHELL DEVELOPMENT DONE IN RECORD TIME
System Developer:
Using Fusion for migration and content transformation in WorkPoint is second to none
BREAK FREE OF THE POWERSHELL SWAMP
Use solid No-Code framework with…

What’s in it for me?
BE EMPOWERED AND GET THE JOB DONE!
Perform tasks you never thought possible without a single line of code. Cut debugging, gain speed and get the solution in production fast!
MIGRATE FAST
I have used Fusion on several projects and it…

Data Driven Automation – No Coding required.
Some features are not available in Ontolica Fusion Free Edition.
FileShares and SharePoint Document Libraries (Interactive, Scheduled or Test-Run)
FileShare migration/replication to SharePoint at…

Whats in it for me?
COMPLETE THE TASK BEFORE DEADLINE
Replace “hard-core” development with No-Code solutions
Get the job done fast and gain independence from scripting experts.
COOL KICK OFF
We are kicking off this relationship with a solid…

Fusion is a 100% client side program that installs on a Windows computer.
Local administrative rights are needed to perform the installation.
The Fusion repository, is by default installed on a local FireBird database, placed in the Windows folder…

Fusion Desktop
We continuously work to add new and exciting features, this is the latest release.
Version
Product
Generally Available (GA)
6.1
Fusion Desktop
January 2018
You are up and run in minutes: Install & Upgrade…

Sites in SharePoint is handled by Fusion as Items in a virtual List.
The special internal Fusion List Subsites, has one Item for each Site in the Site Collection.
With the Data Transport Component you can Create/Update/Delete Items in any SharePoint List.
When you…

SharePoint – “List View Threshold” parameter.
Fusion respects that parameter while at the same time enabling querying Lists & Libraries holding any number of items without regards to indexing.
In effect, this parameter has no impact on Fusion…

Review
AMAZING TOOL
“With Fusion and CtrlSync, Surfray has created some amazing tools to sync files and data across different platforms. When it comes to sheer speed, there is no match in the market. Fusion and CtrlSync is by far, the fastest. Whenever I…

Create/Update/Delete SharePoint Sites in BULK (via virtual Subsites List)
Sites in SharePoint is handled by Fusion as Items in a List. The special internal List Subsites, has one Item for each Site in the associated Site collection.
So when you add an…

New Things Makes Us Feel So Good
Changelog
Next version
Module
Version 6.34 GA – March 2018
DataTransport
Database Target: Create-Table-From-Source-Columns support for creating and altering tables in MS Access…

SUBMIT YOUR TICKET HERE
WORLDWIDE * ASSISTANCE
Ask us your question or tell us about your issue and we will be most happy to assist you
LANGUAGE:
English
Danish
Spanish
*Want to know more about the ONTOLICA Support & Service Program

Unfortunately, we do not offer service consultant licenses.
Please see more here:
Consultancy Service
Voucher Card”:http://docs.surfray.com/ontolica-support-service/1/en/topic/vouchercard
*Any questions or issues – please use our Support & Service…

Fusion supports the Office Dev Team’s
“PnP Provisioning Engine” without coding.
To get an overview – read: Introducing the PnP Provisioning Engine.
*Microsoft: Why the new approach?
This begs the question, Why the need for a new approach? And…

This List is managed and maintained virtually by Fusion and it does npt exists within SharePoint.
When you retrieve the List, Fusion is generating the Site Hierarchy relative to the Connection URL. Each Item in the List is equal to one site in the Site…

Fusion imports Lotus Notes Documents including embedded files and attachments into SharePoint.
Many vendors provide so called “Easy Notes migration tools”.
But at the end of the day the result can seem nice but in a real world SharePoint production…

I’m getting the error:
! Document properties can not be extracted. Please install: Office-2010 32bit or Office 2010 64bit + hotfix:Office2010-kb2483230 or Office-2013 32/64bit
This happens when Microsoft Office is not installed on the machine where Fusion is…

Fusion automatically handles NULL values returned from a database.
If you want to do custom logic based on NULL values here is an example.
if([data] = ‘null’, ‘My custom data’, [data])
The above statement will return My custom data if the…

This problem is solved by CtrlSync:
1. How to automatically download files to users’ laptops from multiple different Sites in SharePoint. (Blueprints, Product Specifications and Price Sheets, Documentation, Recipes etc.)
2. How to automatically…

A computer license key has to be acquired for each local workstation or central server.
Fusion Desktop License Key is “hardware-locked” to a Computer
A computer is considered any workstation, server or other devices where the software license is…

Automation Components can be dynamically invoked fro PowerShell.
You have the option to use PowerShell to create advanced logic and let Fusion handle the bulk work of fast file an data replication.
From PowerShell you can invoke saved components.
Parameters like…

Any component can run as a batch job on the Fusion Batch Server.
A component can only be schedule once. However it may be referenced in multiple Collection components that are scheduled as jobs individually.
When a batch job is running it can be monitored using the…

A great way to get influence and discount
Customer involvement in Ontolica Development makes great results
If you are OK with being involved and part of the development project and can take responsibility for normal end-test, then the Joint Venture Development is…

To run an external program use the RunProgram() function.
The external program will run and any return value is returned to Fusion.
*Any windows program can be called.
This is useful in many scenarios including:
Custom logic in FileTransport components for…

Standard SharePoint behavior for Approving a document.
When a document is “Approved”, SharePoint is setting the value of the columns:
[Modified] = CurrentDateTime
[Modified By] = The account that does the Approval
When Versioning is enabled then the…

To start the sever, navigate to the “Batch job monitor” in the Fusion control panel, and click on “Start Batch Server..”
Once the server is up and running you are ready to schedule and run jobs in batch.
To configure the server as a Windows…

Fusion Desktop
Related:
Whats new
Changelog
Release Cycle
The Release Candidate (RC) is a “Pre-Release” version with potential to be the final software release unless bugs or similar emerge.
In this stage of product stabilization, all product features have…

Lots of good reasons to
1) Not all service-packs and upgrades are for the good
As we all know – Microsoft (and other big brands) – keeps making a lot of updates and fixes to their software and sometimes this affects other software there are…

All New Enhancements and Fixed Issues
Roadmap
Whats new
Next version
Module
Type
Version 6.34 – March 2018
DataTransport
Fixed
SharePoint Source&Target: Updating items or deleting before create – the job would do…

What is Control Sync..?
State your username & password to the Site from where you want to manage what files go where. (Know as the shared Subscription Site)
When connected to SharePoint, Fusion will minimize to the Windows System tray. (Lower right corner of…

Conditionally take action on List & Document Items
You configure Fusion components and visually test/verify the actions step-by-step.
The components are stored in the repository and can also be called from batch jobs or PowerShell
Data Movement in…

You get 2-way access to more than 40 Data Source Drivers.
*Simple connection set-up and streamlined command execution.
No complex API calls and no programming.
Further more, connectors give you automatic error recovery, retry and audit/reporting.
A Data Source…

Fusion can dynamically do just about any type of calculation on Date,Time and DateTime data types.
This example will add one minute to the DateTime value assigned to the [Modified] column in a SharePoint Library
The syntax:
DateTime( Date( DateTime([data]) ),…

The file dialog.ini defines the different program settings.
In the [Profile] section the following configuration parameters are valid.
Parameter
Description
Temp
Point to a different TEMP folder. The default is…

Fusion is a SharePoint automation tool in its very own category.
FK/SJ – husk omstrukturering
SharePoint Migration is supported in many areas and there is a vast amount of additional functionality ranging from conditional content replication and List/Library…

ONTOLICA SUPPORT & SERVICE
How can I run without an Ontolica Software Assurance (SA)
MANDATORY
According to the end user license agreement (EULA) on nearly all our software, it is mandatory to have an active Key License and Software Assurance (SA) when…

Here are a few nice tips for working with the Microsoft Text ODBC Driver encapsulated in Fusion
Working with dates:
When comparing dates it is useful to hint the driver about the format. Consider the below sample fragment of a WHERE clause:
WHERE ('2017-02-08'…

Delete items from document library based on criteria just like WHERE clause in SQL statement but without programming.
Key features
Test-run allows jobs to run and log all actions, without committing them
Jobs can run Interactively…

By combining File Transport with Data Transport components you can migrate or synchronize Enterprise Content Management Systems (ECM) with SharePoint.
With the Data Transport component you can apply the metadata after files are uploaded.
You can do it in multiple…

Fusion supports reading and updating Lookup columns.
Updating Lookup columns
The Item Label value can be assigned to the column directly. I will trigger a lookup in the linked List to retrieve the physical ID that in turn is applied to the column.
A report is stored…

Do things you never thought possible with No-coding Solutions
Scripting Language
PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language.
The working approach is…

Documents and metadata can be replicated between locations.
The selection criteria dynamically limits the files that gets replicated
Metadata can, in-stream, be transformed or converted into Managed Metadata.
And even enriched from external data source.)
…

Before a value is updated on SharePoint, it is validated.
The validation is also performed when “Test-Run” is executed.
InvalidData.txt Report is embedded in the Job Log
Fusion supports the following SharePoint column types:
Type
Validation…

ONTOLICA SUPPORT & SERVICE
Customer driven development
We believe the best software solve real problems and needs, so the most important development is customer and user requirement
Development and Priorities
When building an expanding our software systems,…

Collect and stage data in the built-in XRM database.
The included Master Data Management allows you to merge and manage many different Data Sets from SharePoint, Databases, Excel, CSV etc.
You can analyze, aggregate and create dynamically selected sub sets of…

Read CSV file and update SharePoint, Database, LOB systems or the Internal XRM data store.
Write CSV file with data sets retrieved from more than 40 data sources.
SELECT data set with powerful criteria from CSV file. Then use it to CREATE or UPDATE Items in…

.
Source (your FileShare) and target (your SharePoint Library) is specified in the File Transport component. You give the component a name and run it visually step-by-step or schedule it as a batch job on the built-in batch server. With Bidirectional support you can…

ONTOLICA SUPPORT & SERVICE
General handling & service Fee’s
In some countries, the payment process can be simple and easy – in other countries the need for more steps and more resources are necessary, and the same can be applied to some companies and…

The access to our Support and Service program
GUARANTEE – for access to software usage rights, upgrade, support and services
The Software Assurance (SA) provides running and working software:
FREE – Usage rights in accordance with the end user license…