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: Export Module to excel
Topic Summary: Exporting all the attributes to excel
Created On: 23-Feb-2005 10:18
Status: Post and Reply
Linear : Threading : Single : Branch
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 Tony Goodman, on Wednesday, March 2, 2005 4:51 AM

Answer:
try the attached code.
This is commas.dxl with the dialog box removed.
needs tidying up.
 23-Feb-2005 10:18
User is offline View Users Profile Print this message


Tarun Inabathuni

Posts: 59
Joined: 18-Jan-2005

Report this to a Moderator Report this to a Moderator
 23-Feb-2005 12:53
User is offline View Users Profile Print this message


Tony Goodman

Posts: 1098
Joined: 12-Sep-2002

sometimes less is more. but not always.

-------------------------
Tony Goodman
http://www.smartdxl.com
Report this to a Moderator Report this to a Moderator
 23-Feb-2005 13:32
User is offline View Users Profile Print this message


ron lewis

Posts: 650
Joined: 20-Sep-2004

Whats wrong Tony? Can't you read between the lines.

If the question is how do export values for all attributes to excel, then there is no shrink wrapped tool to do this -- a dxl script has to be written or borrowed that will loop thru each object and each attribute to export to a csv file.

Report this to a Moderator Report this to a Moderator
 23-Feb-2005 14:06
User is offline View Users Profile Print this message


Tarun Inabathuni

Posts: 59
Joined: 18-Jan-2005

Hi all Does anyway have a dxl to export all the attributes from a module( irrespective of view ) to excel because i have more than 32 attributes in my module Thankx regards Tarun
Report this to a Moderator Report this to a Moderator
 24-Feb-2005 12:19
User is offline View Users Profile Print this message


Paul Worrall

Posts: 87
Joined: 30-Sep-2003

Am I missing something here? When you go "File -> Export -> Spreadsheet", and choose to Export Attributes from list, doesn't this let you select any attribute you want to export?
Report this to a Moderator Report this to a Moderator
 24-Feb-2005 13:29
User is offline View Users Profile Print this message


ron lewis

Posts: 650
Joined: 20-Sep-2004

Good Catch Paul -- you are right about in export to spreadsheet.  To export all the attributes the user will have to load a list of attributes from a file.

Report this to a Moderator Report this to a Moderator
 25-Feb-2005 03:23
User is offline View Users Profile Print this message


Tarun Inabathuni

Posts: 59
Joined: 18-Jan-2005

Hi yes Pauls method is appropriate but iam trying to dump a module into excel using batch mode connection to DOORS, when i do this the dxl dumps what ever columns it finds in the default view where as i want to dump all the attributes in the module. Thankx Regards Tarun
Report this to a Moderator Report this to a Moderator
 25-Feb-2005 13:55
User is offline View Users Profile Print this message


Tony Goodman

Posts: 1098
Joined: 12-Sep-2002

Answer Answer
try the attached code.
This is commas.dxl with the dialog box removed.
needs tidying up.


-------------------------
Tony Goodman
http://www.smartdxl.com
Report this to a Moderator Report this to a Moderator
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.