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.
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
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 - Stop service
Download System Database
Importer if you haven't done so and start it. Click on the browse button
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
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.
Switch from file