PDA

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


Pages : 1 2 3 4 5 6 7 [8] 9 10 11 12 13 14 15

mouseymousey
24-01-2008, 06:31 PM
Hi Matt,

At this moment the KML file doesn't include that information, but it does the browser viewer. If you are using my free server, you can access this browser by going to http://www.luisespinosa.com/trackme

Regards

This app just gets better and better! I will have to donate...

One more question, using the browser viewer it seems to show my 2 trips over 2 days as one trip. Am I doing something wrong?

Thanks again for this.

staryon
24-01-2008, 06:33 PM
Thanks Matt.

Are you sure that you don't have both trips under the same trip name?

mouseymousey
24-01-2008, 07:28 PM
oops... didn't set the trip name. Thanks.

peter7
24-01-2008, 07:34 PM
Hi there is have the following net compact framework - 3.5 - but track me doen`t work - I`m using a Kaiser ?

So pls help me what is wrong ?

myrin

staryon
24-01-2008, 08:52 PM
Hi there is have the following net compact framework - 3.5 - but track me doen`t work - I`m using a Kaiser ?

So pls help me what is wrong ?

myrin

What error do you get?

peter7
24-01-2008, 10:02 PM
After I installed trackme it will not start or even breaks the system and I have to make a soft rest !

My Net Compact Framework version 3.5.7283

jameswalsh
24-01-2008, 10:09 PM
What device are you running? What version of Windows Mobile?

peter7
24-01-2008, 10:11 PM
Kaiser and Windows Mobile - where do I find the answer ? I have St. Quentins rom on it

peter7
24-01-2008, 10:12 PM
Sorry now I found it WM 6 professional

rsjj
24-01-2008, 11:55 PM
Hi
First of all Very many Thanks(VMT) fro such a nice application. It installed bug free. I am having a slight problem with Google earth. It reports an error that it it could not fetch the klm file. I can see my track on your webpage without any problem. It says

"Fetch of Network Link ......Failed..........................."
Http:File not found

I can see my track on webserver.

Any ideas some one can give.

Many Thanks

staryon
25-01-2008, 01:18 AM
Hi
First of all Very many Thanks(VMT) fro such a nice application. It installed bug free. I am having a slight problem with Google earth. It reports an error that it it could not fetch the klm file. I can see my track on your webpage without any problem. It says

"Fetch of Network Link ......Failed..........................."
Http:File not found

I can see my track on webserver.

Any ideas some one can give.

Many Thanks

Are you sure that you are generating the KML file?
If so what URL you are specifying in Google Earth?

Regards

GpsPasSion
25-01-2008, 02:24 AM
Finally found some time to install a recent version, very nice progress since the first version!

Since I just installd php on a backup win2003 server (using wamp and it works fine with phpbb) thought I would give the server app a go but I'm having problems :
1. install.php returns no errors and database structure created properly as well as config.php, except the google api key
2. delete install.php and database.sql
3. When I try to connect, I get a "Failed to connect to database. Display terminated." with I connect and no data can be uploaded from the PDA.

What's strange is that when I look at the source for the index.php in Firefox page I see the whole config.php file! Probably means index.php is not getting interpreted properly for some reason....

UPDATE - fixed, the config.php file generated by install.php started with <? instead of <?php that's weird as the config.php that comes in the package has it. Oh well ;-)

UPDATE2 - still can't upload a position (eror can't be displayed, optional messages, etc...) or get the icon list, will try to troubleshoot...Tried the register_globals = 1/ php.ini trick , but no go. upload.php from my browser returns a "Result:5" if that matters ?

Must the installation path for trackme show up in the config file ? I've noticed in step 8 "8) Fill in the blanks with the database information used above, name of the folder where you uploaded all of the php files..." but can't see where to specify that in the installer or in config.php?

ronfin44
25-01-2008, 03:27 AM
I've tried numerous GPS apps on my Tilt. The usual Telenav, Google Maps, and Windows Live, but TomTom is by far the best. Super simple to get running on my device. Pretty much drop a cab file on the memory card, then the folder containing the maps, and bam, it's awesome. Haven't tried Google Earth yet, but look forward to testing it out. :)

staryon
25-01-2008, 03:47 AM
GpsPasSion,

If you want to see the description of the error messages, check this post:
http://forum.xda-developers.com/showpost.php?p=1827153&postcount=1715

I cannot help you too much about the other problems, because I didn't write that part. I hope jcleek can see your message and help you with that.

Regards

jbarber
25-01-2008, 05:37 AM
Downloaded the software and when selected I get the following error message:
"File or assemble name
'System.Data.SqlServerCe,
Version=3.5.0.0, Culture=neutral,
PublicKey Token=3BE235D2AD3',
or one of its dependencies, was not found."

GpsPasSion
25-01-2008, 09:55 AM
@staryon - thanks, will install the error messages package and yes, let's hope jcleek can share his thoughts on this. I'm still confused about having to speficy the path or not in config.php and where.

installed : error message is error (404) not found, this would seem to confirm a problem with the path.

Is there a way to send a position via the browser /upload.php?xyz to zoom in on the problem ?

peter7
25-01-2008, 10:09 AM
Staryon - this is the error message:
"File or assemble name
'System.Data.SqlServerCe,
Version=3.5.0.0, Culture=neutral,
PublicKey Token=3BE235D2AD3',
or one of its dependencies, was not found."

WHat can I do ?

rsjj
25-01-2008, 02:23 PM
Are you sure that you are generating the KML file?
If so what URL you are specifying in Google Earth?

Regards
Hi
The url of the generated file which i also copied in Google earth was

http://luisespinosa.com:80/trackme/routes/rsjj.kml

I could see my track on Luisespinosa's web server but google earth said it could not find the file. I was connected using Wifi and the internet connection was working without any problems.

Any help is more than welcome.

MANY tHANKS

staryon
25-01-2008, 04:21 PM
Hi
The url of the generated file which i also copied in Google earth was

http://luisespinosa.com:80/trackme/routes/rsjj.kml

I could see my track on Luisespinosa's web server but google earth said it could not find the file. I was connected using Wifi and the internet connection was working without any problems.

Any help is more than welcome.

MANY tHANKS

rsjj, I put that URL in Google Earth and it worked fine. I could see your location.

staryon
25-01-2008, 04:21 PM
Staryon - this is the error message:
"File or assemble name
'System.Data.SqlServerCe,
Version=3.5.0.0, Culture=neutral,
PublicKey Token=3BE235D2AD3',
or one of its dependencies, was not found."

WHat can I do ?

Did you install Compact Framework 3.5 and SQL Mobile 3.5?

staryon
25-01-2008, 04:27 PM
@staryon - thanks, will install the error messages package and yes, let's hope jcleek can share his thoughts on this. I'm still confused about having to speficy the path or not in config.php and where.

installed : error message is error (404) not found, this would seem to confirm a problem with the path.

Is there a way to send a position via the browser /upload.php?xyz to zoom in on the problem ?

You could try with something like the folowing (I don't remember all the required parameters at this moment, so I'm not sure if I am missing any)

http://www.luisespinosa.com/trackme/requests.php?username=<user>&password=<pass>&action=upload&db=2&lat=3.5&long=3.2

mcross
25-01-2008, 06:09 PM
First off thank you Staryon for the app and Jcleek for the web, both working beautifully for me.

I made a few modification to the web for my purposes and thought I would post. It might be useful to some of your users. Its not real pretty but functional.

I added 2 points filters:
1)Shows the last 20 points stored in the database
2)Shows points between specified dates and times.

you can look at the changes here (http://www.mc-consult.com/trackme).

the 2 files I modified are index and languages

Again, Thanks and keep up the good work.

staryon
25-01-2008, 06:19 PM
First off thank you Staryon for the app and Jcleek for the web, both working beautifully for me.

I made a few modification to the web for my purposes and thought I would post. It might be useful to some of your users. Its not real pretty but functional.

I added 2 points filters:
1)Shows the last 20 points stored in the database
2)Shows points between specified dates and times.

