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 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).

send sms from file
Figure 1 - Send 200 SMS from a file

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

sent messages from a file
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).

configure system database
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
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
Figure 5 - Start the importer and browse

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

select ozeki ng sms gateway directory
Figure 6 - Select Ozeki NG SMS Gateway directory

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

import
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).

start service
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).

sent messages from database in ozeki ng sms gateway
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.

More information