I am trying to learn about frontline sms external commands feature.
We want to use it to automatically export the sms database table to a csv file.
I also want to know if there is an additional manual that has examples of using this feature. We are in the requirements building stage of our project and are trying to understanding the potential of this feature.
I am happy to tell you that External command, FrontlineSMS command option works great with php url also. we can get inputs from frontline, display text on webpage, and generate xml code on the fly which frontline correctly sends sms's to.
Now we will be able to connect our teachers in villages directly to our webpages through their sms's, that can then be seen worldwide immediately.
And whats more, we can also use webpage response to send sms to anybody through frontline,
The sms sent by xml code is atleast 50% faster than the sms sent by the autoreply feature, if not more.
Thanks for keeping us posted on your progress here! Great to hear.
Would you be interested in sending me some information on what you'll be doing with FrontlineSMS - the project(s), what the software allows you to do, the impact it's having, etc? I'm beginning to build case studies for regular blog posts on the subject. A couple of photos are also very useful.
If you can help, let me know! Feel free to email me about it if you like.
Sorry for the delay - I was swamped with work, and couldnt get back to you.
Yes we would be very happy to give you information on how we plan to use frontline. We have just made a very first small release to get sms's from all over the state for data analysis, and collecting news in 1 place.
But we will know the impact only in the coming few months. So I will get back to you with full information in 1 month or so, when we start using it more and more.
We have not yet tested querying the web database, although that is very much feasible since we already can read data from sms, process it and send some message back to frontline.
I will ask my web developer to provide the sample code on Monday.
Note: in my case, I created a textfile named "script.php" stored in the "www/test" folder of my local web server hosted on the same computer.
Response type: "Simpe text"
Message: Click on "Include response"
Check "send an autoresponse"
Click on done.
FrontlineSMS is setup.
You need to have a webserver setup on the local machine, create a database and have the file script.php stored in your "www/test" folder.
I attached to this message the file "script.php" and the SQL database creation instructions.
You will need to open "database.txt".
Execute the SQL instructions contained in the file on your databse server (through PhpMyadmin".
You have to create a user allowed to access the " sims" database created.
You will need to edit script.php to change the database access parameters (username, database, password..." according to the parameters you used for your user.
Once all this is done, when frontlineSMS will receive an SMs containing "MIL" it will call "script.php" with the product parameter given by "GET" method.
The script will look for the information and create a string containing the prices on the different markets.
The string is sent back to frontlineSMs which sends autoresponse by SMS.
I am attaching a document which has the php code that my web developer has written.
It is a very simple code, that simply gets data, outputs xml-type string with echo command that frontline can understand(under frontline command option of response type), and also stores the input in our database.
the echo command can be changed to give a simple text as output, that frontline can send in Plain Text response type option with $Include response, so that your user/users can get a web server generated response that tells them the message has been processed successfully
In your case, send back query response also.
I am using the example to query a phone database.
The browser gives me what I want:
First Last: Tel: 222-222 Celular: 09-099-099
in frontlinesms I am using or would like to use somthing like:
as the sms contains the keyword and the message content, I would like to remove the keyword and just send the message content "first last" to the system, but it does not work