Jump to content
airhaul

Navdata Update

Recommended Posts

airhaul    2

Cleaned up the code in fsbuildparse.php so it works better

This is an updated version of Nabeel's code for navdata update which is avaliable by search in forums

-All intersections uploaded with a lat/lng

-All VOR / NDB correctly labeled

-Intersections all go in instead of hanging up

Works with fsbuild airac

Used 1310 myself

Loading airways segments...91220 airway segments loaded...

Loading VORs...965 VORs added, 2834 updated

Loading NDBs...2202 NDBs added, 1800 updated

Loading INTs...93944 INTs added, 54743 bypassed already in DB

Completed!

-Would recommend backing up navdata table in database before running

-Program deletes all previous data in phpvms_navdata table before updating

-Also program will not work if the table phpvms_navdata is not present. If it isnt go to DBadmin and copy structure only from navdata table to phpvms_navdata

-Inserts into phpvms_navdata table. If prefix is different rename phpvms_navdata to navdata for example when complete

-Use at your own risk. Works great with me but can't say it will with everyone.

How to load NAVDATA for phpVMS

-------------

1. Unzip navdata.zip

2. Obtain fsbuild airac

3. Install fsbuild airac into same folder as fsbuild.exe(airac file)

4. need to have three files

awys.txt -airways (default fsbuild)

ints.txt - intersections (default fsbuild)

navs.txt - ndb/vor (default fsbuild - code fixed to label vor/ndb separately)

5. Take the 3 files listed above insert them into navdata/fsbuild folder

Optional - Recommend sorting out lat/lng intersections in ints.txt and any intersection that is not 5 characters in length

6. Open db.php file and insert your DB username, password, & server name into the appropraiate places between ''

7. Upload navdata folder into root directory of site

8. Connect to server with ssh app. I use putty

9. cd to navdata

10. run php -f fsbuildparse.php at prompt

11. Takes maybe 5 mins or so then should get

Loading airways segments...91220 airway segments loaded...

Loading VORs...965 VORs added, 2834 updated

Loading NDBs...2202 NDBs added, 1800 updated

Loading INTs...93944 INTs added, 54743 bypassed already in DB

Completed!

navdata.zip

  • Like 1

Share this post


Link to post
Share on other sites
airhaul    2

Sorry only have used putty.

Could set it up to run in admin or load page from browser but it wipes out the table navdata everytime you run it

Problem is you want to run once then delete the files and folders

Putty pretty easy to use for me

Select ssh put in web address then click connect

At prompt type in login and password

Then >cd public_html/navdata

Then >php -f fsbuildparse.php

Contact your Hosting company, they might have to enable SSH for putty to work

Share this post


Link to post
Share on other sites
ARV187    41
<?php

error_reporting(E_ALL & ~E_NOTICE);

$db = mysql_connect('localhost', 'db username goes here', 'db password goes here');

mysql_select_db('db server name goes here');

define('NAV_NDB', 2);

define('NAV_VOR', 3);

define('NAV_DME', 4);

define('NAV_FIX', 5);

Only db server name? not db name?

Not work to me, in putty I enter the webpage of VA or name server... but i get error network no work time out.

I find this option:

post-5667-0-16501200-1386416559_thumb.jpg

Share this post


Link to post
Share on other sites
airhaul    2

This process is not the easiest but I have listed all the steps.

Try customer service at your Hosting company for SSH problems

open local.config.php in core folder, then copy the DB info name, password, server name into db.php

$db = mysql_connect('localhost', 'joetest', 'password')

mysql_select_db('aerodb');

Mine is localhost and is for most people but change it if different in local.config.php

Share this post


Link to post
Share on other sites
Sava    800

Is someone willing to export the phpvms_navdata they have in their DB so not all of us have to go through the process/

  • Like 3

Share this post


Link to post
Share on other sites
ARV187    41

Is someone willing to export the phpvms_navdata they have in their DB so not all of us have to go through the process/

Good post!!

Share this post


Link to post
Share on other sites
Angel Air    60

It looks like fivedev does not support SSH I have tried to connect to the server using putty but it can not connect so if anyone has managed this would the mind uploading the .SQL file for navdata so we have all got a working copy.

Please and thankyou

Share this post


Link to post
Share on other sites
FSX30HD    8

Optional - Recommend sorting out lat/lng intersections in ints.txt and any intersection that is not 5 characters in length

Howto make that ? Please

Regards Fred

Share this post


Link to post
Share on other sites
ARV187    41

Ok, navigraph, but Navdata table is confidential? if i search all routes in routefinder or public civil aviation authorities, not is the same? (with more work obvious).

Is a eternal cuestion, public info packed by a private enterprise, is ethical? or is ethical take public info from enterprise without pay?, are complicate cuestions.

Edited by ARV187

Share this post


Link to post
Share on other sites
FSX30HD    8

Is a eternal cuestion, public info packed by a private enterprise, is ethical? or is ethical take public info from enterprise without pay?, are complicate cuestions.

I'm agree with you in this point. In my case a pay Navigraph to "work" with free datas and make them in Setup... But look at jeff's website http://www.fs-products.net/index.php/downloads/viewcategory/6-phpvms-modules

Share this post


Link to post
Share on other sites
ARV187    41

Hi again,

I have Jeff's navdata, but i have much errors:

post-5667-0-93373200-1399797550_thumb.jpg

Here is public information about navdata, so this information share in .csv or .sql format not is illegal!!!

I think that pay to navigraft is because setups to diferents devices & sims, not by data wich is public.

http://www.icao.int/...3freqlist02.pdf

Share this post


Link to post
Share on other sites
Sava    800

Might be easier for you to post it here so if down the line someone needs it, he can find it here :)

  • Like 1

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


×