Using the dt Command Line Tool
This applies to: Managed Dashboards, Managed Reports
The dt tool lets you perform various admin/configuration tasks from the command-line:
reset the admin password
run a health check on the application
change configuration settings
encrypt/decrypt the connection information stored in the application's config file
Note: Most of these tasks can be performed within Symphony's Admin interface.
Using dt
On the server where Symphony is installed, open a Command Prompt window (Terminal on Linux) and navigate to the tools installation subfolder. On Windows, type dt followed by a command, and on Linux, type ./dt.sh followed by a command.
For example, type dt help or ./dt.sh help to get the help page for this tool.
Each command has further help, which you can view by adding typing the command name after help.
For example, enter dt help setConfigValue on Windows to see the syntax for setting a configuration value.
Commands
resetAdminPassword
This command lets you reset the administrator password for Symphony.
See How to Reset the Admin Password.
setConfigValue
Use this command to set a configuration value.
See Set a Configuration Value From the Command Line.
healthCheck
Perform a health check on the Symphony application and its databases with option to fix errors.
See Health Check.
configFile
Encrypts or decrypts the sensitive information stored in the dbi.config file, such as application database connection information.
connectionConfig
instead.connectionConfig
Encrypts or decrypts the connection information for the application database stored in Symphony Managed Dashboards and Reports Config File.
configFile
instead.Examples:
To encrypt the application database connection string:
dt connectionConfig decrypt
To decrypt the application database connection string:
dt connectionConfig decrypt
export
Exports the application data into a DBIE file. Syntax:
<application database connectionstring> – The connection string of the application database. If not specified, the value will be taken from the dbi.config file located in the App_Data folder specified in the dt.exe.config file.
<application database storage type> – The application database server type. If not specified, the value will be taken from the dbi.config file located in the App_Data folder specified in the dt.exe.config file. The argument is optional. Valid values: "SqlServer", "Postgres".
<export configuration file> – The export configuration input file, generated using getExportConfigFile (see below). The argument is mandatory, unless the alternative argument <export configuration identifier> is provided. If this or an alternative argument is not explicitly provided, the value is read from standard input.
<export configuration identifier> – The ID of the export configuration saved in the application. The argument is mandatory, unless the alternative argument <export configuration file> is provided. To find its ID, select the existing configuration and click Details in the toolbar.
<DBIE export file> – The output DBIE export file name (mandatory).
<export report file> – The export report file name (optional).
Example using an export configuration file:
dt export /ecf:"C:\temp\Export Configuration 1.json" /dbie:"C:\temp\Export 1.dbie" /report:"C:\temp\Export 1 report.txt"
Example specifying optional connection information and using a saved export configuration ID:
dt.exe export /appcs:"Data Source=localhost; Initial Catalog=DundasApp; Integrated Security=True" /appStorage:SqlServer /ecid:fab25279-e3a d-4885-8b8c-11d73a38ae62 /dbie:"C:\temp\Export 1.dbie"
getExportConfigFile
Generates an export configuration file that can be used to export (see above).
Syntax:
dt getExportConfigFile [/appcs:<application database connection string>] [/appStorage:<application database server type>] /name:<export co nfiguration name> /file:<export configuration output file>
<application database connectionstring> – The connection string of the application database. If not specified, the value will be taken from the dbi.config file located in the App_Data folder specified in the dt.exe.config file.
<application database storage type> – The application database server type. If not specified, the value will be taken from the dbi.config file located in the App_Data folder specified in the dt.exe.config file. The argument is optional. Valid values: "SqlServer", "Postgres".
<export configuration name> – The name of the existing export configuration (mandatory). For details on creating an export configuration see Import and Export a Project.
<the export configuration output file> – The export configuration output file (mandatory). Will be created if does not exist or overwritten if exists.
Example:
dt getExportConfigFile /name:"Export Configuration 1" /file:"C:\temp\Export Configuration 1.json"
import
Imports application data from a DBIE file.
Syntax:
dt import [/appcs:<application database connection string>] [/appStorage:<application database server type>] [/dbie:]<DBIE export file> [/ report:<import report file>]
<application database connectionstring> – The connection string of the application database. If not specified, the value will be taken from the dbi.config file located in the App_Data folder specified in the dt.exe.config file.
<application database storage type> – The application database server type. If not specified, the value will be taken from the dbi.config file located in the App_Data folder specified in the dt.exe.config file. The argument is optional. Valid values: "SqlServer", "Postgres".
<DBIE export file> – The input DBIE export file. If not provided, the value will be read from standard input.
<import report file> – The output import report file (optional).
Example:
dt import /report:"C:\temp\Import 1 report.txt"
deleteOldEntityData
Deletes old entity revisions.
Syntax:
dt deleteOldEntityData [/appcs:<application database connection string>] [/appStorage:<application database server type>] [/beforeDate:<be fore date>] [/entityIds:<entity IDs>] [/tenantIds:<tenant IDs>]
<application database connection string> – The application database connection string (optional). If not specified, the value will be taken from the dbi.config file located in the App_Data folder specified in the dt.exe.config file.
<application database storage type> – The application database server type. If not specified, the value will be taken from the dbi.config file located in the App_Data folder specified in the dt.exe.config file. The argument is optional. Valid values: "SqlServer", "Postgres".
<before date> – Only revisions created before this date will be processed (optional). If not specified, all revisions will be processed. Parsed as local time.
<entity IDs> – A comma-separated list containing the IDs of entities to process (optional). If not specified, all entities will be processed.
<tenant IDs> – A comma-separated list containing the IDs of tenants to which the operation will be limited (optional). If not specified, all tenants will be included.
Example:
dt deleteOldEntityData /beforeDate:"2017-01-02 00:12:00" /entityIds:1b7c71af-4704-430c-b647-6046aa40728a,65f5f5ad-dfdb-4302-94ea-1593f1737456 /tenantIds:306fcf43-a2ad-4c99-b2db-27f89b7da895,c24e7c1b-0d53-4057-8f12-9318cf8e4935
manageExtensions
Use this command to manage extensions.
Example:
To view the list of extensions (custom extensions display Resource in the IsResource column):
dt manageExtensions List
For more information, see:
Comments
0 comments
Please sign in to leave a comment.