Background: Using DOORS 8.3
Created module that contains ID|Requirements|REQ?|and other Attributes
The Requirements Object Text contains WORD Tables and some VISIO Figures.
Attempting to generate an output, preferably a Spreadsheet 11x17 that can be submitted to Customer.
1) Export to EXCEL: pop-up requires me to select what to include in the MAIN column
(a) Selected Object Text; RESULT: EXCEL file with text for Object Text fields, but blanks for Heading Text and the WORD Tables/Figures
(b) Selected Object Heading; RESULT: EXCEL file with only Heading Text and evry other object in column blank.
2) Export to Spreadsheet; RESULT: .csv file that when opened in EXCEL contains all the Heading & Object text; however, the Tables and Figures still are not included.
Any suggestions? What am I missing?
Thanks in advance for your assistance.
SMS
SystemAdmin - Thu Mar 26 11:43:07 EDT 2009 |
|
Re: Exporting module to EXCEL or Spredsheet - missing Object Text
Ron_Lewis - Thu Mar 26 12:08:51 EDT 2009
Go to http://galactic-solutions.com/GalacticDownloads.htm and download the advanced excel export tool
|
|
Re: Exporting module to EXCEL or Spredsheet - missing Object Text
SystemAdmin - Thu Mar 26 12:51:29 EDT 2009
As DOORS help states "Select Object Heading and Text to export both the Object Heading and Object Text attributes in the main column". But typically it is better to create an export view which removes the main column and adds Object Heading and Object Text as separate columns.
BTW: OLE objects in Excel are not so easy, because they kind of float over the cells. Even though the excellent Galactic Solutions Enchanced Excel Export script exports OLE objects they are often in incorrect location. Maybe a better solution would to to make a table format export to Word?
|
|
Re: Exporting module to EXCEL or Spredsheet - missing Object Text
SystemAdmin - Thu Mar 26 12:55:53 EDT 2009
How can we have tables in Excel spreadsheet? Unless the table is declared as a picture, the table will be converted to text and exported to the cells of the spreadsheet.
Or is there a way to retain the structure of the table in the Excel spreadsheet? I mean the same structure when we copy a Word table and paste in Excel spreadsheet.
|
|
Re: Exporting module to EXCEL or Spredsheet - missing Object Text
Ron_Lewis - Thu Mar 26 14:25:04 EDT 2009 SystemAdmin - Thu Mar 26 12:55:53 EDT 2009
How can we have tables in Excel spreadsheet? Unless the table is declared as a picture, the table will be converted to text and exported to the cells of the spreadsheet.
Or is there a way to retain the structure of the table in the Excel spreadsheet? I mean the same structure when we copy a Word table and paste in Excel spreadsheet.
Might be better to have software than converts DOORS tables to a picture during export -- of course that software would be difficult to write.
|
|
Re: Exporting module to EXCEL or Spredsheet - missing Object Text
SystemAdmin - Thu Mar 26 15:12:43 EDT 2009 Ron_Lewis - Thu Mar 26 12:08:51 EDT 2009
Go to http://galactic-solutions.com/GalacticDownloads.htm and download the advanced excel export tool
Restarted DOORS and attempted to execute the script; however, I received an error message stating that the script was created for v7.x and I need to get the 8.3.0.0 version.
Looked on the Galactic Solutions Group's website and can not find a newer version.
SMS
|
|
Re: Exporting module to EXCEL or Spredsheet - missing Object Text
Ron_Lewis - Thu Mar 26 15:24:29 EDT 2009 SystemAdmin - Thu Mar 26 15:12:43 EDT 2009
Downloaded the dxl script as recommended.
Restarted DOORS and attempted to execute the script; however, I received an error message stating that the script was created for v7.x and I need to get the 8.3.0.0 version.
Looked on the Galactic Solutions Group's website and can not find a newer version.
SMS
https://forum.telelogic.com/customer/doors/messageview.cfm?catid=17&threadid=632&highlight_key=y&keyword1=Enhanced%20Export%20to%20Excel
|
|
Re: Exporting module to EXCEL or Spredsheet - missing Object Text
SystemAdmin - Thu Mar 26 17:19:50 EDT 2009
Thanks. The info in the old forum was helpful.
The only 'problem' left is that the Figures and Tables are placed in the row below the row with the ID and all the other related Attributes.
Also, these items overflow over the following line - worse after double-clicking on the item.
This will require clean-up time that I don't have.
Looked in the old forum but didn't find anything related to this. Maybe searching for the wrong thing?
SMS
|
|
Re: Exporting module to EXCEL or Spredsheet - missing Object Text
Ron_Lewis - Fri Mar 27 04:57:29 EDT 2009 SystemAdmin - Thu Mar 26 17:19:50 EDT 2009
Thanks. The info in the old forum was helpful.
The only 'problem' left is that the Figures and Tables are placed in the row below the row with the ID and all the other related Attributes.
Also, these items overflow over the following line - worse after double-clicking on the item.
This will require clean-up time that I don't have.
Looked in the old forum but didn't find anything related to this. Maybe searching for the wrong thing?
SMS
I myself would just print with adobe acrobat and get on with it.
|
|
Re: Exporting module to EXCEL or Spredsheet - missing Object Text
SystemAdmin - Fri Mar 27 09:22:19 EDT 2009 Ron_Lewis - Fri Mar 27 04:57:29 EDT 2009
You can change the properties of the images to solve the problem.
I myself would just print with adobe acrobat and get on with it.
Interesting comments. Don't mean to be too obtuse...
When should the properties be changed? Change the properties of the images saved in DOORS (before attempting to export) or once they've been exported into EXCEL?
If the exported data was intended for our internal use/review, then you're correct in implying that the format is not important - getting the data is. The EXCEL spreadsheet I'm using the exported data for is part of a document to be submitted to a customer and traditionally, our source files are not PDFs. However, DOORS being a new tool here, perhaps now's the time to reconsider the traditional source data.
So, based on your second comment, do you recommend exporting directly into a PDF from DOORS? Would that result in a better output than these attempts to export into EXCEL (or WORD)?
SMS
|
|
Re: Exporting module to EXCEL or Spredsheet - missing Object Text
Ron_Lewis - Fri Mar 27 09:42:53 EDT 2009 SystemAdmin - Fri Mar 27 09:22:19 EDT 2009
Ron,
Interesting comments. Don't mean to be too obtuse...
When should the properties be changed? Change the properties of the images saved in DOORS (before attempting to export) or once they've been exported into EXCEL?
If the exported data was intended for our internal use/review, then you're correct in implying that the format is not important - getting the data is. The EXCEL spreadsheet I'm using the exported data for is part of a document to be submitted to a customer and traditionally, our source files are not PDFs. However, DOORS being a new tool here, perhaps now's the time to reconsider the traditional source data.
So, based on your second comment, do you recommend exporting directly into a PDF from DOORS? Would that result in a better output than these attempts to export into EXCEL (or WORD)?
SMS
Print to pdf from DOORS -- make sure you set images sizes in DOORS before print.
|
|
Re: Exporting module to EXCEL or Spredsheet - missing Object Text
Ron_Lewis - Fri Mar 27 09:45:03 EDT 2009 Ron_Lewis - Fri Mar 27 09:42:53 EDT 2009
Set image properties in excel.
Print to pdf from DOORS -- make sure you set images sizes in DOORS before print.
|
|
Re: Exporting module to EXCEL or Spredsheet - missing Object Text
SystemAdmin - Fri Mar 27 10:02:09 EDT 2009
For the release of this document, I used the "Enhanced Export to EXCEL" DXL Script and in EXCEL manually moved the Tables and Figures into the correct rows with their corresponding Attributes and deleting the extra rows; not perfect, but gets the job done.
Thanks for the suggestions. I'll try them out.
SMS
|
|