Topic
Prev Next

Import Reference Data

It is possible to import reference data into your model from an .XML file that was exported from another model or from an iteration of the current model, either:

  • Manually, whenever you know there is new or changed data to apply, or
  • Automatically whenever the model is reloaded into Enterprise Architect (if the file has changed since the previous import)

The automatic import checks if the source file has changed since the last import; if the file has not changed, the import does not proceed. If the file has changed, the changed data is imported; however, you can configure the system to display a prompt for you to allow or cancel the import.

Access

Ribbon

Configure > Model > Transfer > Import Reference Data > Import File

Configure > Model > Transfer > Import Reference Data > Shared File

Menu

Project > Data Management > Import Reference Data > Import File

Project > Data Management > Import Reference Data > Shared File

Import reference data manually (Import File)

Step

Action

See also

1

On the 'Import Reference Data' dialog, click on the 'Import File' tab and on the Select File button, then select the filename to import data from.

This would be an XML file produced by the Enterprise Architect Data Exporter.

Export Reference Data

2

If you have selected a valid file, a list of available tables to import displays in the 'Select Datasets to Import' panel.

3

Click on one or more of the tables to import.

Press Ctrl or Shift to click on multiple tables.

4

Click on the Import button to start the process.

A message displays when the import is complete; generally the process is quite fast.

Import reference data automatically (Shared File)

Step

Action

See also

1

On the 'Import Reference Data' dialog, click on the 'Shared File' tab.

2

If you are changing an existing configuration to import from a different XML file, click on the Clear button to clear the dialog fields.

3

Click on the Select File button and browse for the filename to import data from.

This would be an XML file produced by the Enterprise Architect Data Exporter.

Export Reference Data

4

If you have entered the name of a valid file, a list of tables to import displays in the 'Datasets in File' panel.

Click on one or more of the tables to import. Press Ctrl or Shift to click on multiple tables.

5

If you prefer to control whether or not the automatic import takes place, select the 'Always prompt before import' checkbox.

6

Click on the Import button to import the reference data now, and to enable the automatic check and import for subsequent reloads.

Notes

Concerning General Types data:

  • For Statuses, Constraints, Requirements and Scenarios, the imported data is merged with the existing data; if a record already exists it is updated to the new values, and if the record does not exist, a new record is added - records are never deleted
  • For Constraint Status Types, Difficulty, Test Status and Priority, the complete existing list is replaced by the imported list

Concerning Calendar events and event types, Team Review configurations, Patterns and Gap Matrix Profiles:

  • The imported data is merged with the existing data; if a record already exists it is updated to the new values, and if the record does not exist, a new record is added - records are never deleted

Concerning Images; for MS SQLServer Repositories:

  • Importing images as reference data into a SQLServer repository is not supported when connected via Cloud Services
  • To import images as reference data you must have additional MS SQL Server permissions, so that you can perform 'Set Identity On/Off' commands; the role of db_ddladmin provides the required permissions; however, this approach might not be allowed in your environment, so discuss this requirement with your DBA to find an appropriate solution