yashsingh1/xdaforums huggingface dataset:
[Windows Mobile Apps and Games] pewe:
Thanks Turtle - but I think you misunderstand my request.

Let me try to explain better.

On the phone Trackme creates an offline file for later upload called 'Local.sdf' which is a Sql file.

When Trackme uploads to the server it clears that file.

For the use I want to put it to (uploading to my server and also to geotag photgraphs on my home PC) all trips would be recorded offline and would be uploaded to my server when I got home.

Before running the upload I want to copy the 'local.sdf' file to my PC before it is cleared.

Now I have a copy of 'local.sdf' I need a utility to extract the data from it and put it in a format that can be read by the geotagging software 'Geosetter' which matches the time stamp in a gpx file with the time stamp of photographs and geotags them - adding the location to the photograph exif data.

On the server there is a file 'export.php' which does what is needed locally, but it is a php file which extracts data from a MYSql database to create one or both of the gpx and kml files for downloading back to the PC. It will only run on a server.

The utility I am talking about would do what 'export.php' does, but locally so the geotagging could be done even if for some reason the Trackme data could/was not be uploaded to the server.

There is a peice of free software called SDFBrowser (http://brain2cpu.com) which reads the 'local.sdf' file, but only exports it as a csv - shame it does not export xml which could be used as a gpx file.
[Windows Mobile Apps and Games] _LEM_:
By the way, in case it helps you, if you take pictures with your phone and they are geotagged, you can upload them with TrackMe. TrackMe will match them to the closest position that you have in the database by looking at the lat/long information.

I understand what you need, but as you noticed, TrackMe will only work with data that has been uploaded previously to the server. Whatever is stored in the sdf file is for temporary and internal use.
[Windows Mobile Apps and Games] pewe:
Thanks Lem.

That's my problem. I need to Geotag the photos first, and to do it manually is a pain, and I don't want to run 2 different GPS trackers - either both on the phone or one on the phone and one on a separate gps unit - at the same time.

I'll just have to try and find a way of getting the times and locations out of a copy of 'local.sdf' and into a form that a geotagger can use.:(
[Windows Mobile Apps and Games] pewe:
I have now found a simple (relatively) way to use the data from a copy of the Trackme 'local.sdf' file to create a .gpx file on my PC, then to use Geosetter to Geotag photos.

I would ask though, is it possible to upload geotagged photos from the PC to my Trackme server for use with the data, or do these too have to be uploaded from the phone.

Thanks.
[Windows Mobile Apps and Games] tft:
anyone have a cab for this? download link is dead.
[Windows Mobile Apps and Games] _LEM_:
Download link works fine for me.
[Windows Mobile Apps and Games] websurf:
Hi Lem

I'm using Verizon Touch Pro2 phone on Pageplus carrier (which still verizon network) I'v been receiving short URL sms fine no problem from Verizon Imagio which also Pageplus (again Verizon network). but since I ported Verizon Imagio phone to another carrier (Lycamobile) which using T-Mobile network. Trackme is on the Lycamobile phone (T-Mobile) and the short URL are being send from this phone to the Touch Pro 2 on Verizon network.

My SMS its all scramble up. This is how it look:

1/2 (C?4??N??hhQ?'gK?mBAgeY7oN1+feX7m?4??n??fzD+"F4lz?sVD?gJ=vY2=JH1C.Z6ez?_c?Y0tJu)"F:trA+V'??6bu!#F??1bD1S?K?8n89c??3IX1cF6n?_c&Z2=*Q2?'??6?5K?&??6tu?c&??6R?cvmX?aH_?W

Do you know why or is there something I need to change in my phone to fix this problem?

Thank in Advance LEM
[Windows Mobile Apps and Games] _LEM_:
Have you tried sending a similar message but typing it manually? Maybe it gets messed up with hyperlinks.
[Windows Mobile Apps and Games] websurf:
Hi LEM

I've tried your suggestion with 2 SMS manually type in and they were sent and received successfully and correctly.

this is what I tried.

SMS 1: http://www.google.com

SMS 2: http://xrl.us/bo5be5 This is the actual link I received when both phones were on the same Verizon Network.

I then let TrackMe to send me the SMS alert but the SMS still all scramble again.

Also, LEM! How do I setup the Geofence? Do I just need to add 1 alert with current position? or 4? I don't understand if this is a Circle or Rectangular shape of Geofence.
[Windows Mobile Apps and Games] _LEM_:
I don't have the WM version anymore so I have tried to reproduce the problem on my Android but I couldn't. I'm sorry about that.

For Geofence, yes, it's a circle. I don't remember exactly how to set it up but I think you could enter the values manually or specify the current position.

Regards
[Windows Mobile Apps and Games] websurf:
Ok thanks for tried LEM
[Windows Mobile Apps and Games] websurf:
I LEM

I've just did another test on this issue with 2 phones on the SAME network.(again, its a Lycamobile Carrier but they use T-Mobile Network)

The reply SMS from TrackMe is below:

PC map: ERROR: Blocked- 148.2.137.81 in xbl.spamhaus.org (http://www.spamhaus.org/query/bl?ip=81.137.2.148)

Mobile map: ERROR: Blocked- 148.2.137.81 in xbl.spamhaus.org (http://www.spamhaus.org/query/bl?ip=81.137.2.148)

Just let you know and not sure that something you would like to look into.

thank you
[Windows Mobile Apps and Games] _LEM_:
Try disabling the option Sharing Settings->Shorten URLs.

Not sure if it will work but you can give it a try.

EDIT:

Sorry... that option is only for Android. I have seen the shorten website banning some devices and showing the same error that you mention.

That usually took care of the problem.
[Windows Mobile Apps and Games] websurf:
Could this be just Phone Carrier specific? because I know when both phone on Verizon then everything is working fine. (but not with T-Mobile)

Oh one more thing, Today I tried to use CellID instead of GPS and TrackMe showed this red line: Error: Cell id not received in 3s.

I searched this forum but did not find any one mentioned about this error. is this something wrong with my phone?

By the way, I'm GSM network (use SIM on T-Mobile)
[Windows Mobile Apps and Games] _LEM_:
Sorry for the delay...

Yes, I think it could be. Carrier specific.

It could also be related to that phone. I remember seeing some phones (not very often) that didn't provide that information.
[Windows Mobile Apps and Games] websurf:
Hi LEM

Couple more questions please

1) In the Geofence setting, Can I set it under one mile? I tried like 0.5, however TrackMe automatically adding alot more numbers after that.

2) Can I reset the Notified remotely?

Thanks for your answer
[Windows Mobile Apps and Games] _LEM_:
1. I really don't remember having a limitation there, but maybe there is. What do yo see if you type, for example, 0.1?

2. No, that's not possible.

Regards.
[Windows Mobile Apps and Games] websurf:
I do see 0.1 after I type. however, after I save and exit Trackme then restart it again I see some weird number like 0.100568004288 the number is random.
[Windows Mobile Apps and Games] _LEM_:
I may not be converting it correctly. However it's still 0.1 so it should be ok.
[Windows Mobile Apps and Games] websurf:
thank you LEM

I do really want to see you in person or at least seeing your picture :). You're so nice , thank you so much for your help and Trackme is the best app out there.
[Windows Mobile Apps and Games] _LEM_:
Only if you are a girl!! :o Just kidding! You are too kind.

I'm glad you like the app. I wish I could spend more time on it and keep adding new features more often!
[Windows Mobile Apps and Games] pewe:
I'm sure I am been a bit thick, but I have a question about using this with Android.

I have a new Android tablet and installed TM on it.

When I launch the program I see the screen with the 3 icons plus start button at the top, as well as the 3 icons at the bottom of the screen, but I can't see any buttons to open the settings window.

How do I access the settings???

Thanks.
[Windows Mobile Apps and Games] :
I'm only guessing, cause I do not have android running at the moment, but i would assume, that you access the settings - like in nearly every other android app - via hardware button (context menu).
[Windows Mobile Apps and Games] toysareforboys:
How do you setup the geo fence on the android version? I want a text whenever I enter the geo fence, and whenever I leave the geo fence. Is this possible?

Thanks!

-Jamie M.
[Windows Mobile Apps and Games] mr.Const:
toysareforboys,

http://www.luisespinosa.com/phpBB2/viewforum.php?f=8
[Windows Mobile Apps and Games] toysareforboys:
Won't let me sign up, always says my e-mail address is invalid. Tried 20 e-mail addresses, no go :(

I e-mailed info@luises... so I'll see how it goes.

-Jamie M.
[Windows Mobile Apps and Games] _LEM_:
Sorry for the delay, I have been out of town and I just came back.

Geofence is not implemented for the Android version. You have reminders that work a little similar but it's not really the same.

The reminders will notify the user when you enter in a certain area.

Regards
[Windows Mobile Apps and Games] _LEM_:
I really don't have control over the forum but never heard about that problem. Are you using real email addresses?
[Windows Mobile Apps and Games] toysareforboys:
That's a bummer :( Any idea when the geo fence feature is coming to Android?

Lots of real e-mail address :(

It worked fine tonight though, somethin musta been funky with the signup process.

-Jamie M.
[Windows Mobile Apps and Games] _LEM_:
I don't think it will be anytime soon. Development has been stopped for a while now.
[Windows Mobile Apps and Games] toysareforboys:
Thanks for the quick reply.

-Jamie M.
[Windows Mobile Apps and Games] yellowfever:
Thanks a lot for the old TrackMe Windows Mobile!

Thanks a lot for the old TrackMe Windows Mobile! This helped very much in turning my vintage smartphone (2006 Fujitsu-Siemens Loox T830) into a GPS+GMS/UMTS car tracker :)

Only pity is that CellID doesn't work, neither with the stock WM5 nor a new WM6.1 - but zhis is the same with other software, so this is a general thing with this device (same SIM works fine with CellID in an HTC Mega, which unfortunately lacks a connector for an external GPS antenna).

Thanks a lot and Take care!

(some $$$ sent by Paypal)
[Windows Mobile Apps and Games] _LEM_:
Thanks a lot, Andreas! I really appreciate your contribution.

I'm glad you still have been able to use it for a WM phone.

I remember that CellID was kind of picky for some phones. Not all of them supported it.
[Windows Mobile Apps and Games] websurf:
TrackMe stopped upload data to the server

Does any one having issue with TrackMe stopped upload data to the Server in the last couple days? (Windows Mobile Version)

I'm unable to view the Track on both Google Earth and Webview http://www.luisespinosa.com/trackme/index.php.

Is the server down?
[Windows Mobile Apps and Games] _LEM_:
I just tried it right now and it works ok. Maybe it's something temporary from your location.
[Windows Mobile Apps and Games] websurf:
Hi LEM!

Thank you

I'll wait til tomorrow then
[Windows Mobile Apps and Games] jefmcg:
export trackme as GPX files

I use strava these days, and I was regretting some of my old rides weren't in there. Then I remembered I had them in trackme. I've got my own database, so I just had to write a script to turn them into GPX. This Unix shell script works against an older version of the database (back in 2008).

(written and tested on a mac)

It creates a GPX file for each trip, with a file name of the form username_tripid.gpx.

Uploaded to strava, endomondo and ridewithgps. Most are fine, a few long trips are a bit weird

Use in good health.

database_name=""
database_username=""
database_password=""
while [ $# -gt 0 ]
do
case "$1" in
-u) database_username="$2"; shift;;
-p) database_password="$2"; shift;;
-d) database_name="$2"; shift;;
esac
shift
done

