DMT Playbook Powershell commands

Thank you, apparently it is possible. Here is the full list:


Command line help

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


OK

5 Likes