Manage Lookup Tables

Create, edit, delete, import and export Lookup Tables used for mapping items to and from other systems.

Manage / Configuration / Lookup Tables

None

The following controls are available.

Control	Description
Type	Select the type of Lookup Table.
	Import a Lookup Table.
	Export the selected Lookup Table.
	Create a new Lookup Table.
	Edit the selected Lookup Table.
	Delete the selected Lookup Table.

The following types of lookup tables are available.

The following file types are supported for import.

The Type of lookup table selected determines the file types that can be imported.

• Lookup Tables can be used to map data when importing from or exporting to other systems.
• Different types of Lookup Table are used to map attributes, blocks, polygon hatching, layers (codes), line styles and plan symbols.
• For a line style lookup table, leave the box empty to map to or from a solid(continuous) line style.
• For an attribute lookup table, leave the box empty to prevent the attribute from being imported or exported.
• Use any separator (not just a comma), when importing data in the comma delimited (.csv) format. See Example 2 below.

The following are examples of Lookup Tables that can be imported using Comma Delimited (.csv) format.

The first item in each row is the name in the local project and the second the name on the foreign file.

Example 1

Fence,903
Natural Surface,104
Culvert,301
Drain,305

Example 2

Header lines can be included providing they start with a # character. Use this to add a name, description or use a different delimiter.

# Name="Field to office" Desc="Convert from field codes to layer names" Delimiter=":"
#Local:Foreign
Natural Surface:104
Culvert:301
Drain:305

• Edit Lookup Table
• Manage Configuration