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  <123
Tom@FlagMountain View Drop Down
Admin Group
Admin Group

Joined: 22 Oct 2014
Location: Albuquerque, NM
Status: Offline
Points: 509
Post Options Post Options   Thanks (0) Thanks(0)   Quote Tom@FlagMountain Quote  Post ReplyReply Direct Link To This Post Posted: 02 Dec 2018 at 12:16pm
Just for everyone's enlightenment, the ATCpro flight traffic was created using FlightAware.  If you have a custom database that is more entertaining/challenging, the please post it.


Tom Murdock
Flag Mountain Software
ATCpro Project Team
Back to Top
Sath_99 View Drop Down
Senior Member
Senior Member

Joined: 24 Feb 2016
Location: Holland
Status: Offline
Points: 181
Post Options Post Options   Thanks (0) Thanks(0)   Quote Sath_99 Quote  Post ReplyReply Direct Link To This Post Posted: 08 Feb 2019 at 8:49am
Originally posted by hnorgaar hnorgaar wrote:

Hi moghost360

You cant use SQLite Expert for this, so

1. Download for your operating system and install it
2. Open the Excel spreadsheet I made and go to the schedule tab. Right click on the schedule tab in the bottom and press "Move or copy sheet", then chose New Workbook in "To Workbook" and mark "Create a copy".
3. Now remove the first 2 lines in the new sheet and save the new document as a csv file with the name "Schedule"
4. Now open the custom.db in "DB Browser for SQLite" and chose the "Browse data" tab, go to file, "import and table from csv file", and import the schedule.csv you just created.
5. Done and enjoy

Remember that import will ADD data to existing data, so either clean the the custom.db dirst or the lines will be added.

I've created a custom database for KTYS with the help of Henrik's Excel sheet.
One thing i've noticed that the save function to an *.csv file, i ihave to define the rows 
dLocal, dUTC, aLocal, aUTC, loadUTC as a number with no decimals, otherwise the import function will not work leading to empty cells and creating an error message in ATCPro.

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.094 seconds.