Export Topaz Phone book to TNG Phone book

[Leon van Heerden]

The following SQLs can be used to export the Topaz Phone book to a CSV file format that can then be imported into TNG.

Please take the following into consideration:

1. Topaz has a Person and Company field in the phonebook, TNG has a Description and a Category field inthe phone book.
2. The SQLs can either save just the person or just the Company as the Description, or you can save the person as the Description and the Company as the Category.
3. The SQL will only export entries that has a person or company names filled in. Entries where both fields are blank, will not be exported.
4. You will have to edit the CSV files a bit, since Topaz exports the data with double quotes around the text fields. A simple search and replace in notepad will work.

This SQL will Export all the Topaz Person entries as TNG Descriptions and the Topaz Companies as TNG Categories.

Code: Select all

Select A."Number", A."Person" , A."Company", A."private" from Master A where (A."Person" <> '') or (A."Company" <> '')

This SQL will Export all the Topaz Person entries as TNG Descriptions and will leave the TNG Categories blank.

Code: Select all

Select A."Number", A."Person" , "", A."private" from Master A where (A."Person" <> '')

This SQL will Export all the Topaz Company entries as TNG Descriptions and will leave the TNG Categories blank.

Code: Select all

Select A."Number", A."Company" , "", A."private" from Master A where (A."Company" <> '')

Once the double quotes (") has been removed, please save the file as phonebook.txt in the 'Import' folder located in the 'C:\Program Files\Datatex\TNG' directory. You may create an Import folder if not present.

Please Note: Your existing TNG phonebook entries will be replaced with this import. Ensure that all entries are correct before importing into TNG.

Use the Topaz Query facility to execute these SQLs and then save the results to CSV files.