Jump to content

Complete Airports List


APX0475

Recommended Posts

OK, Free hosting can limit limit you, so that's the problem, Free Hostings are not good. Paid ones, you won't have that kind of problems.

Hello, we has hosting at www.dreamhost.com, isn't free

We can't maintain a complete list of airport.

43000 reg in memory?? humm is too much.

phpVMS is wonderfull any way :)

Thanks !!

Link to comment
Share on other sites

  • Moderators

Hey,

I took a look at your hosting, you can have it in your hosting, but not sure.

But the other side, if you are a "world-wide" airlines with every airport, and this is for you. But I would usually add the airports I do really need.

Link to comment
Share on other sites

  • Moderators

Hey,

You go to phpMyAdmin and then go to your phpvms database and on the top, click on import and then elect the zip file that you downloaded and let it run it will take a while

But one thing, it could be restricted by your hosting but it s a wroth a try.

Link to comment
Share on other sites

  • 7 months later...

Any of you sql wizards know if there is a way to make it skip entries that exist already instead of stopping? At most all I can get in is 58 airports. Before trying to run this I had only like 30 in my DB.

I suppose I could drop all my airports and start from scratch since it is a dev site anyhow. I hate to do that though due to schedules I already have that I do fly with for testing purposes.

Try INSERT IGNORE

Link to comment
Share on other sites

Trying to make preferred routes my flight schedules...

Help Please....

Peferred Routes Database

Your best bet would be to log into your site and export the schedules template under "Airline Operations". Then you will see what columns are required from your list. In regards to your preferred routes list you could import that into Excel to help you copy and paste some of the data between that and your schedules template.

Good Luck

Link to comment
Share on other sites

  • 1 month later...
  • 3 months later...
  • 1 month later...
  • 1 month later...
  • 1 year later...

Hi guys,

I'm having major snags with this! I've tried importing this file into PHPMyAdmin, but I get this error:

Error

SQL query:

