Delta Virtual Airlines
Water Cooler

  • Water Cooler
    • All Posts
    • Channels
    • Search
  • Our Airline
    • Home
    • Login
    • Logged In Users
    • Our Partners
    • Issue Tracker
  • Pilot's Lounge
    • Online Events
    • Flight Tours
  • ACARS
    • Live ACARS Map
    • Google Earth
    • ACARS Flights
    • Dispatch Schedule
    • Top Dispatchers
  • Statistics
    • Airline Totals
    • Flight Statistics
    • Online Statistics
    • Simulator Versions
    • Passenger Statistics
    • Landing Statistics
    • Optimal Landings
    • Server Statistics
  • Contact Us
    • Corporate Offices
    • Our Staff
    • Password Reset
    • Privacy Policy
    • Career Opportunities
Delta Virtual Airlines Water Cooler | Airline Operations | Importing schedule data
DVA3220
Captain, B737-800
OLP

Joined on May 19 2006
DVA Five-Year Anniversary
B737 50 Club

Southeastern United States

78 legs, 129.9 hours
73 legs, 122.3 hours online
76 legs, 127.3 hours ACARS
31 legs, 57.3 hours event
Posted onPost created on October 14 2019 23:31 ET by Tyler Devereaux
I know there's been a few threads about this, and the last official response I remember seeing was that someone elsewhere spiked the price of where DVA used to get its schedule data, resulting in a cessation of automatic updates. I'm certainly not trying to be pushy, but rather just wondering if there's another way to freely get a new stream of data flowing. I was digging around online and found that Delta publishes a rather enormous PDF file with their worldwide schedule. I was able to access it on the public side of their webpage (without needing to log in or anything) after some digging around, so (I'm no expert in this subject) it seems like... public document => free use? The time range, as of this writing, is 01OCT19-15NOV19 -- fairly short, so (having no evidence to the contrary) my assumption is that this publication gets updated periodically.

I've included a screenshot of one of the pages. Putting my old IT hat on and skimming through the publication, it's already very well formatted in tabular form: it seems like it wouldn't be crazy difficult to parse. I certainly can't promise anything-- my workload is unfortunately starting to overflow my desk lately --but, if I (or another volunteer) could develop something to parse this file... how much of an undertaking would it be to get it consumed and enable (semi-)automatic schedule updates again? Comparing the data I'm looking at against a quick Flight Schedule Search in the DVA system for matching airport pairs (I understand there's probably a lot more data stored behind the scenes), it seems like the data in this PDF has everything that is displayed on our route search. It may take a little bit of craftiness to develop an index key scheme and, depending on the current database schema, perhaps some additional post-processing to pre-process the leg/trip information if that isn't already handled by a grouping query. But, this seems very doable.

Please forgive me if I'm getting a little excited over nothing. I'm sure other people have seen the same data I'm looking at. Could this be a solution to our schedule data problem, or is there more to it that further complicates the matter?
DVA12617
Chief Pilot, A350-900
OLP, VFRADV
DISPATCHER
E-MAIL

Joined on April 23 2015
B757 100 Club
Eurocap Club
Millennium Club
Toulouse 500 Club
DVA Ten-Year Anniversary
Online Quadruple Century Club

"Go Utes!"
Herriman, UT

1,322 legs, 3,057.1 hours
432 legs, 896.0 hours online
1,303 legs, 3,014.9 hours ACARS
25 legs, 78.6 hours event
39 legs dispatched, 174.2 hours
Posted onPost created on October 15 2019 01:28 ET by Joe Burner
Tyler,

So great job and great find on this. The only problem I see is going through the entire document or documents. The problem is that there are a lot of world wide airports that Delta Airlines flies to on a daily basis. Reading through the document could take great deal of time to read through and then decipher how to implement it into our schedule and then update that frequently as if this document is even updated.

I think you have a great idea and I don’t want to bash on your idea, it’s just I am not sure if it would be feasible to sort through this for every airport Delta serves. This would take a lot of time sort through. Unless we have an algorithm or something that can sort it automatically?

I think it is a great idea though. I didn’t even know documents such as this existed and better yet public knowledge. So great find.

I’d love to see our schedule get updated regularly as before but I’m not sure how we can do that?




DVA3220
Captain, B737-800
OLP

Joined on May 19 2006
DVA Five-Year Anniversary
B737 50 Club

Southeastern United States

78 legs, 129.9 hours
73 legs, 122.3 hours online
76 legs, 127.3 hours ACARS
31 legs, 57.3 hours event
Posted onPost created on October 15 2019 14:24 ET by Tyler Devereaux
Joe:

Sorry, I should have explained better. By no means do I expect anyone to manually read through this: the PDF is over 1000 pages! If someone tried to do this manually, I think it'd probably take just about enough time to allow my yet-unborn grandkids to retire. When I said "parse" I meant write a script/program/webpage/etc to read and interpret the file much faster than a human could. The idea was that a script could read the file when a new one is produced, extract all of the useful information from the PDF and transfer it into DVA's schedule database
DVA5385
Captain, A330-300

Joined on September 13 2007
Two Million Mile Club
DVA Ten-Year Anniversary
Everett 500 Club
Eight Century Club

North Yorkshire GB

