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: Exporting to Excel, losing the heading numbers
Topic Summary:
Created On: 21-Sep-2004 21:29
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.
 21-Sep-2004 21:29
User is offline View Users Profile Print this message


Patrick Whalen

Posts: 23
Joined: 2-Sep-2004

Hello,

I've been having problems exporting a module to Excel. The heading numbers do not export. To get around this, I export the module to a .csv, then open and SAVE AS xls.

I am using Object Heading & Text as the main column. I have tried all others as the main column, but have not had any luck.

What am I missing?

Thanks,

Patrick
Report this to a Moderator Report this to a Moderator
 22-Sep-2004 16:05
User is offline View Users Profile Print this message


Patrick Whalen

Posts: 23
Joined: 2-Sep-2004

I guess that's what I'm asking...Anyone know how to do this?

quote:

Originally posted by: Robert Swan
.......I guess your stuck with CSV export, or writing some DXL or EXCEL macro to work out the number from the Object Level.


Report this to a Moderator Report this to a Moderator
 22-Sep-2004 16:36
User is offline View Users Profile Print this message


ron lewis

Posts: 650
Joined: 20-Sep-2004

You can add a layout dxl column with following code

if(isOutline(obj)) display number obj

Report this to a Moderator Report this to a Moderator
 23-Sep-2004 15:17
User is offline View Users Profile Print this message


Louie Landale

Posts: 2070
Joined: 12-Sep-2002

You could realistically create a Layout that simulates the Main column, display that, then export to Excel.

string Text = richTextWithOle(obj."Object Text")
string Head = richText(obj."Object Heading")
string Para = number(obj)
Buffer Results = create()
if (!null Head or null Text)
{ Results += Para // DOORS thinks this is a heading object
Results += "\n"
}
if (!null Head)
{ Results += Head // non null Heading
Results += "\n"
}
Results += Text
display (stringOf(Results))
delete (Results)

- Louie

Edited: 23-Sep-2004 at 15:23 by Louie Landale
Report this to a Moderator Report this to a Moderator
 23-Sep-2004 16:04
User is offline View Users Profile Print this message


Pieter DE WAARD

Posts: 73
Joined: 11-Jul-2003

You could use the solution offered by Galactic Solutions . It has a very nice interface where you have the choice to include or surpress the heading numbers, amongst a bunch of other features.

-------------------------
Pieter de Waard
www.nhindustries.com
Report this to a Moderator Report this to a Moderator
 23-Sep-2004 16:44
User is offline View Users Profile Print this message


Hazel Woodcock

Posts: 38
Joined: 4-Oct-2002

You can save a view with the heading number in one column (only where there is heading text) as below

string s = obj."Object Heading"
if (s != "")
{
string temp = number(obj)
display temp
}

Also have an Object Heading column
Also have an Object Text column

No main column

Export to Excel and format as desired with headings and numbers in bold, if you don't wrap the heading text it will flow across all visible excel columns so the actual heading column can be narrow giving an apparant indent for the object text.

If you have any intention of re-importing to DOORS, then heading and text need to be in separate columns anyway. Recording an Excel macro to do the formatting makes life easy for re-exporting.

There are very possibly as many solutions to this one as there are readers of it :-)

-------------------------
Hazel Woodcock
Report this to a Moderator Report this to a Moderator
 2-Nov-2004 12:28
User is offline View Users Profile Print this message


Kristian Bøe

Posts: 29
Joined: 16-Jun-2003

Modify excel.dxl
change the function headingLong to the following (Ugly but works) will handle when you include Heading and text:

string headingLong(Object o) {
string sss = o.AHeading
string ttt = o.ALongText

if (null o.AHeading) {
return o.ALongText ""
}

if (sss != "" && ttt != "") then
return number o " " o.AHeading "\r" o.ALongText ""

if (sss != "") then
return number o " " o.AHeading "\r"
else
return o.ALongText ""
}

and original line 228 for the choice Heading only

change line 228 (that is line 228 before doing the above change)

if (doMain == mainHeading) s = o.AHeading ""
to
if (doMain == mainHeading) {
string sss2 = o.AHeading
if (sss2 != "") s = number o " " sss2 ""
else s = ""
}

Works for me.

-------------------------
Kristian Bøe
Extenda AB
Kristian.Boe@extenda.se
Report this to a Moderator Report this to a Moderator
 28-Sep-2007 19:39
User is offline View Users Profile Print this message


Alonso De Vega

Posts: 6
Joined: 27-Mar-2007

When exporting, I also select "Object heading and text" when prompted, but still no heading numbers.

I have an imported Word document that has numbers in the headings, but when exporting it to Excel (because I've added more columns and want to keep them seperate) there are no heading numbers, just heading titles.

In the DOORS module, I'll insert the "Object Number" column then export the module to Excel.

Unfortunately, this means the heading numbers are in a different column than the heading text, but at least I now have the heading numbers.

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.