yashsingh1/xdaforums huggingface dataset:
[Windows Mobile Apps and Games] bobsys:
That looks pretty darn good.

I cannot test it before the weekend because my son took my Diamond with him to college to test if he could write something to drastically reduce the amount of data if sent over UDP. Just got a mail that it is working. He takes every GPS reading (every second) applies time, distance and heading tresholds to determine if the point should be uploaded. As test he only uploads lat and long, timestamp and a CRC byte. Total 13 bytes. I will ask him to publish it here. Perhaps it could be helpfull as test ?

With the heading now taken into account and reduced data traffic Trackme will be close to perfect.
[Windows Mobile Apps and Games] _LEM_:
hey guys...

I just found out that there is a command from the GPS that returns

the speed and angle. I didn't know that until today!! For that reason I was calculating the speed and angle myself.

I'll do some research on this and if it works fine I will replace it with that.

It only took me a year to find that out :p
[Windows Mobile Apps and Games] bobsys:
I believe OziExplorer only needs the RMC sentence. Includes speed and true heading.
[Windows Mobile Apps and Games] _LEM_:
That's the one that I meant. I just tested it and the results are almost identical but it makes everything much easier for me,

so I will be replacing it for this.
[Windows Mobile Apps and Games] bobsys:
Meantime I got my Diamond back and tested your latest version. The heading routine worked very well. I set it at 30 degrees threshold. A dramatic improvement. Yes, a few more points are recorded but everyone worthwhile. That however can become more than compensated for when UDP uploading is used.
[Windows Mobile Apps and Games] czar_au:
CellID Bug

Can't seem to Get Cell ID's working for Optus in Australia, anyway that is separate issue, as I can play with the PHP to see what is happening? My issue is that Trackme Fails with "Cell ID not found in databases. Skipped"... which is all good, but 1 second later it preforms another check "Reading Current Cell ID...". I have my Storage set to 15 minutes. Why is it trying to do another update repeatedly? Should it use the Server Wait for this error? which I also set to 15 mins. The problem is, If it comes across a cell it doesn't know about than it will keep hammering my data connection. If all is successful, it works fine
[Windows Mobile Apps and Games] _LEM_:
New version available!!

- Angle and Speed values are now taken directly from the GPS feed. No internal calculations are done.

- Added option (Config->General) to show an arrow with the current direction. This option is disabled by default

Enjoy!!
[Windows Mobile Apps and Games] _LEM_:
Hi,

Do you have the option 'Store Cell ID/Signal Str. in TrackMe database' checked?

If you have, try unchecking it and let me know if you are still having that problem.
[Windows Mobile Apps and Games] khaytsus:
Staryon,

New version looks great, probably stuck in the house tonight but I'll be trying it out tomorrow. :) FYI, noticed that the Source prefs page has a lot of empty space at the bottom.

You mentioned that the new mode which generates a point based on change of angle is not for walking; you're not kidding. I was doing some caching yesterday for about 90 minutes and racked up 454 points.

Is it possible to add a minimum speed to the equation? So the speed would have to be greater than some number in addition to the distance and angle checks that you're doing? Even just 5mph would eliminate any problems in walking, but of course making it configurable is always nice.

I was thinking I read recently you were thinking about adding the angle distance setting to the configuration, if the above is possible perhaps they can both be added?
[Windows Mobile Apps and Games] _LEM_:
With the new version all that has changed, because I only check the angle if TrackMe receives speed and angle data.

Your GPS shouldn't send any speed and angle information if it detects that you are not really moving but I think that is not always true and it also depends on your GPS device.

Try the new version and let me know if it works better.

If not, I will end up adding some additional checking before computing if the angle has changed.
[Windows Mobile Apps and Games] czar_au:
Yeah, not affected by this option, it does it if it is on or off. The other bug that I am aware of is if you start in "silent/minimised mode" it still takes over the buttons at the bottom of the screen ie... Menu [ ] Screen Off. And the [X] Close button at the top.
[Windows Mobile Apps and Games] _LEM_:
Do you think you can send me the file config.dat to my email?

You can find it here:

http://luisespinosa.com/contact_eng.html

That will help me to debug the problem.

Regarding the other problem... yes, I am aware of that issue. I haven't been able to find a solution yet. I have the impression that the problem was incorporated with WM 6.1
[Windows Mobile Apps and Games] bobsys:
Just tested this new version where speed and heading are taken from the RMC sentence. I did the same thing as a while ago namely recorded the trip on two PDA's where one was running Ozi and the other was running TrackMe. Then I imported route.kml file into Ozi so that both tracks get superimposed in a singel picture. As I predicted, Trackme is now as good as Ozi! Great. Probably Trackme is a little faster as well using the RMC sentence.

What a difference compared to the previous test. I hope you will now understand that I was not trying to discredit your program when I called the track as bad looking but only suggesting how it could improve by taking heading into account. Never mind if it records more data points because that will totally disappear when you manage to get the communication via UDP. It will reduce data cost by more than an order of magnitude far offsetting the higher number of points recorded. After that Trackme will be World class software. I have already seen proof of concept software on the UDP thing.
[Windows Mobile Apps and Games] _LEM_:
Not a problem. I also want to apologize if I looked angry or something like that.

It's just you said TrackMe only works fine when you are walking and that was something that could confuse some new users.

I'm glad the program is working much better now for you and of course for the whole community.

I will also add khaytsus' idea to add a minimum speed that should improve even more this new feature.

Regards and thanks for your suggestions.
[Windows Mobile Apps and Games] khaytsus:
Staryon,

It's not like my database is large or anything, but do you have any suggestions for optimizing/indexing the tables? I'm pretty much a mysql idiot when it comes to things like that. I can find how to index a table via MySQL docs, but not sure what makes sense in the way that TrackMe queries data.

Do you do any indexing on your server?

ALTER TABLE positions ADD INDEX(ID(20),FK_Users_ID(20),FK_Trips_ID(20)); perhaps something like that?

This is more or less an academic question, not a performance issue.
[Windows Mobile Apps and Games] _LEM_:
Yes, I have a few indexes.

These are the ones that I have:

Positions:

ALTER TABLE 'positions' ADD INDEX 'Index_FK_Trips_ID' ( 'FK_Trips_ID' )
ALTER TABLE 'positions' ADD INDEX 'Index_FK_Users_ID' ( 'FK_Users_ID' )

Icons:

ALTER TABLE 'icons' ADD INDEX 'Name' ( 'Name' )

CellIDs:

ALTER TABLE 'cellids' ADD INDEX 'Index_CellID' ( 'cellid' )

Trips:

ALTER TABLE 'trips' ADD UNIQUE 'Index_FK_Users_ID_Name' ('FK_Users_ID','Name')
ALTER TABLE 'trips' ADD INDEX 'Name' ('Name')

Users:

ALTER TABLE 'users' ADD UNIQUE 'Index_username' ( 'username' )
[Windows Mobile Apps and Games] Dtrieb:
I have a small wish.

(Please add it on your to-do list.)

Is it possible to Export the Routes also as gpx like here and not only as KML.

Here the german site:
[Windows Mobile Apps and Games] _LEM_:
yeah, that has been in the to-do list for a long time now.
[Windows Mobile Apps and Games] khaytsus:
Odd, I swear I responded to this yesterday.. Anywho, thanks for those, I've ran them and optimized my tables too. :) My massive 7200 record database isn't going to benefit from it that much, but in the long run I'm sure it's better. :)
[Windows Mobile Apps and Games] _LEM_:
Yes, speed was increased a lot on mine when I added those indexes.
[Windows Mobile Apps and Games] _LEM_:
ohh.. I think I misunderstood. I went to that web site and it seems that somebody already implemented it? Is that true?

If that works I can add that to TrackMe very easily.
[Windows Mobile Apps and Games] Dtrieb:
Yes it is true, but:

You have enter a URL in your Browser (like this)

http://INSTALLATIONSURL/export.php?action=gpx&username=DEINNUTZERNAME&password=DEINPASSWORT&tripname=<None>&datefrom=DATUM&dateto=DATUM&db=5

And this is not good because you see your Passwort in the browser history.

If you can make this with a button with the code from the site (export.php.zip). It would great !!!
[Windows Mobile Apps and Games] _LEM_:
Yes, I should be able to do that pretty easily.
[Windows Mobile Apps and Games] jenya:
Support for Intermediate GPS Driver

Hi,

I have an ATT Q9 Global and I was successfully able to install your app since you now support WM Std :)

Anyway, I was just curious if you are supporting using the Intermediate GPS driver. The Q9 does not actually map the internal GPS to an actual COM.

Here are the GPS Details for the Q9 Global in case you don't have one handy :)

[HKEY_LOCAL_MACHINE\System\CurrentControlSet\GPS Intermediate Driver]

[HKEY_LOCAL_MACHINE\System\CurrentControlSet\GPS Intermediate Driver\Multiplexer]