echo "$* database_name $database_name database_username $database_username database_password $database_password "
if [ "$database_name" == "" -o "$database_username" == "" ] ; then
echo >&2 "usage: $0 -n <datbase name> -u <database username> -p <database password>"
exit 1
fi

for i in `mysql --skip-column-names -p$database_password -u$database_username $database_name -e "select ID from trips"`
do

username=`mysql --skip-column-names -p$database_password -u$database_username $database_name -e "select username from users, trips where FK_Users_ID = users.ID and trips.id=$i" `
FILENAME=${username}_$i.gpx
echo $FILENAME
name=`mysql --skip-column-names -p$database_password -u$database_username $database_name -e "select Name from trips where ID = $i" `
echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?> <gpx creator=\"Trackme - $i\" > <trk><name>$i - $name</name> <trkseg>" > $FILENAME
mysql --skip-column-names -p$database_password -u$database_username $database_name -e "select concat('<trkpt lat=\"',Latitude,'\" lon=\"',Longitude,'\"> <time>',Date_Format(convert_tz(DateOccurred ,'+07:00','+01:00' ), '%Y-%m-%dT%H:%i:%sZ'),'</time> </trkpt>') as 'Point' from positions where FK_Trips_ID = $i order by dateoccurred asc" >> $FILENAME
echo "</trkseg> </trk> </gpx>" >> $FILENAME
done
[Windows Mobile Apps and Games] _LEM_:
That's great! Thanks so much for your contribution. :good:
[Windows Mobile Apps and Games] jefmcg:
You're welcome.

Forgot to mention: there was something really iffy about the timestamps (apparently I commute at 3am), so I found a route with a known time (cross channel ferry) and worked out a correction factor. That may not apply universally.

(And XDA-Dev sends me an email, so just post any question here, and I can answer them)
[Windows Mobile Apps and Games] anderlmayer:
Field Test Program

Hi,

Could you tell me which field test program did you use? It seems just the thing I am looking for. Thank you.

"

"
[Windows Mobile Apps and Games] jefmcg:
You are responding to a post from 2008, so he was presumably using Windows Mobile 6.x. You'll probably need to look elsewhere
[Windows Mobile Apps and Games] khaytsus:
God I hope HE isn't using WM 6.0. *Shudder*
[Windows Mobile Apps and Games] _LEM_:
I still have my WM 6.0 :)

I wonder how many people are still using TrackMe for WM. I should have added some information in the database for statistic purposes... kind of late now.
[Windows Mobile Apps and Games] tbala:
server side error

I had installed the web server porition and it is working fine

one one small glitch

on the right hand side menu

down below you have one item called “Download Data” option either KML or CSV

when i click any of the option i get the following error

“Not Logged in or this is not a private system”
[Windows Mobile Apps and Games] dschense:
This is really great!

Is it possible to implement a multiuser view?

