Chat now with support
Chat with Support

Metalogix Email Migrator 4.7.1 - Help

Introduction Getting started Migration User Interface Configuration Troubleshooting & Tips

Exporting Jobs to an Excel File

Metalogix Email Migrator Console has the ability to export a selected job or multiple jobs from the Job List section into a Microsoft Excel file. The export will include all of the operations within each job (whether it is a migration action or some other action), and their details. This is to help users better understand their migration data and results, and provides another way to review the resulting logs.

In addition to the log details that are provided, there are also a number of tables and charts that can be accessed in different tabs within the Excel file. These tables and charts will help breakdown the information in a more visible manner.

The below directions will explain how to access and use this feature.

1. First, an action of some type (a migration action or some other type of action) must be run, in order to create a job in the job list section.

2. Next, select the desired job(s) to export from the Email Migrator Job List.

3. From here there are two options. Users can:

a)Select the Export Excel button at the top of the Job List (next to the Delete Jobs button).

b)Right-click on the selected job(s) to open the context menu, and select the Export selected job to Excel option (under Export selected job to xml).

4. In either case the Save As explorer window will open. This allows users to navigate to, and select, the desired location to save the Excel file to. This also lets users determine the name for the exported excel file, however, a file name will be provided by default. Click the Save button after the desired location and file name has been selected.

5. The excel file will be saved to the desired location and is ready for viewing. By default the excel file will open after it has been created. This process may take a few minutes depending on the size of the selected job(s) and the number of actions in the log(s).


Explaining the Exported Excel File

When an Excel file is exported from the Email Migrator Job List there are a number of page tabs that can be viewed. Each page tab will display a different set of data, and some of these tabs will also display pivot graphs (with pivot tables behind them).



The data within all of these excel tabs (both the tables and the graphs) should only be considered a starting point when looking at your migration data. Users can modify the existing graphs through various methods, such as applying filters, changing the data values, etc. Users can also take the "raw" data from the LogItems tab and use it to create their own graphs or sets of data as required.


Jobs - This tab will list all of the specific jobs that are included in the export. This includes migration jobs as well as other actions.

LogItems - This tab will list all of the operations that have been run by Email Migrator and provide all of the logging details that are available in the Log Viewer and Log Item Details windows. Some examples of these operations are: copying documents, adding users, updating lists, etc.




Error Rates - This tab will display a graph that represents the number of errors and warnings that Email Migrator encounters during a migration on a "per minute" basis. The vertical axis will list the number of errors/warnings that are encountered (at the specified time), and the horizontal axis lists the amount of time (displayed in a "per minute" value). The horizontal axis can also be changed to display in month, day, or hour time values as well. Below the graph there is a table that will provide a different view of the same error/warning breakdown.




Operation Counts - This tab will display a graph that represents the number of operations/actions that are run over a period of time. Some examples of the operations that will be displayed are: copying mailbox, copying folder, copying user etc., and each operation will have its own line representation on the graph. The vertical axis will list the number of operations that are running (at the specified time), and the horizontal axis lists the amount of time (this is displayed in a "per minute" value). The horizontal axis can also be changed to display in month, day, or hour time values as well. Below the graph there is a table that will provide a different view of the same migration operation data.




Operation Duration - This tab contains a graph that displays the total duration of time for each operation/action type against the total migration time, and is potentially most confusing graph to read in the exported excel file. The vertical axis lists the total duration time for each action. This is determined by finding the difference between each operation/actions Time Started and Time Finished values, and then adding the totals together for all of that operation/actions of that type that are running. This is then displayed against the horizontal axis which lists the time (displayed in a "per minute" value) for the migration. The horizontal axis can also be changed to display in month, day, or hour time values as well. Below the graph there is a table that will provide a different view of the same migration data.

An example of how to read this graph is: if at minute 25 (of the hour, not the 25 minute of the migration) a large number of small documents are copied and completed (all in the 25th minute), then at minute 25 in the graph there will likely be a spike in the "duration time" for the "Copying Document" operation/action. If each document was copied in 2 seconds, and there were 41 small documents, then the Sum of Duration value would be listed as 82 seconds (or 0:01:22). So the results in the graph would show a spike for the Copying Document operation/action and minute 25, with a value of 0:01:22.




