Fleet SQL Creator

phpVMS Legacy Add-Ons (v2/v5) Development Help
1

This was my half term (+ like a week  :slight_smile: project.

Basically, you add your aircraft, select a type and enter a callsign, enter the table name of your aircraft table (by default phpvms_aircraft - this is only if you changed the prefix) and click create

It then creates you a .sql file with all the rest of the information (full name, icao, empty weight [lbs], cruise speech [mach] etc) for you to import straight into your database.

It’s only really a one time use thing, unless you want to add bulk aircraft, or just cant be bothered to enter the information yourself, but I learnt making it so

Have a go:

http://www.europeangateway.info/fleetsql/

Please let me know if you have any problems.

P.S. Yes I know there’s only airbus and boeing aircraft - I’m working on it

2

Looks great Tom,

I’m sure some will use it.

Thanks

Adam

3

Excellent, Tom! Small projects like this are great to learn. I like the use of jQuery.

Will that be the permanent URL to it? I can add it to the downloads page

4

Yes I’ll be leaving it there for the foreseeable future

And thanks

5

I swung by there and checked that out. I like it. Great job!

6

Sorry for bringing back such an old thread, but I was wondering: if I were to work on an extensive database of aircraft for this and refine the interface and code a little, would people be interested in using it?

I’ll quickly go over how it works again:

You select the aircraft in your airlines fleet, and add the callsign for each.

The script takes all the relevant information (PAX No., Empty weight, Speed, Cargo weight etc) from the database and produces a .sql file for you to import to your database, instantly adding all your aircraft with correct information - saving you going through and making each aircraft individually.

Contrary to what I wrote originally, I believe it would also work for additions to the fleet, so if you’ve opened a new division with a whole load of new aircraft you can add them all to the existing entries.

So, would my summer be well spent improving this?

7

Tom, perhaps you can create the import CSV file now, since I’ve added an import/export in the admin panel for aircraft

8

Tom, perhaps you can create the import CSV file now, since I’ve added an import/export in the admin panel for aircraft

Is there? Is it in version 934?

I can’t find it.. just for schedules.

But yeah that makes my life a lot easier!

9

is there a way to still download this, thanks

10

Ah I took this down ages ago, was a bit buggy. If I still have the code I can put it back up somewhere if you want?

11

Please

Thankyou

12

I know this is an old thread, but is there a way I can get the coding? I would love something like this

13

On 9/20/2014 at 8:44 AM, longhorns19 said:

I know this is an old thread, but is there a way I can get the coding? I would love something like this

likewise, i have a huge amount of aircraft to import and i cant sit here for hours doing it manually (or copy paste in phpmyadmin and change registrations)