You can use a database trigger to do this, database triggers are purely a database functionality that does not require changing anything in Diafaan SMS Server, except setting up the SQL Connector in the default configuration.
It is also possible to use a Scripting Connector in Diafaan SMS Server and write a C# or Visual Basic.NET script that does a database lookup when an SMS message is received and sends back the appropriate message. You can find an example script for a database lookup in the Scripting Pack that you can find on the download page of this website.
I couldn't get it to work so I decided to purchase the Multitech MTC-H5 model modem. It seems to be working fine. Thanks for your help. I have another question now though.
I"m trying to create a SMS database that will automatically retrieve info about accounts once given an account number through text.
For example, diafaan/access server receives "10186" in a text. The access database sees that entry, and automatically responds with the "note" that was associated with that account #. I'm assuming I'll have to set up a trigger somewhere via script to check all incoming text to see if they match account numbers. Then if they do, set the trigger to copy that row from my table into the "messageout" table. Does this sound possible to you using Diafaan. If so, then I'll definitely be purchasing the software. I ate my full free trial time just trying to get the connection to work.
When the 'CompatibilityMode' property in the advanced settings of the GSM Modem Gateway is set to 'BasicTextMode' or 'BasicPDUMode', Diafaan SMS Server only uses the minimal functionality to be able to send and receive SMS messages. It does not request other information from the modem and that means that no information about the modem and the network will be displayed.
You can enable communication logging to see what Diafaan SMS Server sends to the modem and how the modem responds. If you send the log file to firstname.lastname@example.org I can have a look to see if I can find anything wrong but the error message indicates that the modem just returns 'ERROR' and if that is the case it will be difficult to pinpoint the exact cause of the error.
I'm using a Multi-Tech Modem, Model # is MTC-EV3-B01
I got it connected fine. It did have the AT+CPIN error, but I saw the post to bypass that. On the status tab it says "ready to send and receive messages" but on the right side of that status tab, it has no info. No signal strength, no gsm operator, nothing. When I send a message it gives the "300 unknown error after PDU sent" message.
I've sent test text messages to and from the database so far, nothing showing up.
Most Users Ever Online: 494
Currently Browsing this Page:
Guest Posters: 518
Newest Members:, Henk Helmantel
Administrators: Henk Helmantel: 1003