Import complex relations

Import using the new wizard

1. Open a view.

   Tip For an export-import round trip, open the same view you have used during export.

2. Above the table, to the right, click → Complex Relations.
   The Import dialog box appears.
3. Drag and drop the file or click Upload a file and choose the appropriate Excel file for upload.
4. Click Next.
5. Select the Complex Relation Type from the drop down list.
6. Manage the mapping of the fields of the import file and your Collibra resources:
   1. The Import mapping dialog box appears and Collibra tries to map the table headers in your import file to Collibra resources based on the names of the columns and the available columns in the view you have started the import from.

      Tip If you are performing and export-import round trip, all columns are mapped automatically.

      Learn more about the mapping dialog box.

      

      Field	Description
      Automap	Button to let Collibra automatically map all table headers in the import file to Collibra resources, based on their names.
      Clear	Button to remove all mappings.
      Mapping table	This table enables you to map table headers in the import file to Collibra resources. Each row in the table has a background color to indicate whether the table header is mapped or not. Green: When the table header from the import file is mapped to a Collibra resource the row will be highlighted in green. Red: After clicking the warning about unmapped items these rows will be highlighted in red and moved to a separate section at the bottom of the table. Once a table header in the unmapped section has a mapping selected it will be moved to the green mapped section. You can use the Automap button to automatically map a table header, unless you have already manually changed the mapping. If you manually change a mapping then auto-mapping will not longer override this selection. An individual mapping can be cleared by using the cross icon in the Table Headers column. If a relation type in your file matches with multiple relation types in Collibra then it will not be auto-mapped, meaning you will be required to map this relation type manually. This is to avoid any incorrect mapping.
      Table Headers	This column contains the field name of the table headers in your file.
      Collibra Resources	This column shows to which Collibra resource the file field is mapped. If the field is unmapped then there is a drop down list with the available Collibraresources . For relations, a hierarchy is displayed.
      Complex Relation Type	Select the complex relation type you want to use for mapping.

   2. Click Automap to let Collibra map all previously unmapped columns automatically.
   3. If required, manually map columns to another resource.
      Note When importing new assets, ensure you provide and map the following information:

      • The full name.
      • The asset type.

        Tip The import wizard can determine the asset type of the related assets based on the asset types of the complex relation.

      • The domain.
   4. Click Next.
      The Import options appear.
7. Enter the required information.
   

   Setting	Result
   Test import	Collibra first simulates an import without affecting the data to give you an overview of how the actual import would affect the data. After the overview, you can proceed with the import, go back to change the options or cancel the import.

8. Click the Test Import button.
   The test results appear.

9. If the simulated results match your expectations, click Import.

   Tip If they don't, click Back to change the mapping or import options.

   The import results appear.

10. Click Close.

Import using the old wizard

Important Starting with Collibra version 2023.08, version 2 of the import wizard is enabled by default, while version 1 is no longer available for general use.

Note For the original import wizard, the max file size is restricted to 100 MB.

1. Open a view.

   Tip For an export-import round trip, open the same view you have used during export.

2. Above the table, to the right, click → Complex Relations.
   The Import dialog box appears.
3. Click Select File and choose the appropriate Excel file for upload.
4. Click Next.
5. Select the complex relation type that you want to import.
6. Click Next.
7. Manage the mapping of the columns of the import file and the view's fields.
   1. The Import mapping dialog box appears and Collibra tries to map the columns from the import file with the Collibra resources, based on the names of the columns and the available columns in the view you have started the import from.

      Tip If you are performing and export-import round trip, all columns are mapped automatically.

      Learn more about the mapping dialog box.

      Visual	Number	Field	Description
      	1	Automap	Button to let Collibra automatically map all fields of the view to the columns in the import file, based on the names of the characteristics and columns.
      	2	Clear	Button to clear all mapped characteristics in the Import Column.
      	3	Mapping table	This table enables you to map characteristics of the view to columns of the import file. Each row has a background color to indicate whether a characteristics is mapped or not. Dark green: The characteristic is mapped to a column in the import file. Light green: The relation is mapped partially. This means not all underlying fields are mapped. White: The characteristic is not mapped.
      	4	Characteristic	This column contains the available characteristics. Depending on the selection in the view selector, it contains either the characteristics of the selected view, or all characteristics. For relations, a hierarchy is displayed.
      	5	Import Column	This column should contain fields in which you can choose columns of the import file to map to a characteristic of the view.

   2. If required, choose another view in the view selector.
      
      Tip Choose All characteristics to show all characteristics. In most cases, this makes it easier to map all characteristics.
   3. Click Automap to let Collibra map all visible columns automatically.
   4. If required, manually map columns to another characteristic.
8. Click Next.
   The Import options appear.
9. Enter the required information.
   

   Setting	Result
   Test Import	Collibra first simulates an import without affecting the data to give you an overview of how the actual import would affect the data. After the overview, you can proceed with the import, go back to change the options or cancel the import.

10. Click the Test Import button.
    The test results appear.

11. If the simulated results match your expectations, click Import.

    Tip If they don't, close the dialog box to cancel the import or click Back to change the mapping or import options.

    The import results appear.

12. Click Close.