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

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…

Component reference

Component reference

FileTransport for copying/moving files. DataTransport for interacting with SharePoint Items and database rows. Collection for combining multiple components into a composite job etc

Parameters in File Transport

Component reference » Parameters » Parameters in File Transport

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

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…

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…

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…

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…

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…

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…

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…

Error: Access to the path ‘xyz’ is is denied.

FAQ & How to » Error conditions… » Error: Access to the path ‘xyz’ is is denied.

If you get the error Access to the path ‘xyz’ is is denied. during file copy from a File Share then check that you have the proper rights to access the files. Google c# Access to the path for details.

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…

Database connections

Fusion Control Panel » Database connections

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

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

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

Change Log v5.85 (November 3 – 2017)

What’s new – November 2017 » Change Log v5.85 (November 3 – 2017)

Module Type Version 5.85 – See the RoadMap for next release here FileTransport Enhancement Dynamic SharePoint source/target site functionality optimized for large number of iterations to enable dynamic distribution of files…

Include/Exclude files and folders

Component reference » File Transport » Include/Exclude files and folders

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

Links to external articles

FAQ & How to » Links to external articles

External links *WeTransfer: Quick and easy file transfer service. SharePoint Server 2010 capacity management: Software boundaries and limits Plan for performance and capacity management in SharePoint Server 2013 Firebird database reference Firebird database…

FAQ & How to

FAQ & How to

Include/Exclude files and folders Rename a file before it is uploaded to SharePoint Replace the actual file content during upload Empty all items from SharePoint Recycle Bin Document Library Performance tip Copy data from database to database Dynamically skipping…

Payment Method

What is Ontolica Fusion » Pricing & Delivery » Payment Method

Supported payment method ONLINE SHOP 24/7 – ONLY for Ontolica Fusion Subscription License Link: http://sites.fastspring.com/surfray/product/ontolicafusion Master Card Visa Amex Discover PayPal FINANCE – PURCHASE ORDER PROCESS (POP) Surfray US…

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…

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

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

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…

Include files created > 24 hours ago

FAQ & How to » Include files created > 24 hours ago

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

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…

Repository

Miscellaneous » Repository

The repository stores all configuration data including. Component configurations and user preferences Job logs Data Management data Supported repository database platforms: MS SQL 2005, 2008, 2012, 2014 (Server and Express) FireBird 2.53 (Default single…

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…

Libraries with version history

Component reference » File Transport » Libraries with version history

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

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…

GoalWare – Italy

Introduction » Reviews » GoalWare – Italy

Ontolica Fusion Review “This unique application allows you to tackle any project knowing that with this ‘Swiss’ boxcutter of information technology, you can create a lot of solutions: Latest project migrated 350,000 documents from Oracle DB, file…

CtrlSync Setup 3-4

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

List installation Complete CtrlSync management lists have been successfully created. You are now ready to add Subscription List Items and start syncing files. Minimum user Permissions to the Management Lists Subscription Management *File Subscriptions are…

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…

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…

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

Feature Comparison Sheet

Feature Comparison Sheet

Features included in Editions: Free Standard Query Databases , Excel files, CSV and SharePoint Lists & Libraries X X Excel Push/Pull reporting and automation, For-Each-Row loop , Parameters X X Run…

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…

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

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…

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…

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…

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…

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…

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…

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…

Centralized Error Handling

CtrlSync for SharePoint » Tips » Centralized Error Handling

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

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…

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…

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…

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…

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…

WorkPoint 365 / on-prem

Supported 3 party products » WorkPoint 365 / on-prem

Ontolica Fusion with WorkPoint Greatly reduce resources and cost for WorkPoint implementations You will be running before you know it No need of coding (no-code solution) Adaptable Temples Dedicated Connector High-speed file transfer Easy set-up Migration…

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…

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…

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…

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…

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…

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…

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…

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…

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. Parameter Description ServerShutdownTerminateJobs When the Batch Server is restarted any running Jobs will…

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…

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…

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

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…

I’m SharePoint Developer

Introduction » Bennefits » 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…

What’s new – November 2017

What’s new – November 2017

Module News in November 2017 – See the Change Log here and the RoadMap here FileTransport Dynamic SharePoint source/target site functionality optimized for large number of iterations to enable dynamic distribution of files across…

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…

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…

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…

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…

I’m SharePoint PowerUser

Introduction » Bennefits » 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…

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…

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…

I’m SharePoint Consultant

Introduction » Bennefits » 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…

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…

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…

I’m SharePoint Admin/Analyst

Introduction » Bennefits » 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…

Replicate/Migrate FileShare to SharePoint Library at high speed

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

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