Chat now with support
Chat with Support

Metalogix Essentials for Office 365 2.3 - User Guide

Metalogix Essentials for Office 365 User Guide
Administrator Architect Backup
Interface Overview Common Functions
Connecting to SharePoint and OneDrive for Business Connecting to Cloud Storage Global and SharePoint Administrators Hyper Backup Creating a Full Backup Creating an Update Backup Creating an Exchange Online Mailbox Backup Creating an Office 365 Group Backup Creating a OneDrive for Business Backup Backup Resume Backup Search Restore from Backup Scheduling Backup Jobs Retention Policies Import/Export Backup Archives Moving the Backup Location Backup Project Conversion
Drives
Interface Overview Common Functions
Connecting to Drives Copy Google Drive Copy File Share Copy My Sites to OneDrive for Business Copy Tenant Copy Box Copy Dropbox OneDrive Management Progress Tab Hyper Migration Path Length Overflow
File Manager Informant Migrator
Interface Common Functions
Connect to SharePoint and OneDrive for Business Global and SharePoint Administrators Copy Sites Live Compare Copy Lists and Libraries Copy, Move, and Tag SharePoint Content Copy Alerts Pre-Migration Report Azure Turbo Mode In-Place Tagging of SharePoint Items Incremental Copy Nintex Workflow Migration Orphaned Users Copy Preserving Content Authorship and Approve/Reject Statuses Save Site to XML Using Scripts and Integration With Windows Task Scheduler
Profile and Global Variables Public Folders for SharePoint Reporting and Re-Mapping Users and Templates Security Manager Term Store Manager Scripts Wizards Appendix

Copying NTFS Permissions

NTFS folder permissions are automatically mapped when the "Copy Permissions" option is selected within the Advanced Options of the Summary screen of the wizard.
file manager common functions 1

info

NOTE: If selecting "Remove Folder Structure", the "Copy Permissions" option will be disabled. The application will match NTFS to SharePoint permissions in the following way

NTFS Permission

SharePoint Permission Level

Full Control

Full Control

Modify

Contribute

Read

Read

Write

Contribute

List Folder contents

Read

Read & Execute

Read

info

NOTE: These permissions may also be mapped when copying NTFS to SharePoint via CSV and Command Line Scripting

Uploading Files into SharePoint

The option is designed to enhance and expand SharePoint’s ability to import files located in Windows or other operating systems. There are several advantages to using Essentials to do this operation.

·You can upload, tag and check-in content in one step and for multiple items

·You may reuse existing file system (NTFS) attributes to tag the content.

·Users often implement a folder based hierarchy inside the file system to categorize content. These folder names can be automatically extracted during upload and used as metadata in SharePoint.

·There are no limitations to how many files you can upload at one time.

·NTFS file permissions are also supported during the copy process (see Copying NTFS Permissions section for more information).

info

NOTE: NTFS Permission copy is not available to Power User products.

The process of importing files is very similar to the process of copying items within SharePoint, with one major exception. Rather than selecting the source content from a SharePoint list, it is selected from within the Connections pane or from Windows Explorer. The remainder of the process is described in the Copy/Move (and Tag) SharePoint Content section. Please refer to these sections for additional information.

info

NOTE: When importing content from the file system, File Manager can use file system attributes such as created and modified dates and file owner to tag the imported content. These attributes are shown under the Available Columns list in the Field Value Selection Screen and include relative folder names.  See Mapping Folders to SharePoint Fields for more information.

Mapping Folders to SharePoint Fields

Users who save their files to files system often use folder structure to describe the contents contained there.  In SharePoint or OneDrive for Business these folder names can be repurposed to tag the content during the upload process (and optionally remove the folder structure all together).  

To do this follow these steps:

1.Initiate the upload process by copying your local files into a SharePoint Library. Select Next and proceed to the Properties screen.
mapping folders to sharepoint 1

2.On the Properties Screen select the down arrow button next to the field that you wish to tag with folder data.
mapping folders to sharepoint 2

3.This will bring up the Field Value Selection Screen. On this screen, in the Available Columns section, you will find fields named Folder 1 in the File Path, Folder 2 in the File Path and so on.  These are relative to the root of the files structure you are uploading.

info

NOTE: You can also enable Data Analysis Mode from the Contents tab menu in order to see the folder names in the Available Values section of the screen.

mapping folders to sharepoint 3

4.Select the relative folder that you want to map to your current field and press the Select button.  

5.Complete the wizard and press Finish to start the upload.
mapping folders to sharepoint 4

info

