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 all attributes to Excel
Topic Summary: export all attributes to Excel
Created On: 12-May-2005 16:08
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.
 12-May-2005 16:08
User is offline View Users Profile Print this message


Ananda Badugu

Posts: 20
Joined: 3-Feb-2003

Hi

Please any one can help us. in our DOORS module have more than 32 attributes. we have created two different views to view all the attributes. Now we want to export to Excel. when I use export option in DOORS, it exports only displayed attributes in single view. please any one help us how to export to all the attributes using dxl. I have created my own dxl, exported to .CSV format. but data is not formatted.


here is the dxl that is created.


Module m = current
Column c
Object o
string s
string s1
string s2
string s3
string s4
string s5
string s6
string s7
string s8
string s9


Stream Out = write "C:\\DXLReports\\VIPS.csv"

Out << "Business Rule Number" "\t" "Business Rules Description" "\t" "A3-MIM" "\t" "PMs" "\t" "Change Request" "\t" "Approved" "\t" "Comments" "\n"

for o in m do{

s2 = o."Business Rule Number"
s3 = o."Business Rules Description"
s4 = o."A3-MIM"
s5 = o."PMs"
s6 = o."Change Request"
s7 = o."Approved"
s8 = o."Comments"

Out << identifier o """\t" s2 "\t" s3 "\t" s5 "\t" s6 "\t" s7 "\t" s8 "\n"




Thanks
Anand
Report this to a Moderator Report this to a Moderator
 13-May-2005 09:23
User is offline View Users Profile Print this message


Tony Goodman

Posts: 1098
Joined: 12-Sep-2002

The attached should get you started.
This allows you to export selected attributes to a CSV file.


csvAttrs.dxl
csvAttrs.dxl  (4 KB)



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


ron lewis

Posts: 650
Joined: 20-Sep-2004

It might be a wee bit simpler to use the  use the tool  Export Spreadsheet.
Select the radio button labeled as shown below

                 Export: 0 Attributes from list

Report this to a Moderator Report this to a Moderator
 17-May-2005 08:19
User is offline View Users Profile Print this message


Tony Goodman

Posts: 1098
Joined: 12-Sep-2002

Good point Ron, but where's the fun in that?

-------------------------
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.