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: DOORS to Excel Export
Topic Summary: Excel changes the case for Boolean Type values exported from DOORS
Created On: 29-Mar-2007 16:45
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.
 29-Mar-2007 16:45
User is offline View Users Profile Print this message


Ginelle Gali

Posts: 4
Joined: 10-Jun-2003

I have a problem of Excel converting the case for all Boolean Type values exported from DOORS. e.g. The value True is changed to TRUE. The .csv export does not have this problem, its only with the .xls export.
We have a vbscript that we need to run in Excel to change it back to the original case as it exists in the DOORS module. But, if it is possible to fix this problem in the DOORS to Excel export utility, we would prefer to try that approach.

Any suggestions for updating the DOORS - EXCEL utility (or the code if this has been done before) will help. Thanks.
Report this to a Moderator Report this to a Moderator
 29-Mar-2007 17:30
User is offline View Users Profile Print this message


David Pechacek

Posts: 674
Joined: 5-Dec-2006

Looking at the export script for Excel, it looks to me that Excel itself might be doing this. The export script simply gets the string value of each attribute thats being exported and assigns it to the proper cell. I know Excel often times does store booleans (since Excel does use them) as uppercase so this is what it is likely doing. What you could do is investigate modifying the export script to set the column that the booleans are going into as a Text only column.

-------------------------
David Pechacek
AAI Services Textron
dpechacek@sc-aaicorp.com
David.Pechacek@gmail.com
Report this to a Moderator Report this to a Moderator
 29-Mar-2007 21:40
User is offline View Users Profile Print this message


ron lewis

Posts: 650
Joined: 20-Sep-2004

Potential solution for you is to add tic mark (ie "'") in file excel.dxl
to the following lines of code as shown:

if (null dxl(c)) {
s = "'" probeAttrShortDate_(o, attrName c)
}


If you need greater fidelity than this you could test attrName to see if it is boolean attribute before applying the tick mark.

The above tick mark will convert the export to text and excel will not convert.
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.