Mass Updating object descriptions in universe

[system]

@Dwayne Hoffpauir

I have an Excel-based utility for this purpose. It contains two VBA macros that manipulate the Designer object model (no direct repository updates). The first macro “dumps” the current class name, object name, and description in columns A,B,C and repeats the object name and description in columns D,E. Then columns D,E can be edited to a “new” object name and description. The second macro makes the changes to the universe. It’s not “bullet proof” by any means, but I’ll share the code if you’re interested.

The Excel utility can be downloaded here. Open the file, press Alt-F8 and you should see two macros. Run GetInfo first. You will be asked to log into Designer, and open a universe. The current class, object, and description will be loaded into the spreadsheet. Make changes to the columns in blue. Then run the MakeChanges macro. You will again be asked to log into Designer and open a universe. There is no “hourglass” so be sure the macro is finished. Designer will be left open with the updated universe UNSAVED, to give you a chance to review the updates.

I will see about getting this added to the Code Samples forum later.

[Edit: Utility has been placed in the Code Samples forum here.]

---

Dwayne Hoffpauir (BOB member since 2002-09-19)