It is currently Thu 21 Sep, 2017 21:27

All times are UTC + 2 hours




 Page 1 of 1 [ 8 posts ] 
Author Message
 Post subject: Distance in csv - file?
PostPosted: Wed 21 Jan, 2009 11:23 
Registered
Registered

Joined: Mon 19 Jan, 2009 14:09
Posts: 3
Hello altogether! I'm using an i-blue 747 and Mac Travel Recorder (latest version) for Data logging.

I marked the "distance" button in the software and set it together with all necessary option for Google Earth. After logging quite a while, downloading the data and exporting to csv I was quite astonished, that there was no column in Excel (after importing the previously from MTR exported csv - file) for DISTANCE in the data sheet.

Have I done something wrong? Is it possible to include the distance into the csv file?

And: is there a way to directly see the distance from the Google Earth track?

What I did yesterday, was uploading the kmz - file to [url]http://www.gpsvisualizer.com[/url] There I can get a height-profile which shows height (y axis) and distance (x axis). But this is a little bit too complicate and not accurate enough!

I'm really looking forward to your answers and hope,
that you can help me!

Thanks, Maccle


Offline
 Profile  
 
 Post subject: Re: Distance in csv - file?
PostPosted: Wed 21 Jan, 2009 20:49 
Site Admin
Site Admin

Joined: Sat 25 Dec, 2004 16:19
Posts: 424
Maccle wrote:
After logging quite a while, downloading the data and exporting to csv I was quite astonished, that there was no column in Excel (after importing the previously from MTR exported csv - file) for DISTANCE in the data sheet.

If you have two coordinates, you'll have the distance. The formula to calculate the distance isn't really rocket science.

Quote:
Is it possible to include the distance into the csv file?

I'll have a look at it.



_________________
Met vriendelijke groeten,

Bert Rozenberg
Offline
 Profile  
 
 Post subject: Re: Distance in csv - file?
PostPosted: Fri 23 Jan, 2009 01:34 
Site Admin
Site Admin

Joined: Sat 25 Dec, 2004 16:19
Posts: 424
Maccle wrote:
Is it possible to include the distance into the csv file?

Done. New version online.



_________________
Met vriendelijke groeten,

Bert Rozenberg
Offline
 Profile  
 
 Post subject: Where is the new version?
PostPosted: Fri 06 Feb, 2009 10:31 
Registered
Registered

Joined: Mon 19 Jan, 2009 14:09
Posts: 3
Hey admin!

I tried to find the new version and downloaded twice the dmg.zip
from the download page, but it was every time the same version
number AND when I exported the csv and imported it to Excel,
there was no distance row!

Perhaps you can post the link to the new version somewhere?!?

Thanks a lot!

Maccle


Offline
 Profile  
 
 Post subject: Re: Where is the new version?
PostPosted: Sat 07 Feb, 2009 16:21 
Site Admin
Site Admin

Joined: Sat 25 Dec, 2004 16:19
Posts: 424
Maccle wrote:
I tried to find the new version...

That's not hard to do. It's the only one available.

Quote:
when I exported the csv and imported it to Excel,
there was no distance row!

The only reason I can think of is that you data logger didn't log the distance. MTR will only export distance information if it's supplied by the data logger, it will not calculate that.

Just curious: for what are you using the csv files?



_________________
Met vriendelijke groeten,

Bert Rozenberg
Offline
 Profile  
 
 Post subject: So why did you tell sth about calculating?
PostPosted: Sat 07 Feb, 2009 17:06 
Registered
Registered

Joined: Mon 19 Jan, 2009 14:09
Posts: 3
[quote]If you have two coordinates, you'll have the distance. The formula to calculate the distance isn't really rocket science.

Quote:
Is it possible to include the distance into the csv file?

I'll have a look at it.[/quote]

Okay, doesn'nt matter. Don't want to mix everything.

1) The build/version of MTR which I can download via the MTR HP is the same (I compared the number) which I had previously installed on system. To this end I couldn't notice any change? Or didn't you change the versions number after re-programming?

2) The logging of the distance is definitly set ON.

3) The reason for using the csv is: using the Excel sorting function to get the highest speed AND hopefully in the near future getting the exact distance of a track.

Hope you can help me a little bit more now?!

Bye, Maccle


Offline
 Profile  
 
 Post subject: Re: So why did you tell sth about calculating?
PostPosted: Thu 12 Feb, 2009 16:42 
Site Admin
Site Admin

Joined: Sat 25 Dec, 2004 16:19
Posts: 424
Maccle wrote:
2) The logging of the distance is definitly set ON.

Can you send me the .bin file, so I can have a look at it using your data?

Quote:
3) The reason for using the csv is: using the Excel sorting function to get the highest speed AND hopefully in the near future getting the exact distance of a track.


But there are a zillion programs out there doing that, based on a gpx file.



_________________
Met vriendelijke groeten,

Bert Rozenberg
Offline
 Profile  
 
 Post subject:
PostPosted: Tue 24 Mar, 2009 21:39 
Site Admin
Site Admin

Joined: Sat 25 Dec, 2004 16:19
Posts: 424
There's a new version online.
This version doesn't use the distance from the gps, but calculates the distance between each two coordintaes.



_________________
Met vriendelijke groeten,

Bert Rozenberg
Offline
 Profile  
 
Display posts from previous:  Sort by  
 Page 1 of 1 [ 8 posts ] 

All times are UTC + 2 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:

cron