Well, the thing you’re getting back from MongoDB isn’t the ISO date format. I
don’t know enough about MongoDB to understand how to get it to spit out the
date in the correct format, but that’s where you need to look.
Best,
Erick
> On May 10, 2019, at 2:13 PM, Abhijit Pawar <aapawar.s...@gmail.com> wrote:
>
> 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...
