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

PowerShell Documentation

PowerShell Documentation

Call PowerShell from within Fusion

PowerShell Code Snippets

PowerShell Documentation » Run PowerShell from Fusion » Fusion PowerShell Commands » PowerShell Code Snippets

Get Site Title and write it to the Fusion Job Log $web = Get-PnPWeb Add-xJobLog -LogType "Information" -Message $web.Title Add-xJobLog -LogType "Information" -Message "Take a break :-)" Start-Sleep -Seconds 10 Add-xJobLog -LogType "Information" -Message…

Fusion PowerShell Commands

PowerShell Documentation » Run PowerShell from Fusion » Fusion PowerShell Commands

PowerShell cmdlets Description Get-xParameter Read the value from a Fusion Parameter INTO a PowerShell variable. Set-xParameter Assign a Fusion Parameter the value FROM a PowerShell variable. Add-xJobLog Add a…

Run PowerShell from Fusion

PowerShell Documentation » 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…

SharePoint PnP PowerShell Resources

PowerShell Documentation » SharePoint PnP PowerShell Resources

Requirements PowerShell ExecutionPolicy set to Unrestricted and the PnP cmdlets installed Start ISE or PowerShell.exe as administrator and run the following Commands. Set-ExecutionPolicy -ExecutionPolicy Unrestricted Install-Module SharePointPnPPowerShellOnline *…

External automation from PowerShell

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…

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

Component Override Parameters

Component reference » Parameters » Component Override Parameters

Parameters that dynamically override Component properties at runtime. DataTransport Override Parameters Values FileTransport Override Parameters Values Show OVR_SubFolders Yes/True/1 No/False/0 …

Run a component in batch

Fusion Control Panel » 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…

For Each Row – Run Component

Component reference » Data Transport » For Each Row – Run 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…

Job Monitor

Fusion Control Panel » 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…

Add-xJobLog

PowerShell Documentation » Run PowerShell from Fusion » Fusion PowerShell Commands » Add-xJobLog

Add-xJobLog -LogType “String” -Message “String” Add a message to the Fusion Job Log. The command works asynchronously so you can use the Fusion Job Log to monitor the progress of your script as it executes. -LogType Argument…

SharePoint PnP Provisioning

PowerShell Documentation » SharePoint PnP Provisioning

Site/List/Library provisioning made easy! - With optional immediate file & data upload. Effectively enabling you to do all the steps involved in provisioning of complete SharePoint Sites or individual Lists/Libraries and transfer files/data without complex and…

Collection

Component reference » Collection

Work with multiple Components and integrate PowerShell/SQL Combine multiple Components into one job Set conditions for Component calls Call PowerShell and execute SQL with parameters Collection Components can contain other Collection Components Use the…

New Collection

In-app help » new componnet dialog box » New Collection

Automation: Combine multiple Components and integrate PowerShell/SQL Group components into composite parameterized jobs Set conditions for Component calls Run PowerShell and SQL with parameters Use nested calls to other…

Changelog

Roadmap » Changelog

Download Fusion 12.05 Generally Available here.. Module Type Version 12.05 August 16, 2021 SharePoint Enhancement Emoji support (❤️, copy paste emoji ). Item properties, including file and folder names can now contain Emojis. You…

Data Driven Automation Enviroment

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…

Master Data Management

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…

Whats new

Roadmap » Whats new

Download Fusion 12.21 Generally Available here.. Module Type Version 12.21 July 1, 2022 SharePoint Enhancement Emoji support (❤️, copy paste emoji ). Item properties, including file and folder names can now contain Emojis. You can…

Run Excel from Job Server Service

Fusion Control Panel » Job Monitor » Job Server » Run Excel from Job Server Service

When running Excel jobs from the Job Server installed as a Windows Service you might run into different errors where Excel cannot function. The issue is a limitation imposed by Microsoft and it is not specific to Fusion. This applies to any program type including c#,…

Legacy ECM data to SharePoint

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…

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…

Use Cases

Use Cases

ProductLogo SAVE TIME – GET DATA & FILES MOVING! With 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…

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…

Data Movement – in & out of SharePoint

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…

Get-xParameter

PowerShell Documentation » Run PowerShell from Fusion » Fusion PowerShell Commands » Get-xParameter

Get-xParameter -Name “String” Get the value from a Fusion Parameter and assign it to a PowerShell variable. *Passwords: Notice that the Cmdlet writes the retrieved value to the Console when running in PowerShell ISE but not for Parameters of type…

Add/Update SharePoint List Items from external data source

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…

Replicate/Migrate FileShare to SharePoint Library at high speed

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…

Set-xParameter

