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.

For registered phonebook info to be visible in Totalview, when receiving or making a call, the registered phonenumber must start with +contrycode, and can not contain any space.

File example

“+4520409041”,”SAS Travel Center”,”Postboks 150, 2770 Kastrup”
“+4586128665”,”Radisson SAS Scandinavia Hotel”,”Margrethepladsen 1, 8000 Århus C”
“+4570102000”,”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.