Import from File

Although WRDB contains an editor for entering information into Support tables, you may find it convenient to import and export Support data to and from various file formats. Data are imported using DBCONV from a variety of different programs (see Import Other File ). All Support tables to be imported have similar formats as follows:

Line 1: Keyword (one of the following: Stations, PCodes, CCodes, Branches, Station Group, PCode Group, QCodes)

Line 2: Column headings corresponding to field names in the Support tables (see Section 2.6) or the column heading "IGNORE"

Lines 3 and up: Tabular data, comma and quote delimited

All fields need not be included, but you will get an error message if you don’t include necessary fields (for example, STATION_ID in the Stations table). Support tables are not overwritten, rather they are added to and updated. That means that, for example, new stations can be added, and data for existing stations are updated, but existing stations not found in the import file are unchanged.

See also Support Table Import/Export Example.