857 legs, 5,275.1 hours
1 legs, 0.8 hours online
843 legs, 5,256.0 hours ACARS
Posted onPost created on October 16 2019 07:25 ET by Will Prince
I like this idea! i just want to throw in that these guys >>> https://www.alpha-india.net/forums/ post regular flight plans for delta AI traffic, maybe we can speak to them?


DVA13558
Captain, B727-200

Joined on November 06 2018
Everett Century Club
DVA Five-Year Anniversary
Triple Century Club
Online Triple Century Club

Western Europe

350 legs, 823.2 hours
336 legs, 778.1 hours online
349 legs, 820.9 hours ACARS
1 legs, 1.9 hours event
Posted onPost created on October 16 2019 10:52 ET by Lorenzo Nesta
The schedules are unfortunatley well out of date. It would be nice to see them updated.

Cheers
Lonz

Lorenzo Nesta

Captain, B727-200
DVA9545
Senior Captain, B777-200
OLP, 737-ATP

Joined on March 03 2011
50 State Club
Globetrotter
US Coastal Club
US Mountaineer Club
Million Mile Club
Events Double Century Club
DVA Ten-Year Anniversary
Toulouse 500 Club
Bi-Millennium Club
Online Twenty Century
DVA Fleet Master

"YUPIIIII"
Goiás Brazil

2,578 legs, 5,183.9 hours
2,405 legs, 4,903.2 hours online
2,570 legs, 5,154.3 hours ACARS
271 legs, 683.8 hours event
Posted onPost created on October 16 2019 11:10 ET by Thiago Braga
I have to agree. There are many outdated flught and also changes in A/Cs. Any chance for updates?


DVA2527
Senior Captain, B737-800

Joined on August 15 2005
50 State Club
Two Million Mile Club
Online Thirty Century
Everett Tri-Millennium Club
DVA Twenty-Year Anniversary
Five Millennium Club

"Flying Delta's Western Hub"
Salt Lake City, UT USA

5,010 legs, 9,704.7 hours
3,748 legs, 7,363.4 hours online
4,427 legs, 8,531.3 hours ACARS
22 legs, 49.5 hours event
Posted onPost created on October 22 2019 18:06 ET by Joe Porter
Is there any possibility to work with flight aware? Their flights and AC are quiet TW current . . .

JP

Joe Porter

Senior Captain, B737-800
DVA043
Senior Captain, MD-11
OLP

Joined on June 10 2001
Event Half Century Club
Online Double Century Club
50 State Club
DVA Twenty-Year Anniversary
Everett 1500 Club
Bi-Millennium Club
Four Million Mile Club

"Col. Panic"
Marietta, GA

2,347 legs, 9,466.0 hours
240 legs, 553.9 hours online
2,005 legs, 8,259.1 hours ACARS
75 legs, 196.3 hours event
2,383 legs, 9,600.9 hours total
91 legs dispatched, 66.4 hours
Posted onPost created on October 23 2019 15:32 ET by Luke Kolin
Sorry I've missed this - if you have a repeatable way of extracting the data into some sort of structured form, we can definitely go from there.

Cheers!

Luke Kolin

Senior Captain, MD-11
DVA10323
Chief Pilot, B727-200
OLP

Joined on November 26 2011
50 State Club
Globetrotter
Tin Dispatcher
Tri-Jet Triumph
US Capital Club
Online Seven Century Club
US Mountaineer Club
DVA Ten-Year Anniversary
Flying Colonel
Everett Millennium Club

"GPS, we don't need no GPS"
Gulfport, MS

1,591 legs, 1,457.9 hours
742 legs, 686.0 hours online
1,583 legs, 1,450.4 hours ACARS
41 legs, 58.7 hours event
327 legs dispatched, 343.5 hours
Posted onPost created on October 24 2019 17:07 ET by Kevin Lundy
Good find Tyler! I like the way you are thinking. I found the schedule on the Delta site and downloaded all 1,046 pages of it. Very extensive schedule. I tried converting the schedule using Adobe Professional and it kept crashing. I split the schedule into 105 sections and tried to convert a section to a CVS file formated in a way we use to import the schedule. It did convert the smaller section but it was not in a usable format. It made 44 columns of data, we only use 11 columns. The data is not consistently placed in columns throughout the schedule either. It would be too labor-intensive to clean up the data. I will dig a little deeper into this concept.


Kevin Lundy

Chief Pilot, B727-200
DVA12617
Chief Pilot, A350-900
OLP, VFRADV
DISPATCHER
E-MAIL

Joined on April 23 2015
B757 100 Club
Eurocap Club
Millennium Club
Toulouse 500 Club
DVA Ten-Year Anniversary
Online Quadruple Century Club

"Go Utes!"
Herriman, UT

1,322 legs, 3,057.1 hours
432 legs, 896.0 hours online
1,303 legs, 3,014.9 hours ACARS
25 legs, 78.6 hours event
39 legs dispatched, 174.2 hours
Posted onPost created on October 24 2019 17:17 ET by Joe Burner
Kevin,

I’m willing to lend a hand with this project as well if you’d like. wink

Joe



DVA3220
Captain, B737-800
OLP

Joined on May 19 2006
DVA Five-Year Anniversary
B737 50 Club

Southeastern United States

