The migration spreadsheet

Migrate for AODocs is a tool that allows you to migrate files and folders into your AODocs libraries.

Important: Migrate for AODocs is currently available for our service teams only. For EAP access, contact dev-migration@altirnao.com

 This article describes the different tabs in the migration spreadsheet:

 What is the migration spreadsheet?
 The data tab 
 The binding tab
 The mapping tab
 The attachments tab
 The folder tab

 


What is the migration spreadsheet?

In the migration configuration screen, you can generate:

  • an extraction spreadsheet, to analyse the details of your source files and extract details about the migration (no migration takes place from the extraction spreadsheet) – learn more: Extract details of your source data and migration setup
  • a migration spreadsheet, containing all the instructions that Migrate for AODocs uses to migrate your files to AODocs

When you generate a migration spreadsheet, your migration starts. You can edit the spreadsheet to configure your migration while your files are uploading to the My Drive of your uploader account. You then confirm when you’re ready to create your files in AODocs.

Learn more: What is Migrate for AODocs?

Notes:
– There’s no difference between the extraction and migration spreadsheets, except that in extraction spreadsheets the attachments tab isn't populated. Other than this, they’re generated in exactly the same way, according to the options you select in the configuration screen.
– You can also create migration spreadsheets from scratch.


The data tab

Each row in the data tab corresponds to a document to migrate into AODocs.

For file system migrations, there is one attachment per document. For SharePoint / Lotus Notes migrations into Document Management libraries, there can be zero, one or more attachments per document.

The columns in the data tab are listed below with a description of what they contain and details about what you can change in them.

ID column:

What it contains:

Unique ID of the document.

  • For file system migrations: path of the file to migrate
  • For Goole Drive migrations: Google ID of the document
  • For SharePoint migrations: URL of the document in the SharePoint site
  • For Lotus Notes migrations: ID generated by the Lotus Notes exporter
    Note: This is different from the technical ID – learn more: Title column.
Details: Don’t change this value.

VERSION column:

What it contains:

Version number of the document.

Different versions of a document are on separate rows with the same ID but different version numbers.

This column is included in the spreadsheet only if there is versioning information available in your source data and you defined how many versions to include in the configuration screen. If you included three versions, the three latest versions are listed, for example, versions 9.0, 8.0 and 7.0.

For SharePoint migrations: the column is filled in from your source data.

Details:

You can change the value in this cell (it must be a numerical value).

For “from scratch” migrations: you can create the column and fill in the values manually.

Note: In the binding tab, add the VERSION column name to include it in your migration.

VERSION_DESCRIPTION column:

What it contains:

Description of the version.

For all migration types except “from scratch”: this column is included in the spreadsheet only if the VERSION column is included.

For SharePoint migrations: the column is filled in from your source data (if available).

Details: 

You can add, delete or edit the value in this cell. It will be imported as the description for a document version. Learn more: Manage document versions in AODocs libraries.

For “from scratch” migrations: you can create the column and fill in the values manually.

Note: In the binding tab, add the VERSION_DESCRIPTION column name to include it in your migration.

CLASS_NAME column:

What it contains:

Name of the document class in your AODocs library.

For all migration types except SharePoint and Lotus Notes:

  • if you selected a document class in the configuration screen:
    • the spreadsheet doesn't contain a CLASS_NAME column; all documents will be imported into the document class you selected
    • columns are created in your spreadsheet for all existing properties in the document class you selected
  • if you didn’t select a document class in the configuration screen, the column is empty and you must fill it in manually – every cell must have a value

For SharePoint / Lotus Notes migrations:

  • the column is filled in with the SharePoint Content Type / Lotus Notes Form
  • if you select a document class in the configuration screen, it is taken into account for the migration and the SharePoint Content Type / Lotus Notes Form are ignored

Learn more: Run your migrations.

Details:

