- Product Manual
- Introduction
- Installation Guide
- User Guide
- Developers Guide
- Examples and Solutions
- Telephone networks
- SMS Pin game
- E-mail to SMS alert
- 2 way SMS to Email gateway
- SMS Order System
- Asterisk PBX SMS
- SQL SMS Gateway
- Service Provider
- SMS PIN code query
- SMS Counter game
- SMS newsgroup
- Distributed SMS
- SMS Menu
- Google maps
- Forwarding
- Birthday greeting - SQL Express
- Birthday greeting - MySQL
- Birthday greeting - Oracle
- Instant brochure - MMS autoreply
- Alphabet letter game
- SMS sport betting service
- E-mail about outgoing SMS messages
- SMS Information Menu
- Email to SMS feature
- Reminder example
- Bulk SMS Client
- Bulk SMS to a given phone number range
- Filtering phone numbers
- Ozeki Phone Sytem PBX SMS
- Autoreply voucher example
- Appendix
- SMS FAQ
- Feature list
- Commercial Information
- Search
Ozeki brings you outstanding
SMS Gateway technology. Use our SMS Server products on Windows,Linux, or Android
C# SMS API
Developers can use our C# SMS API to send SMS from C#.Net. The C# SMS API comes with full source code
PHP SMS API
The ozeki PHP SMS gateway software can be used to send SMS from PHP and to receive SMS usig PHP on your website
SMPP SMS Gateway
SMS service providers use our SMPP gateway solution, that offers a high performance SMPP server and SMPP client gateway with amazing routing capabilities
How to setup Ozeki NG SMS Gateway Autoreply voucher sender
Find an Autoreply example on this page that will demonstrate how to build your own SMS system to introduce voucher service for your customers. To implement this solution effectively and properly please follow the configuration guide below this page.
Configuration guide
Step 1 - Installing Ozeki NG SMS Gateway software
In order to start using Ozeki NG SMS Gateway, first you need to install it to your computer. If you have any problem during the installation process, just follow this guide: Installation Steps.
Step 2 - Connecting the gateway to your service provider
After you have installed the two Ozeki NG SMS Gateway software products, you need to setup at least one service provider connection to send out your SMS messages. There are two ways of sending SMS messages:
- GSM modem
- IP based service provider connections, such as SMPP, HTTP, UCP etc.
You can configure the service provider connections based on the guides that can be found here.
Step 3 - Configuring MySQL
To setup Autoreply service a database table is needed that will hold voucher information. Here is the table definition:
CREATE TABLE IF NOT EXISTS `voucher` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher` int(11) DEFAULT NULL, `phonenumber` varchar(100) DEFAULT NULL, `date_time` timestamp DEFAULT NULL, PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
Now a stored procedure has to be created in your database server which will help you to create the random voucher.
First you need to login to your database management software. You can use mysql console, phpmyadmin or any other management software. Then select the database in which you created the voucher table and issue the following create script.
DELIMITER $$ CREATE PROCEDURE Getphonenumber( IN phone varchar(100)) BEGIN DECLARE random INT(11); SET random = (select UNIX_TIMESTAMP()+FLOOR(RAND()*1000)+FLOOR(RAND()*9999)); IF random NOT IN (SELECT voucher FROM voucher) THEN INSERT INTO voucher (phonenumber,voucher, date_time) VALUES(phone, random, NOW()); SELECT phone, random; END IF; END $$ DELIMITER ;
Step 4 - Adding new Autoreply Database user and modifying it.
After you have created the table and the stored procedure, you need to add a new Autoreply Database user to your Ozeki NG SMS Gateway software product.
In order to connect the gateway to a MySQL database, first you need to install a MySQL ODBC Driver to your Windows operating system and then add a new data source to it which will be connected to your database server.
If you have added the new data source, return to your Ozeki NG SMS Gateway, install a new Autoreply Database user and provide a connection string (related to your database server) under the Database connection tab in the Connection String textbox and select ODBC from the Connection string type dropdown menu.
Driver={MySQL ODBC 5.1 Driver};Server=localhost; Database=voucher;User=root;Password=qwe123;Option=4;
Now go to the Autoreply script tab and add the path of the sqlscript.txt which default is C:\Program Files (x86)\Ozeki\OzekiNG - SMS Gateway\Config\Autoreply\sqlscript.txt. You have to open this file, delete the last row and add to the following line CALL Getphonenumber ("$sender");
This guide shows you a solution how to send Autoreply voucher message using Ozeki NG SMS Gateway software product. The stored procedure can also be created in different ways. It is also possible to use other database servers, such as MSSQL or Oracle.
If you have any other question, please send us an e-mail at info@ozekisms.com.
More information
- Autoreply voucher example
- Ozeki Phone Sytem PBX SMS
- Email to SMS feature
- Reminder example
- SMS PIN code query
- Bulk SMS Client
- Sending e-mail alert SMS messages
- Bulk SMS to a given phone number range
- High volume SMS messaging
- SMS Service Provider Connectivity
- Users and SMS Applications