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

Import messages Contents | SearchHTTPS

Home > Product Manual > Installation Guide > Installation Steps > System database > Switch from file

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 switch from File to Database

In this brief overview you can read what you need to do if you have stored messages in a file and now you wish to switch to database.

By default, messages of all users are stored in a file. These files are stored in the folders of users (for example, the messages of user admin are also stored in file) (Figure 1).


Figure 1 - Messages of users are stored in file

On Figure 2 you can see the sent messages of user admin stored in file. The file names of these messages are their GUID.


Figure 2 - Sent messages of user admin in file

If user admin sends out messages, sent messages will be stored in file. Then messages are forwarded to the SMSC (SMS center) that returns a delivery report about messages. These delivery reports will be matched with the messages stored in the file (Figure 3).


Figure 3 - Sending messages with file

However, files are easy to work with, if Ozeki NG SMS Gateway needs to process great numbers of messages the system can slow down because of the hard disc usage. Since Ozeki NG SMS Gateway stores messages in 7 Kb files, hard disc is engaged to a great extent.

Switch to database

This situation can be avoided by switching to database. Practically it means that messages will be stored in a database instead of files that will ensure a faster system (Figure 4).


Figure 4 - Messages stored in database

In case of sending messages, messages will be stored in the database and the returned delivery reports will be matched the original messages stored in the database (Figure 5).


Figure 5 - Sending messages with database

Now if you stored your messages in file and switch to database problems can occur deriving from the fact that there can still be messages stored in the file to which delivery reports have not been returned yet. After switching to database, delivery reports will still be returned to messages that have been stored in file. But since the storage in file option is disabled, Ozeki NG SMS Gateway will only look for original messages in the database (and not in file any more). So if there is a delivery report that is returned for a non-existing message (messages that were originally stored in file) the following error message will appear:

ERROR 2202:
Cannot find corresponding envelope for incoming delivery report in sent items. Missing envelope ID: msgID


Figure 6 - Error when try to match the original message

To solve this issue you can use Message importer that will allow you to import messages from file to database. Therefore, the system will be able to match the delivery reports with messages that have already been imported into the database.

Download message importer

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


How to import messages from File to Database
System database





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