Question
Tecnilógica
ES
Last activity: 25 Jul 2019 3:48 EDT
Help creating a data dictionary from property tree
Hello!
I'm trying to create a data dictionary on and Excel file (CSV) of all the properties of a class and everything that I want to save, I can get it from Designer Studio > Data model > Classes & Properties > Property Tree
The problem is that when I try to expand the columns, my web browser starts to use a lot of memory and in the end it crash. I tried to get the properties in small portions, but still it's impossible.
Is there a way to get the Property tree of a Class using other way? BIX could be an option, but I cannot download it.
Thanks!
Tecnilógica
ES
Any help? I just want to export the property tree to a file. The problem is, it's too big to do it and crash the browser. Anyway, if somebody have an idea to export it, I'll appreciate it. Thanks a lot!
Pegasystems Inc.
US
Hello,
I'm not aware of an easy way to do this as a tree structure. You could definitely write a report (or make use of something OOTB) and export to excel. I'd look at how the instance lists are generated. You might be able to query the database directly as well, but you'd need to figure out the SQL to get you what you want.
Thanks,
Mike
Tecnilógica
ES
My first try was to query the database to create the data dictionary, SQL developer has a tool for that. But as you said, the main problem is to figure out where is everything stored.
Writing a report looks promising, I'll need to have a look at that. But if there's something already I'd rather use it. I mean, in property tree from data model: Classes and Properties, I could get a table with all the data related with the structure (like a data dictionary) and that's the perfect solution, but as I mentioned, when I expand the rows to fetch more data structures, it crash my browser (tried several, doesn't work with anyone) and it looks like the reason is because it loads a lot of repeated javascript (for showing some info when hovering over the rows). Also, it doesn't have a way to directly export to excel or other formats.
Thanks for your reply!