Question About NavData

[freshJet]

Recently released my OFPs to pilots and was aware of the issues with the NavData regarding their accuracy. My plan (or only option) is to manually update all the relevant data, i.e all the data that applies to my routes and surrounding waypoints/navaids.

My question is which AIRAC was it built upon?

[Vangelis]

Jefrey has a version uploaded on his site that it was created at

2013-01-05 20:40:16 but i do not know witch version it is

http://www.fs-products.net/index.php/downloads/viewdownload/6-phpvms-modules/24-navdata-phpvms

[freshJet]

Oh, thanks a lot, wasn't aware of that...

[freshJet]

Anyone get the 1052 error?

#1062 - Duplicate entry '1' for key 'PRIMARY'

[ARV187]

To me work well, some vor or dme wrongs, but work. Try to created a new blank table with same name (phpvms_navdata) and import the navdata.sql

[AndreNix]

This is an alternative update for phpvms_navdata.

I decided to update my table but I had no patience to make manually.

In addition to complicated and exhaustive update manually, I decided to use the AIRAC

How to?

Simple!

I used FSBUILD_1307.exe, extracted and renamed the files.

I don't have fsbuild installed on my pc, just grabbed the file for FSUILD and extract in a single folder.

Note:

To unzip and install the AIRAC effective, I created fsbuild.exe in Notepad.

I selected the folder on the supposed fsbuild.exe and extract the files

Which files?

FSBUILD_1307.exe ORIGINAL RENAMED

** ints.txt <-----> INTERSECTIONS.txt

** awys.txt <-----> AIRWAYS.txt

** navs.txt <-----> NDB-VOR.txt

I used the phpvms_navdata from Nabeel Shahzad (Thank´s Nabeel) and I analyzed the fsbuildparse.php!

GitHub - https://github.com/nshahzad/phpvms_navdata

https://github.com/nshahzad/phpvms_navdata/blob/master/fsbuildparse.php

Airways = Line 82 ----> $handle = fopen('fsbuild/fsb_awy2.txt', 'r'); --- awys.txt

VORs = Line 159 ---> $handle = fopen("fsbuild/fsb_vor.txt", "r"); --- navs.txt

NDBs = Line 235 ---> $handle = fopen('fsbuild/fsb_ndb.txt', 'r'); --- navs.txt again

INTs = Line 312 ---> $handle = fopen('fsbuild/fsb_int.txt', 'r'); --- ints.txt

Simple, no?

I changed the file fsbuildparse.php for my personal use.

How do I update my table (index)?

How to use?

modify the db.php file for your data (mysqlserver, user, password and database) and run the following command:

php-f update.php

this works!!!

[root@localhost nupdate]# php -f update.php

Loading airways segments...181408 airway segments loaded...

Loading VORs...3415 VORs added, 3500 updated

Loading NDBs...0 NDBs added, 5839 updated

Loading INTs...

Perhaps not a great alternative, but it's a great start!!

Change, create, deploy and distribute.

[Jakubovsky]

Loading airways segments...============ MySQL server has gone away ==========

[airhaul]

Updated the version so it loads lat/lng without 0's so forth

Link to post

http://forum.phpvms.net/topic/19993-navdata-update/