Okay, I will give that a try. I could resolve this any other day by being able to execute the same XPATH retrieval twice. Why does the following not work:
<field column="first_date_d" xpath="/add/doc/fie...@name='original_air_date_d']" /> <field column="second_date_s" xpath="/add/doc/fie...@name='original_air_date_d']" /> When I do this, only the second_date_s will make it into the index. I know first_date_d instruction is valid but, it just disappears. Any thoughts? On 4/1/09 11:59 PM, "Noble Paul നോബിള് नोब्ळ्" <noble.p...@gmail.com> wrote: > I guess dateFormat does the job properly but the returned value is > changed according to timezone. > > can y try this out add an extra field which converts the date to toString() > > <field column="original_air_date_d_str" > template="${<entityname>.original_air_date_d}"/> > this would add an extra field as string to the index > > > > On Wed, Apr 1, 2009 at 11:31 PM, Wesley Small <wesley.sm...@mtvstaff.com> > wrote: >> Was there any follow up to this issue I found? Is this a legitimate bug >> with the time of day changing? >> >> I could try to solve this by executing same xpath statement twice. >> >> <field column="original_air_date_d" >> xpath="/add/doc/fie...@name='original_air_date_d']" /> >> >> <field column="temp_original_air_date_s" >> xpath="/add/doc/fie...@name='original_air_date_d']" /> >> >> However, when I do that, the first field original_air_date_d does not make >> it into the index. Is seems that you cannot have two identical xpath >> statements in the data input config file. Is this by design? >> >> >> On 4/1/09 7:45 AM, "Small, Wesley" <wesley.sm...@mtvstaff.com> wrote: >> >>> I have noticed that setting a dynamic date field from source column changes >>> the time within the date. Can anyone confirm this? >>> >>> For example, the document I import has the following xml field. >>> >>> <field name="original_air_date_d">2002-12-18T00:00:00Z</field> >>> >>> >>> In my data-inport-config file I define the following instructions: >>> >>> <field column="temp_original_air_date_s" >>> xpath="/add/doc/fie...@name='original_air_date_d']" /> >>> >>> <field column="original_air_year_s" >>> sourceColName="temp_original_air_date_s" regex="([0-9][0-9][0-9][0-9])[- >>> /.][0-9][0-9][- /.][0- >>> 9][0-9][T][0-9][0-9][:][0-9][0-9][:][0-9][0-9][Z]" replaceWith="$1" /> >>> >>> <field column="original_air_date_d" sourceColName="temp_original_air_date_s" >>> dateTimeFormat="yyyy-MM-dd'T'HH:mm:ss'Z'"/> >>> >>> >>> What is set in my index is is the following: >>> >>> <arr name="temp_original_air_date_s"> >>> <str>2002-12-18T00:00:00Z</str> >>> </arr> >>> >>> <arr name="original_air_year_s"> >>> <str>2002</str> >>> </arr> >>> >>> <arr name="original_air_date_d"> >>> <date>2002-12-18T05:00:00Z</date> >>> </arr> >>> >>> You'll notice that the hour (HH) in original_air_date_d changes is set to >>> 05. It should still be 00. I have noticed that it changes to either 04 or >>> 05 in all cases within my index. >>> >>> In my schema the dynamic field "*_d" >>> <dynamicField name="*_d" type="date" indexed="true" stored="true"/> >>> >>> Thanks, >>> Wesley. >>> >>> >> >> > > > > -- > --Noble Paul >