for example two or more clients are connected to the server and updating their positions every x seconds.

One Admin account for the webinterface to view all live tracking clients at the same time on one map with their name and maybe icon or different colors ?

this would be really really great!
[Windows Mobile Apps and Games] _LEM_:
Thanks! I'm glad you like it.

The web viewer is open source, I didn't write it. However, If you have some knowledge, you could make some modifications to make it work like you need.

Basically it should take into account different users at the same time.
[Windows Mobile Apps and Games] xZise:
I know it has been half a year since your suggestion to follow multiple users, but I'm currently working on improving the viewer itself. And I actually plan to add at some point support to show multiple trips at the same time and with that it should be easy to also should multiple trips from multiple users. The main problem there is just how to design the UI for that.
[Windows Mobile Apps and Games] _LEM_:
That would be awesome! We have been expecting for that feature for a long time. I'm glad you are taking the time to do that.

I can't wait to see it! Please keep us posted. :)
[Windows Mobile Apps and Games] poyensa:
incredible pictures, so close where I live :)
[Windows Mobile Apps and Games] _LEM_:
I'm glad to find a fellow developer close to my place! :D
[Windows Mobile Apps and Games] _LEM_:
*edited*

Sorry, the update was for the Android version. I posted it here by mistake.
[Windows Mobile Apps and Games] odie3:
Unless I am completely blind I am not seeing the public/private, I assume I should see a var setting for $public_page?

