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: 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
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-Dec-2004 15:15
User is offline View Users Profile Print this message


Jeff Schrader

Posts: 4
Joined: 19-Nov-2004

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.
Report this to a Moderator Report this to a Moderator
 30-Dec-2004 13:08
User is offline View Users Profile Print this message


Karen Hidalgo

Posts: 55
Joined: 4-Nov-2003

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
Report this to a Moderator Report this to a Moderator
 3-Jan-2005 21:52
User is offline View Users Profile Print this message


Louie Landale

Posts: 2070
Joined: 12-Sep-2002

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
Report this to a Moderator Report this to a Moderator
 4-Jan-2005 12:32
User is offline View Users Profile Print this message


Hazel Woodcock

Posts: 38
Joined: 4-Oct-2002

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
Report this to a Moderator Report this to a Moderator
 4-Feb-2005 16:26
User is offline View Users Profile Print this message


Mark Rothstein

Posts: 1
Joined: 4-Feb-2005

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.

It would be nice to be able to edit Object Level within DOORS, so as to avoid repetitive copy and paste.

TIA
Mark

Report this to a Moderator Report this to a Moderator
 7-Feb-2005 08:32
User is offline View Users Profile Print this message


Tony Goodman

Posts: 1098
Joined: 12-Sep-2002

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
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.