View Issue Details

IDProjectCategoryView StatusLast Update
0006103OXID ERP InterfaceOXID ERP Interface - subpublic2015-12-01 12:53
Reportermartinwegele Assigned To 
PrioritylowSeveritytweakReproducibilityalways
Status acknowledgedResolutionopen 
Product Version2.14.0 
Summary0006103: exported CSV files cannot be imported again because of different sequence of fields
DescriptionIf you export e.g. articles via CSV and then take this file to import the articles again, your data will end up in the wrong fields of the tables in the shop's database because the sequence of the fields is different for import and export.
That's because OXSHOPINHERITEDSHOPIDS is on 3rd position in the field list in \oxERPType_Article::$_aFieldListVersions[13] but the field does not actually exist in the database. The sequence of the fields in the import files is determined by this array.
I suppose that for the export this "virtual field" is just appended to the "real fields" from the database table so it ends up being the last in the exported CSV file: oxERPType::addExportData
TagsSolution Provided

Relationships

related to 0006101 resolvedarturas.sevcenko number of fields is wrong in docu for CSV 

Activities

martinwegele

2015-03-26 15:34

reporter   ~0010836

Last edited: 2015-03-26 15:49

Workaround: Move the field to the last position in the list in modules/erp/objects/oxerptype_*.php. That way it will be the last field in the import file, too.