Ozeki NG SMS Gateway logo OZEKI NG SMS Gateway
"The World's most reliable SMS gateway software!"
info@ozeki.hu
SMS Gateway to send SMS via GSM modem or IP SMS connection Overview SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Quick start SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Download SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Manual SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection How to buy SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection FAQ SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Contact Us SMS Gateway to send SMS via GSM modem or IP SMS connection
OZEKI NG SMS Gateway - Product Guide

MySQL configuration Contents | SearchSwitch from file

Home > Product Manual > Installation Guide > Installation Steps > System database > Import messages

SMS Gateway SMS Gateway Home

  Product Manual
  Introduction
  SMS technology
  Installation Guide
  Prerequisites
  Download Information
  Installation Steps
  System database
  Oracle configuration
  MSSQL 2008
  MSSQL 2012/2014
  MySQL configuration
  Import messages
  Switch from file
  HTTPS
  Firewall on Windows 7
  Firewall on Windows 8
  Firewall on Windows 10
  Service Provider Connections
  Users and applications
  Linux
  User 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.

How to import messages into system database

To be able to speed up sending SMS text messages you can use System Database option of Ozeki NG SMS Gateway that allows storing messages in a database instead of a file. To introduce this option first you need to import your messages from file to database. This page provides you a detailed description on how to import your messages into system database with System Database Importer.

Download: System_Database_Importer.zip

When you switch to System Database, you can receive an error message since the system cannot find messages.
The reason for this: the system searches for messages still in the file but system database stores them in a database. To avoid this error message please download System Database Importer.

Import SMS text messages to system database

For demonstration I send 200 SMS text messages from a file using Ozeki Performance Tester. Ozeki NG SMS Gateway has already been installed on the computer and I store messages in a file (Figure 1).


Figure 1 - Send 200 SMS from a file

Ozeki NG SMS Gateway sent out the 200 messages (Figure 2).


Figure 2 - Sent messages from a file

Now I switch to System Database. In Edit menu select Server Preferences. On Databases tab click on System database settings tab. Here enable Use a database server instead of file system to store message option.
Specify Database connection type and Database connection string (Figure 3).


Figure 3 - Configure System Database

After the configuration stop Ozeki NG SMS Gateway by right clicking on its icon in the system tray and select Stop service option (Figure 4).


Figure 4 - Stop service

Download System Database Importer if you haven't done so and start it. Click on the browse button (Figure 5).


Figure 5 - Start the importer and browse

Select Ozeki NG SMS Gateway directory and click OK (Figure 6).


Figure 6 - Select Ozeki NG SMS Gateway directory

After the form is filled automatically, you just need to click on Import (Figure 7).


Figure 7 - Import

Finally, if you followed the instructions you receive a notification if the Import completed successfully.

Start Ozeki NG SMS Gateway by right clicking on its icon in the system tray and select Start service option (Figure 8).


Figure 8 - Start service

Finally, I sent the imported messages - in this time from the database and not from the file - and you can see that Ozeki NG SMS Gateway has sent the messages out (Figure 9).


Figure 9 - Sent messages from database in Ozeki NG SMS Gateway

In conclusion

With the implementation of System Database Importer you can avoid problematic cases derive from the fact that the system searches for messages still in the file and not in the database. With this solution you can be sure that messages will be imported from the file to the database. In this way you can introduce System Database option easily and successfully into your system to speed up sending great numbers of SMS text messages.

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


System Database





Next page: Switch from file
Copyright © 2000- - Ozeki Ltd | info@ozeki.hu
Home > Product Manual > Installation Guide > Installation Steps > System database > Import messages
Legal | Privacy policy | Terms of use
Page: 2677 | Login | 18.204.2.53