Location Intelligence Module Conversion Utility

The Location Intelligence Module utility has two conversion utilities: FMTMakr2.exe and SpatialImport.exe.

You may need to use one or both utilities to convert your data, depending on the format.

Converting .TXT and .CSV Files

Converting .TXT and .CSV files into the Centrus .FMT format is a two-step process:

First, create a format file (.FMT) for your .TXT or .CSV file using the Data Formatter utility (FMTMAKR2.exe). This utility can be found on the Spectrum™ Technology Platform server in:

<SpectrumInstallLocation>\modules\lim\lib

Note: Field names are limited to 10 characters.

Second, use the SpatialImport.exe utility to import the data into a format usable by Spectrum™ Technology Platform. Follow the instructions in Converting .SHP, TAB, .MIF, and .DBF Files to convert the .TXT or .CSV file. Note that in order for SpatialImport.exe to work with .TXT or .CSV files, the .FMT file created by the Data Formatter utility must be present in the same directory as the .TXT or .CSV file.

Converting .SHP, TAB, .MIF, and .DBF Files

If you are importing an ESRI shapefile (.SHP), a TAB file (.TAB), a MapInfo Interchange Format file (.MIF), or a DBF file (.DBF) for use with the Location Intelligence Module, open a command prompt and type the following:

SpatialImport [-u] InputFile OutputFile [PolygonNameField]

Where:

Note: Field names are limited to 10 characters.

Converting .MDB Files

If you are importing a Microsoft Access (.MDB) file for use with the Location Intelligence Module, type the following:

SpatialImport dbfile.mdb:tablename

Where:

Note: Field names are limited to 10 characters.