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: Import from spreadsheet bug?
Topic Summary:
Created On: 24-Jan-2008 16:53
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.
 24-Jan-2008 16:53
User is offline View Users Profile Print this message


Jim Backus

Posts: 21
Joined: 27-Apr-2006

In DOORS 8.1:

Open the Import Spreadsheet window and select the 'Import to attributes: From list' and 'Import options: Create new objects' radio buttons.

Now if the source data has columns that are NOT to be imported a list must be created that includes 'ignore' entries in the appropriate places.

To save time the next time a similar import is to be done this file can be saved as an '.ATR' file.

My .ATR file looks like this:

preadsheet Import/Export Attribute List
Ignore
Object History
Object Text
Traceability Notes
Compliancy Notes
Ignore
Validation Method
Ignore
Assignment
Ignore
Ignore
Verification Method

However if this file is loaded, the 'ignore' entries are omitted from the 'Attributes to import' window in the Import Spreadsheet' window, so when an import is performed the data is imported incorrectly. On re-saving the loaded ATR file it can be seen that the 'ignore' entries are missing:

Spreadsheet Import/Export Attribute List
Object History
Object Text
Traceability Notes
Compliancy Notes
Validation Method
Assignment
Verification Method

This looks like a bug with the use of the .ATR file. Has anyone else seen this? Is it a known DOORS bug? If so which versions are affected?

The DXL responsible is commas.dxl in lib/dxl/standard/import but it's a big script and I don't feel brave enough to start tampering with it!

TIA

Jim

-------------------------
Jim Backus<BR>Ultra Electronics, Controls
Report this to a Moderator Report this to a Moderator
 25-Jan-2008 09:26
User is offline View Users Profile Print this message


Jim Backus

Posts: 21
Joined: 27-Apr-2006

Further information:

It apppears that the bug may lie in the include file attrlist.inc which has a block of code:

for (file >> line; !end file; file >> line) {
if (!attrExists_ line)
if (matches("[1-9] .", line))
line = line[end(0):]
if (attrExists_ line )
put(alSelectedAttr, alSelAttrNum++, line)
}

This appears to check that attributes exist before adding them to the attribute list used to map a CSV file into DOORS. Clearly there is no attribute named 'ignore' so these entries will not be loaded. I've only scanned the DXL quickly so this may not be the cause. As it's in an include file that may be used elsewhere I'm loath to modify it.

-------------------------
Jim Backus<BR>Ultra Electronics, Controls
Report this to a Moderator Report this to a Moderator
 28-Jan-2008 21:48
User is offline View Users Profile Print this message


Joseph Dubin

Posts: 26
Joined: 1-Mar-2006

Yes, it ignores the IGNORE directives in a saved .ATR file. I reported this in March 2007. Telelogic logged it as an enhancement request, although I asked them to reclassify it as a bug.

I was able to work around it by modifying my source Excel to remove the columns I wanted to ignore...

-------------------------
Joseph DUBIN
joseph.dubinNOSPAM@freescale.com
Freescale Semiconductor, Inc.
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic DOORS forum.
There are currently 0 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 0 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.