yashsingh1/xdaforums huggingface dataset:
[Windows Mobile Apps and Games] _LEM_:
The best way of doing that (at least is how I do it) is storing the points remotely. By doing that, every time that the KML file is generated (you can create it automatically with every new point uploaded), you can have access to the KML using a URL. Something like http://luisespinosa.com/trackme/routes/USER.kml

(click on 'Show Generated filenames' to see the exact URL)

Once you have that, go to Google Earth and click on 'Add network link'. Enter the URL, check 'Fly on refresh' and specify a time period (I usually enter 30 seconds).

And you're done!

PS: I plan to write a manual this weekend for the program... so stay tuned!

Regards
[Windows Mobile Apps and Games] grizzley:
Wait....

Why is there a database? What is the use? The script reads from the KLM file, not the database where the routes are stored.

What am I missing?

When you go to index.php, that page just reads the /routes/user.klm file, NOT the database. So, you have a big old database full of routes, but how do you access them?
[Windows Mobile Apps and Games] _LEM_:
The KML files are like subsets of the database. You decide how to generate the KML files. You can generate a KML file using all your points from any trips, for a given trip, or for trips with no names. You can also specify a date range.

By having a database you have ALL your data stored, from all your trips. You will never lose that data.

When you choose 'Realtime tracking' what it really does is to create a KML file using the last 6 hours of data that you have in the database.

Hope it helps.
[Windows Mobile Apps and Games] grizzley:
Sorry, I still dont get it.....

Tell me this, maybe this will help me understand.....

I have a database of routes. How do you access any of those via the web?

In order to access them, you have to manually create a new PHP page to view "trip 1" and another page for "trip 2".

I don't know. There just donset seem to be any of the pages (index mainly) that selects or pulls the database, in ONLY gets /routes/my.klm

If it referenced the database, or had a way to select them, or anything, I might understand....

Are you saying that the klm files on the server are pulling data from the database?

sorry.
[Windows Mobile Apps and Games] kiwikenji:
Staryon, your the man! I was not aware of the 'Add network link' on Google Earth. I was just placing the URL under >FILE>OPEN. I will give this a try tomorrow. Good idea on writing a guide for newbies....when i first set this up I was completely lost. Again "buen trabajo"!
[Windows Mobile Apps and Games] jcleek:
You are correct. The index.php file I wrote does not access any databases. You need the databases for the WM application to have a place to store data. The index page displays the KML file you tell it to. It can be a KML produced by the WM application or one you downloaded from your sister Lucy's web server. It doesn't matter. I wrote the page for the specific task of displaying the contents of the KML file. If you want the page to read data directly from the database, change the code and make it do that and then come back here and share what you made just like Staryon, Doughtcom and I have done. Unfortunately it is impossible to give everyone everything they want with a single solution....
[Windows Mobile Apps and Games] grizzley:
OK, I understand. I just didn't know what it was doing. So it appears that your script does two things. I am going on vacation and upon my return I will try to add a page that reads the database and allows selection of which database to display. I wont redo what you did, just add to it.
[Windows Mobile Apps and Games] _LEM_:
Yes, what jcleek mentions in correct. Just one more thing for making more clear.

If you don't want to have your own server to store the GPS positions and you don't want to store them on your PDA either, you can just use my server. When you run the program for the first time is already configured with that. You just need to enter a username and password (whatever you want) and start uploading data.

Once you are doing that you can generate KML files automatically if you need realtime tracking. If you don't care about this and you just want to see your trip later today or any other day, just forget about the 'Realtime tracking' tab, and go to Tools->Export Data when you are ready to create your KML file.

Regards
[Windows Mobile Apps and Games] jcleek:
Awesome! Can't wait to see what you come up with.

You guys can check this out:

Selectable KML files

