The topic you requested could not be found.
Related topics are listed below.

Fusion overview

Documentation » Video library » Fusion overview

Showcases of some of the main features of Ontolica Fusion Video library

Ontolica Fusion Desktop

Software Download » Ontolica Fusion Desktop

Download the latest version We will continue to update the software version, this is the latest release Product Version General Available (GA) Ontolica Fusion Desktop 6.1 January 2018 DOWNLOAD You are up and run in…

Ontolica Fusion CtrlSync

Software Download » Ontolica Fusion CtrlSync

Download the latest version We will continue to update the software version, this is the latest release Product Version General Available (GA) Ontolica Fusion CtrlSync 6.1 January 2018 DOWNLOAD You are up and run in…

Ontolica Fusion Road map (16-01-2018)

Documentation » Miscellaneous » Ontolica Fusion Road map (16-01-2018)

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

This is what Ontolica Fusion cannot do…

Documentation » Miscellaneous » This is what Ontolica Fusion cannot do…

Copy SharePoint site structures 1:1. SharePoint Governance and site backup/restore. Create/Update/Delete Items in SharePoint Term Store databases.

Installing Fusion

Documentation » Video library » Installing Fusion

This video will show you how to install Fusion on your computer! Video library

Features

Documentation » Templates » CtrlSync for SharePoint » Features

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…

Function reference

Documentation » Component reference » Function reference

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…

Fusion random crash “BEX”

Documentation » FAQ & How to » Fusion random crash “BEX”

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

Documentation » PowerShell » Run PowerShell from Fusion

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…

Fusion Control Panel

Documentation » Fusion Control Panel

The main window where Components and system functions are managed

Functions & Features

Functions & Features

Ontolica Fusion Desktop The scope of Functions & Features content are depending on the edition: Ontolica Fusion STANDARD Edtion (STD) Ontolica Fusion PROFESSIONAL Edtion (PROF) Ontolica Fusion ENTERPRISE Edtion (EAS) GENERAL: Complement with SharePoint,…

Other ONTOLICA Products

Other ONTOLICA Products

docs.surfray.com is our new unified documentation experience For additional documentation on our products, please visit: There you will find the most known information, answers to your questions etc. Remember to use the search box in the…

Welcome to Fusion – Easy Automation For SharePoint

Documentation » Welcome to Fusion – Easy Automation For SharePoint

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…

How to renew my Fusion subscription?

FAQ » How to renew my Fusion subscription?

We recommend that our current customers renew their subscription directly through the application. For a complete walkthrough, click here. Otherwise, you may also request your renewal options directly at support & service center

Subscription Price Sheet

Pricing & Plans » Subscription Price Sheet

Ontolica Fusion Desktop – Subscription Price sheet SHOP NOW The scope of Function & Features are depending on the edition: View Edition Content Functions & Features Pricing when purchasing: from USA / USD from EMEA /…

Pepertual Price Sheet

Pricing & Plans » Pepertual Price Sheet

Ontolica Fusion Desktop – Pepertual Price Sheet SHOP NOW The scope of Function & Features are depending on the edition: View Edition Content Functions & Features Pricing when purchasing: from USA / USD from EMEA / EUR…

GDPR

Functions & Features » GDPR

Functions & Features The scope of Functions & Features content are depending on the edition: Ontolica Fusion STANDARD Edtion (STD) Ontolica Fusion PROFESSIONAL Edtion (PROF) Ontolica Fusion ENTERPRISE Edtion (EAS) Comming soon INCLUDED IN THE EDITIONS …

Architecture Docs

Functions & Features » Architecture Docs

Functions & Features The scope of Functions & Features content are depending on the edition: Ontolica Fusion STANDARD Edtion (STD) Ontolica Fusion PROFESSIONAL Edtion (PROF) Ontolica Fusion ENTERPRISE Edtion (EAS) Comming soon INCLUDED IN THE EDITIONS …

Excel Reporting

Functions & Features » Excel Reporting

Functions & Features The scope of Functions & Features content are depending on the edition: Ontolica Fusion STANDARD Edtion (STD) Ontolica Fusion PROFESSIONAL Edtion (PROF) Ontolica Fusion ENTERPRISE Edtion (EAS) Turn days into hours INCLUDED IN THE…

WebHooks

Functions & Features » WebHooks

Functions & Features The scope of Functions & Features content are depending on the edition: Ontolica Fusion STANDARD Edtion (STD) Ontolica Fusion PROFESSIONAL Edtion (PROF) Ontolica Fusion ENTERPRISE Edtion (EAS) Comming soon INCLUDED IN THE EDITIONS …

Automation

Functions & Features » Automation

Functions & Features The scope of Functions & Features content are depending on the edition: Ontolica Fusion STANDARD Edtion (STD) Ontolica Fusion PROFESSIONAL Edtion (PROF) Ontolica Fusion ENTERPRISE Edtion (EAS) Turn days into hours INCLUDED IN THE…

Job Scheduling

Functions & Features » Job Scheduling

Functions & Features The scope of Functions & Features content are depending on the edition: Ontolica Fusion STANDARD Edtion (STD) Ontolica Fusion PROFESSIONAL Edtion (PROF) Ontolica Fusion ENTERPRISE Edtion (EAS) Turn days into hours INCLUDED IN THE…

File Transport

Functions & Features » File Transport

Functions & Features The scope of Functions & Features content are depending on the edition: Ontolica Fusion STANDARD Edtion (STD) Ontolica Fusion PROFESSIONAL Edtion (PROF) Ontolica Fusion ENTERPRISE Edtion (EAS) Turn days into hours INCLUDED IN THE…

Software Download

Software Download

You are up and running in minutes DOWNLOAD Free Trial DOWNLOAD ONTOLICA FUSION DESKTOP – Latest version Whats New Changelog DOWNLOAD Ontolica Fusion CtrlSync – Latest version…

Data Transport

Functions & Features » Data Transport

Functions & Features The scope of Functions & Features content are depending on the edition: Ontolica Fusion STANDARD Edtion (STD) Ontolica Fusion PROFESSIONAL Edtion (PROF) Ontolica Fusion ENTERPRISE Edtion (EAS) Turn days into hours INCLUDED IN THE…

What’s in it for me?

Introduction » What’s in it for me?

Ontolica Fusion will make it easier to meet deadlines Rather than waiting for the ability, TRY the new and powerful game changer FOR SHAREPOINT AND POWERSHELL Whats in it for me? I’m Management I’m SharePoint Admin/Analyst I’m SharePoint…

What is a computer license?

FAQ » What is a computer license?

It is 1 workstation or server, installed with Ontolica Fusion. It’s possible to transfer the license from one computer to another. More information is available here

Benefits

Introduction » Benefits

Discover Ontolica Fusion & Make Amazing Solution Ontolica Fusion complements SharePoint, PowerShell, and OneDrive Save You Vast Amount Of Time. Reduce scripting and resource requirements with No-Coding setup Integrate/Sync line of business content with Office…

Licensing Model

Licensing Model

Ontolica Fusion Desktop Subscription license Perpetual license Consumptive license The scope of Function & Features are depending on the edition: View Edition Function & Features 1. Subscription License A renewable license, usually annual, including…

Description

Introduction » Description

Ontolica Fusion short description – delivers you fast results … Fast and adaptable prefabricated program components that reduce the PowerShell scripting needs, gain programmer independence and deliver rock-solid reliable solutions a lot quicker than…

Pricing & Plans

Pricing & Plans

Ontolica Fusion Desktop Edtion Content Functions & Features STANDARD (STD) PROFESSIONAL (PROF) ENTERPRISE (EAS) Most Popular 12 months Subscription 12 months Subscription 12 months Subscription 3,000…

CtrlSync Licensing

Documentation » Templates » CtrlSync for SharePoint » CtrlSync Licensing

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…

Start your FREE trial

Start your FREE trial

You are up and running with the FREE TRAIL in minutes VIDEO Enjoy our 5-minutes power introduction WEBINAR Register for our next introduction webinar DOWNLOAD Start your FREE Ontolica Fusion TRIAL ENJOY VIDEO NEXT WEBINAR DOWNLOAD FREE TRIAL…

Order, Purchase & Delivery

Order, Purchase & Delivery

IT IS EASY TO ACQUIRE ONTOLICA FUSION Request a formal Quote in our Support & Service Center Online Shopping Purchase Order Process Payment Methods More information: Pricing & Plans Reviews *Start your FREE TRIAL. You will be up and run in…

Introduction

Introduction

Ontolica Fusion short introduction Ontolica Fusion complements SharePoint, PowerShell, and OneDrive SharePoint High-Speed File & Data TRANSPORT No-Coding Productivity Framework File Transporter Data Transporter Excel Reporting Automation Job…

I’m SharePoint Admin/Analyst

Introduction » Whats in it for me? » I’m SharePoint Admin/Analyst

Tired of endless lines of PowerShell script? ..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…

Deployment

Documentation » Templates » CtrlSync for SharePoint » Deployment

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…

Partners

Introduction » Partners

FIND YOUR ONTOLICA FUSION SOLUTION PARTNER Collaborate with people who deliver results We have an Ontolica Partner, who will match your challenges, business, and organization Konsulent Fabrikken – Denmark NSI…

License Key

Licensing Model » License Key

A computer license key has to be acquired for each local workstation or central server. Ontolica 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…

Consultant Factory – Denmark

Introduction » Reviews » Consultant Factory – Denmark

Ontolica Fusion Review “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 need…

Install & Upgrade

Install & Upgrade

You are up and running in minutes with Ontolica Fusion Install Quick Guide Download Software and just run “OntolicaFusion.exe” – click next, next, next … - (make sure to be local administrator) Upgrade Quick Guide – Internet…

NSI IT – Belgium

