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.
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. Each record of a spreadsheet represents one dictionary entry.
In order to gain the spreadsheet template, export to Excel file (Exporting dictionary entries) 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:
Now, click Import/Export , then Import Excel in the drop-down menu:
You will be asked to select the spreadsheet from your computer. 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. Note that the file import is limited up to 500 records per Excel spreadsheet. If you want to import more records, split them into several spreadsheets.
Click Open :
Now, 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:
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:
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: