ATCPro Forums Homepage
Forum Home Forum Home > ATC Pro Forums > General Discussion
  New Posts New Posts RSS Feed - Custom Flight Schedules
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Custom Flight Schedules

 Post Reply Post Reply Page  12>
Author
Message
andrewatc View Drop Down
Senior Member
Senior Member


Joined: 28 Feb 2016
Location: Canada
Status: Offline
Points: 352
Post Options Post Options   Thanks (1) Thanks(1)   Quote andrewatc Quote  Post ReplyReply Direct Link To This Post Topic: Custom Flight Schedules
    Posted: 08 Jan 2017 at 10:43am
I thought I would start a thread on creating custom flight schedules. As this is something that took me a while to figure out it might be worth having a discussion about. I made some instructions on how to do so below for an other user and figured I might as well post them! Please correct anything I've got wrong. Below is my method that seems to work.

First thing you'll need to do is download SQLite. http://sqliteexpert.com/

Then you'll need to find the file that has the traffic for that particular airport. Go to Program Data  > Flag Mountian > ATCpro > Facilities > ABQ

There you will see a bunch of files, open the one titled custom.db with SQLite Expert.

This is where you can create the custom fights.

rowid and id just need to be numbers. For the first one just start with row id = 1 and id= 0, and then count up from there as you ad flights

carrier is the airline code. You can see all the available airline codes under the universal tab on the side under callsigns

fltnum is the flight number. I think it can be anything up to 4 digits  

equip  is the aircraft type. you can find all the different aircraft types under the universal tab on the side under aircraft. Make sure you use the IATA name for the aircraft!

dICAO is the departure location airport code
 
dLocal is the local time the aircraft departs. Note: this time has to be in minutes from Sunday at midnight (I believe). Meaning that if you wanted to have an aircraft depart somewhere at 6 am on Sunday the local time would be 360 (6 hours past midnight).

dUTC is the universal time that the aircraft departs. Depending on time zone this will vary. For example when I make departures off the west coast I take the local time and add 480 minutes (8 hours). I don't know how much it matters if the difference between local time and UTC time is correct or not. So you may be able to just put anything there.

aICAO is the arrival airports code. In this case it would be KABQ.

aLocal now we're getting to the important stuff. When do you want your arrival to show up? This again is in minutes from sunday at midnight. I figured out that 2000 is right around 9 am on Tuesday. So I just started there and built flights for the whole day.

aUTC is the universal time the aircraft arrives. Local plus 420 minutes for ABQ seems to be working.

loadUTC not 100% sure what this is, just make it a UTC time that is before the aircraft departs and it will work.

overflight ID again don't know what this is. Just type (null) with the brackets and lowercase.

numApproach just put a zero '0'

Here's an example of some custom flights I've built: (link to an image)
https://puu.sh/tfqSv/ed05549493.png

You can also open up the 'schedule' file for the facility with SQLite and see the existing airline schedule and edit those flights or look at examples.

So far I have only been able to make it work for airline flights, not GA. If anyone knows how to do GA flights please let me know!

Andrew
SW3, SW4 Captain in CYYC
Back to Top
seippg View Drop Down
Member
Member


Joined: 16 Jun 2016
Location: NC
Status: Offline
Points: 10
Post Options Post Options   Thanks (0) Thanks(0)   Quote seippg Quote  Post ReplyReply Direct Link To This Post Posted: 11 Jan 2017 at 1:09pm
Would be cool be able to import from FlightAware.
Gregg
Back to Top
Tom@FlagMountain View Drop Down
Admin Group
Admin Group


Joined: 22 Oct 2014
Location: Albuquerque, NM
Status: Offline
Points: 481
Post Options Post Options   Thanks (0) Thanks(0)   Quote Tom@FlagMountain Quote  Post ReplyReply Direct Link To This Post Posted: 11 Jan 2017 at 1:14pm
Andrew:
 
Very nice tutorial on building a custom flight db.  Thanx for posting it.
 
Regards
 
Tom Murdock
Flag Mountain Software
Tom Murdock
Flag Mountain Software
ATCpro Project Team
Back to Top
deltamike172 View Drop Down
Senior Member
Senior Member


