Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic DOORS (steve huntington)
Decrease font size
Increase font size
Topic Title: Database schema drawing
Topic Summary:
Created On: 9-Dec-2003 15:31
Status: Post and Reply
Linear : Threading : Single : Branch
1 2 Next Last unread
Search Topic Search Topic
Topic Tools Topic Tools
Quick Reply Quick Reply
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
Answer This question was answered by Michael Sutherland, on Friday, March 11, 2005 4:58 PM

Answer:
Cliff,

The attached code seems to be incomplete (cut off ). Can you post as a .zip attachment?
 9-Dec-2003 15:31
User is offline View Users Profile Print this message


Dave Robbins

Posts: 36
Joined: 9-Dec-2003

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
Report this to a Moderator Report this to a Moderator
 9-Dec-2003 17:55
User is offline View Users Profile Print this message


Louie Landale

Posts: 2070
Joined: 12-Sep-2002

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
Report this to a Moderator Report this to a Moderator
 11-Dec-2003 00:56
User is offline View Users Profile Print this message


Douglas Zawacki

Posts: 97
Joined: 14-Aug-2003

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".
Report this to a Moderator Report this to a Moderator
 11-Dec-2003 12:05
User is offline View Users Profile Print this message


Tony Goodman

Posts: 1098
Joined: 12-Sep-2002

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
Report this to a Moderator Report this to a Moderator
 11-Dec-2003 16:08
User is offline View Users Profile Print this message


Louie Landale

Posts: 2070
Joined: 12-Sep-2002

I never said I tried it; just wrote it.

- Louie
Report this to a Moderator Report this to a Moderator
 12-Dec-2003 21:02
User is offline View Users Profile Print this message


Dave Robbins

Posts: 36
Joined: 9-Dec-2003

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
Report this to a Moderator Report this to a Moderator
 8-Jan-2004 22:20
User is offline View Users Profile Print this message


Paul Miller

Posts: 376
Joined: 2-Oct-2002

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
Report this to a Moderator Report this to a Moderator
 29-Jan-2004 13:27
User is offline View Users Profile Print this message


Carlo Becheri

Posts: 4
Joined: 26-Nov-2002

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
Report this to a Moderator Report this to a Moderator
 30-Jan-2004 18:40
User is offline View Users Profile Print this message


Pete Kowalski

Posts: 301
Joined: 7-Feb-2003

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
Report this to a Moderator Report this to a Moderator
 2-Feb-2004 21:37
User is offline View Users Profile Print this message


Timothy Ryan

Posts: 5
Joined: 17-Nov-2003


I too would LOVE to receive this code.

Thanks

Tim Ryan. ... tryan@drs-esg.com
Report this to a Moderator Report this to a Moderator
 3-Mar-2004 22:02
User is offline View Users Profile Print this message


Ahsan Syed

Posts: 5
Joined: 18-Sep-2002

Can you post the code or email me the code as well.

Thanks

Report this to a Moderator Report this to a Moderator
 6-Mar-2004 09:31
User is offline View Users Profile Print this message


Dave Robbins

Posts: 36
Joined: 9-Dec-2003

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
Report this to a Moderator Report this to a Moderator
 23-May-2004 12:48
User is offline View Users Profile Print this message


Dave Robbins

Posts: 36
Joined: 9-Dec-2003

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
Report this to a Moderator Report this to a Moderator
 23-May-2004 12:52
User is offline View Users Profile Print this message


Dave Robbins

Posts: 36
Joined: 9-Dec-2003

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
Report this to a Moderator Report this to a Moderator
 23-May-2004 18:13
User is offline View Users Profile Print this message


Pete Kowalski

Posts: 301
Joined: 7-Feb-2003

Dave,

Wow, you are alive! You haven't attached the code.

Thanks for sharing. This looks promising.



-------------------------
pete.kowalski(at)motorola.com
Report this to a Moderator Report this to a Moderator
 23-May-2004 21:00
User is offline View Users Profile Print this message


Dave Robbins

Posts: 36
Joined: 9-Dec-2003

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
Report this to a Moderator Report this to a Moderator
 8-Feb-2005 20:25
User is offline View Users Profile Print this message


cliff Bly

Posts: 58
Joined: 11-Apr-2003

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
Report this to a Moderator Report this to a Moderator
 8-Feb-2005 20:45
User is offline View Users Profile Print this message


cliff Bly

Posts: 58
Joined: 11-Apr-2003

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
Report this to a Moderator Report this to a Moderator
 10-Feb-2005 15:46
User is offline View Users Profile Print this message


Michael Sutherland

Posts: 248
Joined: 13-Sep-2002

Answer Answer
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
Report this to a Moderator Report this to a Moderator
 22-Jan-2007 15:18
User is offline View Users Profile Print this message


Jobina Johnson

Posts: 55
Joined: 12-Sep-2002

Did anyone every recent the complete code for the schema drawing, if so I would like a copy

Thanks

-------------------------


jobina.l.johnson@boeing.com
Report this to a Moderator Report this to a Moderator
Telelogic DOORS » DXL Exchange » Database schema drawing

1 2 Next Last unread
Topic Tools Topic Tools
Statistics
20925 users are registered to the Telelogic DOORS forum.
There are currently 1 users logged in.
The most users ever online was 15 on 15-Jan-2009 at 16:36.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.