Going to try setting it to False.

Also, I think there has been a change to export.php, yes?
[Windows Mobile Apps and Games] Rescue9:
Staryon

Code works great now dude. However, the routes folder still isn't created. I'm thinking it might be a permission issue. I still have to manually create the folder and set it 777 to get it to work.
[Windows Mobile Apps and Games] odie3:
Yes, I did have to add this:

$public_page = "yes";

All seems to be working well (made the export.php edits too so no longer need my php.ini file).
[Windows Mobile Apps and Games] jcleek:
I forgot to update the config but I fixed it. Also a small refresh tweak on the last position.

Latest version of server files

Also I have included the latest files from Staryons first post.
[Windows Mobile Apps and Games] Rescue9:
So am I understanding you correctly. All I'll need to do when updating is copy this to my web folder, unzip, and run the install.php?
[Windows Mobile Apps and Games] odie3:
Say, I am noticing a difference with the speed/alt between viewing the KML file and the Archive/Last Position. Is it something I did wrong?

Edit:

I think the MPH/Miles is really km/h and meters on the Archive/last location pages.

Okay, in the DB the values are in Meters [Altitude] for Altitude and Meters Per Second for Speed [Speed].

Miles Per Hour you need to take [Speed] * 2.2369

Altitude in Feet you need to take [Altitude] * 3.2808399

km/h you need to take [Speed] * 3.6

Altitude in meters you need to do nothing, since it is in meters already.

Edit Two: This is what I did:

$mph = $row['Speed'] * 2.2369362920544;
$ft = $row['Altitude'] * 3.2808399;
$kmh = $row['Speed'] * 3.6;
$html .= " var point = new GLatLng(" . $row['Latitude'] . "," . $row['Longitude'] . ");\n";
$html .= " var marker = createMarker(point, 'User: <b>" . $founduser['username'] . "</b><hr width=\"300\">Time: " . $row['DateOccurred'] . "<br>Trip: " . $tripname . "<br>Speed: " . round($mph,2) . " MPH (" . round($kmh,2) . " km/h)<br>Altitude: " . round($ft,2) . " ft (" . round($row['Altitude'],2) . " m)<hr width=\"300\"><b>TrackMe. Created by Luis Espinosa</b><br>http://www.luisespinosa.com');\n";
///$html .= " var marker = createMarker(point, 'User: <b>" . $founduser['username'] . "</b><hr width=\"300\">Time: " . $row['DateOccurred'] . "<br>Trip: " . $tripname . "<br>Speed: " . $row['Speed'] . " MPH ($kmh km/h)<br>Altitude: " . $row['Altitude'] . " ($meters m)<hr width=\"300\"><b>TrackMe. Created by Luis Espinosa</b><br>http://www.luisespinosa.com');\n";
[Windows Mobile Apps and Games] _LEM_:
Probably. I don't think I can set it to 777 from the PHP code... if somebody knows a way, please let me know.

thanks
[Windows Mobile Apps and Games] _LEM_:
hey guys, I just discovered something with Google Maps Mobile! Maybe you guys already knew, but if you click on Search and enter the URL of the KML file, the route will be shown.

The only problem that I see is that only seems to show 9 placemarks. Could anybody double check that for me? Thanks!
[Windows Mobile Apps and Games] turtle2472:
I just wanted to post to cheer you all on. I'm not a programmer so I'm holding out until this is more complete.

Thanks for all the work. I'm looking forward to using this. :)
[Windows Mobile Apps and Games] odie3:
I got it working on Google Maps Mobile too, pretty cool. Once my kml has more than 9 place marks I'll let you know (which will be tomorrow when I get into the office).
[Windows Mobile Apps and Games] AndyInFl:
Thanks to everyone involved withthis project!

