Conversion Wizard

The Conversion Wizard allows you and CXT Software staff to import or export various tables of data from the Operations App. 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.

  1. Go to Tools.

  2. Click Conversion Wizard.

How to Use

Using the Conversion Wizard incorrectly can damage your Operations App 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 the Operations App, 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.

  4. Click Process.

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.

Import

When importing data, 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.