78 legs, 129.9 hours
73 legs, 122.3 hours online
76 legs, 127.3 hours ACARS
31 legs, 57.3 hours event
Posted onPost created on October 24 2019 19:38 ET by Tyler Devereaux
I'll keep working on this. I'll see what I can come up with.
DVA12617
Chief Pilot, A350-900
OLP, VFRADV
DISPATCHER
E-MAIL

Joined on April 23 2015
B757 100 Club
Eurocap Club
Millennium Club
Toulouse 500 Club
DVA Ten-Year Anniversary
Online Quadruple Century Club

"Go Utes!"
Herriman, UT

1,322 legs, 3,057.1 hours
432 legs, 896.0 hours online
1,303 legs, 3,014.9 hours ACARS
25 legs, 78.6 hours event
39 legs dispatched, 174.2 hours
Posted onPost created on October 24 2019 19:51 ET by Joe Burner
Tyler,

Where did you find the schedule? I tried googling it and I couldn’t find it.

Thanks

Joe



DVA3220
Captain, B737-800
OLP

Joined on May 19 2006
DVA Five-Year Anniversary
B737 50 Club

Southeastern United States

78 legs, 129.9 hours
73 legs, 122.3 hours online
76 legs, 127.3 hours ACARS
31 legs, 57.3 hours event
Posted onPost created on October 24 2019 20:52 ET by Tyler Devereaux
It's called Delta Worldwide Timeline. It's on the Delta website. I'll have to dig out the link when I get to a computer.
DVA12617
Chief Pilot, A350-900
OLP, VFRADV
DISPATCHER
E-MAIL

Joined on April 23 2015
B757 100 Club
Eurocap Club
Millennium Club
Toulouse 500 Club
DVA Ten-Year Anniversary
Online Quadruple Century Club

"Go Utes!"
Herriman, UT

1,322 legs, 3,057.1 hours
432 legs, 896.0 hours online
1,303 legs, 3,014.9 hours ACARS
25 legs, 78.6 hours event
39 legs dispatched, 174.2 hours
Posted onPost created on October 24 2019 21:10 ET by Joe Burner
Tyler,

Thank you I’ll have to search for it.



DVA2496
Senior Captain, B757-200
OLP

Joined on July 13 2005
B757 100 Club
50 State Club
Iron Dispatcher
Black Pearl Club
Everett Millennium Club
Globetrotter
Flying Colonel
Online Fifteen Century
Two Million Mile Club
Event Half Century Club
DVA Twenty-Year Anniversary

"Delta Connect - Antigua to world"
Cassada Gardens, Saint John Antigua and Barbuda

1,948 legs, 6,269.0 hours
1,852 legs, 6,008.0 hours online
1,807 legs, 5,852.1 hours ACARS
76 legs, 159.2 hours event
641 legs dispatched, 253.3 hours
Posted onPost created on October 24 2019 21:14 ET by Perez Howson
Here is the link guys..

https://www.delta.com/content/dam/delta-www/pdfs/flight_schedules.pdf

Regards,



DVA12617
Chief Pilot, A350-900
OLP, VFRADV
DISPATCHER
E-MAIL

Joined on April 23 2015
B757 100 Club
Eurocap Club
Millennium Club
Toulouse 500 Club
DVA Ten-Year Anniversary
Online Quadruple Century Club

"Go Utes!"
Herriman, UT

1,322 legs, 3,057.1 hours
432 legs, 896.0 hours online
1,303 legs, 3,014.9 hours ACARS
25 legs, 78.6 hours event
39 legs dispatched, 174.2 hours
Posted onPost created on October 24 2019 22:01 ET by Joe Burner
So I was able to find the schedule now. wink Thank you Perez. I downloaded all 1,046 pages as well. One thing I realized is this is until November 15 2019




DVA3220
Captain, B737-800
OLP

Joined on May 19 2006
DVA Five-Year Anniversary
B737 50 Club

Southeastern United States

78 legs, 129.9 hours
73 legs, 122.3 hours online
76 legs, 127.3 hours ACARS
31 legs, 57.3 hours event
Posted onPost created on October 25 2019 09:46 ET by Tyler Devereaux
Yes. Per my original post, I was hoping that the short validity period meant more frequent updates... which, for our purposes, would be a good thing.
DVA12617
Chief Pilot, A350-900
OLP, VFRADV
DISPATCHER
E-MAIL

Joined on April 23 2015
B757 100 Club
Eurocap Club
Millennium Club
Toulouse 500 Club
DVA Ten-Year Anniversary
Online Quadruple Century Club

"Go Utes!"
Herriman, UT

1,322 legs, 3,057.1 hours
432 legs, 896.0 hours online
1,303 legs, 3,014.9 hours ACARS
25 legs, 78.6 hours event
39 legs dispatched, 174.2 hours
Posted onPost created on October 25 2019 10:24 ET by Joe Burner
Tyler,

I think it is a good thing. wink It’s a lot of good data. Even if we can use what you found would be good. smile



DVA2496
Senior Captain, B757-200
OLP

Joined on July 13 2005
B757 100 Club
50 State Club
Iron Dispatcher
Black Pearl Club
Everett Millennium Club
Globetrotter
Flying Colonel
Online Fifteen Century
Two Million Mile Club
Event Half Century Club
DVA Twenty-Year Anniversary

"Delta Connect - Antigua to world"
Cassada Gardens, Saint John Antigua and Barbuda

