Address Fabric™ Data consists of a tab-delimited text file (address_fabric_usa.txt) to give users flexibility in managing tables and schemas in various database technologies.
Before Address Fabric™ Data can be loaded into MapInfo Pro (versions 15.0 and later), the data file must be associated with the header file:
- Open the MapBasic window in MapInfo Pro by clicking Home >
Tool Windows > MapBasic –
- Download this script, which will be used to create the table structure.
- Edit the script, changing the table name in the template to a recognizable
name, such as us_address_fabric_header. Be sure to change all
instances of the output path for the TAB file and table name:
- Copy the complete template text and paste it into the MapBasic window
- Select all text in the MapBasic window and press Enter. This will create a table containing only headers.
- In MapInfo Pro, click Home > Open > Table
- Set the value of Files of type: to Delimited ASCII (*.txt)
- Select the data text file (us_address_fabric.txt) and click Open
- Set the following parameters in the Delimited ASCII Information dialog –
- Select Other as the delimiter type and enter a pipe character ( | ) as the delimiter option
- Set the value of File Character Set: to Unicode UTF-8
- Leave the Use First Line for Column Titles option unchecked unless you are loading the nationwide file
- Click OK
Note: There is no need to change the delimiter type – the Tab option is selected by default.
- The table will open without headers
- Append the data table to the blank header row table –
- Click Table > Append Rows
- Select the name of the data table from the Append Table dropdown
- Select the name of the header table from the to Table: dropdown
- Click OK
- Save the file once the append operation finishes. Data is now ready for use.