Skip to content
Alexander Barthel edited this page Oct 31, 2017 · 8 revisions

Navdatareader User Manual

Navdatareader is a command line tool that allows to create a full SQLite navigation database for Little Navmap from various sources which are FSX (all versions), Prepar3D (all versions), X-Plane 11 and Navigraph.

The tool allows detailed configuration of included content as well as simple validation and reporting mechanisms.

Command Line Options

Usage: navdatareader [options]

-h, --help

Displays a brief help for the command line options.

-v, --version

Displays version and revision information about the program.

-f, --flight-simulator type

Required option. Flight simulator type or other data source. Valid values are:

  • FSX: Microsoft Flight Simulator X. SP2 or Acceleration.
  • FSXSE: Flight Simulator - Steam Edition.
  • P3DV2: Lockheed Martin Prepar3D v2
  • P3DV3: Lockheed Martin Prepar3D v3
  • P3DV4: Lockheed Martin Prepar3D v4 and version 4.1.
  • XP11: X-Plane 11.
  • DFD: A SQLite database containing navigation data.

-s, --scenery scenery.cfg file

Optional FSX or Prepar3D Scenery.cfg file. The location of this files is automatically determined by registry entries if not given.

-b, --basepath base path

Required option for X-Plane data compilation.

Optional FSX or Prepar3D base path for BGL files. This path is automatically determined by registry entries if not given.

-d, --source-database database

Required option for a DFD based compilation. Path and name of an extended DFD database.

-o, --output database file

Output Sqlite database filename. The default is navdata.sqlite in the current directory.

-c, --config configuration file

Extended configuration file for Navdatareader. Default is to use built-in navdatareader.cfg.

Examples

Read a FSX scenery database from the default places which are determined by the registry entries of FSX and write the Little Navmap database to navdata.sqlite in the current directory:

navdatareader.exe -f FSX

Read a Prepar3D version 4 database from non standard places. A Prepar3D installation is not needed in this case. The scenery database files are sufficient. The Little Navmap database is written to navdata.sqlite in the current directory:

navdatareader -f P3DV4 -b C:\Simulators\P3DV4 -s C:\ProgramData\P3DV4\Scenery.CFG

Read X-Plane scenery data from C:\My Programs\X-Plane 11 and write the Little Navmap database to D:\navdata-xp11.sqlite:

navdatareader -f XP11 -b "C:\My Programs\X-Plane 11" -o D:\navdata-xp11.sqlite

Files

Logs

The program writes two log files into the current execution directory:

  • abarthel-navdata_reader.log: Contains all messages that are also printed on the command line.
  • abarthel-navdata_reader-err.log: Contains warning, critical and fatal messages only.

Log file names are rolled on each execution of the program. A maximum of five log files is kept.

Navdatareader Configuration

This configuration file (option -c) allows an in-depth configuration of the included features. Note that not all features/filters are available for all simulator/source types.

This file is normally only needed for debugging or development purposes.

The file is Ini-style and all options are commented.

# Database - Currently not used - SQLite only
[Database]
Type=QSQLITE
ConnectionName=
ConnectionOptions=
HostName=
Port=
UserName=
Password=

[Options]

# Show statistics
DatabaseReport=true

# Fail if most important tables are not populated
BasicValidation=true

# Process airport deletesDatabase - only FSX/P3D
ProcessDelete=true

# filter out dummy runways - only FSX/P3D
FilterRunways=true

# Write incomplete objects - only FSX/P3D
SaveIncomplete=true

# Connect airways
ResolveRoutes=true

# Create routing application tables
CreateRouteTables=true

# Debugging options - slows compilation down and creates huge log files
Verbose=false

# Debugging option - Commit after each update - very slow
Autocommit=false

# Delete duplicates
Deduplicate=true

# Vaccuum database
VacuumDatabase=true

# Gather schema statistics
AnalyzeDatabase=true

# Tables names and minimum number of rows
# An exception is throw if the tables have less rows
# The numbers below are the common minimums for bare FSX and DFD database
[BasicValidationTables]
airport=13000
airport_file=0

[Filter]
# Not all filters are applied to the X-Plane compilation and none to the DFD compilation.
#
# If include filter is set only the listed features are loaded
# If exclude is set all listed features as excluded
# Exclude has priority before include
# All filters are case insensitive, comma separated and use globbing expressions
# ?	Matches any single character
# *	Matches zero or more of any characters
# [...]	Sets of characters can be represented in square brackets

# Filter files by name excluding path  - only X-Plane and FSX/P3D
# Examples: BNXWorld?.bgl or APX45*.bgl or FTX_NZSI_Unlisted_Airstrips.BGL
IncludeFilenames=

# FSX filename prefixes: - only X-Plane and FSX/P3D
# Exclude DEM, bridges and other scenery per default
ExcludeFilenames=brx*,obx*,cvx*,dem*

# Filter files by path relative from scenery.cfg minus the scenery directory - only X-Plane and FSX/P3D
# Example: Addon Scenery/JetwayExclude/*,Scenery/0501/*,Scenery/0601/*
IncludePathFilter=
ExcludePathFilter=

# Filter airports three or four letter ICAO ident - only X-Plane and FSX/P3D
IncludeAirportIcaoFilter=
#EDVK EDXW
ExcludeAirportIcaoFilter=

# Filter by object type. Some combinations of this can result in unexpected behavour  - only X-Plane and FSX/P3D
# that is caused by the hierarchical dependency of objects. E.g. filtering out runways
# will also remove approaches and ILS.
# Possible values are:
# AIRPORT, RUNWAY, HELIPAD, START, APPROACH (and transitions), APPROACHLEG (and transition legs),
# COM, PARKING, ILS, VOR, NDB, WAYPOINT, AIRWAY, MARKER, APRON, APRON2, APRONLIGHT, FENCE, TAXIWAY, ROUTE,
# GEOMETRY (apron and apron light geometry), BOUNDARY (airspaces)
IncludeBglObjectFilter=
ExcludeBglObjectFilter=FENCE,APRONLIGHT,APRON2,TAXIWAY_RUNWAY,VEHICLE

# Filters that define if an airport is defined as addon or not
IncludeAddonPathFilter=
ExcludeAddonPathFilter=Scenery/*

Links

The source code for this application is available at Github:

The manual is available online:

Navdatareader User Manual

License {#license}

This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program. If not, see http://www.gnu.org/licenses.


Last updated 2017-10-31T23:19+01:00

Clone this wiki locally