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

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…

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…

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…

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…

Null values returned form a database

FAQ & How to » Null values returned form a database

Fusion automatically handles NULL values returned from a database. If you want to do custom logic based on NULL values here is an example. if([data] = ‘null’, ‘My custom data’, [data]) The above statement will return My custom data if the…

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…

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…

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…

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

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…

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…

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…

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

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…

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…

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…

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…

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

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…

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…

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…

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…

What is XRM

Use Cases » 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…

Blank – No Components

In-app help » Blank – No Components

New Repository with no pre-configured setup. The Repository is the database where all Components, Parameters, Logs and Master Data is stored. The Repository database is by default a local Firebird database However you can quickly (2 clicks) migrate the Repository to…

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…

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…

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…

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

Import

In-app help » new componnet dialog box » Import

Import data from any data source into the Repository database Populate Search & Replace lists used in calculations Load data into the Repository Master Data Management table structure

Import

Component reference » Import

Import data from any data source into the Repository database Populate Search & Replace lists used in calculations Load data into the Repository Master Data Management table structure

Azure SQL Server connection

Fusion Control Panel » Database connections » Azure SQL Server connection

Configure a database connection to SQL Server in Microsoft Azure. A little tricky syntax SQL Server needs, but simple once you know how.

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

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…

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…

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…

Office 365 “Service Applications”

No-Code Service Application Framework » Office 365 “Service Applications”

Say HELLO to No-Code O365 “Service Applications” running unattended client-side on any machine locally or in your private cloud. Design your own “No-Code O365 Service Applications” in the most powerful framework ever created for SharePoint and data…

System requirements

Sales information » System requirements

Performance is greatly dependent on available Memory & CPU power Microsoft .Net Framework requirements .Net Framework 4.6.2 .Net Framework 3.5.x for access to SharePoint 2010 Minimum hardware requirements Monitor: Screen resolution of minimum 1280 ×…

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…

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…

Excel Workbook – Refresh/Push/Pull

Use Cases » 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

Use Cases » 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…

Query any SharePoint List & Library

Use Cases » 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…

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…

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…