SEND SMS ALERT FROM YOUR SYSTEM: Twitter Joomla HP Openview WhatsUp Gold Sharepoint Notes
    
Home Solutions Applications Industries Products About Us
    
OzekiNG-SMS-Gateway.zip (5 MB)
for Windows XP,2000,2003,2008,Vista,Windows 7
free 20 day trial version
Menu
  Welcome page
  Solutions
  Applications
  General information
  Network management
  CRM
  Workflow management
  Helpdesk
  SQL database
  Interbase
  Visual FoxPro
  E-mail
  Website
  Two-factor authentication
  SMS Examples
  Products
  Contact
  Sitemap

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

E-mail: info@sms-integration.com

Useful information
How to send SMS with a GSM modem attached to your PC?


This solution is best if you are planning to send or receive up to 4000 SMS per day. Read more:
  • Prerequisites
  • Setup instructions
  • Video tutorial


    How to send SMS through the Internet?


    If you wish to send more then 4000 SMS per day, it is a good idea to use an Internet SMS service provider. Read more:
  • Prerequisites
  • Setup instructions
  • Automate phone calls!

    Ozeki Phone System XE - VoIP PBX Software is an excellent tool for making automated phone calls.

    Send and receive SMS in Visual FoxPro

    Visual FoxPro is a data centric and object oriented database to make well-organized data storage possible. Now there is a great possibility to improve your Visual FoxPro by adding SMS functionality to it. With this function you will be able to send and receive important data and information in your database to mobile phones. This functionality can be provided by a stable SMS gateway such as Ozeki NG SMS Gateway. Ozeki NG SMS Gateway is a software product that can be installed on your computer. It forwards SMS messages to the mobile network either with a GSM modem attached to the computer or over IP SMS connection. If you implement Ozeki NG SMS Gateway to transmit SMS messages you will gain a high secure and stable SMS system that improves corporate communication. In this article you will find further information on this solution.

    Video: Send SMS from Visual FoxPro (part 1/2, configure your modem)
    Video: Send SMS from Visual FoxPro (part 2/2, configure your system)

    Fields of application

    Visual FoxPro is a data centric and object oriented database that can be used to maintain a well-structured corporate IT system. Now there is a great possibility to increase the features of Visual FoxPro to be more efficient.

    If you wish to further improve your Visual FoxPro database you can add SMS functionality to it. SMS technology makes it possible to improve corporate communication in a large extent. If you add SMS functionality to your database then you ensure that all the important changes will be forwarded to the intended people. Dealing with huge amount of data is important in companies as there are constant changes in their databases. With Ozeki's solution, information about these changes can be easily and very rapidly forwarded to the intended people.

    To achieve this SMS functionality you need to install an SMS gateway on your computer such as Ozeki NG SMS Gateway. This software product is able to meet with all the requirements of companies because it is a stable and well-functioning software with high capacity. In this way you can send SMS messages from your corporate IT system to the mobile phones of the intended people. The benefits can be immediately noticed. With this solution your colleagues, employees but even your customers or business partners can be informed in a practical way. You can send short but important information to these people and it is quite sure that they will receive your message immediately. Therefore the communication of your company is highly improved both within and outside of the company.

    Prerequisites

    In order to setup this solution you need to find a way to connect your system to the mobile network. You can do this by using an Internet connection or you can setup a wireless connection by attaching a GSM phone/GSM modem to your computer. To help you make a decision, we have prepared a webpage for you: Internet based SMS connections vs. GSM modem based (wireless) SMS connections. Depending on what you select, you need the following prerequisites.

    Prerequisites for Internet based connection to the Mobile network

    If you wish to connect your system to an SMS service provider over the Internet you need the following components:

    Figure 1/a - Prerequisites for Ozeki NG SMS Gateway IP SMS connection

    In this case you need to find an SMS service provider who can reach the mobile phones in your area. This SMS service provider should be able to provide SMS service through the Internet. To find such a provider, you can check our website where we list some of them: SMPP SMS Service providers. Once you have found such a provider, you need to sign up for their service to get the connection parameters. You can use these parameters to configure your Ozeki NG SMS Gateway software.

    Prerequisites for wireless (GSM modem) connection to the Mobile network

    If you wish to connect your system to the mobile network wirelessly, you need a GSM modem or GSM phone, that you can attach to your computer with a data cable. In this case your Ozeki NG SMS Gateway software will operate this phone and will send and receive SMS messages wirelessly. To setup this connection method, you need the following components:

    Figure 1/b - Prerequisites for Ozeki NG SMS Gateway GSM modem connection

    Your checklist (for GSM modem connection):

    SIM Card - You can get this from your local mobile network operator.*
    Modem - Use a Wavecom, Siemens or Multitech modem.
    Data cable - Comes with the modem
    Computer - Recommended: Intel P4 3Ghz, 2GB RAM, 500Mb HDD, Windows OS
    Ozeki NG SMS Gateway - Download it from http://www.sms-integration.com
    Visual FoxPro

    *The SIM card will come with a plan, that will determine how much money you will spend on each SMS.
    Ozeki NG SMS Gateway can be obtained by
    opening the download page:
    Download Ozeki NG SMS Gateway!

    System architecture

    After you make sure you meet the requirements above, you can start to build your SMS system. It will work as follows: In case of incoming messages, Ozeki NG SMS Gateway inserts the message into Visual FoxPro by an SQL INSERT statement and you can read your incoming message. If you wish to send messages from FoxPro then Ozeki NG SMS Gateway polls the message out from the database by an SQL SELECT statement, processes it and finally sends out to mobile phones. Figure 2 demonstrates this process.

    Figure 2 - Ozeki NG SMS Gateway - solution for SMS sending in Visual FoxPro

    Ozeki NG SMS Gateway forwards messages to the mobile network either with the help of a GSM modem attached to your PC with a data cable or it connects directly to the SMS center of the mobile service provider over the Internet. Please note that GSM modem connection is highly recommended as it is more secure than IP SMS connectivity.

    How to configure this solution

    To send and receive SMS in Visual FoxPro you need to make some simple configuration in Ozeki NG SMS Gateway. To apply this solution properly please follow the steps of our configuration guide and watch this video tutorial as well.

    Video: Send SMS in Visual FoxPro (configure your system)

    First you need to create a new database and then two database tables for incoming and outgoing messages: "ozekimessagein" and "ozekimessageout". To create these tables start Visual FoxPro at "All programs" in "Start" menu (Figure 3).

    Figure 3 - Start Visual FoxPro

    Then click on "New" menu item in "File" menu (Figure 4)

    Figure 4 - Select New

    Select "Database" option and "New file" button (Figure 5).

    Figure 5 - New database

    Define a location where you wish to save the created database. In our example it is "ozeki_visual_foxpro_db" folder in C drive (Figure 6).

    Figure 6 - Select a folder for the database

    Provide a name for the database (in our example it is "ozeki") and click on "Save" (Figure 7).

    Figure 7 - Provide a name for the database

    Expand the command window and clear its content (Figure 8)

    Figure 8 - Cleared command window

    Then paste these table definitions into the command window (Figure 9):

    CREATE TABLE ozekimessagein;
    (id INT(4) autoinc,;
    sender Varchar(30) NULL,;
    receiver Varchar(30) NULL,;
    msg Varchar(160) NULL,;
    senttime Varchar(100) NULL,;
    receivedtime Varchar(100) NULL,;
    operator Varchar(30) NULL,;
    msgtype Varchar(30) NULL,;
    reference Varchar(30) NULL);


    CREATE TABLE ozekimessageout;
    (id INT(4) autoinc,;
    sender Varchar(30) NULL,;
    receiver Varchar(30) NULL,;
    msg Varchar(160) NULL,;
    senttime Varchar(100) NULL,;
    receivedtime Varchar(100) NULL,;
    operator Varchar(30) NULL,;
    msgtype Varchar(30) NULL,;
    reference Varchar(30) NULL,;
    status varchar(30) NULL,;
    errormsg varchar(250) NULL);


    Figure 9 - Pasted table definitions

    Now select all the definitions and right click on them and select "Execute Selection" option (Figure 10).

    Figure 10 - Execute table definitions

    If it is done, close the command window the created database tables will appear in the database (Figure 11).

    Figure 11 - Created tables

    The configuration of the database is finished, now you can start to configure Ozeki NG SMS Gateway. First log into Ozeki NG SMS Gateway with your username and password. Then click on "Add new user or application" (Figure 12).

    Figure 12 - Add new user

    Select "Database user" and click on "Install" next to it (Figure 13).

    Figure 13 - Install database user

    Provide a name for this user. In our example it is "visual_foxpro" (Figure 14).

    Figure 14 - Provide a name

    In "Database connection" tab provide the connection string and click on "OK" (Figure 15).
    Connection string:

    Provider=VFPOLEDB.1;Data Source=PathToYourDatabase;Mode=ReadWrite;Password="";Collating Sequence=MACHINE

    After the "Data Source=" part provide the full path to the created database.

    Figure 15 - Connection string for the user

    Now click on "SQL for sending" tab and modify the SQL update statements. To do so, you need to delete the apostrophes after "WHERE id=" part in the update statements. First go to "Sending" tab and modify the "UPDATE" statement in a way that the final statement should look like this (Figure 16):

    UPDATE ozekimessageout SET status='sending' WHERE id=$id


    Figure 16 - SQL statement for sending

    Then you need to modify other update statements as well. The statement in "Sent" tab is (Figure 17):

    UPDATE ozekimessageout SET status='sent', senttime='$senttime' WHERE id=$id

    Figure 17 - SQL statement for sent

    The statement in "Not sent" tab is (Figure 18):

    UPDATE ozekimessageout SET status='notsent' WHERE id=$id

    Figure 18 - SQL statement for not sent

    The statement in "Delivered" tab is (Figure 19):

    UPDATE ozekimessageout SET status='delivered' WHERE id=$id

    Figure 19 - SQL statement for delivered

    The SQL statement in "Undelivered" tab is (Figure 20)

    UPDATE ozekimessageout SET status='undelivered' WHERE id=$id

    Figure 20 - SQL statement for undelivered

    In order to demonstrate this process in a better way I enable "Log SQL SELECT statements" and "Log SQL UPDATE statements" (Figure 21).

    Figure 21 - Logging

    To test the system click on "SQL Prompt" menu item and select the following statement from the dropdown menu: "INSERT INTO ozekimessageout (receiver,msg,status) VALUES ('+36205460691' , 'Hello World' , 'send');" Then click on "Execute" (Figure 22). This SQL statement will insert a row into "ozekimessageout" table which will be sent out by Ozeki NG SMS Gateway as an SMS message.

    Figure 22 - Create an outgoing message

    If you inserted the outgoing message into "ozekimessageout" table, after a short period of time you can see in the "Events" of the created database user that the outgoing message has been found and updated by Ozeki NG SMS Gateway and finally it has been sent as an SMS message (Figure 23).

    Figure 23 - Found outgoing message

    The sent message can be seen in the "Outbox" of the created database user (Figure 24).

    Figure 24 - Sent message of database user

    For demonstrating incoming messages I will simulate an incoming message over SMPP connection (Figure 25).

    Figure 25 - Received message

    By clicking on the "Events" of the created database user it can be seen that the incoming message has been inserted into "ozekimessagein" table (Figure 26).

    Figure 26 - Inserted message

    To see the incoming message click on "SQL Prompt" menu item and select "SELECT*FROM ozekimessagein" statement and click on "Execute" (Figure 27).

    Figure 27 - Select fields from ozekimessagein

    As a result the received message can be seen (Figure 28).

    Figure 28 - Received message

    Conclusion

    Visual FoxPro with Ozeki NG SMS Gateway is the best solution if you wish to implement an efficient SMS system in your corporate IT network. Ozeki's solution makes it possible to send important data and information from Visual FoxPro to multiple mobile phones if it is required. With this solution you will gain a stable, well-functioning and secure SMS system that is easy to work with and save valuable time and money.

    Request more information

    If you are interested in this solution, let us know, so we can send you more relevant information and quotation with prices. Please fill in the following form:


    Your name:
    Company:
    E-mail:
    Tel:
    Country:
    Message:
     
    Home > Applications > SQL database > Visual FoxPro
    Feel free to contact us for additional information. Tel: (36) 52 532 731, Fax: (36) 52 532 732, E-mail: info @ ozekisms.com
    Copyright © 2000 - 2014 Ozeki Informatics Ltd. - All rights reserved.