How to import telephone numbers into Topaz

[Belinda Frick]

As you are dialing numbers / receiving calls they are updated into the TOPAZ numbers table. These numbers has no information linked to it. TOPAZ has the facillity to import these numbers with the Person's name and Company Name and you can classify the number as Private or Business. Follow instructions below to do the import.

Required:

• Topaz 1.6.5.0 or newer
• Input file in the specified format.

Installation:

• Create the number file:
  
  Create a text file with the numbers in the following format:
  

  Code: Select all

  Number,Person,Company Name,Number Type

  
  The Number Type is a P or a B relating to a Business or Private number.
  
  If you use EXCEL to create the file,
  save it as CSV (comma delimited).
  
  NOTE: In Excell if your number column is in the wrong format it will remove the leading zero of your telephone number. Please check this before you proceed to import.
  
  When you create the EXCEL file, select the column and change the format to 'TEXT'. Now enter the information required. Save the file as 'comma delimited CSV'. This will ensure that you have leading zeroes. You can check this by opening the csv file in a text editor. Text editor will not automatically format the content as when you open a file in EXCEL. NOTE: if you open the file you created in EXCEL after saving it as CSV, it will again remove the leading zeroes.
  
  Also see: Create Excel file for TOPAZ to import telephone numbers
  
  
• Import the number file into TOPAZ:
  
  Go to DATA > NUMBERS, click on IMPORT NUMBERS...
  
  NOTE: When you import the list, it will assume that the file is the correct and date list and overwrite the in the database.It will not blank any fields. So if you have a number and person, but nothing else entered your text file, only the person name will be updated. The current company name will stay the way it is in the database.