Previous Topic: Auto Hide FeatureNext Topic: Bulk Editor Row-Level Paste


Bulk Editor Row-Level Copy

Use the row-level copy feature of the Bulk Editor to copy selected rows in the Bulk Editor to the clipboard, which can then be pasted into another spreadsheet program, such as Microsoft Excel. This makes it easier to share the data for editing property values, especially if another person on your team needs to perform the edits and does not have access to erwin® Data Modeler. When editing work is complete simply copy the updated rows to the clipboard for pasting back into the Bulk Editor.

The Bulk Editor uses a special textual format so each row and column is unambiguously identified and can be pasted into Microsoft Excel.

The following table represents the textual format used for the Bulk Editor. Three rows were selected in the Bulk Editor, and then the Copy button Copy Selected Rows to the Clipboard Button on the Bulk Editor Toolbar was clicked to copy the data to the clipboard.

erwin Property Ids

1075850516::User Formatted Name

0::Object Type

1073742126::Name

1075849148::Comment

1075839201::241

Certificate_241

Certificate

Certificate_241

A Comment

1075839199::232

Assembly_232

Assembly

Assembly_232

Another Comment

1075839199::235

Assembly_235

Assembly

Assembly_235

 

The data includes a column heading for each column. The column heading contains the internal erwin® Data Modeler property ID and a user-ready name for the property represented by that column.

The data also has an extra column that precedes the other columns. It contains the erwin® Data Modeler object type, two colons, and then the object ID. This information is used during a Paste operation to uniquely identify an object in the model.

More information:

Using the Bulk Editor

Bulk Editor Row-Level Paste