You can change or add the value of this cell. If you enter a value that doesn’t correspond to an existing class in your library, a new class is created in your AODocs library during the creation phase.

Notes:

  • You can't run a migration without defining the document class for all your documents.
  • Names of document classes are case sensitive.
  • Team Folders have only one document class, so if your target library is a Team Folder, all cells in the column must contain the name of its only document class.

FOLDER column:

What it contains: For all migration types except for “from scratch”: this column is filled in with the name of the folder containing the migrated file (if any).
Details:

A folder with this name will be created in your AODocs library.

You can:

  • change or add values to create folders with different names in your AODocs library
  • add /folderA/folderB to create subfolders
  • remove the value to migrate the file to the root of your AODocs library

Notes:

  • If there is already a folder with this name in your AODocs library, the file is migrated into this folder.
  • In Document Management libraries, you must first activate folders if you want to organize your files in a folder structure.
  • You must have Browse by Folder defined in views to see your documents in folders.

TITLE column:

What it contains:

Title of the document.

Every cell must have a value.

For all migration types except for “from scratch”: this column is filled in from your source data.

For Lotus Notes migrations: this column contains the technical ID of the document because the titles of documents don't appear in the source data for migration. 
Notes:

Details: You can change or add a value to define the title of your document when migrated into AODocs.

RICH_TEXT column:

What it contains:

Document description. Can be in plain text or HTML code.

For SharePoint migrations: this column is filled in with the Description of your source files.

For Lotus Notes migrations: this column is filled in from your source files.

Details:

You can change or add a description for your document.

Learn more: The AODocs document page.

CREATION_DATE column:

What it contains:

Date your source file was created.

Details:

Documents keep their original creation date when migrated into AODocs.

You can change this value.

MODIFICATION_DATE column:

What it contains:

Date your source file was last modified.

Details:

Documents keep their last modification date when migrated into AODocs.

You can change this value.

INITIAL_AUTHOR column:

What it contains:

Name of the user who created the source file.

Every cell must have a value.

Details:

Documents keep their document creator when migrated into AODocs.

You can change this value.

UPDATE_AUTHOR column:

What it contains:

Name of the user who last updated the source file.

Details:

Documents keep their last update author when migrated into AODocs.

You can change this value.

ATTACHMENT column:

What it contains:

For file system migrations: there is always one attachment per source file.

For SharePoint / Lotus Notes migrations into Document Management libraries: there can be zero, one or more attachments per document. If there are several attachments, they are separated by pipe signs (|)

Details:

For all migration types except “from scratch”: you mustn’t change the values in this column.

For “from scratch” migrations: you can enter the path of a local file.

Note: If you do this, you must run the migration through the upload phase again to ensure your attachments are uploaded.

[Property name] column:

What it contains:

For file system migrations: a column is created for each property in the document class you selected in the configuration screen (if any).

For SharePoint / Lotus Notes migrations: a column is created for each property defined in your source data.

Note: Each column must have a unique name. This means you can't have a custom property column called ID, for example. However, if you want to have a property called ID, you can rename the property column and then in the binding tab, "bind" it to a property called ID in the Target name column.

Details:

You can add or change property values for each document.

You can add as many columns as you like, to create new properties.

Note: In the binding tab, add the names of any columns from the data tab that you want to include in your migration.

AODocs ID column:

What it contains:

ID of the document created in AODocs during the creation phase of the migration.

Note: This different from the Google Drive ID of attachments.

Details:

Don’t make any changes to this column. It must be empty before running the migration.

It is filled in during the migration when the documents are created in AODocs.

 


The binding tab

The binding tab is used to define which columns from the data tab to use in your migration. You must “bind” the source data to your target AODocs configuration. Any columns not listed in the binding tab will be ignored during the migration.

Note: The binding tab is populated in extraction spreadsheets. However, don’t make any changes because you can’t use the extraction spreadsheet for migration.

image01.png

System properties

The system properties (always in capitals) are listed first. System properties must have the same values in the Source name and Type columns.

Important: Don’t enter anything in the Target name column for system properties. You can’t change AODocs system properties, so if you enter values they won’t be taken into account.

VERSION and VERSION_DESCRIPTION are treated like system properties. If these columns were created during the extraction phase, they’re listed in the binding tab along with the system properties. If you added versioning information to your data tab manually, you must also add it in the binding tab to include it in your migration.

 

Custom properties

Custom properties are listed after the system properties.

Notes:
– For file system migrations: if you selected a document class in the configuration screen, columns are created in the data tab for the properties (if any) in your document class. These properties are also listed in the Source name column in the binding tab.
– For SharePoint / Lotus Notes migrations: columns are created in the data tab for the properties in your source data. These properties are also listed in the Source name column in the binding tab.

Create new properties for the documents to migrate

1. Create a new column in the data tab.

2. Name it with your new property.

3. Enter values in the required cells.

4. Repeat steps 1 to 3 to create as many properties as you want.

“Bind” custom properties to your AODocs configuration

1. In the Target name column in the binding tab, enter the property names you want to use in AODocs for the corresponding properties listed in the Source name column. If any properties you enter in the Target name column don’t yet exist in your AODocs document class, new properties are created.

Tips: To display any new custom properties you added to the data tab, position your cursor in the first empty cell in the Source name column and start typing the name of a property.

2. In the Type column, use the drop-down menu to select the property type. These are the property types available in AODocs. Learn more: Create and configure custom properties.

Important: Don’t select system properties in this list.

Note about creating categories

When you create new categories or category values using the migration spreadsheet:

  • if you create new values for a category that already exists in your AODocs library, you must first make sure the checkbox Dynamic values is selected in your library configuration for the category, so the new values can be added
  • if you create a new category and give it values, a new category with dynamic values is created in your AODocs library

Learn more: Create categories.

"Bind" the AODocs Title system property to a specific field in Lotus Notes

For Lotus Notes migrations, the titles of documents don't appear in the source data, so the TITLE column in the spreadsheet contains the ID of the document. The title of your Lotus Notes documents may be held in a specific field. 

To "bind" the AODocs Title system property to a field in Lotus notes:

1. Remove the entire row containing the TITLE system property in the binding tab. 

2. Add TITLE as a custom property in the Source name field.  

3. Select the Lotus Notes field that contains document titles in the Target name field. The content of the Lotus Notes field you selected will be the titles of your documents when imported into AODocs.


The mapping tab

The mapping tab is used to map users who are mentioned in your source data onto accounts on your G Suite domain.

Note: The mapping tab is populated in extraction spreadsheets. However, don’t make any changes because you can’t use the extraction spreadsheet for migration.

The origin column lists all users who are mentioned in your source data (for example, INITIAL_AUTHOR, UPDATE_AUTOR, SharePoint users and Lotus Notes users). Use the gsuite column to map these uses to accounts on your G Suite domain.

Note: The G Suite accounts you enter in the gsuite column must already exist on your domain.

image02.png


The attachments tab

In migration spreadsheets, the attachments tab lists all the attachments to migrate.

Note: The attachments tab isn’t populated in extraction spreadsheets. Learn more: What is the migration spreadsheet?

You can view this tab during the migration to monitor the creation of your attachments in AODocs.

The columns in the attachments tab are listed below with a description of what they contain.

Important: You mustn’t change anything in this tab. 


origin

Path of the attachment to migrate.


lastUpdate
 

Date of the last update to the attachment. Attachments keep their last modification date when migrated into AODocs.

driveID

 The Google Drive ID of the attachment

 


The folder tab

In extraction and migration spreadsheets, the folder tab lists all the folders that will be created during the migration.

Important: You mustn’t change anything in this tab.

Was this article helpful? 0 out of 0 found this helpful
If you didn’t find what you were looking for, don’t hesitate to leave a comment!
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.