Skip to content
SMART Migration platform
Search
Ctrl
K
Cancel
Home
Partners
Ask the Docs
Contact us
Select theme
Dark
Light
Auto
Home
Partners
Ask the Docs
Select language
English
Deutsch
Français
Nederlands
Menu
Home
Partners
Ask the Docs
Contact us
SMART Migration Platform
Features
Migration Automation
Use case scenarios
Comparison to classic tools
ShareGate Migrate vs SMART Migration
OneDrive Migration - differences
Why SMART Migration
SMART Migration vs. Scripting
SMART Migration Customer cases
Unique Selling Proposition (USP)
IDE (Integrated Development Enviroment)
Installing the SMART Migration server for the IDE
Function reference
How functions work in transformations, variables and call conditions
Logical
Case()
If()
IsNull()
Text
Asc()
Char()
CharNewLine()
CharTab()
ExtractMetadataColumn()
Fill()
IndexValue()
LastPos()
Left()
LeftTrim()
LeftTrimChar()
Len()
Lower()
Match()
Mid()
Pos()
Replace()
ReplaceAll()
ReplaceFirst()
ReplaceTextInFile()
Right()
RightTrim()
RightTrimChar()
Space()
String()
StringCheckSum()
Trim()
TrimChar()
Upper()
WordCap()
Date and Time
Date()
DateTime()
DateTimeToNumber()
Day()
DayName()
DayNameLocal()
DayNumber()
DaysAfter()
FirstDayOfMonth()
FirstDayOfWeekISO()
FirstDayOfWeekUS()
Hour()
HoursAfter()
IsDate()
LastDayOfMonth()
LastDayOfWeekUS()
LastDayOfWeekISO()
Minute()
Month()
MonthsAfter()
MonthName()
MonthNameN()
Now()
RelativeDateTime()
RelativeMonth()
RelativeYear()
Second()
SecondsAfter()
SecondsAfterDateTime()
Time()
Today()
Year()
YearsAfter()
WeekNumberISO()
WeekNumberUS()
Numeric
Dec()
IsNumber()
Mod()
Number()
Truncate()
Rand()
Round()
File handling
FileCheckSum()
FileExist()
FolderExist()
GetFileNamePart()
GetFolderCreated()
GetFolderModified()
ReadTextFile()
RemoveIllegalCharactersFromFileName()
WriteFile()
SharePoint
GetSharePointLibraryURL()
SharePointPlatform()
SPConvertToDirectFolderURL()
JSON
GetJsonBoolean()
GetJsonString()
GetJsonNumber()
Nextcloud App
NCApp_ClaimJob()
NCApp_GetRunHistory()
PowerShell
Get-FlowVariable
Set-FlowVariable
Add-FlowLogRow
Connect-PnPOnline from SMART Migration
PowerShell samples
PnP.PowerShell installation
Dashboard: job sessions and their logs
Offload SharePoint files to Blob storage
SMART Offload FAQ
Offload - System requirements
Microsoft Blob Storage Pricing
Offload implementation - How it works
Microsoft 365 Archive
Access to SharePoint & Blob Storage
Setup: Antivirus Exclusions
Workpoint 365 support
IDE FAQ
FAQ: Getting started and setup
FAQ: Transformations, functions and variables
FAQ: PowerShell
FAQ: SharePoint, WorkPoint 365 and the Nextcloud app
Nextcloud
Installing the SMART Migration server for Nextcloud
Commercial
SMART Migration for Nextcloud
Business Intelligence
App To Nextcloud
How SMART Migration and the app work together
Security, privacy and data ownership
The destination user's app password
Why the SMART Migration server runs in your network
Performance and load on the Nextcloud server
Set up SMART Migration for the app
How to get a SMART Migration partner
The Support tab
Partner role
Working with a partner: from first contact to go-live
Trial and licences
Set up the project team
Find your way around the app
Settings
Help panel and AI Help
Working together: what is shared and what is yours
Which jobs to create first
Jobs and job modes
The job dialog
Advanced options for discovery and migration
Job status
Scheduling, recurrence and priority
Sources
Migrate a list of files from a CSV file
Export a file list from Power BI
Pick files with a Power BI or SQL query
Choose which files a job takes
Incremental runs: only the files changed since the last run
Version history
Destinations
Rules for adding and overwriting files
Metadata, MetaVox and SharePoint views
Why carry metadata into Nextcloud with MetaVox
Encrypted SharePoint Files (Purview)
Groups and tags
Organise the jobs of a project
Change many jobs at once
Import jobs
Import jobs from a CSV file
Import jobs by scanning SharePoint or OneDrive
Naming and placing scanned jobs
Discovery
Dashboard
Count and filter runs on the Dashboard
Monitor the migration from one place
Progress for jobs without a Discovery run
Notifications when a job runs
Run History
Run details and the session log
Reports and run folders in Nextcloud Files
File Issues
Business intelligence with Power BI
Power BI for first-time users
Refresh, upload and share SMART BI.pbix
A tour of the SMART BI report
Follow every file from discovery to migration
Adapt the SMART BI report to your needs
Plan and run a migration, wave by wave
Estimate volume and duration
What a migration involves, and what sets its speed
Size the servers for a large migration
Cutover: Traditional and Enhanced Migration
Why replace SharePoint files with .url links
Restore: files back from Nextcloud to SharePoint Online or a file share
OneDrive to Nextcloud
File shares to Nextcloud
Digital Resilience Operation (DORA)
Glossary
Nextcloud FAQ
FAQ: Getting started and setting up
FAQ: Partners and licences
FAQ: Finding your way around the app
FAQ: Jobs
FAQ: Sources, files and destinations
FAQ: Importing jobs
FAQ: Discovery and business intelligence
FAQ: Runs, reports and file issues
FAQ: Planning the migration
FAQ: Production and performance in the real world
FAQ: When something does not work
FAQ: Partners' services
Troubleshooting
Technical prerequisites for partners
How to setup your free Windows Sandbox
Partner POC
Microsoft Teams App
Installing the SMART Migration server for Microsoft Teams
Power BI
Power BI tips
System information
Hardware/VM requirements
How SMART Migration installs: the repository and the BI database
Plan and maintain the SMART Migration environment
Licences and editions
License matrix
Create an M365 app registration
GA download and change log
Download release candidate
Partner info
How to become a partner
Partner material needed
Select theme
Dark
Light
Auto
Select language
English
Deutsch
Français
Nederlands
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 an expression is null.
