Fusion Documentation
Table of Contents
Fusion Documentation
Component reference
File Transport
Include/Exclude files and folders
Renameing files
Assigning SharePoint metadata
Office Custom Properties
Test run
File/Folder selection filter
Libraries with version history
Versioning & Approval
Document Libaray Performance tip (O365, 2013)
Dynamic FileTransport URL/UNC
Dynamic FileTransport Source
Dynamic FileTransport Target
PDF conversion
Tuning SharePoint O365 performance
Tuning SharePoint on-prem file upload
SharePoint Document Set
Data Transport
For Each Row – Run Component
SharePoint Subsites List
DataTransport E-Mail
SharePoint retrieve only distinct Items
Collection
Script before (Collection)
Script after (Collection)
Run external program (API)
Import
Run with Multitasking
SharePoint Lookup Columns
SharePoint column types and data validation
Job log viewer
Parameters
Parameters in File Transport
Component Override Parameters
System Parameters
DataValidationWarnings
Function reference
Logical
Case()
If()
IsNull()
Text
Asc()
Char()
CharNewLine()
CharTab()
Fill()
IndexValue()
LastPos()
Left()
LeftTrim()
Len()
Lower()
Match()
Mid()
Pos()
Replace()
ReplaceAll()
ReplaceTextInFile()
Right()
RightTrim()
Space()
String()
Trim()
Upper()
WordCap()
Date & Time
Date()
DateTime()
DateTimeToNumber
Day()
DayName()
DayNameLocal()
DayNumber()
DaysAfter()
FirstDayOfMonth()
FirstDayOfWeekISO()
FirstDayOfWeekUS()
Hour()
HoursAfter()
IsDate()
LastDayOfMonth()
LastDayOfWeekUS()
LastDayOfWeekISO()
Minute()
Month()
MonthsAfter()
MonthName()
MonthNameN()
Now()
RelativeDate()
RelativeDateTime()
RelativeTime()
RelativeMonth()
RelativeYear()
Second()
SecondsAfter()
Time()
Today()
Year()
YearsAfter()
WeekNumberISO()
WeekNumberUS()
Numeric
Dec()
IsNumber()
Mod()
Number()
Truncate()
Rand()
Round()
File
CreateFolder()
GetDirectory()
ReadFile
Collection
CallCollection()
Finish()
Skip()
LogMessage()
LogWarning()
LogError()
LogFile()
Miscellaneous
Output()
GetJobSessionComponentID()
GetJobSessionID()
GetOfficeFileProperty
Pause()
RegistryGetValue()
RegistrySetValue()
RunProgram()
SharePoint
GetSharePointListTitle
SharePointSiteTempalte
SharePointSourceURL
SharePointTargetURL
SharePoint specific functionlity
Dynamically preventing a SharePoint column from being assigned
The web site does not support SharePoint Online Credentials
Edition feature matrix
PowerShell Documentation
Run PowerShell from Fusion
Fusion PowerShell Commands
Get-xParameter
Set-xParameter
Add-xJobLog
Connetct-PnPOnline
PowerShell Code Snippets
SharePoint PnP Provisioning
SharePoint PnP PowerShell Resources
Roadmap
Whats new
Changelog
Next version
Fusion and Microsoft Teams
Use Cases
Create database table from List
Data Driven Automation Enviroment
Replicate/Migrate FileShare to SharePoint Library at high speed
Conditional replication of Documents from Site to Site at high speed.
Conditionally copy files or folders to different SharePoint sites
Add/Update SharePoint List Items from external data source
Delete items or documents from SharePoint
Data Movement – in & out of SharePoint
CSV Importer/Exporter with powerful filters
Copy files out of SharePoint to FileShare
Connectors to ERP/CRM and Databases
Legacy ECM data to SharePoint
Update metadata on Documents in SharePoint
Importing Lotus Notes Documents into SharePoint via AGECOM Export Utility
Master Data Management
External automation from PowerShell
Excel Workbook – Refresh/Push/Pull
Excel BULK generator
Query any SharePoint List & Library
Migrate files from custom CMS systems
Business Logic and Application examples
Introduction Video
Explaind with 1 Slide
Fusion Control Panel
Components
Job Monitor
Run a component in batch
Job Server
Run Job Server as Windows Service
Run Excel from Job Server Service
Database connections
Azure SQL Server connection
Microsoft Text ODBC Driver
SharePoint connections
2 Factor authentication not supported
How to create Office 365 AppID
Considerations for using Web Login
Service Applications
File Migration & Sync
FAQ & How to
File is missing or has wrong content or metadata
Dynamically skipping individual files from being uploaded
Leave file in “Checked Out” status after upload to SharePoint Document Library
Replace file content on during upload to SharePoint
Empty all items from SharePoint Recycle Bin
SP 365, 2013 Document Libaray Performance tip
Copy data from database to database
Update List Item or Document metadata while keeping [Modified] & [Modified By]
Links to external articles
Check for Updates/New version
“List View Threshold” and the 5000 items Show Stopper issue
Null values returned form a database
Date and Time calculation
Error conditions…
Error: Access to the path ‘xyz’ is is denied.
Set Link URL and desc (Hyperlink)
Include files created > 24 hours ago
Error connection to OneDrive 365
Migrating SharePoint BLOG Site
Fusion random crash “BEX”
Bulk Update SharePoint Items
Using SharePoint Document Id
SharePoint Query (CAML)
Miscellaneous
Installation
Advanced configuration settings
Repository
Tips and external links.
SQL tips
SharePoint External User Login
SharePoint recurrence data schema
This is what Fusion cannot do…
Diagnostics
MS PowerAutomate
For security reasons DTD is prohibited in this XML document
Support
Sales information
Price sheet
System requirements
File
Need more help with this?
DON'T HESITATE TO CONTACT US HERE ..
×
Thanks for your feedback.