-- -- Database: `aca` -- -- -- Dumping data for table `phpvms_airports` -- INSERT INTO `phpvms_airports` (`id`, `icao`, `name`, `country`, `lat`, `lng`, `hub`, `fuelprice`, `chartlink`) VALUES (1, '00A', 'Total Rf Heliport', 'US', 40.0708, -74.9336, 0, 0, ''), (2, '00AK', 'Lowell Field', 'US', 59.9492, -151.696, 0, 0, ''), (3, '00AL', 'Epps Airpark', 'US', 34.8648, -86.7703, 0, 0, ''), (4, '00AR', 'Newport Hospital & Clinic Heliport', 'US', 35.6087, -91.2549, 0, 0, ''), (5, '00AZ', 'Cordes Airport', 'US', 34.3056, -112.165, 0, 0, ''), (6, '00CA', 'Goldstone Gts Airport', 'US', 35.3505, -116.888, 0, 0, ''), (7, '00CO', 'Cass Field', 'US', 40.6222, -104.344, 0, 0, ''), (8, '00FA', 'Grass Patch Airport', 'US', 28.6455, -82.219, 0, 0, ''), (9, '00FD', 'Ringhaver Heliport', 'US', 28.8466, -82.3454, 0, 0, ''), (10, '00FL', 'River Oak Airport', 'US', 27.2309, -80.9692, 0, 0, ''), (11, '00GA', 'Lt World Airport', 'US', 33.7675, -84.0683, 0, 0, ''), (12, '00GE', 'Caffrey Heliport', 'US', 33[...]

MySQL said: dot.gif

#1146 - Table 'wdwvacom_wdw.phpvms_airports' doesn't exist

Why doesn't it just overwrite it? I can't for the life of me get it to work

Link to comment
Share on other sites

  • 1 month later...
  • 8 months later...

Hi guys,

I'm having major snags with this! I've tried importing this file into PHPMyAdmin, but I get this error:

Error

SQL query:

-- -- Database: `aca` -- -- -- Dumping data for table `phpvms_airports` -- INSERT INTO `phpvms_airports` (`id`, `icao`, `name`, `country`, `lat`, `lng`, `hub`, `fuelprice`, `chartlink`) VALUES (1, '00A', 'Total Rf Heliport', 'US', 40.0708, -74.9336, 0, 0, ''), (2, '00AK', 'Lowell Field', 'US', 59.9492, -151.696, 0, 0, ''), (3, '00AL', 'Epps Airpark', 'US', 34.8648, -86.7703, 0, 0, ''), (4, '00AR', 'Newport Hospital & Clinic Heliport', 'US', 35.6087, -91.2549, 0, 0, ''), (5, '00AZ', 'Cordes Airport', 'US', 34.3056, -112.165, 0, 0, ''), (6, '00CA', 'Goldstone Gts Airport', 'US', 35.3505, -116.888, 0, 0, ''), (7, '00CO', 'Cass Field', 'US', 40.6222, -104.344, 0, 0, ''), (8, '00FA', 'Grass Patch Airport', 'US', 28.6455, -82.219, 0, 0, ''), (9, '00FD', 'Ringhaver Heliport', 'US', 28.8466, -82.3454, 0, 0, ''), (10, '00FL', 'River Oak Airport', 'US', 27.2309, -80.9692, 0, 0, ''), (11, '00GA', 'Lt World Airport', 'US', 33.7675, -84.0683, 0, 0, ''), (12, '00GE', 'Caffrey Heliport', 'US', 33[...]

MySQL said: dot.gif

#1146 - Table 'wdwvacom_wdw.phpvms_airports' doesn't exist

Why doesn't it just overwrite it? I can't for the life of me get it to work

Hi guys,

I'm having major snags with this! I've tried importing this file into PHPMyAdmin, but I get this error:

Error

SQL query:

-- -- Database: `aca` -- -- -- Dumping data for table `phpvms_airports` -- INSERT INTO `phpvms_airports` (`id`, `icao`, `name`, `country`, `lat`, `lng`, `hub`, `fuelprice`, `chartlink`) VALUES (1, '00A', 'Total Rf Heliport', 'US', 40.0708, -74.9336, 0, 0, ''), (2, '00AK', 'Lowell Field', 'US', 59.9492, -151.696, 0, 0, ''), (3, '00AL', 'Epps Airpark', 'US', 34.8648, -86.7703, 0, 0, ''), (4, '00AR', 'Newport Hospital & Clinic Heliport', 'US', 35.6087, -91.2549, 0, 0, ''), (5, '00AZ', 'Cordes Airport', 'US', 34.3056, -112.165, 0, 0, ''), (6, '00CA', 'Goldstone Gts Airport', 'US', 35.3505, -116.888, 0, 0, ''), (7, '00CO', 'Cass Field', 'US', 40.6222, -104.344, 0, 0, ''), (8, '00FA', 'Grass Patch Airport', 'US', 28.6455, -82.219, 0, 0, ''), (9, '00FD', 'Ringhaver Heliport', 'US', 28.8466, -82.3454, 0, 0, ''), (10, '00FL', 'River Oak Airport', 'US', 27.2309, -80.9692, 0, 0, ''), (11, '00GA', 'Lt World Airport', 'US', 33.7675, -84.0683, 0, 0, ''), (12, '00GE', 'Caffrey Heliport', 'US', 33[...]

MySQL said: dot.gif

#1146 - Table 'wdwvacom_wdw.phpvms_airports' doesn't exist

Why doesn't it just overwrite it? I can't for the life of me get it to work

I'm with the same problem.... Someone know what to do?

Link to comment
Share on other sites

  • Administrators
Why doesn't it just overwrite it? I can't for the life of me get it to work

There is nothing to overwrite......

#1146 - Table 'wdwvacom_wdw.phpvms_airports' doesn't exist

The table does not exist (phpvms_airports) or you have a different prefix than phpvms_

If you deleted the table prior to trying to insert the new data then you will have to replace the table prior to the data insert. If your table already has data just empty the table (Truncate)

If you are using a different prefix you will either have to temporarily change the prefix or change all instances of the prefix in the data file.

  • Like 1
Link to comment
Share on other sites

There is nothing to overwrite......

#1146 - Table 'wdwvacom_wdw.phpvms_airports' doesn't exist

The table does not exist (phpvms_airports) or you have a different prefix than phpvms_

If you deleted the table prior to trying to insert the new data then you will have to replace the table prior to the data insert. If your table already has data just empty the table (Truncate)

If you are using a different prefix you will either have to temporarily change the prefix or change all instances of the prefix in the data file.

"If you are using a different prefix you will either have to temporarily change the prefix or change all instances of the prefix in the data file."

What i was made. I opened the file and changed all the "phpvms_airports" to my table name, in this case, to "phpvms_globairports" and worked fine.

THanks for it sim, really nice!!

Thanks again!

Hudson

PS: Sorry my english errors

Link to comment
Share on other sites

  • 3 months later...
  • 4 months later...
  • 3 months later...
  • 1 month later...
  • 2 months later...

Here is the data dump for my airports table for a charter system I have built if it will help. It has 41533 airfields, helipads, water strips, and private airfields in it, I think there are still some that I do not have in it but its a start. It is a big file so you may have to split it up to import it into your table, if you are on free hosting I would not even try.

Thanks i download this but can you tell me where do i have to add this file? Sorry i am new. Thanks

Link to comment
Share on other sites

  • 3 months later...
  • 3 weeks later...
  • 3 months later...
  • 9 months later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...