yashsingh1/xdaforums huggingface dataset:
[Windows Mobile Apps and Games] _LEM_:
ok guys,

here is the new version. I'm sorry it took so long, but believe me... it was really tough sometimes. The worst part is to upload data to the server. Usually servers don't like these things for a external application, and I had to try a thousand of different techniques to get it to work.

I'm still haven't been able to fix that problem that I mentioned. If you select store GPS positions locally and generate kml files remotely, and some cases it will just hang there trying to upload the data. I don't know why. It only happened to me a few times and for that reason it's very difficult to trace it.

I'll keep working on that.

This new version has the following:

- Ability to store GPS positions locally and remotely.

- Ability to generate KML files locally and remotely.

- Export function has been rewritten to support new features.

- Added option for delete positions locally and remotely.

- You can export/delete positions for a given trip, for any trip, or for positions with no trip defined.

- Ability to delete trips

- If you use your own server, you can specify the extension of the files (PHP,ASP,...) and also the folder where the files are located.

- Simple and Advanced mode in Configuration.

For next version I prefer to wait in adding more features until this one is stable and I can fix that bug that happens sometimes. My next release will be the necessary PHP and mysql files and documentation for people who want to use their own server.

I hope you guys have fun with it!

ahh.... I added a link for Donations :o

If I get enough to invite my wife for a romantic dinner in the place of her choice I'll be completely satisfied!! just kidding... She almost divorced me for all those long nights that I kept working on this :D She cannot understand how much fun is to work on this project!!! Thanks a lot for your support guys.

Check my signature for downloading the program.
[Windows Mobile Apps and Games] jcleek:
ERROR!!

When you specify a file extension (like php) it puts that in the web address!

http://www.domain.com:80php/routes/Slacker.kml

The php should not be there, and because it is the remote KML creation does not work!
[Windows Mobile Apps and Games] cjmedina:
i cant get it to work on google earth i keep getting cant find http file . i followed the instruction from the read me file on the app but when i enter the url its says cant find http file. any ideas
[Windows Mobile Apps and Games] _LEM_:
ok guys, I think I fixed the problem.

Try with this new version I just uploaded.

By the way, I think I also fixed the problem uploading data. At least I left it running for 4 hours and worked fine.
[Windows Mobile Apps and Games] jcleek:
First time I ran it after installing this new version it immediately soft reset my device!

Still doesn't work. Now the export address shows:

http://www.domain.com:80/trackme.php/routes/Slacker.kml

Notice the folder "trackme" is now "trackme.php"
[Windows Mobile Apps and Games] _LEM_:
The program is exporting the files correctly. The only thing is that when you click on 'Show generated filenames' is not showing the right name.

Just point Google Earth to http://www.domain.com:80/trackme/routes/Slacker.kml

and the file should be there.

No idea about the soft reset. I haven't really modified anything that could do that. Let's see what feedback we get from other users.

Regards
[Windows Mobile Apps and Games] jcleek:
Two versions ago it was working perfectly. Last version and this one I get:

Error generating remote .kml file

Screen capture attached. Any idea why?
[Windows Mobile Apps and Games] daesimps:
Just tried this on my Artemis.

Told it to use COM4 (same as I do with TomTom and Co-Pilot). When I click start it just says opening COM4 and then locks my handset up. Have to reset to get it back.

Do you have any ideas as I would really like to get this app working - it is exactly what I was looking for.

Thanks in advance.

Dae
[Windows Mobile Apps and Games] odie3:
This looks pretty cool but I seem to be over looking the readme file. I assume I need a way to upload the file to my hosting site (does it use ftp)?
[Windows Mobile Apps and Games] _LEM_:
Can I see the tab where you have the settings for your remote server?
[Windows Mobile Apps and Games] _LEM_:
it uses HTTP post requests, so you don't need really need anything on your server (unless that you have disabled some settings)
[Windows Mobile Apps and Games] _LEM_:
I just uploaded a new version that fixes that problem when showing the generated filenames.
[Windows Mobile Apps and Games] odie3:
Okay, I can hit my link on your server "http://luisespinosa.com/trackme/routes/myusername.kml" and I get some information. Now what do I do with it? Import it some how to google earth web site?

