Phonebook import

The file is in CSV format.

 

Record layout

 Fieldname Description
Phone number The phone number
Name Name of person or organization having phone number
Address Address of person or organization having phone number

 

 

Remarks

To make sure the imported file has the right format, it will be checked thoroughly. If has the right format, it will be imported elsewhere it will be rejected.
If more than one user detail of a certain type in the file is set to be default, the last imported detail will be set to default.

 

File example

“70102000”,”SAS Travel Center”,”Postboks 150, 2770 Kastrup”
“86128665”,”Radisson SAS Scandinavia Hotel”,”Margrethepladsen 1, 8000 Århus C”
“70102000”,”Imperial Hotel”,” Vester Farimagsgade 9, 1606 København V”

 

 

Totalview’s phonebook can be maintained periodically:

Existing entries in Totalview’s phonebook are deleted and an updated phonebook is inserted. Below are some examples of SQL commands:

 

Deleting the entire phonebook

delete from VI_PHONEBOOK

 

Deleting general entries in phonebook

delete from VI_PHONEBOOKSTANDARD

 

Deleting UserLevel entries in phonebook

delete from VI_PHONEBOOKUSER

 

Deleting UserLevel entries in phonebook for user ‘TT’

delete from VI_PHONEBOOKUSER

where OWNER = ’TT’

 

Insert general entry into phonebook

insert into phonebook

(NUMBER, NAME, ADRESS) values

(‘+298344000’, ‘Formula.fo’, ‘Stiðjagøta 5-11’)

 

Insert TT’s UserLevel entry into phonebook

insert into phonebook

(NUMBER, NAME, ADRESS, USERLEVEL, OWNER) values (‘+298344000’, ‘Formula.fo’, ‘Stiðjagøta 5-11’, 1, ‘TT’)

 

SQL rights

In order to access the Totalview’s SQL Database the necessary rights must be configured in the SQL Server. Configuring the SQL Server is beyond the scope of this documentation. Please see Microsoft SQL Server documentation for help.

To insert entries into the phonebook, user must have necessary rights to table PHONEBOOK.

Manually entered phonebook entries from Admin or Switchboard client are UserLevel entries. While entries imported with Admin are considered as general entries. If an imported entry is changed from within Totalview, the entry is changed to a UserLevel entry. This is because the entry is considered to be more accurate after the change has been applied.
Last edited on October 30th, 2017