Operation Throughput - This tab will display a graph that represents the amount of data/throughput (in MB) that is migrated on a "per minute" basis. The vertical axis will list the amount of data that is being pushed through Email Migrator for a given operation (at the specified time), and the horizontal axis lists the time (displayed in a "per minute" value) that the action was performed at. The horizontal axis can also be changed to display in month, day, or hour time values as well. Below the graph there is a table that will provide a different view of the same throughput data.




In This Section

Resource Utilization Settings

Automatic Updates

Configuring Proxy Settings

PowerShell Authentication

Generating PowerShell Scripts

PowerShell Command-let List



Resource Utilization Settings

Metalogix Email Migrator has the ability to manage its performance level through the Resource Utilization Setting. This type of management is also known as throttling, and is used for any migration action that is run with the Email Migrator.

To access this feature go to the Email Migrator's ribbon and select Settings > Edit resource utilization setting. This will open a new window:




This new window displays a slide bar, with Efficiency on the left-hand side, and Speed on the right-hand side. By default this value will be set in the center or the slide bar. This is the recommended setting for best performance and resource utilization (use of RAM, CPU and Network load) during a migration.

If the slide bar is further to the left, the migration will run slower, but will have less chances of overloading the available resources and causing potential errors. If the slide bar is farther to the right, it with use more system resources, and can speed the migration up, but could cause some potential errors if the system resources cannot handle the data being migrated. There is a chance that if the speed is too high, you would actually see a slowdown in the overall migration, because the migration is trying to run actions faster than the resources properly allow.

The actual values that are provided in the slide bar are determined by the systems resources (the system that has Email Migrator installed on it). A system with high resources will be able to run faster migrations, even if using the default setting (which is for the slide-bar to be in the middle), because it's overall available resources will be higher. This also means that the Efficiency and Speed values will have a larger spread between them. A system that has low resources will run slower, simply because it doesn't have the resources to run at faster levels. Again, this also affects the default values for Efficiency and Speed, since these numbers will be lower, and have a smaller spread between them.




If the Efficiency is set to maximum (all the way to the left), the migration will run slower, but the "slowest" speed will be the same between systems with high and low resources. The "slowest" value between systems will always be the same, however, the "highest" value will be different based on the systems resources.


Automatic Updates

Metalogix Email Migrator has the ability to automatically check online to see if there is a more recent version of the Email Migrator available for download. This gives users easier access to new builds, and provides a direct line to download and install the Email Migrator.

Every time Email Migrator is started it will automatically check to see if there are any new updates, to help users ensure that they are working with the most recent build, with all the latest features and fixes that are available. This check requires that the system that the Email Migrator is installed on has internet access. While the Email Migrator will check every time it is opened, it is also possible to manually run the check. To do this go to the Help option in the toolbar, and select Check update.

If the user is already running the latest build, the Check for Updates dialog will open, and the user will be informed that they already have the latest version installed. If there is a new build available for download the Download and Install Update dialog will open.



After update from 4.0 to 4.1 connection to folder will be lost and it is necessary to recreate it again.




It is recommended to complete all not finished migrations in the old version and update only afterwards. Then run new migrations.


Running the Automatic Update

1. When the Email Migrator runs a check for updates and finds a newer build available, users will be prompted to update with the Product update information dialog.




2. The available options in the Product update information dialog are:

o Update - Select this option and click OK and Download to download the latest version.

o Remind me later - Select this option to skip this dialog. A new version reminder appears when Email Migrator is started next time.

o Skip this version - Select this option not to be notified of this version. Notifying dialog will appear only when a next new version is available.

o Turn off automatic updating - Select this option to disable the automatic update check. However, new versions can still be checked manually from the ribbon menu by clicking Help > Check for Updates.




In case your maintenance license has expired already, you will not be eligible to install the new version. Should you still wish to update, contact us.


3. If the Update option is selected the Download and Install Update dialog will open.




4. Click the Download button. This will allow users to directly download the latest build to their current machine. The progress of the download will be displayed in the Download progress bar.




If users are accessing the internet through a proxy server the here link can be clicked to open the proxy configuration dialog.

5. Once the download is complete, click OK to continue.

6.T he Download and Install Update dialog will still be open, but the Download button will be replaced with the Install button.




Users will have the option to install the new build directly from here by clicking the Install button. If users are continuing the installation process directly from this dialog, then the Email Migrator console will close itself down, so the install process can be run.

7. Users can step through the installation process.

8. When the install is complete, users can start Email Migrator and continue with their migrations.


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating