The Epicor Data Management Tool (DMT) is an application that many Epicor ERP clients use to import information into their Epicor systems and to make mass updates. Many clients already know how to use the tool through the standard UI interface. The command line interface allows for interacting with the DMT without the need for user intervention.

The Benefit of Accessing Epicor Data Management Tool via Command Line

By allowing us to interface directly with DMT, this allows for us developers/consultants to quickly import information into Epicor. Such information that can be imported for both new and updating include:

  • Parts
  • Material Issue
  • Return Material
  • Quantity Adjustments
  • Jobs
  • Job Receipt to Inventory
  • Many More

Under normal circumstances, we would need to utilize the standard Business Objects or APIs to make these transactions and updates within the system. This can add a lot of overhead when performing a large number of transactions at a time. Pushing these through the DMT usually allows for us to process a greater number of transactions more quickly, with only the need to write the CSV file and kick off the application.

Getting started with Epicor Data Management Tool (DMT) via Command Line

Epicor provides a good amount of information regarding the DMT and the command line interface. Here is some documentation on it, so long as you have an EpicWeb account. you can find those resources, here.

The above resource provides all of the options that can be used with the DMT.exe and some basic examples. Beyond that, I would recommend anybody who would want to use this to use the DMT to create the templates for what the would want to import. By default, it automatically selects the required fields, so it’s just a matter of adding in the fields that needs to be updated/inserted.

Kicking off the DMT via a BPM is how I had originally done this for an Encompass client in Life Sciences manufacturing and I imagine that this would probably be the most universal way for it to be used. With that said, using the DMT in this way is not viable for Cloud clients as the DMT isn’t available for execution from the server side of things.

Cloud clients can still utilize the DMT, even with command line, but it would need to be through a different methodology, such as script file or through a local application that has access to the DMT install.

For more information on utilizing Epicor Data Management Tool via Command Line, reach out to Encompass using the link below.

About Encompass Solutions

Encompass Solutions is a business and software consulting firm that specializes in ERP systems, EDI, and Managed Services support for Manufacturers. Serving small and medium-sized businesses since 2001, Encompass modernizes operations and automates processes for hundreds of customers across the globe. Whether undertaking full-scale implementation, integration, and renovation of existing systems, Encompass provides a specialized approach to every client’s needs. By identifying customer requirements and addressing them with the right solutions, we ensure our clients are equipped to match the pace of Industry.


This page is currently only accessible to registered members of our website. Please register here to view this content. Thank you.

 


This page is currently only accessible to registered members of our website. Please register here to view this content. Thank you.

 


This page is currently only accessible to registered members of our website. Please register here to view this content. Thank you.

 


If you have not already heard, the Automate Forward Trade Show and Conference is being held virtually this year. It’s one of our favorite conferences and it’s free to attend.

What is Automate Forward?

A week-long event of talks, demos, and exhibits on automation technologies.

From the event organizers – “One thing every industry has in common right now is the need to do more with less. Whether it’s less manpower or tighter budgets, demand is increasing even if resources are not. Automation is the key to not just getting through these difficult times, but to growing during them! With more than 80 speakers reviewing robotics, machine vision, motion control, artificial intelligence, and smart automation technologies, Automate Forward is the event to participate in to learn how to reach and exceed your goals.”

View the agenda

When is it?

9 AM – 5 PM EST, March 22-26, 2021

Where is it?

Anywhere you have an internet connection with your computer or mobile device.

How to attend

Register and join the event on one or all of the days’ activities.

Encompass will be participating in the event for our third year and we’re excited to be a part of this exceptional event again. Don’t forget to stop by our virtual tradeshow booth and say hello.

We hope to see you there.

About Encompass Solutions

Encompass Solutions is a business and software consulting firm that specializes in ERP systems, EDI, and Managed Services support for Manufacturers. Serving small and medium-sized businesses since 2001, Encompass modernizes operations and automates processes for hundreds of customers across the globe. Whether undertaking full-scale implementation, integration, and renovation of existing systems, Encompass provides a specialized approach to every client’s needs. By identifying customer requirements and addressing them with the right solutions, we ensure our clients are equipped to match the pace of Industry.

1 2 3 20