Exporting and Importing a Glossary
You can export and import glossaries created from one Data Catalog instance to another.
The glossary file is exported to a bucket in Object Storage and you can download this exported file in the Microsoft Excel file format.
Exported Excel file column headers
- Type: Specifies if the entry is a category or term.
- Parent Path: Specifies the path of the parent category. If the entry is the topmost level category, then the parent path column is null.
- Name: The specified name for a category or term.
- Status: Specifies whether the status of the category or term, at the time the glossary was exported, is new, approved, under-review, or escalated.
- Owner (OCID): Specifies the OCID of the user who owns the glossary category or term.
- Owner (Name): Specifies the name of the user who owns the glossary category or term.
- Description: Specifies the description for the category or term.
- Source Path: Specifies the path of the source term.
- Relationship Type: Specifies the relationship type as parent:child.
- Destination Path: Specifies the path of the destination term.
Creating your own import Excel file
- Define your terms and categories in an Excel sheet named Categories and Terms.
- The Type, Parent Path, and Name column headers are required to successfully import a Excel format glossary file.
- To define custom properties, add columns after the Description column. You
must use the convention
<Namespace>.<Custom Property Name>for custom property column names. Custom Properties is the default namespace. - If the Status column isn't populated, then default value New is set on import.
- If the Owner (OCID) column isn't populated, then it is set to the OCID of the user importing the file to the glossary.
- Only the Owner (OCID) column is considered while importing. The Owner (Name) field isn't read during import.
- Relationships can be defined in a separate Excel sheet named Relationships. If any relationships are defined, then the columns Source Path, Relationship Type, and Destination Path must be populated for each relationship.
- Only Parent:Child relationship type is supported. Any other value is accepted during import but not shown in the user interface.
Note
You can get started with creating your own import file using this Excel template file. The Excel sheet named Metadata has information on creating the import file.
Note
When exporting or importing a glossary, all the data is preserved. Some rich text
formatting may be modified or lost.
Format loss details
The following styles may be lost on import or export:
| Format Loss Details | ||||
|---|---|---|---|---|
| Big | Font-Families | Special Container | Formatted | Cited Work |
| Quote | Sample Text | Italic Title | to-do list | Subscript |
| Subtitle | Marker | Background color | Hyperlinks | Superscript |