View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0004944 | OXID eShop (all versions) | 2.8. Service | public | 2013-02-19 11:45 | 2013-02-22 10:16 |
Reporter | martinwegele | ||||
Priority | normal | Severity | minor | Reproducibility | always |
Status | resolved | Resolution | fixed | ||
Product Version | 4.7.3 / 5.0.3 revision 54408 | ||||
Target Version | Fixed in Version | 4.7.4 / 5.0.4 revision 57063 | |||
Summary | 0004944: CSV-import reports wrong number | ||||
Description | If 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 Reproduce | In a PE use the import function with the attached file. | ||||
Tags | No tags attached. | ||||
Theme | Both | ||||
Browser | All | ||||
PHP Version | any | ||||
Database Version | any | ||||
|
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 |
|
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. |