![]() |
Telelogic DOORS (steve huntington) | ![]() |
new topic :
profile :
search :
help :
dashboard :
calendar :
home
|
||
Latest News:
|
|
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 |
![]() |
![]()
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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.
|
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.