| |
 |
| |
How to configure VisualGSM to conduct a survey, and store the survey results in MS Access, in just 15 minutes |
 |
| Introduction |
|
This tutorial demostrates how it is possible to configure VisualGSM Enterprise to conduct a simple survey with 2 answers, A and B, and collect the survey results using MS Access, in just 15 minutes.
|
 |
| |
| Software Requirement |
|
1). VisualGSM Enterprise Server (SMS Gateway)
2). Microsoft Access
|
|
| |
| Procedure |
|
| STEP 1:- To store results from 2 answers, first, you need to create an Access database with a table "survey". |
|
| In this example, the database is access_demo.mdb. It has a "Survey Table", with fields "Survey_results" and "Respondent". The field "Survey_results" will store the respondent's reply, while the field "Respondent" will store the mobile number of the respondent. |
|
 |
| |
| |
| STEP 2:- Next, create an MS Access "system DSN" for this database, e.g. VGSMDEMO. |
|
 |
|
 |
| |
| |
STEP 3:- Following that, create the keywords for the 2 responses on VisualGSM Enterprise Manager.
Note: If you have not installed VisualGSM Enterprise Server, you can download the installers from this link (VisualGSM SMS Gateway and Email2SMS Addon Download). Refer to the "Quick Start Checklist" on how to configure VisualGSM Enterprise Server.
Run VisualGSM Enterprise Manager, and click on "Keyword" tab.
Click on "New", select "SQL Query" for Type (refer to the below screen capture for details).
The keywords should be the same as your intended response from the users. The full SQL statement is:- |
|
| insert into survey (SURVEY_RESULTS,RESPONDENT) values ('YES','{N}') |
|
| This SQL statement means "inserting" into a new record into the table "Survey", and make the field "Survey_results" = "Yes", and the field "Respondent" = {N}. {N} represents respondent's mobile number. It's a fixed property provided by VisualGSM. Here's if the user replies A, VisualGSM will insert a new record in which the field "Survey_results" will carry the value 'YES', into the table "Survey". For details, click on the screencapture shown below. |
|
 |
|
|
| |
| |
STEP 4:- Indicate the DSN used, which is VGSMDEMO.
Once you have added and configured the keyword, you can use the "Test" button to test the keyword (i.e. simulate an SMS survey) and check your Access database for the new record created in the simulation. |
|
 |
|
|
| |
| Note:- You can use the NOKEYWORD function to capture wrong replies. Check the User Guide for more information on how to use NOKEYWORD. |
| |
| |
STEP 5:- Start VisualGSM Service and test your new keywords.
Start VisualGSM Service using the "Start" button on VisualGSM Enterprise Manager.
Note:- If VisualGSM service does not start, refer to the returned message and check your setup. Refer to the next section, troubleshooting.
Proceed with live SMS testing. Refer to the sms server log file for testing details. |
| |
|
| |
| Troubleshooting |
|
If you are facing any issues, please refer to the sms_server_log.txt file for logging details.
Default path for sms server log:
c:\Program Files\Visualtron Software Corporation\VisualGSM\vgsmlog\sms_server_log.txt
If you have any questions or comments, you may post on the support forum for this tutorial - click here. |
| |
|
| |
| Relevant links |
Build an SMS Directory Bot in just 4 hrs (including testing) |
| |
| |
| |