I've completed the first sort of the data for our UK schedules by separating it out airport by airport.  The next step is to sort each airport's data into a format acceptable by our own database.  This will take a while.   Below are the weekly Arrivals and Departures for each airport.  As long as you live you'll never need to fly the same flight twice!  This is before I start on the EJU schedules!  All credit to Andy Smith for doing this job in the past.  It's huge!

EGAA	536
EGBB	96
EGCC	462
EGGD	542
EGGP	180
EGGW	648
EGJJ	80
EGKK	1548
EGNS	60
EGNT	42
EGPD	36
EGPE	60
EGPF	236
EGPH	384
EGSS	106
TOTAL	5016

UPDATE

Making good progress.  All UK schedules now complete except EGKK which is 50% done.  Having a fly today to check out MSFS SU12 to look at something other than spreadsheets! 

I should be able to get them to Mark for uploading by the weekend.

I'm posting this here instead of starting another topic as its the nearest thing to my query,

For the last couple of days when Ive gone to set a flight up with ACARS & choosing the flight from my booked list, It keeps returning schedule not found ? Its not every flight but its frustrating when you arrive & then do the follow on flight to find "Scheduled not found" from my booked flight list in ACARS, albeit Ive booked via assigned flights in the schedules menu.

Cheers

Barry

Have you tried clicking on Refresh in Bluesky underneath DATA/

Also click on "current bids" to see if it's there then highlight it and finally clickn"Flt Bid " at the bottom.

Good Morning Andy,

Yes Ive tried all of what you have said to no avail, Yesterday in the end I was deleting flight then booking another one that it found,.Its doing it again now I can fly EGCC to LKPR but "schedule not found" for return flight to EGGD

Is it in the current bids on Bluesky?

I have just booked both and they are there,but i obviously cannot fly them as i'm already in flight

 

Aha

It's because several different routes are using the Flight number.

I have just changed it, so do a refresh and use EZY473K 

Andy

Yep that works,Thankyou, however EZY43 LIPX to EGGD has the same issues "schedule not found" sorry  In any case Ive got the day/night off so going up the pub for a few pints, I shall continue later,

Again thankyou

Done that one too.

There are several that need looking at.

 

We have had a massive overlap of imports from summer to winter for a couple of years now, from different sources, all combined onto one database. The cleanest solution would probably be to remove older schedules, but we needed a way to capture all flights and insert them into the system, which is why the constraint was removed.

We have also now started adding additional import data so that we can check what to remove going forward.

@ Andy ,thanks for sorting it out, @ Mark all good I were'nt complaing I wondered why this was happening ? I appreiceate all the hard work it involves ruuning this VA.

No its fine mate, we need to get this right and it only improves when problems are flagged up. I can fix them then.