1,948 legs, 6,269.0 hours
1,852 legs, 6,008.0 hours online
1,807 legs, 5,852.1 hours ACARS
76 legs, 159.2 hours event
641 legs dispatched, 253.3 hours
Posted onPost created on October 25 2019 11:52 ET by Perez Howson
You're welcome Joe.... and I don't mind assisting as well, you know.

The question then becomes, what's the data to pull out from the .CSV file?

I see Kevin has an excel file there..having worked for another airline before I am somewhat familiar.... however, it would suspect it's going to be based on whatever system DVA is using for compilation.

Regards,



DVA2527
Senior Captain, B737-800

Joined on August 15 2005
50 State Club
Two Million Mile Club
Online Thirty Century
Everett Tri-Millennium Club
DVA Twenty-Year Anniversary
Five Millennium Club

"Flying Delta's Western Hub"
Salt Lake City, UT USA

5,010 legs, 9,704.7 hours
3,748 legs, 7,363.4 hours online
4,427 legs, 8,531.3 hours ACARS
22 legs, 49.5 hours event
Posted onPost created on October 25 2019 12:40 ET by Joe Porter
if it is in excel, it should be able to be saved as a .csv file in several formats MSDOS, etc. from excel. I am sure Luke can chime on this with some direction. Regardless, great find. It would be nice that the schedule is correct to RW dispatch . ..

Joe Porter

Senior Captain, B737-800
DVA3220
Captain, B737-800
OLP

Joined on May 19 2006
DVA Five-Year Anniversary
B737 50 Club

Southeastern United States

78 legs, 129.9 hours
73 legs, 122.3 hours online
76 legs, 127.3 hours ACARS
31 legs, 57.3 hours event
Posted onPost created on October 25 2019 15:16 ET by Tyler Devereaux
My plan was to make a script that would read the PDF and extract the info into a SQL database that Luke could hopefully import from. I hadn't gotten far enough to choose a language yet. I didn't want to get too into the weeds until hearing back from Like/whomever else would potentially receive and process the data.

While Excel does a decent job of converting to a table that could be theoretically exported to CSV, it seems like there would still need to be a significant amount of manual post-processing to clean up the CSV after Excel finished. Maybe it's possible, though. If we can get it done easily, repeatedly and reliably with Excel, that'd be awesome!

DVA043
Senior Captain, MD-11
OLP

Joined on June 10 2001
Event Half Century Club
Online Double Century Club
50 State Club
DVA Twenty-Year Anniversary
Everett 1500 Club
Bi-Millennium Club
Four Million Mile Club

"Col. Panic"
Marietta, GA

2,347 legs, 9,466.0 hours
240 legs, 553.9 hours online
2,005 legs, 8,259.1 hours ACARS
75 legs, 196.3 hours event
2,383 legs, 9,600.9 hours total
91 legs dispatched, 66.4 hours
Posted onPost created on October 25 2019 17:04 ET by Luke Kolin
Just write it to a CSV; that's easy to parse and import.

Cheers!

Luke Kolin

Senior Captain, MD-11
DVA3220
Captain, B737-800
OLP

Joined on May 19 2006
DVA Five-Year Anniversary
B737 50 Club

Southeastern United States

78 legs, 129.9 hours
73 legs, 122.3 hours online
76 legs, 127.3 hours ACARS
31 legs, 57.3 hours event
Posted onPost created on October 25 2019 17:57 ET by Tyler Devereaux
Alright. I'll add this to my pile of stuff and try to hack something together.
DVA2496
Senior Captain, B757-200
OLP

Joined on July 13 2005
B757 100 Club
50 State Club
Iron Dispatcher
Black Pearl Club
Everett Millennium Club
Globetrotter
Flying Colonel
Online Fifteen Century
Two Million Mile Club
Event Half Century Club
DVA Twenty-Year Anniversary

"Delta Connect - Antigua to world"
Cassada Gardens, Saint John Antigua and Barbuda

1,948 legs, 6,269.0 hours
1,852 legs, 6,008.0 hours online
1,807 legs, 5,852.1 hours ACARS
76 legs, 159.2 hours event
641 legs dispatched, 253.3 hours
Posted onPost created on October 25 2019 18:20 ET by Perez Howson
Alright, well just let us know what we can do.


Regards,



DVA12617
Chief Pilot, A350-900
OLP, VFRADV
DISPATCHER
E-MAIL

Joined on April 23 2015
B757 100 Club
Eurocap Club
Millennium Club
Toulouse 500 Club
DVA Ten-Year Anniversary
Online Quadruple Century Club

"Go Utes!"
Herriman, UT

1,322 legs, 3,057.1 hours
432 legs, 896.0 hours online
1,303 legs, 3,014.9 hours ACARS
25 legs, 78.6 hours event
39 legs dispatched, 174.2 hours
Posted onPost created on October 25 2019 18:41 ET by Joe Burner
Luke,

Thank you for the response to this.

Tyler,

I believe either Kevin Lundy, Jim Rose, Soonho Lee or myself can get it uploaded to the schedule. This is a great find. wink my hats off to you good sir!

I have been trying to convert it csv format but haven’t been successful. wink




DVA3220
Captain, B737-800
OLP

Joined on May 19 2006
DVA Five-Year Anniversary
B737 50 Club

Southeastern United States

