Data dictionary import and export

Import and export

Move domain and dictionary entries in and out with Excel, and back up or restore a whole asset as JSON.

Two separate paths

There are two ways to move data, and they work on different units.

Path	Unit	Where
Excel (.xlsx)	Entries (rows) inside an asset	The grid toolbar in the asset detail
Backup (.json)	The whole asset	The export button in the asset detail, and the import button on the list screen

Excel fills the contents of an asset that already exists; a backup creates the asset itself.

Excel export

Download Excel in the grid toolbar exports the current entries as a workbook.

Excel download and upload buttons in the asset grid toolbar

Sheet names are fixed as Domain and Dictionary, while headers are written in the current UI language. A file exported in Korean can still be imported from an English UI.
Types, Y or N flags, standard functions and domain names are offered as cell dropdowns.
The domain column of a dictionary sheet exists only when the dictionary pins a domain pack.

Excel import

Pick a file under Upload Excel and a preview appears before anything is applied. Starting from scratch, use download blank template.

Counts of added, modified, unchanged and excluded rows are shown first.
Changes can be selected row by row, with the old and the new value side by side.
Applying still leaves a draft. Save to commit it.

An entry with a matching name is treated as a modification, and an unknown name as an addition. Rows excluded as errors are not applied, so fix the file and upload again.

Common errors

Message	What to do
A required value is empty	Fill in the columns that cannot be blank, such as name, type and nullability.
Not a number, or not Y or N	Length and scale take numbers; flag columns take Y or N.
Duplicated in the file, or already used by another entry	Names and abbreviations cannot collide. Check both inside the file and inside the asset.
Unsupported type, or a type that takes no length or scale	Pick from the type dropdown and fill in only what that type accepts.
No domain pack is pinned, or the domain is not in the pack	Pin a domain pack on the dictionary first, then use a domain name from that pack.
The word is not in the dictionary	Related word and antonym columns accept only names registered in the same dictionary.
The file was exported from a different kind of asset	Upload a domain file to a domain asset and a dictionary file to a dictionary asset.

Backup export

Export at the top right of the asset detail downloads the whole asset as a JSON file. For a dictionary, the pinned domain pack information is included as well.

Excel works row by row and therefore lives in the grid toolbar, while the backup, which handles the whole asset, sits at the top of the detail screen.

Creating an asset from a backup

Import at the top left of the data dictionary management screen takes a backup file, shows the kind, name and entry count, and creates a new asset from it.

Creating a domain or dictionary from a backup file

You are warned in advance if the name is already taken.
If a dictionary backup carries domain pack information, that pack is created alongside it, or reused when the same pack is already on this device.
If the pack cannot be found, the asset is created without domain assignments.

Files exported by an older format cannot be restored. Export again from a current version.