2542788 - ImpEx fails during Hot Folder import when the csv file contains semicolons

 During hot folder import, you might notice some unexpected behavior or errors when the csv file contains the field delimiter character, which in most cases and by default is the semicolon:

csv.fieldseparator=;

• Unexpected behavior: The data is succesfully imported but the values are not properly assigned to the corresponding header field
• Error: You observe errors such as the one below where if the content of the error is investigated, it can be noticed that one of the items in the value line of the csv file is being assigned to the wrong ImpEx header field which doesn't support this value or its type:

  ,,,,error finding existing item : column='xyz' value='xyz', | column xyz: cannot resolve value 'xyz' for attribute 'xyz';xyz;xyz;;xyz

Read more...

All hybris versions

SAP Hybris Commerce 6.0 ; SAP Hybris Commerce 6.1 ; SAP Hybris Commerce 6.2 ; SAP Hybris Commerce 6.3 ; SAP Hybris Commerce 6.4 ; SAP Hybris Commerce 6.5 ; SAP hybris Commerce 5.0.3 ; SAP hybris Commerce 5.0.4 ; SAP hybris Commerce 5.7 ; SAP hybris Commerce Suite 5.2 ; SAP hybris Commerce Suite 5.3 ; SAP hybris Commerce Suite 5.4 ; SAP hybris Commerce Suite 5.5 ; SAP hybris Commerce Suite 5.5-1 ; SAP hybris Commerce Suite 5.6 ; hybris Commerce Suite 5.0 ; hybris Commerce Suite 5.1 ; hybris Commerce Suite 5.1.1

• semi colon
• semicolumn
• semi column
• field delimiter
• field separator
• fieldseparator
• escaped
• special character

, KBA , CEC-COM-CPS , SAP Commerce , Problem