"DriverInterface"="GPD1:"

[HKEY_LOCAL_MACHINE\System\CurrentControlSet\GPS Intermediate Driver\Multiplexer\ActiveDevice]

"Index"=dword:00000001

"Prefix"="GPD"

"Context"=dword:12344160

"Flags"=dword:00000002

"Keep"=dword:00000001

"Dll"="GPSID.dll"

[HKEY_LOCAL_MACHINE\System\CurrentControlSet\GPS Intermediate Driver\Drivers]

"CurrentDriver"="Q9h Built-in GPS"

[HKEY_LOCAL_MACHINE\System\CurrentControlSet\GPS Intermediate Driver\Drivers\Q9h Built-in GPS]

"FriendlyName"="Q9h Built-in GPS"

"CommPort"="LVC1:"

"InterfaceType"="COMM"
[Windows Mobile Apps and Games] _LEM_:
Hi jenya,

I got a Motorola Q for testing the smartphone conversion and I had a lot of problems attaching a bluetooth GPS to this phone. I made some research and I found that problem could be resolved by upgrading the firmware of the phone. I did that, and now I am able to use a bluetooth device with the phone.

In case it helps, I created a video on Youtube showing how to do it.

You can check it here:

http://www.youtube.com/watch?v=dyFHsppse2s

Regards
[Windows Mobile Apps and Games] Dtrieb:
That's nice because so you can use Routes in OpenStreetMap.org
[Windows Mobile Apps and Games] jenya:
Hey,

Thanks for the prompt response... I'm using the ATT Q9 Global on WM6.1 which actually has built in GPS...
[Windows Mobile Apps and Games] _LEM_:
oh... I see. In that case I don't know how to do it.

Maybe there is a third party application that let you to map the internal GPS to a COM port.

I hope somebody else can give you more information

Regards
[Windows Mobile Apps and Games] _LEM_:
New version available

- Fixed problem when using cell id tracking and first position was not found

(TrackMe kept retrying)

- Now you can export to GPX (Credits to Ulrich Wolf. Thanks a lot!)

Note:

For people using their servers the file Export.php has been updated.
[Windows Mobile Apps and Games] Dtrieb:
Thx you are so fast ... But i get the error message: "Error creating remote gpx file ()"

And one idea:

Can you write on the main screen the traffic (up/download) that the programm makes to the internet?
[Windows Mobile Apps and Games] _LEM_:
Did you update your server?
[Windows Mobile Apps and Games] LaCroix:
I am the author of the GPX-Addon for TrackMe. Some thoughts:

I've implemented this in the same manner as the KML-Plugin works. My suggestion: Send the password as a md5-hash over the network.

The produced GPX-File data can be read by various tools for geotagging e.g. geosetter or even picasa.

As i do not have any windows-mobile devices anymore i cannot test any changes to "my code".

And sorry, i forgot to notify you of my changes as i changed my device shortly after developing this extension.
[Windows Mobile Apps and Games] Dtrieb:
YES I have update my Server.
[Windows Mobile Apps and Games] _LEM_:
LaCroix, thanks a lot for writing this plugin for TrackMe.

As soon as I added to the official release I thought that maybe I should have asked you first if you were ok in adding it. I hope it's not a problem!

Thanks again and let us know if you decide to make any updates to the plugin.

Regards
[Windows Mobile Apps and Games] LaCroix:
Was done out of a need (to geotag my photos :))

No that's not a problem, i'm glad somebody (thanks to Dtrieb!) reported this update to you ;)

Only if i write a application for my new Symbian-Smartphone ;) Probably won't happen i think...perhaps if i find some time...
[Windows Mobile Apps and Games] Timmi-T:
After update to new version today i'm getting an error message in TrackMe's log window, all tripdata is stored locally and cannot be forced either before or after the trip's end.

The error is: "Error: Unknown column 'signalstrenght' in 'field list'"

And it seems to me that it does'nt matter if CellID/signal strength is activated or not.

I tried to reinstall .Net SQL and TrackMe but it doesn't help.

I also have latest version of server.

Phone:TyTN2

WM: 6.1 stock

Thanks, for a great application by the way!! :)
[Windows Mobile Apps and Games] _LEM_:
Do you think you can send me the file local.sdf to my email?

http://luisespinosa.com/contact_eng.html

Thanks
[Windows Mobile Apps and Games] _LEM_:
hey guys, I think I'm going to take a break in adding new features to the program.

