Importing Data Exported from the Grid Editor

Go Up to Grid Editor

You can import Comma Separated Value (CSV) files containing Reference Objects that you have exported from a Grid Editor. This function is useful when you have many Reference Objects of a certain type that you want to use in another workspace or make available to another user. You can export that information and then make it available to be imported without the burden of re-entering the data.

The exported CSV files from ER/Studio BA can only contain one type of exported Reference Object. For example, you could export all your Business Rules contained in a workspace and your exported file would only contain those Business Rules. Once imported, these objects are placed in the appropriate folder (i.e., Business Rules) in the Model View tree.

1 Open the workspace where you want to import the csv file.

2 Choose File > Import > Comma Separated Values (CSV)... from the main menu

OR

Right-click the Reference Object node where you want to place the imported objects and select Import Comma Separated Values (CSV)....

The CSV Import Wizard opens.

3 Select the object type you want to import from the Available Object Types list. This object type must match the object types you exported.

4 Browse to the location of the previously exported Grid Editor file and select the file you want to import.

5 Click OK and then click Next.

• If there are elements that exist with the same name the Possible Duplicate Elements dialog opens. You can choose to create a new element with a unique name or update the existing element. When updating existing elements the following will occur: (1) Elements in the project having corresponding objects in the import are updated with new information; and (2) Objects in the import without corresponding element in the project are added to the project as new element.
• If there are problems with the import, a Problems in File dialog opens. A table lists any errors, warnings, or information, as well as the line number of the problem.

• Click Launch Editor to open the application associated with the CSV extension, where you can view and correct any problems.
• Once you have corrected the problem click Revalidate.

6 If the import is successful, 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 ER/Studio BA.

8 Once you close the notification dialog, the imported elements are placed under the appropriate node in the Model View tree.

9 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.