78 legs, 129.9 hours
73 legs, 122.3 hours online
76 legs, 127.3 hours ACARS
31 legs, 57.3 hours event
Posted onPost created on October 25 2019 19:54 ET by Tyler Devereaux
Joe Burner wrote:

Luke,

Thank you for the response to this.

Tyler,

I believe either Kevin Lundy, Jim Rose, Soonho Lee or myself can get it uploaded to the schedule. This is a great find. wink my hats off to you good sir!

I have been trying to convert it csv format but haven’t been successful. wink



Thanks smile I really hope my assumption is correct and this document gets continually updated. If I can write something to automate parsing of the document, it could be as simple as scheduling a job to run automatically and our scheduling data woes could be over with. For awhile, at least. I'm optimistic.
DVA12617
Chief Pilot, A350-900
OLP, VFRADV
DISPATCHER
E-MAIL

Joined on April 23 2015
B757 100 Club
Eurocap Club
Millennium Club
Toulouse 500 Club
DVA Ten-Year Anniversary
Online Quadruple Century Club

"Go Utes!"
Herriman, UT

1,322 legs, 3,057.1 hours
432 legs, 896.0 hours online
1,303 legs, 3,014.9 hours ACARS
25 legs, 78.6 hours event
39 legs dispatched, 174.2 hours
Posted onPost created on October 25 2019 20:02 ET by Joe Burner
Tyler Devereaux wrote:

Joe Burner wrote:

Luke,

Thank you for the response to this.

Tyler,

I believe either Kevin Lundy, Jim Rose, Soonho Lee or myself can get it uploaded to the schedule. This is a great find. wink my hats off to you good sir!

I have been trying to convert it csv format but haven’t been successful. wink



Thanks smile I really hope my assumption is correct and this document gets continually updated. If I can write something to automate parsing of the document, it could be as simple as scheduling a job to run automatically and our scheduling data woes could be over with. For awhile, at least. I'm optimistic.



Tyler, I like the optimistic vision you have. wink So I think we can convert this to a csv file and we can get it imported. I know Kevin is working on this project as the number 1 priority.
Thank you
Joe



DVA8088
Chief Pilot, B737-800
OLP, 737-ATP

Joined on December 11 2009
50 State Club
Globetrotter
US Coastal Club
US Mountaineer Club
Everett Quad-Millennium Club
Events Triple Century Club
Online Sixty Century Club
Six Million Mile Club
Seven Millennium Club
DVA Fifteen-Year Anniversary

"Real Time & Online. The only way to fly!!"
Corona, CA

7,316 legs, 15,121.0 hours
6,903 legs, 13,683.4 hours online
7,255 legs, 14,952.5 hours ACARS
372 legs, 926.8 hours event
Posted onPost created on October 26 2019 17:20 ET by Scott Simmons
I'd be happy to write a PowerShell script to parse the data and create a usable file for importing into the DVA schedule.

Kevin,
Let me know which 11 fields are required.



DVA2496
Senior Captain, B757-200
OLP

Joined on July 13 2005
B757 100 Club
50 State Club
Iron Dispatcher
Black Pearl Club
Everett Millennium Club
Globetrotter
Flying Colonel
Online Fifteen Century
Two Million Mile Club
Event Half Century Club
DVA Twenty-Year Anniversary

"Delta Connect - Antigua to world"
Cassada Gardens, Saint John Antigua and Barbuda

1,948 legs, 6,269.0 hours
1,852 legs, 6,008.0 hours online
1,807 legs, 5,852.1 hours ACARS
76 legs, 159.2 hours event
641 legs dispatched, 253.3 hours
Posted onPost created on October 27 2019 09:30 ET by Perez Howson
Scott Simmons wrote:

I'd be happy to write a PowerShell script to parse the data and create a usable file for importing into the DVA schedule.

Kevin,
Let me know which 11 fields are required.


I am feeling so excited lol... just waiting to get these new routes :-) let's get it guysssss!

Regards,



DVA014
Captain, MD-88
OLP

Joined on June 15 2001
Century Club
Everett Century Club
Online Century Club
DVA Twenty-Year Anniversary

Helsinki, Etelä-Suomi Suomi

166 legs, 1,027.5 hours
130 legs, 872.4 hours online
161 legs, 993.7 hours ACARS
3 legs, 27.5 hours event
Posted onPost created on October 27 2019 10:42 ET by Jere Aarnia
Hopely we see updated schedules in near future also B788 B789 and B781 routes

Jere Aarnia

Captain, MD-88
DVA12617
Chief Pilot, A350-900
OLP, VFRADV
DISPATCHER
E-MAIL

Joined on April 23 2015
B757 100 Club
Eurocap Club
Millennium Club
Toulouse 500 Club
DVA Ten-Year Anniversary
Online Quadruple Century Club

"Go Utes!"
Herriman, UT

1,322 legs, 3,057.1 hours
432 legs, 896.0 hours online
1,303 legs, 3,014.9 hours ACARS
25 legs, 78.6 hours event
39 legs dispatched, 174.2 hours
Posted onPost created on October 27 2019 11:46 ET by Joe Burner
Jere Aarnia wrote:

Hopely we see updated schedules in near future also B788 B789 and B781 routes



Perez Howson wrote:

Scott Simmons wrote:

I'd be happy to write a PowerShell script to parse the data and create a usable file for importing into the DVA schedule.

