sms based grade inquiry

[iancemacio]

hello mga sir...

paano po ba ang gagawin dito?
my plan bale ay sms lang ang gagamitin para makareceive ng grades.

ano pong cellphone model ang puede gamitin?
anong cable ang gagamitin para magconnect ng cellphone to a computer?
anong programming ang gagamitin?

[zer0w1ng]

Nokia cellphone with datacable.
This is available in some cell shops.

For the software, check gnokii http://gnokii.org/
You have to customize it a bit to connect to the grades database server.

[Kaizer03]

hello mga sir...

paano po ba ang gagawin dito?
my plan bale ay sms lang ang gagamitin para makareceive ng grades.

ano pong cellphone model ang puede gamitin?
anong cable ang gagamitin para magconnect ng cellphone to a computer?
anong programming ang gagamitin?

it would be much more easier if you will use a GSM modem,

if you are going to use a phone, 6210 and 7210 are widely used for alternative for GSM modem

DLR3P cable is used to interface the Cellphone to the Computer

or an ordinary phone with its DataCable, mas ok ata ang Nokia, since maraming resources din ito =)


you can use any other programming Language, you only have to send AT Commands through it =) to command or access the phone..=)

AT Commands are used to communicate within your phone or GSM Modem=)

[iancemacio]

ok salamt po...

ano kayang data based ang puedeng gamitin?
paano po icoconnect ang iyong data base at iyong ceephone? what i mean is paano automatic basahin ng tinext ko sa database at isesend ito pabalik sa sender?

[zer0w1ng]

MsAccess.
MySQL.
Or any SQL server using ODBC.

Or could just be plain text file.  The grades data structure is just a single table.

[Kaizer03]

ok salamt po...

ano kayang data based ang puedeng gamitin?
paano po icoconnect ang iyong data base at iyong ceephone? what i mean is paano automatic basahin ng tinext ko sa database at isesend ito pabalik sa sender?

that is the purpose of your program..=)

your program will interpret the received SMS message then process it, after processing the received message it will communicate to the database(MySQL is a free database).. then upon receiving the reply from the database it will process again, then prepare the data to be send in SMS format to your phone=)

[iancemacio]

ok.. maraming salamat....

meron ba kayong architecture nito?
mga pictures ng mga gagamitin?
paki.email po sa cemacio_ian@yahoo.com
you can contact me at 09169163011

kailangan na kailangan po para sa aming project.. thanks.. God Bless

[zer0w1ng]

I discourage direct emails or PMs when helping.
Posting the answers and questions on the forum let everybody or somebody in the future with same needs will be benefited also by just reading the posts.

For your question on the architecture? Please elaborate on this.
Hardware architecture or software?

For software, the application is straightforward and IMHO does not need even complicated charts or UML.
You just need to parse the SMS received for the student ID.  Using a standard format for the SMS query helps a lot.
For example: GRADE 12345. You need just to trim spaces at the beginning of the text received and copy the ID number at the 7th position.  You need also to compare the string "GRADE" if present else just ignore the text.

After you have the ID number, just do a lookup on your grades database and send the grade back.

You also need to retrieve the sender's number to be able to send it back.

As suggest by gigz, you can use a GSM modem.  If you follow this route, you need to familiarize and do research on AT commands.
http://www.developershome.com/sms/atCommandsIntro.asp

Serial communications knowhow is also needed.
http://www.google.com.ph/search?hl=tl&rlz=1C1GGLS_enPH323PH323&q=serial+communications&btnG=Maghanap&meta=&aq=f&oq=

--

For the hardware, a datacable is just needed and connected like this:

CELLPHONE <---------------------> COM1 / COMPUTER
                          ^
                           data cable

GSM modem <--------------------->COM1 / COMPUTER
                          ^
                           serial cable

[iancemacio]

ok sir... maraming salamt po...im using vb6 with mscomm control so i cud use AT commands, and at the same time connect it to a database...im still learning pa po...am i on the right path?

[emond]

sample code for connecting GSM/Phone modem using MScomm control in vb6

With frmDataEnv.MSComm1
     
   
      .RThreshold = 1
        .InputLen = 0
        .Settings = "9600,N,8,1"
        .DTREnable = True
        .InBufferSize = 32
        .OutBufferSize = 0
        .CommPort = Me.cmbPorts.Text
        .RTSEnable = True
        DoEvents
        .PortOpen = True
        DoEvents
   End With