Re: Batch Update Fields

2010-12-05 Thread Adam Estrada
OK so the way I understand this is that if there is a synonym on a specific field at index time, that value will be stored rather than the one in the csv that I am indexing? I will give it a whirl and report back... Thanks! Adam On Sat, Dec 4, 2010 at 2:27 PM, Erick Erickson wrote: > When you de

Re: Batch Update Fields

2010-12-04 Thread Erick Erickson
When you define your fieldType at index time. My idea was that you substitue these on the way in to your index. You may need a specific field type just for your country conversion Perhaps in a copyField if you need both the code and full name Best Erick On Sat, Dec 4, 2010 at 12:16 PM, Ad

Re: Batch Update Fields

2010-12-04 Thread Adam Estrada
Synonyms eh? I have a synonym list like the following so how do I identify the synonyms on a specific field. The only place the field is used is as a facet. original field => country name AF => AFGHANISTAN AX => Ă…LAND ISLANDS AL => ALBANIA DZ => ALGERIA AS => AMERICAN SAMOA AD => ANDORRA AO => AN

Re: Batch Update Fields

2010-12-03 Thread Erick Erickson
That will certainly work. Another option, assuming the country codes are in their own field would be to put the transformations into a synonym file that was only used on that field. That way you'd get this without having to do the pre-process step of the raw data... That said, if you pre-processin

Re: Batch Update Fields

2010-12-03 Thread Adam Estrada
First off...I know enough about Solr to be VERY dangerous so please bare with me ;-) I am indexing the geonames database which only provides country codes. I can facet the codes but to the end user who may not know all 249 codes, it isn't really all that helpful. Therefore, I want to map the full c

Re: Batch Update Fields

2010-12-03 Thread Erick Erickson
Have you consider defining synonyms for your code <->country conversion at index time (or query time for that matter)? We may have an XY problem here. Could you state the high-level problem you're trying to solve? Maybe there's a better solution... Best Erick On Fri, Dec 3, 2010 at 12:20 PM, Ada

Re: Batch Update Fields

2010-12-03 Thread Markus Jelsma
On Friday 03 December 2010 18:20:44 Adam Estrada wrote: > I wonder...I know that sed would work to find and replace the terms in all > of the csv files that I am indexing but would it work to find and replace > key terms in the index? It'll most likely corrupt your index. Offsets, positions etc

Re: Batch Update Fields

2010-12-03 Thread Adam Estrada
I wonder...I know that sed would work to find and replace the terms in all of the csv files that I am indexing but would it work to find and replace key terms in the index? find C:\\tmp\\index\\data -type f -exec sed -i 's/AF/AFGHANISTAN/g' {} \; That command would iterate through all the files i

Re: Batch Update Fields

2010-12-03 Thread Erick Erickson
No, there's no equivalent to SQL update for all values in a column. You'll have to reindex all the documents. On Thu, Dec 2, 2010 at 10:52 PM, Adam Estrada wrote: > OK part 2 of my previous question... > > Is there a way to batch update field values based on a certain criteria? > For example, if

Re: Batch Update Fields

2010-12-03 Thread Markus Jelsma
You must reindex the complete document, even if you just want to update a single field. On Friday 03 December 2010 04:52:04 Adam Estrada wrote: > OK part 2 of my previous question... > > Is there a way to batch update field values based on a certain criteria? > For example, if thousands of docum