Search

Automatically renewal to you cancel the subscription
All subscriptions purchased online, will automatically renew until you cancel the subscription.
Subscription purchased with manually finance PO process, will receive an invoice/payment alert by e-mail
If you…

Follow the instruction in the purchase confirmation (manage subscription)
or
Follow the instruction in the purchase invoice (cancellation)
or
Submit a cancellation Ticket to our Support & Service Center
Important: Remeber to check the cancelation policy for your…

SharePoint TIPS & TRICKS
Here is a very handy one line PowerShell command if you want to get the Farm Id:
(Get-SPFarm).Id
Paste this into the SharePoint Management Shell and it should display the Farm Id for your SharePoint Server farm.
*Any questions or issues…

You should always be able to find your Software Assurance ID:
On the last Software Assurance (SA) Invoice
Or on the last Software Subscription Invoice
We will normally be able to find your Software Assurance ID in our systems via our Support & Service…

If not renewed, normally all software, maintenance, support, and service are suspended and soon after terminated
More:
How to renew my subscription
How to cancel my subscription
How to run without a Software Assurance
*Any questions or issues – please use…

Unfortunately, this can’t be done. You will have to use your subscription for the purchase period, and then select another subscription plan when ready
*Any questions or issues – please use our Support & Service Center

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…

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…

Submit a service ticket with your issue in our Support and Service Center
Just follow the instruction and fill out with complete information, and our team will get back to you as soon as possible.
Fast lane tickets:
For our team can make an effective support &…

Submit a service ticket with your issue in our Support and Service Center
Just follow the instruction and fill out with complete information, and our team will get back to you as soon as possible.
Service Price Sheet
Use our Support & Service Center
NOTE:
If…

Submit a service ticket with your issue in our Support and Service Center
Just follow the instruction and fill out with complete information, and our team will get back to you as soon as possible.
Service Price Sheet
Use our Support & Service Center
NOTE:
If…

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…

Subscriptions define sets of files from different Sites and Folders.
Each List Item in the Subscription List represents one file set definition. ([Source] to [Target]) It is associated with one user. Each user can have multiple subscriptions.
Subscription List Item…

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…

WORLDWIDE SUPPORT & SERVICE CENTER
Submit a ticket with your issue in our Support and Service Center
Just follow the instruction and fill out with complete information, and our team will get back to you as soon as possible.
Read more of ticket…

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…

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…

Alternative quick and easy XXL file transfer service.
When files are too big for the normal e-mail tickets
No need for FTP etc
It is so very easy, just ..
Request an e-mail address of your issue contact
Go to https://www.wetransfer.com/
Use the e-mail…

*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
…

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…

Connect to the SharePoint admin center
Select User Profile, then Manage User Profiles
Find a profile
Manage Site Collection Owners (drop down list)
Change the primary or secondary site collection administrator
Repeat for every single user

Review
SOLVED MY ISSUE
“I wanted to just throw a kudos out to you and your team for making the service configuration work really nicely with alternate accounts. Solved my original issues altogether. Well done.”
Zach Eisenhauer –…

How to get an issue escalated to management
Please consider and understand that our support and service team will assist you as much as possible, of course with respect to our guidelines, the terms, and conditions on an issue.
The best way to solve an issue will…

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…

In this recorded session (30 minutes) you will learn how to connect SharePoint with enterprise content and data to enable Business Critical SharePoint. This will empower SharePoint users and project teams with all critical business information from across the…

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…

Keep a File Share updated with selected or all documents from a SharePoint Document Library.
or
Export Documents & metadata from SharePoint to other storrage.
Source (your SharePoint Library) and target (your FileShare) is specified in the File Transport…

Something doesn’t work with the Install
After download of the software program and starting to Install (programname.exe)
it doesn’t seem to work?
Issues
Can’t install
Install hangs during setup
Causes
Maybe the download failed
Maybe…

