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

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 limitations

Need more help with this?
DON'T HESITATE TO CONTACT US HERE ..

Thanks for your feedback.
Copyright © 2018 No-Code Solutions