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

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…

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

PowerShell Documentation

PowerShell Documentation

Call PowerShell from within Fusion

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…

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…

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…

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…

Changelog

Roadmap » Changelog

Download Fusion 11.27 Generally Available here.. Module Type Version 11.27 June 1,2020 FileTransport Enhancement SharePoint Document Library located in ../Lists Using a Dynamic URL (like in Self Service) Fusion now supports any URL for…

Sync for Clients & Employees

Miscellaneous » Citrix ShareFile and Fusion » Sync for Clients & Employees

“Sync Window” pops up when you click on the Fusion System tray Icon.

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…

Check for Updates/New version

FAQ & How to » Check for Updates/New version

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

Considerations for using Web Login

Fusion Control Panel » Considerations for using Web Login

When using the Web Login Fusion retrieves the connection to SharePoint from your browser session. Advantages: Simple and secure and the only choice for users configured for MFA and not having access to an AppId Support for Multi Factor Authentication (MFA) Support…

For security reasons DTD is prohibited in this XML document

For security reasons DTD is prohibited in this XML document

Network issue when connecting to SharePoint Online. Error; For security reasons DTD is prohibited in this XML document. To enable DTD processing set the DtdProcessing property on XmlReaderSettings to Parse and pass the settings into XmlReader.Create method. The…

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…

Fusion Premium

Fusion Premium

edition feature matrix FREE Fusion DataTransport Migrate SharePoint List items with transformation DataTransport Import or sync data to SharePoint List from Excel,CSV, SQL DataTransport…

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…

Whats new

Roadmap » Whats new

Download Fusion 11.27 Generally Available here.. Module Type Version 11.27 June 1,2020 FileTransport Enhancement SharePoint Document Library located in ../Lists Using a Dynamic URL (like in Self Service) Fusion now supports any URL for…

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…

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…

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…

Fusion Feature List

Fusion Feature List

ONE-STOP FREE TOOL for getting data IN/OUT and AROUND SharePoint Visual and interactive jobs with previewing of what is going to happen. Perform test-runs to analyze outcome before committing changes Automate tasks with parameters. Run one-off jobs or scheduled on…

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…

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

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…

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…

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…

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

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

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…

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…

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…

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…

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

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…

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…

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…

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…

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

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…

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

System Parameters

Component reference » Parameters » System Parameters

[] Returns all column Warnings for each SharePoint Item Updated/Created.

Diagnostics

Miscellaneous » Diagnostics

Activating Diagnostics can help troubleshooting error conditions. This feature is mostly for support cases

Next version

Roadmap » Next version

Features implemented for next GA release July 2020 Module Type Version 11.27 July 2020

Pause()

Component reference » Function reference » Miscellaneous » Pause()

Function reference Pause program execution for the specified number of seconds. Pause( ‘seconds’ ) Argument Description seconds The number of seconds to pause. (suspend execution) Example 1 This example will pause for 5…

GetJobSessionComponentID()

Component reference » Function reference » Miscellaneous » GetJobSessionComponentID()

Function reference Returns the id for the current top-level component. GetJobSessionComponentID() Example 1 This example will output the id for the top-level component in the current session to the debug window. Debug( GetJobSessionComponentID()…

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

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

DataValidationWarnings

Component reference » Parameters » System Parameters » DataValidationWarnings

The System Parameter [] returns all column Warnings for each SharePoint Item Updated/Created. Use this Parameter to assign a List Column of choice for data quality analysis and bad data findability. The information returned includes: Unresolved Content…

SharePoint retrieve only distinct Items

Component reference » Data Transport » SharePoint retrieve only distinct Items

You can specify to retrieve only 1 Item for each distinct value based on 1 column or all columns Notice that you can use the Sort option below, so that the distinct value chosen is based on the sort order. This is useful when the sorted columns have multiple values…

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…

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…

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…

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

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.

Custom Repository

In-app help » Custom Repository

Install a Custom Repository pre-configured for specific tasks. Select or download the custom Repository .XDS file to install. *You can crate your own template simply by creating a backup of your Repository to an .XDS file

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…

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…

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…

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

Fusion random crash “BEX”

FAQ & How to » Fusion random crash “BEX”

On some systems Fusion can crash with a Windows “BEX” error This problem is registered on Windows Server 2008 The solution can be to run Fusion in compatibility mode with Windows 7 Procedure: In the Fusion program folder: (C:\Program Files…

Release Cycle

Roadmap » Release Cycle

There are five stages used in our release cycle. These necessary phases are essential to the overall goal of putting the most stable & solid software products on the market. Release Cycle 1 Alpha 2 Beta 3…

SharePoint connections

Fusion Control Panel » SharePoint connections

Connections stores URL, User/AppID for connecting to SharePoint Sites The connection caches Information about the site artifacts like Lists & Libraries. This information is used for setting up column mappings etc. Important about Office 365 – Microsoft…

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

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…

MS Flow – Notification

In-app help » MS Flow – Notification

Optional. Skip this step if you don’t want to use Microsoft PowerAutomate for Job Notification Users can get notified on job start and completion by installing the per-packaged Microsoft Flow template. The flow is invoked if the Migration Job signals a warning…

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…

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…

Introduction & Specifications

Self Service File Migration & Sync » Introduction & Specifications

Use SharePoint List to configure and schedule File Migration & Sync Jobs Empowering Users and Workflows to run recurring or onetime File Migration & Sync jobs Just create a simple SharePoint List Item for each job – That’s it! Production ready in 15…

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…

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…

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…

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…

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 …

2 Factor authentication not supported

Fusion Control Panel » 2 Factor authentication not supported

SharePoint Online limitation Multi-Factor-Authentication cannot work when using classic authentication to SharePoint (user name and password) In Fusion, you can instead use Web Login. Microsoft recommends to use AppID/AppSecret authentication at all times for high…

LogMessage()

Component reference » Function reference » Collection » LogMessage()

Function reference Add a message to the Job log for the current Collection. LogMessage( ‘message’ ) Argument Description message The message to add to the Job Log. You can optionally prefix the message with subject (max 20…

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…

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

Contact us

Contact us

WORLDWIDE SUPPORT & SERVICE CENTER How can we help you? Here you can request support on your Issue LANGUAGE: English Spanish Danish For your safety and our records, any financial or cancellation inquiries and issues, have to be submitted to our Support and…

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…

Self Service File Migration & Sync

Self Service File Migration & Sync

Solution Template for Fusion 8.31 and above above Use SharePoint List to configure and schedule FileTransport components to do File Migration & Sync. *How it is designed. A DataTransport component download SharePoint List Items and for each item map the column…

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…

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…

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…

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

Welcome

In-app help » Welcome

Fusion have been upgraded. Description for: FusionDrive You can continue to use your existing Repository or choose to install an additional. Having multiple Repositories enables you to separate different projects from each other. Using the Version Control feature…

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…

Your great ideas

Roadmap » Your great ideas

We really appreciate your input and ideas THANKS, to all who have lifted our product by sharing with us Your issue reporting will get our highest priority Your input can easily be our next enhancement Your ideas could change our Roadmap for the future Please…

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…

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…

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…

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

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…

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…

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…

How to create Office 365 AppID

Fusion Control Panel » How to create Office 365 AppID

Here are some helpful links for creating an Office 365 AppID How to create an Office 365 AppID (Microsoft article) Recommended “App’s permission Request XML” You can define your own “App’s permission Request…

File Migration & Sync

In-app help » File Migration & Sync

Use SharePoint List to configure and schedule File Migration & Sync Jobs Empowering Users and Workflows to run recurring or onetime File Migration & Sync jobs Just create a simple SharePoint List Item for each job – That’s it! Production ready in 15…

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…

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…

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…

LogError()

Component reference » Function reference » Collection » LogError()

Function reference Signal an error and add an error message to the Job log for the current Collection. LogError( ‘message’ ) Argument Description message The error message to add to the Job log. You can optionally prefix the…

Tuning SharePoint on-prem file upload

Component reference » File Transport » Tuning SharePoint on-prem file upload

Microsoft recommendation for best performance: When uploading large number of files or high volume, the best performance is accomplished outside normal business hours (night time or weekends). SharePoint On-Premises Fusion is using “CSOM API” in all…

Document Libaray Performance tip (O365, 2013)

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

Office 365 & SharePoint 2013 – Disabling the ‘Following Content’ Feature SPO sites (but not site collections), have a feature called: ‘Following Content’ This feature is enabled by default when a new site is created. When it is disabled, performance may…

LogWarning()

Component reference » Function reference » Collection » LogWarning()

Function reference Add a warning message to the Job log for the current Collection. LogWarning( ‘message’ ) Argument Description message The warning message to add to the Job Log. You can optionally prefix the message with …

Configuration

In-app help » Configuration

Configure FusionDrive Step Action (see screenshot below) 1. Identify the SharePoint Site you want to use as your Subscription Management Site. Edit the connection properties to point to that site. You can use any site including a regular…

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…

SharePoint Query (CAML)

FAQ & How to » SharePoint Query (CAML)

When you run queries on Lists and Libraries there are a couple of rules to observe when to use index on columns. Index rules. The general rule is NOT to use index on any columns. Use index only when you want query a column in a large list…

Tuning SharePoint O365 performance

Component reference » File Transport » Tuning SharePoint O365 performance

Microsoft recommendations for best Office 365 performance: When uploading high volume of file content, the best performance is accomplished outside normal business hours (night time or weekends). Use AppID/Secret as the authentication model, NOT user accounts, when…

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…

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

Importing Lotus Notes Documents into SharePoint via AGECOM Export Utility

Use Cases » Importing Lotus Notes Documents into SharePoint via AGECOM Export Utility

Fusion imports Lotus Notes Documents including embedded files and attachments into SharePoint. Many vendors provide so called “Easy Notes migration tools”. But at the end of the day the result can seem nice but in a real world SharePoint production…

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…

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…

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…

Apply O365 Retention Label

Component reference » Data Transport » Apply O365 Retention Label

DataTransport can apply “Retention Labels” to List & Library Items Retention labels are basically polices that you apply to List and Library Items to define when and on what conditions they are deleted or archived. Microsoft docs: Overview of retention…

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…

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…

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…

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…

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…

Migrating SharePoint BLOG Site

FAQ & How to » Migrating SharePoint BLOG Site

Fusion can not migrate a BLOG site directly from one Site to another in one go. However you can migrate most of the content step by step . Follow these steps: Copy the files in the Document Libraries. Make a note of the relative URL’s for…

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…

SharePoint Lookup Columns

Component reference » SharePoint Lookup Columns

Fusion supports reading and updating Lookup columns. Updating Lookup columns The Item Label value can be assigned to the column directly. I will trigger a lookup in the linked List to retrieve the physical ID that in turn is applied to the column. A report is stored…

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…

Fusion and Microsoft Teams

Fusion and Microsoft Teams

Fusion can work with all standard or custom SharePoint Lists & Libraries associated with any given Microsoft Team For example this means that Fusion can do conditional migration or do 1-way or 2-way synchronization of documents to/from any associated Document Library…

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…

PDF conversion

Component reference » File Transport » PDF conversion

Convert files into PDF when copied or moved using FileTransport All you have to do is to enable it! Supported Source/Target Copy/Move from FileShare to SharePoint Copy/Move from SharePoint to SharePoint Copy/Move from…

CtrlSync Setup 2-4

In-app help » 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…

Installation Package

In-app help » Installation Package

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

Dynamically preventing a SharePoint column from being assigned

Component reference » SharePoint specific functionlity » Dynamically preventing a SharePoint column from being assigned

SharePoint column assignments can be skipped on a per Item,per column basis. This is done by assigning the columns a special value returned by the below system functions in an expression. Note that the data type must match in your expression. This feature can be very…

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…

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…

Advanced configuration settings

Miscellaneous » Advanced configuration settings

The file dialog.ini defines the different program settings. In the [Profile] section the following configuration parameters are valid. Parameter Description Temp Point to a different TEMP folder. The default is…

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…

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…

CtrlSync Setup 4-4

In-app help » 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…

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 …