Introduction » Reviews » NSI IT – Belgium

Ontolica Fusion Review “Definitely a great tool, we often use it for complex migration to SharePoint.” Philippe Mélisen – NSI IT – Belgium Need more to be convinced Description Benefits Pricing & Plans *Start your FREE TRIAL –…

Business Logic and Application examples

Documentation » Use Cases » Business Logic and Application examples

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…

OLD introduction

Product » Description » OLD introduction

SAVE TIME – GET DATA & FILES MOVING! LESS CODING FOR FASTER RESULTS For all your SharePoint solutions Here you will find detailed information about Ontolica Fusion. Try the search box in the upper right corner docs.surfray.com is our unified…

Spindustry – USA – Start

Introduction » Reviews » Spindustry – USA – Start

. Ontolica Fusion Review “We are kicking off this relationship with a solid implementation of one of the coolest SharePoint tools out there” Zach Eisenhauer – Spindustry – USA Need more to be convinced Description Benefits Pricing &…

Spindustry – USA – Running

Introduction » Reviews » Spindustry – USA – Running

. Ontolica Fusion Review “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 all together. Well done.” Zach Eisenhauer – Spindustry…

Reviews

Introduction » Reviews

Ontolica Fusion Reviews Get worldwide reviews and experience directly from companies, partners, developers, and consultants Extract: Lincoln Electric System – USA Konsulent Fabrikken – Denmark Spindustry – USA –…

Lincoln Electric System – USA

Introduction » Reviews » Lincoln Electric System – USA

Ontolica Fusion Review 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 –…

Welcome

Fusion Control Panel » System Configuration » Welcome

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…

Install program don’t seem to work

Install and Upgrade » Install program don’t seem to work

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

PowerShell

Documentation » PowerShell

Call PowerShell from within Fusion Call Fusion Components from PowerShell

Payment Method

Order, Purchase and Delivery » Payment Method

Supported payment method . ONLINE SHOPPING 24/7-365 Online: Ontolica Fusion subscription Master Card Visa Amex Discover PayPal FEE + Small fixed Invoice fee + Fixed Card / PayPal fee PURCHASE ORDER PROCESS (PO/POP) We support shopping with PO process,…

GoalWare – Italy

Introduction » Reviews » GoalWare – Italy

Ontolica Fusion Review “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…

Installation Package

Fusion Control Panel » System Configuration » Installation Package

CtrlSync for SharePoint Installation Package content. Corporate Branding – logo, colours etc. Custom Business Logic URL to the Subscription Site. Automatic silent configuration with custom Installation…

I’m SharePoint Consultant

Introduction » Whats in it for me? » I’m SharePoint Consultant

How can I deliver a more robust, extensible and well documented solution without endless lines PowerShell? ..Automating data and file processing within SharePoint is unthinkable without PowerShell. And for good reason, all the necessary access to lower level data…

I’m SharePoint Project Manager

Introduction » Whats in it for me? » I’m SharePoint Project Manager

How can we deliver SharePoint projects without the risk of volatile PowerShell development? .. As PowerShell scripts become larger and more complex the more they depend on their developers and the more volatile they get. So change of staff or simple script…

Whats new

Roadmap » Whats new

New Things Makes Us Feel So Good Changelog Next version Module Version 6.12 – January 2018 – Change Log here and RoadMap here FileTransport 20% performance enhancement when copying 1000 files. DataTransport…

SharePoint Site Provisioning (PnP)

Component reference » Data Transport » SharePoint Site Provisioning (PnP)

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…

Use Cases

Documentation » Use Cases

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…

Get the job done – Fast and efficient

Introduction » HARDtalk » Get the job done – Fast and efficient

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

Changelog

Roadmap » Changelog

All New Enhancements and Fixed Issues Roadmap Whats new Next version Module Type Version 6.12 January 2018 FileTransport Fixed Crash in second preview dialog box when there were no files to transfer. Module…

Migrating SharePoint BLOG Site

Documentation » FAQ & How to » Migrating SharePoint BLOG Site

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…

I´m Management

Introduction » Whats in it for me? » I´m Management

Whats in it for me? GET COMPLEX SharePoint SOFTWARE DEVELOPMENT DONE IN RECORD TIME AT A FRACTION OF THE COST Ontolica Fusion significantly reduce the complexity, risks, and investment in PowerShell and SharePoint solutions Rock solid win/win benefits to…

Run external program (API)

Component reference » Collection » Run external program (API)

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…

PnP Provisioning Engine for PowerShell

Documentation » PowerShell » PnP Provisioning Engine for PowerShell

Fusion supports the PnP Provisioning Engine. via the Collection Component before/after PowerShell scripts. To get an overview – read: Introducing the PnP Provisioning Engine. Documentation for CmdLets *Microsoft: Why the new approach? This begs the question,…

Importing Lotus Notes Documents into SharePoint via AGECOM Export Utility