Joined: 03 Jan 2016
Status: Offline
Points: 317
Post Options Post Options   Thanks (0) Thanks(0)   Quote deltamike172 Quote  Post ReplyReply Direct Link To This Post Posted: 11 Jan 2017 at 9:21pm
Keep in mind, that flightaware filters out most of the corporate traffic, since they pay to have their flights blocked so we can't track them.
Back to Top
tlittle View Drop Down
Member
Member


Joined: 09 Jan 2017
Status: Offline
Points: 6
Post Options Post Options   Thanks (0) Thanks(0)   Quote tlittle Quote  Post ReplyReply Direct Link To This Post Posted: 12 Jan 2017 at 7:22pm
Originally posted by seippg seippg wrote:

Would be cool be able to import from FlightAware.
 
Been workin on that Tongue
 
Still developing but here's a snippet of departures from ABQ from today back to earlier this week:
 
(I keep corporate and GA traffic to 25-50%, commercial 0%, custom 100% with the flights below)
Plan on getting the whole week in then upload. Right now it's a bit crude but anyone could copy and paste the code below *into the custom.db within the ABQ folder* in SQL within sqlite.
 
INSERT INTO 'Schedule' VALUES
(0,'AAL',1353,'738','KABQ',5357,5777,'KDFW',5491,5911,5717,'(null)',0),
(1,'AMF',1051,'PA2','KABQ',5341,5761,'KPHX',5476,5896,5701,'(null)',0),
(2,'N113US',0,'C560','KABQ',5322,5742,'KLBB',5425,5845,5722,'',0),
(3,'ASA',775,'738','KABQ',5314,5734,'KSEA',5410,5830,5674,'(null)',0),
(4,'RSP',243,'E50P','KABQ',5303,5723,'KSDL',5375,5795,5663,'(null)',0),
(5,'BTQ',614,'PL2','KABQ',5299,5719,'KSVC',5351,5771,5659,'(null)',0),
(6,'MNU',751,'CR7','KABQ',5293,5713,'KSFO',5359,5779,5653,'(null)',0),
(7,'SWA',28,'733','KABQ',5287,5707,'KSAN',5330,5750,5647,'(null)',0),
(8,'SWA',1461,'733','KABQ',5281,5701,'KLAS',5300,5720,5641,'(null)',0),
(9,'SWA',1766,'73G','KABQ',5278,5698,'KHOU',5435,5855,5638,'(null)',0),
(10,'N21H',0,'C560','KABQ',5265,5685,'KBUR',5328,5748,5665,'',0),
(11,'N72CU',0,'BE36','KABQ',5258,5678,'KGYR',5411,5831,5658,'',0),
(12,'N3137T',0,'P46T','KABQ',5250,5670,'KEDC',5439,5859,5650,'',0),
(13,'ASH',5963,'CR9','KABQ',5248,5668,'KPHX',5307,5727,5608,'(null)',0),
(14,'AAL',2511,'738','KABQ',5223,5643,'KDFW',5358,5778,5583,'(null)',0),
(15,'SKW',5253,'CR7','KABQ',5219,5639,'KIAH',5376,5796,5579,'(null)',0),
(16,'AAY',471,'M88','KABQ',5213,5633,'KLAS',5242,5662,5573,'(null)',0),
(17,'DAL',1781,'M90','KABQ',5204,5624,'KATL',5466,5886,5564,'(null)',0),
(18,'SWA',1566,'73G','KABQ',5195,5615,'KDAL',5337,5757,5555,'(null)',0),
(19,'GJS',4524,'CR7','KABQ',5192,5612,'KORD',5372,5792,5552,'(null)',0),
(20,'SWA',4904,'733','KABQ',5187,5607,'KDAL',5324,5744,5547,'(null)',0),
(21,'ENY',3513,'CR7','KABQ',5161,5581,'KORD',5344,5764,5521,'(null)',0),
(22,'SWA',4566,'738','KABQ',5125,5545,'KLAX',5173,5593,5485,'(null)',0),
(23,'N101CG',0,'CNC','KABQ',5122,5542,'KIWA',5247,5667,5522,'',0),
(24,'LOF',4787,'ER4','KABQ',5116,5536,'KDEN',5166,5586,5476,'(null)',0),
(25,'SWA',732,'73G','KABQ',5114,5534,'KLAS',5133,5553,5474,'(null)',0),
(26,'N3984W',0,'BE2','KABQ',5104,5524,'KHHF',5240,5660,5504,'',0),
(27,'ASH',5752,'CR9','KABQ',5090,5510,'KPHX',5154,5574,5450,'(null)',0),
(28,'SWA',1838,'73G','KABQ',5081,5501,'KDAL',5216,5636,5441,'(null)',0),
(29,'SWA',1712,'73G','KABQ',5078,5498,'KPHX',5143,5563,5438,'(null)',0),
(30,'N16LX',0,'SR22','KABQ',5077,5497,'KRVS',5299,5719,5477,'',0),
(31,'SWA',1730,'733','KABQ',5077,5497,'KDEN',5125,5545,5437,'(null)',0),
(32,'SKW',4462,'CR9','KABQ',5073,5493,'KSLC',5148,5568,5433,'(null)',0),
(33,'SWA',416,'733','KABQ',5047,5467,'KHOU',5202,5622,5407,'(null)',0),
(34,'CPZ',6064,'E75','KABQ',5045,5465,'KLAX',5096,5516,5405,'(null)',0),
(35,'ASH',5937,'CR7','KABQ',5041,5461,'KDFW',5173,5593,5401,'(null)',0),
(36,'N22NJ',0,'EA50','KABQ',5024,5444,'KHND',5064,5484,5424,'',0),
(37,'ASQ',3888,'ER3','KABQ',5004,5424,'KIAH',5160,5580,5364,'(null)',0),
(38,'SWA',6,'73G','KABQ',4983,5403,'KLAS',4998,5418,5343,'(null)',0),
(39,'SWA',1675,'733','KABQ',4973,5393,'KMCI',5117,5537,5333,'(null)',0),
(40,'AAL',2214,'M88','KABQ',4966,5386,'KDFW',5098,5518,5326,'(null)',0),
(41,'SWA',198,'73G','KABQ',4926,5346,'KPHX',4987,5407,5286,'(null)',0),
(42,'LOF',4799,'ER4','KABQ',4923,5343,'KDEN',4976,5396,5283,'(null)',0),
(43,'AAY',492,'M88','KABQ',4918,5338,'KAUS',5063,5483,5278,'(null)',0),
(44,'N3080K',0,'BE36','KABQ',4886,5306,'KSEZ',5003,5423,5286,'',0),
(45,'N101CG',0,'CNC','KABQ',4878,5298,'KABQ',4985,5405,5278,'',0),
(46,'N505AW',0,'BE20','KABQ',4871,5291,'KTUS',4963,5383,5271,'',0),
(47,'ASH',5956,'CR9','KABQ',4867,5287,'KPHX',4930,5350,5227,'(null)',0),
(48,'SWA',103,'73G','KABQ',4832,5252,'KMDW',5021,5441,5192,'(null)',0),
(49,'SWA',1894,'738','KABQ',4819,5239,'KBWI',5122,5542,5179,'(null)',0),
(50,'ASH',6225,'E70','KABQ',4818,5238,'KIAH',4978,5398,5178,'(null)',0),
(51,'SWA',554,'73G','KABQ',4809,5229,'KSAN',4847,5267,5169,'(null)',0),
(52,'BTQ',654,'PL2','KABQ',4807,5227,'KCNM',4855,5275,5167,'(null)',0),
(53,'AAL',1282,'738','KABQ',4805,5225,'KDFW',4937,5357,5165,'(null)',0),
(54,'CFS',774,'CNC','KABQ',4793,5213,'KDRO',4853,5273,5153,'(null)',0),
(55,'CFS',791,'CNC','KABQ',4790,5210,'KFMN',4850,5270,5150,'(null)',0),
(56,'CFS',786,'CNC','KABQ',4783,5203,'KFMN',4837,5257,5143,'(null)',0),
(57,'UPS',2871,'763','KABQ',4780,5200,'KSDF',5030,5450,5140,'(null)',0),
(58,'UAL',382,'319','KABQ',4775,5195,'KDEN',4831,5251,5135,'(null)',0),
(59,'FDX',629,'AB6','KABQ',4773,5193,'KLBB',4872,5292,5133,'(null)',0),
(60,'AMF',1268,'BE9','KABQ',4769,5189,'KCNM',4835,5255,5129,'(null)',0),
(61,'AMF',1284,'PA2','KABQ',4768,5188,'KALM',4825,5245,5128,'(null)',0),
(62,'AMF',1874,'PA2','KABQ',4762,5182,'KFMN',4820,5240,5122,'(null)',0),
(63,'AMF',1882,'BE9','KABQ',4757,5177,'KHOB',4822,5242,5117,'(null)',0),
(64,'AMF',1254,'PA2','KABQ',4756,5176,'KSVC',4826,5246,5116,'(null)',0),
(65,'AMF',1296,'BE9','KABQ',4754,5174,'KROW',4804,5224,5114,'(null)',0),
(66,'N29AN',0,'CNC','KABQ',4750,5170,'KCVN',4808,5228,5150,'',0),
(67,'SWA',192,'73G','KABQ',4747,5167,'KOAK',4822,5242,5107,'(null)',0),
(68,'N108AN',0,'CNC','KABQ',4746,5166,'KABQ',4908,5328,5146,'',0),
(69,'SWA',1561,'73G','KABQ',4744,5164,'KPHX',4808,5228,5104,'(null)',0),
(70,'SWA',718,'73G','KABQ',4742,5162,'KHOU',4898,5318,5102,'(null)',0),
(71,'ASH',5976,'CR9','KABQ',4732,5152,'KDFW',4864,5284,5092,'(null)',0),
(72,'SWA',1111,'733','KABQ',4718,5138,'KDEN',4771,5191,5078,'(null)',0),
(73,'N340EM',0,'CN2','KABQ',4711,5131,'KGJT',4797,5217,5111,'',0),
(74,'ASH',5930,'CR9','KABQ',4710,5130,'KPHX',4774,5194,5070,'(null)',0),
(75,'DAL',1995,'M90','KABQ',4708,5128,'KATL',4976,5396,5068,'(null)',0),
(76,'CPZ',6066,'E75','KABQ',4704,5124,'KLAX',4753,5173,5064,'(null)',0),
(77,'SWA',203,'73G','KABQ',4703,5123,'KDAL',4850,5270,5063,'(null)',0),
(78,'SKW',5348,'CR7','KABQ',4692,5112,'KSFO',4772,5192,5052,'(null)',0),
(79,'N474SS',0,'PL2','KABQ',4688,5108,'KPHX',4852,5272,5088,'',0),
(80,'BTQ',612,'PL2','KABQ',4688,5108,'KSVC',4739,5159,5048,'(null)',0),
(81,'SWA',1820,'738','KABQ',4687,5107,'KPHX',4750,5170,5047,'(null)',0),
(82,'DAL',2123,'717','KABQ',4684,5104,'KSLC',4757,5177,5044,'(null)',0),
(83,'UPS',894,'752','KABQ',4681,5101,'KPHX',4739,5159,5041,'(null)',0),
(84,'N49MN',0,'GR2','KABQ',4424,4844,'KSFO',4510,4930,4824,'',0),
(85,'N305LG',0,'BE20','KABQ',4299,4719,'KRQE',4337,4757,4699,'',0),
(86,'UPS',797,'AB6','KABQ',4149,4569,'KSDF',4404,4824,4509,'(null)',0),
(87,'UPS',887,'763','KABQ',4132,4552,'KONT',4169,4589,4492,'(null)',0),
(88,'SWA',142,'738','KABQ',4108,4528,'KDAL',4236,4656,4468,'(null)',0),
(89,'N7542S',0,'PAY2','KABQ',4097,4517,'KPVW',4230,4650,4497,'',0),
(90,'SWA',1595,'73G','KABQ',4096,4516,'KPHX',4156,4576,4456,'(null)',0),
(91,'SWA',1717,'73G','KABQ',4088,4508,'KLAS',4113,4533,4448,'(null)',0),
(92,'FDX',1334,'D11','KABQ',4085,4505,'KMEM',4254,4674,4445,'(null)',0),
(93,'BTQ',616,'PL2','KABQ',4039,4459,'KSVC',4089,4509,4399,'(null)',0),
(94,'BTQ',566,'PL2','KABQ',4037,4457,'KALS',4077,4497,4397,'(null)',0),
(95,'ASH',5964,'CR9','KABQ',4034,4454,'KPHX',4093,4513,4394,'(null)',0),
(96,'JBU',213,'320','KABQ',4016,4436,'KLGB',4059,4479,4376,'(null)',0),
(97,'N545WB',0,'TBM','KABQ',4009,4429,'KSDL',4108,4528,4409,'',0),
(98,'SWA',1157,'73G','KABQ',3997,4417,'KPHX',4060,4480,4357,'(null)',0),
(99,'ASH',5989,'CR7','KABQ',3982,4402,'KDFW',4114,4534,4342,'(null)',0),
(100,'N523DV',0,'C25B','KABQ',3979,4399,'KCLS',4100,4520,4379,'',0),
(101,'N912NM',0,'PL2','KABQ',3969,4389,'KFMN',4018,4438,4369,'',0),
(102,'SWA',206,'73G','KABQ',3966,4386,'KDEN',4021,4441,4326,'(null)',0),
(103,'UAL',2385,'320','KABQ',3965,4385,'KDEN',4018,4438,4325,'(null)',0),
(104,'UPS',2874,'763','KABQ',3961,4381,'KPHX',4026,4446,4321,'(null)',0),
(105,'SWA',1469,'73G','KABQ',3960,4380,'KDAL',4096,4516,4320,'(null)',0),
(106,'SKW',4499,'CR9','KABQ',3947,4367,'KSLC',4026,4446,4307,'(null)',0),
(107,'SWA',1471,'73G','KABQ',3935,4355,'KPHX',3998,4418,4295,'(null)',0),
(108,'AMF',1051,'PA2','KABQ',3908,4328,'KPHX',4043,4463,4268,'(null)',0),
(109,'SWA',1379,'73G','KABQ',3900,4320,'KOAK',3980,4400,4260,'(null)',0),
(110,'EJM',204,'CL30','KABQ',3897,4317,'KMDW',4084,4504,4257,'(null)',0),
(111,'AAL',1353,'738','KABQ',3892,4312,'KDFW',4027,4447,4252,'(null)',0),
(112,'N1414P',0,'C25A','KABQ',3883,4303,'KTKI',4024,4444,4283,'',0),
(113,'ASA',775,'73G','KABQ',3877,4297,'KSEA',3971,4391,4237,'(null)',0),
(114,'N826AC',0,'C560','KABQ',3874,4294,'KFSM',4059,4479,4274,'',0),
(115,'SWA',28,'73G','KABQ',3840,4260,'KSAN',3885,4305,4200,'(null)',0),
(116,'SWA',1766,'73G','KABQ',3836,4256,'KHOU',3999,4419,4196,'(null)',0),
(117,'SWA',1461,'73G','KABQ',3822,4242,'KLAS',3843,4263,4182,'(null)',0),
(118,'N113US',0,'C560','KABQ',3821,4241,'KLBB',3920,4340,4221,'',0),
(119,'ASH',5963,'CR9','KABQ',3805,4225,'KPHX',3874,4294,4165,'(null)',0),
(120,'AAL',2511,'738','KABQ',3794,4214,'KDFW',3929,4349,4154,'(null)',0),
(121,'N406SF',0,'BE9L','KABQ',3778,4198,'KLRU',3831,4251,4178,'',0),
(122,'SKW',5253,'CR7','KABQ',3761,4181,'KIAH',3923,4343,4121,'(null)',0),
(123,'XOJ',789,'CN7','KABQ',3757,4177,'/ MM',3956,4376,4117,'(null)',0),
(124,'N14NW',0,'CNT','KABQ',3752,4172,'KSEE',3852,4272,4152,'',0),
(125,'SWA',4904,'733','KABQ',3736,4156,'KDAL',3873,4293,4096,'(null)',0),
(126,'N239BC',0,'C402','KABQ',3717,4137,'KTCS',3759,4179,4117,'',0),
(127,'ENY',3513,'CR7','KABQ',3701,4121,'KORD',3895,4315,4061,'(null)',0),
(128,'SWA',4566,'73G','KABQ',3689,4109,'KLAX',3739,4159,4049,'(null)',0),
(129,'JBU',189,'320','KABQ',3671,4091,'KSAN',3719,4139,4031,'(null)',0),
(130,'LOF',4787,'ER4','KABQ',3669,4089,'KDEN',3725,4145,4029,'(null)',0),
(131,'SWA',732,'73G','KABQ',3660,4080,'KLAS',3681,4101,4020,'(null)',0),
(132,'N92VA',0,'ER4','KABQ',3658,4078,'KSVH',3934,4354,4058,'',0),
(133,'GJS',4524,'CR7','KABQ',3648,4068,'KORD',3837,4257,4008,'(null)',0),
(134,'SWA',1712,'733','KABQ',3646,4066,'KPHX',3705,4125,4006,'(null)',0),
(135,'N2028S',0,'C210','KABQ',3644,4064,'KABQ',3645,4065,4044,'',0),
(136,'ASH',5752,'CR9','KABQ',3643,4063,'KPHX',3703,4123,4003,'(null)',0),
(137,'N3455L',0,'BE20','KABQ',3637,4057,'KWJF',3744,4164,4037,'',0),
(138,'SWA',1730,'73G','KABQ',3624,4044,'KDEN',3674,4094,3984,'(null)',0),
(139,'ASH',5937,'CR7','KABQ',3618,4038,'KDFW',3747,4167,3978,'(null)',0),
(140,'SWA',416,'73G','KABQ',3611,4031,'KHOU',3766,4186,3971,'(null)',0),
(141,'CPZ',6064,'E75','KABQ',3609,4029,'KLAX',3666,4086,3969,'(null)',0),
(142,'SKW',4462,'CR7','KABQ',3608,4028,'KSLC',3693,4113,3968,'(null)',0),
(143,'N22NJ',0,'EA50','KABQ',3594,4014,'KSDL',3736,4156,3994,'',0),
(144,'SWA',1838,'73G','KABQ',3583,4003,'KDAL',3721,4141,3943,'(null)',0),
(145,'SKW',5425,'E75','KABQ',3575,3995,'KLAX',3672,4092,3935,'(null)',0),
(146,'ASQ',3888,'ER3','KABQ',3558,3978,'KIAH',3714,4134,3918,'(null)',0),
(147,'N648JW',0,'C510','KABQ',3551,3971,'KTRM',3624,4044,3951,'',0),
(148,'SWA',6,'73G','KABQ',3542,3962,'KLAS',3565,3985,3902,'(null)',0),
(149,'AAL',2214,'M88','KABQ',3524,3944,'KDFW',3653,4073,3884,'(null)',0),
(150,'SWA',1675,'733','KABQ',3519,3939,'KMCI',3661,4081,3879,'(null)',0),
(151,'N550DM',0,'EA50','KABQ',3517,3937,'KFMN',3558,3978,3917,'',0),
(152,'LOF',4799,'ER4','KABQ',3498,3918,'KDEN',3560,3980,3858,'(null)',0),
(153,'N61DT',0,'EA50','KABQ',3495,3915,'KRAP',3598,4018,3895,'',0),
(154,'SWA',198,'73G','KABQ',3494,3914,'KPHX',3550,3970,3854,'(null)',0),
(155,'N305LG',0,'BE20','KABQ',3450,3870,'KROW',3490,3910,3850,'',0),
(156,'ASH',5956,'CR9','KABQ',3410,3830,'KPHX',3472,3892,3770,'(null)',0),
(157,'N9898',0,'BE20','KABQ',3408,3828,'KFFZ',3501,3921,3808,'',0),
(158,'SWA',103,'73G','KABQ',3400,3820,'KMDW',3590,4010,3760,'(null)',0),
(159,'UPS',2871,'763','KABQ',3397,3817,'KSDF',3642,4062,3757,'(null)',0),
(160,'BTQ',654,'PL2','KABQ',3394,3814,'KCNM',3449,3869,3754,'(null)',0),
(161,'CTA',571,'PL2','KABQ',3381,3801,'KTUL',3555,3975,3741,'(null)',0),
(162,'ASH',6225,'E70','KABQ',3375,3795,'KIAH',3534,3954,3735,'(null)',0),
(163,'SWA',1894,'73G','KABQ',3374,3794,'KBWI',3674,4094,3734,'(null)',0),
(164,'SWA',554,'73G','KABQ',3369,3789,'KSAN',3415,3835,3729,'(null)',0),
(165,'CFS',774,'CNC','KABQ',3367,3787,'KDRO',3426,3846,3727,'(null)',0),
(166,'CFS',791,'CNC','KABQ',3365,3785,'KFMN',3424,3844,3725,'(null)',0),
(167,'AAL',1282,'738','KABQ',3362,3782,'KDFW',3493,3913,3722,'(null)',0),
(168,'FDX',629,'AB6','KABQ',3343,3763,'KLBB',3449,3869,3703,'(null)',0),
(169,'AMF',1284,'PA2','KABQ',3339,3759,'KALM',3394,3814,3699,'(null)',0),
(170,'AMF',1268,'BE9','KABQ',3337,3757,'KCNM',3397,3817,3697,'(null)',0),
(171,'CFS',786,'CNC','KABQ',3335,3755,'KFMN',3400,3820,3695,'(null)',0),
(172,'AMF',1882,'BE9','KABQ',3335,3755,'KHOB',3396,3816,3695,'(null)',0),
(173,'UAL',382,'319','KABQ',3333,3753,'KDEN',3393,3813,3693,'(null)',0),
(174,'AMF',1296,'BE9','KABQ',3332,3752,'KROW',3379,3799,3692,'(null)',0),
(175,'AMF',1874,'PA2','KABQ',3328,3748,'KFMN',3391,3811,3688,'(null)',0),
(176,'AMF',1254,'PA2','KABQ',3322,3742,'KSVC',3390,3810,3682,'(null)',0),
(177,'N920RC',0,'CN2','KABQ',3321,3741,'KGUP',3377,3797,3721,'',0),
(178,'N29AN',0,'CNC','KABQ',3317,3737,'KCVN',3372,3792,3717,'',0),
(179,'ASH',5930,'CR9','KABQ',3312,3732,'KPHX',3372,3792,3672,'(null)',0),
(180,'SWA',192,'73G','KABQ',3309,3729,'KOAK',3395,3815,3669,'(null)',0),
(181,'SWA',718,'733','KABQ',3305,3725,'KHOU',3465,3885,3665,'(null)',0),
(182,'SWA',1561,'73G','KABQ',3303,3723,'KPHX',3366,3786,3663,'(null)',0),
(183,'ASH',5976,'CR9','KABQ',3295,3715,'KDFW',3426,3846,3655,'(null)',0),
(184,'SWA',1111,'73G','KABQ',3279,3699,'KDEN',3336,3756,3639,'(null)',0),
(185,'DAL',1995,'M90','KABQ',3266,3686,'KATL',3529,3949,3626,'(null)',0),
(186,'SWA',1820,'738','KABQ',3260,3680,'KPHX',3323,3743,3620,'(null)',0),
(187,'SWA',203,'73G','KABQ',3258,3678,'KDAL',3394,3814,3618,'(null)',0),
(188,'SKW',5348,'CR7','KABQ',3256,3676,'KSFO',3345,3765,3616,'(null)',0),
(189,'UPS',894,'763','KABQ',3253,3673,'KPHX',3314,3734,3613,'(null)',0),
(190,'CPZ',6066,'E75','KABQ',3250,3670,'KLAX',3309,3729,3610,'(null)',0),
(191,'DAL',2123,'717','KABQ',3242,3662,'KSLC',3345,3765,3602,'(null)',0),
(192,'BTQ',612,'PL2','KABQ',3234,3654,'KSVC',3282,3702,3594,'(null)',0),
(193,'N531AW',0,'BE30','KABQ',2825,3245,'KONM',2843,3263,3225,'',0),
(194,'N92VA',0,'ER4','KABQ',2769,3189,'KLAS',2798,3218,3169,'',0),
(195,'UPS',797,'AB6','KABQ',2726,3146,'KSDF',2983,3403,3086,'(null)',0),
(196,'UPS',887,'763','KABQ',2718,3138,'KONT',2757,3177,3078,'(null)',0),
(197,'SWA',142,'73G','KABQ',2683,3103,'KDAL',2813,3233,3043,'(null)',0),
(198,'JTL',991,'GR2','KABQ',2653,3073,'KGJT',2699,3119,3013,'(null)',0),
(199,'FDX',1334,'D11','KABQ',2648,3068,'KMEM',2819,3239,3008,'(null)',0),
(200,'SWA',1717,'73G','KABQ',2647,3067,'KLAS',2666,3086,3007,'(null)',0),
(201,'SWA',1595,'733','KABQ',2642,3062,'KPHX',2698,3118,3002,'(null)',0),
(202,'BTQ',616,'PL2','KABQ',2601,3021,'KSVC',2648,3068,2961,'(null)',0),
(203,'BTQ',566,'PL2','KABQ',2594,3014,'KALS',2634,3054,2954,'(null)',0),
(204,'SWA',1157,'73G','KABQ',2544,2964,'KPHX',2606,3026,2904,'(null)',0),
(205,'ASH',5989,'CR7','KABQ',2536,2956,'KDFW',2667,3087,2896,'(null)',0),
(206,'SWA',1469,'73G','KABQ',2534,2954,'KDAL',2670,3090,2894,'(null)',0),
(207,'UPS',2874,'763','KABQ',2528,2948,'KPHX',2586,3006,2888,'(null)',0),
(208,'SWA',206,'73G','KABQ',2520,2940,'KDEN',2574,2994,2880,'(null)',0),
(209,'N912NM',0,'PL2','KABQ',2511,2931,'KFMN',2558,2978,2911,'',0),
(210,'SKW',4499,'CR9','KABQ',2507,2927,'KSLC',2604,3024,2867,'(null)',0)


