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

PowerShell

PowerShell

Call PowerShell from within Fusion Call Fusion Components from PowerShell

Run PowerShell from Fusion

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…

PowerShell configuration tips

PowerShell » PowerShell configuration tips

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…

External automation from PowerShell

Why Ontolica Fusion » 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 Component from PowerShell

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…

PowerShell Command Reference

PowerShell » PowerShell Command Reference

Get-xParameter Set-xParameter Add-xJobLog Set-xReturn New-SharePointSite New-SharePointContext Get-SharePointSiteTemplates

PnP Provisioning Engine for PowerShell

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

Data Movement – in & out of SharePoint

Why Ontolica Fusion » 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…

Copy files out of SharePoint to FileShare

Why Ontolica Fusion » 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…

Flat Migration of FileShares to SharePoint (eliminating folders)

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

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

Why Ontolica Fusion » 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.) …

I’m SharePoint Administrator

Introduction » I’m SharePoint Administrator

Tired of endless lines of PowerShell to get your data and files moving? and what are the implications of long PowerShell scripts? With Ontolica Fusion you can significantly reduce the economic investment as well as risk and complexity of PowerShell development for…

Profound Difference in Productivity!

Why Ontolica Fusion » Profound Difference in Productivity!

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…

I’m SharePoint Project Manager

Introduction » I’m SharePoint Project Manager

How can we create applications for SharePoint and deliver on-time? With Ontolica Fusion you can significantly reduce the economic investment as well as risk and complexity of PowerShell development for SharePoint. SharePoint on-premises and in Office 365 goes…

I’m SharePoint PowerUser

Introduction » I’m SharePoint PowerUser

What is a user friendly way to automated tasks without running PowerShell scripts? With Ontolica Fusion you can significantly reduce the economic investment as well as risk and complexity of PowerShell development for SharePoint. Development and utilization of…

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…

Batch job monitor

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…

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…

I’m SharePoint Developer

Introduction » I’m SharePoint Developer

Article is under review and is incomplete. Trivial coding made easy First of all – no ties – you do not get locked up! You can interface and leverage existing PowerShell code. Your gain among othe things is thar you get rid og the…

Why Ontolica Fusion

Why Ontolica Fusion

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…

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…

Delete items or documents from SharePoint

Why Ontolica Fusion » 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…

Legacy ECM data to SharePoint

Why Ontolica Fusion » 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…

Site Provisioning Create/Update/Delete Sites in BULK.

Why Ontolica Fusion » 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…

Connectors to ERP/CRM and Databases

Why Ontolica Fusion » 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…

Get the job done – Fast and efficient

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

Change Log v5.69

What’s new – August 2017 » Change Log v5.69

Module Type Version 5.70 Database Enhancement When you save a Database Connections then a local 32 bit ODBC Data Source is created with the same name and connection parameters as used by Fusion. This makes it much easier to create…

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…

Add/Update SharePoint List Items from external data source

Why Ontolica Fusion » 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…

Ontolica Fusion Roadmap (08-08-2017)

Miscellaneous » Ontolica Fusion Roadmap (08-08-2017)

*Next version. Please note that Ontolica Fusion Roadmap features and dates are subject to change without notice. Module Type Status Features committed for version 6.0 – September 2017 CtrlSync New In Progress …

Master Data Management

Why Ontolica Fusion » 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…

Business Logic and Application examples

Why Ontolica Fusion » 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…

CSV Importer/Exporter with powerful filters

Why Ontolica Fusion » 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…

Welcome to Fusion – Easy Automation For SharePoint

What’s new – July 2017 » 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…

Data Driven Automation Enviroment

Why Ontolica Fusion » 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…

Replicate/Migrate FileShare to SharePoint Library at high speed

Why Ontolica Fusion » Replicate/Migrate FileShare to SharePoint Library at high speed

. With Bidirectional support you can also copy files from SharePoint to FileShares as well. Folders can be copied 1:1 or created from metadata. Source (your FileShare) and target (your SharePoint Library) is specified in the File Transport component transport}. You…

What’s new – August 2017

What’s new – August 2017

Module News in August 2017 – See the Change Log here… Database When you save a Database Connections then a local 32 bit ODBC Data Source is created with the same name and connection parameters as used by Fusion. This makes it…

Error: The operation has timed out

FAQ & How to » Error conditions… » Error: The operation has timed out

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…

CtrlSync for SharePoint

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…

SharePoint column types and data validation

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…

Fusion overview

Video library » Fusion overview

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

For Each Row – Excecute Component

Component reference » Data Transport » For Each Row – Excecute Component

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…

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…

Server Side Excel

Fusion Control Panel » Batch job monitor » Batch Server » Server Side Excel

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…

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

Function reference

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…

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…

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…

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…

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…

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…

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…

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…

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…

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…

other resources

Miscellaneous » other resources

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…

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…

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…

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…

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…

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

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…

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

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…

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 …

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…

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…

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…

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…

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…

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…

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…

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

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

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…

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 Thai (limited) *Want to know more about the ONTOLICA Support & Service Program

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

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

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…

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…

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…

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…

Video library

Video library

Category Description File Transport Migration of FileShare to SharePoint (folders 1:1) File Transport Flat Migration of FileShare to SharePoint (eliminating folders) File Transport Copy files from SharePoint to…

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 date A date value n An integer indicating the number of…

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…

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…

Collection

Component reference » Collection

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…

What is XRM

Why Ontolica Fusion » What is XRM

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…

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…