Kevin,
Let me know which 11 fields are required.


I am feeling so excited lol... just waiting to get these new routes :-) let's get it guysssss!

Regards,



Hey y’all,

So we are currently working on a lot of new and interesting things and number one is working on updating the schedule. We have a lot of data in this awesome find, thank you Tyler. The data needs to be sifted through and added and updated. Hopefully we can get it added here in the near future.




DVA10323
Chief Pilot, B727-200
OLP

Joined on November 26 2011
50 State Club
Globetrotter
Tin Dispatcher
Tri-Jet Triumph
US Capital Club
Online Seven Century Club
US Mountaineer Club
DVA Ten-Year Anniversary
Flying Colonel
Everett Millennium Club

"GPS, we don't need no GPS"
Gulfport, MS

1,591 legs, 1,457.9 hours
742 legs, 686.0 hours online
1,583 legs, 1,450.4 hours ACARS
41 legs, 58.7 hours event
327 legs dispatched, 343.5 hours
Posted onPost created on October 27 2019 13:35 ET by Kevin Lundy
Scott Simmons wrote:


Kevin,
Let me know which 11 fields are required.


Awesome, I am sending you an email. Thanks!

Kevin Lundy

Chief Pilot, B727-200
DVA13420
Assistant Chief Pilot, B737-800

Joined on February 25 2018
50 State Club
Comrade Club
Winter Olympics Club
DVA Five-Year Anniversary
Millennium Club
Globetrotter
Everett 500 Club

Springfield, MO

1,093 legs, 1,902.6 hours
1,092 legs, 1,900.5 hours ACARS
Posted onPost created on October 29 2019 22:06 ET by Adam Magiera
This is a great find. An updated schedule would be great!

Adam Magiera

Assistant Chief Pilot, B737-800
DVA8088
Chief Pilot, B737-800
OLP, 737-ATP

Joined on December 11 2009
50 State Club
Globetrotter
US Coastal Club
US Mountaineer Club
Everett Quad-Millennium Club
Events Triple Century Club
Online Sixty Century Club
Six Million Mile Club
Seven Millennium Club
DVA Fifteen-Year Anniversary

"Real Time & Online. The only way to fly!!"
Corona, CA

7,316 legs, 15,121.0 hours
6,903 legs, 13,683.4 hours online
7,255 legs, 14,952.5 hours ACARS
372 legs, 926.8 hours event
Posted onPost created on October 30 2019 01:37 ET by Scott Simmons
This is going to be a good learning exercise. I've made some progress. I saved the .PDF as text (thanks to FoxIt Reader). I've massaged the file and removed the extraneous lines (ones without flight data).
Now I'm working on pulling the required data from each line. Getting the Flight Number is easy. Next is the EQType...stay tuned
The data is much more spread out than how it appears below...

Nov-14 ALB 5:55a ATL 8:49a - - - 4 5 - - DL2352 M88 0 2h 54m
Oct-9 ALB 6:00a ATL 8:34a 1 2 3 4 5 - 7 DL2352 320 0 2h 34m
Oct-31 Nov-1 ALB 6:00a ATL 8:34a - - - 4 5 - - DL2352 320 0 2h 34m
Oct-10 Oct-30 ALB 6:00a ATL 8:37a 1 2 3 4 5 - 7 DL2352 M90 0 2h 37m
Nov-3 Nov-3 ALB 6:00a ATL 8:37a - - - - - - 7 DL2352 M90 0 2h 37m
Oct-5 Oct-5 ALB 6:04a ATL 8:35a - - - - - 6 - DL2352 320 0 2h 31m
Nov-2 Nov-2 ALB 6:04a ATL 8:35a - - - - - 6 - DL2352 320 0 2h 31m
Oct-12 Oct-26 ALB 6:04a ATL 8:38a - - - - - 6 - DL2352 M90 0 2h 34m
Nov-6 - ALB 11:44a ATL 2:25p - - 3 - - - - DL1775 M88 0 2h 41m
Nov-4 Nov-11 ALB 11:49a ATL 2:27p 1 - - 4 5 - 7 DL1775 320 0 2h 38m
Nov-12 - ALB 11:49a ATL 2:27p - 2 - 4 5 - - DL1775 320 0 2h 38m
Oct-30 ALB 11:59a ATL 2:35p 1 2 3 4 5 - 7 DL0694 M90 0 2h 36m



DVA043
Senior Captain, MD-11
OLP

Joined on June 10 2001
Event Half Century Club
Online Double Century Club
50 State Club
DVA Twenty-Year Anniversary
Everett 1500 Club
Bi-Millennium Club
Four Million Mile Club

"Col. Panic"
Marietta, GA

2,347 legs, 9,466.0 hours
240 legs, 553.9 hours online
2,005 legs, 8,259.1 hours ACARS
75 legs, 196.3 hours event
2,383 legs, 9,600.9 hours total
91 legs dispatched, 66.4 hours
Posted onPost created on October 31 2019 11:15 ET by Luke Kolin
To be honest, what you have should be sufficient. The IATA lookup is trivial to do on my end.

Cheers!

Luke Kolin

Senior Captain, MD-11
DVA8088
Chief Pilot, B737-800
OLP, 737-ATP

Joined on December 11 2009
50 State Club
Globetrotter
US Coastal Club
US Mountaineer Club
Everett Quad-Millennium Club
Events Triple Century Club
Online Sixty Century Club
Six Million Mile Club
Seven Millennium Club
DVA Fifteen-Year Anniversary

"Real Time & Online. The only way to fly!!"
Corona, CA

7,316 legs, 15,121.0 hours
6,903 legs, 13,683.4 hours online
7,255 legs, 14,952.5 hours ACARS
372 legs, 926.8 hours event
Posted onPost created on October 31 2019 23:59 ET by Scott Simmons
Luke,
After some more work I've got it to this point:

AIRLINE NUMBER LEG EQTYPE FROM TO DTIME ATIME
------- ------ --- ------ ---- -- ----- -----
DL 0518 1 737 ABE ATL 6:14 8:15
DL 0719 1 737 ABE ATL 6:35 8:46
DL 4301 1 737 ABE DTW 1:15 3:09
DL 4321 1 737 ABE DTW 5:55 7:48
DL 4325 1 737 ABE DTW 5:46 7:40
DL 5172 1 737 ABE ATL 1:05 3:30
DL 5197 1 737 ABE ATL 5:55 8:14
DL 5277 1 737 ABE ATL 3:00 5:10
DL 0779 1 737 ABQ ATL 4:13 9:09
DL 0798 1 737 ABQ SLC 8:30 10:14
DL 0830 1 737 ABQ ATL 1:45 6:43
DL 0883 1 737 ABQ ATL 9:00 1:57
DL 0954 1 737 ABQ MSP 8:45 12:09
DL 1002 1 737 ABQ ATL 4:30 9:28
DL 1452 1 737 ABQ ATL 6:00 10:51
DL 1522 1 737 ABQ MSP 2:17 5:50
DL 1744 1 737 ABQ ATL 1:28 6:24
DL 1924 1 737 ABQ ATL 4:00 8:57
DL 1941 1 737 ABQ ATL 6:15 11:11
DL 2264 1 737 ABQ ATL 4:44 9:44
DL 2517 1 737 ABQ MSP 3:00 6:26
DL 2794 1 737 ABQ ATL 11:55 4:53
DL 2924 1 737 ABQ ATL 12:18 5:14
DL 3682 1 737 ABQ LAX 11:43 12:55
DL 3703 1 737 ABQ SLC 5:49 7:34
DL 3724 1 737 ABQ SLC 6:10 7:43
DL 3818 1 737 ABQ SLC 12:40 2:26

I'm still working on getting the EQTYPE from the raw data.



DVA043
Senior Captain, MD-11
OLP

Joined on June 10 2001
Event Half Century Club
Online Double Century Club
50 State Club
DVA Twenty-Year Anniversary
Everett 1500 Club
Bi-Millennium Club
Four Million Mile Club

"Col. Panic"
Marietta, GA

2,347 legs, 9,466.0 hours
240 legs, 553.9 hours online
2,005 legs, 8,259.1 hours ACARS
75 legs, 196.3 hours event
2,383 legs, 9,600.9 hours total
91 legs dispatched, 66.4 hours
Posted onPost created on November 01 2019 18:20 ET by Luke Kolin
Send me what you have - like I said, IATA equipment code lookups are trivial for me to do.

Cheers!

Luke Kolin

Senior Captain, MD-11
DVA8088
Chief Pilot, B737-800
OLP, 737-ATP

Joined on December 11 2009
50 State Club
Globetrotter
US Coastal Club
US Mountaineer Club
Everett Quad-Millennium Club
Events Triple Century Club
Online Sixty Century Club
Six Million Mile Club
Seven Millennium Club
DVA Fifteen-Year Anniversary

"Real Time & Online. The only way to fly!!"
Corona, CA

7,316 legs, 15,121.0 hours
6,903 legs, 13,683.4 hours online
7,255 legs, 14,952.5 hours ACARS
372 legs, 926.8 hours event
Posted onPost created on November 03 2019 22:42 ET by Scott Simmons
I've got the equipment issue solved. Just some fine tuning.
I'll send you the raw .CSV (several flights for each flight number) plus another .CSV with unique flight numbers (one flight per flight number)



DVA043
Senior Captain, MD-11
OLP

Joined on June 10 2001
Event Half Century Club
Online Double Century Club
50 State Club
DVA Twenty-Year Anniversary
Everett 1500 Club
Bi-Millennium Club
Four Million Mile Club

"Col. Panic"
Marietta, GA

2,347 legs, 9,466.0 hours
240 legs, 553.9 hours online
2,005 legs, 8,259.1 hours ACARS
75 legs, 196.3 hours event
2,383 legs, 9,600.9 hours total
91 legs dispatched, 66.4 hours
Posted onPost created on November 04 2019 15:21 ET by Luke Kolin
Scott Simmons wrote:

I've got the equipment issue solved. Just some fine tuning.


Is it solved using the existing mappings in the database? wink That's why I mentioned I'd prefer IATA or ICAO codes and I'll take it from there on the import. My week is a little crazy but hopefully I can take a peek at it over the next few days.

Cheers!

Luke Kolin

Senior Captain, MD-11
DVA2527
Senior Captain, B737-800

Joined on August 15 2005
50 State Club
Two Million Mile Club
Online Thirty Century
Everett Tri-Millennium Club
DVA Twenty-Year Anniversary
Five Millennium Club

