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: Error importing CSV file back into module
Topic Summary: DOORS creates objects instead of updating
Created On: 14-Dec-2004 17:44
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.
 14-Dec-2004 17:44
User is offline View Users Profile Print this message


Dan Dalton

Posts: 4
Joined: 19-Jan-2004

I have been trying to isolate an issue and I am at a complete loss.

I have a module which I have exported to a CSV spreadsheet. Without even modifying/opening that CSV, I import it back into the originating module and the module creates new objects rather than comparing, seeing that nothing has been modifed and saying "0 updated, 0 created." I presume something *has* been changed somewhere in the import/export, so I was wondering if anyone else has had experience with this.

Thanks in advance,
Dan
Report this to a Moderator Report this to a Moderator
 15-Dec-2004 11:25
User is offline View Users Profile Print this message


Paul Ransley

Posts: 10
Joined: 20-Sep-2004

Dan,

When you ran the import did DOORS prompt you to create a new attribute called ID? If it did thats the problem though you say it creates new objects but reports "0 updated, 0 created." which does not sound right.

Anyway, if the import did create a new attribute called ID it would have occured because the exported csv does not have a column called either Object Identifier or Absolute Number, so could not match up on anything, and as a result creates new objects.

The column in the standard view titled ID is actually the attribute Object Identifier (well a pseudo attribute really). Before exporting the csv edit the column title to Object Identifier, then when you run the import again choose Object Identifier as the attribute to match on.

You could also manually edit the CSV file to change the column title ID to Object Identifier (or Absolute Number depending whether a prefix has been included).


-------------------------
Paul Ransley<BR><BR>Beaver Computer Consultants Limited

Edited: 15-Dec-2004 at 11:52 by Paul Ransley
Report this to a Moderator Report this to a Moderator
 16-Dec-2004 16:06
User is offline View Users Profile Print this message


Louie Landale

Posts: 2070
Joined: 12-Sep-2002

Somewhere in the Import process there is an option to define one of the import columns as the "key". This key is used to match CSV rows with objects.

Therefore, when you export you should routinely include the Absolute Number as the first column, and use this column as the "key" when you reimport it.

- Louie
Report this to a Moderator Report this to a Moderator
 17-Dec-2004 11:10
User is offline View Users Profile Print this message


Paul Worrall

Posts: 87
Joined: 30-Sep-2003

Also, avoid using 'ID' as the title of the first column in the CSV file; when you try to open it in Excel (I'm using 97 SR2) Excel thinks it's a SYLK file, and then the SYLK import filter says "file format is not valid" and aborts.
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.