Ozeki 10
Ozeki NG SMS Gateway
SMS Gateway
Quick Start Guide
SMS with Client Software
SMS from/to Database
SQL Logging
System Database
MSSQL 2008
MSSQL 2012/2014
Import messages
Switch from file
Message Server 6
SMS Wall
IP SMS Gateway
Android SMS
Excel SMS
Bulk Messenger
Developer tools

Ozeki 10 SMS Gateway
MSSQL 2012/2014 MSSQL 2012/2014 | Switch from file Switch from file

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_v2.exe

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 SMS Gateway has already been installed on the computer and I store messages in a file (Figure 1).

Figure 1 - Send 200 message with Ozeki Performance tester

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

Figure 2 - The message will appear under the user used by Ozeki Message tester

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 settings' for SMS messages

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

Figure 4 - Stop Ozeki 10 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 SMS Gateway directory and click 'OK' (Figure 6).

Figure 6 - Select Ozeki SMS Gateway directory

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

Figure 7 - Import the user files used in Ozeki SMS Gateway

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

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

Figure 8 - Start Ozeki 10 service

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

Figure 9 - From now on the user messages are stored in a database. They will appear under the user.

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.

Copyright © 2000- - Ozeki Ltd |
Home > Products > SMS > SMS Gateway > System Database > Import messages
Legal | Privacy policy | Terms of use
Page: 5797 | Login |