Create Items in SharePoint List using data from CSV and MS Access
No-Code Solution
Related:
Use Cases
Data Movement – in & out of SharePoint
CSV Importer/Exporter with powerful filters
*Start your FREE TRIAL – You will be up and run in minutes
*Any…

.
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…

A file can be uploaded to the SharePoint Document Library and left in “Checked Out” state
This enables for manual moderation and verification of individual files.
By assigning the value SkipCheckIn! to the column [Check-in Comment] then file will not be…

How to replace the content of the target file with the content from a different file.
This technique can for be used for uploading a file to SharePoint and making the actual file a dummy, by dynamically replacing the content uploaded.
(Anonymize file content or…

Calculate target “Site URL” dynamically for each File or Folder.
Use cases: (They all use the Run Component for each row feature in Data Transport)
FileShare upload to SharePoint Site where each top level folder represents a Customer…

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.)
…

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…

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…

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 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…

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…

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…

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…

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…

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…

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…

Configure CtrlSync for SharePoint
Step
Action (see screenshot below)
1.
Identify the SharePoint Site you want to use as your Subscription Management Site. Edit the connection properties to point to that site. You can use any site including a…

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.…

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…

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…

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…

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…

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…

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…

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…

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 &…

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…

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…

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…

Excel can not be activated from a Service or the Task Scheduler
This applies to any program type including c#, VB, PowerShell etc. that uses OLE Automation.
There are many different solutions/configurations.
Please be EXTREMELY careful when modifying the windows…

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…

When an error occurs it is registered on the Subscription Management Site.
Each Subscription Item in the “Subscription” List is processed separately.
Any general error related to a Subscription Item, like bad URL or missing access permissions, is…

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…

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…

Connections stores properties like Server name, User/Password etc. necessary to connect to a given database.
Connectors to ERP/CRM and Databases
*A connection can be referenced from multiple Components and user/password can include parameters.
In SQL statements the…

Parameters are basically variables that holds data values and returns them when referenced from Components or calculations
However the concept of variables is extended with an optional expression/rule set that evaluates each time the parameter is referenced.
The…

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…

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…

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…

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…

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…

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…

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?
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…

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…

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…

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…

..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…

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…

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…

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…

We will always do our best to deliver on-time and when possible – before time
Most of our finance, administration, renewal, and software license key activities are outsourcing to a 3rd party and the cost etc. for the processing will be added to the PO invoices…

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…

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…

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…

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 – - – …

Create Subscriptions for users
CtrlSync is basically managed form one single SharePoint List called Subscription.
Each Item defines one set of files to sync and is associated with one specific user or a number of groups. Each user can reference multiple…

Each Item in the List “Subscription” represent one set of files for one user.
The user’s own account is used for file download/upload
When the client program on the user’s machine (or Server) initiate file sync, the List Items in the Subscription List…

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…

Create Management Lists
List
Role
Subscription
Define the different sets of files that users are subscribing to. Each List Item represent one set of files. Users can have multiple subscriptions to Document Libraries or Folders from…

Function reference
Add a message to the Job log for the current Collection.
LogMessage( ‘message’ )
Argument
Description
message
The message to add to the Job Log. You can optionally prefix the message with subject (max 20…

Your access to our software Maintenance starts with minimum an active Software Assurance (SA)
The Software Assurance (SA) provides software updates and free level 1 support with access to the service program
Are Included in Subscription software license
Are…

Parameters can be used in the file specification to point to system
folders like the Desktop and Documents folder, or to a user defined location.
A parameter can also be used in the SharePoint Folder specification…

Remote support & service
The assurance offers end-users organization access to remote support & service on end-users installation via end-users remote access systems.
Are for companies and organizations using our software, where the solution is of a great value and…

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…

Function reference
Add a warning message to the Job log for the current Collection.
LogWarning( ‘message’ )
Argument
Description
message
The warning message to add to the Job Log. You can optionally prefix the message with …

Online support & service
The assurance offers end-users organization with access to online support & service via end-users online meeting system, skype, business skype or similar.
Are for companies and organizations using our software, where the solution is of a…

Access to service level 2
The assurance offers end-users organization 1st & 2nd level service with our team of consultancy.
Are for companies and organizations using our software, where the solution is of a great value and where it is a requirement to have access to…

Service Assurance L3 (SAL3)
The assurance offers end-users organization 1st, 2nd & 3rd level service with our team of supporter, consultancy, engineers, and developers.
Are for companies and organizations using our software, where the solution is of a great value and…

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…

Function reference
Signal an error and add an error message to the Job log for the current Collection.
LogError( ‘message’ )
Argument
Description
message
The error message to add to the Job log. You can optionally prefix the…

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…

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]) ),…

