CA ERwin Data Modeler r8 New Feature Guided Tours › Bulk Editor and Bulk Editor Wizard › Basic Bulk Editor Operations

Basic Bulk Editor Operations

Use the following steps to become familiar with basic Bulk Editor operations.

  1. Using the vertical “splitters” between the displayed column headers feel free to adjust the width of any displayed column for better viewing of the selected metadata.

    Note: Clicking on a column header will override the row ordering you specified in the Bulk Editor Wizard and sort the row-level metadata either alphabetically or reverse alphabetically.

  2. Click in a metadata cell (such as Name or Comment) and make some in-line edits. Click the Click the Expand button to open editing dialog icon to open a larger editing window so you can change the metadata value.

    Note: You can launch the macro toolbox (via the menu icon) to include macros in your changed metadata. When you complete your change, click the OK button to close the window and display your change in the Bulk Editor.

  3. Enter text in the search box at the top of the Bulk Editor (search box reads: “Enter filter text”) to search for and limit the Bulk Editor display to only those rows containing the entered text.
  4. Enter a new (or updated) comment (or similar) value on the first row displayed.
  5. Right-click on the updated comment (or similar) value and then select Copy this cell on the pop-up menu.
  6. Using standard Windows selection keystrokes select several or all displayed rows.

    Note: Use the first column in the Bulk Editor to do this.

  7. Right-click on any one of the selected rows and then select Paste to...all selected rows on the pop-up menu to populate the change made in Step 4 to all selected rows.
  8. Remove the filter criteria entered in Step 3 (delete the entered search value) and verify the changes made in Step 7 did not update any non-displayed rows.

    Note: You can use Undo/Redo for this purpose.

  9. Select one of the table objects displayed in the Bulk Editor that is also visible in the modeling workspace. Click the Edit the Selected Object Button on the Bulk Editor Toolbar icon (Edit the selected object) to open the Table Editor. In the Table Editor, click the Delete toolbar icon to delete the selected object from the Bulk Editor pane – it should also disappear from your modeling workspace. Close the Table Editor to return to the Bulk Editor.
  10. Click the Bulk Editor Undo Action Button icon to undo the previous Delete operation and verify that both the Bulk Editor and the modeling workspace are properly updated.