Fusion Documentation

Table of Contents

Fusion Documentation

Fusion Feature List
Component reference
- File Transport
- Data Transport
- Collection
- Import
- Run with Multitasking
- SharePoint Lookup Columns
- SharePoint column types and data validation
- Job log viewer
- Parameters
- 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
  - Numeric
    - Dec()
    - IsNumber()
    - Mod()
    - Number()
    - Truncate()
    - Rand()
    - Round()
  - File
  - Collection
  - Miscellaneous
  - SharePoint
- 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
- SharePoint PnP Provisioning
- SharePoint PnP PowerShell Resources
Roadmap
- Whats new
- Changelog
- Next version
- Your great ideas
- Release Cycle
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.
- 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

Collection

CallCollection()
Finish()
Skip()
LogMessage()
LogWarning()
LogError()
LogFile()

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

Thanks for your feedback.

Copyright © 2018 No-Code Solutions