Easy Automation – Data Driven » Legacy ECM data to SharePoint » Importing Lotus Notes Documents into SharePoint via AGECOM Export Utility

Fusion imports Lotus Notes Documents including embedded files and attachments into SharePoint in a 3 step customizable process. In SharePoint the Notes Documents will “end up” in 2 SharePonit lists. One for the Attachments and one for the Notes body and…

Input

Introduction » Whats in it for me? » I´m Management » Input

Adaptable prefabricated program components that reduce the PowerShell scripting needs. Reduce scripting needs and gain programmer independence and deliver reliable solutions much quicker. Reduce scripting and gain programmer independence for creating and maintain…

Batch job monitor

Documentation » Fusion Control Panel » Batch job monitor

Controls and monitors Components that runs on a scheduled basis or is invoked from PowerShell. Jobs modes: Que – sequentially, one after another. Parallel – multiple jobs runs simultaneously. PowerShell – Jobs initiated using the function…

Date and Time calculation

Documentation » FAQ & How to » Date and Time calculation

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

I’m SharePoint PowerUser

Introduction » Whats in it for me? » I’m SharePoint PowerUser

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…

Check for Updates/New version

Documentation » FAQ & How to » Check for Updates/New version

Fusion will automatically check for updates every 2 weeks. You can manually do it this way:

Run Component from PowerShell

Documentation » PowerShell » Run Component from PowerShell

Invoke-xComponent $MyJob = Invoke-xComponent -Name [-Description] [-SourceRedirec] [-SourceUser] [-SourcePassword] [-TargetRedirect] [-TargetUser] [-TargetPassword] [-FusionParameters] Name Description -Name The name of the component to…

Job Server

Fusion Control Panel » Batch job monitor » Job Server

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…

I’m SharePoint Developer

Introduction » Whats in it for me? » I’m SharePoint Developer

How can I do more with SharePoint faster? …PowerShell is great in many ways but the larger and more complex scripts become the more time it takes to edit and extend without breaking existing functionality. Time is easily consumed by doing trivial tasks like…

Synchronize files between SharePoint environments

Documentation » Video library » Synchronize files between SharePoint environments

In this tutorial we will show you how to synchronize your files between two SharePoint Environments using Fusion Video library

Flat Migration of FileShares to SharePoint (eliminating folders)

Documentation » Video library » Flat Migration of FileShares to SharePoint (eliminating folders)

This Tutorial will show you how to perform a flat migration of FileShares to SharePoint using Fusion! Video library

Delete items or documents from SharePoint

Documentation » Use Cases » Delete items or documents from SharePoint

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…

Copy files from SharePoint to SharePoint (including folders)

Documentation » Video library » Copy files from SharePoint to SharePoint (including folders)

In this tutorial we will show you how to migrate your documents from one SharePoint environment to another using Fusion! Video library

Video: Run Batch Server as Windows Service

Fusion Control Panel » Batch job monitor » Video: Run Batch Server as Windows Service

In this tutorial we show you How to Configure the Fusion Batch Server to Run as a Windows Service. Video library

Script before (Collection)

Component reference » Collection » Script before (Collection)

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…

Conditional replication of Documents from Site to Site at high speed.

Documentation » Use Cases » Conditional replication of Documents from Site to Site at high speed.

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

Add/Update SharePoint List Items from external data source

Documentation » Use Cases » Add/Update SharePoint List Items from external data source

Data “travel” from Source to Target via the Data Transport component Key features Create / Update Items with data from databases or applications like MS Dynamics, SAP. Create / Update Items using Items from same list or…

On the drawing board

Roadmap » On the drawing board

Office 365 WEBHOOKS coming to Fusion Module Type Features committed for version 6.5 – mid 2018 System New Automatic Solution Documentation. Output an active PDF listing all components, parameters, jobs etc including…

Video: Schedule an ongoing synchronization

Fusion Control Panel » Batch job monitor » Video: Schedule an ongoing synchronization

In this tutorial we show you how to schedule an ongoing batch synchronization between two SharePoint environments using Fusion Video library

Installation

Documentation » Miscellaneous » Installation

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…

Schedule an ongoing synchronization

Documentation » Video library » Schedule an ongoing synchronization

In this tutorial we show you how to schedule an ongoing batch synchronization between two SharePoint environments using Fusion Video library

System requirements

Install & Upgrade » System requirements

Performance is greatly dependent on available Memory & CPU power Memory: Constraint the degree of multitasking when transferring files and SharePoint Items CPU: The calculation speed for folder structure flattening and individual columns metadata transformations as…

Site Provisioning Create/Update/Delete Sites in BULK.

Documentation » Use Cases » Site Provisioning Create/Update/Delete Sites in BULK.

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…

“List View Threshold” and the 5000 items Show Stopper issue

Documentation » FAQ & How to » “List View Threshold” and the 5000 items Show Stopper issue

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…

CSV Importer/Exporter with powerful filters

Documentation » Use Cases » CSV Importer/Exporter with powerful filters

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…

