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
Topic Summary: ID number does not start from 2 ...
Created On: 20-Jun-2007 23:13
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.
 20-Jun-2007 23:13
User is offline View Users Profile Print this message


Krishna Kandala

Posts: 170
Joined: 8-Jul-2006

Hi All,

I am importing an Excel spreadsheet to a new DOORS module (version 7.1). I created a template with the attributes same as the column headings of the spreadsheet and created a blank module based on the template. I saved the Excel spreadsheet as .csv file. I opened the blank module and imported the .csv file with the options "By column labels" and "Create new objects". The .csv file is imported without problem. When I checked the ID  number sequence, it started from 8442 instead of 2 ( there is already one blank object in the module). I deleted and purged the module, created another new module and then imported the .csv file. The  ID is starting at the same number ( there are 4219 rows including the heading row in the .csv file). It appears that the objects were imported thrice, with the first two instances purged. I can not understand what is happening.
Am I not importing the csv file correctly ?
Report this to a Moderator Report this to a Moderator
 21-Jun-2007 11:36
User is offline View Users Profile Print this message


Tony Goodman

Posts: 1098
Joined: 12-Sep-2002

Object identifiers are consumed, even if you don't save your changes.

Try this: create a new empty module.
Add an object.
Close the module without saving changes.
Open the module again and add a new object. It's absolute number will be 2, not 1.

I suspect you have cancelled out of a previous import and thus the identifiers have been consumed without you realising.

I wouldn't worry too much about the absolute numbers of objects - they are just unique identifiers.

As an aside, it is a bad idea to attempt to keep module "tidy" by having sequential identifiers - i have seen this many times and it always end in tears.

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