Is it possible to script the creation of multiple libraries in a DxDataBook configuration, including the linking to DSN data source tables and setting property annotation / mapping? We have around 200+ 'libraries' - or categories as we view them - and would like to avoid doing all that setup for the configuration by hand.
Thanks-
-j
Hello j,
I didnt see any answer to your automation request, and I also have no anwer that could directly answer your request.
And I will tell you how I found out that doing a lot of DxDB config can be eased by hand if you do the right sequence.
If you build a library and add a table, then you have to click for quiet a long time to set this up for every library. What I found out is that if you do it in a clever way with the right sequence, then you can save a lot of time. I have set up around 80 libraries in round 40 min, most of the time was waiting for the tool to do a refresh or scrolling.
I started out with a "template" library that is the most "common" of them all. I set up the dxdb configuration as I liked it. The queries to your system have to be similar, that means the names of the properties you want to annotate must be identical. that means that the query has to deliver consisten fields.
The key is to follow this sequence exactly:
1) copy the library
2) with right mouse button open property and rename the library
3) in the renamed library select the table and do an add table with the new query from your system
4) select the old table and delete it
Repeat for all libraries and do not bother with the few libraries that will have different settings.
Only when you are finished with them go back to the one that have to have special settings.
You will notice that doing it in this order the new added table will follow the settings of the old present table. This will save you the trouble to click on every line of the table to set the visibility, annotation and similar fields.
Hope this will help you.
Matija