Edited by tlittle - 12 Jan 2017 at 7:27pm
Back to Top
andrewatc View Drop Down
Senior Member
Senior Member


Joined: 28 Feb 2016
Location: Canada
Status: Offline
Points: 352
Post Options Post Options   Thanks (0) Thanks(0)   Quote andrewatc Quote  Post ReplyReply Direct Link To This Post Posted: 12 Jan 2017 at 9:58pm
Wow awesome list tlittle. How would one go about getting this into the custom file?
SW3, SW4 Captain in CYYC
Back to Top
tlittle View Drop Down
Member
Member


Joined: 09 Jan 2017
Status: Offline
Points: 6
Post Options Post Options   Thanks (0) Thanks(0)   Quote tlittle Quote  Post ReplyReply Direct Link To This Post Posted: 13 Jan 2017 at 6:23pm
You will need SQLite program, per original post. This is still in early stages though but if the devs are okay with it, I could upload the custom.db once it is done and all you would need to do is rename the original custom.db and drop the revised one in...
Back to Top
hnorgaar View Drop Down
Member
Member


Joined: 24 Aug 2016
Status: Offline
Points: 79
Post Options Post Options   Thanks (0) Thanks(0)   Quote hnorgaar Quote  Post ReplyReply Direct Link To This Post Posted: 15 Jan 2017 at 12:10am
I have made a Excel spreadsheet to make it a bit easier and will like to share it with you.
Only thing which doesnt work yet is flights overlapping from Sunday into Monday.
Feel free to use ituploads/184/ATCPRO.rar
Back to Top
Tom@FlagMountain View Drop Down
Admin Group
Admin Group


Joined: 22 Oct 2014
Location: Albuquerque, NM
Status: Offline
Points: 481
Post Options Post Options   Thanks (0) Thanks(0)   Quote Tom@FlagMountain Quote  Post ReplyReply Direct Link To This Post Posted: 19 Jan 2017 at 9:21am
The ATCpro team encourages you to create and share custom flight schedules.
 
Regards
 
Tom Murdock
Flag Mountain Software
Tom Murdock
Flag Mountain Software
ATCpro Project Team
Back to Top
moghost360 View Drop Down
Member
Member


Joined: 26 Apr 2017
Status: Offline
Points: 17
Post Options Post Options   Thanks (0) Thanks(0)   Quote moghost360 Quote  Post ReplyReply Direct Link To This Post Posted: 04 Jun 2017 at 12:53pm
How do I go about pasting a lot of values into SQLite Expert? I can't seem to get it to work; I'm using the excel file provided by hnorgaar. 

Edited by moghost360 - 04 Jun 2017 at 12:55pm
Back to Top
 Post Reply Post Reply Page  12>
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 11.10
Copyright ©2001-2017 Web Wiz Ltd.

This page was generated in 0.125 seconds.