Hop List Generator

[Robert]

I don't know if this gonna break all the fun of making Hop Lists.
Take a look at it and see if it's something that you like. I have plans getting runway length searchable so you don't have to worry about getting your heavy down on some tiny grass strip or such.

Anyway, here it is: http://www.basisten.se/e107_pages/hoplists/

[Russell Gilbert]

Hey Robert,

Very nice tool!

I guess you got your airport database from Traffic Toolbox, or did you figure out another way?

Would you like me to add a link to your page from the FSHost Add-ons page?

Thanks,
Russell

[Robert]

Hi Russell   
You're right, I used Traffic Toolbox to gather the airports but didn't find any airport names in there (maybe I have done something wrong here).
Instead I crawled the internet and found a file (fsxge.kml) and played a lot with it. Finally, I ended up with only having 294 airports without name.

With some experimenting in PHP and MySQL it turns out that it can be used for anyone who wants to generate their own hop lists.
I have plans to give the user the ability to select other languages for their generated hop lists.

Besides the missing names there is a 'heading bug' in my script that causes a 'NAN' instead of proper heading between some airports. I will look into that soon.
And yes, you are more than welcome to add a link to the generator in your FSHost Add-on page. That would be really great! 

Edit: Just added a nice Google Map for visual reference when making your Hop Lists   

[wheelie]

Hi Robert,

After our exchange of PMs I have sent you a file that shows the ICAO equivalent codes for FS9 to FSX. It also shows which ICAO codes in FS9 are not present in FSX.

It does not list all of the FS9 ICAO codes or all of the FSX ICAO codes - just the equivalents but because I always develop hop lists using FS9 I didn't bother to figure out which ICAO codes in FSX do not have an equivalent in FS9.

If you have any questions just ask me :-)

[Robert]

Hey, Wheelie!
I got your file and you know what? Your table did the trick!  Ha ha..
Take a look and see if i got it right.

The annoying "heading bug" and the remaining airport names will be taken care of later.
Now I'm off for vacation.
See you later.

[wheelie]

Hi Robert,

Hope you've had a good holiday 

I had another look at your tool - it's getting much better  I tried it with the sequence of hops that alerted me to the incompatibility of ICAO codes between FS9 and FSX (I generate hop lists in FS9 and then check they work in FSX - normally if an FS9 code isn't in FSX then I just change the destination to somewhere else in the vicinity where the ICAO code is common between FS9 and FSX). However, for FWLI in FS9 there are no other airports for hundreds of miles around that share the same code 

So, the sequence is: FVHA, FLLS, FWLI, FMMI (these are three hops that are part of my "World Tour").

Your generator produced:

FVHA = Click "Create a Flight" (or use the World menu) to start at FVHA, [Harare International - Zimbabwe], located at 4902ft [1494m] (Runway: HARD) then type "?hop" for first hop instructions.
FLLS = Fly heading 315 for 218nm and land at FLLS, [Lusaka International - Zambia], located at 3780ft [1152m] (Runway: HARD), then type "?hop".
FWLI = Fly heading 74 for 323nm and land at FWLI, [ - ], located at 4035ft [1230m] (Runway: HARD), then type "?hop". NOTE: FSX pilots fly to FWKI and then type "?hop".
FMMI = Fly heading 112 for 844nm and land at FMMI, [Antananarivo Ivato International - Madagascar], located at 4199ft [1280m] (Runway: HARD), then type "?hop".

which is pretty good.

In fact, it seems that I made a mistake in my hop list instructions for the FSX part of FLLS to FWLI - I should have used FWKI I will go and correct that now.

[wheelie]

Text deleted - cos what I wrote was wrong. Is there any way of deleting this entry?

[Robert]

Hello everyone!
Finally I managed to update this tool and I believe the 'NaN' (not a number) error is gone ... and putting too much airport information into the hop instructions was a really bad idea - I took it away and left only the most basic data.   I am however still not sure about the accuracy for the distance and heading generated by this script. Maybe some of you out there can help me on that matter.

New URL to the hoplist creator: http://www.basisten.se/e107_pages/hoplist_creator/index.php
Thanks
/Robert

[Packo88]

I really love this Hoplist Generator and i use it every month for the FigAir Monthly Hoplists.

I have noticed that you have made some changes to the page and they look real nice. I like the ability to download as a FHL file that you have added too.
Just one thing that I have noticed is that now we dont get the detail of the runway surface at the destination airport. Will this be added back in in the future?

Keep up the good work

Thanks

[Robert]

Thanks for the compliments.
Please do not hesitate to come up with more suggestions about this tool ... I love to hear it.

The runway information is available so why not let the user to choose whether they want it or not?
I added two check boxes (runway surface and country), and I will probably add more options later this year after the summer holidays.
Give it a try and see if you like it!

I'll be back in a month
Have a good summer

[Robert]

 ...just added total distance, total number of hops and airport altitude ...

[sattawut]

Thanks for the compliments.
Please do not hesitate to come up with more suggestions about this tool ... I love to hear it.