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 CA 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 
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 CA 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 CA 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.
|
Copyright © 2013 CA.
All rights reserved.
|
|