Hello,
I am trying to index date in ISODate format like this saved in mongoDB
collection using DataImortHandler in SOLR 5.4.1:
{
.
.
"endDate" : ISODate("2019-03-12T21:53:16.841Z")
}
It throws below error:
*java.text.ParseException: Unparseable date: "Tue Mar 12 21:53:16 UTC 2019"*
Below is the configuration SOLR:
*data-source-config.xml:*
<entity name="products"
dataSource="mongod"
transformer="ProdsCatsFieldTransformer,TemplateTransformer"
onError="continue"
pk="uuid"
query="<< query >>"
deltaImportQuery="<<deltaImportQuery>>"
>
<field column="endDate" name="prodendDate" />
<entity name="categories"
dataSource="mongod"
transformer="TemplateTransformer,DateFormatTransformer"
onError="continue"
pk="uuid"
child="true"
query="<<query >>"
deltaImportQuery="<<deltaImportQuery>>"
parentDeltaQuery="<<parentDeltaQuery>>'">
*<field column="prodendDate" template="${products.endDate}" />*
* <field column="endDate" sourceColName="prodendDate"
dateTimeFormat="yyyy-MM-dd'T'HH:mm:ss.SSSZ" locale="en"/>*
</entity>
</entity>
*schema.xml:*
<field name="prodendDate" type="string" indexed="true" stored="false"
required="false" />
*<field name="endDate" type="date" indexed="true" stored="true"
required="false"/>*
Even tried with yyyy-MM-dd'T'HH:mm:ss format but no luck.
Any idea what could be the issue here...
