OZEKI NG SMS Gateway
"The World's most reliable SMS gateway software!"
info@ozekisms.com
Tel.: 00 36 52 532 731
Overview Quick start Download Manual How to buy FAQ Contact Us
OZEKI NG SMS Gateway - Product Guide

Addressbook Contents | SearchMySQL addressbook

Home > Product Manual > User Guide > User Interface > Users and applications > Addressbook > Addressbook types

SMS Gateway SMS Gateway Home

  Product Manual
  Introduction
  SMS technology
  Installation Guide
  User Guide
  Quick Start Guide
  User Interface
  Menu
  Toolbar
  Service Provider Connectivity
  Users and applications
  Export messages to Excel
  Addressbook
  Addressbook types
  MySQL addressbook
  Shared database
  Import/Export addressbook
  Separate addressbook for each user
  Ozeki SMS Client
  Sound and Alerts
  Schedule SMS sending
  Send message to multiple recipients
  Send message to contact groups
  Configuration
  Client software
  Administrator's guide
  Developers Guide
  Examples and Solutions
  Appendix
  FAQ
  Feature list
  Commercial Information
  Search
 


Automated phone calls?
Ozeki Phone System XE VoIP PBX software is an advanced PBX built for automated voice calls and 2 way SMS messaging. It has outstanding APIs for software developers. It can be used for:

Phone calls from SQL
Phone calls from HTTP
Voice and SMS applications

Callcenter developers
If you are working on telephone solutions, please check out the Ozeki VoIP SIP SDK.
It can be used to create VoIP client and server software.

Contact Us!
If you wish to get further information, do not hesitate to contact us!

E-mail: info@ozekisms.com

If you have a technical question, please submit a support request on-line.

Addressbook types in Ozeki NG SMS Gateway


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
Driver={MySQL ODBC 5.1 Driver};Server=IPaddress;Database=DBname;User=UserName;Password=PassWord;Option=4;
 

Create table script for MySQL
CREATE TABLE  `contact` (
       `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
       `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` DATE NOT NULL
);

CREATE TABLE  `contactGroup` (
       `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
       `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
);

 

On Contacts tab you can specify the SQL statements of the contacts: for Load, Create, Delete, and Update fields (Figure 12).


Figure 12 - Contacts tab

If you use MySQL please replace Create statement in Contacts tab to the follows:

Create statement
INSERT INTO Contact (name, mobile, telephone, fax, email, im, other, comment, createTime) VALUES
('$name', '$mobile', '$telephone', '$fax', '$email', '$im', '$other', '$comment', '$createTime');
SELECT last_insert_id();


On Groups tab you can define the SQL statements of groups for Load, Create, Delete, and Update fields (Figure 13).


Figure 13 - Groups tab

If you use MySQL please replace Create statement in Groups tab to the follows:

Create statement
INSERT INTO ContactGroup (name, useraccount, subscribekeyword, greetingmessage, unsubscribekeyword,
byemessage, allowsubscription) VALUES ('$name', '$useraccount', '$subscribekeyword', '$greetingmessage',
'$unsubscribekeyword', '$byemessage', '$allowsubscription'); SELECT last_insert_id();


SQL statements can also be specified for members on Membership tab: Load, Add to group, and Remove from group (Figure 14).


Figure 14 - Membership tab

Dig deeper!
People who read this also read...


MySQL addressbook
Shared database
Addressbook
Import/Export Addressbook
Separate addressbook for each user in Ozeki NG SMS Gateway
Graphical user interface





Next page: MySQL addressbook
Copyright © 2000 - 2014 Ozeki Informatics Ltd.
All rights reserved

Software PBX for Windows | VoIP SDK   |   Legal information   |   Privacy policy   |   Terms of use
Please, address your inquiries to info@ozekisms.com