Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Manual tasks to perform if the batch file does not work for you or anybody on the team:

Download the Tab Delimited Data sdr zip files (lower list of files on the screen)from 2015 to 2030, from https://av-info.faa.gov/dd_sublevel.asp?Folder=%5cSDRS

unzip the zip files:

...


Open the DATA.TXT file in excel

These three steps are the quickest way to open the DATA.TXT the same way the batch file does:

  • Go to a command prompt (does not have to be as an admin).

  • cd \Program Files (x86)\Microsoft Office\root\Office16

  • run the command: excel

...

  • C:\DATA\FAA\DATA.TXT

...

The data in DATA.txt will now look like similar to this. Notice the ENTRY_DATE is our leftmost value.

...