bg

Data Logger Suite: Logging and Monitoring. SMS to database: Writing short messages from a GSM modem into a database. Part II

Download and install our software

Download Data Logger Suite: Logging and Monitoring

Data Logger Suite SMS Edition you can download here. Plugins can be downloaded separately here.

Configuring how to write data to the database

You may choose between two modules to write data with:

ODBC database - it is free, but it cannot save the text message at the moment when there is no connection to the database

SQL Database Pro - it requires a separate license, but it offers some professional features the ODBC database lacks.

Note: The program installation wizard can automatically create the configuration for these modules matching the offered table structure.

Configuring the process of writing data to a database with the ODBC database

  1. Select the module in the list of data export modules

Selecting the data export module for ODBC database
Fig. 9. Selecting the data export module

  1. Enable writing to the database

Enable writing to the database
Fig. 10. Enable writing to the database

  1. Configure a connection to the database: select the ODBC connection and specify advanced settings. If the ODBC connection is not created yet, click Configure. You can find more details about all options and the configuration process in the help file of this module.

Configuring the connection
Fig. 11. Configuring the connection

  1. Link parser items to the columns of the table from the database: import the table description from the database (the Import button) and link the necessary columns. You should either delete unlinked columns from the tree or specify the default values for them.

Linking items and columns
Fig. 12. Linking items and columns

  1. If everything is configured correctly, you will see the message about values successfully written to the database in the main window of the program.

Message about SMS successfully written to the database
Fig. 13. Message about data successfully written to the database

Configuring the process of writing data to a SQL Server 2008 database with SQL Database Pro

The configuration of this module may require the knowledge of your database SQL dialect. First, you should create a table in the database and assign permissions for writing to it.

  1. Select the module in the list of data export modules.

Selecting the SQL Database Pro module
Fig. 14. Selecting the SQL Database Pro module

  1. Enable writing to the database

Enabling writing to the database in the SQL Database Pro module
Fig. 15. Enabling writing to the database in the SQL Database Pro module

  1. Configure a connection to the database: Select the database type and specify the connection settings. You can find more details about all options and the configuration process in the help file of this module. Figure 16 shows a connection string for the database "test" of the Microsoft SQL Express 2008 server located on one computer with the program.

Connection settings for SQL Express 2008
Fig. 16. Connection settings in the SQL Database Pro module

  1. Add an SQL query to the queue and link the parameters of the SQL query of the :P1 type and the parser items.

SQL query
Fig. 17. SQL query

SQL query settings
Fig. 18. SQL query settings

  1. If everything is configured correctly, you will see the message about data successfully written to the database in the main window of the program.

Message about SMS successfully written to SQL Server 2008
Fig. 19. Message about data successfully written to the database

Copyright © 1999 - 2024, AGG Software.
All rights reserved. Terms of use | Privacy policy