Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 213334

Summary: Duplicate record error when import a CSV into an existing datapool.
Product: z_Archived Reporter: Paul Slauenwhite <paulslau>
Component: TPTPAssignee: Bozier jerome <jerome.bozier>
Status: CLOSED WORKSFORME QA Contact:
Severity: major    
Priority: P1 CC: bjiang, jerome.bozier
Version: unspecifiedKeywords: plan
Target Milestone: ---   
Hardware: All   
OS: All   
Whiteboard:
Attachments:
Description Flags
Screen capture. none

Description Paul Slauenwhite CLA 2007-12-18 12:26:42 EST 
Duplicate record error when import a CSV into an existing datapool.


Running the 'test datapool bufferization (bugzilla : 209263)' test case in
org.eclipse.hyades.test.ui.datapool.tests\manual\datapool\Test.UI.DatapoolEditor_importExport.testsuite
causes the enclosed dialog to be shown.

Jerome B, please investigate.
Comment 1 Paul Slauenwhite CLA 2007-12-18 12:32:24 EST 
Created attachment 85476 [details]
Screen capture.
Comment 2 Paul Slauenwhite CLA 2008-01-24 12:13:16 EST 
*** Bug 117144 has been marked as a duplicate of this bug. ***
Comment 3 Paul Slauenwhite CLA 2008-01-24 12:13:29 EST 
[From https://bugs.eclipse.org/bugs/show_bug.cgi?id=117144]:

When importing from a csv file with equivalence classes and with option "First 
column contains equivalence class names" checked to an existing datapool that 
contains EC with the same name, import will fail with error "CSV file line X: 
Duplicate record.".

This works as designed but datapool editor can be smarter to recognize such 
equivalence classes and perform "appending records" instead of give an error.

csv file contains equivalence classes: https://bugs.eclipse.org/bugs/attachment.cgi?id=30258

datapool with an equivalence class named "good data":
https://bugs.eclipse.org/bugs/attachment.cgi?id=30259
Comment 4 Paul Slauenwhite CLA 2008-05-05 13:20:11 EDT 
This is working as designed.  

When the optional row number is specified with the equivalence class names in the CSV file, that row must be imported in that row of the target datapool.  If that row of the target datapool is already populated, the error message is correctly displayed.  However, when the optional row number is NOT specified with the equivalence class names in the CSV file, the row is appended to the target datapool.
Comment 5 Paul Slauenwhite CLA 2008-06-10 09:49:50 EDT 
Verified in TPTP-4.5.0RC3-200806031051.  Closing.