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: Excel-Export in Batch-Mode
Topic Summary: Is this possible?
Created On: 30-Apr-2007 09:24
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.
 30-Apr-2007 09:24
User is offline View Users Profile Print this message


Thomas Langholz

Posts: 40
Joined: 20-Oct-2005

Hi all, does anybody know if it is possible to run an excel-export(build in) in batch-mode? if yes, which changes do i have to do to make this possible? (of course, exept supressig all dialogues!) greetings thomas
Report this to a Moderator Report this to a Moderator
 30-Apr-2007 15:21
User is offline View Users Profile Print this message


David Pechacek

Posts: 674
Joined: 5-Dec-2006

We run nightly batch scripts that recreate tab delimited files which can be opened in Excel.

Basically you use a "for o in m do" loop to loop through all the objects in a module and just output each attribute you wish to a file separating attributes by tabs. Make sure to put the attribute names in the first row in each file. Then just set up a .bat file which your IT department can add as a service to run nightly.

See Streams in the DXL help manual for writing to files. No rich text however will be kept. I have a file of Excel functions you can use if you wish to write a simple Excel Exporter. A good non-batch Excel exporter is Michael Sutherland's Enhanced Export to Excel (a simple search will help you find it on here). A lot of my Excel functions are modifications of his code from that tool. Feel free to email me to get it.

-------------------------
David Pechacek
AAI Services Textron
dpechacek@sc-aaicorp.com
David.Pechacek@gmail.com
Report this to a Moderator Report this to a Moderator
 3-May-2007 20:51
User is offline View Users Profile Print this message


Craig Forant

Posts: 56
Joined: 21-Feb-2005

http://www.galactic-solutions....acticDownloadExcel.htm

is where you can download the Excel Exporter by Michael Sutherland. I don't see a version for DOORS 8, but I downloaded the Version for DOORS 7 and commented out the version checking around lines 3290. It seemed to work fine.

Thanks.

-------------------------
Craig Forant
me@craigforant.com
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic DOORS forum.
There are currently 2 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 2 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.