Staryon,

Just downloaded the latest and this problem still exists. Just a reminder in case this was missed. When a new Position is Received, Destination File(s) set to Local and Storage, Store positions Locally:

The Data type is not valid for the boolean operation. [Data type (if known)=...

Thanks for the Documentation. I'm sure I'll need it when I try to load it on my own server. (That could be a major struggle for me, seeing how little I know about Linux. Long live the Dos prompt...)

Thanks again.
[Windows Mobile Apps and Games] _LEM_:
Do you get the error when storing the GPS position or when generating the local KML file?
[Windows Mobile Apps and Games] AndyInFl:
I get the error when generate KML is selected. If not seleceted it says storing position.
[Windows Mobile Apps and Games] _LEM_:
Give me 5 minutes and I'll give you a new version to test...
[Windows Mobile Apps and Games] _LEM_:
ok, try now.... if still doesn't work, we'll have to wait for other users to test it. I don't know what else I can try to change... :(
[Windows Mobile Apps and Games] wafwot:
Yep. Only nine. My kml file has 264 positions in it (thanks to my 100-mile commute from Seattle). Google Maps Mobile only shows the last nine. It appears to be in reverse order; the last position labeled "1".
[Windows Mobile Apps and Games] _LEM_:
It's weird.... I found this:

If you download the new version 1.3.1 from http://google.com/gmm , you can view up to 255 placemarks. The 1-9 limitation only applies to older versions.

http://googlemapsbook.com/2006/08/18/gmm-kml/

And I'm using the latest version. Actually that news is very old.
[Windows Mobile Apps and Games] AndyInFl:
Once again....

Great job! Working just fine now.

Thank you.

Just tried uploading to you server and it says ".kml file upload correctly." This is the first time I tried and it seems to be doing the job!

I appreciate your and everyone's help. this is a great app!!!
[Windows Mobile Apps and Games] _LEM_:
great!! I'm glad it worked.

You will probably still have the same problem when deleting positions.

I will fix it too... but tomorrow! I'm falling asleep :o
[Windows Mobile Apps and Games] AndyInFl:
Config

Trip and positions deleted correctly.

Seems to work fine!
[Windows Mobile Apps and Games] adebilloez:
Great it work now !!!
[Windows Mobile Apps and Games] licht77:
Buginfo: Altitude in the KML file is genereated but is not correct... - for me it needs to be divided by 10... (using the last server files)

Couldnt test speed so far because i am sitting in the office at the moment... :(

Edit: Another thought....

Any ideas how to protect the KML file itself? I guess http-auth isnt flexible enough for those of you who use this app for multiple users... Unfortunately google earth doesnt accept dynamic kml files (blabla.kml.php or so)...
[Windows Mobile Apps and Games] jcleek:
New server version incorporating:

1) Corrections to my horrible attempt at basic math (Odie3)

2) Install reads SQL statements from an external (database.sql) file (Staryon)

3) Incorporated a preg_match for the login page for a non-public server (licht77)

4) Changes to index.php to not work unless both install.php and database.sql have been deleted from folder

5) Documentation changes in config.php and Read_Me.txt

This should be a complete package including all of the files from the latest manual install from Staryon. I believe I have incorporated all suggested and requested changes to the install and index code but if I missed something please let me know. As always, if you see a problem please let me know and I will get it fixed ASAP.

Of course you can always get to this Zip from Staryon's first post or just click this link: Latest version of server files
[Windows Mobile Apps and Games] cruchot_:
Hi,

I try to use this great software. The data connection is fine and GPS connectivity too. When I start to gather some data here's what I get (on the PDA) :

Error getdata: FormatException

And nothing else happens.

Any idea ?

Thx :)
[Windows Mobile Apps and Games] _LEM_:
Hi cruchot_,

What regional settings (country) do you have on your PDA?