*TrackMe* GPS/CellID Tracking tool for Google Earth & Google Maps *UPDATED 10/22/08*

[staryon]

the files are identical.
Don't you have any problems uploading GPS positions to your server from TrackMe?

It's weird if you don't get the same error, because the same script is used.

[daesimps]

the files are identical.
Don't you have any problems uploading GPS positions to your server from TrackMe?

It's weird if you don't get the same error, because the same script is used.

No problems at all. Positions are updated fine. Export works OK if I use a data range. It is just retrieving the list of trips that doesn't work.

[staryon]

I found the problem. It's in Trackme and the reason is because my logic sucks.

You are getting this result from the server:
Result:18.11.07_19.16.36|Trip_14.11.07_17.06.02

and TrackMe thinks that it's an incorrect password, because the string starts with Result:18.11.07_19.16.36|Trip_14.11.07_17.06.02

I'll fix it right now.

[daesimps]

I found the problem. It's in Trackme and the reason is because my logic sucks.

You are getting this result from the server:
Result:18.11.07_19.16.36|Trip_14.11.07_17.06.02

and TrackMe thinks that it's an incorrect password, because the string starts with Result:18.11.07_19.16.36|Trip_14.11.07_17.06.02

I'll fix it right now.

That makes sense and explains everything. Never even occurred to me! Would a (relatively) easy fix be to change the app/php so that it starts the trip list with "Result::" - i.e. with 2 colons. Not much of a change, but should resolve the problem

[staryon]

ok, try the new version I just uploaded.

This is a temporary fix. I should really change the logic in the PHP page, but just to make it easy for everybody, you just need to update the pda application.

Regards

[daesimps]

ok, try the new version I just uploaded.

This is a temporary fix. I should really change the logic in the PHP page, but just to make it easy for everybody, you just need to update the pda application.

Regards

Ah - I see you fixed it whilst I was typing my reply.

Thanks

[odie3]

This has to be "Globals" thing. I removed my php.ini file and this is how I was able to get the message that is attached.

1. Tools
2. Export GPS Positions
3. Select Trip (my where already there)
4. Location Source/Destination set to remote
5. Generate KML File Checked
6. Range unchecked
7 Click okay

First time with my php.ini installed it worked, 2nd time with it deleted I got the user/password error.

So, my question is - have you tried either the php.ini or .htaccess file trick?

NM - different problem (but there is still a global problem somewhere).

[daesimps]

This has to be "Globals" thing. I removed my php.ini file and this is how I was able to get the message that is attached.

1. Tools
2. Export GPS Positions
3. Select Trip (my where already there)
4. Location Source/Destination set to remote
5. Generate KML File Checked
6. Range unchecked
7 Click okay

First time with my php.ini installed it worked, 2nd time with it deleted I got the user/password error.

So, my question is - have you tried either the php.ini or .htaccess file trick?

NM - different problem (but there is still a global problem somewhere).

Staryon has fixed it. It was nothing to do with globals. My trip was "18_11_07". Therefore his requests.php returned "result:18_11_07". His application saw the "result:1" and interpreted this as a password failure.

As an aside I do not have register_globals switched on and never will. It is policy that this is never done on the server. Where variables haven't been declared I have been manually editing the files.

[Rescue9]

I enabled the globals line in php.ini and it kindof worked.

I no longer get errors on the client side, and it says that it generated the remote .kml correctly. This is where the positives end. :-P


The routes folder was not automatically created like you said it should be, and the .klm is nowhere to be found. I manually created the routes folder and still no .klm file. EDIT: I had to manually create the routes folder, but I fixed this issue by chmod 777 the routes folder. Now the .klm file is created.

In addition, I really don't want to enable globals in my php files just to use this. Is there a way around enabling globals? ADDITION: Just to verify, if the globals is turned off, I get the INVALID username/password error again.

[Rescue9]

I reworked the code in the exports.php as listed in this post: http://forum.xda-developers.com/showpost.php?p=1674951&postcount=486

After reworking this code and moving the variables to the top of the file, I no longer have to have the globals enabled in the php.ini file. In addition, I do NOT have a .htaccess file.

With these changes, I am now receiving uploads of the .kml file to the server.

Only problem that I see now, so far, is the fact that I had to manually create the routes folder and enable it 777.

[staryon]

Rescue9,

it seems that you were not using the latest version of the php files.
Check the first post and download the files for the manual installation and get the files export.php, requests.php and upload.php

Those files already include the variables declaration that was causing problems with some of you. They also create
the routes folder automatically.

[Rescue9]

I'll try again, but I'm pretty sure I downloaded those files after you posted the update a page or two back.

Will update in a while. :-D

[Rescue9]

Hmmm.... Are you sure you uploaded your new server zip? I tried this again and the code seems the same as it was when I edited it. In addition, the folder still isn't created when I use it the first time.

[staryon]

Are you downloading the files for the manual installation or the automatic installation?

[staryon]

jcleek,

For you install.php file, do you think there is a way to call a file that contains the script that creates the database? By doing that, you don't have to be updating this file all the time I make a modification to the database.
I'm not sure if that's possible.

My goal is to join your Automatic installation and my Manual Installation into one, so we have everything updated all the time.

[Rescue9]

I'm downloading the manual installation.

EDIT: Just checked the files... I'm definitely downloading the Manual installation, and the code in the exports.php is still borked.

I basically cut this:
$action = $_GET["action"];
$username = urldecode($_GET["username"]);
$password = urldecode($_GET["password"]);
$datefrom = urldecode($_GET["datefrom"]);
$dateto = urldecode($_GET["dateto"]);
$tripname = urldecode($_GET["tripname"]);

and pasted it right after
require_once('config.php');

Then it worked like a charm. Like I said though... still no auto folder creation.

[staryon]

I'm downloading the manual installation.

EDIT: Just checked the files... I'm definitely downloading the Manual installation, and the code in the exports.php is still borked.

I basically cut this:
$action = $_GET["action"];
$username = urldecode($_GET["username"]);
$password = urldecode($_GET["password"]);
$datefrom = urldecode($_GET["datefrom"]);
$dateto = urldecode($_GET["dateto"]);
$tripname = urldecode($_GET["tripname"]);

and pasted it right after
require_once('config.php');

Then it worked like a charm. Like I said though... still no auto folder creation.

oh... sorry about that. You're right, there was an error in the export.php file.
I just corrected it.

[jcleek]

Server files have been updated. Changes:

1) Install file will read config.php so you don't have to re-enter everything. Just don't replace your existing config.php if you already have a working install.
2) Install file will attempt to create the tables and if they are already there the new attribures for speed and altitude will be added
3) Speed and Altitude show up and I have matched Staryon's pushpin text.
4) Finally, this version is a public/private installation. Select the option you want in the config and that's what you get.

I still see passwords in the database are in clear text. I need to know when we are going to change those over so I can modify the code. If there is something I missed or can do better please let me know.

Latest version of server files (http://www.getcis.com/trackme/TrackMe_Server.zip)

[staryon]

yes, they are not encrypted yet. I'll let you know when that's done.

Thanks

[jcleek]

jcleek,

For you install.php file, do you think there is a way to call a file that contains the script that creates the database? By doing that, you don't have to be updating this file all the time I make a modification to the database.
I'm not sure if that's possible.

My goal is to join your Automatic installation and my Manual Installation into one, so we have everything updated all the time.

I will look into it... not sure.

[odie3]

...
4) Finally, this version is a public/private installation. Select the option you want in the config and that's what you get.
..

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?

