About DTT Import and Export

The DTT Import is a tool used by Administrators to import a company’s destination information from a CSV (comma-separated values) file into the Destination Translations Table (DTT). The DTT is a SQL table that exists in the Upland AccuRoute database. The server and its components use the DTT to route messages to their appropriate destinations. The DTT Import tool is useful for companies that have many destinations that are part of their workflow configuration. Adding, editing, and removing destination records is a quick and easy process with the DTT Import tool.

Import Add

The DTT Import tool performs a query to determine if there is an existing entry. For example, if a fax number does not exist, a new entry is added with the properties defined in the CSV file.

Import Remove

If the fax number exists, the DTT Import tool retrieves its properties, removes the existing entry and creates a new entry after merging existing properties with the new definition.

Import Failures

During the DTT Import process, failed records are skipped and reported after the import is complete at the Command Prompt or in a Log file. See Viewing DTT Import errors for more information.

How routing works after a DTT Import

The Dispatch component checks the DTT to see if the original Email, Fax, Folder and other destination types need to be translated.

Note: In the context of this topic, the use of the term “translated” means “changed”.

The Dispatch component changes the destination to one of the following types.

    Email

  • Device
  • Folder
  • Printer
  • RightFax Connector

It translates the actual destination address by adding the new destination as a localized destination. Fax number translations occur after the Normalization process so DTT fax numbers match normalized numbers.

Routing rules are then applied after the translation takes place. The job will find the appropriate routing rule using the new type and destination.

Before you begin

You must create a CSV file that contains the destination information needed for the DTT Import process.