"Flying Delta's Western Hub"
Salt Lake City, UT USA

5,010 legs, 9,704.7 hours
3,748 legs, 7,363.4 hours online
4,427 legs, 8,531.3 hours ACARS
22 legs, 49.5 hours event
Posted onPost created on November 04 2019 19:30 ET by Joe Porter
This sounds very encouraging. I always use the RW published flights, routes, gate info, etc. . . . always an "as real as it gets" simmer . . .

Joe Porter

Senior Captain, B737-800
DVA8088
Chief Pilot, B737-800
OLP, 737-ATP

Joined on December 11 2009
50 State Club
Globetrotter
US Coastal Club
US Mountaineer Club
Everett Quad-Millennium Club
Events Triple Century Club
Online Sixty Century Club
Six Million Mile Club
Seven Millennium Club
DVA Fifteen-Year Anniversary

"Real Time & Online. The only way to fly!!"
Corona, CA

7,316 legs, 15,121.0 hours
6,903 legs, 13,683.4 hours online
7,255 legs, 14,952.5 hours ACARS
372 legs, 926.8 hours event
Posted onPost created on December 14 2019 12:15 ET by Scott Simmons
I've accessed the link that Perez provided and it's still coming up with the same .PDF that was only good until 11.15.19.
I was hoping that they would replace it with an updated schedule.
I'm anxious to run a new schedule through the PowerShell script I wrote that parsed the .TXT dump of the .PDF and saved it to a .CSV that Luke is looking over.



DVA10082
Captain, B777-200
OLP

Joined on August 17 2011
50 State Club
Event Half Century Club
Tin Dispatcher
DVA Ten-Year Anniversary
Globetrotter
Bi-Millennium Club
Three Million Mile Club
US Coastal Club
US Mountaineer Club
Everett Bi-Millennium Club
Online Twenty Century

"Set your compass to 'E' and get out of my airspace!"
Monroe, LA

2,483 legs, 8,590.4 hours
2,051 legs, 6,798.2 hours online
2,448 legs, 8,496.6 hours ACARS
104 legs, 243.6 hours event
366 legs dispatched, 255.4 hours
Posted onPost created on December 14 2019 13:53 ET by Josh Burr
Scott Simmons wrote:

I've accessed the link that Perez provided and it's still coming up with the same .PDF that was only good until 11.15.19.
I was hoping that they would replace it with an updated schedule.
I'm anxious to run a new schedule through the PowerShell script I wrote that parsed the .TXT dump of the .PDF and saved it to a .CSV that Luke is looking over.


Scott,

I've been referencing this link since early 2017 to fly RW international legs. They do update it, but in my experience, they update it a month after the new one is made valid (In this case, the new one was valid Nov. 16, so it should be on that link sometime around Dec. 16).

That's where the problem will come into this big project; the DVA schedule, if updated the DAY the RW scheudle is available for our viewing, will always be at least one month behind.



DVA043
Senior Captain, MD-11
OLP

Joined on June 10 2001
Event Half Century Club
Online Double Century Club
50 State Club
DVA Twenty-Year Anniversary
Everett 1500 Club
Bi-Millennium Club
Four Million Mile Club

"Col. Panic"
Marietta, GA

2,347 legs, 9,466.0 hours
240 legs, 553.9 hours online
2,005 legs, 8,259.1 hours ACARS
75 legs, 196.3 hours event
2,383 legs, 9,600.9 hours total
91 legs dispatched, 66.4 hours
Posted onPost created on December 14 2019 16:05 ET by Luke Kolin
I'm looking at parsing the entire SkyTeam schedule - unfortunately it seems almost a year out of date.

Cheers!

Luke Kolin

Senior Captain, MD-11
DVA043
Senior Captain, MD-11
OLP

Joined on June 10 2001
Event Half Century Club
Online Double Century Club
50 State Club
DVA Twenty-Year Anniversary
Everett 1500 Club
Bi-Millennium Club
Four Million Mile Club

"Col. Panic"
Marietta, GA

2,347 legs, 9,466.0 hours
240 legs, 553.9 hours online
2,005 legs, 8,259.1 hours ACARS
75 legs, 196.3 hours event
2,383 legs, 9,600.9 hours total
91 legs dispatched, 66.4 hours
Posted onPost created on December 15 2019 10:32 ET by Luke Kolin
I'm pretty sure I can import multiple "layers" of schedule from different sources over each other. What's stopping me now is the incredibly poor quality of the permanent schedule data. I'm trying to clean up what's there, but I'm really starting to suspect/fear that we need to go to the current SkyTeam schedule and have the Ops team revalidate all of the historic flights and determine what to put back. It's been added in fits and starts over the years without a coherent plan or vision, and the data quality is poor and there are some interesting choices having been made (Saudia Historical?)

Cheers!

Luke Kolin

Senior Captain, MD-11
Progress Spinner


Delta Virtual Airlines 2006 (Golgotha v12.3) Copyright © 2004 - 2025 Global Virtual Airlines Group. All Rights Reserved. (Build 971)
For flight simulation purposes only. Not a commercial website. In no way are we affiliated with Delta Air Lines, its affiliates, or any other airline. All logos, images, and trademarks remain the property of their respective owners. Delta Virtual Airlines is a non-profit entity engaged in providing an avenue for flight simulation enthusiasts.