This page demonstrates the addressbook types available in
Ozeki NG SMS Gateway. Please read this description page and follow the screen
shots to learn the various types and their functions.
In this example I login as user admin to Ozeki NG SMS
Gateway. To be able to configure the addressbook, click on the respective
user (Figure 1).
Figure 1 - Click on the user
Click on Configure and select Advanced tab on the
configuration pane (Figure 2).
Figure 2 - Select Advanced tab
In the section called Addressbook, you can specify the
Type of Addressbook.
File Addressbook
In this case File Addressbook is selected
(Figure 3). File addressbook ensures that contacts will be stored in a file.
Figure 3 - File addressbook
Click on Configure under Addressbook section
(Figure 4).
Figure 4 - Addressbook configuration
On General tab you can see the directory of the
addressbook but please note that it cannot be configured (Figure 5).
Figure 5 - Directory of addressbook
LDAP Addressbook
If you select LDAP Addressbook as the addressbook on
Advanced tab, then contacts will be selected from LDAP (for
example, Active Directory)
(Figure 6).
Figure 6 - LDAP addressbook
Go to Configure and click on Addressbook
configuration. On General tab you can specify the parameters such as
Host (in this example Active Directory is on computer 192.168.91.190)
(Figure 7).
Figure 7 - Specify parameters
On Attributes tab you can configure how contacts should
be search for (Figure 8).
Figure 8 - Attributes tab
Figure 9 demonstrates that three contacts has been imported
and appeared in the addressbook.
Figure 9 - Imported contacts
SQL Addressbook
You can also select SQL Addressbook type on Advanced
tab (Figure 10). In this case contacts will be stored and uploaded from an SQL
database.
Figure 10 - SQL addressbook
To configure the addressbook, click on Configure and on
Addressbook configuration. On Connection information tab you can
specify the Connection string with which the system connects to the
database (Figure 11).
Figure 11 - Connection string
First you need to create database tables:
MSSQL
Create table script for MSSQL Server
CREATE TABLE contact (
id int IDENTITY (1,1) not null,
name varchar(50) not null,
mobile varchar(255) not null,
telephone varchar(255) not null,
fax varchar(255) not null,
email varchar(255) not null,
im varchar(255) not null,
other varchar(255) not null,
comment varchar(255) not null,
createTime DateTime not null
);
CREATE TABLE contactGroup (
id int IDENTITY (1,1) not null,
name varchar(50) not null,
useraccount varchar(50) not null,
subscribekeyword varchar(50) not null,
greetingmessage varchar(50) not null,
unsubscribekeyword varchar(50) not null,
byemessage varchar(50) not null,
allowsubscription varchar(5) not null
);
CREATE TABLE membership (
groupId int not null,
contactId int not null
)
MySQL
You can connect to MySQL with this connection string: Connection string