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¶
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.