21. Logbook

Little Navmap creates logbook entries for each flight automatically when detecting a takeoff or landing. A logbook entry containing only departure is created on takeoff and finalized with destination and more information on landing.

Check Create Logbook entries to enable this functionality which is default.

Note that all times, fuel consumption and other values are measured between takeoff and landing since it is not reliably possible to detect the start and end of a flight.

Use Reset all Settings and Restart to be sure that the logbook flight detection is set up for a new flight.

Editing functionality in the logbook is similar to the userpoints editing (Userpoints).

21.2. Add Logbook Entry

Allows to create a new log entry manually. The dialog layout and functionality is the same as for editing logbook entries. The button Reset clears all fields.

21.3. Edit Logbook Entry

The dialogs for editing and adding are equal and contain three tabs.

Most fields have a tooltip explaining the meaning, are optional and can be freely edited.

The button Reset undoes all manual changes and reverts all fields back to the original state.

21.3.1. Tab Logbook Entry

Additional notes about some fields on this page:

  • Departure and Destination: These are automatically resolved to an airport. Coordinates (not shown and not editable) are assigned to the departure or destination airport if found. The dialog will show the airport name and elevation if the airport ident can be resolved. Otherwise an error message is shown.
  • Date and Time in Simulator UTC: Time set in the simulator on liftoff or touchdown. Always UTC.
  • Real local Time: Real world time on liftoff or touchdown. Stored in your local time.
  • Route Description: Flight Plan Route Description extracted from the flight plan.
  • Flight plan file and Aircraft performance file: Used flight plan and performance files. These are only references which will turn invalid if the files are moved or renamed.

21.3.2. Tab Fuel and Weight

Block fuel and trip fuel are extracted from Tab Fuel Report.

Used fuel is the fuel consumption between liftoff and touchdown.

21.3.3. Tab Description or Comments

Links are recognized in the field Description or Comments and can be opened in the dock window Information on tab Logbook which is shown after clicking on a logbook entry or selecting Show Information in one of the context menus.

Normal web links like http://www.example.com or https://www.example.com are recognized besides directory or file links like file:///C:/Users/me/Documents/Aircraft%20Notes.txt on Windows or file:///home/me/Aircraft%20Notes.txt on macOS or Linux.

Note that you have to use the forward slash / instead of the backslash \ on Windows as a path separator.

Replace spaces in links with %20 since Little Navmap recognizes links until the next space.

21.3.4. Edit a single Logbook Entry

_images/logbook_edit.jpg

Editing a logbook entry.

21.3.5. Edit multiple Logbook Entries

If more than one logbook entry was selected for editing, the edit dialog shows a column of checkboxes on the right side of available fields. Not all fields are available for bulk edit.

If checked, the field to the left is unlocked and any text entered will be assigned to the respective field in all selected logbook entry. Unchecked fields will not be altered for any of the selected entries.

In combination with the search function, this allows for bulk changes like fixing an invalid aircraft type.

_images/logbook_bulk_edit.jpg

Editing more than on logbook entry. Three fields are to be changed for the selected entries.

21.4. Logbook Statistics

This dialog shows two tabs:

  1. Overview contains a general report which can be copied as formatted text to the clipboard.
  2. Grouped Queries has a button on top which shows different reports in the table below. The content of the table can be copied as CSV to the clipboard.
_images/logbook_stats.jpg

Overview tab of logbook statistics dialog.

21.5. Import and Export

The full logbook can be imported and exported to a CSV (comma separated value) text file which can be loaded in LibreOffice Calc or Microsoft Excel. All data can be exported and imported which allows to use this function for backup purposes.

Note that it is not possible to export a selection similar to the userpoints. Only the full logbook can be exported. Import appends the logbook entries from the CSV file to already present logbook entries.

Export and import can be done by using the menu items Import CSV and Export CSV.

See chapter CSV Data Format below for more information on the format.

21.6. X-Plane Import

