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

Xill4
4.xx.x

License valid time
29/2/2024, 11:42:29 AM

Creates a new project or opens an existing project.

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 the Select option in the flow menu.

• Exporting and importing flows

  Flows can be exported and imported, so parts of your project can be reused.

  • Exporting a flow

    To export a flow use Flow menu button (...)-> Export flow You can also export a flow when you have it open using Options-> Export Flow

  • Importing a flow

    To import a flow use use Flow -> Import Flow

• 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%)`.

note

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.