Re: Store SMS to database

On Wed, 30 Jun 2004, Jeffrey G. Ubalde wrote:
..
>     Does anyone know a tool that works like Gnokii and can store
> retrieved and sent SMS to a database (more specifically a MySQL
> database)? We have tried using a couple of applications that connects a
> mobile phone to a PC (we are currently using gnokii) but we haven't seen
> a software that can save SMS directly to a database. Any suggestions
> would really be appreciated..

well you could try using GNokii with Gnokii::GSM Perl module. the Perl 
program will just periodically poll the phone, download any new SMS 
messages, and insert them in the database via Perl DBI. Trivial.

another way is to use GSMLib library (only works with phones that support 
AT commands -- meaning every Nokia from 7110 and up). Then use MySQL C 
client to insert in database. Trivial as well.

(you shouldn't be afraid to write your own software if the "off-the-shelf" 
open source packages don't do exactly what you want)


---
Orlando Andico <orly-TNEdZibuOH3QT0dZR+AlfA@xxxxxxxxxxxxxxxx>
Mosaic Communications, Inc.

--
Philippine Linux Users' Group (PLUG) Mailing List
plug-sJCYDywXB4m9hMQLrSLElQC/G2K4zDHf@xxxxxxxxxxxxxxxx (#PLUG @ irc.free.net.ph)
Official Website: http://plug.linux.org.ph
Searchable Archives: http://marc.free.net.ph
.
To leave, go to http://lists.q-linux.com/mailman/listinfo/plug
.
Are you a Linux newbie? To join the newbie list, go to
http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie