yashsingh1/xdaforums huggingface dataset:
[Windows Mobile Apps and Games] Riel:
When starting for first time:

'cant find file- or assembly-name System.Data.SqlServerCe, Version=3.5.0.0, Culture=neutral, PublicKeyToken=3BE235DF1C8D2AD3 or one of the dependencies'

I can only select 'close'.

(translated from Dutch).

I have installed .net 3.5 on diamond. It had 2.0 before, but separatedly installed 3.5 and selected to use this one. Has it got to do with that?
[Windows Mobile Apps and Games] justpctech:
SQL Server Mobile 3.5

you will need the SQL Server Mobile 3.5 thats listed in the first post here...that's whats throwing that error message.
[Windows Mobile Apps and Games] Riel:
Offcourse.

Silly me, works ;)

Didn't look twice in startpost.
[Windows Mobile Apps and Games] Riel:
[OLD]ok,

I set up my own server, but I get this message on my PDA:

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

I don't knwo where on my server I should fill in my username?

Trackme does connect to database.

(www.rielity.nl/trackme/)

*** changed port number, and get another message about the message cannot be displayed. I have a dutch .net and installed the error-messages-cab. Maybe ain't working too. Anyway, I don't know if port number is right, i'm really not into this. I just know what to fill in for databases and so on and that's all really :). It seems to work with this port number (80 didn't) but I am not sure. I don't get 'unable to create user' anymore ****

Any idea what i've missed?[/OLD]

*** got error message : This protocol version is not supported ***
[Windows Mobile Apps and Games] Riel:
On the diamond, .net 2.0 was installed by default.

I installed 3.5 with a config tool, so WM must be using 3.5 only.

Can it have something to do with this?
[Windows Mobile Apps and Games] Riel:
Hmm..

looks it's a server side problem, it works like a charm on luisespinoza.com !!

I want to use it on my own server.

What I want to do with it is this:

I want to make a list with distance I travelled for work every day.

Start adres, end adress, distance travelled, date and time.

Is this information extractable?

It would be worth A LOT for me , saving me hours of jotting down every mile i've driven (i have my own company as a single-employed man) so I need to get the taxes back.

Think I go for a donation, s soon as I got my own server working. one of the best ppc apps I found !
[Windows Mobile Apps and Games] Riel:
Nobody an idea why that protocol is wrong, and what protocol is meant there?
[Windows Mobile Apps and Games] Phree:
Yikes!

Check this out. Today, I had to pop to town so I thought I'd take my iPaq with me and create a new journey for TrackMe. The journey was a round trip of no more than maybe 5 miles. I used my external bluetooth gps receiver, had 9 satellites in view and all was good to go. So off I went, all was good. Got home and uploaded the route and here's what I got:

I like to drive fast but even I'd struggle with those speeds!! Not sure if it was a problem with TrackMe, my bt gps receiver or the iPaq itself. I'll try it again later tonight...
[Windows Mobile Apps and Games] Phree:
Riel,

as I remember, you don't create a username/password on your server. You put the details into your version of TrackMe on your PPC. Then you create a route. Then you upload it - and then you should be able to sign in on your server ;)

Give that a go.
[Windows Mobile Apps and Games] del4:
Where did you learn about this, as it's the first I've heard of it?!? It would explain why no matter what I did, I couldn't get my Mogul's GPS to work last week on a trip to central Europe! Had hoped to use TrackMe to record my travels, but couldn't get a single satellite... if you could point me to more info on this via PM, I'd appreciate it.
[Windows Mobile Apps and Games] _LEM_:
I've had that problem a couple of times while using TomTom.

I'm not sure but I've heard that the problem could be related with interferences with high voltage posts and similar.
[Windows Mobile Apps and Games] Riel:
Hmm, I didn't create that. I also don't know what my port number should be. I have server running somewhere else, I set up databases via port 2443. But don't know if I must use that here too ...

But on port 2443 it 'connects' but I get that protocol error. It is not saying that when I use luis' server. So on serverside is something wrong. Maybe not accepting html? Must I set a .htcacces maybe?
[Windows Mobile Apps and Games] Phree:
Riel,

I'm just about to leave for work - but I can pick this thread up when there and go through everything on my server and jot it down for you to check against yours if any good? We can also go through the settings on our PPC's to compare?

Happy to help :)
[Windows Mobile Apps and Games] Riel:
Cool phree, i'll be here in an hour I guess :)

On port 80 i get:

user didn't exist or user could not be created ...
[Windows Mobile Apps and Games] Phree:
Hi Riel,

at work now...I'm just about to look at how everything is setup on both my server and my PPC...I'll post up again in the next few minutes ;)
[Windows Mobile Apps and Games] Riel:
Well, seems I can't get acces to database on my website from my ppc.

Can't create user, i'll try on a friends server now for a change.

I am not sure about port 80 / 2443
[Windows Mobile Apps and Games] Riel:
wow

how you run the sql inserts?

I am using an existing database !
[Windows Mobile Apps and Games] Riel:
Ah

In my php_myadmin the 'users' is already taken by my master website!

I need that.

possible to change?
[Windows Mobile Apps and Games] Phree:
Can you not just create a new database? You should be able to. When you access your server, how do you do it? Do you use CPanel?
[Windows Mobile Apps and Games] Riel:
Nope, I have the right to use just one database.

But, i just changed all USERS to TM_USERS in every file :p so lets see what it does.
[Windows Mobile Apps and Games] Riel:
Well, the user accounts are created....

but now it's unable to create trip :S

the trips table is there?
[Windows Mobile Apps and Games] Phree:
Did you look in the php files for the SQL INSERTS as well? There will be mentions of USERS in those files as well.

If this all becomes too messy or complicated, I can just set you up with a copy of it on my server if you like? I can pwd protect it for you so only you (not even me) will have access to it :-)
[Windows Mobile Apps and Games] Phree:
Ah ok, do you have a trip that you've already recorded on your PPC? If so, upload it. If not, create one and then upload it ;)
[Windows Mobile Apps and Games] Riel:
I think I had to re-create that trips table?

* search all php files and changed it

* search the .sql file and changed it

* removed all tables via phpmyadmin

* ran the install via install.php

* tables were nicely created ... and

* ITS WORKING

THANX a lot for your time, without you mentioning that SQL thing it wouldn't slip my mind that my database was causing trouble...

ok, now I'll shut up for a while :p

But still I have questions for the next step:

IS it possible to get a streetname or at least a city out of google maps?
[Windows Mobile Apps and Games] Phree:
YAY!! Glad it's working :) And glad I could help ;)

Ok, when you say a streetname/city out of Google maps how do you mean? What are you trying to do?
[Windows Mobile Apps and Games] Riel:
I want to make a report:

Date - time - trip - km's - duration

Trip is important as a description.

10-08-08 10:20AM - EIndhoven->sittard - 67 km 40 min

11-08-08 09:30AM - Eindhoven->amsterdam - 110 km 70 min

etc etc

That would be awesome (and even would pay for it, just because it doesn't exist :S)
[Windows Mobile Apps and Games] Phree:
Phew, I'm not so sure that could be done...I think you would somehow have to have a database that would contain all the longitude & latitude of all the possible cities you would be going from & to and as I'm sure you can imagine, this would be enormous. I guess you could somehow create your own database that contained the cities that only you need but I'm not really sure how you could do this as you would have to base your cities as a square and have lon & lat details for the top left, top right, bottom left, bottom right of that square. Then you would need to figure out your SQL to check if your start or end lon & lat fell in between those four co-ords. Tricky, really tricky.

Maybe someone else will read this and say all the above is rubbish and there is an easy way to do it - and I hope they do coz doing what you are trying to achieve would be cool :cool:

As for the rest of your report, that would be easy enough to write the SQL for as all the data you need is already uploaded to the database.
[Windows Mobile Apps and Games] Riel:
WEll, in google maps when I click somewhere a balloon with current city pops up ;)

I can see the streets also when I use the found coordinates to plan a route with google maps ... !

And is *this* possible with the collected coordinates?

http://www.marsrutai.info/directions.htm

And here is an example of a database (but just not usable this way around I guess :p) http://www.tageo.com/index.php?show=search
[Windows Mobile Apps and Games] Phree:
Hey :)

As you say, the link you posted does the reverse of what you need. You also have to remember, that Google Maps isn't taking a longitude and latitude and then converting it into a street name. What it's doing, is taking those co-ords and overlaying a map with those co-ords at the centre. Any clickable balloons would have been added afterwards either by Google staff themselves or other net users.

I just searched Google for a while trying to see if what you want to do has been done and although I found a couple that seem to work on that basis, they were only in the US.

I think you would have to create the database yourself and work from there :( But hey, I could be wrong and as I said before, I'd be happy to be if someone else could show how it's done.
[Windows Mobile Apps and Games] Riel:
And what's this?

http://nicogoeminne.googlepages.com/documentation.html

Think it is JUST what i was looking for.

But I am no programmer :) :p
[Windows Mobile Apps and Games] Phree:
You proved me wrong :D

That is VERY cool...I tried using this: http://nicogoeminne.googlepages.com/full4.html and it worked great for me in the UK..Now to implement it into your report somehow. I'll take a look into it if you like as you'll need to somehow pull the data out of the result and store it.

Nice!
[Windows Mobile Apps and Games] Riel:
It got my neighbours housenumber here in the Netherlands while getting gps coordinatie in house, that's impressive :)

Well:

If TrackMe works the way it does now I already have:

- Total KM's

- Start and End time

- Duration

Just reverse geocode the start and end coordinates and we have a full log :p

Maybe option to get an adress loggen in between (done by pressing a button on PDA where it sends and extra trigger signal so reverse geocoder knows he has to take it too)

But maybe i have to slow it down a bit ... getting some sleep ..

Need to ask the creator of the server-files if this functionality can be added, or maybe I know someone...

If the creators are ok with this idea?
[Windows Mobile Apps and Games] Phree:
Heh, no worries. Sleep well :)

So far as implementing something like this into TrackMe would have to be something you put forward as a possible future development. The way I'm thinking it could work is if you store a kml file on your server when uploading a route (it's in the config menu) and then have a separate page (maybe your reporting page) that lets you choose the kml file. It then takes the first lon & lat, converts that and adds to the main database, then the same with the last lon & lat...That way you would have your start & end locations to include in your report.

I'll have a playaround and see what I can come up with - if anything!
[Windows Mobile Apps and Games] Riel:
Thanx a lot, but don't spend too much of your time there :)

I think it is possible, so I just wait patiently for someone to integrate that.

The best part is already done: getting the coordinates on your own server!

What you do with em ... is up to you :)
[Windows Mobile Apps and Games] _LEM_:
hey man... thanks a lot for your support.

It's great to have people like you willing to help like that.

Best regards
[Windows Mobile Apps and Games] Phree:
Hey, no problem :) I've been there myself once too many times with other things and have been in a position where no-one wants to help (even though I know they could if they wanted to) and so I'm always happy to help if and where I can.

Now it's ticking over in my mind about this reverse geocoding and whether I can do it or not! It would be quite cool to somehow implement it for reporting. I think it could be done in the way I described above by pulling the first & last details out of the kml file. I think I'll try and VBScript it and then incorporate it into a "reports" html page kinda thing.
[Windows Mobile Apps and Games] Riel:
I can only appreciate Phree ;)
[Windows Mobile Apps and Games] _LEM_:
Thanks for your requests. They look interesting but they may take a while to do. I'm really sorry but I don't have plans to add your requests at this moment so I prefer not to promise you anything.

What you are really asking if for GPS Fleet tracking and TrackMe is not really intended for that.

Sorry about that.

Regards
[Windows Mobile Apps and Games] Riel:
Hi!

All respect for that!

But I really dont want fleet tracking, just a report of one (my) driven routes.

Anyway, I hope I am free to use the data from your program freely on my server?

Anyway, I really don't want to push you, and for the last line in the PM, it's worth it!

Regards!
[Windows Mobile Apps and Games] _LEM_:
Yes, you can use that data with no problems. Just add a reference to my website if you publish it somehow.

By the way, I really have plans in extending the Manage Trips function by showing some extra information when you click on 'Get Existing' That information will include the date and time and the total distance. Hope that helps.
[Windows Mobile Apps and Games] kilrah:
Hi,

I finally got my kaiser back from repair after more than 2 months without it ( :( ), searched for new versions for my usual programs (including Trackme) and reinstalled all my stuff. Now when testing everything, I found a problem with the Trackme trips. I'm running the Trackme server on my website, and was using it without problems previously. Now that I have updated to your latest PDA app version, I can't get it to list the trips anymore. Each time I use the "Get existing trips" function, I get an error saying "Unable to get trip list (Result: 1st_trip_name_here|2nd_trip_name_here|etc)"

So as the trip names are the ones on the server it obviously can reach the server normally and retrieve the names but can't parse them or whatever...

I tried deleting positions from the PDA and it works, creating new trips and uploading positions works too, just not the trip listing. I've tried deleting the contents of the positions and trips DB tables to start cleanly again but it didn't help, I can create new trips again but not list them. Any idea?
[Windows Mobile Apps and Games] _LEM_:
Did you get the latest server files?

I'm not sure what version you are running but the files requests.php and export.php were changed in the latest updates.
[Windows Mobile Apps and Games] Phree:
Hi,

is there any way of changing the filename for the remote kml file within TrackMe? At the moment, all my kml's are saved as "Phree.kml" - so before I upload a new one, I have to change the name of the one currently on my server. I don't know if this is by design or I'm doing something wrong?

Cheers :)
[Windows Mobile Apps and Games] _LEM_:
It's by design. There is one file per user.

Why do you need to have multiple KML files on the server?

By doing that you will need to change the URL every time you want to display something with Google Earth.

Use Trackme's export function to generate the KML file that you need at any moment and open Google Earth. The trip will be shown automatically.
[Windows Mobile Apps and Games] kilrah:
My bad, hadn't seen that. Everything works fine now, thanks :)
[Windows Mobile Apps and Games] Doemaarwat:
When I get my trip summary I get this huge (average) speeds. What is going wrong? I have this working on my own server and when I view the information on my website it gives me the correct average speed.
[Windows Mobile Apps and Games] _LEM_:
That's hard to tell unless I see your data.

Could you provide at least an screenshot of the trip summary?
[Windows Mobile Apps and Games] _LEM_:
TrackMe for iPhones?

I'm getting many requests from people who are asking for a version of TrackMe for iPhones.

I'm really thinking about that, but since it's a completely different technology everything would have to be written from scratch.

The other main problem is the price. I don't own an iPhone 3G which comes with a GPS and also development is not free either because I need to pay Apple a developer fee.

For those reasons I'm thinking in charging for this version of TrackMe. The question is: Would you pay $19 (approximately) for TrackMe for iPhones?

Since it's a lot of work and money If I get a lot of interest on this I may consider start working on this very soon.

Maybe this is not the best forum to ask for this, but if I go to an iPhone forum probably nobody will know about TrackMe!

Please respond on this thread about your thoughts!

Thanks
[Windows Mobile Apps and Games] Phree:
Hiya,

I think I'm getting confused! Ok, let's say I go for a drive and store the track offline. When I get home, I upload the track and also create (remotely) a KML file. This KML file is a copy of the track but for Google Earth right? Then, if I go out for a bike ride and record that track offline and then upload it when I get back & create KML again, the current KML file on the server gets overwritten and replaced with the new one. Is that right? If so, cool :) I seem to have a problem with creating them - I rode home from work the other morning and recorded the track, then uploaded it when home. On my TrackMe page, it displays the route perfectly but when I open the KML file in Google Earth, it doesn't relate to the journey at all. I've also noticed that if I view the KML file in an editor, it's one long continuous line of data across the page, but if I view a KML that's been created differently (any example KML file off the net) it's all formatted and goes down the page rather than across it.
[Windows Mobile Apps and Games] _LEM_:
The thing is... you only need to create a KML file when you want to see something right now on Google Earth. Data is stored in the database. You don't need to be creating KML files every time there is a new trip.
[Windows Mobile Apps and Games] Riel:
Simple.

Yes.

What's 19$? It's usefull...
[Windows Mobile Apps and Games] jon_k:
To be honest I wouldn't buy it on the iPhone.

TrackME is a cool program though I haven't donated as promised because I never got it up and running again like I thought I would.

Instead I ended up getting an FCC license and using Amateur Radio spectrum to send out GPS coordinate packets using my electronic device I built myself.

