Projects
When you are preparing content migration in Xill, you start with a project. In a logical sense, a project holds all the flows and settings that you need to complete the migration.
Project toolbar
Creating a new project
To create a new project use Project->New Project
When you create a new project, Xill4 saves it to its default location, .\projects
To change this location, change the XILL4_PROJECT_PATH
environment variable. For more information, see Xill4 advanced configuration
Flows
-
Create a new Flow
Creating a new flow
To create a new flow use
Flow -> New Flow
. -
Opening a flow.
To open a flow, either click on the flow or use
Flow menu button (...)-> Open Flow
-
Updating a flow.
To update a flow, use
Flow menu button (...)-> Update Flow
This will overwrite the flow and add any new variables, currently configured variables will remain unchanged.
-
Cloning a flow
To clone a flow, use
Flow menu button (...)-> Clone Flow
-
Selecting a flow
To select one or more flows using
CTRL+Click
use theSelect
option in the flow menu. -
Exporting and importing flows
Flows can be exported and imported, so parts of your project can be reused.
-
Flow metadata
A flow contains descriptive metadata like a name, group icon etc. To edit this metadata use
Flow menu button (...)-> Edit
-
Removing a flow
To remove a flow from a project use
Flow menu button (...)-> Remove
Report Menu
It is possible to generate 6 predefined reports in Xill4. This is done using the Report Menu.
- Extraction report
- Shows all files, folders, etc that are extracted from the source system, when they were created and last modified, their file locations, and whether or not they are to be migrated.
- File Extension Counts
- Shows all file extensions and how often they occur.
- 100 Largest Files
- Shows the 100 largest files.
- Empty Files
- Shows all files with a 0 byte size, and their location.
- Empty Folders
- Shows all folders without folders or documents in them.
- Invalid File Names (SPO) - Shows all files and their locations with invalid characters in their name or a name that is too long for SharePoint These reports were found to be the most commonly used ones.
Generated reports are named {projectId}_{reportType}[{lines-lines}].xlsx
.
{projectId}
is the project ID as shown in the URL of Xill4, {reportType}
is the type of report you want to generate.
If a maximum size has been set [{lines-lines}]
shows what lines of the report are in the file. I.e. 0-10000
, for the first 10,000 lines.
The maximum size of a report can be set using the split at rows field.
Configuring the reports
The report menu has 2 configuration options:
The Mongo Connection string: this field is used input the location of the MongoDB Content Store.
It is possible to input both environment variables or vault variables using the %
-syntax (e.g. %XILL4_MONGO_CONNECTION%
or %vault.mongoConnection%)`.
This field is used to work with different databases within a single project. It is advisable to leave it at the default.
Split at rows: this field is used to input an integer value that splits the report into files with at most that many lines. When a report is split Xill4 automatically downloads all reports. This is implemented because Excel cannot handle files larger than 100,000 lines. Generating large reports also uses a lot of RAM on the machine hosting Xill4, so be careful.