Man, I feel like a noob.
[Windows Mobile Apps and Games] odie3:
Say, where is the Tab "Google Earth" that has the button that states "Click here for help to setup Google Earth". It shows it on your screen shots on your first page but on my install of your program... :(

Edit:

Okay, I gave up on Google web map site and moved on to the real Google Maps (Client Install). That works great and even figured out how to add a network link under my places (rather cool).

So, any step by step for Google Web Map site and the kml file? Thanks!
[Windows Mobile Apps and Games] jcleek:
I just installed the latest version. Now it says uploaded correctly but there is no file on my server in the routes folder.

But after I restarted it again it now shows the file error again.
[Windows Mobile Apps and Games] odie3:
Okay, this thing is freaking cool! I just sent you $20.00 via paypal from your donate button.

Question: Is there a way for your app to auto-create a trip each time you start it up? Perhaps Trip-MMDDYYYY as a name?
[Windows Mobile Apps and Games] _LEM_:
oh man... I didn't know you were using your own server. The php files have changed for this version. You know, that's why I didn't want to release the php files until I had stable version.

Here are the newest php files. However, keep in mind that they may change for a next release.

http://luisespinosa.com/temp/trackme.zip

You don't need the file googleearth.php anymore.
[Windows Mobile Apps and Games] _LEM_:
*THANKS A LOT* man.... I really appreciate it.

No, but it's a great idea. I will add it for the next version.

By the way, I think you are using an old version. You can get the latest from my signature.

Regards
[Windows Mobile Apps and Games] MPIIIMan:
staryon, you need to update those PHP files.

They do not work without modification on my server.

You are not declaring the variables being passed in via the URL.

$action = $_GET["action"];
$username = $_GET["username"];
$password = $_GET["password"];
$lat = $_GET["lat"];
$long = $_GET["long"];
$dateadded = $_GET["dateadded"];
$dateoccurred = $_GET["dateoccurred"];
$datefrom = $_GET["datefrom"];
$dateto = $_GET["dateto"];
$tripname = $_GET["tripname"];
[Windows Mobile Apps and Games] odie3:
Cool, thanks for taking my idea into account!

As for the version, I was on .16 but now I am on .17. BTW, how do I use the .kml file in Google Maps (the online version)?
[Windows Mobile Apps and Games] peter7:
Yes i did....I have St. Quentin`s Rom on my Kaiser - can that cause these problems ?

Or I first started track me and then I installed SQL Server Mobile - has this been wrong ??
[Windows Mobile Apps and Games] teren:
Help with stored trips

Hello Staryon! Just wanted to update you on the use of TrackMe! I had previously been using it to track my flights around the San Juan Islands, and am now traveling in Argentina. So far, more or less, the program has worked wonderfully! I am able to track my routes all around the country, and it's great for family & friends to see where I am at any given point. That is, assuming there is internet access! I sometimes go 4-6 days without net, so I just dump my track when I get a connection. Wonderful!

I have a question for you, maybe two!

First - when I am traveling like this, I have been using "remote" mode and just been offline till I hit a town with net, then upload positions. Would I be better off doing the "local" mode then updating when I find net? Is 'Local' mode the same as Remote-Offline? Can I store more that one photo for forced update on 'local' mode?

Here's the biggie. I was trying to troubleshoot a problem with a trip that stopped displaying anything at all. So I re-named it. Still does not work on my own server, but shows up ok in google maps and google earth. I have no idea why or what happened. I had stored a bunch of points on the renamed track. Then I restarted my phone, and it defaulted back to the old name (my bad - i forgot to change the name in the Trip Name) Is there ANY way to combine my trips back together so when I export to KML it will do both? I don't know much about SQL so don't really want to try at the DB level...

You can see what I am talking about on my server. http://www.photosfrombelow.com/trackme

The problematic track is 'Argentina_2008_YEAH' and the one I want to combine it with is 'Argentina_2008'

I sure appreciate your help! I'll be happy to make another donation if you can sort this out for me and answer my questions!!

Cheers from South America!

Chris Teren
[Windows Mobile Apps and Games] _LEM_:
I don't know... I cannot get it to work. I'll keep trying...
[Windows Mobile Apps and Games] _LEM_:
I'm sorry but I haven't tried that ROM. It's weird that you get an error message saying that SQL Mobile 3.5 is not present when you already installed it...

I hope somebody can give you some information. At this moment, I don't know what else you can try.
[Windows Mobile Apps and Games] _LEM_:
since I don't have access to your server, we will have to do this step by step.

Do you know how to execute SQL commands? If you do, run this one:

select * from trips

and let me know what value you get in the column ID for those 2 trips that you want to combine.
[Windows Mobile Apps and Games] teren:
well, i do know how to issue SQL commands, and in the column ID for those trips I get 27 and 28

Maybe though we should address why one trip will NOT display on my server, but will on google earth/maps. I don't want to go through this and have nothing work.

( i did figure out how to export, to google earth/maps, the date range of my trips to show on google earth the track)

FYI the track that works is 28, and the one that doesn't is 27
[Windows Mobile Apps and Games] _LEM_:
Which one is which?

In order to run a command, there's have to be a tab that says SQL, where you can enter SQL commands. Once I know the ID for each trip I could give you the command that you need to combine both.

It's hard to find out why is not showing on the map. I didn't write that part of the code so I don't know what you could try.
[Windows Mobile Apps and Games] teren:
I agree it is hard to sort this out. The track that works is 28, the one that does not display is 27. That's in the ID column. Do you want the 'name' column for these as well?

ID 27 is 'Argentina_2008_YEAH'

and ID 28 is 'Argentina_2008'

I can't give direct access to the DB. I could give you access through my website admin page, if that would help

by the way - the track that does not display was working fine, then after an upload offline positions, it stopped.
[Windows Mobile Apps and Games] _LEM_:
ok, try this:

update positions set FK_Trips_ID=28 where FK_Trips_ID=27

That will move all the data from trip Argentina_2008_YEAH to Argentina_2008
[Windows Mobile Apps and Games] mcross:
Date Ranges

I have been messing around with my page all day, maybe I am causing your troubles.

I believe I have fixed the issues with the dates, I also added code to set the Start and End dates to the first and last dates of the a Trip when 'Show Trip' is pressed. The Dates can then be changed and when 'Apply Points Filter' is pressed the data will be requeried.

For the Date range filter to work the drop down for the Points filter has to be set to 'Show for Date Range'.

I am attaching an updated index.php

Hope it works for you.:)
[Windows Mobile Apps and Games] teren:
well, that did appear to move all the date to the new trip, but it also destroyed the ability to view either track on my server...

any chance jcleek is around ?

I just basically lost my track on my server, from 2+ weeks of travel.

at least my KML is in tack for m google earth and googla maps, but that defeats the purpose of having my own server.

thanks for trying... I am sure there is one stupid corrupt update in the SQL that is causing this...

Chris
[Windows Mobile Apps and Games] _LEM_:
Nothing has been destroyed. The data is still in the database.

Can you try to export all the positions from trip Argentina_2008 to a KML file?

Once you get that, open that KML file. If you see all your data then I think there has to be a bug in the web viewer.
[Windows Mobile Apps and Games] teren:
You are correct, Staryon, and I should not have used the word destroyed. What I meant was, I can no longer view either track on the TrackMe Display on my server. All of my previous tracks show. The one that was not displaying anything, now shows the Google Base Map of the world, while the one we moved all the position data is not showing anything at all.

I'll try the KML file, and will also root around in the DB and see if I can find the culprit.

Do you have any suggestions which data fields I should look at in the DB? positions or trips? any idea which might cause the TrackMe Display to not show any data at all?

Thanks for you help!

CT
[Windows Mobile Apps and Games] teren:
it apears a bad net connection was the culprit for my phone meltdown. my apologies.

i am going to look at the kml file now and see if i can find a culprit...

chris
[Windows Mobile Apps and Games] _LEM_:
well... the program was updated to CF3.5 in December. Probably there were sql changes in the database since the last time that you updated your server and those changes were posted in the forum. People who are using their own server know that they need to check if there are database changes when new versions are released. Every time I made a change in the database I posted the necessary scripts in the forum for people using their servers.

To be honest, I don't understand why some people want to have their own servers if they don't have any experience with SQL. As soon as they have a small problem they are screwed up.

That doesn't happen if you use my free server. You only need to update TrackMe and you're done.

It could be a million things. Maybe you never created your server correctly from the first time and that's why you were having those problems.

I don't keep old versions or TrackMe.

What I would do in your case is to export all your data to a SQL file and make a fresh install of your database. Once you have everything running, import that data back using a SQL statement.

And please, don't blame TrackMe for the problems that you are having. If you install CF3.5 and SQL Mobile and your PDA stops working, that has nothing to do with TrackMe.
[Windows Mobile Apps and Games] _LEM_:
I see you edited your post...

too late man... think twice before blaming somebody.
[Windows Mobile Apps and Games] Quentin-:
Q-Mobile 1.2 SqlServerCe 3.5 FIX

This turned out to be a problem with Q-Mobile 1.2, I apologize for the inconvenience and appreciate your very detailed error report which enabled me to find the issue very quickly. Please see this post for the solution and CAB file. Cheers,
[Windows Mobile Apps and Games] _LEM_:
Thanks a lot for the information, Quentin. I will add it to the FAQ
[Windows Mobile Apps and Games] teren:
Staryon - if you look back, I have been using TrackMe from day one. I donated months ago. AND I was not blaming you! I was seeking advice from the software developer - read my original post I had a few questions for you on the differences on REMOTE vs. LOCAL mode, and how to combine two tracks. I am sorry if my posts indicated I was blaming your software. I was blaming the .NET framework, which I knew was not your problem. I was asking for an older version of TrackMe that didn't need the 3.5 .NET, as I thought it was incompatible with some of the software I use. Turns out, in Argentina, net connections, both WiFi and cell, die for no reason. I do appreciate your help, but I don't remember EVER blaming you or your program. I LOVE your program, and have said so EVERY post.

If you want to know what I edited in my post, it was a list of the programs that I thought were struggling with the new .NET framework., but turned out to be a bad cellular connection.

Further - I have updated ALL server files EVERY time there has been an update. And the same goes for TrackMe. I am not an idiot. I have been out of the country and on cell-data plans here that are too prohibitive cost-wise to update. So in one fell swoop, I updated TrackMe, and the NET framework and SQL - because today was the first time I saw them. FYI, even with the network issues resolved, the 3.5 .NET framework DOES cause problems with some of the programs I use. I am trying to update every piece of software in my phone, but it takes a while... I know this is not your fault, and I don't think I ever intoned that.

I am surprised, after trying to help me, that you would turn on me so quickly. I have been championing TrackMe for months, and I was not bullshitting you when I said I would donate again...

I do appreciate the help you gave me. And I would still be delighted if you could clarify for me how the LOCAL mode differs from the REMOTE mode, as I mentioned in my first post. And if I figure out why a bad dataset sent to the server causes the Display program to not display anything, I will share.

I am sure now I have invited a HUGE flame on myself... That's the nature of these forums. So be it.

Chris
[Windows Mobile Apps and Games] jcleek:
If your web server allows you to display the contents of a PHP file you have a much bigger problem than the map display not working. I can't help you with that.

Don't confuse Staryon's code withthe server display. The config is for the display only and has nothing to do with you being able to upload positions. Staryon is hosting all of the files but it is two completely seperate efforts, and the onlything they share is MySQL data.
[Windows Mobile Apps and Games] jcleek:
You have to pick a name (or log in for a private server) first. Then you can pick a trip or take the default (latest) trip. The filter is applied against whatever trip you select.
[Windows Mobile Apps and Games] jcleek:
I am here, but I do not understand what I can do for you. If the data is correct in the database the server page will display it. If there is a problem with it then it won't. If it displays some data but not other data you definitely have a database issue.
[Windows Mobile Apps and Games] jbarber:
I think it's the ROM you're using...I'm using the same ROM and am getting the same error message.
[Windows Mobile Apps and Games] teren:
Thanks for the reply. Here's a brief synopsis of my problem. I had a track going, for about 10 days of a trip. It was correctly displaying on my own server, and on Google Earth, and maps.google.com. For some reason, sometime in the last 3 or 4 days, it stopped displaying on my server's TrackMe Display page, but still correctly shows on Google Earth and maps.google.com. When I try to load the TM-D I get a big rectangle with nothing in it. I can view all other of my 27 tracks with no problem.

I guess that during an "upload offline positions" I had a network hiccup which caused some data to corrupt. I am simply trying to figure out how to tell where the problem is, that causes TrackMe Display to NOT show a track (or map or anything other than the empty frame) while Google earth/maps do correctly display.

http://www.photosfrombelow.com/trackme will show you the page. As a default, it loads the track which does not display (Argentina_2008) and the next one, Atgentina_2008_YEAH is currently showing a blank base-map, because I tried to combine two tracks into one, but the corruption followed the combining of the two tracks. Staryon was helping me try to combine two tracks because of a renaming problem I had. It worked, but didn't solve the display problem.

I am reading through the KML file to see if I can see what the problem is, but I don't know which data field would, with a corrupt entry, cause the Display to not show anything.

Unfortunately, all the troubleshooting, and updating to the newest TrackMe involved the SQL and .NET updates, and even more unfortunately coincided with a network outage, which made me think all the updates were causing problems with my phone. (The .NET update DOES cause some problems with some aviation programs I have, but I am working on updating them as well...)

At any rate, any feedback would be greatly appreciated. Thanks for all your hard work on this project, and for the support!

Chris
[Windows Mobile Apps and Games] teren:
ha - i guess that last post wasn't brief, was it...
[Windows Mobile Apps and Games] _LEM_:
see next post
[Windows Mobile Apps and Games] _LEM_:
Local mode stores everything on your PDA and it doesn't use internet connection. Remote stores all the data on a server except when data cannot be uploaded and it will be stored locally temporarily. Both modes are completely independent.
[Windows Mobile Apps and Games] teren:
thanks - i was hoping that was the case! I'll give it a try tomorrow!

CT
[Windows Mobile Apps and Games] peter7:
Staryon - the exact error message which I get is as follows: publickey token = 3....not found- and then I push finish and then the error with netfront s coming - does this help you ?

THANK you
[Windows Mobile Apps and Games] peter7:
It works - the solution was St. Quentin`s cab - see this thread
[Windows Mobile Apps and Games] _LEM_:
mcross, still doesn't work for me.

If I go to your website, leave the default trip as it is, select a date range and I click on Apply Points filter, it will still show positions with a date out of the date range.
[Windows Mobile Apps and Games] _LEM_:
jcleek,

I have a suggestion for you. When I click on "Apply points filter", do you get all the data again from the database? If so, I think you shouldn't have that button there.

For me it's confusing because when I select something I don't know if I should click on Show Trip or not.

I would do something like this:
[Windows Mobile Apps and Games] mcross:
You may have done this but, did you change the drop down above the 'Apply Points Filter' button to 'Show for Date Range' ?
[Windows Mobile Apps and Games] _LEM_:
sorry but I'm not sure if I understand... I always try to make everything simple. My idea was to have only 1 button for 'Show', instead of having an extra one for 'Apply points filter'. Just select the options that you want... for example, the trip name, if you want to see only pictures and a date range... and click on Show to see the data.
[Windows Mobile Apps and Games] jcleek:
The solution is simple. Took me about 30 seconds to find it. You have a point you forced an upload on that has this in the comments:

[quite]Lunch in... where the he'll are we? oh - las heras...[/quote]

Notice the single quote in the he'll? That needs to come out. Staryon isn't filtering for HTMLEntitles and so quotes will screw up the database display.
[Windows Mobile Apps and Games] jcleek:
Interesting idea. I will have to look into that.
[Windows Mobile Apps and Games] _LEM_:
there's no need for modifying existing data. There are different ways of escaping special characters.

Take a look at the function mysql_real_escape_string()

http://www.w3schools.com/php/func_mysql_real_escape_string.asp
[Windows Mobile Apps and Games] mcross:
Few Changes to Index

I made a few more changes to the index.php file, show/hide date fields based on what is selected in filter options, and show Trip summary when date fields are hidden. The calendar works in IE7 now too.

check it out here