I use the APRS protocol ( http://en.wikipedia.org/wiki/Automatic_Position_Reporting_System )

I also don't own the iPhone though. However, I'd rather keep the Tilt and use TrackMe for free.If I used TrackMe on the Tilt, I probably wouldn't be opposed to purchasing it. After all, you've supported this program for a long while and it'd be worth the cost.
[Windows Mobile Apps and Games] Andehh:
I have done my best to search through this thread but i cant find any answers. In short i am still getting the:

''File or assembly name 'System.Data.SqlServerCe, Version=3.5.0.0, Culture=neutral, PublicKeyToken=3BE235DF1C8D2AD3', or one of its dependencies, was not found''. I then press quit to get rid of it and it comes up with another error message saying .NEt CF Initialization Error....App failed to load....NET compact Framce is installed on SD card, make sure the card is inserted into the device. If it still fails to load, re-install.NET compact framework is recommended.

Even after iv installed the fix. I am using a clean install of Dutty's latest 6.1, on t-mobile in the UK.

I am sorry if this has been asked already in the thread, but 266 pages is an awfull lot of infomation to search though!

thanks guys :)
[Windows Mobile Apps and Games] Riel:
Installed SQL 3.5?

And .net 3.5?

I had .net 2.0 installed first.

THere is a config tool that let windows use 3.5. After installing it, wm6.1 still uses 2.0 until you say it must use 3.5
[Windows Mobile Apps and Games] Andehh:
I am guessing not, iv got literally what came with Dutty's 6.1. Still fairly new to the phone.

Dont spose you have a link, or know where i can find it do you? Ill have a search around aswell.

thanks :)
[Windows Mobile Apps and Games] cotr:
remote enable?

heres a weird thought related to loosing a phone.

would it be possible to remotely activate the tracking system for viewing when you loose it?
[Windows Mobile Apps and Games] Riel:
I guess so.

Use this:

http://xdaforums.com/showthread.php?t=379440

In combination with the 'auto start' function of TrackME and you are set.
[Windows Mobile Apps and Games] del4:
Sure! Check out Mobile SMS Remote, which lets you execute commands, e.g., starting TrackMe, via a specially formatted SMS. The source is also provided, so should be a simple matter to modify it to your needs.

HTH
[Windows Mobile Apps and Games] Doemaarwat:
Have screencaptured the data. Maybe you can see what's wrong here.

Added a second screenshot when I went out with the dog a couple of minutes ago.

[Edit]

On my site it says:

avg speed: 3.49 km/h

max speed (which is the speed of the first point): 10.76 km/h

[/edit]
[Windows Mobile Apps and Games] AllTheWay:
I thought this thread would be better placed in the Kaiser Software section. If this is going to be a problem let me know. Just might be easier to find on page one since in the Kaiser General section all you get usually is a page full of questions that have already been answered.
[Windows Mobile Apps and Games] _LEM_:
wow... :)

I think it has to do with the regional settings. Could you let me know where are you located?
[Windows Mobile Apps and Games] _LEM_:
Sounds good to me.

Regards
[Windows Mobile Apps and Games] Doemaarwat:
I am located in the Netherlands. My thousand separator is '.' and my decimal separator is ','.

In my database is seems the speed is save with a '.' as decimal separator.

Do you calculate it in your program on the device or is it a query which gives the avg. speed?

This issue about separator gives me as a developer _always_ trouble :)

[edit]

Is seems the calculation is done in the TrackMe program on the PPC itself. I changed the thousand separator and the decimal separator and it gives me the correct avg. speed.

Maybe for your next fix. Get the separators before calculating.

[/edit]
[Windows Mobile Apps and Games] MAD_Funk:
Thanks for your post

Most Excellent :D staryon

Am a newbie to xda- developers, and have been looking for a tool like this for a while. Thanks for the post.

Works great!
[Windows Mobile Apps and Games] p-de-geus:
This is a very nice software :):).

I tested it and like it, I'm also run the server site on my own web page.

I'm going to test/use it during my holiday, going on a sailing trip at the Greece coast.
[Windows Mobile Apps and Games] lidholm:
Hi

I read in one of the posts in the beginning of this thread that you maybe would release the code for the program. I have searched for it but haven't found it yet.

Has it been released yet?

I would love to have a look at how it is written!
[Windows Mobile Apps and Games] _LEM_:
Thanks for the info. It should be an easy fix. I'll try to release it as soon as possible.
[Windows Mobile Apps and Games] _LEM_:
Sorry man but I don't plan the release the source code.

You cannot believe how many supposely 'non-profit' companies asked me to get the code just to use it in their commercial applications.

Regards
[Windows Mobile Apps and Games] mburlingame:
Is there anyway to be able to add the traffic button to the self server?

http://googlemapsapi.blogspot.com/2007/06/add-traffic-to-your-mashup-button.html

Thanks

Great App BTW