Please state your username & password.
When logged in files will automatically start to replicate.
From the Dashboard you can monitoring the activity i.e. files being Downloaded/Uploaded.
To open the Dashboard click on the program icon in the System Tray. (Lower…

WORLDWIDE SUPPORT & SERVICE CENTER
Response time are depending on what support or service agreement your company or organization has a subscription to
Software Assurance
Only 1-level support
Normal and known issues
First in, First out
Support…

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…

CtrlSync for SharePoint
Files and Folders will now start to replicate between your computer and SharePoint.
From the Dashboard you can monitoring the activity i.e. files being Downloaded/Uploaded.
To open the Dashboard click on the program icon in the System Tray.…

Function reference
Make the information needed to create a target site if it does not already exist.
This is used by the FileTransport component when called from DataTransport/For-Each-Row.*
SharePointSiteTempalte(TemplateID, SiteTitle, SiteDescription)
…

Rename existing files or as they are copied/moved to SharePoint, FTP, Network share or local drive.
Preview the proposed renaming actions before they are committed.
Test-Run supported, with full reporting.
Persist the Modified & ModifiedBy values when source and…

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…

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…

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…

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'…

Function reference
Skip the rest of the procession for the current Collection.
Skip( ‘message’ )
Argument
Description
message
The message to add to the Job log
Example 1
This example will signal that the Collection should…

Function reference
Finish the current Collection Component with no further execution.
Finish( ‘message’ )
Argument
Description
message
The message to add to the Job log
Example 1
This example will signal that the…

Function reference
Opens a list window and outputs argument text to it.
This is a useful function when debugging components and parameter return values.
Output( ‘text’ )
Argument
Description
Text
The text to output to the list…

Software, upgrades, license key, support & service
It all begins with a Software Assurance (SA)
Provides access to Software usage rights, new versions, upgrades, support & services
Extended Software Maintenance, Support & Service
All Subscription Licenses are…

Software source code copy in 3rd party depot
The assurance offers the end-users organization a secure way to protect and ensure against situations where the vendor can’t maintain the delivered software solution.
Are for companies and organizations using our…

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…

Dynamically calculated value, a source file field reference, or a constant can be assigned to a SharePoint column.
A constant can be typed in or a field related to the source file can be selected in the DropDown next to the SP column.
The special fields [Folder01],…

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…

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…

When an Item or Document metadata is updated, SharePoint automatically updates the columns [Modified] & [Modified By]
The Data Transport component can update Items and Document metadata while preserving the current values in the columns [Modified] & [Modified By] by…

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…

Function reference
Evaluates a condition and returns a value based on that condition.
If ( boolean, truevalue, falsevalue )
Argument
Description
boolean
A boolean expression that evaluates to true or false
truevalue
A…

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…

Function reference
Replaces a portion of one string with another.
Replace ( string1, start, n, string2 )
Argument
Description
string1
The string in which you want to replace characters with string2.
start
A long whose value…

We would very much like to hear more …
User driven development
We believe the best software solve real problems and needs, so the most important development is customer and user requirement
Please use our Support & Service Center and submit a ticket with…

Function reference
Return the value of a Standard or Custom property from an Office File.
If the property does not exist or the value is empty then the default value is returned.
GetOfficeFileProperty( ‘Filename’‘ , ‘Property’ ,…

User-driven development
We believe the best software solve real problems and needs
Our most important development is customer and user requirement
User-driven innovation is about “exploiting special knowledge about the customers to add extra value to…

Worldwide Support & Service Center:
We have centralized our systems to make sure you are getting a effective support & service
To make sure your issue are not overlooked or forgotten, submit a ticket with your questions and issue in our centralized Support &…

Allows for a job to run and log all actions to be taken without actually committing them.
This gives insight into:
Performance prognosis. (Estimated time to complete the job).
Dynamic calculation results.
Report that shows what impact the job will have on…

We support manual Renewal Purchase Order Process (PO/POP) on most of our software, assurance, subscription and service products.
Most of our finance, administration, renewal, and software license key activities are outsourcing to 3rd party suppliers, and the cost etc.…

The support tickets have to be an effective and constructive way to solve the issues together.
Not considered as support:
Issue of a character there can’t be solved within the ticket in the Support & Support Center
Issue of the type, we can’t solve within a…

You can extract Custom Properties from Office Files.
In the assignment use the following syntax: [Property:MyProperty] my default]
If the property does not exist then the default value is returned.
Leading and trailing space is removed from the default value
Se…

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…

Transport data between Source and Target.
Connectors to ERP/CRM and Databases.
“Source” defines the data set used as input for the selected action on the “Target”.
SharePoint List or Library Items.
Database result…

HOW TO GET STARTED
Submit a Service ticket with your issue and needs:
Consulting assistance
Engineer assistance
Development assistance
Solution Service Check
etc.
After joint acceptance of quote (period & price), we will send you a confirmation with…

CHOOSE HOW YOU WANT TO START – the Purchase Order Process (PO/POP)
QUOTE
ORDER
PURCHASE
Send us your quote information, and we will come back asap with a formal quote
Send us your order information, and we will come back asap…

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,…

SharePoint Platform: 2010, 2013 On-Premises
This is often coursed by a server side settings in SPWebApplication.ClientCallableSettings
It is default set to 00:01:30 and this is often to low.
To check the setting:
To change the setting to 5 minutes:
PowerShell…

Function reference
Add a file to the Job log fro the current Collection
LogFile( ‘file name’ )
Argument
Description
Filename
The file name to add to the Job log
Multiple files can be specified by separating with ;
Example…

Use a File/Folder selection filter to specify what files & folders to process.
This filter is evaluated Client-Side and enables multiple advanced matching expressions not available in traditional wild card specifications or SharePoint CAML query.

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

Use a Microsoft account and associate an email to it.
(example myname@gmail.com)
If you dont have a MS Live account or forgot password. Then fix it here:
https://login.live.com
Login to O365 here.
https://login.microsoftonline.com/

The Job Server can run as an unattended Windows Service.
Scheduled Jobs will the start automatically independent of any user logged in.
*Important!
Remember to give the account you are using, the proper
permissions to “Log on as a service”.
(Local Security…

Connections stores all properties like URL, user/password etc. necessary to connect to a site in SharePoint.
*A connection can be referenced from multiple Components and user/password can include parameters.
Information about the metadata columns in Lists & Libraries…

Function reference
Converts an integer to a Unicode character.
Char ( n )
Argument
Description
n
The integer you want to convert to a character
Data type: String
Returns the character whose code point value is n.
Example 1
This…

Files can dynamically be omitted from being upload based on an expression.
By Assigning the value “Skip!” to the filename will force the file to be skipped.
The filename will be added to the report “SkippedFiles.txt” that will be embedded in…

Function reference
Sets the first letter of each word in a string to a capital letter and all other letters to lowercase (for example, ROBERT E. LEE would be Robert E. Lee).
WordCap ( string )
Argument
Description
string
A string or…

Function reference
Rounds a number to the specified number of decimal places.
Round ( x , n )
Argument
Description
x
The number you want to round.
n
The number of decimal places to which you want to round x. Valid values are…

Function reference
Truncates a number to the specified number of decimal places.
Truncate ( x, n )
Argument
Description
x
The number you want to truncate.
n
The number of decimal places to which you want to truncate x.…

Review
CONTINUE TO BE IMPRESSED
WOW!
“I suggested a little improvement in functionality to be considered and a week later it is being implemented with a whole lot more. What a responsive team! I continue to be impressed by your group.”
William Lang…

We only deliver support via our central ticket system
Worldwide Support & Service Center:
We have centralized our systems to make sure you are getting a effective support & service
To make sure your issue are not overlooked or forgotten, submit a ticket…

We develop software for the SharePoint world.
We deliver solutions to partners, companies & organizations in nearly all the world
Powers ability to your SharePoint tasks & projects
No-code solutions that would otherwise require complex programming
Multitasking…

Function reference
Obtains the remainder (modulus) of a division operation.
Mod ( x, y )
Argument
Description
x
The number you want to divide by y.
y
The number you want to divide into x
Data type: Number
Example…

We really appreciate your input and ideas
THANKS, to all who have lifted our product by sharing with us
Your issue reporting will get our highest priority
Your input can easily be our next enhancement
Your ideas could change our roadmap for the…

XRM is not a product; it is a strategic approach to building a unified system that connects all aspects of a business together.
XRM is the natural evolution of Customer Relationship Management (CRM).
Over a decade ago it started with a rolodex. Then someone decided…

No-Code Solution
SOMETIMES IT IS HARD TO HEAR
In HARDtalk we go close to the truth:
Tired of endless lines of PowerShell
Profound difference in Productivity
Get the job done – fast and efficient
More:
Quick Links
Reviews
Video Quick…

Function reference
Converts a string to a number.
Number ( string )
Argument
Description
string
The string you want returned as a number.
Data type *Number”
Returns the contents of string as a number. If string is not a valid…

SharePoint Document Libraries that has versioning enabled are supported.
Scenarios:
When transferring files to a Document Library a new version is created.
Files copied from a file share to a Document Library, having the same name, can be created as different…

It is 1 workstation or server, installed with the acquired software. It’s possible to transfer the license from one computer to another. When you purchase or subscribe the software license a Computer License Key are included.
*Any questions or issues –…

Function reference
Replaces all occurrences of a string with a file. (Non case sensitive)
ReplaceTextInFile ( File, SearchFor , ReplaceWith, AddFileToJobLog )
Argument
Description
File
The name of the input file in which you want to replace…

No 5k Threshold Limit. No column indexing. No Special views.
No Coding. No CAML syntax. Simple to use!
Save your parametrized Queries as Componets, and reuse ad hoc or in automated tasks.
Transfer Query result set to:
Screen – interactive…

WORLD WIDE SUPPORT & SERVICE CENTER
Level 0 support
Reserved for automated or self-service tasks without the aid of a personal support.
Level 1 support
Only provides basic support, such as standard instructions, ticket routing and escalation to other…

Script can run AFTER the referenced Components have been executed.
Language
Features
PowerShell
The embedded script is invoked using the PowerShell.exe. The ISE can be used to developing and testing the script. Special PowerShell commands…

Script can run BEFORE any of the referenced Components executes.
Language
Features
PowerShell
The embedded script is invoked using the PowerShell.exe. The ISE can be used to developing and testing the script. Special PowerShell commands are…

In File Transport you can create a WHERE criteria to limit the files being processed.
This criteria is converted into CAML and is evaluated at the server. It is therefore the most effective way to specify a criteria, if you can live with the CAML limitations :-)
(on…

Function reference
Obtains a specified number of characters from the beginning of a string.
Left ( string, n )
| Argument | Description |
| string | The string containing the characters you want |
| n | A long specifying the number of characters you want…

Function reference
Pause program execution for the specified number of seconds.
Pause( ‘seconds’ )
Argument
Description
seconds
The number of seconds to pause. (suspend execution)
Example 1
This example will pause for 5…

Function reference
Returns the id for the current top-level component.
GetJobSessionComponentID()
Example 1
This example will output the id for the top-level component in the current session to the debug window.
Debug( GetJobSessionComponentID()…

Independent consultants that can help and guide you:
Anders Dissing
dissing@sharepointkonsulenterne.dk
A highly skilled SharePoint solution architect with a focus on overall SharePoint solution architecture. With several years of experience as a…

To set both the URL and the description on a URL column use the below format:
Format is: URL, Description
Important: After the comma there is one space.
Example: “https://www.les.com/, Lincoln Electric System”
Using a calculation:
[] + ',…

Function reference
Obtains the current time based on the system time of the client machine.
Now()
Data type: Time
Returns the current time based on the system time of the client machine.
Use Now to compare a time to the system time or to display the system time on…

Function reference
Converts the value of a string to a decimal.
Dec ( string )
Argument
Description
string
The string you want returned as a decimal.
Data type: Decimal
Returns the contents of string as a decimal if it succeeds and 0…

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…

Enjoy the fast install video
Install
Download Software
and just run “OntolicaFusion.exe” – click next, next, next …
make sure to be local administrator
Upgrade: WITH Internet access – upgrade easily from within the software…

Our best practice for connecting in online meetings
It is our experience that international companies and organizations are using so many different and preferred online meeting systems, that we had to make a simple and effective process guide for everyone to use …

Function reference
Converts the first character of a string to its Unicode code point. A Unicode code point is the numerical integer value given to a Unicode character.
Asc ( string )
Argument
Description
string
The string for which you…

Function reference
Combines a date and a time value into a DateTime value.
DateTime ( date {, time } )
Argument
Description
string/date
A valid date (such as Jan 1, 2005, or 12-31-99) or a blob variable whose first value is a date that…

Check the job log to analyze the root of the problem.
Possible causes include:
User does not exist in target environment.
Columns data types does not match.
Event Receivers on the target list has caused the upload terminate before completion.

WORLDWIDE SUPPORT & SERVICE CENTER
CONTACT NOW
We have centralized our systems to make sure you are getting a effective support & service
To make sure your issue are not overlooked or forgotten, submit a ticket with your questions and issue in our…

Review
SWISS KNIFE
“This unique application allows us to tackle any project with this ‘Swiss’ boxcutter of information technology, we can create a lot of solutions: Latest project migrated we 350,000 documents from Oracle DB, file system to…

Office 365 & SharePoint 2013 – Disabling the ‘Following Content’ Feature
SPO sites (but not site collections), have a feature called: ‘Following Content’
This feature is enabled by default when a new site is created. When it is disabled, performance may…

Function reference
CreateFolder( ‘Folder Path’)
Creates a folder on a local drive or File Share.
Multiple subfolders can be created at the same time.
Argument
Description
Folder Path
The folder(s) to create
Data type:…

Enabling a computer to run PowerShell
If you se the error :
File xxxxxxxx.ps1 cannot be loaded because the execution of scripts is disabled on this system. Please see “get-help about_signing” for more details.
Then you must enable your system to run…

Software Maintenance, Support & Service
Software Assurance
All agreements and assurances
Get a missing assurance activated or a closed assurance reactivated.
When your organization need to activate a Software Assurance (SA) on a software license there never…

Combine multiple components into one.
This is useful when creating jobs that performs many different operations as one session.
A Collection can reference all types of Components including other Collections for nested operations.
The Job log will span all referenced…

Function reference
Converts a string whose value is a valid date to a value of datatype date.
Date ( string )
Argument
Description
string
A string containing a valid date (such as Jan 1, 2004, or 12-31-99) that you want returned as a date…

WORLDWIDE SUPPORT & SERVICE CENTER
The support tickets is an effective and constructive way to solve issues together.
TICKET STATUS
Open
New issues, Replies (response) from the user
In Progress
Is been handled, assessed, worked…

There are five stages used in our release cycle.
These necessary phases are essential to the overall goal of putting the most stable & solid software products on the market.
Release Cycle
1
Alpha
2
Beta
3…

*‘Redirect URL’ in The FileTransport Component to dynamically create a SharePoint Site *
Redirect URL: Http://abc.com/Sites/Steen1/MyDocLib
Create a site named “Steen1” and use the document Library “MyDocLib”
Note:…

Function reference
Obtains a specified number of characters from the end of a string.
Right ( string, n )
Argument
Description
string
The string from which you want characters returned.
n
A long whose value is the number of…

Q: Does CtrlSync support/work with Nintex Workflows?
A: Yes – CtrlSync works extremely well with both Nintex Workflows and SharePoint Out-Of-The-Box Workflows.
Example 1.
When Nintex Workflow or OOTB SharePoint Workflow has completed and a new file is published…

2-way access to more than 100 data sources.
A Data Source Driver is the low-level ODBC interface to a given application or database unless stated otherwise.
All favorite Drivers are built-in:
Simple connection set-up and streamlined command execution
No complex…

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…

You can call the same File Transport component for each row in a data set, and dynamically use different Source/Target URL or UNC path.
Note: URL/UNC path values can be dynamically constructed using calculations that references other parameters of database…

Logical
Case()
Tests the values of a column or expression and returns values based on the results of the test.
If()
Evaluates a condition and returns a value based on that condition.
isNull()
Test if the value of…

Release Candidate (RC) features
- RC features are consolidated later in the General Availability Release (GA)
Module
Type
Changes committed for version 6.35 RC – Match 2018
Control Panel
Enhancement
New “Find…

This error is a WinSock error that is being returned by the system socket.
According to the MSDN list of WinSock Error Codes
WSANO_DATA 11004
The requested name is valid and was found in the database, but it does not have the correct associated data…

Function reference
Obtains the number of minutes in the minutes portion of a time value.
Minute ( time )
Argument
Description
time
The time value from which you want the minutes
Data type:Integer
Returns the minutes portion of time…

Service Consultancy Prices
Per hour (per started hour)
Per hour – Voucher card (volume discount)
Per day (volume discount)
Standby time can be booked with -50% discount if not used
We require 7 days cancellation notice prior to scheduled delivery
Changes…

Avoid delays, frustration, panic or need of express delivery with extra cost
Plan ahead:
If your renewal process is a manual PO Process and the delivery of the License Key also are a manual process, it can be important to plan in good time
If the renewal payment…

END-USER LICENSE AGREEMENT (EULA)
READ THE TERMS AND CONDITIONS OF THESE LICENSE TERMS CAREFULLY BEFORE USING THE SOFTWARE.
THE MANUFACTURE (HEREINAFTER CALLED THE “SOFTWARE HOUSE” or “Software House”) OF THIS SOFTWARE PROGRAM (HEREINAFTER…

A filter that specifies what files & folders to process.
This filter is evaluated Client-Side and enables multiple advanced matching expressions not available in traditional wild card specifications or SharePoint CAML query.
Include
Include files/folders…

Please select Repository configuration.
The Repository is where all Components, Parameters Master Data is stored.
You can have multiple Repositories to enabled the separation of different projects from each other.
Using the Version Control feature you can separate…

Function reference
*Set a string value in the Windows Registry. The Key/ValueName is created if it does not exist.
RegistrySetValue( ‘Key’‘ , ‘ValueName’ , Value)
Argument
Description
Key
The registry key…

$ USD
From the 1 of March 2018 it is very simple
We only use one currency – USD
Other currency
Some of our payment systems support valuta price approximate calculation
Centralized outsourcing
We have outsourced the most of our finance, administration,…

A column can be left out of the metadata update by assigning it ‘Skip!’ as value.
This can be done using an expression for example based on other metadata values.
The expression is evaluated individually for each file.
Note: This also works in…

Function reference
Obtains the number of seconds in the seconds portion of a time value.
Second ( time )
Argument
Description
time
The time value from which you want the seconds
Data type: Integer
Returns the seconds portion of time…

Software Maintenance, Support & Service
The yearly 12-months assurance fee is a percent calculated on the end-users registered inventory of software licenses, but never less than the minimum fee on the assurance.
More on the main Software Assurance
More on the…

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…

Function reference
Builds a string of the specified length by repeating the specified characters until the result string is long enough.
Fill ( chars, n )
Argument
Description
chars
A string whose value will be repeated to fill the return…

Function reference
Obtains the year portion of date. Years from 1000 to 3000 inclusive are handled.
Year ( date )
Argument
Description
date
The date value from which you want the year
Data type: Integer
Returns an integer whose value…

Function reference
Finds one string within another string.
Pos ( string1, string2 {, start } )
Argument
Description
string1
The string in which you want to find string2.
string2
The string you want to find in string1.…

Standard support for the 2 latest versions
What is the latest 2 versions?:
The latest active General Available (GA) version and one active software version back.
Example:
v7.1 latest GA software version
v6.x as one version back
v5.x no normally support…

update contact_c
set c_log_antal = result.antal
from contact_c,
(select po_log.c_id as id, count(*) as antal from po_log group by po_log.c_id) as result
!!select must work alone!!
where contact_c.c_id = result.id;
Example
update contact_c
set c_log_antal =…

Easily adjustable templates for fast start-up
A setup from the supplier, used as a starting point for a particular task, project or application so that the format does not have to be recreated each time it is used
(You make your own templates and setup for use…

Function reference
Finds the last position of a target string in a source string.
LastPos ( string1, string2, searchlength )
| Argument | Description |
| string1 | The string in which you want to find string2. |
| string2 | The string you want to find in string1.…

Function reference
Converts a string to a time datatype.
Time ( string )
Argument
Description
string
A string containing a valid time (such as 8 am or 10:25) that you want returned as a time datatype. Only the hour is required; you do not…

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…

This Data Transport Target, forms a “For Each” loop around the data set retrieved, and executes a linked Component.
The column values for each row are represented as parameters and can be assigned directly to target columns in the linked component and…

Allows you to automatically run tasks multiple times with different input data/parameters. (Data Driven Automation – one by one)
No Programming Skills Required.
(The profound difference in productivity.)
Perform tasks For Each instance in input Data…

All Automation Components generate a job log each time they run.
Multiple components can be grouped together in a Collection to form a composite job with many steps.
In this case log entries are hierarchy referenced for each component in the collection so that the…

Function reference
Obtains a specified number of characters from a specified position in a string.
Mid ( string, start {, length } )
Argument
Description
string
The string from which you want characters returned.
start
A…

PRODUCTIVITY is the PROFOUND DIFFERENCE between “Data Driven Automation” and hard coded actions, whether it’s done in some Tool, PowerShell or manually.
And best of all – without a single line of Code!
Manual Labour & PowerShell
Data Driven…

Function reference
Make the combined Site URL for interpretation in the FileTransport component when called from DataTransport/For-Each-Row.
SharePointSourceURL(Site, DocumentLibrary, FolderAndWildcard)
Argument
Description
Site
The URL to…

Function reference
Make the combined Site URL for interpretation in the FileTransport component when called from DataTransport/For-Each-Row.
SharePointTargetURL(Site, DocumentLibrary, Folder, ContentType)
Argument
Description
Site
The URL…