SAP Knowledge Base Article - Preview

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:

  • 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



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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.