apa-logbook-parser Command Reference

apa-logbook-parser

apa-logbook-parser is a tool to transform the XML version of the APA Logbook to other formats.

  1. Go to https://tasc.alliedpilots.org/LogData/LogView.aspx and export/download your logbook in XML format.

  2. try apa-logbook-parser parse <path to XML file> <output directory>

This should output a number of files, including:

  • a formatted version of the original XML data file for easier reference.

  • a json file containing the raw parsed data.

  • a json file containing a flattened version of the raw parsed data.

  • a csv file containing a flattened version of the raw parsed data.

  • a json file containing an expanded version of the parsed data.

  • a json file containing a flattened expanded version of the parsed data.

  • a csv file containing the flattened expanded version of the parsed data.

Most people will only use the csv version of the expanded logbook for import into a spreadsheet. The other formats are included for easier error diagnosis, and future uses.

The expanded format transforms the original data to include:

  • departure and arrival times in both local and utc

  • timezone names for each station

  • durations in 00:00:00 (HH:MM:SS) format for ease of use in spreadsheets.

  • a row number based on the order of flights found in the source XML file.

  • A unique identifier (UUID) based on the original data parsed for each flight.

    This id -should- remain unique through different downloads of a logbook, so long as APAs data does not change.

The data available is limited by the source data. There is no way to determine actual duty in, duty out, or layover location from the data provided by APA.

apa-logbook-parser [OPTIONS] COMMAND [ARGS]...

Options

--debug, --no-debug

Not currently in use.

-v, --verbose

Not currently in use.

parse

Parse an APA logbook XML file, and output in several formats.

FILE_IN - the path to an APA Logbook in XML format.

PATH_OUT - the path to an output directory where the translated logbook files will be written.

try apa-logbook-parser –help for more details.

apa-logbook-parser parse [OPTIONS] FILE_IN PATH_OUT

Options

-o, --overwrite

Allow an existing file to be overwritten.

Default:

False

Arguments

FILE_IN

Required argument

PATH_OUT

Required argument