Importing dictionary entries

Signavio supports the import of dictionary entries from Microsoft Excel (.xls or .xlsx) files.

The file needs to be structured like this:

Necessary structure of a spreadsheet that is to be imported into Signavio.

Necessary structure of a spreadsheet that is to be imported into Signavio.

The column headers mark the dictionary attributes. In case you want to import multiple languages, you might want to add the language code to the column headers. Please notice that the column header text doesn’t need to be equal to the attribute name in Signavio, as the mapping will be configured later on.

Each spreadsheet of the Excel file represents one dictionary category. Subcategories are treated the same way as main categories. When importing multiple categories, it is necessary to repeat the import process for each category.

In order to gain the spreadsheet template, you can export dictionary entries as an Excel file and use the export file as a reference for the import file structure.

In order to import dictionary entries, click the entry Dictionary at the bottom of the folder tree on the left in the Signavio Explorer. The Dictionary opens:

Navigate to the Dictionary.

Navigate to the Dictionary.

Now, click Import/Export, then Import Excel in the drop-down menu:

Open the import dialog.

Open the import dialog.

You will be asked to select the spreadsheet from your computer. Click Choose File:

Click 'Choose File'.

Click ‘Choose File’.

Select the file you want to upload. Please make sure the file is a Microsoft Excel file with the file extension .xls or .xlsx.

Click Open:

Select the file you want to import.

Select the file you want to import.

Now, click Import:

Click 'Import'.

Click ‘Import’.

The import configuration dialog opens.

Here, you need to select whether you want to update dictionary entries, to create new entries or to create new entries and to update existing entries:

Select between update, create or both.

Select between update, create or both.

Next, you need to select the to-be imported spreadsheet and to define the mappings between spreadsheet and the Signavio dictionary. Please note that the Id mappings are only relevant in case you want to update existing entries:

Map spreadsheet column headers to Signavio dictionary attributes.

Map spreadsheet column headers to Signavio dictionary attributes.

Click Import to start the automatic import process.

As soon as the import has been executed, you will receive a summary as well as a download link to the imported Excel file, which contains the details of the import process:

A summary of the import will be displayed.

A summary of the import will be displayed.