Script after (Collection)

Component reference » Collection » Script after (Collection)

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…

Replicate/Migrate FileShare to SharePoint Library at high speed

Documentation » Use Cases » Replicate/Migrate FileShare to SharePoint Library at high speed

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

FAQ

FAQ

Frequently asked question Your question! What is a computer license? Are there any maintenance fees? Do you offer a consultant license? How to renew my Fusion Subscripti? Are there any limitations to my license? Do you offer a monthly subscription? What…

Online Shopping

Order, Purchase & Delivery » Online Shopping

Ontolica Online Shopping 24/7 365 Easy Shopping Online – SAVE – No overhead of cost and fee’s No – Purchase Order Process Fee No – extra handling Fee What products are supported for shopping online … *GO ONLINE…

SharePoint Site Provisioning

Component reference » Data Transport » SharePoint Site Provisioning

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…

Use our Support & Service Center

Use our Support & Service Center

USE OUR SUPPORT & SERVICE CENTER Tell us of 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

SharePoint Subsites List

Component reference » Data Transport » SharePoint Subsites List

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…

CharNewLine()

Component reference » Function reference » Text » CharNewLine()

Function reference Return the 2 characters Carriage Return NewLine

Error: Document properties can not be extracted

FAQ & How to » Error conditions… » Error: Document properties can not be extracted

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…

Null values returned form a database

Documentation » FAQ & How to » Null values returned form a database

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…

CtrlSync for SharePoint

Documentation » Templates » CtrlSync for SharePoint

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…

External automation from PowerShell

Documentation » Use Cases » External automation from PowerShell

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…

Run a component in batch

Fusion Control Panel » Batch job monitor » Run a component in batch

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…

Versioning & Approval

Component reference » File Transport » Versioning & Approval

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…

Starting the server

Fusion Control Panel » Batch job monitor » Batch Server » Starting the server

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…

Editions

Licensing Model » Editions

Functions & Features content are depending on the software edition SCOPE STANDARD PROFESSIONAL ENTERPRISE File Transport Data Transport Excel Reporting …

CtrlSync Setup 1-4

Fusion Control Panel » System Configuration » CtrlSync Setup 1-4

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…

Today()

Component reference » Function reference » Date & Time » Today()

Function reference Obtains the system date and time. Today ( ) Data type: DateTime Returns the current system date and time.

Data Movement – in & out of SharePoint

Documentation » Use Cases » Data Movement – in & out of SharePoint

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…

Connectors to ERP/CRM and Databases

Documentation » Use Cases » Connectors to ERP/CRM and Databases

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…

Advanced configuration settings

Documentation » Miscellaneous » Advanced configuration settings

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…

SharePoint migration and beyond

Introduction » Description » SharePoint migration and beyond

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…

GetJobSessionID()

Component reference » Function reference » Miscellaneous » GetJobSessionID()

Function reference Returns the unique id for the current component session. GetJobSessionID() Example 1 This example will output the current SessionID to the debug window. Debug( GetJobSessionID() )

Microsoft Text ODBC Driver

Fusion Control Panel » Database connections » Microsoft Text ODBC Driver

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

Legacy ECM data to SharePoint

Documentation » Use Cases » Legacy ECM data to SharePoint

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…

Expression examples

Component reference » Function reference » Expression examples