[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.

[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).

[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 (http://www.getcis.com/trackme/TrackMe_Server.zip)

Also I have included the latest files from Staryons first post.

[Rescue9]

I forgot to update the config but I fixed it. Also a small refresh tweak on the last position.

Latest version of server files (http://www.getcis.com/trackme/TrackMe_Server.zip)

Also I have included the latest files from Staryons first post.

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?

[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";

[staryon]

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.

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

[staryon]

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!

[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. :)

[odie3]

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!

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).

[AndyInFl]

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!

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.

[staryon]

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.

Do you get the error when storing the GPS position or when generating the local KML file?

[AndyInFl]

Do you get the error when storing the GPS position or when generating the local KML file?

I get the error when generate KML is selected. If not seleceted it says storing position.

[staryon]

Give me 5 minutes and I'll give you a new version to test...

[staryon]

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... :(

[wafwot]

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!


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".

[staryon]

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".

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.

[AndyInFl]

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... :(

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!!!

[staryon]

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

[AndyInFl]

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

Config

Trip and positions deleted correctly.

Seems to work fine!

[adebilloez]

New version and documentation available!!

Check the first post for details.

Please feel free in expanding the documentation and/or correcting mistakes
if anyone is interested. I'm really bad writing documentation and also my English is not great :(

licht77, this new version contains what you asked for.

adebilloez, try to download the server files that I put in the first post (manual installation) just in case that resolves your problem.

Great it work now !!!

[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)...

[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 (http://www.getcis.com/trackme/TrackMe_Server.zip)

[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 :)

[staryon]

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 :)

Hi cruchot_,

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

[staryon]

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 (http://www.getcis.com/trackme/TrackMe_Server.zip)


AWESOME! That's perfect. I think that's all what we need to have just one installation package. If you are ok, you can provide me with updates of index.php and install.php and I will put those files with my files, so you don't have to worry every time I make a change.

By doing that, we offer just one link to the users, instead of having an automatic and a manual installation.

[cruchot_]

Hi cruchot_,

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

French settings (FRANCE)

[jcleek]

AWESOME! That's perfect. I think that's all what we need to have just one installation package. If you are ok, you can provide me with updates of index.php and install.php and I will put those files with my files, so you don't have to worry every time I make a change.

By doing that, we offer just one link to the users, instead of having an automatic and a manual installation.

Absolutely. So all you need from me are changes to:

install.php
index.php
config.php

If I make changes I will zip and email them to you and you can incorporate them in your first post. Can you clean up the first post a bit? Put the links at the top of the post so we don't have to search so far down and make the images a bit smaller? The more information added the more difficult it is to follow that post. Just my .02...

If you will grab the latest zip file (http://www.getcis.com/trackme/TrackMe_Server.zip) and get those files from it I will delete it from my server completely. Let me know when you have it and I will remove it.

From now on if you guys want the latest of my files get them from the first post on the main page of this thread. Staryon will provide update notices in the forum.

[mskovrinskie]

Is there a daemon mode for TrackMe? Ideally I would like to have this start automatically in the background so that it is always running on a reboot. As it stands now, if I drop a shortcut into \Windows\Startup, it will start but it leaves the GUI in the foreground and keeps the screen from powering off.

An option to run at startup in background would be great!

[cruchot_]

I've juste switched my regional setting to "English (United-States)" and it's working great :D

Thank you :)

[cruchot_]

I've just switched my regional settings to "English (United-States)" and it's working great :D

Thank you :)

[staryon]

Absolutely. So all you need from me are changes to:

install.php
index.php
config.php

If I make changes I will zip and email them to you and you can incorporate them in your first post. Can you clean up the first post a bit? Put the links at the top of the post so we don't have to search so far down and make the images a bit smaller? The more information added the more difficult it is to follow that post. Just my .02...

If you will grab the latest zip file (http://www.getcis.com/trackme/TrackMe_Server.zip) and get those files from it I will delete it from my server completely. Let me know when you have it and I will remove it.

From now on if you guys want the latest of my files get them from the first post on the main page of this thread. Staryon will provide update notices in the forum.

Ok! I just got the files. I will also change my first post. Good idea!

[odie3]

Well, the user/password get trips bug hit me this morning but getting the new cab fixed it. Before when I chose <NONE> for a trip name, the name would start with "Trip" then YYYYMMDD. Now it is just YYYYMMDD... why is that?

Also, all my positions had "0" for speed and Alt on my trip from home to work for some reason. I deleted most of my trips and ran it again outside my office, one time no Speed/Alt then the other 3 times it worked. Not sure what is going on there but I think *something* is lurking in the code that may not pass Speed/Alt up to the database.

[staryon]

I've juste switched my regional setting to "English (United-States)" and it's working great :D

Thank you :)

Let me test the program with the French settings just to see if I get the same error.

[staryon]

Well, the user/password get trips bug hit me this morning but getting the new cab fixed it. Before when I chose <NONE> for a trip name, the name would start with "Trip" then YYYYMMDD. Now it is just YYYYMMDD... why is that?


I removed the 'Trip_' because it looks very confusing when you are using GE with the realtime tracking.
Actually still looks confusing, so I may change it again :(

[odie3]

I am not 100% sure but I think that export.php needs updating, where the vars need to be higher in the file, like right below "require_once('config.php');"

Or at least that is what daesimps said a few pages back (http://forum.xda-developers.com/showpost.php?p=1674951&postcount=486).

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 (http://www.getcis.com/trackme/TrackMe_Server.zip)

[staryon]

French settings (FRANCE)

Ok, I think I fixed the program. Try downloading the program again.

[staryon]

I am not 100% sure but I think that export.php needs updating, where the vars need to be higher in the file, like right below "require_once('config.php');"

Or at least that is what daesimps said a few pages back (http://forum.xda-developers.com/showpost.php?p=1674951&postcount=486).

Yes, I fixed that problem yesterday. You can try to download the Installation package again from the first page. It contains the latest changes.

By the way, now we only have one installation package instead of a 'manual' and a 'automatic'

[jcleek]

I am not 100% sure but I think that export.php needs updating, where the vars need to be higher in the file, like right below "require_once('config.php');"

Or at least that is what daesimps said a few pages back (http://forum.xda-developers.com/showpost.php?p=1674951&postcount=486).

The export.php is Staryon's code so he is maintaining the master copy.

I have removed the zip file from my server so if you try to click one of the previous links you will get a 404. Get the files from the first post of this thread.

[odie3]

I just downloaded the files (again) to double check, export.php has NOT been updated where the vars are under "require_once('config.php');".

[jcleek]

Staryon, that first post is perfect now!

[staryon]

I just downloaded the files (again) to double check, export.php has NOT been updated where the vars are under "require_once('config.php');".

I just downloaded and it looks fine


require_once('config.php');

header("Content-type: text/xml");

if(!@mysql_connect("$DBIP","$DBUSER","$DBPASS"))
{
echo "<Result>2</Result>";
die();
}

mysql_select_db("$DBNAME");


$action = $_GET["action"];
$username = urldecode($_GET["username"]);
$password = urldecode($_GET["password"]);
$datefrom = urldecode($_GET["datefrom"]);
$dateto = urldecode($_GET["dateto"]);
$tripname = urldecode($_GET["tripname"]);


The declaration is not exactly under "require_once('config.php');" but that's not needed, because the variables are not used yet.

[staryon]

Staryon, that first post is perfect now!

Thanks a lot!

[odie3]

Oh, this is where I got the information about it being under the config section.

I'm downloading the manual installation.

EDIT: Just checked the files... I'm definitely downloading the Manual installation, and the code in the exports.php is still borked.

I basically cut this:
$action = $_GET["action"];
$username = urldecode($_GET["username"]);
$password = urldecode($_GET["password"]);
$datefrom = urldecode($_GET["datefrom"]);
$dateto = urldecode($_GET["dateto"]);
$tripname = urldecode($_GET["tripname"]);

and pasted it right after
require_once('config.php');

Then it worked like a charm. Like I said though... still no auto folder creation.

[odie3]

Okay, I *think* I recreated the no Speed/Alt issue. What I did was remove my php.ini file so I could test the export.php file (which worked for user/password) but when I went outside to get a position it was marked with no Speed/Alt.

Then I put my php.ini in and did it again, this time I got Speed/Alt on my marker. Is it possible we need to declare a var for Speed/Alt too?

[odie3]

@ jcleek

On the index, instead of using php round, use php number_format - this will keep the rounding in line with Staryon's code. Sorry for not seeing that before... that's my fault.

[mcwtrekkie]

Just tried this app on my Athena and it works perfectly, thankyou. A truely great app :)

[jcleek]

@ jcleek

On the index, instead of using php round, use php number_format - this will keep the rounding in line with Staryon's code. Sorry for not seeing that before... that's my fault.

Tell me what the line should say exactly and I will replace it.

[sarab99]

Is there a daemon mode for TrackMe? Ideally I would like to have this start automatically in the background so that it is always running on a reboot. As it stands now, if I drop a shortcut into \Windows\Startup, it will start but it leaves the GUI in the foreground and keeps the screen from powering off.

An option to run at startup in background would be great!


This is good suggestion hope staryon do it.

[staryon]

Just tried this app on my Athena and it works perfectly, thankyou. A truely great app :)

Thanks for letting us know! I'm always glad to hear some feedback from devices that are not Kaisers.

[odie3]

Tell me what the line should say exactly and I will replace it.

Example:
$html .= " var marker = createMarker(point, 'User: <b>" . $founduser['username'] . "</b><hr width=\"300\">Time: " . $row['DateOccurred'] . "<br>Trip: " . $tripname . "<br>Speed: " . number_format($mph,2) . " MPH (" . number_format($kmh,2) . " km/h)<br>Altitude: " . number_format($ft,2) . " ft (" . number_format($row['Altitude'],2) . " m)<hr width=\"300\"><b>TrackMe. Created by Luis Espinosa</b><br>http://www.luisespinosa.com');\n";

[mcwtrekkie]

Thanks for letting us know! I'm always glad to hear some feedback from devices that are not Kaisers.

Actually, sorry for the that. The app runs perfectly, but I've just tried loading the KML into Google Earth and the co-ordinates are wrong :( .. it say's I'm in Italy, where in fact im in the UK!

Any help would be appreciated, 'cos it's looks like a DAMN sweet app :)

[jcleek]

Staryon, check your PM. Need an email address to send the updated index to.

[staryon]

duplicate post

[staryon]

This is good suggestion hope staryon do it.

I'm trying to finish the current TO-DO list first, but I will take a look as soon as possible.

[staryon]

Actually, sorry for the that. The app runs perfectly, but I've just tried loading the KML into Google Earth and the co-ordinates are wrong :( .. it say's I'm in Italy, where in fact im in the UK!

Any help would be appreciated, 'cos it's looks like a DAMN sweet app :)

:p

yes, download it again. I use some dummy GPS positions for testing and I forgot to turn them off when I released the new version.
:D

[staryon]

Staryon, check your PM. Need an email address to send the updated index to.

hmm... I replied your PM this morning with my email address.
I'll try again.

[mcwtrekkie]

:p

yes, download it again. I use some dummy GPS positions for testing and I forgot to turn them off when I released the new version.
:D


Thanks staryon, thought it was something like that, as it seemed to get a GPS awfully quickly which doesn't usually happen on the athena ;)

Installed the latest version now, will try to test it on my way to work in a few minutes :)

Thanks again

[meathome22]

I get an error message when loading a *.kml in g-earth or g-maps. I am quite sure the reason is my language setting to "german", so coordiantes are written xx,xxxx (with comma). I have older kml files from a previous trackme version where coordinates where xx.xxxx (point) and have no problems.

[staryon]

I get an error message when loading a *.kml in g-earth or g-maps. I am quite sure the reason is my language setting to "german", so coordiantes are written xx,xxxx (with comma). I have older kml files from a previous trackme version where coordinates where xx.xxxx (point) and have no problems.

Do you think you can send me a PM with the KML file? It will help me to debug it.

Thanks

[staryon]

One more thing... how do you generate the KML files?
Storage = 'Remote' and Export='Remote'?

[meathome22]

One more thing... how do you generate the KML files?
Storage = 'Remote' and Export='Remote'?


Storage = 'local' and Export='Remote'

[ishkatar]

Hi jcleek:
Is there anyway you could port those PHP files into ASP (or ASPX)? I would like to incorporate the traking into my server, but I really don't know anything about PHP.
Thanks a lot!!!!
Ishkatar

[jcleek]

Hi jcleek:
Is there anyway you could port those PHP files into ASP (or ASPX)? I would like to incorporate the traking into my server, but I really don't know anything about PHP.
Thanks a lot!!!!
Ishkatar

Likewise I know absolutely nothing about ASP... sorry. But it is just the Google Maps API (http://www.google.com/apis/maps/). I wrapped some features into a page but it is just the API.

[staryon]

Storage = 'local' and Export='Remote'

[edited]

don't worry about it. I think I found problem.

Thanks

[ishkatar]

Likewise I know absolutely nothing about ASP... sorry. But it is just the Google Maps API (http://www.google.com/apis/maps/). I wrapped some features into a page but it is just the API.
Ok ... thanks anyways ... I'll try to figure out something ... jejejeje

[wkm1]

GOOGLE maps reports <LookAt> and <coordinates> has a syntax error.
My file is at http://www.via.at/voxcom/route.kml
The national setting (German language ROM) now creates for example
16,3853563666667 instead of 16.3853563666667 The comma behind 16
is wrong. It's upposed to be a '.' for GOOGLE.

A working file (edited by hand) is at
http://www.via.at/voxcom/routepoint.kml

rgards
wkm1

[staryon]

GOOGLE maps reports <LookAt> and <coordinates> has a syntax error.
My file is at http://www.via.at/voxcom/route.kml
The national setting (German language ROM) now creates for example
16,3853563666667 instead of 16.3853563666667 The comma behind 16
is wrong. It's upposed to be a '.' for GOOGLE.

A working file (edited by hand) is at
http://www.via.at/voxcom/routepoint.kml

rgards
wkm1

Are you using Storage=Local and Export=Remote?

[wkm1]

Are you using Storage=Local and Export=Remote? everything is in 'local' or 'Locally'. I do not have a GPRS or other
realtime links active during my tracking. I have uploaded the files later on,
from my PC into the Server site.
wkm1

[staryon]

I'm almost complete with my .Net version of the PHP code. I'll release the URL later. I'm about to have to start working A LOT but I'll continue to support it when I can. I'll be releasing the Source for whoever wants to add to it or whatever once it's at least to the point of functional :)

I have it to where you can embed an iframe in whatever site you want, I have a login so that only or users you create can view your map(s) (trips) and have it to where you can delete trips and trip data.

Before I release it I want to add functionality that'll enable it to e-mail people (need to figure out my relay SMTP server) and also add a feature stylize the routes per trip. So blue for Sunday and red for Monday for instance.

Later I'll enable it to where you can overlay (include) multiple trips and do other queries on the data. We have time and location with that data that are linked to specific trips... there's LOTS of cool reports we could run. I just need to come up with more ideas and have the time to develop it :)

hey DoughtCom,

Are you still working on this? I remembered you said that you were working on a module in ASP.Net 2.0
It would be awesome that you can give us an update.

Thanks

[staryon]

everything is in 'local' or 'Locally'. I do not have a GPRS or other
realtime links active during my tracking. I have uploaded the files later on,
from my PC into the Server site.
wkm1

I fixed the problem. I'm testing it now. I will be releasing a new version later today.

Regards

[thirdowl]

Staryon,

Excellent work, again! I used this throughout my trip last week and have found it performs phenomenally and provides a great way of sharing what I was up to traveling over seas!

I am planning on using my own server to host my routes, thanks to you and jcleek, now that I have things figured out, and was wondering if there is a way of getting my previous routes from your server and putting them on mine after I am done installing and configuring?

Thanks!

[Rescue9]

Just a guess as I have not tried this, but is it possible to open your previous routes inside Google Earth and save them kml file locally?

Had to do a complete reinstall after hard reset due to problems with someone else's crap software. I'll do a bit of tracking tomorrow to see if I find more bugs.

[staryon]

Staryon,

Excellent work, again! I used this throughout my trip last week and have found it performs phenomenally and provides a great way of sharing what I was up to traveling over seas!

I am planning on using my own server to host my routes, thanks to you and jcleek, now that I have things figured out, and was wondering if there is a way of getting my previous routes from your server and putting them on mine after I am done installing and configuring?

Thanks!

Just let me know when you have your server up and running, and I can create a script for your with all your data.

[staryon]

Just a guess as I have not tried this, but is it possible to open your previous routes inside Google Earth and save them kml file locally?

Had to do a complete reinstall after hard reset due to problems with someone else's crap software. I'll do a bit of tracking tomorrow to see if I find more bugs.

Yes, GE has an option to save the routes to a file.

[staryon]

New version available.

- Fixed problem generating local KML file and regional settings
- When using remote server, if timeout occurs it will retry 2 times. After that,
it won't try again until 2 minutes later (I may change this in the future so you can specify your own default values)

[odie3]

Staryon,

When I am driving down south out of Austin I drop from 3G to Edge and when this happens I have to turn off TrackMe and turn it back on. If I am moving from H to 3G I have no problems and I think moving from Edge to 3G/H is okay too. It's just dropping to (E)dge where I start to get connection fails (error is in red letters and I can not read the complete message).

So, any ideas about that and could it be solved with TrackMe? Or is that just the way it is (when moving from 3G to E)?

[staryon]

Odie3,

I just open a http connection, if for any reason I get an error I just display it. I cannot do anything about it. However, it shouldn't
be necessary to reopen TrackMe. As soon as the data connection is available again, it should connect.


By the way, there is a scroll bar at the bottom that you can move it right, so you can see the full messages.

[AndyInFl]

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";

Could someone explain something to me? I remeber when GPS devices first came out, I was told that there was a margin of error built into civilian GPS devices that would be accurate to around 15 feet or 15 meters, something like that. It was suppose to be so that a non military person could not get an accurate fix on a site for evil purposes, etc. Is this true today?

When I view my .kml files, Google Earth shows my points anywhere from my nearly exact location to a few hundred feet away on another property while the phone is sitting stationary on my desk. Also I am about 10 miles away from the ocean with no hills. (Florida is pretty flat.) My elevation shows I'm about 100 feet below sea level. I can understand a rounding error in a calculation but what I don't understand is why the same result doesn't continue given no device movement. There shouldn't be a margin of error in points on a stationary device, should there be?

Once again, thanks to all!

[AndyInFl]

Staryon,

Could you make an option or default the route.kml to the name of the trip .kml so when exporting the file it won't overwrite itself?

[staryon]

Could someone explain something to me? I remeber when GPS devices first came out, I was told that there was a margin of error built into civilian GPS devices that would be accurate to around 15 feet or 15 meters, something like that. It was suppose to be so that a non military person could not get an accurate fix on a site for evil purposes, etc. Is this true today?

When I view my .kml files, Google Earth shows my points anywhere from my nearly exact location to a few hundred feet away on another property while the phone is sitting stationary on my desk. Also I am about 10 miles away from the ocean with no hills. (Florida is pretty flat.) My elevation shows I'm about 100 feet below sea level. I can understand a rounding error in a calculation but what I don't understand is why the same result doesn't continue given no device movement. There shouldn't be a margin of error in points on a stationary device, should there be?

Once again, thanks to all!


Check this post just in case it helps
http://forum.xda-developers.com/showthread.php?t=338809&highlight=static+navigation

Tilt's GPS uses static navigation, so it doesn't work very well if you don't move or you move very slowly. So far I don't think there is a way of disabling static navigation with this model of GPS

Regards

[cruchot_]

Ok, I think I fixed the program. Try downloading the program again.

Hello,

It's working now with french regional settings :)

Thank you :cool:

[daesimps]

jcleek

I have had to put the following lines at the top of index.php in order to get the private login to work.

$username = $_REQUEST["username"];
$password = $_REQUEST["password"];

I have also had to change the following line as my server uses a non-standard port for http.

Change:

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

To:

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


This works on my server and handles http on a non-standard port and also an install directory other than trackme. Without this change the map just displayed the entire world!

[singrysweets]

Just test it in my appartment and it works great... one thing though, when i try to activate it through the internet on my phone it gave me an error... but when i turned on wifi and tried it again it work... any idea what that could be? if i'm on the go i would need the internet being that wifi is not everywhere


Any one knows why i'm only able to connect through wifi and not my media net?...any one?

[Tigggger]

Excellent work on this program guys..

Just a little code tweak you may find useful (now and in the future)


if (isset($_POST["action"]) && $_POST["action"] == "install")
{
$dbname = $_POST["dbname"];
$dbuser = $_POST["dbuser"];
$dbpassword = $_POST["dbpassword"];
$dbserver = $_POST["dbserver"];
$folder = $_POST["folder"];
$apikey = $_POST["apikey"];
$googleview = $_POST["googleview"];
$username = $_POST["username"];
$bgcolor = $_POST["bgcolor"];
$html .= " </div>\n";


to


@extract($_POST);
if (isset($action) && $action == "install"){
$html .= " </div>\n";


That automatically asigns all the variables to the names used in the POST, which in this case they are all the same. The same is possible with @extract($_GET) to get variables from a URL so .php?blah=1&something=2 does the same as $blah = $_GET["blah"] etc

Hope this helps

[powerppc]

JCleek,

Anyway to make the breadcrumbs to a smaller points and the latest position to have the big points? The way I see Google Maps is that it's confusing to see where I am currently if all the points have the same size. Especially if there are more than 30 points. Thanks for making it work, it's nice.

One more thing, since you are savvy at making Google Maps work with Luis stuff, could you try to make it PDA compatible with Yahoo Maps? It still won't be real time, but it gives people who wants to track their friends or family while on the move could be done through their PDA. That way, the mapping software don't have to be in the Trackme itself, making it more stable and less bloatware.

I've done some research and the way Yahoo Maps api works is that it reads the XML Lat and Lon. And you can specify the size of the map, making it compatible to PIE. Like this for example <a href="http://gws.maps.yahoo.com/mapimage">http://gws.maps.yahoo.com/mapimage</a>.

The developer site for Yahoo Maps API is <a href="http://developer.yahoo.com/maps/">Here</a>.

[jcleek]

JCleek,

Anyway to make the breadcrumbs to a smaller points and the latest position to have the big points? The way I see Google Maps is that it's confusing to see where I am currently if all the points have the same size. Especially if there are more than 30 points. Thanks for making it work, it's nice.

One more thing, since you are savvy at making Google Maps work with Luis stuff, could you try to make it PDA compatible with Yahoo Maps? It still won't be real time, but it gives people who wants to track their friends or family while on the move could be done through their PDA. That way, the mapping software don't have to be in the Trackme itself, making it more stable and less bloatware.

I've done some research and the way Yahoo Maps api works is that it reads the XML Lat and Lon. And you can specify the size of the map, making it compatible to PIE. Like this for example <a href="http://gws.maps.yahoo.com/mapimage">http://gws.maps.yahoo.com/mapimage</a>.

The developer site for Yahoo Maps API is <a href="http://developer.yahoo.com/maps/">Here</a>.

Sounds to me like you have enough information on Yahoo maps to give it a go yourself! I didn't know anything about the Google API until I started this project so...

As for changing the images based on last location I am not sure. Right now I am trying to figure out how to tie each point together in the order traveled like is shown on the KML display.

[jcleek]

Questions about historical data:

1) I am thinging about making the historical maps show a green icon for a start point and red icon for end (or current location) point
2) I am thinking about stringing the points together like on the KML files

What do you guys think?

[daesimps]

Questions about historical data:

1) I am thinging about making the historical maps show a green icon for a start point and red icon for end (or current location) point
2) I am thinking about stringing the points together like on the KML files

What do you guys think?

I was just about to post to ask if the archive view could plot lines to show the order of the points so I can work out the route taken.

You must be a mind reader:)

[staryon]

JCleek,

Anyway to make the breadcrumbs to a smaller points and the latest position to have the big points? The way I see Google Maps is that it's confusing to see where I am currently if all the points have the same size. Especially if there are more than 30 points. Thanks for making it work, it's nice.

One more thing, since you are savvy at making Google Maps work with Luis stuff, could you try to make it PDA compatible with Yahoo Maps? It still won't be real time, but it gives people who wants to track their friends or family while on the move could be done through their PDA. That way, the mapping software don't have to be in the Trackme itself, making it more stable and less bloatware.

I've done some research and the way Yahoo Maps api works is that it reads the XML Lat and Lon. And you can specify the size of the map, making it compatible to PIE. Like this for example <a href="http://gws.maps.yahoo.com/mapimage">http://gws.maps.yahoo.com/mapimage</a>.

The developer site for Yahoo Maps API is <a href="http://developer.yahoo.com/maps/">Here</a>.

Do you have an example of showing a KML file with Yahoo maps?

[staryon]

Staryon,

Could you make an option or default the route.kml to the name of the trip .kml so when exporting the file it won't overwrite itself?

Sounds good.

[jcleek]

Figured out the polylines for a trip from the database.

Go here (http://track.getcis.com/) and click the SHOW ARCHIVE button. Notice the polylines between points?

Next is custom colored icons for the first and last points in the trip. When I figure that out I will send Staryon a new file for the zip.

[daesimps]

Staryon,

I have noticed that requests.php is missing 2 declarations, resulting in no speed/altitude data

The following 2 lines need adding near the top with the rest of the declarations.

$altitude = urldecode($_GET["altitude"]);
$speed = urldecode($_GET["speed"]);

[staryon]

Staryon,

I have noticed that requests.php is missing 2 declarations, resulting in no speed/altitude data

The following 2 lines need adding near the top with the rest of the declarations.

$altitude = urldecode($_GET["altitude"]);
$speed = urldecode($_GET["speed"]);

Thanks for letting me know. I just fixed it.

[odie3]

Gee, that is what I was saying a few post ago (just did not know how to fix it). :(

[odie3]

daesimps, what about doing it like Tigggger suggested? I am not really sure what he mean but I am guessing with his code you do not have to remember declaring every new var...

Excellent work on this program guys..

Just a little code tweak you may find useful (now and in the future)


if (isset($_POST["action"]) && $_POST["action"] == "install")
{
$dbname = $_POST["dbname"];
$dbuser = $_POST["dbuser"];
$dbpassword = $_POST["dbpassword"];
$dbserver = $_POST["dbserver"];
$folder = $_POST["folder"];
$apikey = $_POST["apikey"];
$googleview = $_POST["googleview"];
$username = $_POST["username"];
$bgcolor = $_POST["bgcolor"];
$html .= " </div>\n";
to


@extract($_POST);
if (isset($action) && $action == "install"){
$html .= " </div>\n";
That automatically asigns all the variables to the names used in the POST, which in this case they are all the same. The same is possible with @extract($_GET) to get variables from a URL so .php?blah=1&something=2 does the same as $blah = $_GET["blah"] etc

Hope this helps

[daesimps]

daesimps, what about doing it like Tigggger suggested? I am not really sure what he mean but I am guessing with his code you do not have to remember declaring every new var...

I'm no PHP expert, but I have been advised against it as it is a similar security risk to having "register_globals" set to on. I found a few pages that talk about it's use. Here is a quote from one of them

"If you refer to a variable $username without initializing it beforehand, you may be wrongfully assuming that its initial value will be null. extract, like register_globals can falsify that assumption, allowing the variable $username to be initialised by end users. In short, it’s just like turning register_globals on again."

An example is Jcleek's index.php. He checked for a variable called "loggedin", which he sets in his code. If we used the code suggested above, then a user could pass a URL with a POST of loggedin=yes and the code above would automatically initialise this variable with the value "yes", thereby possibly bypassing the authentication code and proceeding as though a valid login had been performed. I have not verified jcleeks code to see if this would actually happen, but it is an example. I could, however, be completely wrong!

Based on that I prefer to declare the variables manually.

[odie3]

Good point... should stay as it is then. :)

[jcleek]

ch ch ch changes!

Ok guys, I did a lot of work today to improve the mashup but I have a real question for you: What purpose does it server to show the KML file on my google maps page? The last archive is EXACTLY the same as the KML file. It offers no added information at all. Why even have it? It is code that has to be maintained which takes time and effort. So the question is should I just remove the KML code from my page?

Now for the changes. I have added polylines between points AND I have color coded the markers on the archive maps. For an example:

1) CLICK HERE (http://track.getcis.com/) and click the SHOW ARCHIVE button. The start of the track is the green icon. The end of the track is the red one.
2) Click the SHOW LAST LOCATION button. See the red icon? That is the last known location.

Again, the only two things we really need are the archive and the last location. The KML needs to go away. I just need some consensus before I remove the code and produce a new version.

[staryon]

pretty cool! I think I am going to add the green and red icons in google earth as well.

I'm also thinking in replacing the pushpins with arrows, so you can see the direction on the map. Not sure how to do this yet.

[daesimps]

ch ch ch changes!

Ok guys, I did a lot of work today to improve the mashup but I have a real question for you: What purpose does it server to show the KML file on my google maps page? The last archive is EXACTLY the same as the KML file. It offers no added information at all. Why even have it? It is code that has to be maintained which takes time and effort. So the question is should I just remove the KML code from my page?

Now for the changes. I have added polylines between points AND I have color coded the markers on the archive maps. For an example:

1) CLICK HERE (http://track.getcis.com/) and click the SHOW ARCHIVE button. The start of the track is the green icon. The end of the track is the red one.
2) Click the SHOW LAST LOCATION button. See the red icon? That is the last known location.

Again, the only two things we really need are the archive and the last location. The KML needs to go away. I just need some consensus before I remove the code and produce a new version.

Sounds good to me. I only really use the last location and archive. I suppose there is the argument that you can use the PDA app to export based on date range instead of trip, thereby creating a kml which is a composite of multiple trips. Not something that I'd use, but I bet there'll be at least one person who uses it in this manner :)

[jcleek]

Also I can use any of these icons (http://www.visual-case.it/cgi-bin/vc/GMapsIcons.pl). Any ones in there more appropriate?

[jcleek]

Sounds good to me. I only really use the last location and archive. I suppose there is the argument that you can use the PDA app to export based on date range instead of trip, thereby creating a kml which is a composite of multiple trips. Not something that I'd use, but I bet there'll be at least one person who uses it in this manner :)

I didn't mean to get rid of the KML, just the SHOW KML FILE on my index page. It serves no purpose there except to duplicate data in a way that I can't control (icons, colors, polylines, etc).

[staryon]

hey jcleek,

a request here.... in the drop down for the trips, do you think you can add '<None>' and '<Any>'?

Regarding <None>....
With TrackMe it's possible not to assign positions to a specific trip, so the FK_TRIPS_ID field in the Position table is NULL.

<Any> will show everything in the database for that user.

I love your plugin man!

[staryon]

I didn't mean to get rid of the KML, just the SHOW KML FILE on my index page. It serves no purpose there except to duplicate data in a way that I can't control (icons, colors, polylines, etc).

I agree. I never use that option anyway ;)

[staryon]

Also I can use any of these icons (http://www.visual-case.it/cgi-bin/vc/GMapsIcons.pl). Any ones in there more appropriate?

Those look great! Actually I was looking for something like that now that I'm thinking in adding 'Force update'

For example, if you stop for lunch, you can force an update and choose the icon that you want to be shown later on the map.

[jcleek]

Those look great! Actually I was looking for something like that now that I'm thinking in adding 'Force update'

For example, if you stop for lunch, you can force an update and choose the icon that you want to be shown later on the map.

I can accomodate that in my code as well.

[jcleek]

hey jcleek,

a request here.... in the drop down for the trips, do you think you can add '<None>' and '<Any>'?

Regarding <None>....
With TrackMe it's possible not to assign positions to a specific trip, so the FK_TRIPS_ID field in the Position table is NULL.

<Any> will show everything in the database for that user.

I love your plugin man!

Done, but the ANY is simply too slow to be usable. You can look at my page and see what I mean. I only have about 8 trips on there... And I don't have any NULL examples so that map is blank for me.

[staryon]

Done, but the ANY is simply too slow to be usable. You can look at my page and see what I mean. I only have about 8 trips on there... And I don't have any NULL examples so that map is blank for me.

Thanks!!

When I use the Export function in TrackMe and I select <None> or <Any> I usually combine it with a Date Range, otherwise as you said, you will have too much data.

Another option would be that you add the Date Range... but I don't want to give you more work to do!! What you have done so far it's great.

[daesimps]

I didn't mean to get rid of the KML, just the SHOW KML FILE on my index page. It serves no purpose there except to duplicate data in a way that I can't control (icons, colors, polylines, etc).

What I meant is that you can use the PDA to search on a date range (therefore spanning multiple trips) and use it to create a kml file. How would you then display that kml?

Like I said, I don't use the kml, but there may be people who would want to use it in the manner I describe.

Anyway - good work. Can't believe how far this project has come.:)

[adebilloez]

Thanks!!

When I use the Export function in TrackMe and I select <None> or <Any> I usually combine it with a Date Range, otherwise as you said, you will have too much data.

Another option would be that you add the Date Range... but I don't want to give you more work to do!! What you have done so far it's great.

Now that I got these 2 superb apps working... thanks to the (2) authors!

Here's the usage that I plan for using :

* Share my today :follow-me ... -> last xxx positions
* Share my recurrent trip (I go work ..I go Tennis ...) -> simple Trip details
* I'm going in holiday, follow me ->I decide the start and destination to reach , friend can follow me and when destination is reached they get a mail.
* I'm near you, call me -> if my position is near to a marker the owner of the marker is notified so we can meet...

* And last but not least ...find friend near me! (already implemented)

Social networking are in the tube ... I'm sharing idea based on YOUR work sorry for that...



*

[justdavesj]

I'm trying to set up my own server for trackme. I have most of it working but when the application tries to upload the .kml file it gives an error. It looks like the requests.php file does not take the action kml into account. Is there a fix for this?

thanks

[jcleek]

What I meant is that you can use the PDA to search on a date range (therefore spanning multiple trips) and use it to create a kml file. How would you then display that kml?

Like I said, I don't use the kml, but there may be people who would want to use it in the manner I describe.

Anyway - good work. Can't believe how far this project has come.:)

My page only displays the username.kml file the PDA creates anyway and there is little point in re-writing code to do what the PDA can already do. The system isn't designed to allow you to store multiple KML files and to do so would be dumb anyway... that is what the MySQL database is for.

[jcleek]

Now that I got these 2 superb apps working... thanks to the (2) authors!

Here's the usage that I plan for using :

* Share my today :follow-me ... -> last xxx positions
* Share my recurrent trip (I go work ..I go Tennis ...) -> simple Trip details
* I'm going in holiday, follow me ->I decide the start and destination to reach , friend can follow me and when destination is reached they get a mail.
* I'm near you, call me -> if my position is near to a marker the owner of the marker is notified so we can meet...

* And last but not least ...find friend near me! (already implemented)

Social networking are in the tube ... I'm sharing idea based on YOUR work sorry for that...



*

As Staryon has discovered, there is no way to make this thing be everything to everyone. It long ago met my needs but I continue to develop based on needs that I believe are beneficial to everyone and worth the effort to produce. That's the beauty of open-source: you can make it do whatever you need it to. My google maps mashup is meant to display data that is on the server as a series of trips or a single (latest) point.

* Share my today :follow-me ... -> last xxx positions

Want to have someone follow you? Set up a public server, or give them your user name and password and the trip archive always shows the current (or most recent) track first.

* Share my recurrent trip (I go work ..I go Tennis ...) -> simple Trip details

Want to show your trip to work? Start a new trip called "Work" and drive to work. Trips are saved in the database and available from the trips list.

* I'm going in holiday, follow me ->I decide the start and destination to reach , friend can follow me and when destination is reached they get a mail.

Same as first point

* I'm near you, call me -> if my position is near to a marker the owner of the marker is notified so we can meet...

That is a great feature for you to figure out how to implement ;-)

As I said, we can't possible make it every single thing to every person without devekoping a monster; something we have repeatedly all agreed we DID NOT want.

[staryon]

I'm trying to set up my own server for trackme. I have most of it working but when the application tries to upload the .kml file it gives an error. It looks like the requests.php file does not take the action kml into account. Is there a fix for this?

thanks

never heard about that error.

Please provide more details... like the error type.
You say that you are uploading a kml file. In that case, the file has been generated on your pda, for that reason action='kml' is not called in the requests.php file, that's only if you are generating the kml file on your server.

[justdavesj]

never heard about that error.

Please provide more details... like the error type.
You say that you are uploading a kml file. In that case, the file has been generated on your pda, for that reason action='kml' is not called in the requests.php file, that's only if you are generating the kml file on your server.

You can see the error I get in the attachment.


The http for this request from the pda is as follows:

192.168.3.2 - - [19/Nov/2007:16:00:52 -0800] "GET trackme/export.php?action=kml&username=xxxxxxxx&password=xxxxxxxx&datefrom=2007-11-19%2010:0:38&dateto=2007-11-19%2017:0:38 HTTP/1.1" 200 30

The action=kml is what I'm referring to.

thanks

[justdavesj]

You can see the error I get in the attachment.


The http for this request from the pda is as follows:

192.168.3.2 - - [19/Nov/2007:16:00:52 -0800] "GET trackme/export.php?action=kml&username=xxxxxxxx&password=xxxxxxxx&datefrom=2007-11-19%2010:0:38&dateto=2007-11-19%2017:0:38 HTTP/1.1" 200 30

The action=kml is what I'm referring to.

thanks


I got it working now. I've had to add an include ('config.inc'); to all the beginning of all the php files. It seems that my version of php will not automatically include that. Also, I'm running mysql on linux and the database setup says it finishes without errors, but it does not set up the tables. I had to use the commands out of the database file and manually enter them into mysql.

Thanks for the great software.

[staryon]

I got it working now. I've had to add an include ('config.inc'); to all the beginning of all the php files. It seems that my version of php will not automatically include that. Also, I'm running mysql on linux and the database setup says it finishes without errors, but it does not set up the tables. I had to use the commands out of the database file and manually enter them into mysql.

Thanks for the great software.

Good. I'm glad it worked. However, keep in mind (based on the screenshot that you posted) that you were not uploading a kml file. The kml was being generated on the server.

[jcleek]

Ok, final draft of the updated version (http://track.getcis.com/). Comments?

1) I removed the KML display (redundant and not configurable)
2) Made the intermediate icons on a trip smaller and gray to make the start and end stand out

If you guys like this one I will update the private server implementation piece and send it to Staryon.

[staryon]

just one thing...

if you select <Any>, Trip name is not shown when you click on a pushpin.

[justdavesj]

Good. I'm glad it worked. However, keep in mind (based on the screenshot that you posted) that you were not uploading a kml file. The kml was being generated on the server.

Now I'm having a problem with the google map. I've attached a screenshot.

[jcleek]

just one thing...

if you select <Any>, Trip name is not shown when you click on a pushpin.

Fixed. Anything else?

[jcleek]

Now I'm having a problem with the google map. I've attached a screenshot.

That is not google maps. Did you install this on youe own server? It looks like the map size is set to 600 x 20.

[staryon]

Fixed. Anything else?

Good. It works now.
The only thing is always show the trip <Any>
Probably you hardcoded a variable for testing...

[justdavesj]

That is not google maps. Did you install this on youe own server? It looks like the map size is set to 600 x 20.

Yes, it's installed on my own server. I checked the height and width in the config file and they look fine (600x400).

The application is also having trouble connecting with the gps sometimes. I have an att 8525 with external bluetooth gps (holux m1000). Everything works fine the first time I start the application but if I stop it and try to start it again it just hangs at "waiting for GPS response." The only way I can get it working again is to soft-boot the pda. I have google maps and live search and they both work fine with the gps.

thanks

[jcleek]

Yes, it's installed on my own server. I checked the height and width in the config file and they look fine (600x400).

The application is also having trouble connecting with the gps sometimes. I have an att 8525 with external bluetooth gps (holux m1000). Everything works fine the first time I start the application but if I stop it and try to start it again it just hangs at "waiting for GPS response." The only way I can get it working again is to soft-boot the pda. I have google maps and live search and they both work fine with the gps.

thanks

Then something else is wrong, but I an not sure what. Even if your database is empty the map should show a blank world map. Give me a few minutes to finish up my changes and get it to Staryon then try installing the php files again.

[odie3]

Ok, final draft of the updated version (http://track.getcis.com/). Comments?

1) I removed the KML display (redundant and not configurable)
2) Made the intermediate icons on a trip smaller and gray to make the start and end stand out

If you guys like this one I will update the private server implementation piece and send it to Staryon.

That is pretty sweet, I like that a lot!

[androgyn]

Dear all. I am using this amazing program very well with my kaiser.
I tried to use it at my artemis too.
But unfortunately I got a pop up that PInvoke-DLL sqlceme30.dll ist not installed. After net frame 2.0 from Billy I thought it is done. But, no way. Same failure then w/o net frame.

What is to do? It can't be only for my kaiser, isn't it?

Best regards

Guido

[Eitel]

Then something else is wrong, but I an not sure what. Even if your database is empty the map should show a blank world map. Give me a few minutes to finish up my changes and get it to Staryon then try installing the php files again.


Check the config file. Mine was doing the same thing and I found out that is was calling pixels twice, as in "600pxpx"

[staryon]

Dear all. I am using this amazing program very well with my kaiser.
I tried to use it at my artemis too.
But unfortunately I got a pop up that PInvoke-DLL sqlceme30.dll ist not installed. After net frame 2.0 from Billy I thought it is done. But, no way. Same failure then w/o net frame.

What is to do? It can't be only for my kaiser, isn't it?

Best regards

Guido


Hi Guido,

The program should be compatible with any device running Windows Mobile and an internal/bluetooth GPS. Unfortunately I cannot test it with other devices, because I only have the kaiser. However, I know some other people who are using it with other PDAs and Smartphones.

Anyway, try to copy the following file to the folder where you have the program installed, just in case it resolves the problem. It seems that you are missing the library to access SQL Server Mobile databases.

http://luisespinosa.com/temp/System.Data.SqlServerCe.dll

[Eitel]

staryon, I have a request. Right now the program stores and uploads every X amount of time (both are the same). Could you set the times diferent? As in store location every X time and upload every X time. Example, mark points every 30 seconds but upload every 2 minutes.

[justdavesj]

Check the config file. Mine was doing the same thing and I found out that is was calling pixels twice, as in "600pxpx"

That was the problem.

thanks

[AndyInFl]

Here is a suggestion:

I think (I'm not a programmer) that some useful information could be easily added to the info captions that are generated by doing some calculations of the date already stored in the trips.

1. It maybe be helpful to include a point number of each position. The polylines would seem to overlap when traveling in a small radius. If someone recorded positions that required back tracking or over/underpass driving in trafic, the lines might be difficult to decern.

2. Presently, the start and end point are being determined. So by taking the start and end times, you would know the total trip time / distance / number of positions / average speed.

As long as the data is present in the trip, I believe it would be useful to display.

Here's my suggestion of a possible info caption.

Again, thanks to all!

[staryon]

staryon, I have a request. Right now the program stores and uploads every X amount of time (both are the same). Could you set the times diferent? As in store location every X time and upload every X time. Example, mark points every 30 seconds but upload every 2 minutes.

I'm sorry Eitel, but I prefer to keep the program simple. I think that can confuse some people because they may think that something was uploaded when it was not because it was in the buffer. On the other hand, I think one timer is enough.

thanks for your suggestion though

[jcleek]

Staryon has the updated index.php and will update the zip after we can work out a small bug. Changes include:

1) I literally cut the code down to less than half of the previous version. The code was trimmed down to remove the KML section and consolidated the map drawing for both the pub and priv setups to share the same code.
2) All points are now connected in the drawn map by polylines.
3) Points are color coded for the start (green), end or current (red), and intermediate (gray) points.
4) Trip options added for NONE and ANY. Note: the ANY page can take a long time to display if you have a lot of points in your table!

Things still to do:

1) Change the private login to use session cookies vs passing the username and password on every submit. This will allow the current position page to refresh like it does on the public implementation.
2) Explore options proposed by AndyInFl - great ideas
3) Clean up code to use style sheet instead of depreciated code

Staryon, check your email...

[URPREY]

Hi - I have a problem hopefully someone can help me with. I used the program today to track a short trip, and everything showed on the screen to be uploading. however, when I pull up the trip in Google Earth, all of the points are blank with no lat/lon or speed or anything. I also cannot log into the trackme website with the user ID and password I initially chose. Is there an issue with my login account or something else? This is on my Tilt. Thanks!

[edit]I figured out the issue. It was a password problem. Thanks[edit]

[staryon]

Staryon has the updated index.php and will update the zip after we can work out a small bug. Changes include:

1) I literally cut the code down to less than half of the previous version. The code was trimmed down to remove the KML section and consolidated the map drawing for both the pub and priv setups to share the same code.
2) All points are now connected in the drawn map by polylines.
3) Points are color coded for the start (green), end or current (red), and intermediate (gray) points.
4) Trip options added for NONE and ANY. Note: the ANY page can take a long time to display if you have a lot of points in your table!

Things still to do:

1) Change the private login to use session cookies vs passing the username and password on every submit. This will allow the current position page to refresh like it does on the public implementation.
2) Explore options proposed by AndyInFl - great ideas
3) Clean up code to use style sheet instead of depreciated code

Staryon, check your email...


Done. New version is ready to download.

[Eitel]

I'm sorry Eitel, but I prefer to keep the program simple. I think that can confuse some people because they may think that something was uploaded when it was not because it was in the buffer. On the other hand, I think one timer is enough.

thanks for your suggestion though

That's ok. I was just thinking that moving less data may be better for people that don't have unlimited data. Not my case thou, and the transfers are still small.

[staryon]

Hi - I have a problem hopefully someone can help me with. I used the program today to track a short trip, and everything showed on the screen to be uploading. however, when I pull up the trip in Google Earth, all of the points are blank with no lat/lon or speed or anything. I also cannot log into the trackme website with the user ID and password I initially chose. Is there an issue with my login account or something else? This is on my Tilt. Thanks!

Hi Urprey,

I checked the database and you're right. The points are there, but they are all empty but the last 3. I have never seen something like that!
Please try again and let me know if it keeps happening. Maybe your GPS was not initialized correctly or something...

[androgyn]

Hi Guido,

The program should be compatible with any device running Windows Mobile and an internal/bluetooth GPS. Unfortunately I cannot test it with other devices, because I only have the kaiser............

Thank you. I got it to the point the software freeze on my unit. Will say if I use the standard GPs setting like Com4 no HW port and automatic managed by MS the SW will freeze. If I unckeck automatic, no port found. If HW port 2, nothing will happen.

I know myself that we are in the Kaiser and not in a Artemis thread, so I just want to thanks to all for their patience.

best Regards

Guido from Cologne/Germany

[staryon]

Sorry guys.

Download the files again, I made a mistake in the index.php file.

http://luisespinosa.com/bin/TrackMe_Server.zip

[staryon]

Thank you. I got it to the point the software freeze on my unit. Will say if I use the standard GPs setting like Com4 no HW port and automatic managed by MS the SW will freeze. If I unckeck automatic, no port found. If HW port 2, nothing will happen.

I know myself that we are in the Kaiser and not in a Artemis thread, so I just want to thanks to all for their patience.

best Regards

Guido from Cologne/Germany

I'm sorry you are having problems with the program.
Just in case, could you try with this other program that another user wrote?

http://forum.xda-developers.com/showthread.php?p=1589423#post1589423

It's a program that checks the GPS connectivity.

Thanks

[staryon]

That's ok. I was just thinking that moving less data may be better for people that don't have unlimited data. Not my case thou, and the transfers are still small.

Eitel, correct me if I am wrong... even if I don't upload the data now, I would have to do it later, so the same bandwidth would be used...

[androgyn]

I'm sorry you are having problems with the program.
Just in case, could you try with this other program that another user wrote?

http://forum.xda-developers.com/showthread.php?p=1589423#post1589423

It's a program that checks the GPS connectivity.

Thanks

Thanks again for answer. Yes, with TomTom on original configuration it works fine. I will play around a little bit next day. I will let you know what is going on.

BR

Guido

[jcleek]

AndyInFl asked for these fields to be added to the baloon information for each point:

Total Time: The total time is relatively easy. The date/time format needs to be converted to *nix timestamp for calculations and then back after calculating.

Distance: Distance is also relatively easy but will not be accurate at all. I question the value of this information. Say you travel in a 100 mile circle at 100 miles per hour. In an hour you travel 100 miles, right? If you have the GPS set to get a new position every hour it will show you didn't travel at all.

Average Speed: Not possible using current tables. Data in the speed colum is stored as a DOUBLE field type and can not be averaged. I could count each speed entry and divide by total entries but that is like 8 or 9 lines of code to do a standard MySQL AVG function which is a single DB query.

Point number of total points: Again easy to do but why? You can have a 100 mile trip with 10 points or 10,000. What does that really tell you? What value does it add and is it worth the effort to put it in?

After giving a total of about 5 minutes of thought I think that the only items that would have any value is the average speed and total time. I will look into how to do the speed without the column being an INT field and the time calculations.

[staryon]

Thanks again for answer. Yes, with TomTom on original configuration it works fine. I will play around a little bit next day. I will let you know what is going on.

BR

Guido

Guido,

The program is in the first post. It's called GPSInit

[staryon]

Average Speed: Not possible using current tables. Data in the speed colum is stored as a DOUBLE field type and can not be averaged. I could count each speed entry and divide by total entries but that is like 8 or 9 lines of code to do a standard MySQL AVG function which is a single DB query.


jcleek,

I tried with these values


Edit Delete 0
Edit Delete 0
Edit Delete 0
Edit Delete 0
Edit Delete 0
Edit Delete 0
Edit Delete 0
Edit Delete 0
Edit Delete 0
Edit Delete 0
Edit Delete 25.317
Edit Delete 25.417
Edit Delete 25.218
Edit Delete 25.502
Edit Delete 25.511
Edit Delete 21.28
Edit Delete 23.822
Edit Delete 27.566
Edit Delete 28.218
Edit Delete 25.015
Edit Delete 21.407
Edit Delete 23.013
Edit Delete 25.583
Edit Delete 25.437
Edit Delete 25.647
Edit Delete 25.663
Edit Delete 25.612
Edit Delete 25.387
Edit Delete 25.613


and this function:
select avg(speed) from positions where fk_users_id=1

and it returned 19.637026666667

That's what you need, right?

[grizzley]

Just FYI, I had alot of problems getting GPS to read during a recent plane trip. No program (Google Maps, TomTom, TrackMe, etc...) could find satelites.

