DMT Documentation

Used by Epicor customers and partners worldwide, DMT reduces the complexities of data management. Explore our DMT Support Portal for everything you need to get the most from Epicor DMT.

Features

PlayLists

A PlayList is a CSV file containing a list of Import files. A PlayList can be loaded into DMT and used to run the list of Imports. PlayLists support many of the features of the Command Line Argument feature, so you can control whether to Add, Delete or Update the specified Imports. The PlayLists menu item can be found in the main menu:

Use the "Load PlayList" button to load an existing PlayList file or click the "Add Row" button to create a new PlayList.

The PlayList file is a comma separated list of Command Line Arguments with the name of the argument in the header:

In addition to the normal Command Line Arguments, PlayLists also allow the user to specify the "Wait" command. This tells DMT to wait until this Import has finished before starting the next Import. This allows multiple Imports to be run concurrently or consecutively.

Clicking the "Load Imports" button simple the specified Imports into DMT. Clicking the "Load and Run Imports" button loads the specified Imports into DMT and runs the Imports.

PlayBooks

A PlayBook is a text file containing a list of PlayList files. A PlayBook can be loaded into DMT and used to load or run the PlayLists. The PlayBooks menu item can be found in the main menu:

A PlayBook is a simple list of files with a header of "PlayList". The files are PlayList files.

Use the Move Up / Move Down buttons to reorder the list. Click the Load button to load the PlayList.

Please download the new PlayBooks and PlayLists Lab from EpicWeb for more details.

Favorites

Use the Favorites menu to store frequently used Imports.

To add an Import to the Favorites menu, right-click the import in the menu and select "Add / Remove Favorite"

The Import is added to the Favorites menu and can be launched from here:

To remove an Import from the Favorites menu, right-click the Import in the Favorites menu and select "Add / Remove Favorite" again.

BAQ Exports

We are proud to announce a powerful new feature for DMT – the ability to export data from Epicor. DMT can now be used to export data from an Epicor Business Activity Query (BAQ), producing a file compatible with DMT imports. This has enormous scope for keeping Epicor environments in sync.
Initially, the new feature is only available from the Command Line. We will be extending this functionality in later releases, but for now, a DMT BAQ Export can be initiated using a Command Line similar to the following:-


                                    start C:\Epicor\ERP10\DMT.exe -User=myuser -Pass=mypass -Export -BAQ="CustomerExport"
                                    -Target="C:\CustExport.csv"

Where :

-Export – instructs DMT to perform a BAQ Export rather than an import.
-BAQ="CustomerExport" – informs DMT to use the BAQ called “CustomerExport”. If the results of this BAQ export are to be used to re-import data to another environment using DMT, please ensure that columns in the BAQ are compatible with the relevant imports (this can be checked in template builder)
-Target="C:\CustExport.csv" – tells DMT where to create the DMT import file.

PowerShell Examples

We have created a GitHub site for sharing useful information about DMT. Our hope is that the DMT community will contribute to this site to help make using DMT even easier.
To start the ball rolling, we have uploaded some useful PowerShell scripts for scripting DMT imports (including one that sends a confirmation email).
Please following the link: EpicorDMTScripts

Updater Service Migration

Path to update DMT to 4.0.50.1 and above

How to update DMT to 4.0.50.1 and above? DMT Updater Service has been moved to a new URL on Microsoft Azure. If you are on DMT versions 4.0.49.0 or below, you need to first update to DMT 4.0.50.0 then update to DMT 4.0.50.1 and above.
From Epicor ERP 10.2.500 onwards, DMT Tool will be shipped as part of the ERP installation.

Screenshots

Tabbed Imports: Open imports are displayed in tabs at the top of the screen to make them easier to switch between.

New Menu Structure: The import menu is now displayed as an Epicor-style "tree-view" on the left-hand-side of the screen. The standard import menu is under Management Mode.

New Search Menu: The new Search Menu can be used to quickly find an import. The list of matching imports refreshes as you type. Clicking the item in the list launches the import screen.

New Migration Mode : The new Migration Mode helps define the order in which imports should be used when migrating to a new environment. Using the imports in the order in which they appear in the menu ensures your data is loaded into the environment in the correct order.

Extensions Menu : DMT extensions are now displayed in a separate menu for of access.

Data Management Tool