Session 10: Importing Comma Separated Value (CSV) Files

Go Up to Main Page

You can import large amounts of data into EA/Studio using the CSV import wizard. You can include Business Elements, Business Entities, Business Rules, Business Units, Stewards, and Tasks. Using pre-existing templates you can input data into a comma separated value file and then import it into the application.

Templates exist for each object and are available in x:\Program Files\IDERA\ EAStudio\ samples\CSV\Templates. You can open these templates in Microsoft Excel or a text editor to enter data.

1 On the main menu, select File>Import>Comma Separated Values (CSV)… and the CSV Import Wizard opens.

2 Select “Business Units” from the list of available object types.

3 In the Location text box browse to x:\Program Files\IDERA\ EAStudio\Samples\CSV\Data\Great West Bank\Great West Business Units.csv and click Open.

4 Select “Business Units” from the list of available object types.

5 In the Location text box browse to x:\Program Files\IDERA\ EAStudio\Samples\CSV\Data\Great West Bank\Great West Business Units.csv and click Open.

6 When you click Next an Import Summary dialog opens displaying all the records that have been imported.

7 Click Finish and a CSV Import Complete notification dialog opens telling you how many elements were created in EA/Studio.

8 If you are importing reference objects, once you close the notification dialog, the imported elements are placed under the appropriate Reference Object node in the Model View tree. In our example, three imported elements were placed in the Business Units node.

9 If you are importing Tasks and Entities, they are placed in a model. You will be prompted where to place them on the next page of the Import Wizard.

10 Once imported, you can then drag these elements on to an existing diagram. When you double-click on an element, the Property View for that element opens displaying the imported data.

Session 10 Conclusion

In this session, you have learned how to import a comma separated value file.

Session 11 discusses the Create Links and Usages functions.