ATCPro Forums Homepage
Forum Home Forum Home > ATC Pro Forums > ATC Pro Official Support
  New Posts New Posts RSS Feed - Custom traffic
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Custom traffic

 Post Reply Post Reply Page  123>
Author
Message
mofmtl View Drop Down
Member
Member


Joined: 29 Apr 2020
Status: Offline
Points: 17
Post Options Post Options   Thanks (0) Thanks(0)   Quote mofmtl Quote  Post ReplyReply Direct Link To This Post Topic: Custom traffic
    Posted: 06 May 2020 at 9:20am
How do I create a custom traffic list for ABQ?
Back to Top
wheniwasinspace View Drop Down
Member
Member


Joined: 05 Jan 2019
Location: Sweden
Status: Offline
Points: 55
Post Options Post Options   Thanks (0) Thanks(0)   Quote wheniwasinspace Quote  Post ReplyReply Direct Link To This Post Posted: 08 May 2020 at 1:03am
Go to the folder
%ProgramData%\Flag Mountain\ATCpro\Facilities\ABQ
 
"custom.db" is the file you are looking for.

You'll need an editor for SQLite. There are about a gazillion tools out there.
My personal favourite is "DB Browser for SQLite" https://sqlitebrowser.org/ 

You can take a look in the other .db-files in that folder to see how the information is supposed to look.
The trickiest bit is the times. These are in minutes passed since the week started
(I don't rememeber on the top of my head if they use Sunday or Monday as the first day)
But basically time "0" is at midnight on the first day, and  1440(60*24) is midnight the next day, etc etc...

Andrew did a nice guide on edits(not schedules though, but if you aren't already familiar with SQL edits I'd recommend watching it anyways)

regards,
Alexander
Back to Top
mofmtl View Drop Down
Member
Member


Joined: 29 Apr 2020
Status: Offline
Points: 17
Post Options Post Options   Thanks (0) Thanks(0)   Quote mofmtl Quote  Post ReplyReply Direct Link To This Post Posted: 10 May 2020 at 1:31pm
will try. Thank you for the info
Back to Top
mofmtl View Drop Down
Member
Member


Joined: 29 Apr 2020
Status: Offline
Points: 17
Post Options Post Options   Thanks (0) Thanks(0)   Quote mofmtl Quote  Post ReplyReply Direct Link To This Post Posted: 10 May 2020 at 2:22pm
What are the DB fields please?
dICAO
dLocal
dUTC
aICAO
aLocal
aUTC
Back to Top
mofmtl View Drop Down
Member
Member


Joined: 29 Apr 2020
Status: Offline
Points: 17
Post Options Post Options   Thanks (0) Thanks(0)   Quote mofmtl Quote  Post ReplyReply Direct Link To This Post Posted: 10 May 2020 at 5:06pm
and 
loadUTC

Back to Top
wheniwasinspace View Drop Down
Member
Member


Joined: 05 Jan 2019
Location: Sweden
Status: Offline
Points: 55
Post Options Post Options   Thanks (0) Thanks(0)   Quote wheniwasinspace Quote  Post ReplyReply Direct Link To This Post Posted: 11 May 2020 at 7:29am
dICAO=departure airport icao code
dLocal=departure time in local time
dUTC=departure time in UTC

a=same but arrival

The load time I'm not sure about. I'm guessing it the time when the Sim should load the plane into memory.
What I did when creating customs was to look in the schedule files that comes with the game and set my load times to have about the same offset as they did between load and arrival/dep.

Back to Top
mofmtl View Drop Down
Member
Member


Joined: 29 Apr 2020
Status: Offline
Points: 17
Post Options Post Options   Thanks (0) Thanks(0)   Quote mofmtl Quote  Post ReplyReply Direct Link To This Post Posted: 11 May 2020 at 8:58am
Ok, thanks.
But why is there an arrival and a departure field?
Back to Top
wheniwasinspace View Drop Down
Member
Member


Joined: 05 Jan 2019
Location: Sweden
Status: Offline
Points: 55
Post Options Post Options   Thanks (0) Thanks(0)   Quote wheniwasinspace Quote  Post ReplyReply Direct Link To This Post Posted: 11 May 2020 at 9:51am
Wise guy answer: If you board a 737 don't you want it to fly somewhere? ;P

Real answer: the Sim routes the planes as they would likely by routed IRL.
You'd expect planes arriving from Arizona and Texas to enter Albuquerque tracon from different sides of your radar screens.

Likewise. Planes departing KABQ will be given a a SID and/or exit fix depending on destination.

Back to Top
mofmtl View Drop Down
Member
Member


Joined: 29 Apr 2020
Status: Offline
Points: 17
Post Options Post Options   Thanks (0) Thanks(0)   Quote mofmtl Quote  Post ReplyReply Direct Link To This Post Posted: 11 May 2020 at 10:18am
I understand that.
But I am still not very clear on how to fill in all the fields in the Custom DB. 
Is there a specific time sequence they all require? 
Are some arrivals only and others departures only?
Why separate fields for local, UTC, and load?
Back to Top
mofmtl View Drop Down
Member
Member


Joined: 29 Apr 2020
Status: Offline
Points: 17
Post Options Post Options   Thanks (0) Thanks(0)   Quote mofmtl Quote  Post ReplyReply Direct Link To This Post Posted: 11 May 2020 at 10:19am
It would seem Monday is the 1st day of the week in the game
Back to Top
 Post Reply Post Reply Page  123>
  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.