![]() |
Telelogic DOORS (steve huntington) | ![]() |
new topic :
profile :
search :
help :
dashboard :
calendar :
home
|
||
Latest News:
|
|
Topic Title: Importing Excel Spreadsheet Topic Summary: Need to import large Excel spreadsheet into DOORS Created On: 29-Dec-2004 15:15 Status: Post and Reply |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
Has anyone had any experience with importing an EXCEL spreadsheet into DOORS? I'm using v7.1 with EXCEL 2003. The spreadsheet is approximately 30mb.
|
|
![]() |
|
![]() |
|
I have some experience importing EXCEL spreadsheets (nothing on the size that you are talking about), but I have a DOORS Tech Tip file explaining how to format the EXCEL file and the DXL code that will place the objects at the correct level. I can't see how to attach multiple files, so if you email me, I will send you the 2 files.
Karen Hidalgo Northrop Grumman - TASC karen.hidalgo@ngc.com ------------------------- Karen Hidalgo<BR>Northrop Grumman - TASC<BR>karen.hidalgo@ngc.com Edited: 30-Dec-2004 at 13:09 by Karen Hidalgo |
|
![]() |
|
![]() |
|
If you are trying to update an existing module with new Spreadsheet info you will need to have originally exported the spread sheet from this module using Absolute Number or Identifier, then use that column as the import "Key" so DOORS knows which spread-sheet rows are associated with which DOORS objects. Newly inserted rows will need to be located in DOORS and moved.
If you are creating a new module with a spread sheet its easier. You probably have some mechanism for suggesting "leveling" within the spread sheet: perhaps you have a row "3.1.1 XYZ Mode Requirements" and intend subsequent rows to be objects withing that DOORS section. Be advised the import will import FLAT so you'll need to juggle objects "below" and "after" to force DOORS into the Hierarchy you want. A trick I've used to check your self is this: [1] Create attribute "Initial Order" of type Integer. Run the attached DXL to initialize this attribute, where the top object is "1", the next is "2" etc. Now, as you move objects around you should display this attribute and it will tell you if you have preserved the initial order or not. This is important since moving objects around is a painful learning experience fraught with frequent snafus. One basic trick to moving is to select all the objects that are supposed to be in one section, then move them "below" the section. Starting from the inside and working out is probably best: move sections that have many levels (3.1.1.4) before moving the parent (3.1.1). Also be advised that once imported the spread sheet should be retired without further modification: do you mods in DOORS. If you figure to continue to use the spread sheet then import it to DOORS, do you leveling, add columns "Absolute Number" and "Object Number" (paragraph number), then re-export it. Use "Absolute Number" for updates. - Louie |
|
![]() |
|
![]() |
|
You can import hierarchy from Excel. I have done this for small spreadsheets, and for updates. You need the Object level attribute in a column. I have not checked what happens if you get the level wrong (inconsistent eg level 4 when there is no level 3 object). This approach is a little less painful than manual manipulation of the hierarchy after import.
------------------------- Hazel Woodcock |
|
![]() |
|
![]() |
|
Hazel, How do you do the hierarchy from Excel? I have tried creating an "Object Level" column, but this doesn't get imported into a module using the standard DOORS import function, and the result is still flat. |
|
![]() |
|
![]() |
|
I found the attached that will build the module hierarchy from an attribute containing the object level.
The script is very simple, but please read the comment at the beginning before running as it assumes that you have set the attribute correctly. ------------------------- Tony Goodman http://www.smartdxl.com |
|
![]() |
Telelogic DOORS
» General Discussion
»
Importing Excel Spreadsheet
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.