PowerShell Documentation » Run PowerShell from Fusion » Fusion PowerShell Commands » Set-xParameter

Set-xParameter -Name “String” -Value “String” Transfer/assign the value from a PowerShell variable to a Fusion Parameter *Parameters of type Password cannot be assigned. Example: Set-xParameter -Name "[]" -Value $MyVariable

Connetct-PnPOnline

PowerShell Documentation » Run PowerShell from Fusion » Fusion PowerShell Commands » Connetct-PnPOnline

ConnectPnPOnline using a Fusion SharePoint Connection Fusion generates the script to retrieve the authentication information from a SharePoint Connection and constructs the ConnectPnPOnline command accordingly. *Microsoft Documentation: …

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…

Business Logic and Application examples

Business Logic and Application examples

Data Driven Automation – No Coding required. FileShares and SharePoint Document Libraries (Interactive, Scheduled or Test-Run) FileShare migration/replication to SharePoint at high speed. Incremental/full. Folders 1:1 or flattening…

Delete items or documents from SharePoint

Use Cases » Delete items or documents from SharePoint

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

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…

Connectors to ERP/CRM and Databases

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…

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

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

CSV Importer/Exporter with powerful filters

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…

New Componnet

In-app help » new componnet dialog box » New Componnet

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

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…

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…

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…

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…

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

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

Update List Item or Document metadata while keeping [Modified] & [Modified By]

FAQ & How to » Update List Item or Document metadata while keeping [Modified] & [Modified By]

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

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 …

Run with Multitasking

Component reference » Run with Multitasking

You can run any component as a separate task. The job then runs in it’s own thread while you can continue doing other stuff. The Job Log can run simultaneously for monitoring the job. Please note that Parameter values from the current FusionFullName session is…

Copy data from database to database

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 Transport

Component reference » Data Transport

h3.Work with SharePoint List & Library Items and data from CSV, Database and Excel Excel Perform actions bidirectionally : • Read • Create • Update • Delete/Recycle • Looping (For-Each .. do this and that) Read/Write data bidirectionally : •…

New File Transport

In-app help » new componnet dialog box » New File Transport

High Performance File and metadata Migration to/from/within SharePoint and FileShares File actions in any direction with Automation (features) Copy, Move, Delete, Recycle, Print, E-Mail Synchronize (1-way or 2-way) Enrich…

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

File Transport

Component reference » File Transport

Work with files and their metadata in SharePoint, FileShares or FTP Synchronize (1-way or 2-way) Copy Move Delete/Recycle Print Actions in any combination of From/To Supported file systems: Windows File Share SharePoint Document…

Copy files out of SharePoint to FileShare

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…

Query SharePoint List and export to Excel report

Component reference » Data Transport » DataTransport Video » Query SharePoint List and export to Excel report

Setting up your Source and Target. (Chapter 1/2) Chapter 2 – Running your Component. The DataTransport Componet Video Library

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…

Job Server

Fusion Control Panel » Job Monitor » Job Server

The Fusion Job Server can run components as scheduled Jobs. The Job Server is installed automatically and uses the same repository configuration settings as the Fusion client program. Job administration and monitoring is done remotely from the Job Monitor module in…

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…

Bulk Update SharePoint Items

FAQ & How to » Bulk Update SharePoint Items

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

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…

New Data Transport

In-app help » new componnet dialog box » New Data Transport

High performance data migration to/from/within SharePoint, Excel, CSV and Databases Actions on List & Library items with Automation (Features) Create new SharePoint List from Excel, CSV, SQL, other SharePoint List. Then Sync data Read,…

Installation

Miscellaneous » Installation

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

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…

Conditionally copy files or folders to different SharePoint sites

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…

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 2012 or later (Server and Express) Built-in *The repository can be migrated…

Create database table from List

Use Cases » Create database table from List

Create & maintain database table without SQL scripting No-Code Solution – In Only 3 Easy Steps Supported Drivers and Connectors STEP 1 Create a DataTransport Component and select Source & Target STEP 2 I selected SharePoint as Source and have choose a…

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…

DataTransport E-Mail

Component reference » Data Transport » DataTransport E-Mail

This Data Transport Target sends E-Mails Merge variables Any data Source can be used as merge variables mixed with Fusion Parameters. Merge variables can be calculated and mix data Source columns with parameters in the calculations. Any part of the E-Mail can contain…

SharePoint Document Set

Component reference » File Transport » SharePoint Document Set

Working with Document Sets using FileTransport and DataTransport SharePoint Document Set is basically a “Special Folder” having multiple columns for metadata that applies to all files within the Set. The metadata columns available are defined by the…

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…