you can look at the changes here (http://www.mc-consult.com/trackme).

the 2 files I modified are index and languages

Again, Thanks and keep up the good work.


mcross,

That's great! thanks a lot. I asked jcleek to add the ability to specify a date range a long time ago, but I think he never had time to do that, so I really appreciate that you could do that.

Do you think you can find a way of displaying a calendar or something similar to select the date range more easily?

If not, I will just update the current files with your changes.

Thanks

alphaaskins
25-01-2008, 07:20 PM
Hi,

I found the google earth only shows the latest position when those positions created few days ago in the same trip name cannot be displayed. But all the position can be display when using luisespinosa's server.

staryon
25-01-2008, 07:22 PM
Hi,

I found the google earth only shows the latest position when those positions created few days ago in the same trip name cannot be displayed. But all the position can be display when using luisespinosa's server.

What you see in GE is what you have EXPORTED. It can be realtime tracking or old trips. It depends how you have generated the KML file.

mcross
25-01-2008, 08:14 PM
Glad to see you liked the updates.
I found a javascript calendar on Sourceforge made by Mihai Bazon (http://www.bazon.net/mishoo/) so all credits goto him.

check it out here (http://www.mc-consult.com/trackme). Just click on date field and calendar should popup.

the attachment contains new folder lang, updated index.php, calendar-setup.js, calendar-win2k-cold-1.css, and calendar.js.

Just noticed that its working in Firefox, but not working for IE7

staryon
25-01-2008, 08:37 PM
mcross,

The calendar looks great. However, I think is not filtering the data correctly.
I tried your website and I selected 2008-01-24 15:00:00 to 2008-01-24 15:01:00 but still was showing all the data.
Also when you click on Show Trip, the values that you had disappear and you need to enter them again.

Thanks for your help!

peter7
25-01-2008, 08:54 PM
Staryon - I still have the problem with the error message and to answer your question I have installed Microsoft Compact Framework 3.5 Download and SQL Server Mobile 3.5.

Any other idea how to solve the problem

THANKS so much

staryon
25-01-2008, 09:09 PM
Staryon - I still have the problem with the error message and to answer your question I have installed Microsoft Compact Framework 3.5 Download and SQL Server Mobile 3.5.

Any other idea how to solve the problem

THANKS so much

sorry man... but I don't really know why you are getting that error.
Did you make a soft reset after installing SQL?

mcross
25-01-2008, 09:21 PM
mcross,

The calendar looks great. However, I think is not filtering the data correctly.
I tried your website and I selected 2008-01-24 15:00:00 to 2008-01-24 15:01:00 but still was showing all the data.
Also when you click on Show Trip, the values that you had disappear and you need to enter them again.

Thanks for your help!

Right now it seems you have to pick the Trip First (I am selecting ANY) then press the show trip button, after the trip is brought up then all the Filters can be applied. If another trip is selected then the filters are cleared.

I believe this is the way jcleek intended this to work. I could be wrong though.

peter7
25-01-2008, 09:30 PM
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 ??

teren
25-01-2008, 10:34 PM
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

staryon
25-01-2008, 10:39 PM
Right now it seems you have to pick the Trip First (I am selecting ANY) then press the show trip button, after the trip is brought up then all the Filters can be applied. If another trip is selected then the filters are cleared.

I believe this is the way jcleek intended this to work. I could be wrong though.

I don't know... I cannot get it to work. I'll keep trying...

staryon
25-01-2008, 10:41 PM
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 ??

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.

staryon
25-01-2008, 10:47 PM
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

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.

teren
25-01-2008, 11:04 PM
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.

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

staryon
25-01-2008, 11:10 PM
well, i do know how to issue SQL commands, and in the column ID for those trips I get 27 and 28

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.

teren
25-01-2008, 11:19 PM
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.

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.

staryon
25-01-2008, 11:32 PM
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

mcross
25-01-2008, 11:35 PM
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.:)

teren
25-01-2008, 11:42 PM
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

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

staryon
25-01-2008, 11:47 PM
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

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.

teren
26-01-2008, 12:11 AM
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.

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

teren
26-01-2008, 12:29 AM
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!

CTit 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

staryon
26-01-2008, 01:00 AM
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.

staryon
26-01-2008, 01:01 AM
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

I see you edited your post...

too late man... think twice before blaming somebody.

Quentin-
26-01-2008, 02:22 AM
I am using the Q-mobile 1.2 rom which includes NET CF 3.5, and I install the Sql 3.5 file from the first post before I install TrackMe.

When I run TrackMe the waitcursor is on the screen for approx 30 seconds until a message appears:

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

What's the problem? I love TrackMe but can't use the new versions???

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 (http://forum.xda-developers.com/showpost.php?p=1852972) for the solution and CAB file. Cheers,

staryon
26-01-2008, 03:25 AM
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 (http://forum.xda-developers.com/showpost.php?p=1852972) for the solution and CAB file. Cheers,

Thanks a lot for the information, Quentin. I will add it to the FAQ

teren
26-01-2008, 03:53 AM
I see you edited your post...

too late man... think twice before blaming somebody.

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

jcleek
26-01-2008, 04:00 AM
What's strange is that when I look at the source for the index.php in Firefox page I see the whole config.php file! Probably means index.php is not getting interpreted properly for some reason....

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.

Must the installation path for trackme show up in the config file ? I've noticed in step 8 "8) Fill in the blanks with the database information used above, name of the folder where you uploaded all of the php files..." but can't see where to specify that in the installer or in config.php?

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.

jcleek
26-01-2008, 04:05 AM
Right now it seems you have to pick the Trip First (I am selecting ANY) then press the show trip button, after the trip is brought up then all the Filters can be applied. If another trip is selected then the filters are cleared.

I believe this is the way jcleek intended this to work. I could be wrong though.

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.

jcleek
26-01-2008, 04:12 AM
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


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.

jbarber
26-01-2008, 04:30 AM
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 ??

I think it's the ROM you're using...I'm using the same ROM and am getting the same error message.

teren
26-01-2008, 04:36 AM
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.

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

teren
26-01-2008, 04:37 AM
ha - i guess that last post wasn't brief, was it...

staryon
26-01-2008, 05:31 AM
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.


see next post

staryon
26-01-2008, 05:33 AM
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.


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.

teren
26-01-2008, 06:30 AM
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.

thanks - i was hoping that was the case! I'll give it a try tomorrow!

CT

peter7
26-01-2008, 07:50 AM
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

peter7
26-01-2008, 09:11 AM
It works - the solution was St. Quentin`s cab - see this thread

staryon
26-01-2008, 07:50 PM
Right now it seems you have to pick the Trip First (I am selecting ANY) then press the show trip button, after the trip is brought up then all the Filters can be applied. If another trip is selected then the filters are cleared.

I believe this is the way jcleek intended this to work. I could be wrong though.

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.

staryon
26-01-2008, 08:03 PM
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:

http://www.luisespinosa.com/temp/viewer.jpg

mcross
26-01-2008, 11:33 PM
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.

You may have done this but, did you change the drop down above the 'Apply Points Filter' button to 'Show for Date Range' ?

staryon
27-01-2008, 04:17 AM
You may have done this but, did you change the drop down above the 'Apply Points Filter' button to 'Show for Date Range' ?

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.

jcleek
27-01-2008, 05:05 AM
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


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.

jcleek
27-01-2008, 05:05 AM
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:

http://www.luisespinosa.com/temp/viewer.jpg

Interesting idea. I will have to look into that.

staryon
27-01-2008, 05:21 AM
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:

Lunch in... where the he'll are we? oh - las heras...

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.

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

mcross
27-01-2008, 09:03 PM
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 (http://www.mc-consult.com/trackme)

bengel12
28-01-2008, 12:36 AM
When I try to start the trackme client on my HTC Tilt I get an error stating...

MissingMethodException

at
System.Windows.Forms.Control.set_Parent()
at ControlCollection.Add()
at
TrackMe.FormMain.InitializeComponent()
at
.... (more)

I tried installing/reinstalling the compact 3.5 framework with no luck. I am using the 2 (.net & sqlserver) packages located in the 1st message of the thread.

Any ideas?

Thanks...

jcleek
28-01-2008, 12:36 AM
Looks like mcross is taking over the dev of the server page. Looks good. But need to increment the version number so we can make sure we have the most current.

staryon
28-01-2008, 12:54 AM
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 (http://www.mc-consult.com/trackme)

mcross,

Thanks. Date ranges work fine now. However, with that change that you made I cannot, for example, show only photos for a given date range.

Any chance of changing the interface to the one that I suggested? I think we would get more flexibility and we will get rid of a redundant button.

mcross
28-01-2008, 02:48 AM
Looks like mcross is taking over the dev of the server page. Looks good. But need to increment the version number so we can make sure we have the most current.

jcleek,

I am not wanting to take over the development. There is no way I could have written what you have already done, and I am not even sure if I am sticking my code in the most apporpiate places. I needed a certain function so I wrote and then submitted back so other users could use if they chose too, thats the beauty of open source.

My hope is that if what I have written proves to be useful, you will add to your souce after verifying my contrubutions. I am more than willing to help with whatever tasks you assign. I will try to accomplish what staryon has suggested, if you would like.

I am having lots of fun with this app, and it will help me with my billing, I am a computer consultant and travel around town regularly, if I do not write down what I do, I can use trackme to see where I was/and how long to jogg my memory.

Kai-Uwe
28-01-2008, 04:22 PM
Hello,

yust find it in the Net and think: Whow thats it try it out!

so i do :-)

i startet up with setting up my database on the sql-server (5.0)

Then ftp-ing all the files to my Webspace in an own diretory with 777 permissions and start the install.php. Filling out anything it wants.

But i get an error that says nothing to me:

Fatal error: Call to undefined function: file_get_contents() in /mnt/web5/23/48/5100148/htdocs/jaap/trackme/install.php on line 75

So, what to do?

Greetings Kai-Uwe

pinballwizard
28-01-2008, 09:17 PM
Has anyone tried to set up his own site for TrackMe on a Synology NAS? This NAS has a build in webserver, SQL server and supports php.

See www.synology.com .

mcross
28-01-2008, 09:32 PM
Hey Jcleek and staryon,

I have made the changes staryon asked for, take a look and see if it works (http://www.mc-consult.com/trackme), I still need to make the summary change languages/units but I believe everything is working.

if it tests out I will upload the files.

One thing for you to know, when the Trip is changed, It will lookup the entire trip, pulling the begin and end dates, and summary data. after that the dates can be changed.

I also change the 'Show last location' to 'Live Tracking' in my language file.

Kai-Uwe
28-01-2008, 10:36 PM
Hi, at this time i have problems with the installation of trakme on my own Server (OK, not my own. Its my Hoster ;-) (2-3 Posts before) but i can test and play around with Staryon's server :-)
Thanks for it!

My question: Where can i find the Webinterface from jcleek?

I want to build an "Testwebpage" to look whats going on and how it works :-)

Greetings from Germany Kai-Uwe

mcross
28-01-2008, 10:48 PM
Hi, at this time i have problems with the installation of trakme on my own Server (OK, not my own. Its my Hoster ;-) (2-3 Posts before) but i can test and play around with Staryon's server :-)
Thanks for it!

My question: Where can i find the Webinterface from jcleek?

I want to build an "Testwebpage" to look whats going on and how it works :-)

Greetings from Germany Kai-Uwe

Hello Kai-Uwe,

I am new to trackme too, but I'll try to help.

It sounds like you already have downloaded the server files according to your previous post, but just in case you can find them here (http://www.luisespinosa.com/bin/trackme/server/list.php).

if the install.php does not work, I would just edit your config.php directly and then upload to your web server. In the config just edit the Database Information, add your google api key.

Kai-Uwe
28-01-2008, 11:19 PM
@mcross

php is not my world...But tried it out to fix my probs. Fine, looks simple to find the places where to edit the config php.

So i put in my Database-Name, Database-Username, Database-Password, and my API-Key. Than ftp it up to my server. Let it all in " " OK?

Runing Trackme..and getting errors:
-------------------------------------
User didnt exist and system was unable to create it
Check you are entering a username and password in the account information
---------------------------------------

Ok go to the config screen an look what i have done:
i tried out in "Account":
My dates from stayron Server 8OK, could not work :-))

Username & Password from my Database ---did not work
Username & Password from my webspace --- did not work

In Server: I put the root adress of my server without www... so only jaap.de

The rest stays original.....

hope you understand my bad english.

Greetings Kai-Uwe

staryon
29-01-2008, 05:48 AM
Hey Jcleek and staryon,

I have made the changes staryon asked for, take a look and see if it works (http://www.mc-consult.com/trackme), I still need to make the summary change languages/units but I believe everything is working.

if it tests out I will upload the files.

One thing for you to know, when the Trip is changed, It will lookup the entire trip, pulling the begin and end dates, and summary data. after that the dates can be changed.

I also change the 'Show last location' to 'Live Tracking' in my language file.

Awesome!! Thank you very much!
I tested it and it works fine. The only problem that I've seen is when you click on 'Live Tracking' that returns an error.

Once you fix that problem I will update the files.

Regards

jcleek
29-01-2008, 12:29 PM
@mcross

php is not my world...But tried it out to fix my probs. Fine, looks simple to find the places where to edit the config php.

So i put in my Database-Name, Database-Username, Database-Password, and my API-Key. Than ftp it up to my server. Let it all in " " OK?

Runing Trackme..and getting errors:
-------------------------------------
User didnt exist and system was unable to create it
Check you are entering a username and password in the account information
---------------------------------------

Ok go to the config screen an look what i have done:
i tried out in "Account":
My dates from stayron Server 8OK, could not work :-))

Username & Password from my Database ---did not work
Username & Password from my webspace --- did not work

In Server: I put the root adress of my server without www... so only jaap.de

The rest stays original.....

hope you understand my bad english.

Greetings Kai-Uwe

It sounds to me like a MySQL issue with a MySQL account. Your root hosting account may or may not have access to your MySQL installation. Usually you create an account to give applications access to the data. You need to make sure the account information you are putting in the config.php file really exist and have access to the database.

jcleek
29-01-2008, 12:35 PM
jcleek,

I am not wanting to take over the development. There is no way I could have written what you have already done, and I am not even sure if I am sticking my code in the most apporpiate places. I needed a certain function so I wrote and then submitted back so other users could use if they chose too, thats the beauty of open source.

My hope is that if what I have written proves to be useful, you will add to your souce after verifying my contrubutions. I am more than willing to help with whatever tasks you assign. I will try to accomplish what staryon has suggested, if you would like.

I am having lots of fun with this app, and it will help me with my billing, I am a computer consultant and travel around town regularly, if I do not write down what I do, I can use trackme to see where I was/and how long to jogg my memory.

Well much of what I wrote isn't mine. There have been many contributions to the effort, I was just managing the files. Since you are the one making the bulk of the changes now you should manage the files until someone else has something significant to add. Its all you baby!

Kai-Uwe
29-01-2008, 12:56 PM
It sounds to me like a MySQL issue with a MySQL account. Your root hosting account may or may not have access to your MySQL installation. Usually you create an account to give applications access to the data. You need to make sure the account information you are putting in the config.php file really exist and have access to the database.

The Database exists. I have checked this. Other tools works with my (other)databases ( for example Sitebar).

Maybe i do something wrong with the configuration in Trackme?

So on the Config Page at "Remote", what do i have to put in?
Account: My Username/Password for my own WEB-FTP? Cause Tackme wants to load up files/data? Ore something different?

In "Server": My Webroot: jaap.de? Root folder, where Trackme stays (/trackme)?

The Account Dates of the Database are stored in the config.php.

I tried out to go to: www.jaap.de/trackme/index.php and got the following Messages: (At this time i thing the reason is about the missing data in the Tables)
-----------------------------------------------------------------
Warning: Supplied argument is not a valid MySQL result resource in /mnt/web5/23/48/5100148/htdocs/jaap/trackme/index.php on line 53

Warning: Supplied argument is not a valid MySQL result resource in /mnt/web5/23/48/5100148/htdocs/jaap/trackme/index.php on line 55

Warning: Supplied argument is not a valid MySQL result resource in /mnt/web5/23/48/5100148/htdocs/jaap/trackme/index.php on line 57

Warning: Supplied argument is not a valid MySQL result resource in /mnt/web5/23/48/5100148/htdocs/jaap/trackme/index.php on line 59

TrackMe Display (v1.15)
One or more TrackMe tables in your database are empty. You must generate data by running the TrackMe application on your Windows Mobile device before the map display will work properly.

Tracking information provided by TrackMe
-----------------------------------------------------------

Hope somebody can help me.

Greetings Kai-Uwe

GpsPasSion
29-01-2008, 02:11 PM
I have pretty much the same problem, installation went fine (after I added a <?php at the beginning of the config.php file is the install.php was not creating it), but I can't upload data from my device, I suspect it is a path problem as I get a "404" error, but can't figure out if/how the path needs to be set in config.asp ?

What confuses me is the readme instructions, paragraph 8 "name of the folder where you uploaded all of the php files". Can't see where to put that info in config.asp ?

mcross
29-01-2008, 03:39 PM
The Database exists. I have checked this. Other tools works with my (other)databases ( for example Sitebar).

Maybe i do something wrong with the configuration in Trackme?

So on the Config Page at "Remote", what do i have to put in?
Account: My Username/Password for my own WEB-FTP? Cause Tackme wants to load up files/data? Ore something different?

In "Server": My Webroot: jaap.de? Root folder, where Trackme stays (/trackme)?

The Account Dates of the Database are stored in the config.php.

I tried out to go to: www.jaap.de/trackme/index.php and got the following Messages: (At this time i thing the reason is about the missing data in the Tables)
-----------------------------------------------------------------
Warning: Supplied argument is not a valid MySQL result resource in /mnt/web5/23/48/5100148/htdocs/jaap/trackme/index.php on line 53

Warning: Supplied argument is not a valid MySQL result resource in /mnt/web5/23/48/5100148/htdocs/jaap/trackme/index.php on line 55

Warning: Supplied argument is not a valid MySQL result resource in /mnt/web5/23/48/5100148/htdocs/jaap/trackme/index.php on line 57

Warning: Supplied argument is not a valid MySQL result resource in /mnt/web5/23/48/5100148/htdocs/jaap/trackme/index.php on line 59

TrackMe Display (v1.15)
One or more TrackMe tables in your database are empty. You must generate data by running the TrackMe application on your Windows Mobile device before the map display will work properly.

Tracking information provided by TrackMe
-----------------------------------------------------------

Hope somebody can help me.

Greetings Kai-Uwe

Kai-Uwe,
I have tried to reproduce your error but can't, I agree with jcleek that it must be a database issue, username/password. The MySQL errors you get from the webpage are because you have no users in your users table. The reason you have no users is because Trackme app cannot create a user.

I set my trackme (which works fine with other remotes) to point to your site and get the same errors you report, so I don't believe its a problem with the trackme program.

I wonder what will happen if you add your username and password manually to the database.

GpsPasSion
29-01-2008, 03:44 PM
But if it was a username/password issue the tables wouldn't have been created by the install.php though ? I had that problem at first with a user that had limited access.

Did you specify a path in the config.php as per step 8 of the instructions ? I think our problem could be in the path somewhere.

mcross
29-01-2008, 03:58 PM
But if it was a username/password issue the tables wouldn't have been created by the install.php though ? I had that problem at first with a user that had limited access.

Did you specify a path in the config.php as per step 8 of the instructions ? I think our problem could be in the path somewhere.

I don't see a place to put a path in the config.php.

Kai-Uwe
29-01-2008, 03:59 PM
Kai-Uwe,
I have tried to reproduce your error but can't, I agree with jcleek that it must be a database issue, username/password. The MySQL errors you get from the webpage are because you have no users in your users table. The reason you have no users is because Trackme app cannot create a user.

I set my trackme (which works fine with other remotes) to point to your site and get the same errors you report, so I don't believe its a problem with the trackme program.

I wonder what will happen if you add your username and password manually to the database.

Hi how do i add a username and password manually in the database?

i can create a database withe the Frontend of my provider. Than i can set a passwort. Then i got the Databasename and the Username createt by the frontend of my provider.

Via the frontend i can look in the database. at this time there is nothing in it. Also no tables.

And please what do i have to put in the configuraton of Trackme? i don't want to make mistakes there and also dont want to try oud any combination every time :-) So what username/password combination? Database User7Password? WEB-Accsess/FTP Username/Password ord what?

I editet the config.php manually (DB-User/DB-Password/DB-Name/API-Key). No result. I tried out again to use the install.php. It shows me than the values i have editit in the config.php. When i want to continue installation i get the error:

Fatal error: Call to undefined function: file_get_contents() in /mnt/web5/23/48/5100148/htdocs/jaap/trackme/install.php on line 75

Could it be that the problem is that the installation go wrong and i got no tables in my database?

Greetings Kai-Uwe

GpsPasSion
29-01-2008, 04:03 PM
Ah, if you don't have any tables then the install did not go correctly, likely a username/password/rights problem indeed.

@mcross - thanks, must be from an older version then. Will keep on looking to fix my 404 problem !

mcross
29-01-2008, 04:04 PM
Hi how do i add a username and password manually in the database?

i can create a database withe the Frontend of my provider. Than i can set a passwort. Then i got the Databasename and the Username createt by the frontend of my provider.

Via the frontend i can look in the database. at this time there is nothing in it. Also no tables.

And please what do i have to put in the configuraton of Trackme? i don't want to make mistakes there and also dont want to try oud any combination every time :-) So what username/password combination? Database User7Password? WEB-Accsess/FTP Username/Password ord what?

I editet the config.php manually (DB-User/DB-Password/DB-Name/API-Key). No result. I tried out again to use the install.php. It shows me than the values i have editit in the config.php. When i want to continue installation i get the error:

Fatal error: Call to undefined function: file_get_contents() in /mnt/web5/23/48/5100148/htdocs/jaap/trackme/install.php on line 75

Could it be that the problem is that the installation go wrong and i got no tables in my database?

Greetings Kai-Uwe

using the frontend to your database, import the database.sql file. this will create your tables.

Kai-Uwe
29-01-2008, 04:15 PM
using the frontend to your database, import the database.sql file. this will create your tables.

Didt not work.. got the Message:
--------------------------------------
SQL-Befehl:

--
-- Table structure for table `icons`
--
CREATE TABLE `icons` (

`ID` int( 11 ) NOT NULL AUTO_INCREMENT ,
`Name` varchar( 255 ) NOT NULL ,
`URL` varchar( 512 ) NOT NULL ,
PRIMARY KEY ( `ID` )
) ENGINE= MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =1
-------------------------------------------------
with error:

MySQL meldet:

#1074 - Too big column length for column 'URL' (max = 255). Use BLOB instead

I start to cry.... :eek:

mcross
29-01-2008, 04:22 PM
Didt not work.. got the Message:
--------------------------------------
SQL-Befehl:

--
-- Table structure for table `icons`
--
CREATE TABLE `icons` (

`ID` int( 11 ) NOT NULL AUTO_INCREMENT ,
`Name` varchar( 255 ) NOT NULL ,
`URL` varchar( 512 ) NOT NULL ,
PRIMARY KEY ( `ID` )
) ENGINE= MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =1
-------------------------------------------------
with error:

MySQL meldet:

#1074 - Too big column length for column 'URL' (max = 255). Use BLOB instead

I start to cry.... :eek:

I don't know why you are getting that error, but I guess you can edit the database.sql and change `URL` varchar( 512 ) NOT NULL , to `URL` varchar( 255 ) NOT NULL ,

and then try the import again

Kai-Uwe
29-01-2008, 04:45 PM
Yeah!!!!!!!!!!!!!

One Step forward!!!!

Have to search a little bit but then found it. How to import the sql-file.

Now i have the tables icons, positions, trips and users in my database :o

AND: I COULD SEE MY TRIP IN GOOGLE EARTH!!!!!

!!!WITH MY OWN SERVER!!!

Birthday and thanksgiving in one day today :D

That more than half oft it!! wonderfull!

So the last problem is: When i go to http://www.jaap.de/trackme/index.php

i got only this:

-----------------------------------------------------------------
TrackMe Display (v1.15)
One or more TrackMe tables in your database are empty. You must generate data by running the TrackMe application on your Windows Mobile device before the map display will work properly.
-------------------------------------------------------------------

Hope we can solve this one also :))

Greetings Kai-Uwe

PS: i have stoped crying...Smiling now :-))

mcross
29-01-2008, 04:54 PM
Kai-Uwe,

glad you are not crying now, one of your tables does not contain data, using your front end look at the contents of each table to see which one is blank. I would assume its the icons table.

Kai-Uwe
29-01-2008, 04:58 PM
...im Blind!!!! Forget to delete the install and sql file.

And: Yes the trip table was emty. Just walk in front of the door with the system. Wait 30 seconds...and there will be a trip :-)

Now anything runs fine!!!!!!

Thanks a lot!

But now we know that the automatic installation did not run fine anytime.

Ah mybe you want to kno how i fixed the Database error when trying to import the sql file...

just delete the database (It was SQL Version 4....) and make a new one with Version 5...

So if anybody got the same prob:

Just create a database with SQL-Version 5... and import the sql-file manually. Dont forget to edit the config.php by yourself. Than it works!

The Account information in Tracke me is whatever you want. It creates the account by himself. so for the user it just has effect for the name of the kml-file.

MANY greetings Kai-Uwe

Kai-Uwe
29-01-2008, 05:21 PM
Now I have set in the config.php:
--------------------------------------------
// Public Page Access (yes or no)
$public_page = "No";
-------------------------------------------

when going to http://www.jaap.de/trackme/index.php i need an username and passwort. Thougt it was one of my combination. but thy did not work.

What do i need?

At this time i have switched back to public=yes

Greetings Kai-Uwe

mcross
29-01-2008, 05:39 PM
Now I have set in the config.php:
--------------------------------------------
// Public Page Access (yes or no)
$public_page = "No";
-------------------------------------------

when going to http://www.jaap.de/trackme/index.php i need an username and passwort. Thougt it was one of my combination. but thy did not work.

What do i need?

At this time i have switched back to public=yes

Greetings Kai-Uwe

use the username/password combination you used in trackme remote tab.

verona
29-01-2008, 06:09 PM
Absolutely great software. It works fine on my TYTN II (Vodafone edition with HTC ROM).
The only thing I wonder a bit after installation: If the VPA is unused he goes off. The only way to repower him is the reset button. The power on button is not working anymore. Any hint / solution ?

Regards

Armageddon67
29-01-2008, 07:14 PM
Is it possible, when GPS signal returns (like after a tunnel, for example) to make a fixing of the position automatically? Can be reduced dynamically, update time (10 seconds) in function of the speed? 10 seconds, at 160km/h, covering a curved road or railway, are many IMHO.
Tanks and excuse my ugly english

mcross
29-01-2008, 09:10 PM
staryon,

I fixed the errors on the live tracking button and made changes so the trip summary will change to current status when Live tracking is selected, also added a countdown to data refresh.

added trackme icon too.

I am attaching all files but the ones that are updated/new are: index, language, config (I incremented the version by one), favicon.ico, and the calendar files(this includes the lang folder)

if you want to look at changes, go here (http://www.mc-consult.com/trackme)

staryon
29-01-2008, 09:49 PM
Is it possible, when GPS signal returns (like after a tunnel, for example) to make a fixing of the position automatically? Can be reduced dynamically, update time (10 seconds) in function of the speed? 10 seconds, at 160km/h, covering a curved road or railway, are many IMHO.
Tanks and excuse my ugly english

Sorry but I don't have plans in adding that feature. Regards

staryon
29-01-2008, 09:50 PM
staryon,

I fixed the errors on the live tracking button and made changes so the trip summary will change to current status when Live tracking is selected, also added a countdown to data refresh.

added trackme icon too.

I am attaching all files but the ones that are updated/new are: index, language, config (I incremented the version by one), favicon.ico, and the calendar files(this includes the lang folder)

if you want to look at changes, go here (http://www.mc-consult.com/trackme)

It looks great. Thanks mcross. Where do you have those files, so I can upload them to my server?

mcross
29-01-2008, 10:43 PM
It looks great. Thanks mcross. Where do you have those files, so I can upload them to my server?

sorry forgot to attach the files

staryon
29-01-2008, 11:02 PM
sorry forgot to attach the files

Thanks.

By the way, I changed the location of the files. Now you can download them as a single zip file. I decided to do that because there are already too many files.

You can download it from here:
http://luisespinosa.com/bin/trackme/server.zip

mcross,
A couple of suggestions...

1. When you select a trip, as soon as is selected it will show that trip, instead of waiting for the Show button to be pressed. Do you think you can disable that?
In some cases you may a have a trip with many positions and you just want to select a date range for that trip, however as soon as the trip is selected it will query the database and you have to wait.

2. Do you think you can remove the label that says 'TrackMe Display (v1.15)' at the top? It just takes space in your screen and without that label users can make the map bigger.

thanks a lot! The latest changes look great!

staryon
29-01-2008, 11:12 PM
New version available!

Now you can upload offline pictures. TrackMe will extract creation date information from the pictures and it will try to match it with the existing GPS positions. If the time difference is less than X for a certain position it will upload that picture to the server and it will assign it to that position.

I plan to get GPS data from the image as well in a future version...


mcross,
I have modified the file requests.php
I have updated the server files with this one.

mcross
30-01-2008, 12:05 AM
Thanks.

By the way, I changed the location of the files. Now you can download them as a single zip file. I decided to do that because there are already too many files.

You can download it from here:
http://luisespinosa.com/bin/trackme/server.zip

mcross,
A couple of suggestions...

1. When you select a trip, as soon as is selected it will show that trip, instead of waiting for the Show button to be pressed. Do you think you can disable that?
In some cases you may a have a trip with many positions and you just want to select a date range for that trip, however as soon as the trip is selected it will query the database and you have to wait.

2. Do you think you can remove the label that says 'TrackMe Display (v1.15)' at the top? It just takes space in your screen and without that label users can make the map bigger.

thanks a lot! The latest changes look great!

Attached are updated files to give users the option of having the header or not. changed index, config and language.


The reason I decided to look up the entire trip first was, to show the user the start and end date of the entire trip, otherwise you would not know for sure the exact start and end of each trip. maybe if the dates are left blank it will look entire trip otherwise use range.

staryon
30-01-2008, 12:21 AM
Attached are updated files to give users the option of having the header or not. changed index, config and language.


The reason I decided to look up the entire trip first was, to show the user the start and end date of the entire trip, otherwise you would not know for sure the exact start and end of each trip. maybe if the dates are left blank it will look entire trip otherwise use range.

ok, I understand.
I also have the problem that when I first log in, it takes forever, because it will load the first trip that I have available (which is a long trip), but I am not really interested in showing that trip. That's why I thought that the viewer shouldn't show anything until the user decides what he/she wants to see.

But I understand your point.

Armageddon67
30-01-2008, 11:28 AM
Sorry but I don't have plans in adding that feature. Regards

Thank you anyway :)

staryon
30-01-2008, 04:15 PM
mcross,

Would it be possible to show the trip summary and the date range but without showing the data? I mean, when you select a trip, run some queries to get that information and nothing else.

At least in my case at this moment I cannot use the viewer.It just takes too long every time that I log in.

annegerben
30-01-2008, 06:56 PM
Could you add "dutch" to the language file?

Here is the translation:

elseif($language == "dutch")
{
$title_text = "TrackMe Display";
$trip_button_text = "Toon reis";
$location_button_text = "Volg live";
$filter_button_text = "Punten filter toepassen";
$filter_none_text = "Toon alle punten";
$filter_photo_comment_text = "Toon foto en commentaar punten";
$filter_photo_text = "Toon foto punten";
$filter_comment_text = "Toon commentaar punten";
$filter_last_20 = "Toon laatste 20 punten";
$filter_daterange = "Toon datum bereik";
$footer_text = "Tracking informatie verzorgd door ";
$incomplete_install_text = "Installatie niet volledig uitgevoerd! De files install.php en database.sql bestaan in de TrackMe map. Delete install.php en database.sql uit de TrackMe map om gebruikt te maken van Trackme.";
$no_data_text = "Een of meer TrackMe tabbellen in de database zijn leeg. Je moet eerst gegevens genereren met de TrackMe applicatie op je Windows Mobile apparaat voordat de kaart weergegeven kan worden.";
$database_fail_text = "Verbinding maken met database mislukt. Weergeven afgebroken.";
$none_text = "Geen";
$trip_any_text = "Alle";
$display_options_title_text = "Instelbare display opties";
$display_header_text = "Display Header";
$display_crosshair_text = "Toon crosshair";
$display_clickcenter_text = "Klik naar middelpunt";
$display_overview_text = "Toon overzicht";
$display_language_text = "Selecteer taal";
$display_units_text = "Toon eenheden";
$display_button_text = "Stel in";
$startdate_text = "Van:";
$enddate_text = "Naar:";
$trip_title = "Reis:";
$filter_title = "Filter:";
$date_title = "Datum:";
$tripsummary_title = "Reis overzicht";
$tripstatus_title = "Huidige status";
$summary_time = "Totale tijd:";
$summary_photos = "Totaal aantal foto's:";
$summary_comments = "Totaal aantal commentaren:";
// Public Display Information
$user_button_text = "Toon gebruiker";

// Private Display Information
$login_text = "Gebruikersnaam";
$password_text = "Wachtwoord";
$login_button_text = "Aanmelden";

// Balloon Fields Information
$user_balloon_text = "Gebruiker";
$trip_balloon_text = "Reis";
$time_balloon_text = "Tijd";
$speed_balloon_text = "Snelheid";
$altitude_balloon_text = "hoogte";
$total_time_balloon_text = "Reistijd";
$avg_speed_balloon_text = "Gem. snelheid";
$total_distance_balloon_text = "Totale afstand";
$point_balloon_text = "Punt";
$comment_balloon_text = "Commentaar";
$speed_imperial_unit_balloon_text = "mph";
$distance_imperial_unit_balloon_text = "Mijlen";
$height_imperial_unit_balloon_text = "Voet";
$speed_metric_unit_balloon_text = "km/h";
$distance_metric_unit_balloon_text = "Kilometer";
$height_metric_unit_balloon_text = "Meter";
}

mcross
30-01-2008, 07:17 PM
mcross,

Would it be possible to show the trip summary and the date range but without showing the data? I mean, when you select a trip, run some queries to get that information and nothing else.

At least in my case at this moment I cannot use the viewer.It just takes too long every time that I log in.

Yes, I will work on this.

mcross
30-01-2008, 07:25 PM
Could you add "dutch" to the language file?

Here is the translation:

elseif($language == "dutch")
{
$title_text = "TrackMe Display";
$trip_button_text = "Toon reis";
$location_button_text = "Volg live";
$filter_button_text = "Punten filter toepassen";
$filter_none_text = "Toon alle punten";
$filter_photo_comment_text = "Toon foto en commentaar punten";
$filter_photo_text = "Toon foto punten";
$filter_comment_text = "Toon commentaar punten";
$filter_last_20 = "Toon laatste 20 punten";
$filter_daterange = "Toon datum bereik";
$footer_text = "Tracking informatie verzorgd door ";
$incomplete_install_text = "Installatie niet volledig uitgevoerd! De files install.php en database.sql bestaan in de TrackMe map. Delete install.php en database.sql uit de TrackMe map om gebruikt te maken van Trackme.";
$no_data_text = "Een of meer TrackMe tabbellen in de database zijn leeg. Je moet eerst gegevens genereren met de TrackMe applicatie op je Windows Mobile apparaat voordat de kaart weergegeven kan worden.";
$database_fail_text = "Verbinding maken met database mislukt. Weergeven afgebroken.";
$none_text = "Geen";
$trip_any_text = "Alle";
$display_options_title_text = "Instelbare display opties";
$display_header_text = "Display Header";
$display_crosshair_text = "Toon crosshair";
$display_clickcenter_text = "Klik naar middelpunt";
$display_overview_text = "Toon overzicht";
$display_language_text = "Selecteer taal";
$display_units_text = "Toon eenheden";
$display_button_text = "Stel in";
$startdate_text = "Van:";
$enddate_text = "Naar:";
$trip_title = "Reis:";
$filter_title = "Filter:";
$date_title = "Datum:";
$tripsummary_title = "Reis overzicht";
$tripstatus_title = "Huidige status";
$summary_time = "Totale tijd:";
$summary_photos = "Totaal aantal foto's:";
$summary_comments = "Totaal aantal commentaren:";
// Public Display Information
$user_button_text = "Toon gebruiker";

// Private Display Information
$login_text = "Gebruikersnaam";
$password_text = "Wachtwoord";
$login_button_text = "Aanmelden";

// Balloon Fields Information
$user_balloon_text = "Gebruiker";
$trip_balloon_text = "Reis";
$time_balloon_text = "Tijd";
$speed_balloon_text = "Snelheid";
$altitude_balloon_text = "hoogte";
$total_time_balloon_text = "Reistijd";
$avg_speed_balloon_text = "Gem. snelheid";
$total_distance_balloon_text = "Totale afstand";
$point_balloon_text = "Punt";
$comment_balloon_text = "Commentaar";
$speed_imperial_unit_balloon_text = "mph";
$distance_imperial_unit_balloon_text = "Mijlen";
$height_imperial_unit_balloon_text = "Voet";
$speed_metric_unit_balloon_text = "km/h";
$distance_metric_unit_balloon_text = "Kilometer";
$height_metric_unit_balloon_text = "Meter";
}

Thanks for the translation, I will include with the next updates.

staryon
30-01-2008, 10:00 PM
Yes, I will work on this.

thanks a lot!

GpsPasSion
30-01-2008, 11:54 PM
Good news, my server is now up and running thanks to the lastet install and full zip, maybe I was missing a file, oh well ;-)

I have a couple of suggestions for the "forced update" button. It works pretty well as it is, but could it be added to the buttons on the main page, there is still room on the right and it would be easier to use that way.

More importantly could you freeze the GPS position when the button is pushed that way you can memorize a specific spot and then type your text when time permits (useful when driving!).

Also, could you blank out the form once it has been sent that way the user won't have to delete the link for a picture or the previous text.

Thanks for a great app !

staryon
31-01-2008, 12:12 AM
Good news, my server is now up and running thanks to the lastet install and full zip, maybe I was missing a file, oh well ;-)

Great. I'm glad it works now.


I have a couple of suggestions for the "forced update" button. It works pretty well as it is, but could it be added to the buttons on the main page, there is still room on the right and it would be easier to use that way.

Yes, I will add it for the next version.


More importantly could you freeze the GPS position when the button is pushed that way you can memorize a specific spot and then type your text when time permits (useful when driving!).

Not sure about this. I'll take a look


Also, could you blank out the form once it has been sent that way the user won't have to delete the link for a picture or the previous text.

Yes, not a problem.

Regards

chezzorilla
31-01-2008, 09:06 AM
Where can I see the pics I upload? They don't appear in Google Earth unless I am missing someting.

gkbhat
31-01-2008, 09:07 AM
In my ETEN M700 GPS is not reconginsed by Trackme. I triued all the GPS ports still it doesnot recognise. Can you please help me?
GKBHAT

staryon
31-01-2008, 03:57 PM
Where can I see the pics I upload? They don't appear in Google Earth unless I am missing someting.

Were they uploaded correctly? You should get a message that says 'Done!' when is uploaded fine. Are you using your own server?

staryon
31-01-2008, 03:58 PM
In my ETEN M700 GPS is not reconginsed by Trackme. I triued all the GPS ports still it doesnot recognise. Can you please help me?
GKBHAT

Do you get any errors? or it just says 'Opening port COM..." indefinitely?

chezzorilla
31-01-2008, 05:47 PM
I am using your server and I just found my pics when pressing a balloon in GE. Is it possible to have the balloons that contain pictures stand out / have a different colour?

Kai-Uwe
31-01-2008, 05:57 PM
Hi, i found out that in the German translation there are some "Bugs". Parts are still in english. So i post here the full German translation (i am German) maybe it would help you in the next version.

Than what i found out is when you set the config php to German and Metric it still pops up in english an imperial. You have to swich manually. Maybe it could be fixed.

So, here the German translation:

---------------------------------------------
if($language == "german")
{
$title_text = "TrackMe Anzeige";
$trip_button_text = "Zeige Strecke";
$location_button_text = "Zeige letzte Position";
$filter_button_text = "Setze Wegpunktfilter";
$filter_none_text = "Zeige alle Wegpunkte";
$filter_photo_comment_text = "Nur Wegpunkte mit Photo und Kommentar";
$filter_photo_text = "Nur Wegpunkte mit Photo";
$filter_comment_text = "Nur Wegpunkte mit Kommentar";
$filter_last_20 = "Zeige die letzen 20 Wegpunkte";
$filter_daterange = "Zeige Datenbereich";
$footer_text = "Die Tracking Information wurde bereitgestellt von ";
$incomplete_install_text = "Installation wurde nicht erfolgreich beendet! Die Intallationsdateien index.php und database.sql befinden sich noch im TrackMe Ordner. Um die Kartenanzeige zu aktivieren, bitte die Dateien install.php und database.sql aus dem TrackMe Ordner entfernen.";
$no_data_text = "Eine oder mehrere Tabellen in der Datenbank sind leer. TrackMe muss mindestens einmal auf dme Mobilen Gerät gelaufen sein.";
$database_fail_text = "Fehler bei Verbindung zur Datenbank. Die Anzeige wurde abgebrochen.";
$trip_none_text = "keine";
$trip_any_text = "beliebige";
$display_options_title_text = "Eigene Display einstellungen";
$display_header_text = "Zeige Header";
$display_crosshair_text = "Zeige Fadenkreuz";
$display_clickcenter_text = "Klick zum Zentrieren";
$display_overview_text = "Zeige Übersicht";
$display_language_text = "Wähle Sprache";
$display_units_text = "Wähle Einheiten";
$display_button_text = "Änderungen aktivieren";
$startdate_text = "Von:";
$enddate_text = "bis:";
$trip_title = "Strecke:";
$filter_title = "Filter:";
$date_title = "Zeitraum:";
$tripsummary_title = "Streckendaten";
$tripstatus_title = "Streckenname";
$summary_time = "Zeit:";
$summary_photos = "Photos:";
$summary_comments = "Kommentare:";
// Public Display Information
$user_button_text = "Zeige Benutzer";

// Private Display Information
$login_text = "Benutzername";
$password_text = "Passwort";
$login_button_text = "Anmelden";

// Balloon Fields Information
$user_balloon_text = "Benutzer";
$trip_balloon_text = "Strecke";
$time_balloon_text = "Zeit";
$speed_balloon_text = "Geschwindigkeit";
$altitude_balloon_text = "Höhe";
$total_time_balloon_text = "Gesamtzeit";
$avg_speed_balloon_text = "Durchschnittstempo";
$total_distance_balloon_text = "Entfernung";
$point_balloon_text = "Punkt";
$comment_balloon_text = "Kommentar";
$speed_imperial_unit_balloon_text = "mph";
$distance_imperial_unit_balloon_text = "Meilen";
$height_imperial_unit_balloon_text = "Fuss";
$speed_metric_unit_balloon_text = "km/h";
$distance_metric_unit_balloon_text = "Kilometer";
$height_metric_unit_balloon_text = "Meter";
}
--------------------------------------------------------------------

This translation is FULL German. So letters Ä/äaÖ/ö nd Ü/ü are includet. When you loock it in the Browser at this time you get an square. Maybe you can fix it or you (i) have to change the Letters to Ae/ae Ue/ue and Oe/oe.

Just tell me.

Greetings Kai-Uwe

staryon
31-01-2008, 06:05 PM
I am using your server and I just found my pics when pressing a balloon in GE. Is it possible to have the balloons that contain pictures stand out / have a different colour?

I will change the icon for positions with a picture attached for the next version.

Kai-Uwe
31-01-2008, 06:15 PM
I have found 2-3 Mistakes again. They are away now. Maybe it is easyer for you an others to post the complete langeuage.php. So i adet the file here.

But think about the german letters ÄÖÜ. I dont know to handle them :-)

Greetings Kai-Uwe

roks
31-01-2008, 07:04 PM
Hi All,

I recently went on a trip and used TrackMe to cature my routes. How ever, when I got back from my trip that I realised individual kml files we're not created but its been over written each time.

I realise that there is a log files with all the gps cordianates, is there any way to create the kml files from that? so that i can view the routes in google map?

thanks

staryon
31-01-2008, 07:40 PM
Hi All,

I recently went on a trip and used TrackMe to cature my routes. How ever, when I got back from my trip that I realised individual kml files we're not created but its been over written each time.

I realise that there is a log files with all the gps cordianates, is there any way to create the kml files from that? so that i can view the routes in google map?

thanks

Please check the FAQ in the first post, the one that talks about TrackMe always showing the same position.

mcross
31-01-2008, 09:13 PM
staryon,
made the change to not load the map data when you first arrive at the page and when you switch trips, I did not really know what to do with the map, so its just a blank space, if you have any ideas let me know.

Kai-Uwe,
added the german translation and I believe the config defaults will be applied correctly.

annegerben,
added the dutch translation.

check that its correct here (http://www.mc-consult.com/trackme), I will then attach the updated files.

staryon
31-01-2008, 11:30 PM
staryon,
made the change to not load the map data when you first arrive at the page and when you switch trips, I did not really know what to do with the map, so its just a blank space, if you have any ideas let me know.

Kai-Uwe,
added the german translation and I believe the config defaults will be applied correctly.

annegerben,
added the dutch translation.

check that its correct here (http://www.mc-consult.com/trackme), I will then attach the updated files.

It looks very good.
Maybe you could show the world map or the TrackMe icon... it's up to you.
By the way, when the map is empty I can see these 2 characters at the bottom //
Maybe you added that for testing or something like that.

The only thing that I would change (it's up to you, it's ok the way as it is right now) is to put everything that has to do with the Search inside a panel, so the Live Tracking button is outside that panel.
Even better, when you are in live tracking, all that panel should not be visible, instead just have a button that says 'Search mode' or something like that.

Attached is an example with the panel. But again, it's great as it is... just make the modifications that you consider.

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

roks
01-02-2008, 10:33 AM
Please check the FAQ in the first post, the one that talks about TrackMe always showing the same position.

Thanks for the reply, I've tried that, it just creates a new route.kml file.

How do i make it read the gpspositions log file?

Thanks.

Kai-Uwe
01-02-2008, 11:08 AM
staryon,
made the change to not load the map data when you first arrive at the page and when you switch trips, I did not really know what to do with the map, so its just a blank space, if you have any ideas let me know.

Kai-Uwe,
added the german translation and I believe the config defaults will be applied correctly.

annegerben,
added the dutch translation.

check that its correct here (http://www.mc-consult.com/trackme), I will then attach the updated files.

Hi, i am silly :eek:

I do html-coding for a long time. never did php. Edited the language php not with my html-editor. did it with editor from Windows. And dont thougt about the special characters.. Ohh silly!!!!!

So i did the german translation again. And now it also works with the Characters äöü :-)

In case of that you have addet other languages i only have addet the german translation part of the language.php for you.

Greetings from germany and excuse my bad english. My German is better....

And private to staryon: My Wife is half Spain :-)

Kai-Uwe
01-02-2008, 12:25 PM
At this time i am testing your latest TrackMe-Version. Anything runs fine exept the upload pictures function.

I have loocked up that the date time settings on my PDA's are perfect. Then startet Trackme and after a few moments after uploading the first points i took a foto and want Trackme to upload it and bring it to the right position point.

I testet with 2 differend PDA.

On my HTC Tytn i get the error: Unable to get positions
On my BlueAngel i get the error: No Date time found

Both PDA are with WM6. And have no GPS integratet. I do it with an external GPS-Mouse. Uploading pictures with "Force Update know" is working fine.

Greetings Kai-Uwe

staryon
01-02-2008, 04:20 PM
Thanks for the reply, I've tried that, it just creates a new route.kml file.

How do i make it read the gpspositions log file?

Thanks.

The KML file is just a subset from the database. If you are interested in a specific trip just export it. That it will create a KML file. You don't really need to keep that KML file, because it can be generated at any time. However, if you want to keep it for some reason, just rename it to something else.

staryon
01-02-2008, 04:25 PM
At this time i am testing your latest TrackMe-Version. Anything runs fine exept the upload pictures function.

I have loocked up that the date time settings on my PDA's are perfect. Then startet Trackme and after a few moments after uploading the first points i took a foto and want Trackme to upload it and bring it to the right position point.

I testet with 2 differend PDA.

On my HTC Tytn i get the error: Unable to get positions
On my BlueAngel i get the error: No Date time found

Both PDA are with WM6. And have no GPS integratet. I do it with an external GPS-Mouse. Uploading pictures with "Force Update know" is working fine.

Greetings Kai-Uwe

Did you update the server files? This new version needs a new version of the requests.php file.

If you get the message 'No date time found' is because the EXIF data doesn't contain a tag named TAG_DATE_TIME or EXIF_TAG_D_T_ORIG. That tag contains the date time information.

If you know how to do this, could you check if your image has a different tag name for the creation date? If not, you can send a picture to me so I can take a look at the EXIF data.

Kai-Uwe
01-02-2008, 06:59 PM
Did you update the server files? This new version needs a new version of the requests.php file.

If you get the message 'No date time found' is because the EXIF data doesn't contain a tag named TAG_DATE_TIME or EXIF_TAG_D_T_ORIG. That tag contains the date time information.

If you know how to do this, could you check if your image has a different tag name for the creation date? If not, you can send a picture to me so I can take a look at the EXIF data.

Who i find the new requests.php? in the lastupdatezip i found there where only a language.php, index.php and config.php.

I will look at the exif-data later. Now i have to go to work. Could it be that my pda dont create exif data? Is there the possibilitiy to get that needet information from the file porpertys?

Greetings Kai-Uwe

staryon
01-02-2008, 08:39 PM
Who i find the new requests.php? in the lastupdatezip i found there where only a language.php, index.php and config.php.

I will look at the exif-data later. Now i have to go to work. Could it be that my pda dont create exif data? Is there the possibilitiy to get that needet information from the file porpertys?

Greetings Kai-Uwe

The latest files are always in the first post.

annegerben
01-02-2008, 11:34 PM
staryon,
made the change to not load the map data when you first arrive at the page and when you switch trips, I did not really know what to do with the map, so its just a blank space, if you have any ideas let me know.

Kai-Uwe,
added the german translation and I believe the config defaults will be applied correctly.

annegerben,
added the dutch translation.

check that its correct here (http://www.mc-consult.com/trackme), I will then attach the updated files.

Is the text in the variables $none_text and $trip_any_text used in a query?
When they are translated (and I use them on my own server) I get an mySQL error on lines 603 and 604 in index.php


Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /hermes/web08/b1380/pow.mcconsult/htdocs/trackme/index.php on line 603

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /hermes/web08/b1380/pow.mcconsult/htdocs/trackme/index.php on line 604
On your server the Dutch text for $none_text isn't showing in the dropdown menu.

annegerben
01-02-2008, 11:45 PM
The latest files are always in the first post.

Could you add the version number in the startpost so I can see easily if have installed the latest version?

And is it possible to change the layout so it is also optimal for landscape?
for example in the manage trips screen you have to scoll to see the buttons

staryon
01-02-2008, 11:50 PM
Could you add the version number in the startpost so I can see easily if have installed the latest version?

And is it possible to change the layout so it is also optimal for landscape?

I'll put the date when the whole package has been updated from now on.

> And is it possible to change the layout so it is also optimal for landscape?

Do you mean TrackMe's layout?

annegerben
02-02-2008, 12:00 AM
I'll put the date when the whole package has been updated from now on.

> And is it possible to change the layout so it is also optimal for landscape?

Do you mean TrackMe's layout?

yes, I'll try to upload some screenshots later.

odie3
02-02-2008, 12:03 AM
Well, I been avoiding installing the newer version since I also had to update .Net and SQCE. So, I finally bit the bullet and updated across the board (.Net/SQCE/Web Site).

All seems okay with the upgrade and I am eager to see how the new update off line positions and pictures work. :)

The new version of the web code is GREAT and I like the new changes.

Now to a little problem. It seems I can use the Configuration button, but once I exit out the button does not work again. I have to restart TrackMe to get the configuration button to work again. No big deal...

annegerben
02-02-2008, 12:22 AM
yes, I'll try to upload some screenshots later.

here are the screenshots

Kai-Uwe
02-02-2008, 12:20 PM
Hi.....

so, i do the updates and testet again a little bit: Here are the results:

In the Server files the german translation is not includet, mean it is the old wrong one. I addet the complete language.php here.

When using the upload offline pictures funktion:
On my HTC Tytn with WM6 it works fine :-)

On my BlueAngel with WM6 it did not work. Seems that there are no exif data in the pics.
I addet a test picture here also. Maybe you can extract the Date/Time from the picture propertis. Not from the exif-data? So you can use the full function from TrackMe with older PDA's.

On the Web interface:
When setting the config.php to German and Metric it always pops of in english and imperial. So you have to switsh it manually everytime you acces the Trackpage.

The favicon did not work.

Keep on you more thant excellent work!!!!!

Greetings Kai-Uwe

staryon
03-02-2008, 01:53 AM
New version available!

- Pictures upload. If not EXIF data found, file properties will be used.
- Pictures upload. When a picture is uploaded using this method, the icon
'Camera' will be used.
- Added icon 'Force update' in the main window
- Force Update form is emptied after uploading a position.
- Manage trips window now supports landscape layout.

For people using their servers, I have updated the file requests.php

odie3
03-02-2008, 03:33 AM
Now to a little problem. It seems I can use the Configuration button, but once I exit out the button does not work again. I have to restart TrackMe to get the configuration button to work again. No big deal...

Sorry, that is not the Config button but the "Tools" button.

staryon
03-02-2008, 03:34 AM
Sorry, that is not the Config button but