![]() |
Telelogic DOORS (steve huntington) | ![]() |
new topic :
profile :
search :
help :
dashboard :
calendar :
home
|
||
Latest News:
|
|
Topic Title: Database schema drawing Topic Summary: Created On: 9-Dec-2003 15:31 Status: Post and Reply |
Linear : Threading : Single : Branch |
|
![]() |
![]()
|
![]() Answer: Cliff, The attached code seems to be incomplete (cut off ). Can you post as a .zip attachment? | |
![]() |
|
We have a large Database comprising of many Projects & Folders.
I was looking for some DXL that can recursively work through the Database and produce a netlist that is readable by Visio/OrgPlus/NetViz. Basically, I want to produce a large format diagram of the entire Database also showing the Linking. Many thanks, Dave +44 (0)23 9270 5711 david.robbins@astrium.eads.net ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ EADS Astrium Ltd, Anchorage Road Portsmouth. Hampshire PO3 5PU ------------------------- Dave +44 (0)23 9270 5711 david.robbins@astrium.eads.net ~~~~~~~~~~~~~~~~~~~~ EADS Astrium, Anchorage Road Portsmouth. Hampshire. UK PO3 5PU |
|
![]() |
|
![]() |
|
I don't know about making a drawing, but we CAN find all the Link Module partner relationships, as attached.
The drawing part will, not doubt, need to check for recursive relationships (A is linked to B which is linked to C which is linked to A). - Louie |
|
![]() |
|
![]() |
|
Louie, there were a few bugs in that code...here is the code the way I think you wanted.
Project pCurr = current Item itm Link lnk ModName_ mn Skip Relationships = create string NameMod, NameTarget, ThisRelationship for itm in pCurr do { if (type(itm) != "Formal") continue NameSource = fullName(itm) // or name(itm) mod = read(NameSource,false) Object obj for obj in entire(mod) do { for lnk in obj ->"*" do { mn = target(lnk) if (!null mn) { NameTarget = fullName(mn) // or name(mn) ThisRelationship = NameSource " --> " NameTarget put (Relationships, ThisRelationship, ThisRelationship) } } // end for outgoing links } // end for objects in module close (mod) } // end for items in the current project for ThisRelationship in Relationships do { print ThisRelationship "\n" } delete(Relationships) // if your module names are unique in the project use "name" rather than "fullName". |
|
![]() |
|
![]() |
|
Here is a slightly different approach. This exports source module, target module and link module to a spreadsheet.
Works on the current folder (or project). Don't know anything about NetLists, but I guess you could modify what is written to the file to produce XML or whatever. ------------------------- Tony Goodman http://www.smartdxl.com |
|
![]() |
|
![]() |
|
I never said I tried it; just wrote it.
![]() - Louie |
|
![]() |
|
![]() |
|
Many thanks guys,
I have now got a beta version up and running which exports to a text file that netViz can import. The DOORS database heirachy is maintained and Projects and Folders can be 'drilled down into' Module Links are also exported to netViz & this gives the ability to explore the relationships between Modules and see how many Links each Module has going in & out. I also intend to export brief Module metrics as netViz can produce 'Views' by querying the dataset. ~ produce diagrams like: http://www.netviz.com/products/3d_images/ColorLANinspector.jpg ( but the DOORS database with Links rather than a LAN ) If anyone with netViz wants to try it, let me know. A Demo version of netViz can be obtained from: http://www.netviz.com which is fully functional, except you can't save the data. regards, Dave +44 (0)23 9270 5711 david.robbins@astrium.eads.net ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ EADS Astrium Ltd, Anchorage Road Portsmouth. Hampshire PO3 5PU ------------------------- Dave +44 (0)23 9270 5711 david.robbins@astrium.eads.net ~~~~~~~~~~~~~~~~~~~~ EADS Astrium, Anchorage Road Portsmouth. Hampshire. UK PO3 5PU |
|
![]() |
|
![]() |
|
The ability to graphically view and configure the database schema for a DOORS Project is a sorely needed feature for DOORS, it would greatly improve administration productivity on large projects where the management of link relationships in particular becomes a nightmare.
------------------------- Paul Miller Specification Practices Specialist, EuroCyber, Melbourne, Australia. Mobile: +61 (0)418 135 103 Web Site: http://www.eurocyber.biz E-mail: miller@eurocyber.biz">pmiller@eurocyber.biz |
|
![]() |
|
![]() |
|
The script is very interesting, could you please send me the code?
My address is carlo.becheri@trans.ge.com. Best Regards, Carlo Becheri Verification & Validation GE Transportation Systems S.p.A. Via P. Fanfani, 21 50127 Firenze - Italy Phone +39 055 4234 316 |
|
![]() |
|
![]() |
|
Did anyone receive the code yet? If so, please send me a copy at pete.kowalski@motorola.com. Thanks ahead
![]() ------------------------- pete.kowalski(at)motorola.com |
|
![]() |
|
![]() |
|
I too would LOVE to receive this code. Thanks Tim Ryan. ... tryan@drs-esg.com |
|
![]() |
|
![]() |
|
Can you post the code or email me the code as well.
Thanks |
|
![]() |
|
![]() |
|
Guys,
I am currently working on the next version which supports netViz V7. The code has also been tested on DOORS 6 & 7. The current version can either be run interactively via GUI or as a batch job, which runs weekly. The current version is processing about 2500 modules & 290k links in just under 3 hours on a bog standard office PC. The aim of the next version is to produce live snaps/diagrams of the database like: http://www.netviz.com/products/gallery/Gallery2.gif See also:http://www.netviz.com/products/p_3d.asp for other ideas on how to express the database graphically. Where the major nodes are Projects and Folders containing Requirement Specifications. What we want to be able to see in 3D is the areas that are missing Verification or have no links from lower level RSs. With netViz 7, it is possible to change the link color & size. This will enable the number of links from lower level specs to be represented with color changes. Also, Module icons can have their shape/colr changed according to the metrics gathered for each Module ( such as no in or out links, unmarked Requirements etc ) I will post the script here shortly, with some example graphics of what we have done. regards, Dave +44 (0)23 9270 5711 david.robbins@astrium.eads.net ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ EADS Astrium Ltd, Anchorage Road Portsmouth. Hampshire PO3 5PU ------------------------- Dave +44 (0)23 9270 5711 david.robbins@astrium.eads.net ~~~~~~~~~~~~~~~~~~~~ EADS Astrium, Anchorage Road Portsmouth. Hampshire. UK PO3 5PU |
|
![]() |
|
![]() |
|
Hi,
First off, 1000 appologies for not getting this out earlier :-( ~ We migrated to 7.0SP1 last month & got somewhat tied up in it all + all the introduced 'bugs' like bl**dy <View list is locked> ho hum... Anyway, attached is a 'kit' to produce a netViz netlist from your Database. See: NetViz There really isn't any point in running this script unless you have netViz. But you can obtain a trial copy from: NetViz demo version What can this script do: Builds a Netlist of the entire Database that is compatible with NetViz Version 6.5 see http://www.netviz.com DOORS Version 6.0+ , 7.0SR1, 7.1 Exports: ? Formal DOORS Modules ? Projects ? Folders ? Link Modules ? Links ( as wires ) between Modules Exports Module information: ? Module Full Name ? Module Prefix ? Module Name ? Unique ID (UID) ? Parent ( Folder or Project ) ? Total # of: Objects Requirements Linked Requirements ? Linked % ( How many Requirements have and outlink ) ? Linking Status ~ one of 3 states: 1) No Linkset defined ( No linking found from the Module ) 2) Linkset uses default Link Module: DOORS Links 3) Default Linkset pairing defined ? Command ( Enables the Module icon in netViz to be able to launch DOORS and open selected the Module ) ? Last Modified By ( who did it ? ) ? Last Modified On ( date ) Exports Link Module information: ? Link Module Name ? Link Count ( between nodes ) ? Link Source ? Link Target ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ The Export is in the form of a netViz netlist ( .txt ) & is imported into a netViz Project The tool requires a netViz Catalog. This contains the models for the Projects, Folders, Modules, Link Modules & Links The Catalog can be editted in netViz to use different icons or to create new fields for the exported data. A log file is also exported into the same folder as the netlist file. This shows the progress of the exporter and any problems it encountered. It shows the time taken to open a Module as this is an indicator in 7.0SP1 that the Module has a corrupt View which will cause <View list is locked> messages. Apparently fixed in 7.1 ;-) You really need to read the included 'read_me.txt' file before getting started. It *should* answer any Qs you may have, if not drop me a mail. Thanks to those thread contributors such as Louie, Douglas & Tony for getting me started in all this to start with. cheers, Dave ------------------------- Dave +44 (0)23 9270 5711 david.robbins@astrium.eads.net ~~~~~~~~~~~~~~~~~~~~ EADS Astrium, Anchorage Road Portsmouth. Hampshire. UK PO3 5PU Edited: 23-May-2004 at 21:13 by Dave Robbins |
|
![]() |
|
![]() |
|
Try and attached the code this time...
See previous message. ------------------------- Dave +44 (0)23 9270 5711 david.robbins@astrium.eads.net ~~~~~~~~~~~~~~~~~~~~ EADS Astrium, Anchorage Road Portsmouth. Hampshire. UK PO3 5PU |
|
![]() |
|
![]() |
|
Dave,
Wow, you are alive! ![]() Thanks for sharing. This looks promising. ------------------------- pete.kowalski(at)motorola.com |
|
![]() |
|
![]() |
|
Seemed to get dropped on the last attempt...
------------------------- Dave +44 (0)23 9270 5711 david.robbins@astrium.eads.net ~~~~~~~~~~~~~~~~~~~~ EADS Astrium, Anchorage Road Portsmouth. Hampshire. UK PO3 5PU |
|
![]() |
|
![]() |
|
Didn't need this until a short while ago.
Visio has a Org chart wizard which plots a simple org chart from a csv/tcv/excell document. For a module, create a view showing the ID, the Object Heading and a column showing the parent ID, ------------------------- Cliff Bly |
|
![]() |
|
![]() |
|
whoops - hand finger problems.
Visio has a Org Chart wizard which plots a simple organization from a tsv or Excel document. For a module: create a view with the ID, Object Heading and the ID of the Parent Object. - eg ID, Name , Reports To 1 Heading 1 2 Heading 1.1 1 3 Heading 1.2 1 Export as an Excel spreadsheet and run the Viso org chart reader. For a database shema based on the folder/project/module layout, I create a module with a structure representing the database shema. For a database schema based on the links, I create a module with a structure based on the links. With the link schema, there is 1 problem in that the Visio wizard cannot handle modules which link to more than 1 superior module. In these cases, I have 2 objects representing this module but only 1 module has the subordinate modules. Circular references will not work well. The attached code contains both scripts -- ------------------------- Cliff Bly Edited: 14-Feb-2005 at 19:22 by cliff Bly |
|
![]() |
|
![]() |
|
Cliff,
The attached code seems to be incomplete (cut off ). Can you post as a .zip attachment? ------------------------- Michael Sutherland michael@galactic-solutions.com http://galactic-solutions.com |
|
![]() |
|
![]() |
|
Did anyone every recent the complete code for the schema drawing, if so I would like a copy
Thanks ------------------------- jobina.l.johnson@boeing.com ![]() |
|
![]() |
|
Telelogic DOORS
» DXL Exchange
»
Database schema drawing
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.