Function reference Examples of how expressions can be used If( Pos( ‘[data]’ , ‘Apple’) > 0, ‘Apple’ , ‘Other’) If( ‘xyz’ ‘ + ‘[data]’ = ‘xyz1’ , 1 , 0’) If(…

SharePoint Lookup Columns

Documentation » Component reference » SharePoint Lookup Columns

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…

Output()

Component reference » Function reference » Miscellaneous » Output()

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…

Are there any limitations to my license?

FAQ » Are there any limitations to my license?

You can use the software on an unlimited amount of farms/tenants within the same company or its subsidiaries. Depending on what software edition you have acquired, there can be some limitation on functions & features More information is available…

SharePoint column types and data validation

Documentation » Component reference » SharePoint column types and data validation

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…

FirstDayOfMonth()

Component reference » Function reference » Date & Time » FirstDayOfMonth()

Function reference Return the first day of the month as a date data type. FirstDayOfMonth( string date ) Argument Description string date The date represented as a string Data type: Date Example: Expression returns…

Pause()

Component reference » Function reference » Miscellaneous » Pause()

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…

GetJobSessionComponentID()

Component reference » Function reference » Miscellaneous » GetJobSessionComponentID()

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

IsNull()

Component reference » Function reference » Logical » IsNull()

Function reference Test if the value of an expression is null. IsNull ( expression ) Argument Description expression An expression that you want to test to determine whether its return value is null Data type: Boolean Returns true…

LastDayOfMonth()

Component reference » Function reference » Date & Time » LastDayOfMonth()

Function reference Return the last day of the month as a date data type. LastDayOfMonth( string date ) Argument Description string date The date represented as a string Data type: Date Example: Expression returns…

MonthNameN()

Component reference » Function reference » Date & Time » MonthNameN()

Function reference Return the month’s name based on the months number (1-12). MonthNameN( n ) Argument Description n The month number 1-12 Data type: String Example: Expression returns June MonthNameN( 6 )

WeekNumberUS()

Component reference » Function reference » Date & Time » WeekNumberUS()

Function reference Return the week number of a date value. (US standard) WeekNumberUS ( ‘string date’ ) Argument Description string date The date for which you want the week number Data type:…

Rand()

Component reference » Function reference » Numeric » Rand()

Function reference Obtains a random whole number between 1 and a specified upper limit. Rand ( n ) Argument Description n The upper limit of the range of random numbers you want returned. The lower limit is always 1. The upper limit cannot…

Master Data Management

Documentation » Use Cases » Master Data Management

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…

ReplaceTextInFile()

Component reference » Function reference » Text » ReplaceTextInFile()

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…

Update metadata on Documents in SharePoint

Documentation » Use Cases » Update metadata on Documents in SharePoint

Key features Use data from Databases or CSV/TXT files. Preserve timestamps and ModifiedBy (optional) Re-Run FileShare migration and apply additional metadata only. Convert text or numeric values to Managed…

GetDirectory()

Component reference » Function reference » File » GetDirectory()

Function reference Select a directory. Returns directory path or ‘’ if cancelled. GetDirectory( window title , start path ) Argument Description string The window title of the dialog box string The directory…

MonthName()

Component reference » Function reference » Date & Time » MonthName()

Function reference Obtains the month of a date value and returns the month’s name. MonthName ( ‘string date’ ) Argument Description string date The date for which you want the name of the month Data type:…

Number()

Component reference » Function reference » Numeric » Number()

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…

RegistryGetValue()

Component reference » Function reference » Miscellaneous » RegistryGetValue()

Function reference Return a string value form the Windows Registry. If the key does not exist the default value is returned. RegistryGetValue( ‘Key’‘ , ‘ValueName’ , ‘Default’ ) Argument Description Key…

RightTrim()

Component reference » Function reference » Text » RightTrim()

Function reference Removes spaces from the end of a string. RightTrim ( string ) Argument Description string The string you want returned with trailing blanks deleted. Data type: String Returns a copy of string with trailing blanks…

Trim()

Component reference » Function reference » Text » Trim()

Function reference Removes leading and trailing spaces from a string. Trim ( string ) Argument Description string The string you want returned with leading and trailing spaces deleted. Data type: String Returns a copy of string with…

Len()

Component reference » Function reference » Text » Len()

Function reference Reports the length of a string in characters. Len ( string ) Argument Description string The string for which you want the length Data type: Long Returns a long containing the length of string in…

LastDayOfWeekISO()

Component reference » Function reference » Date & Time » LastDayOfWeekISO()

Function reference Get the last day of the week as a date data type. (ISO standard) LastDayOfWeekISO( year , week ) Argument Description year a numeric value for the year week a numeric value for the week number…

Hour()

Component reference » Function reference » Date & Time » Hour()

Function reference Obtains the hour in n time value. The hour is based on a 24-hour clock. Hour ( time ) Argument Description time The time value from which you want the hour Data type: Integer Returns an integer (00-23)…

Finish()

Component reference » Function reference » Collection » Finish()

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…

LogMessage()

Component reference » Function reference » Collection » LogMessage()

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…

Lower()

Component reference » Function reference » Text » Lower()

Function reference Converts all the characters in a string to lowercase. Lower ( string ) Argument Description string The string you want to convert to lowercase letters. Data type: String Returns string with uppercase letters…

Mod()

Component reference » Function reference » Numeric » Mod()

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…

Minute()

Component reference » Function reference » Date & Time » Minute()

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…

FirstDayOfWeekISO()

Component reference » Function reference » Date & Time » FirstDayOfWeekISO()

Function reference Get the first day of the week as a date data type. (ISO standard) FirstDayOfWeekISO( year , week ) Argument Description year a numeric value for the year week a numeric value for the week number…

Space()

Component reference » Function reference » Text » Space()

Function reference Builds a string of the specified length whose value consists of spaces. Space ( n ) | Argument | Description | |n | A long whose value is the length of the string you want filled with spaces. Data type: String Returns a string filled with n…

WeekNumberISO()

Component reference » Function reference » Date & Time » WeekNumberISO()

Function reference Return the week number of a date value. (ISO standard) WeekNumberISO ( ‘string date’ ) Argument Description string date The date, represented as a string, for which you want the week number Data type:…

RegistrySetValue()

Component reference » Function reference » Miscellaneous » RegistrySetValue()

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…

ReplaceAll()

Component reference » Function reference » Text » ReplaceAll()

Function reference Replaces all occurrences of a string with another string. (Non case sensitive) *ReplaceAll ( string1 , searchfor , replacewith ) Argument Description string1 The string in which you want to replace searchfor with…

LeftTrim()

Component reference » Function reference » Text » LeftTrim()

Function reference Removes spaces from the beginning of a string. LeftTrim ( string ) Argument Description string The string you want returned with leading spaces deleted Data type: String Returns a copy of string with leading spaces…

Char()

Component reference » Function reference » Text » Char()

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…

LastDayOfWeekUS()

Component reference » Function reference » Date & Time » LastDayOfWeekUS()

Function reference Return the last day of the week as a date data type. (US standard) LastDayOfWeekUS( year , week ) Argument Description year a numeric value for the year week a numeric value for the week number…

FirstDayOfWeekUS()

Component reference » Function reference » Date & Time » FirstDayOfWeekUS()

Function reference Get the first day of the week as a date data type. (US standard) FirstDayOfWeekUS( year , week ) Argument Description year a numeric value for the year week a numeric value for the week number…

Upper()

Component reference » Function reference » Text » Upper()

Function reference Converts all characters in a string to uppercase letters. Upper ( string ) Argument Description string The string you want to convert to uppercase letters. Data type: String Rturns string with lowercase letters…

Second()

Component reference » Function reference » Date & Time » Second()

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…

Day()

Component reference » Function reference » Date & Time » Day()

Function reference Obtains the day number of the month in a date value. Day ( date ) Argument Description date The date for which yhu want the day Data type: Integer Returns an integer representing the day of the month in a…

Skip()

Component reference » Function reference » Collection » Skip()

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…

Document Libaray Performance tip (O365, 2013)

Component reference » File Transport » Document Libaray Performance tip (O365, 2013)

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…

Pos()

Component reference » Function reference » Text » Pos()

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

YearsAfter()

Component reference » Function reference » Date & Time » YearsAfter()

Function reference Return the number of years one date occurs after another. YearsAfter ( ‘date1’, ‘date2’ ) Argument Description date1 A date value represented as string that is the start of the interval being…

LogError()

Component reference » Function reference » Collection » LogError()

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…

IsNumber()

Component reference » Function reference » Numeric » IsNumber()

Function reference Reports whether the value of a string is a number. IsNumber ( string ) Argument Description string A string whose value you want to test to determine whether it is a valid number. Data type: Boolean Returns true if…

DayName()

Component reference » Function reference » Date & Time » DayName()

Function reference Obtains the day of the week in a date value and returns the weekday’s name. DayName ( date ) Argument Description string date The date for which you want the name of the day Data type: String Returns a string…

Month()

Component reference » Function reference » Date & Time » Month()

Function reference Gets the month of a date value. Month ( date ) Argument Description date The date from which you want the month Data type: Integer Returns an integer (1 to 12) whose value is the month portion of date. Example…

HoursAfter()

Component reference » Function reference » Date & Time » HoursAfter()

Function reference Obtains the number of hours one datetime occurs after another. HoursAfter ( ‘datetime1 ‘, ‘datetime2’ ) Argument Description datetime1 A datetime value represented as string that is the start of…

DayNameLocal()

Component reference » Function reference » Date & Time » DayNameLocal()

Function reference Gets the day of the week in a date value and returns the weekday’s name in localized language. DayNameLocal ( string date ) Argument Description string date The date represented as a string for which you want the…

MonthsAfter()

Component reference » Function reference » Date & Time » MonthsAfter()

Function reference Return the number of months one date occurs after another. MonthsAfter ( ‘date1’, ‘date2’ ) Argument Description date1 A date value represented as string that is the start of the interval being…

Dec()

Component reference » Function reference » Numeric » Dec()

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…

LogWarning()

Component reference » Function reference » Collection » LogWarning()

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 …

RelativeMonth()

Component reference » Function reference » Date & Time » RelativeMonth()

Function reference Obtains the date that occurs a specified number of months after or before another date. RelativeMonth( date, n ) Argument Description string A date value n An integer indicating the number of…

GetOfficeFileProperty

Component reference » Function reference » Miscellaneous » GetOfficeFileProperty

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

DaysAfter()

Component reference » Function reference » Date & Time » DaysAfter()

Function reference Return the number of days one date occurs after another. DaysAfter ( date1, date2 ) Argument Description date1 A date value that is the start date of the interval being measured date2 A date value that is…

LogFile()

Component reference » Function reference » Collection » LogFile()

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…

CreateFolder()

Component reference » Function reference » File » CreateFolder()

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

CallCollection()

Component reference » Function reference » Collection » CallCollection()

Function reference Call a Collection Component. CallCollection( ‘NameOrId’) Argument Description NameOrId The name or the internal ID of the collection Component to call Data type: String Returns values …

IsDate()

Component reference » Function reference » Date & Time » IsDate()

Function reference Tests whether a string value is a valid date. IsDate ( datavalue ) Argument Description datavalue A string whose value you want to test to determine whether it is a valid date Data type: Boolean Returns true if…

Date()

Component reference » Function reference » Date & Time » Date()

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…

DayNumber()

Component reference » Function reference » Date & Time » DayNumber()

Function reference Gets the day of the week of a date value and returns the number of the weekday. DayNumber ( date ) Argument Description date The date from which you want the number of the day of the week. value1 > value2 Data type:…

RelativeTime()

Component reference » Function reference » Date & Time » RelativeTime()

Function reference Obtains a time that occurs a specified number of seconds after or before another time within a 24-hour period. RelativeTime ( time, n ) Argument Description time A time value n A long number of seconds…

WordCap()

Component reference » Function reference » Text » WordCap()

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…

RelativeDate()

Component reference » Function reference » Date & Time » RelativeDate()

Function reference Obtains the date that occurs a specified number of days after or before another date. RelativeDate ( date, n ) Argument Description date A date value n An integer indicating the number of days Data…

IndexValue()

Component reference » Function reference » Text » IndexValue()

Function reference Returns a value form a delimited string based on an index IndexValue( sourcestring , delimiterstring, indexnumber) Argument Description sourcestring The list of values delimiterstring The string that…

Left()

Component reference » Function reference » Text » Left()

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…

SecondsAfter()

Component reference » Function reference » Date & Time » SecondsAfter()

Function reference Gets the number of seconds one time occurs after another. SecondsAfter ( time1, time2 ) Argument Description time1 A time value that is the start time of the interval being measured. time2 A time value…

RelativeDateTime()

Component reference » Function reference » Date & Time » RelativeDateTime()

Function reference Obtains a datetime that occurs a specified number of seconds after or before another datetime. RelativeDateTime ( datetime, n ) Argument Description string A datetime value n A long number of seconds…

RelativeYear()

Component reference » Function reference » Date & Time » RelativeYear()

Function reference Obtains the date that occurs a specified number of years after or before another date. RelativeYear ( date , n ) Argument Description string A date value n An integer indicating the number of…

Now()

Component reference » Function reference » Date & Time » Now()

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…

LastPos()

Component reference » Function reference » Text » LastPos()

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

Mid()

Component reference » Function reference » Text » Mid()

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…

Copy files out of SharePoint to FileShare

Documentation » Use Cases » Copy files out of SharePoint to FileShare

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…

Release Cycle

Roadmap » Release Cycle

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…

SharePointSiteTempalte

Component reference » Function reference » SharePoint » SharePointSiteTempalte

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

Fill()

Component reference » Function reference » Text » Fill()

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…

If()

Component reference » Function reference » Logical » If()

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…

Round()

Component reference » Function reference » Numeric » Round()

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…

Right()

Component reference » Function reference » Text » Right()

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…

Asc()

Component reference » Function reference » Text » Asc()

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…

Truncate()

Component reference » Function reference » Numeric » Truncate()

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

DateTime()

Component reference » Function reference » Date & Time » DateTime()

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…

Time()

Component reference » Function reference » Date & Time » Time()

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…

Year()

Component reference » Function reference » Date & Time » Year()

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…

Replace()

Component reference » Function reference » Text » Replace()

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…

SharePointSourceURL

Component reference » Function reference » SharePoint » SharePointSourceURL

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…

Case()

Component reference » Function reference » Logical » Case()

Function reference Tests the values of a column or expression and returns values based on the results of the test. Case ( column WHEN value1 THEN result1 { WHEN value2 THEN result2 { … } } { ELSE resultelse } ) Argument Description …

SharePointTargetURL

Component reference » Function reference » SharePoint » SharePointTargetURL

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…

Conditionally copy files or folders to different SharePoint sites

Documentation » Use Cases » Conditionally copy files or folders to different SharePoint sites

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…

Next version

Roadmap » Next version

Module Type Features committed for version 6.13 – January 2018 DataTransport New SharePoint: Convert List Items with attachments into Document Libraries Items. Attachment becomes the file in the Document Library…

Copy data from database to database

Documentation » FAQ & How to » Copy data from database to database

The Data Transport component can Insert/Update/Delete data between different data sources. Data sources include SharePoint Databases Excel files Text files Third -party drivers In this example I…

Data Driven Automation Enviroment

Documentation » Use Cases » Data Driven Automation Enviroment

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…

String()

Component reference » Function reference » Text » String()

Function reference Converts data to a string formated according to a specified format mask. You can convert and format date, DateTime, numeric, and time data. String ( data {, format } ) Argument Description data The data you want…

RunProgram()

Component reference » Function reference » Miscellaneous » RunProgram()

Function reference Runs an external program and wait for it to complete. A return value can optionally be communicated using a dynamically generated Registry Key. RunProgram ( ‘Exe ‘ , ‘Argument’ , ‘Timeout’ , …

Match()

Component reference » Function reference » Text » Match()

Function reference Determines whether a string’s value contains a particular pattern of characters. Match ( string, textpattern ) Argument Description string The string in which you want to look for a pattern of characters …