Using the Data Conversion Administration Utility

The Data Conversion Administration Utility allows you to encrypt/decrypt sensitive data (such as a group of Social Security numbers) in your database.

Access and usage of the Data Conversion Administration Utility should be provided only to a system administrator. This utility provides access to highly sensitive data and should be used only in the explicit instance of needing to encrypt or decrypt the driver profile.

Contact your Professional Services representative to obtain the DataConversionAdministrationUtilityInstall.msi needed to install the utility.

Installing the utility

  1. Double click the DataConversionAdministrationUtilityInstall.msi to run the install program.
    A message is shown when the install is completed.

  2. Click Close.

Mass encryption/decryption of Social Security numbers and license numbers

To encrypt/decrypt a group of Social Security numbers and/or license numbers in your database:

  1. Double click the DataConversionAdministrationUtility.exe to open the utility.
    Note: By default, the installer program places the file at

    C:\Program Files (x86)\TMW Systems, Inc\TMW Data Conversion Administration

  2. In the Login window, enter a username and password that has System Administrator rights in the TMWSuite database.
    The Data Conversion Administration Utility window opens.

  3. In the Conversion Type field select one of the following:

    To do this Select

    Encrypt a group of drivers' license numbers

    EncryptDriverLicenseNumber

    Decrypt a group of drivers' license numbers

    DecryptDriverLicenseNumber

    Encrypt a group of drivers' Social Security numbers

    EncryptManPowerProfileSocialSecurityNumber

    Decrypt a group of drivers' Social Security numbers

    DecryptManPowerProfileSocialSecurityNumber

    Encrypt a group of Pay To’s Social Security numbers

    EncryptPayToSocialSecurityNumber

    Decrypt a group of Pay To’s Social Security numbers

    DecryptPayToSocialSecurityNumber

  4. Click Retrieve Data.
    The system retrieves a list of all resources.

    image76

  5. To see which rows will be converted, you can sort the data by clicking the column headings.
    Rows that will be converted are marked as NotDetermined in the Result column.

  6. Click Convert.
    The window refreshes, showing the updated data.

    image77

  7. Click Save to save the conversion.

Mass encryption/decryption of EFS codewords

First available in TMWSuite version 2024.3

If you are using the TMWSuite Add-Ins version of Advances/Fuel Purchases Import, you can use the Data Conversion Administration Utility to encrypt/decrypt EFS codewords.

Follow the steps for encrypting/decrypting Social Security numbers, using these Conversion Type field values as needed.

To do this Select

Encrypt a group of EFS primary codewords

EncryptSecurityCardCodeWord

Decrypt a group of EFS primary codewords

DecryptSecurityCardCodeWord

Encrypt a group of EFS secondary codewords

EncryptSecurityCardSecondaryCodeWord

Decrypt a group of EFS secondary codewords

DecryptSecurityCardSecondaryCodeWord