freshJet Posted June 16, 2013 Report Share Posted June 16, 2013 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? Quote Link to comment Share on other sites More sharing options...
Members Vangelis Posted June 17, 2013 Members Report Share Posted June 17, 2013 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 Quote Link to comment Share on other sites More sharing options...
freshJet Posted June 17, 2013 Author Report Share Posted June 17, 2013 Oh, thanks a lot, wasn't aware of that... Quote Link to comment Share on other sites More sharing options...
freshJet Posted June 17, 2013 Author Report Share Posted June 17, 2013 Anyone get the 1052 error? #1062 - Duplicate entry '1' for key 'PRIMARY' Quote Link to comment Share on other sites More sharing options...
ARV187 Posted June 17, 2013 Report Share Posted June 17, 2013 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 Quote Link to comment Share on other sites More sharing options...
AndreNix Posted July 16, 2013 Report Share Posted July 16, 2013 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. Quote Link to comment Share on other sites More sharing options...
Jakubovsky Posted November 12, 2013 Report Share Posted November 12, 2013 Loading airways segments...============ MySQL server has gone away ========== Quote Link to comment Share on other sites More sharing options...
airhaul Posted December 6, 2013 Report Share Posted December 6, 2013 Updated the version so it loads lat/lng without 0's so forth Link to post http://forum.phpvms.net/topic/19993-navdata-update/ Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.