Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Section
Column
width70%

 T

he address book of the T300/500 PBX system provides access to important or frequently used phone numbers and a detailed view of each entry.

Click on

...

Address book in the menu bar.

The contacts can be called directly from the address book:

You can use up to 8000 entries.

...

Adding entries

  • Click on New Contact in the

...

  • address book view. An editing window opens with all fields for the contact's address book and detailed view.
  • Import entries using a CSV-file

Import entries using a CSV-file

  • Click on Import to upload your CSV-file

ImportAdressBook.jpgImage Modified

  • Click on Download to create the template for your CSV-file.

  • Add your contacts into this file.

  • Click on Import to upload the contacts.

Delete entries

  • Delete the entries one by one by clicking the X in the addressbook view.

  • The complete address book from the command line.

Delete complete address book

  • Login the the PBX using SSH.

  • On the command line. psql asterisk

...

 

Background Color
#C0C0C0
#C0C0C0

[root@T300

...

~]#

...

psql

...

asterisk

...


Welcome

...

to

...

psql

...

8.3.12,

...

the

...

PostgreSQL

...

interactive

...

terminal.

...

Type:

...

  \copyright

...

for

...

distribution

...

terms
          \h

...

for

...

help

...

with

...

SQL

...

commands
          \?

...

for

...

help

...

with

...

psql

...

commands
          \g

...

or

...

terminate

...

with

...

semicolon

...

to

...

execute

...

query
          \q

...

to

...

quit

...

asterisk=#

...

  • Check if the table person exists. select * from person;

...

Background Color
#C0C0C0
#C0C0C0

  asterisk=#

...

select

...

*

...

from

...

person;

...


       id  | accountid |     familyname      |          firstname          | folder
    ------+--------------+--------------------+-

...

-----------------------------+--------

...


        0 |            0 | Nobody          |                               |      0
   1000 |      1000 | Eric                | Kantoor                   |      0
   1034 |      1038 | Prive               | Prive                       |      0

  •     To delete the complete address book. delete FROM person WHERE id > 0 and accountid = 0;

...

  •   
Background Color
#C0C0C0
#C0C0C0

asterisk=#

...

delete

...

FROM

...

person

...

WHERE

...

id

...

>

...

0

...

and

...

accountid

...

=

...

0;

...

  DELETE 323  asterisk=#

  
  • To exit the postgres database.

...

 

Background Color
#C0C0C0
#C0C0C0

asterisk=#

...

\q

 

 

 




Column
width30%

Table of Contents