Modify user accounts from a flat file
Use the EQCmd.exe utility to add, delete, modify and query user, department and billing code accounts from a flat file. You can also assign users and departments to billing codes. This method is a one-time import and does not synchronize data beyond the import.
Equitrac installs this utility on the accounting server in the Program Files\Nuance\Equitrac\Tools folder.
The command-line utility accepts commands in the following format:
EQCmd -s<Server> <Action> <Obj_type> <Obj_ID>|All [<Options>] Execute the command with a batch file:
EQCmd -s<Server> -f<BatchFile>Command-line parameters enclosed in parentheses < > are mandatory and require a specified value. Parameters within square brackets [ ] are optional entries and do not need to have a specified value if they will not be included in the command. Optional parameters that will be in the command, do require a specified value.
Equitrac accepts CSV files as batch files. Batch operation allows all the command actions except for the “query” command. Use the table below to fill in the parameters.
| Parameter | Variables |
|---|---|
| Server | Specify the name or IP address of CAS. |
| Action | Specify the action to take on the account.
Use one of:
|
| Obj_type | Use one of:
|
| Obj_ID | Applies <action> only to
the specified object ID. Use double quotes around object IDs that
have a space, for example human resources.
To apply <Action> to all accounts of <Obj_type>,
use All. You can use “All”
for “Assign”, “Remove”, “Query”, “Adjust” actions. You cannot use
it for “Add”, “Delete”, “Modify”, “Lock” and “Unlock” actions.
|
| Options for Action Command | Specify additional values.
|