We haven’t considered functions for this. I just had the DMT training session with Epicor, and we went over exporting part masters and reimporting them with updated values. In our case, we are replacing operations, so we have to DMT delete the operations, then DMT import the operations. Exporting all the necessary data with a BAQ is a fast and simple way to get the data out. I just had to go through and manually update the field labels.
I am exporting every field I can for comparison before and after I rework the part master. I want to make sure that the DMT captures every thing. Since I am not very familiar with it yet, I wanted to run it as open as possible.
My coworker just found a great solution using the DMT through command lines with a batch file. Run: C:\Epicor\ERPDT\Client-Pilot\DMT.exe /? to see the parameters that can be used with the DMT in command line.
There is a parameter in the DMT command line called -UseFieldNames. If you export your BAQ this way, it will automatically include the correct field names instead of labels. This batch file can be used to export the data I need.
SET /P PW=Enter password
echo %PW%
start C:\Epicor\ERPDT\Client-Pilot\DMT.exe -User=name -Pass=%PW% -Export -BAQ="baqName" -Target="C:\temp\001.csv" -NoUI -UseFieldNames
pause
Has anyone else discovered this? Is there any reason we shouldn’t use it? Thanks!
Nate