Import Utility for Terrain Navigator and Terrain Navigator Pro 3.0 or later
FormatMXF was written to correct common problems found in user-created .MXF (Marker eXport Format) files for Terrain Navigator/Terrain Navigator Pro. In addition, it will convert .CSV files created with Microsoft Excel to .MXF.
What is a .MXF file?
A .MXF file is a list of coordinates that are to be imported into (or exported from) Terrain Navigator/Terrain Navigator Pro as a list of Markers. This allows transferring of Marker data (positions, names, etc.) into other applications. Since there is no accepted standard for this sort of information interchange, we have created and documented our own transfer format.
Run the FormatMXF application and an Open dialog will appear. Select the .MXF (or .CSV/.TXT) file you wish to format and press Open. The application will process the file and ensure its compatibility with Terrain Navigator/Terrain Navigator Pro. Once processed, the resulting .MXF file can be imported into Terrain Navigator/Terrain Navigator Pro via the Import command found under the File menu.
FormatMXF will correct the following problems commonly encountered in a user-created .MXF file:
1. Ensures the file has the proper extension.
2. Verifies Latitude / Longitude is in Decimal Degrees.
3. Corrects Latitude / Longitude sign problems (Positive Lat. / Negative Long.)
4. Removes any quotation marks in text fields.
5. Removes any quotation marks that surround the Latitude/Longitude fields.
6. Removes any quotation marks that surround the entire line.
7. Ensures text fields are encased in a single set of quotation Marks.
8. Ensures non-text fields are not encased in quotation marks.
9. Creates default Name (if it is left blank)
10. Creates valid, empty fields for ShortName and Description.
11. Fills in default values for Color and Symbol if those fields are left blank.
12. Validates optional time field.
FormatMXF will NOT convert coordinates that are not in the Decimal Degrees format. Be sure that your coordinates are in this format before running FormatMXF. See the Terrain Navigator/Terrain Navigator Pro electronic documentation for a discussion on Lat./Long. formats.
Using with Excel
Microsoft Excel is a very popular application for editing .MXF files. However, when these files are saved, Excel does not format the file correctly, adding extra quotation marks around text fields and doing other odd things. When a .MXF file is saved from Excel as a .CSV file, FormatMXF will create a new .MXF file from the .CSV file, while correcting for these problems.
Details of the .MXF specification can be found in the electronic manual for Terrain Navigator/Terrain Navigator Pro. Click Help, Contents, and in the Markers section, see "Marker Text File Format (.MXF)" for a detailed overview of this file format.
FormatMXF was created based on the need of several users for a simple utility that would convert Excel-created .CSV files to .MXF. Although we are happy to provide this application to our users, we make no warranty over it and can not provide exhaustive technical support for its use.
03/21/00 - Original release
01/02/01 - Version 1.1 - Added more robust quotation solutions
11/14/02 - Version 1.2 - Added more robust handling of quotation marks within fields.
02/23/06 - Version 1.3 - Added support for skipping completely bogus lines of data.
04/24/06 - Version 1.4 - Modernized display during conversion process
01/13/12 - Version 1.5 - Added support for additional colors; Added support for (optional) time data field
01/16/12 - Version 1.6 - Updated documentation; Added warning before existing file is overridden
09/19/12 - Version 9.2 - Changed version scheme to match TNP; Improved CSV conversion
Related Technical Documents
MXF Conversion Tools: ASCII, DAT, POS, ATT
Marker (MXF) File Import/Export Format
Symbol Key for .MXF/.RXF Files