Importing and exporting a lookup table
Available from version 8.3 and later.
Import a lookup table from an Excel (.xlsx) or CSV (.csv) file, and export a lookup table to an Excel workbook.
Import a file
Importing needs the MANAGE_LOOKUP_TABLES privilege and the lookup tables feature in your license. An import always writes a whole table: it either creates a new table or replaces every row and column of an existing one.
- New table: on the Lookup tables page, open the dropdown next to Create lookup table and click Import.
- Existing table: select the table and click Import at the top of the panel. Save or cancel your changes first.
Importing into an existing table replaces every row and column of the table. It cannot be undone, so export the table first if you need a copy.
- Under Excel or CSV file, click Browse and select the file.
- Leave The first row holds the column names selected if the file has a header row. Clear it if the first row is data.
- Click Upload.
- For a new table, enter its Name.
- Review the columns. Historian detects each column's type from the values in the file. For each column you can:
- clear Include to leave it out,
- change its name,
- change its type.
- Click Next. Historian shows how many rows will be imported and a preview of them.
- Click Confirm.
If a cell does not match the type of its column, Historian lists the problems with their row numbers and you cannot confirm. Change the column type, or correct the file and import it again.
File rules
- The file can be at most 16 MiB and hold at most 500,000 rows.
- From an Excel file, Historian reads the first sheet.
- A CSV file can use a comma or a semicolon as separator. Historian picks the one used most in the first line.
- An empty cell imports as an empty value.
- A Boolean column accepts true, yes and 1, and false, no and 0, in any case. Excel boolean cells work as well.
- Without a header row, the columns of a new table are named Column 1, Column 2, and so on. Importing into an existing table keeps its column names.
Export a table
Exporting needs the READ_LOOKUP_TABLES privilege.
- Click Lookup tables in the main menu and select the table.
- Click Export at the top of the panel.
Historian downloads the saved rows as an Excel file named after the table. Unsaved changes are not included.