The reason is because I am releasing new versions so quickly that it's being difficult for me to test each one of them more in deep which is how I like to do. That's why a few new bugs were introduced in the last few versions.

I prefer to wait before adding anything new again and get rid of any possible existing bugs that may show up from now on. Once the program is completely stable again I will continue adding more stuff.

Regards
[Windows Mobile Apps and Games] Timmi-T:
You've got mail ...
[Windows Mobile Apps and Games] turtle2472:
I personally think that's a great plan. While I enjoy the upgrades and improvements if we lose stability then what's the point?
[Windows Mobile Apps and Games] _LEM_:
Timmi-T, I haven't received your email.

Do you think you can upload it somewhere and send me a PM with the link?

If not, just try to send it to me again.

Thanks
[Windows Mobile Apps and Games] knox203:
True Stealth Operation?

Is there any word on a truly stealth operational mode for the application? I've noticed with the current stealth mode it replaces the softkeys with the TrackMe buttons, and when I open another application up, then close it, TrackMe comes to the foreground.

Any chance of running the application completely in the background where there's no chance for user interaction?
[Windows Mobile Apps and Games] _LEM_:
That's a known bug and it was probably introduced with WM 6.1

It used to work fine.
[Windows Mobile Apps and Games] knox203:
Thanks for clarifying, staryon! Do you have any plans of updating the software to make it compatible with 6.1?
[Windows Mobile Apps and Games] _LEM_:
Yes, it's in the to-do list. I will try to have it fixed soon.
[Windows Mobile Apps and Games] _LEM_:
From now on the release history and future database updates (for people using their servers) will be posted here:

http://www.luisespinosa.com/trackmerelease_eng.html
[Windows Mobile Apps and Games] turtle2472:
Can you add a note on the ones that require an update on the server side specifically? I have not made the recent update because I'm not ready to take the time to update the web server. This will help me make sure I update those files too when I refer to your notes. Thanks staryon! :)
[Windows Mobile Apps and Games] _LEM_:
Yes, I will do that from now on because I don't remember which ones require a db update.
[Windows Mobile Apps and Games] turtle2472:
I meant to put this in the last post, but in the notes will you also include the actual command for the SQL DB updates too? Right now I just scroll through the posts until I can find what I'm supposed to update. I'm sure I'm not alone in this either. :D
[Windows Mobile Apps and Games] kapl.tom:
Hi. I have HP iPAQ 514 and I can't read cell ID position. It's show only error: Cell id not received in 3s. Is it any solution how to fix this problem? Or can I do something with it?
[Windows Mobile Apps and Games] dopsi:
uploading/export data

hi

i got some troubles with uploading/expoting positions to my own server

it work already but after flashing a new rom yesterday (dutty v3.4) on my diamond i cant upload data (i am not sure if this work the last months cause i didnt used it :))

i think my settings a correct (advance optins, user, passwd, server, etc) - but i got the message: you need to specify a username and password for the user.

same error when trying to download existing trips

i tried it with the newest version and one from 2 month ago

missed i some updating things?

any hints?

thanks

dopsi
[Windows Mobile Apps and Games] _LEM_:
You are probably in a CDMA network. Cell ID tracking is only compatible with GSM.
[Windows Mobile Apps and Games] _LEM_:
I would suggest to try the same thing on my server first. If everything works fine at least you know that the configuration of your client is correct, so it will probably be easier to help you with the issue.
[Windows Mobile Apps and Games] _LEM_:
Good. But only use that version temporarily. Date Ranges are not working with that version. At least I know where is the problem. I will release a new version tomorrow with that problem fixed.

Thanks for your help!
[Windows Mobile Apps and Games] _LEM_:
By the way, I'm already working on adding information about the speed and altitude.
[Windows Mobile Apps and Games] odie3:
Sweet, I wonder if it will work the next time I fly? :eek:
[Windows Mobile Apps and Games] odie3:
Okay I get:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource ... on line 113

and

Warning: filemtime() [function.filemtime]: stat failed for routes/.kml in ... on line 138
[Windows Mobile Apps and Games] _LEM_:
yeah... it should :D
[Windows Mobile Apps and Games] p25o1:
man this app is getting better and better,

i requested this some pages back,

cn you add the speed on the track points information, it will be very useful for me, and i hope others,,, may be an option to enable it ?

thanks again, and keep up the amazing work.
[Windows Mobile Apps and Games] daesimps:
I have tried the new index.php, but neither of the buttons appear to do anything. They simply return me back to the initial screen.

Does anyone have any ideas?

