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
> 

Reply via email to