Hi,
I have a couple of universes I need to build around 500 objects each universe, sounds alot of objects but these universes will form the basis of number smaller universes, ie master / slave.
Luckly for me they have already created a spreadsheet thats lists the object name and the descriptions, also the db table and column names. The underlying schema isnt ready yet so they just want to see a draft of how the universe will look ie classes and object names.
To get the object names quickly into the universe I did the following trick. Rather than manually type the object name in or copy and past I created a table based on the objects names something like the following,
CREATE TABLE objects
(Account_ID VARCHAR(12),
Account_Name VARCHAR(12))
The data type didnt matter just wanted to create the table. I then went Designer pulled the table in, I then dragged the table to the object area and presto it created a class with the table name and object with the names I needed, it automatically dropped the underscores copy and pasting would of taken me hours. I know I still need to add the table definitions, classes and objects types joins but table definations are not ready so this is all I can do at moment.
Anyway my question does anyone know how I could bulk update the object descriptions as well ? May be updating the repo directly … I know its not supported but this is a brand new universe so currently in dev and dev repo so doesnt matter if I break it, just cant face hours of copy > paste, copy > paste
Cheers
Rich (BOB member since 2002-10-04)