ArchiMate®, ERD, and UML® model data can be imported from an Excel workbook into Enterprise Studio using an Excel connection.
If import feedback has been activated for the connection, import may take more time.
The import function does not check for collaboration conflicts. If one or more of the objects you are importing were claimed when the import is running, no data will be imported. However, this is not explicitly reported by the import. It will only show the message that the import has finished, and the Messages window will show any collaboration conflicts. Because of these, all changes will be reverted.
So please make sure there are no outstanding claims by removing other users' claims or have users commit their changes before you start importing.
- In the connection view, select the Excel connection, and then click
- Navigate to the Excel file you want to import, select it, and click Open. A message appears announcing the import.
- Click OK to start the import.
Upon import, the connection is validated first. If validation is (partly) successful, import from Excel starts. If the import is completed, a message confirming this appears. Click OK to close the message.
If validation fails, a message appears indicating errors have been found in the definition of the connection. Make your choice:
Click Yes to resolve the validation errors and warnings. After that you can start the import again.
Click No if you want to continue the import without resolving the errors. It may result in an incomplete data import, or no import at all.
Click Cancel if you want to cancel the import process.
If reporting has been activated in the connection settings, the Import from Excel window appears showing a summary of the import in a table.
Table with a summary of an import from Excel
If import feedback has been activated in the connection settings, then the Excel file is also opened. It contains feedback on the data you have imported with different colors and comments in the worksheets.
Example of feedback in an Excel file after import
ArchiMate® is a registered trademark of The Open Group.