Is it possible to use Powershell in DMT Playbooks? I know how to call individual templates, but it would be nice to put together a Playbook and just call that. Are there any examples or is this even possible?
Also, is there an extensive list of argument switches somewhere to see what is possible with DMT?
I think if launched with the /? command line it will display a dialog box showing them. But the list is so long, they don’t fit on the screen.
Someone here did some trickery and was able to screen shot all the options (I think they used multiple monitors to extend the size of their desktop. Serch on this site for it.
Thank you, apparently it is possible. Here is the full list:
Usage: DMT.exe [options]
-User
Specifies the username to connect with
-Pass
Specifies the password to connect with
-ConfigValue
Specifies which config file should be used, if not specified then default.sysconfig is assumed
-sso
Specifies Single Sign On
-LogDetailedException
Specifies if the detailed exception should be included in the error log file. Valid values are True or False.Helpful when reporting error to Epicor
-NoUI
This will run DMT without a User Interface, this supports being run from a scheduled task
-DisableUpdateService
This will disable the DMT update service
-Add
Indicates that records should be added
-Update
Indicates that records should be updated
-Delete
Indicates that records should be deleted
-Trace
This will enable tracing in Epicor
-LoadViaOdbc
Forces DMT to use ODBC to read import data, use if errors occur on data load
-ExportData
Exports format of all imports to specified file
-ExportDataFormat
Set to xml to export imports to xml rather than csv
-Delimiter
Sets delimiter for import files
-Import
Specifies the Import to run
-Source
Specifies the import source file
-Converter
Specifies the location of an assembly containing a method to convert the data before importing
-NoCompleteLog
When set to TRUE this will disable the Complete Log
-NoErrorLog
When set to TRUE this will disable the Error Log
-NoErrorInput
When set to TRUE this will disable the Error Input Log
-PlayList
Executes PlayList through command line with specified import source file
-PlayBook
Executes PlayBook through command line with specified import source file
-Export
When Export is set and Import is not, this tells DMT to perform a BAQ Export.
-BAQ
The name of the BAQ to run in BAQ Export mode.
-Target
The file path of the output file to create in BAQ Export Mode.
-PageSize
The number of records to read from the BAQ at a time. Larger = faster. Smaller = less memory. Default 10000.
-UseFieldNames
Include this flag to use the BAQ Field Name rather than Field Label.
Splitter Help —
DMT can be used to split a CSV file into multiple files.
3 arguments must be supplied
This should follow the syntax
-split -input=[InputFile] -files=[FileCount]
Example
-split -input=C:\DMTDiff\Input.csv -files=10
This will save the data from Input.csv in 10 new csv files in the same folder.
Following the format C:\DMTDiff\Input_XX.csv.
-split – required to run the split tool.
[InputFile] – The file you wish to split
[FileCount] – How many new CSV files you wish to create (Must be a number)
Paths can also be relative if they exist in the same folder as the application
Where you able to figure out the exact command line steps? I trying to figure this out as well.