Hi, Gonna hijack this thread for just a bit. :) I'd like to share a little XUCC history. IIRC, the first attempt to develop a prototype of an SMS-to-DB application was by Francis Montesino (back in 2001 or 2002..not so sure now), who proposed the use of gnokii to interface with the mobile phone. I think a prototype didn't materialise (just yet, because of constraints with current technology and available mobile phones at that time).
This picked up in 2003 with a paper I did; "An Operator-Independent SMS-to-Database Gateway" with Yebron, Delegencia, and Nufable. We used gammu (descendant of gnokii), and used PHP, of all languages, to query student grade databases (OSPM). We were able to do a prototype which actually worked, but wasn't for industry use. Engr. Doroja wanted a more robust application that can be deployed in any platform (gateway app + mobile drivers + gammu/gnokii/kannel + mysql). This is where Butch Salem's group comes in, as crimson.albert mentions below. Glad to know that RB's improving on this as well. So yeah, going back on topic, the OP can use gammu, which has several APIs that you can call directly from any programming language of choice. +Crimson+ wrote: > (disable_lurker_mode = true) > > ... I remember this was the project of a few of my batchmate sa senior > project nila. It was a bit of a counterpart of our project in which we > used J2ME (i believe cla ridvan nag padayun on improving it.. :) ). > I think my batchmates had used "Gammo" to read the message from the > SMS and then their application would be used to parse and translate to > DB language. They used VB instead of Java. (The head of that project I > think is working in NEC now...) > > I'm not 100% sure on this since dugay nato and I was not envolved in > the project. i guess a "translator" from the mobile device to a DB > (vice versa) might be a good approach para ang load kay naa ra sa > server. Also if you use J2ME sa mobile kay dapat medyo high end or > atleast naa Java Support ang device so dili ma-apil ang karaan na mga > cellphones. > > Mau lang ni ako understanding sa technology... > > (disable_lurker_mode = false) > > On 3/7/07, *Joshua Raphael P. Fuentes * <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> wrote: > > ah ic. Kanang SMS modem lugar, maka dawat na siya og SMS gikan sa > cellphones? kung mao na , d kinahanglan ka og medium para makuha > ang gai > output adto nga hardware, kanang murag ODBC driver lugar. Pag maka > kuha > na ka og murag CSV or unsa man galing nga format, i convert nalang na > nimo diretso, using anang tool na iynag gi buhat gamit java, kay ang > java pwede man maka connect sa mysql. > > The bottom line would be read the output from the SMS modem (or > whatever > hardware it is that can get inputs from SMS ), parse the given input > ,and assemble a SQL statement to insert data into the mysql database. > > However, if he wants to have a java based application which have to be > installed on the mobile phone, then i suggest using J2ME. I have > tried > using that, with an emulator that runs on a PC, it ran, but I didn't > push through with writing it. It was just some sort of testing and > learning. > > murag gusto niya mahitabo, thru SMS or text gikan sa mga customers > > nila, ma-save ang message (comments, suggestions.. etc) sa mysql > > server using his java application. pero ako di katubag ani hehe pero > > interesado jud ko makahibalo unsaon jud na pagbuhat ana na > technology. > > _________________________________________________ > Kagay-Anon Linux Users' Group (KLUG) Mailing List > [email protected] <mailto:[email protected]> ( > http://cdo.linux.org.ph) > Searchable Archives: http://archives.free.net.ph > > > ------------------------------------------------------------------------ > > _________________________________________________ > Kagay-Anon Linux Users' Group (KLUG) Mailing List > [email protected] (http://cdo.linux.org.ph) > Searchable Archives: http://archives.free.net.ph _________________________________________________ Kagay-Anon Linux Users' Group (KLUG) Mailing List [email protected] (http://cdo.linux.org.ph) Searchable Archives: http://archives.free.net.ph