Is that what some of you are looking for?
[Windows Mobile Apps and Games] odie3:
What we looking at, I am not seeing anything Selectable... :(

Okay, I am getting a drop down now - that is SWEET! I want that! :) :)
[Windows Mobile Apps and Games] jcleek:
Click the link again. You are too fast. About 2 seconds after I posted it I changed it... sorry! It just lists all KML files in the routes folder.
[Windows Mobile Apps and Games] odie3:
LOL - sorry :( I had just refreshed the page thinking that might have been the issue. I see the drop down, I was hoping something like that would happen!

Look forward to that release!
[Windows Mobile Apps and Games] jcleek:
Here you go. Rename it to index.php. Search for GOOGLEAPIKEY and put in your API key. That should be all you need to change.
[Windows Mobile Apps and Games] jcleek:
Ok, found information on getting data from a MySQL database and here is what I am thinking. A page comes up with a form pre-populated with the user names in the database in a drop-down list. You select a name (Slacker) and the next drop-down is auto-populated with trip names for that user. You select the trip you want for that user and hit submit and a map page loads with the information relating to the trip you selected. Is that what you guys think you are asking for?
[Windows Mobile Apps and Games] daesimps:
Absolutely spot on. It's the idea I posted a while back, but with the addition of the username section. That would be perfect.

Please don't take this as an ungreatful please for further work. I appreciate everything you guys have done and the result is awesome. It was just an idea on how it could be expanded a bit. If I knew anything about web design or PHP I would have had a go myself.

Keep up the good work.
[Windows Mobile Apps and Games] jongaynor:
FYI - this happened to me too. I'm going to follow your 'destroy and re-install' method tomorrow. My server & DB are hosted at dreamhost - are yours as well? I only ask because they frequently do stupid crap without telling users.
[Windows Mobile Apps and Games] turtle2472:
Here's a message I sent to my webhost to see what they have to say about the cellid php files. I'll post the updates and what they say when I get another response.
[Windows Mobile Apps and Games] jefmcg:
Edited!

I had a problem connecting to my server, but it turns out that my problem was that i need to upgrade the server side software.

Sorry, I haven't had time to read the previous postings, so I hope I didn't lead anyone astray.

joan
[Windows Mobile Apps and Games] tunstp00:
Fantastice Bit of software have got running on HTC Tytn II wityh your server am in process of building own server. So far so good.

One little problem I have latest version screen shots you provide must be from an old version.
[Windows Mobile Apps and Games] _LEM_:
It seems that the problem is you updated your client without updating your server files.
[Windows Mobile Apps and Games] _LEM_:
yeah, I have made many changes since then. Unfortunately I haven't found anybody interested in keep updated the documentation so I only do it every 3 or 4 months when I have some time.
[Windows Mobile Apps and Games] turtle2472:
This is the comment back from my host admin. I'm not sure if these are changes you can make or if you should, but I wanted to make sure you knew.

The it was followed by this message.
[Windows Mobile Apps and Games] _LEM_:
Good, so it seems that the Google database should be working ok for you now.

Regarding the TrackMe database, it's possible that you are missing a table.

Here is the code that creates that table:

CREATE TABLE `cellids` (
`ID` int(11) NOT NULL auto_increment,
`CellID` varchar(255) NOT NULL,
`Latitude` double NOT NULL,
`Longitude` double NOT NULL,
`DateAdded` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`ID`),
KEY `Index_CellID` (`CellID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

However, I'm thinking in changing that. It doesn't make sense that people using their own servers go to this table stored on their server. It should go to the table stored on my server which has information from many users.

I will try to change that soon.
[Windows Mobile Apps and Games] tunstp00:
Upload Fails - Invalid URL

I am running the latest Mobile software on an HTC Tytn II.

Works great when using your web site. All functions Work.

Have built my own server but when I change the remote settings to point at it I get an error.

Failed to upload position:Invalid URL: The hostname could not be parsed.

I have checked remote settings they are set as follows:-

Server IP xxxxxxx.info Port 80

Root Folder/trackme Ext php

Any idea what the problem may be?
[Windows Mobile Apps and Games] _LEM_:
Server files updated!

Ok, I have updated the files cellid_trackme.php and I added cellid_local.php

The advantage of this is for people that are using their own server since they will be able to get cellid data from the TrackMe database when they select 'trackme' in the database list, instead of going to their own cellid table.

If you want to get data from your own cellid table, then use database 'local' from now on.

Let me know if you guys have questions about this, because I think it can be a little bit confusing.
[Windows Mobile Apps and Games] _LEM_:
Do you think you can send me your config.dat file to ?
[Windows Mobile Apps and Games] turtle2472:
Do we need to add another table or other sql change? Are we just uploading and replacing these two files?

Also, is our "logging of cell ID" going to both local and your server?
[Windows Mobile Apps and Games] _LEM_:
- No sql changes.

- cellid_local.php is a new file, so you just need to add it.

- cellid_trackme.php has been modified, just overwrite the one that you already have.

- "logging of cell ID" goes to the server that you have specified in 'Remote'
[Windows Mobile Apps and Games] turtle2472:
Cool, thanks. So you won't be getting updates from those of us running our own servers.

Thinking of extra features and my suggestion to have multiple profiles would allow me and others with their own servers to hop on yours and play with the nearest buddy feature.
[Windows Mobile Apps and Games] jongaynor:
Damn. You're right. I've donated for my insolence! (also because this product is awesome)
[Windows Mobile Apps and Games] flewid:
Great App

Just wanted to say thanks for the app. Installed it, and the server tonight on my Kaiser and works great. Can't wait to test it furthur away than just my driveway/street :)
[Windows Mobile Apps and Games] tunstp00:
I sent the file last night hope you got it OK
[Windows Mobile Apps and Games] _LEM_:
Thanks! actually it was also my fault. I should add some kind of mechanism that detects if somebody upgraded the client but they didn't updated the server files.
[Windows Mobile Apps and Games] _LEM_:
thanks! have fun with it!
[Windows Mobile Apps and Games] _LEM_:
I sent you an email back last night explaining everything. Didn't you get it?
[Windows Mobile Apps and Games] NotShorty:
Hey, this program is really impressive!

I just started goofing around with Google Gears for Windows Mobile and it occurred to me that if TrackMe worked in Gears, it would draw quite a bit of attention.

http://code.google.com/apis/gears/mobile.html

Prob more work than it's worth though considering how well TrackMe works as it is :D

Anyway, just a thought. Cheers!

NS
[Windows Mobile Apps and Games] tunstp00:
Server Problems

Thanks I found the email.

The invalid host name is solved I need to learn how to type.

Now when I try and upload I get:-

I SEEM TO HAVE CURED THIS NOW BUT HAVE UPDATED WITH HOW I FIXED

(I Hope)

The remote server returned an error: (500) Internal Server Error.

Plus the error that you encountered.

'PHP has encountered an Access Violation at 011BB74E'

Anyway I have emailed you with copies of the ini files for PHP and MYSQL just in case I have something wrong there.

I am using a MS Server 2003 IIS6 with PHP 5.2.6 and MYSQL 5.0.67 GA release installed

I struggled a bit with PHP but used a test page I found that seemed to show it was OK and used the SQL wizard to do the database and install.php manged to set the database up though it could not do the config.ini I did that by hand.

my.ini and php.ini attached

I just knew that the server could not be as easy as it looked, ho hum I'll keep on trying any way.

Well I kept going and got a bit further I have redone my PHP.ini and I apear to have cured the problems above.

It seems that because of some dependancies between the PHP Extentions it can be very important what order they are loaded in the file. See link below it helped me sort things out a bit.

http://www.corephp.co.uk/archives/36-A-Guide-to-using-PHP-5-Extensions-on-Windows.html

Now I have a different Problem which I will raise on a new post.
[Windows Mobile Apps and Games] harty83:
I have Garmins 3 full rom installed which had netcf 3.5 and sqlce 3.5 built into the ROM. All my other .net apps run fine except trackme. I've used netcfconfig to verify my version (3.5.7283.0) and even told it make sure trackme uses it but trackme still will not cooperate

I get:

File or assembly name 'System.Data.SqlServerCe, Version=3.5.0.0, Culture=neutral, PublicKey Token=3BE235DF1C8D2AD3', or one of its dependencies, was not found.

Then it gives me a .NET CF initialization error.

Any clues on this?

Thanks!

Alan
[Windows Mobile Apps and Games] tunstp00:
Unable to create User

Having resolved my earlier problems see post #3203 I have got a bit further but am still unable to download data to my server.

Now when I track I get the following errors after Uploading XXX:-

User didn't exist and system was unable to create it

&

Check you are entering a username and password in the account information.

( I am using a Windows 2003 Server with PHP 5.2.6 and the latest SQL which all seems to be installed OK. Followed instructions for installing trackme bits to the letter and the config.dat on the phone hase been checked and is OK)

HELP What have I missed? :confused:
[Windows Mobile Apps and Games] _LEM_:
I have the impression that maybe your tables were not created correctly.

Could you double check that you have a table called 'Users'?
[Windows Mobile Apps and Games] tunstp00:
Yes that appears to be the case, how do I create the tables?
[Windows Mobile Apps and Games] _LEM_:
If you followed the steps contained in the Read_Me.txt file that mcross wrote, after running the file install.php, the SQL tables should have been created.

Did you do that part?
[Windows Mobile Apps and Games] tunstp00:
Yes I did all that. The respose after running the script was

"TrackMe Server Side Installation

Database tables created successfully

ERROR: config.php can not be opened. You need to edit it manually.

Remember to create two folders ("routes" and "pics") in your TrackMe folder.

If there are no errors listed above then the installation of server side files and tables is complete. You MUST delete the install.php and database.sql files before the map page will display. Once you delete install.php you can click here to view your custom map.

If you have not installed the application on your Windows Mobile Professional device you can download the latest version here

Tracking information provided by TrackMe"

I edited the config.php by hand as required.

Any ideas !!
[Windows Mobile Apps and Games] _LEM_:
hmmm... I cannot help too much about that because I never tried that script.

However you can try to run the file database.sql from MySQL manually. That should create all the necessary tables if they are not there
[Windows Mobile Apps and Games] tunstp00:
Eurika I have finally sorted, I hadn't actually created a database. No wonder it would'nt work.

Brilliant Tool thanks for your help!!!
[Windows Mobile Apps and Games] ppcm:
In testing

I was looking for this type of application, I looks great!

I will test it this week-end during a trip.

I will post my feed back
[Windows Mobile Apps and Games] gthing:
Great app - it has come a long way since last time I used it.

Once feature request: How about the ability to "prefer" GPS over cell ID, but fall back to cell ID if GPS cannot get a fix (such as indoors)?
[Windows Mobile Apps and Games] _LEM_:
yes, I think I will be adding that feature soon.
[Windows Mobile Apps and Games] spencerlim:
hello , first time visit here...

i got a lots of confused about this software ,may i know that Is that this software similar to quick gps ?

and may i know that this software support mapking or garmin or not...

other than this , last important thing to say...

Thank you to staryon for posting this software...I think i will like it after i try,,,:D
[Windows Mobile Apps and Games] _LEM_:
Hii spencerlim,

Here is some information taken from TrackMe's manual:

GPS tracking tool

This tool retrieves GPS positions from a GPS device attached to a PDA.
That information is later used for displaying tracks with Google Earth
or Google Maps.

The program uses a server where your data is uploaded. If you don't
have an Internet connection or you prefer not to use it, you can store
your data locally on your PDA and upload it later when an Internet
connection is available or you use ActiveSync. You can use my server
(free of charge) for storing your data. TrackMe is already configured
to use this server by default.

Hope it helps.

Regards
[Windows Mobile Apps and Games] spencerlim:
Ooo....Thank you for your software...

really , i think figure out another way to use it...just set it open program when i bootup device and send me a msg when the sim card is changed...hope that the when i drop my pda and the ppl who take it will not hard reset and i will get where is the pda or the location via sms or internet...:D

other way is you're so pro ,because you can make this fantastic and useful thing!!!ThankYou...
[Windows Mobile Apps and Games] SrAgaporni:
Hi pals.

I have been testing this great app during last week, but I can't get it to work properly in continuous use. It seems to work fine till you try to upload a photo. After that, it seems to being unable to fix the GPS again, it just keeps showing a "not moved" message, even if you have moved more than 100 meters.

However, the photo is uploaded perfectly, but if you upload several photos at the same point, only one is showed in the TrackMe display.

As far as this, I think that is a great up and it could help me and a lot of people in our journeys.

Muchas gracias Luís :)

PD: I have a HTC p3600 with WM6.1, just in case.
[Windows Mobile Apps and Games] _LEM_:
Maybe it's a problem with static navigation on your GPS. Some GPS devices don't update your position if you move small distances. Not sure if that's the problem though.

On the other hand, a position can only be associated to one image.

If you want to have more than one, you will have to use the 'Force Update' feature.

Regards
[Windows Mobile Apps and Games] _LEM_:
thanks for your comments :)
[Windows Mobile Apps and Games] gdraanen:
Just installed a few days ago. All functions work nicely, and I was able to see my track on google-earth, and mobile maps. Send mail & sms also works.

Great work !!

However: (there is always room for improvements/ enhancement)

Please notice that the actual GPS position tracked is not shown (in text). Neither google-earth (when looking at track points or uploaded gps-pics), nor the mobile mapdata shows the actual position as a gps coordinate.

The SMS message I could send to a friend, holds a LINK to show a spot on a map !!

This would require my friend to be ONLINE, to lookup the actual position.

So, the receiver or web-guest can see me on a MAP, but would not be able to use that information to navigate towards me.

So...

Would it be possible at least to configure the sms message to state something like:

==

<greeting message (I can edit that in the sms text myself -as text template-)>

My <date><time> location:

<gps coordinates in N/S dd*mm.mmm E/W dd*mm.mmm>

Lookup PC: <.... the link as it is stated currently>

Lookup Mobile: <... the link as it is stated currently>

==

If I can get that text out to my friend, he can then input the coordinates in his offline navigator (such as TomTom).

It would be really cool, when the receiver could 'pick up' the coordinates as sent, to use it either as waypoint or as destination setting.

And, when showing the data on an uploaded picture, would it also be possible to show the exif-included position (coordinates) on the screen somewhere ?

Thx
[Windows Mobile Apps and Games] _LEM_:
Looks good. However at this moment I have no plans to add more new features for the SMS notification. I will add it to the to-do list though.

Regards
[Windows Mobile Apps and Games] draconic:
apparently because of my horrible selective reading ability, i was all excited, set up the personal server on my domain, installed trackme, and everything required - until i got an error, and read that it wasn't for smartphones, but standard/pro. :mad:

oh well. any plans for it?
[Windows Mobile Apps and Games] _LEM_:
At this moment, I would say no... but who knows, maybe I will do it in the future...

Sorry I cannot give you more information.
[Windows Mobile Apps and Games] curious george:
I have read through the FAQ and tried searching the thread. Is there a way with this program to send an SMS to a device and when that SMS is received the device do one of the following descretely:

1. descretely receive the sms and not alert the device based on the content of the sms.

based on content, (i.e. "utrackwhereru", "utracklive", "utrackoff" etc...)

2a. "utrackwhereru": if GPS is off turn it on for a snap shot of current location and turn off GPS and then forward the spot KML file.

2b. "utracklive": if GPS is off turn it on & turn on realtime descreet tracking.

2c. "utrackoff": turn gps off.

3. delete the sms received from history immediately.

Thanks,

Curious G
[Windows Mobile Apps and Games] _LEM_:
Hi Curious George,

No that's not possible. As I said sometime ago, I don't think TrackMe is really intended for that. I added the notification on demand feature, but I really think this should be part of a different tool.

I'm not sure if there are other tools that do that, if not I think I will end up writing one.

Regards
[Windows Mobile Apps and Games] bestlane:
This application rocks! Its been working flawlessly for me... any idea if you would be releasing the open source?
[Windows Mobile Apps and Games] _LEM_:
Thanks a lot for your comments!!

I'm sorry but at this moment I don't have plans to release the source code.
[Windows Mobile Apps and Games] joberry:
What else would you like to see in TrackMe? Ohhh late response

Sorry for the slow response.....Trackem works so well I have had little cause to come back for help :rolleyes:

Trackme is fantastic :cool:

But a couple of things that would make it perfect are....

1) Boundary checking on the Long/Lat. I have had Trackme/GPS plotting perfectly in the South of England (UK) and suddenly it decides i'm in the south of Spain or North Wales. ie 100 - 600 miles off course and avs of 300-600 mph. A sense check on the long/lat from the previous values might help??

2) It would be extremely cool if the web server followed the roads instead of joining the plots with a straight line ;-) (Something like www.bikely.com)

3)Fall back to Cell ID if GPS unavailable, Fall forward to GPS when Cell ID is unavailable/not decodable ;-) I know this has appeared in the forum elsewhere but it would be an ideal solution, I find that on rainy days that Sat lock is unreliable. Perhaps set a preference GPS over Cell ID or vica versa :D