I was on 8 different airplanes and only 1 of those planes could get GPS readings.

[odie3]

*Idea but may be stupid*

So, I was playing around Google Earth yesterday and was clicking Camera icons. You know it would be cool to upload pictures that you have taken and when you click on a marker you get a picture in the pop-up (if one was uploaded with that position). Might be a whole lot of work and perhaps not possiable with the API and meta data tags.

This kind falls into the Comment and custom markers...

[odie3]

Sorry guys.

Download the files again, I made a mistake in the index.php file.

http://luisespinosa.com/bin/TrackMe_Server.zip

Thanks to you and jcleek! Page is coming along very nicely!

[AndyInFl]

AndyInFl asked for these fields to be added to the baloon information for each point:

Total Time: The total time is relatively easy. The date/time format needs to be converted to *nix timestamp for calculations and then back after calculating.

Distance: Distance is also relatively easy but will not be accurate at all. I question the value of this information. Say you travel in a 100 mile circle at 100 miles per hour. In an hour you travel 100 miles, right? If you have the GPS set to get a new position every hour it will show you didn't travel at all.

Average Speed: Not possible using current tables. Data in the speed colum is stored as a DOUBLE field type and can not be averaged. I could count each speed entry and divide by total entries but that is like 8 or 9 lines of code to do a standard MySQL AVG function which is a single DB query.

Point number of total points: Again easy to do but why? You can have a 100 mile trip with 10 points or 10,000. What does that really tell you? What value does it add and is it worth the effort to put it in?

After giving a total of about 5 minutes of thought I think that the only items that would have any value is the average speed and total time. I will look into how to do the speed without the column being an INT field and the time calculations.

Just my thoughts:

I saw the conventional uses of the program and also can see a few unconventional ones that I and possibly others could use. As someone who spends time on the water and and on the trails, this program would allow me to create a database of trips not available to me with conventional street maps; places where there are no roads. Just thought a plotter type program built into the phone would mean one less device needed to have fun.

As a parental or employee watchdog type program, this information could be used to track location/performance of child, delivery, etc..

Total Time: Just a matter of record for a repeat trip.

Distance: Just like having an odometer on the car.

Average Speed: The rental car companies used to use this to issue company speeding tickets when the GPS first came out. Good monitor.

Point Number: Just a way of tracking where you where in which order.

Again, just thoughts.... I always try to look at the given item/situation and think how I can use something in a different matter than it was intened for and still gain a significant value. One man's junk is another man's treasure.

Why have elevation when so far it isn't even close to accurate. If I drive in the flat lands of Florida and the elevation in reality doesn't change regardless of the amount of time or distance, then what does that really tell me?

Thanks for everyone's efforts.

[wafwot]

Also I can use any of these icons (http://www.visual-case.it/cgi-bin/vc/GMapsIcons.pl). Any ones in there more appropriate?

Great idea for different color stop and start markers!

Is it possible to use a different color for current location map, say orange, or blue? Or yellow or purple?

[jcleek]

*Idea but may be stupid*

So, I was playing around Google Earth yesterday and was clicking Camera icons. You know it would be cool to upload pictures that you have taken and when you click on a marker you get a picture in the pop-up (if one was uploaded with that position). Might be a whole lot of work and perhaps not possiable with the API and meta data tags.

This kind falls into the Comment and custom markers...

There are mashups out there already that will do exactly that.

[jcleek]

Great idea for different color stop and start markers!

Is it possible to use a different color for current location map, say orange, or blue? Or yellow or purple?

I would have to add in a whole new section of code just to accomodate a new color. As it is, it is the last (and only) icon on the page so it gets red just like a page with a hundred icons. Lot of work just for a color change.

[wafwot]

Why have elevation when so far it isn't even close to accurate. If I drive in the flat lands of Florida and the elevation in reality doesn't change regardless of the amount of time or distance, then what does that really tell me?

This is true. A 3D fix requires at least 4 satellites, and I usually have 7 or 8 locks, but elevation is all over the place. I've tested this out on roads I traveled multiple times a day for more than a decade. I know the road is a 6 degree incline, but my phone maps it with more rise and falls than a roller coaster!

How hard would it be to make logging speed and elevation an option?

[wafwot]

I would have to add in a whole new section of code just to accomodate a new color. As it is, it is the last (and only) icon on the page so it gets red just like a page with a hundred icons. Lot of work just for a color change.

Heh... Smaller is better!

[staryon]

Just my thoughts:

I saw the conventional uses of the program and also can see a few unconventional ones that I and possibly others could use. As someone who spends time on the water and and on the trails, this program would allow me to create a database of trips not available to me with conventional street maps; places where there are no roads. Just thought a plotter type program built into the phone would mean one less device needed to have fun.

As a parental or employee watchdog type program, this information could be used to track location/performance of child, delivery, etc..

Total Time: Just a matter of record for a repeat trip.

Distance: Just like having an odometer on the car.

Average Speed: The rental car companies used to use this to issue company speeding tickets when the GPS first came ou