View Issue Details

IDProjectCategoryView StatusLast Update
0004944OXID eShop (all versions)2.8. Servicepublic2013-02-22 10:16
Reportermartinwegele 
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Product Version4.7.3 / 5.0.3 revision 54408 
Target VersionFixed in Version4.7.4 / 5.0.4 revision 57063 
Summary0004944: CSV-import reports wrong number
DescriptionIf you try to import a CSV file that contains articles with identical OXIDs you will get a message saying:
"Die CSV-Daten wurden erfolgreich importiert.
[~CSV data was imported successfully.]
Zeilen wurden importiert: 288
[~Number of imported lines:]"

This confirmation is wrong since only one of the articles is put into the DB because of the identical OXIDs.
I know that this csv is wrong. But if customers try to import this, they will get the confirmation message and think everything is fine when it is not.
Steps To ReproduceIn a PE use the import function with the attached file.
TagsNo tags attached.
ThemeBoth
BrowserAll
PHP Versionany
MySQL Versionany

Activities

martinwegele

2013-02-19 11:45

reporter  

test.txt (930 bytes)
OXID;OXPARENTID;OXARTNUM;OXTITLE;OXVARSELECT;OXPRICE;OXSORT
337a43b272b28e3b18e9dc53c26ff74c;01201199;01201200;test article csv;01 | 70 cm | 120 cm;2050,6;1
337a43b272b28e3b18e9dc53c26ff74c;01201199;01201201;test article csv;01 | 70 cm | 140 cm;2175,7;2
337a43b272b28e3b18e9dc53c26ff74c;01201199;01201202;test article csv;01 | 70 cm | 160 cm;2260,8;3
337a43b272b28e3b18e9dc53c26ff74c;01201199;01201203;test article csv;01 | 70 cm | 180 cm;2350,9;4
337a43b272b28e3b18e9dc53c26ff74c;01201199;01201204;test article csv;01 | 70 cm | 200 cm;2501;5
337a43b272b28e3b18e9dc53c26ff74c;01201199;01201205;test article csv;01 | 70 cm | 220 cm;2591,1;6
337a43b272b28e3b18e9dc53c26ff74c;01201199;01201206;test article csv;01 | 70 cm | 240 cm;2676,2;7
337a43b272b28e3b18e9dc53c26ff74c;01201199;01201207;test article csv;01 | 70 cm | 260 cm;2751,3;8
337a43b272b28e3b18e9dc53c26ff74c;01201199;01201208;test article csv;01 | 90 cm | 120 cm;2342,2;9
test.txt (930 bytes)

tadas

2013-02-22 10:16

reporter   ~0008437

Row count returned will be equal to the number of affected rows.
So if oxid is the same for all lines, only one database field will be affected, and the result will be: 1 successful row.