Re: How to import data with a different date format

2010-09-08 Thread Dennis Gearon
ch index for display, 'date', > 'time'. That is, unless I force the user's javascript to > generate the time and date from the unix timestamp. > hmm. > > > > Dennis Gearon > > > > Signature Warning > > > > E

Re: How to import data with a different date format

2010-09-08 Thread Jonathan Rochkind
and date from the unix timestamp. hmm. Dennis Gearon Signature Warning EARTH has a Right To Life, otherwise we all die. Read 'Hot, Flat, and Crowded' Laugh at http://www.yert.com/film.php --- On Wed, 9/8/10, Jonathan Rochkind wrote: From: Jonathan Rochkind Subj

Re: How to import data with a different date format

2010-09-08 Thread Chris Hostetter
: If none of your dates have times, they're all just full days, I'm not sure you : really need the date type at all. : : Convert the date to number-of-days since epoch integer. (Most languages will : have a way to do this, but I don't know about pure XSLT). Store _that_ in a : 1.4 'int' field.

Re: How to import data with a different date format

2010-09-08 Thread Dennis Gearon
//www.yert.com/film.php --- On Wed, 9/8/10, Jonathan Rochkind wrote: > From: Jonathan Rochkind > Subject: Re: How to import data with a different date format > To: "solr-user@lucene.apache.org" > Date: Wednesday, September 8, 2010, 11:35 AM > So the standard 

Re: How to import data with a different date format

2010-09-08 Thread Jonathan Rochkind
as a Right To Life, otherwise we all die. Read 'Hot, Flat, and Crowded' Laugh at http://www.yert.com/film.php --- On Wed, 9/8/10, Jonathan Rochkind wrote: From: Jonathan Rochkind Subject: Re: How to import data with a different date format To: "solr-user@lucene.apache.org"

Re: How to import data with a different date format

2010-09-08 Thread Erick Erickson
That was a general comment on SOLR string types. Mostly I wanted to prompt Rico to try some searching before getting too hung up on indexing refinements. I'd far rather demo a prototype being able to say "Dates don't work yet, but you can search" than "searching is broken to pieces, but dates work

Re: How to import data with a different date format

2010-09-08 Thread Dennis Gearon
Right To Life, otherwise we all die. Read 'Hot, Flat, and Crowded' Laugh at http://www.yert.com/film.php --- On Wed, 9/8/10, Jonathan Rochkind wrote: > From: Jonathan Rochkind > Subject: Re: How to import data with a different date format > To: "solr-user@lucene.apache

Re: How to import data with a different date format

2010-09-08 Thread Jonathan Rochkind
how SOLR-savvy you are, so pardon if this is something you already know. But lots of people trip up over the "string" field type, which is NOT tokenized. You usually want "text" unless it's some sort of ID So it might be worth it to do some searching earlier rather than later Why wo

Re: How to import data with a different date format

2010-09-08 Thread Jonathan Rochkind
YY-MM-DD (which is fairly easy in XSLT) and then adding T00:00:00Z to it. Thanks. - Original Message From: Erick Erickson To: solr-user@lucene.apache.org Sent: Wed, September 8, 2010 12:09:55 PM Subject: Re: How to import data with a different date format I think Markus is spot-on giv

Re: How to import data with a different date format

2010-09-08 Thread Jonathan Rochkind
Just throwing it out there, I'd consider a different approach for an actual real app, although it might not be easier to get up quickly. (For quickly, yeah, I'd just store it as a string, more on that at bottom). If none of your dates have times, they're all just full days, I'm not sure you re

RE: Re: How to import data with a different date format

2010-09-08 Thread Markus Jelsma
Ah, that answers Erick's question. And mine ;)   -Original message- From: Rico Lelina Sent: Wed 08-09-2010 19:25 To: solr-user@lucene.apache.org; Subject: Re: How to import data with a different date format I'm going with option 1, converting MM/DD/ to -MM-DD (which

Re: How to import data with a different date format

2010-09-08 Thread Rico Lelina
I'm going with option 1, converting MM/DD/ to -MM-DD (which is fairly easy in XSLT) and then adding T00:00:00Z to it. Thanks. - Original Message From: Erick Erickson To: solr-user@lucene.apache.org Sent: Wed, September 8, 2010 12:09:55 PM Subject: Re: How to import data

Re: Re: How to import data with a different date format

2010-09-08 Thread Rico Lelina
import data with a different date format Your format (MM/DD/) is not compatible. -Original message- From: Rico Lelina Sent: Wed 08-09-2010 19:03 To: solr-user@lucene.apache.org; Subject: Re: How to import data with a different date format That was my first thought :-) But it would be

Re: How to import data with a different date format

2010-09-08 Thread Erick Erickson
I think Markus is spot-on given the fact that you have 2 days. Using a string field is quickest. However, if you absolutely MUST have functioning dates, there are three options I can think of: 1> can you make your XSLT transform the dates? Confession; I'm XSLT-ignorant 2> use DIH and DateTransform

RE: Re: How to import data with a different date format

2010-09-08 Thread Markus Jelsma
Your format (MM/DD/) is not compatible.   -Original message- From: Rico Lelina Sent: Wed 08-09-2010 19:03 To: solr-user@lucene.apache.org; Subject: Re: How to import data with a different date format That was my first thought :-) But it would be nice to be able to do date queries

Re: How to import data with a different date format

2010-09-08 Thread Rico Lelina
import data with a different date format No. The Datefield [1] will not accept it any other way. You could, however, fool your boss and dump your dates in an ordinary string field. But then you cannot use some of the nice date features. [1]: http://lucene.apache.org/solr/api/org/apache/solr

RE: How to import data with a different date format

2010-09-08 Thread Markus Jelsma
No. The Datefield [1] will not accept it any other way. You could, however, fool your boss and dump your dates in an ordinary string field. But then you cannot use some of the nice date features.   [1]: http://lucene.apache.org/solr/api/org/apache/solr/schema/DateField.html   -Original mess