Imports the X-Plane logbook file .../X-Plane 11/Output/logbooks/X-Plane Pilot.txt into the Little Navmap logbook database. Note that the X-Plane logbook format is limited and does not provide enough information to fill all Little Navmap logbook fields.

The imported logbook entries get a description containing Imported from X-Plane logbook X-Plane Pilot.txt which allows to search for the imported entries. Use a pattern like *Imported from X-Plane logbook X-Plane Pilot.txt* in the description search field to look for all imported entries.

Available information in the X-Plane logbook:

  1. Date of flight
  2. Departure airport
  3. Destination airport
  4. Number of landings - added to description.
  5. Duration of flight
  6. Time spent flying cross-country, in IFR conditions and at night - added to description.
  7. Aircraft tail number
  8. Aircraft type

X-Plane logbook example:

I
1 Version
2 190917    EDDN    ESNZ   4   0.8   0.0   0.0   0.0  C-STUB  727-100
2 190917    ESNZ    ESNZ   0   0.1   0.0   0.0   0.0  C-STUB  727-100
2 190920    LSZR    LSZR   0   0.2   0.0   0.0   0.0    SF34

21.7. Conversion

Automatically converts all legacy log entries that were collected as userpoints having type Logbook. The conversion copies them to the new logbook after showing an information dialog.

The conversion works best if field Description in the userpoints was not modified and if no entries were inserted manually.

The converted logbook entries are appended to the current logbook. The original userpoint of type Logbook are not deleted or modified.

The converted logbook entries get a description containing Converted from userdata which allows to search for the imported entries. Use a pattern like *Converted from userdata* in the description search field to search for all entries.

Not all values can be recovered but the original description from the userpoint is stored in the description of the new logbook entry.

A warning dialog is displayed after the conversion which shows any issues during conversion.

_images/logbook_conversion.jpg

Warnings shown after converting userpoints to logbook entries.

21.8. Database Backup Files

Little Navmap creates a full database backup on every start since undo functionality is not available for logbook entries.

You can also use the CSV export to create backups manually since CSV allows to export the full dataset.

See Logbook for information about database backup files.

21.9. CSV Data Format

English number format (dot . as decimal separator) is used in import and export to allow exchange of files on computers with different language and locale settings.

Little Navmap uses UTF-8 encoding when reading and writing files. This is only relevant if you use special characters like umlauts, accents or others. Otherwise encoding does not matter.

If an application fails to load a CSV file exported by Little Navmap, use LibreOffice Calc, Microsoft Excel or any other spreadsheet software capable of reading and writing CSV files to adapt the exported file to the format expected by that application.

See Comma-separated values in the Wikipedia for detailed information on the format.

Altitudes are always feet and distances are always nautical miles in the exported CSV.

The first line of the CSV contains the field names.

Field name Description
aircraft_name Free name like Cessna 172
aircraft_type ICAO type descriptor like B732
aircraft_registration e.g. N12345
flightplan_number Flight number if available
flightplan_cruise_altitude Flight plan cruise altitude in feet
flightplan_file Full path to flight plan file
performance_file Full path to performance file
block_fuel From aircraft performance - lbs
trip_fuel As above
used_fuel As above
is_jetfuel Calculated from aircraft fuel, 1 is jet fuel
grossweight Weight at takeoff, lbs
distance Flight plan distance in NM
distance_flown Actual flown distance in NM
departure_ident Airport ICAO code
departure_name Airport name
departure_runway Runway if available
departure_lonx Coordinates if available and airport resolves
departure_laty As above
departure_alt Elevation in feet
departure_time Real world departure time in local time
departure_time_sim Simulator departure time in UTC
destination_ident Same as above for destination
destination_name As departure
destination_runway As departure
destination_lonx As departure
destination_laty As departure
destination_alt As departure
destination_time As departure
destination_time_sim As departure
route_string ICAO route description
simulator X-Plane 11, Prepar3D v4, etc.
description Free text by user