EDIT: I have resolved this on my server. I think it is to do with variables not being declared. I know nothing about PHP and just used a combination of Google and other programming knowledge from years ago (most of it forgotten now!).
[Windows Mobile Apps and Games] jcleek:
Did you modify the top section and replace the DBIP, DBUSER, DBPASS, DBNAME and GOOGLEAPIKEY fields with the appropriate information for your server? The reason it can not find a KML file is that it didn't get a name from the database to load.

Both of you please download the file again and try it. I made some more changes last night including auto-loading the most current trip on database selection and I declared all of the variables up front (I think). Daesimps if you find any other undeclared variable problems with this version let me know and I will fix them.

I have trimmed the code down as much as I think I can. If you know php have a look at it and tell me what I can do to improve it.
[Windows Mobile Apps and Games] jcleek:
I don't know why I didn't think of this sooner but all I needed to do was sort the trips on the ID field. Since that field is set to autoincrement it will always be in chronological order. On the trip page I just ORDER BY ID DESC and get them listed in most recent trips first regardless of the name you give the trip.
[Windows Mobile Apps and Games] daesimps:
I have just download it again, but I noticed that kml_data and database_data are not declared. I needed to declare these two on my machine as well. I haven't actually tried it, I just had to declare these two on the previous version to get it to work. I could be wrong though, as I said earlier I know nothing about PHP!:D
[Windows Mobile Apps and Games] jcleek:
Correct, they are not declared. If you declare them at the top the page will not work! When necessary I test for their existence with $_POST[] in this new version. If yours doesn't work without you declaring those up front let me know, but it should be fine.
[Windows Mobile Apps and Games] daesimps:
Excellent. As I said - I know nothing! I will give it a try later on today. I appreciate the work you are doing on this project - it is really useful.
[Windows Mobile Apps and Games] jcleek:
I have made some changes... again. I pulled the MySQL information from all of the files and created a config file to store them. This includes Staryons php files. The zip linked below contains a new install.php, index.php, export.php, requests.php and upload.php. If you install any of it, install it ALL. Re-running the installation will not touch your data in the database, and as long as you do not delete your KML files they will be fine as well.

Staryon, the zip contains replacements for your files. All I did was add

require_once('config.inc');

At the top of each file, and I changed the placeholder text to variables:

DBIP changed to $DBIP

DBUSER changed to $DBUSER

DBPASS changed to $DBPASS

DBNAME changed to $DBNAME

That way your files do not need to be changed ever, just the database information in config.inc. Makes the install creation much much easier.
[Windows Mobile Apps and Games] odie3:
Okay, used your link from your above post, all is well now! Nice!

Also, does not this link need to be changed to fit the site where the files are installed? (that is what I been doing)

var geoXml = new GGeoXml(\"http://www.getcis.com/trackme/routes/$username.kml\"); \n";
[Windows Mobile Apps and Games] odie3:
What zip? Changes again? ;)
[Windows Mobile Apps and Games] jcleek:
Right you are, thanks for the catch. I have updated the Zip file. You can simply use the new index.php from the zip or manually replace that line above with

$html .= " var geoXml = new GGeoXml(\"http://" . $_SERVER['SERVER_NAME'] . str_replace("index.php", "", $_SERVER['SCRIPT_NAME']) . "routes/$username.kml\"); \n";

Easiest option is replace index.zip of you updated your install to get the MySQL stuff from config.inc. If you replace the index you need to make no other changes.
[Windows Mobile Apps and Games] odie3:
Where is your master link to get the new files and thank you for creating a Config file, I been meaning to request that (makes life so much easier for new users of your php code).

@ staryon:

When you start supporting Speed/Alt it would be cool if you could add a way to force a update and with that update have it so you can tag a custom pin on the map. Say, a user stops somewhere, you force a update with a food icon/pin (showing on the map you stopped here to get a bite to eat). Perhaps that is a silly idea but thought of it last night when I stopped to get some food.
[Windows Mobile Apps and Games] _LEM_:
Good idea. I will change that.

By the way, I updated the first post with this http://www.getcis.com/trackme/index.zip

so it will always contain the latest changes of your files.
[Windows Mobile Apps and Games] _LEM_:
Yes, if you check the to-do list there is already similar request :)

I like the idea of being able to choose an icon. Thanks!

You will also be able to add a comment for that update.
[Windows Mobile Apps and Games] odie3:
Cool, you are right there is a similar request (without the custom Icon/Pin). ;)

BTW, I get page not found trying to click the link for index.zip.