How do I export extensions from Topaz into Emerald?

[Belinda Frick]

1. Open a Notepad document and enter the following text:

select A."Extension", "=", A."Extension", A."User" From Extensions A

Then save it with a .sql extension.


2. Open Topaz and go to Queries.

3. Click on Open Query and select the above file.

4. The grid will be populated.

5. Right-click on the grid and Export.

6. Open the file you just exported in Notepad.

7. Do a Search and Replace and replace ","="," with =EXT

8. Do another Search and Replace and replace " with a blank.

9. Copy the contents of the file to the Emerald ini file.