Writing a converter from9XRPro logs to Google Earth

Help with any software/desktop related issues. e.g. companion9x, eePe, etc
Post Reply
Denis56
Posts: 22
Joined: Sun Sep 02, 2012 5:05 pm
Country: -

Writing a converter from9XRPro logs to Google Earth

Post by Denis56 »

Hello from France,

I just wrote a little piece of software under Excel to convert the .csv files into .kml files, readable by Google Eatrh, so you can visualize your flights. It works fine and I will post it here if people are interested. One small glitch, the position shown on Google Earth is slightly offsetted compared to the reality (i.e. I seem to fly 500m SE of my usual airfield). This is certainly due to my handling of the GPS data coming from the log. Does somebody know exactly under which format the FrSky GPS v2 is transmitting its data to the telemetry ?

Is it DDMM.mmmm or DDMM.SSss, or any other combination ? Given my geographical position, I can't resolve the ambiguity with the data I have...

Two examples from the log : latitude 4332.2635N and longitude 353.1023E. How to interpret those values ?

Thanks for your help !
Denis

User avatar
Kilrah
Posts: 11108
Joined: Sat Feb 18, 2012 6:56 pm
Country: Switzerland

Re: Writing a converter from9XRPro logs to Google Earth

Post by Kilrah »

What firmware are you running on the radio?
Denis56
Posts: 22
Joined: Sun Sep 02, 2012 5:05 pm
Country: -

Re: Writing a converter from9XRPro logs to Google Earth

Post by Denis56 »

The last one, r217.

Thanks !
Denis
User avatar
MikeB
9x Developer
Posts: 17990
Joined: Tue Dec 27, 2011 1:24 pm
Country: -
Location: Poole, Dorset, UK

Re: Writing a converter from9XRPro logs to Google Earth

Post by MikeB »

That's ersky9x then. the format is DDMM.mmmm.
Are you using a hub, or SPort as the GPS source? They send the original data in different formats, but the firmware converts them to the same format.

Mike.
erskyTx/er9x developer
The difficult we do immediately,
The impossible takes a little longer!
Denis56
Posts: 22
Joined: Sun Sep 02, 2012 5:05 pm
Country: -

Re: Writing a converter from9XRPro logs to Google Earth

Post by Denis56 »

I'm using S-Port. I'll make the necessary adjustments tomorrow. Thank you, Mike. Do you think others might be interested by my little software?
Denis

Denis56
Posts: 22
Joined: Sun Sep 02, 2012 5:05 pm
Country: -

Re: Writing a converter from9XRPro logs to Google Earth

Post by Denis56 »

Okay, everything's fine. The radio does output latitude and longitude under the DDMM.mmmm format as said by Mike and .kml format, for Google Earth, is using the DD.dddddd format. So I can now view directly my flight logs written on the SD Card of my 9XRPro radio into Google Earth! Next step will be to see if an animation is possible (and it should be).

Thanks!
Denis
User avatar
MikeB
9x Developer
Posts: 17990
Joined: Tue Dec 27, 2011 1:24 pm
Country: -
Location: Poole, Dorset, UK

Re: Writing a converter from9XRPro logs to Google Earth

Post by MikeB »

I'm sure others will be interested in your software. I have a GPS sensor, but I don't tend to use it. I would certainly do some flights with it installed and try out your software. I know I have some log files from when I was testing some things with the GPS installed.

Mike.
erskyTx/er9x developer
The difficult we do immediately,
The impossible takes a little longer!
User avatar
jhsa
Posts: 19480
Joined: Tue Dec 27, 2011 5:13 pm
Country: Germany

Re: Writing a converter from9XRPro logs to Google Earth

Post by jhsa »

That is nice in case you lose your model when flying.

João
My er9x/Ersky9x/eepskye Video Tutorials
https://www.youtube.com/playlist?list=PL5uJhoD7sAKidZmkhMpYpp_qcuIqJXhb9

Donate to Er9x/Ersky9x:
https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=YHX43JR3J7XGW
Denis56
Posts: 22
Joined: Sun Sep 02, 2012 5:05 pm
Country: -

Re: Writing a converter from9XRPro logs to Google Earth

Post by Denis56 »

So, here it is. The user manual is included inside, on the work page itself. Obviously, macros must be enabled.

Please download it here : http://dl.free.fr/vijVDT5x7
Password is Summer2015

Here, it works without a glitch but I am aware that sometimes, errors happen with international versions of the software. I have to means to test against that. The code inside is not protected and can be amended in case of trouble or to add new functionalities. An example gathering 7 flights is also included for demo. Flights 1 and two are good examples. I am now working on animating the graphics. Eventually...

Thanks!
Denis
Denis56
Posts: 22
Joined: Sun Sep 02, 2012 5:05 pm
Country: -

Re: Writing a converter from9XRPro logs to Google Earth

Post by Denis56 »

A small update of the same, with a protection against empty data transmitted by the telemetry when GPS loses its fix.

http://dl.free.fr/han8bdQnk
Password is Summer2015

Good flights!
Denis
User avatar
MikeB
9x Developer
Posts: 17990
Joined: Tue Dec 27, 2011 1:24 pm
Country: -
Location: Poole, Dorset, UK

Re: Writing a converter from9XRPro logs to Google Earth

Post by MikeB »

It seems to want a username as well as a password before I can download it.

Mike.
erskyTx/er9x developer
The difficult we do immediately,
The impossible takes a little longer!
Denis56
Posts: 22
Joined: Sun Sep 02, 2012 5:05 pm
Country: -

Re: Writing a converter from9XRPro logs to Google Earth

Post by Denis56 »

Sorry, the username is the usual anonymous
And the password, as indicated, Summer2105
Denis
Denis56
Posts: 22
Joined: Sun Sep 02, 2012 5:05 pm
Country: -

Re: Writing a converter from9XRPro logs to Google Earth

Post by Denis56 »

Ooops, typed too fast. Username is

anonymous

Password is

Summer2015


Fyi, password is case sensitive.
Denis

Post Reply

Return to “Software”