SMS to database: Writing short messages from a GSM modem into a database. Part II

SMS TO DATABASE: WRITING SHORT MESSAGES FROM A GSM MODEM INTO A DATABASE. PART II

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

FIG. 9. SELECTING THE DATA EXPORT
MODULE

2. ENABLE WRITING TO THE DATABASE

FIG. 10. ENABLE WRITING TO THE DATABASE

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

FIG. 11. CONFIGURING THE CONNECTION

4. LINK PARSER ITEMS TO THE COLUMNS OF THE TABLE FROM THE DATABASE: IMPORT THE TABLE DESCRIPTION FROM THE DATABASE (THE IMPORTBUTTON) AND LINK THE NECESSARY COLUMNS. YOU SHOULD EITHER DELETE UNLINKED COLUMNS FROM THE TREE OR SPECIFY THE DEFAULT VALUES FOR THEM.

FIG. 12. LINKING ITEMS AND COLUMNS

5. IF EVERYTHING IS CONFIGURED CORRECTLY, YOU WILL SEE THE MESSAGE ABOUT VALUES SUCCESSFULLY WRITTEN TO THE DATABASE IN THE MAIN WINDOW OF THE PROGRAM.

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.

FIG. 14. SELECTING THE SQL DATABASE
PRO MODULE

2. ENABLE WRITING TO THE DATABASE

FIG. 15. ENABLING WRITING TO THE
DATABASE IN THE SQL DATABASE PRO MODULE

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

FIG. 16. CONNECTION SETTINGS IN THE SQL DATABASE PRO MODULE

4. ADD AN SQL QUERY TO THE QUEUE AND LINK THE PARAMETERS OF THE SQL QUERY OF THE :P1 TYPE AND THE PARSER ITEMS.

FIG. 17. SQL QUERY

FIG. 18. SQL QUERY SETTINGS

5. IF EVERYTHING IS CONFIGURED CORRECTLY, YOU WILL SEE THE MESSAGE ABOUT DATA SUCCESSFULLY WRITTEN TO THE DATABASE IN THE MAIN WINDOW OF THE PROGRAM.

FIG. 19. MESSAGE ABOUT DATA
SUCCESSFULLY WRITTEN TO THE DATABASE

• SMS GSM MODEM SETTINGS AND CONFIGURATION
• SMS TO DATABASE: WRITING SHORT MESSAGES FROM A GSM MODEM INTO A DATABASE
• SAVING SMS TO A DATABASE WITH AN ACKNOWLEDGEMENT
• SMS FROM DATABASE: SENDING SHORT MESSAGES FROM A DATABASE