Operating system name and version: Debain Lenny
Version of smsd: 3.1.14
Smsd installed from: sources
Name and model of a modem / phone: Itegno USB
Interface: USB

Sir,

I would like to use SMStools3 to handle GPS Tracking data through SMS & port it to either PlaySMS or opengts Gps tracking software

My Project is as under

I have GPS/SMS devices which sends GPS Data to a Mobile Number periodically. This Mobile number is on my USB Modem connected to my Server using smstools3

The Format of the Data is as under;

?IMEI,Status,GPS_Fix,Date,Time,Longitude,Latitude,Altitude,Speed,
Heading,Number_of_Satellites_In_Use,HDOP!

For Example;

?353857014816785,2,3,280807,035825,E12129.2616,N2459.7918,97.2,0.13,142.31,04,2.4!

The description of Format1
Format Value Note
? ? Command Head
IMEI The number of IMEI
Status 0 0: Immediate report
1 1: Period report
GPS_Fix 1 1: Fix not available
2 2: GPS 2D Fix
3 3: GPS 3D Fix

Date ddmmyy

Time hhmmss

Longitude (E or W)dddmm.mmmm Example:E12129.2186 Æ E 121°29.2186’

Latitude (N or S)ddmm.mmmm Example: N2459.8915 Æ N 24°59.8915’

Altitude xxxxx.x unit: meters

Speed xxxxx.xx unit: knots (1knots = 1.852km)

Heading ddd

Number_of_
Satellites_In_Use xx

HDOP x.x

! ! Command End

My Question is how to use Eventhandler or script available which can handle & port the above Formatted SMS to MySql

Thanks & regards,

Tummy

tummyg wrote

My Question is how to use Eventhandler or script available which can handle & port the above Formatted SMS to MySql

Do you mean that some script is available somewhere, and does the job after it's installed?

With eventhandler you can do anything which can be imagined. There are no limits, and you can use any language, like PHP, Perl, C/C++, whatever, for eventhandler.

If the script is not already available, and you are very new to programming, I think that you should hire a programmer to do the job.

Sir,

Thank you for your reply.

If you give some examples for Eventhandler projects, I can discuss with some experienced programmer to help to make GPS tracking project

Thanks once again for all your support & patience

regards,

Tummy

This is enough for programmers. Also the search feature could be used, "eventhandler" is a good keyword.

Of course, this document SMS file format is required too.