NOTE: You may also remove the folder structure during upload.  This option is available in the copy items summary screen under Advanced Options.

Uploading Files into SharePoint Using a CSV Spreadsheet

The uploading files into SharePoint using a CSV spreadsheet option is designed to enhance and expand SharePoint’s ability to import files located in Windows or other operating systems, by utilizing a spreadsheet that contains accompanying metadata. The files will be imported into SharePoint and tagged with the metadata associated to it from this spreadsheet. Here are the basic guidelines for using the Upload Content Using CSV feature inside Essentials products.

1.Start by identifying the files and folders that you want to import into SharePoint. There are two ways to do this:

·You can expand and navigate through the Connections (1) area in the product. If you double click on a folder or drive, the contents will be displayed in the Contents (2) area. You may drag-and-drop or copy/paste from Connections or Contents areas directly to the destination.
uploading files using CSV 1

·Alternatively, Essentials provides the same capabilities directly from Windows Explorer.

2.After you have selected the content and dragged/copied it to your SharePoint destination, a familiar wizard will be displayed. This is the same wizard that is used to copy SharePoint content from one place to another. The first window will confirm the destination you drag and dropped the content to. Click Next.
uploading files using CSV 2

3.The second window will give you the ability to apply metadata values. It is a good idea to take advantage of this feature and apply as many metadata values as possible since all the data is validated against SharePoint. There are many capabilities for intelligent and auto tagging available including mapping to NTFS values such as folder names, file names, owners, etc.; or to select values directly from SharePoint managed metadata, choice and lookup lists. Once you have set all your metadata preferences, click Next.
uploading files using CSV 3

4.The final screen of the wizard has a check box towards the bottom of the page. Selecting the Create CSV File for uploading files option will generate a comma separated values file compatible with Excel or any text editing software.
uploading files using CSV 4

5.Although the file content may vary based on the selected metadata, the structure of the CSV spreadsheet will remain consistent. The CSV file will consist of the following columns:

Column Name

Description

Source File

Identifies the physical path to the file that will be uploaded

Target SharePoint Site

Identifies the target site for the file listed in the source file column. The field is left blank by default but may be specified to upload content into different sites and lists using the same CSV file. In order to take advantage of this feature the CSV file must be uploaded on a site not a list level.

Target SharePoint List

Identifies the target list for the import

SharePoint File Name

Identifies the SharePoint item name that will be used for the import ( "/" is used to identify folders)

Content Type

Identifies the SharePoint content type that will be used for the import. This content type should already exist within the target SharePoint list and must be spelled exactly the same way to avoid errors

Custom Fields

Any custom fields would be listed following the content type. These fields must already exist within the target SharePoint list (and content Type). The values entered here must also pass any SharePoint validation or restrictions for the corresponding field.

Created At

Identifies the content creation date which is extracted from the file system. If left blank the value will be set to the current date and time.

CSV ID Col

This is a reserved field utilized for incremental copy functionality. Do not enter anything into this field.

Modified At

Identifies the last content modification date which is extracted from the file system. If left blank the value will be set to the current date and time

Created By

Identifies the user who created the content. If left blank the value will be set to the user currently logged into SharePoint

Modified By

Identifies the user who last modified the content. If left blank the value will be set to the user currently logged into SharePoint.

Mark Version

For versioned libraries, identifies the version level for the item being imported ("Major" or "Minor"). If a quasi-versioning system was used in the file system, this field along with the SharePoint File Name can be used to recreate the versions in SharePoint. In order to implement this functionality, use the same file name in the SharePoint File Name field and then specify the appropriate version level in this field. If left blank, the default version level will be used during import.

Version Comment

Specifies the comment that will be used when importing items

info

NOTE: The layout must not be changed, otherwise the imported file will not be recognized. However, the content may be edited to your preferences. Please remember that any values that are modified or edited must be valid to SharePoint, otherwise they will be ignored or an error will be generated.

6. Identify the library or folder destination for your files, and upload content using CSV by doing one of the following:

·Select Upload Content Using CSV from the ribbon in the File Manager section.
uploading files using CSV 7

·right-click and select "Use CSV to..." and then select "Upload/Copy Content".
uploading files using CSV 5

7.Next the Upload or Copy Content using CSV screen will be generated. Enter the location of your .csv file or .bck file.

info

NOTE: The .bck files are automatically created by the application when downloading the entire site and sub-sites (see Downloading Content from SharePoint for more information).

uploading files using CSV 6

8.You may check individual items or the Check All button at the bottom to select everything. In addition if you are using a custom character set select it in the provided field.

9.To start the import, just press the Finish button.

Related Documents