Export To Spreadsheet

[PolarMonkey]

I'm not sure if this is in your plans already, but would it be possible to be able to export some of the pages to excel type spreadsheet. The main ones I can think of at the moment would be the financial ledger and flight history, possibly the fleet overview, route management and gate management as well.

[Unknown98]

Potentially... I hadn't really thought of it. I'll have to look into how that works and see what it would take to make that happen.

[sw889432]

Easiest will probably just dumping the table data to CSV. I already do this to calculate weekly maintenance costs of my fleet, with a few JS user scripts and some JQuery.

[PolarMonkey]

I just had another thought tonight about this. Would it be possible to export/import the route information through a csv/xls or some other kind of file. With having to redo the routes the last couple times, it has taken me probably over an hour to remake my 55 or so routes. I'm sure there are others with larger airlines that have even more to recreate as well, and this would be a big help.

[Unknown98]

Well the issue, and the reason routes had to be deleted, was that the table structure changed inside the database, so the old data can't be imported back in because the structures won't match and some required data will be missing.

As far as exporting things to a CSV or excel spreadsheet I'm sure it's possible, once I get the route system ironed out maybe I can look into this.

[PolarMonkey]

That makes sense to me. If we were able to import the routes from a file, if we knew how the information had to be rearranged, we could always do that manually if the structure of the database changed again. I was thinking further down the line as airlines expand, since this is a beta, there's always a chance of routes having to get deleted again in the future.

Another thought occurred to me. Would there be any way that someone could cause issues by importing a file for the routes and somehow damage the database? If so, I wouldn't feel bad if you didn't follow through with this one.

[Unknown98]

I don't have an issue allowing people to export things from the database, but I don't think I want to allow importing of data back into it. I feel like there's too much potential there for something to go wrong.

[airlinemanage]

I before post something in the forum about exporting routes to excel in this link: https://www.airlineenterprise.com/forums...hp?tid=489. It may be useful to you, but maybe you also need to make some changes as that post was made before unk redevelop the route management system.