Download all the universe metadata into excel file

[system]

Hi Everyone,

I have a universe in IDT(BO 4) with unx extension. There used to be a macro in excel which would automatically jot down the details for the universe, eg. classes and objects, descriptions, contexts, tables, joins etc.

Has anyone come across that utility to document a universe in BO 4?

The requirement is to be able to download all the universe metadata into excel file, currently IDT allows me to document as a MS Word file but not an excel file, I need that in excel file so that I can keep track of things like object descriptions easily.

I could copy paste from word to excel but thats time consuming…

Experts suggest me some solutions plzzzz

Thanks & Regards,
AFAF

---

AFAF (BOB member since 2012-07-13)

[system]

This works with UNV files.

---

viewlakes (BOB member since 2004-01-28)

[system]

Did you try this -

Excel utility with several lists

Author: Adrián BO_Worker developed from Julien Bras’ userlist utility. Author notes: Excel 97-2003 VBA application. Displays some lists for users, groups, universes, reports… Only reading, not writing back. Please go to configuration sheet and fill Server, Username and Password in order to get it working. After that try the rest of sheets pressing the buttons to field the data below. Whenever you get orange cells that’s a place you should fill. If you get Id and Name to fill you can write one o…

Document a universe using Excel and the Designer SDK

Author: [url=http://www.forumtopics.com/busobj/profile.php?mode=viewprofile&u=1343]Dwayne Hoffpauir, EDS[/url] Notes: The attached utility uses Excel and the Designer SDK to document a universe. Usage is rather straightforward. Click the "Document a Universe" button on the Control Sheet, log in, and select the specific universe. Information will be recorded on separate worksheets for:[list:5d8cd1056f]Database tables Database columns Joins Contexts Classes Objects Conditions[/list:u:5d8cd10…

---

aniketp (BOB member since 2007-10-05)