Conversion Wizard

Owned by Michelle Cabaya
May 13, 2022
2 min read

The Conversion Wizard allows you and CXT Software staff to import or export various tables of data from X Dispatch. This tool is an advanced tool and should only be used with the permission of your system administrator.

Where to Start

You can reach the Conversion Wizard from the Tools Menu within X Dispatch.

  1. Go to Tools.
  2. Click Conversion Wizard.

How to Use

Using the Conversion Wizard incorrectly can damage your X Dispatch database. If you have any questions please contact our support department before using this wizard.


Export

The Conversion Wizard exports a CSV file that can be opened in Microsoft Excel. This can be useful if you need to edit data outside of X Dispatch, make an analysis of all the data, or import into another application.

  1. Select the database table(s) you would like to export.
  2. Select Export.

  3. Select options for your export file.

    Export format only: Exports only the column names and not the table data. This can be used to view the structure, or columns in a table, to prepare for an import of new data.

  4. Click Process.

Import

When importing data back into X Dispatch, the Columns must remain in the exact same order as when they were exported. If any column is moved or deleted, the import will fail.

If you are an on premise customer, make a backup of database table(s) before starting the import process.

  1. Select database table(s) you would like to import.
  2. Select Import.
  3. Select whether or not the first row contains a header and the text delimiter of the file you want to import.
  4. Click Process.