File/Folder selection filter

Component reference » File Transport » File/Folder selection filter

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…

Replace file content on during upload to SharePoint

FAQ & How to » Replace file content on during upload to SharePoint

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…

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

File Transport

Component reference » File Transport

Perform the following file operations: Copy, Move (Source and Target defines from where to where) Delete Supported file systems: Windows File Share SharePoint Document Library Rename a file before upload to SharePoint Assigning SharePoint…

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…

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…

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

Permissions

CtrlSync for SharePoint » Permissions

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…

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…

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…

Test run

Component reference » File Transport » Test run

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…

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…

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…

CtrlSync Licensing

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…

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 date A date value n An integer indicating the number of…

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 datetime A datetime value n A long number of seconds…

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 …

Run Job Server as Windows Service

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

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…

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…

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…

CtrlSync Setup 2-4

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

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…

Dynamically skipping a column from being updated

Component reference » File Transport » Assigning SharePoint metadata » Dynamically skipping a column from being updated

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…

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…

Parameters

Component reference » Parameters

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…

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…

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…

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

Welcome

Fusion Control Panel » System Configuration » Welcome

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…

SharePoint connections

Fusion Control Panel » SharePoint connections

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…

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

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…

CtrlSync and OneDrive for Business

CtrlSync for SharePoint » CtrlSync and OneDrive for Business

*CtrlSync does Automatic File Distribution from SharePoint. It is 100% Centrally Managed and Controlled. Files are automatically downloaded to, or uploaded from the users PC. CtrlSync works with Office 365, SharePoint 2010, 2013, 2016. !The key difference: OneDrive…

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…

Date and Time calculation

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

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…

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

Login completed

Fusion Control Panel » System Configuration » Login completed

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

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…

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 …

Advanced configuration settings

Miscellaneous » Installation » Advanced configuration settings

The file dialog.ini defines the different program settings. In the [Profile] section the following configuration parameters are valid. Description ServerShutdownTerminateJobs=0 When the Batch Server is restarted any running Jobs wil not be…

Leave file in “Checked Out” status after upload to SharePoint

Component reference » File Transport » Leave file in “Checked Out” status after upload to SharePoint

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…

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…

CtrlSync – Login

Fusion Control Panel » System Configuration » CtrlSync – Login

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…

Data Transport

Component reference » Data Transport

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…

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…

Features

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…

CtrlSync Setup 4-4

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

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…

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…

Connect SharePoint to the enterprise

Video library » Connect SharePoint to the enterprise

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…

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…

Error retrieving Items: [11004] Valid name, no data record (Check DNS setup)

FAQ & How to » Error conditions… » Error retrieving Items: [11004] Valid name, no data record (Check DNS setup)

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…

Dynamically skipping individual files from beeing uploaded

Component reference » File Transport » Dynamically skipping individual files from beeing uploaded

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…

Dynamic FileTransport Target

Component reference » File Transport » Dynamic FileTransport URL/UNC » Dynamic FileTransport Target

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…

Job log viewer

Component reference » Job log viewer

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…

System requirements

Miscellaneous » System requirements

Screen resolution of minimum 1280 × 700 Software requirements Version Microsoft .Net Framework 4.5.x Microsoft .Net Framework 3.5.x Download link to .Net 4.5 is here Minimum hardware…

Renameing files

Component reference » File Transport » Renameing files

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…

Subscription Management

CtrlSync for SharePoint » Subscription Management

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…

Create Site – Redirect URL

Component reference » File Transport » Dynamic FileTransport URL/UNC » Create Site – Redirect URL

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

Assigning SharePoint metadata

Component reference » File Transport » Assigning SharePoint metadata

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

Applications

CtrlSync for SharePoint » Applications

Central Management of automatic file distribution - No user interaction required Make sure updated task relevant files are consolidated and made available in folders on users computers/devices for easy access (also offline). Users no longer…

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…

CtrlSync and Nintex Workflows

CtrlSync for SharePoint » Tips & FAQ » CtrlSync and Nintex Workflows

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…

Query any SharePoint List & Library

Why Ontolica Fusion » Query any SharePoint List & Library

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…

Excel Workbook – Refresh/Push/Pull

Why Ontolica Fusion » Excel Workbook – Refresh/Push/Pull

BULK Generate Client specific Excel reports and Push to individual shared folders. Table & Named Cell Retrieval/Update. (Bidirectional) Use existing workbooks or new-from-template with dynamic “Save As”. Refresh Data Tables. Push data sets or single…

Excel BULK generator

Why Ontolica Fusion » Excel BULK generator

BULK Generate Client specific Excel Reports and push to individual Sites Use existing workbooks or new-from-template with dynamic “Save As”. Refresh Data Tables. Push data sets or single values. Iterate same workbook and perform multiple operations as 1…

Components

Fusion Control Panel » Components

“Task Configurations” saved within the repository database. Examples of component use: Conditionally migrate/synchronize FileShares to SharePoint (with folders or flattened) Replicate files, Items/records conditionally and…

3 ways to acquire

What is Ontolica Fusion » Pricing & Delivery » 3 ways to acquire

We offer 3 ways to acquire Ontolica Fusion – Subscription, normal Purchase or buy Perpetual We can help you find the best investment plan SUBSCRIPTION Software Assurance (SA) are mandatory and are included Link:…

Conditionally copy files or folders to different SharePoint sites

Why Ontolica Fusion » 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…

Deployment

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…