FrontlineSMS

FrontlineSMS allows you to text message with large groups of people anywhere there is a mobile signal.

Hi There, David here I wonder if its possible to access the database directly in order to feed information to other systems dynamically. this would be a read only access.

Bests,

Views: 101

Reply to This

Replies to This Discussion

Hi David,

This is most easily achieved by using MySQL as FrontlineSMS's database engine. This can be activated via Settings -> Database Settings in FrontlineSMS. You will also need to have access to a MySQL database. If you need more info on how to do this, I'm sure we can help.

Cheers,

Alex
Could you please help me with connecting to a MySQL database.
I am using WAMP 2.2 with the Apache server and want to connect to the localhost sql database
Gysai:

What are you wanting to do specifically? Are you just wanting to take the data you receive via text and insert it into the MySQL database and maybe do some processing and queries against the db and send it back via SMS? If so, that is super easy to do via external commands.

You've already got all of the necessary pieces in place with your WAMP environment. Just feed the information to an external PHP or Perl script that will take it as a standard HTTP request, process it like you would any other HTTP request, and then pipe your data back to the user.

If you're just wanting to stick results in the database, that's even easier.

Hope this helps. If you need help, feel free to contact me and I'll do my best.

Anthony
I used the HTTP request method.

Thanks
hi sir.

im using flsms external commands and i have doubt in it.i want to send the msg from mobile to flsms which inturn should be stored in my database.how i have to do this.


regards
madan

Hello Anthony Papillion,

             Sir, plz can you provide me the php script to connect, query & send sms back to user....  i'll be very grateful to you....

E-mail: atul.rawat85@gmail.com

Thanks in advance....

RSS

Photos

  • Add Photos
  • View All

© 2013   Created by kiwanja.net.   Powered by

Badges  |  Report an Issue  |  Terms of Service