Skip to Content
0
Dec 28, 2018 at 05:28 AM

Importing date attribute into Hybris commerce through Data hub

783 Views

Hi Experts,

I am trying to import date attribute to Hybris commerce through Data hub but getting following error:

de.hybris.platform.jalo.JaloInvalidParameterException: cannot parse date '4/8/1996' with specified pattern 'MMM d, yyyy h:mm:ss a' due to Unparseable date: "4/8/1996"

canonical extension code is as follows:

             <attribute>
                 <name>START_DATE</name>
                 <model>
                     <localizable>false</localizable>
                     <collection>false</collection>
                     <type>Date</type>
                     <primaryKey>false</primaryKey>
                 </model>
             </attribute>

In Hybris start date is declared as java.util.Date and I am importing csv file into Data Hub where START_DATE value is 4/8/1996.

The problem is, I cannot set date in 'MMM d, yyyy h:mm:ss a' format as this format contains comma and in csv comma is delimiter. Can someone point out where I need to do changes to parse the date?