Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

2010-08-02 Thread PeterKerk
I'm running MSSQL Server 2008 I did this: set CLASSPATH= C:\Program Files\Microsoft SQL Server JDBC Driver 3.0\sqljdbc_3.0\enu\sqljdbc4.jar (I dont know where I can check if this has been executed correctly) Then when approaching this URL:

Re: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

2010-08-02 Thread PeterKerk
Hi Gora, I just ran the classpath command in a DOS command prompt, that normally works for regular PATH variable as well. Your suggestion for the open source JTDS driver sounds good. So if you look at my data-config.xml: dataConfig dataSource driver=com.microsoft.sqlserver.jdbc.SQLServerDriver

RE: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

2010-08-02 Thread PeterKerk
@Michael: your suggestion to place the jar file in that folder has brought me 1 step further. Now I get a new error. It seems as if the user cannot log in. Strange because it IS the correct pwd. In my MSSQL mgmt studio I provide: server name: (local) login: sa password:123456 Now if you look at

Re: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

2010-08-02 Thread PeterKerk
And found another thing, even when I have this in my data-config.xml (a totally deformed XML file), I still get the same login failed error...where I would expect something like a non-well formed XML document error... Im using cygwin...dont know if that caches anything, but its still weird I

Re: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

2010-08-02 Thread PeterKerk
Hi Michael, Thanks, I now use that. But the same error. (PS. is there a way where I can test the current connectionstring?) Therefore I have attached 1 image with 2 screenshots of my situation. http://lucene.472066.n3.nabble.com/file/n1017327/Untitled.png Untitled.png Here's my current

Re: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

2010-08-03 Thread PeterKerk
Hooray, im a bit further now... Turned out that both SQL2005 and 2008 were running, where 2005 was listening on port 1433. I disabled that services, enabled the 2008 service and now I can connect and the command http://localhost:8983/solr/db/dataimport?command=full-import is successfull. But

Re: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

2010-08-03 Thread PeterKerk
Thanks for the quick reply :) Here it is: ?xml version=1.0 encoding=UTF-8 ? !-- Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file distributed with this work for additional information regarding copyright ownership. The

Re: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

2010-08-03 Thread PeterKerk
Ok, downloaded luke, but how do I run it? Tried googling it, but no luck...do I need to put in in some folder? And is there anything with regard to the casing of the columns? For example, I now have select FEATUREID and field column=TITLE name=title / in my data-config However, my DB

RE: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

2010-08-03 Thread PeterKerk
I had a look at this URL: http://localhost:8983/solr/db/admin/dataimport.jsp?handler=/dataimport There I see the data-config.xml on the left side and the full data import result on the right. The response is: response − lst name=responseHeader int name=status0/int int name=QTime234/int /lst −

RE: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

2010-08-03 Thread PeterKerk
Hi, You are correct that locationid is an integer. I have changed it to: entity name=location_theme query=select themeid from location_themes where locationid=${location.ID} But then I get the error: Incorrect syntax near '=' Even though that statement does work in mgmt studio SEVERE: Full

RE: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

2010-08-03 Thread PeterKerk
Awesome! You did it! Turned out, I had to change the casing of this line: entity name=location_feature query=select featureid from location_features where locationid='${location.ID}' to: entity name=location_feature query=select featureid from location_features where locationid='${location.id}'

Indexing boolean value

2010-08-04 Thread PeterKerk
Im trying to index a boolean location, but for some reason it does not show up in my indexed data. data-config.xml entity name=location query=select * from locations field name=id column=ID / field name=title column=TITLE / field name=city column=CITY

RE: Indexing fieldvalues with dashes and spaces

2010-08-04 Thread PeterKerk
I changed values to text_ws Now I only seem to have problems with fieldvalues that hold spacessee below: field name=city type=text_ws indexed=true stored=true/ field name=theme type=text_ws indexed=true stored=true multiValued=true omitNorms=true termVectors=true / field

RE: Indexing boolean value

2010-08-04 Thread PeterKerk
Hi, I tried that already, so that would make this: field name=official type=integer indexed=true stored=true/ copyField source=official dest=text / (still not sure what copyField does though) But even that wont work. I also dont see the officallocation columns indexed in the documents:

RE: Indexing fieldvalues with dashes and spaces

2010-08-04 Thread PeterKerk
Sorry, but Im a newbie to Solr...how would I change my schema.xml to match your requirements? And what do you mean by it will mess with your results? What will happen then? -- View this message in context:

RE: Indexing fieldvalues with dashes and spaces

2010-08-04 Thread PeterKerk
Well the example you provided is 100% relevant to me :) I've read the wiki now (SchemaXml,SolrFacetingOverview,Query Syntax, SimpleFacetParameters), but still do not have an exact idea of what you mean. My situation: a city field is something that I want users to search on via text input, so

RE: Indexing fieldvalues with dashes and spaces

2010-08-05 Thread PeterKerk
@Michael, @Erick, You both mention interesting things that triggered me. @Erick: Your referenced page is very useful. It seems the whitespace tokenizer under the text_ws is causing issues. You do mention another interesting thing: And do be aware that fields you get back from a request (i.e. a

Re: Indexing fieldvalues with dashes and spaces

2010-08-06 Thread PeterKerk
. HTH Erick On Thu, Aug 5, 2010 at 4:31 AM, PeterKerk vettepa...@hotmail.com wrote: @Michael, @Erick, You both mention interesting things that triggered me. @Erick: Your referenced page is very useful. It seems the whitespace tokenizer under the text_ws is causing issues. You do

Re: Indexing fieldvalues with dashes and spaces

2010-08-09 Thread PeterKerk
Hi Erick, Ok. its more clear now. I indeed have the whitespace tokenizer: fieldType name=textTrue class=solr.TextField positionIncrementGap=100 analyzer tokenizer class=solr.WhitespaceTokenizerFactory/ filter class=solr.SynonymFilterFactory synonyms=synonyms.txt

Re: Indexing fieldvalues with dashes and spaces

2010-08-19 Thread PeterKerk
Sorry for late reply, just back from holiday :) I did what you mentioned: field name=services_raw type=string indexed=true stored=true multiValued=true/ copyField source=services dest=services_raw/ and then in url facet.field=services_raw It works...awesome, thanks! -- View this message in

Showing results based on facet selection

2010-08-19 Thread PeterKerk
I have indexed all data (as can be seen below). But now I want to be able to simulate when a user clicks on a facet value, for example clicks on the value Gemeentehuis of facet themes_raw AND has a selection on features facet on value Strand I've been playing with facet.query function:

Autosuggest on PART of cityname

2010-08-19 Thread PeterKerk
I want to have a Google-like autosuggest function on citynames. So when user types some characters I want to show cities that match those characters but ALSO the amount of locations that are in that city. Now with Solr I now have the parameter: fq=title:Bost But the result doesnt show the city

RE: Autosuggest on PART of cityname

2010-08-19 Thread PeterKerk
Ok, I now tried this: http://localhost:8983/solr/db/select/?wt=jsonindent=onq=*:*fl=cityfacet.field=cityfacet.prefix=Bost Then I get: { responseHeader:{ status:0, QTime:0, params:{ fl:city, indent:on, q:*:*, facet.prefix:Bost, facet.field:city,

RE: Autosuggest on PART of cityname

2010-08-20 Thread PeterKerk
Ok, I now do this (searching for utr in cityname): http://localhost:8983/solr/db/select/?wt=jsonindent=onq=*:*rows=0facet=truefacet.field=cityfacet.prefix=utr In the DB there's 1 location with cityname 'Utrecht' and the other 1 is with 'Utrecht Overvecht' So in my dropdown I would like: Utrecht

Re: Autosuggest on PART of cityname

2010-08-20 Thread PeterKerk
@Markus: thanks, will try to work with that. @Gijs: I've looked at the site and the search function on your homepage is EXACTLY what I need! Do you have some Solr code samples for me to study perhaps? (I just need the relevant fields in the schema.xml and the query url) It would help me a lot!

Show a facet filter All

2010-09-05 Thread PeterKerk
I have the facets below. As you can see the number of results for that facet are behind it. But I also want to show an option to the user that says All (x results). That would show the results if this filter was not used. Do bear in mind that I have more facet filters so simply using the numFound

RE: Show a facet filter All

2010-09-06 Thread PeterKerk
Just talking about it helped me in deciding this is not something I want :) Thanks! :) -- View this message in context: http://lucene.472066.n3.nabble.com/Show-a-facet-filter-All-tp1421248p1425600.html Sent from the Solr - User mailing list archive at Nabble.com.

Building query based on value of boolean field

2010-09-09 Thread PeterKerk
I have this field in my schema.xml: field name=partylocation type=boolean indexed=true stored=true/ This one in my data-config: field name=partylocation column=PARTYLOCATION / Now, how can I return all results for which partylocation = true? Thanks! -- View this message in

Re: Building query based on value of boolean field

2010-09-10 Thread PeterKerk
Oh and the field in the result looks like: bool name=partylocationfalse/bool but when I do this: q=partylocation:false I still get no results! :s -- View this message in context: http://lucene.472066.n3.nabble.com/Building-query-based-on-value-of-boolean-field-tp1449018p1453266.html Sent from

Calculating distances in Solr using longitude latitude

2010-09-19 Thread PeterKerk
I want users to be able to filter buildings in my database, by enerting a random zipcode with a certain distance around it (in kilometers). e.g.: 90210 with a radius of 50kilometer. The longitude and latitude of a specific building are in the database. When the user searches on a zipcode, I can

Re: Calculating distances in Solr using longitude latitude

2010-09-20 Thread PeterKerk
Hi Dennis, Good suggestion, but I see that most of that is Solr 4.0 functionality, which has not been released yet. How can I still use the longitude latitude functionality (LatLonType)? Thanks! -- View this message in context:

Re: Calculating distances in Solr using longitude latitude

2010-09-22 Thread PeterKerk
Dennis Gearon wrote: Soo, the short term answer is to use a function column to query against? Prefereably with a bounding box, of course. :-) What do you mean by that? Calculate all locations within a certain range (bounding box) and query on that? I hope not, because that would be a

Range query not working

2010-09-23 Thread PeterKerk
I have this in my query: q=*:*facet.query=location_rating_total:[3 TO 100] And this document: result name=response numFound=6 start=0 maxScore=1.0 − doc float name=score1.0/float str name=id1/str int name=location_rating_total2/int /doc But still my total results equals 6 (total population)

Re: Range query not working

2010-09-23 Thread PeterKerk
Forgot to mention..I tried that too already. So when I have: location_rating_total:[0 TO 100] It shows only the location for which the location_rating_total is EXACTLY 0...locations that have location_rating_total value of 2 are NOT included. Any other suggestions? -- View this message in

Re: Range query not working

2010-09-23 Thread PeterKerk
This is the field in my schema.xml: field name=location_rating_total type=integer indexed=true stored=true/ Also in the response it clearly shows: int name=location_rating_total0/int What else can I do? -- View this message in context:

Re: Range query not working

2010-09-24 Thread PeterKerk
It works! :) @Jonathan: Indeed, I'm using Solr1.4.1 example schema. I have now added: in schema.xml fieldType name=int class=solr.TrieIntField precisionStep=0 omitNorms=true positionIncrementGap=0/ changed relevant fields in schema.xml from integer to int Thanks! -- View this message in

LocalSolr unknown handler: geo

2010-09-24 Thread PeterKerk
I've configured LocalSolr according to description on this page: http://www.gissearch.com/localsolr I use Solr 1.4.1. I've compiled the LocalSolr jars and put them in the Solr lib: \apache-solr-1.4.1\example\solr\lib The lib folder didnt exist so I created it and put the LocalSolr jars in

Re: LocalSolr unknown handler: geo

2010-09-24 Thread PeterKerk
I tried looking for a place where I could ask those questions, but where can I find the LocalSolr mailinglist you are referring to? Thanks! -- View this message in context: http://lucene.472066.n3.nabble.com/LocalSolr-unknown-handler-geo-tp1572964p1573583.html Sent from the Solr - User mailing

Re: Is Solr right for my business situation ?

2010-09-27 Thread PeterKerk
@Walter Underwood: Walter Underwood wrote: Right now, I think the only way to get spatial search in Solr is to deploy a nightly snapshot from the active development on trunk. Could you give me the link to this trunk, I need it very much! Thanks! -- View this message in context:

Re: Is Solr right for my business situation ?

2010-09-27 Thread PeterKerk
Ah, totally looked over that news: spatial search in 3.x! :-D :-D Any idea already when this will be released? Awesome to hear that it has been moved forward! :) -- View this message in context: http://lucene.472066.n3.nabble.com/Is-Solr-right-for-our-project-tp1589927p1592448.html Sent from

Format version is not supported in file 'segments_gw': 0 (needs to be between -9 and -10). This version of Lucene only supports indexes created with release 3.0 and later.

2012-02-12 Thread PeterKerk
Im getting the error below all of a sudden. AFAIK i haven't touched anything with Lucene. I did add a fields to my schema and data-config.xml: data-config.xml: field name=userid column=userid / schema.xml: field name=userid type=string indexed=true stored=true / But removed those again later. I

Re: Format version is not supported in file 'segments_gw': 0 (needs to be between -9 and -10). This version of Lucene only supports indexes created with release 3.0 and later.

2012-02-13 Thread PeterKerk
I have no idea how to check that. Also I have no idea how I would attach a trunk Solr to a 1.4 index, so it's not very likely I actually did that :) My Solr folder looks like this: C:\My Dropbox\Dropbox\inetpub\apache-solr-4.0-2010-10-12_08-05-48\example\example-DIH\solr How would I check what

sort my results alphabetically on facetnames

2012-02-14 Thread PeterKerk
I want to sort my results on the facetnames (not by their number of results). So now I have this (ordered by number of results): Instelling voor auditief gehandicapten (16) Audiologisch centrum (13) Huisartsenpraktijk (13) Instelling voor lichamelijk gehandicapten (13) Ambulancezorg (12)

Need tokenization that finds part of stringvalue

2012-02-28 Thread PeterKerk
I have the following in my schema.xml field name=title type=text_ws indexed=true stored=true/ field name=title_search type=text indexed=true stored=true/ fieldType name=text class=solr.TextField positionIncrementGap=100 analyzer type=index tokenizer

Re: Need tokenization that finds part of stringvalue

2012-03-01 Thread PeterKerk
I think I didnt explain myself clearly: I need to be able to find substrings. So, its not that I'd expect Solr to find synonyms, but rather if a piece of text contains the searched text, for example: if title holds smartphone I want it to be found when someone types martph or smar or smart. I

Re: Need tokenization that finds part of stringvalue

2012-03-01 Thread PeterKerk
@iorixxx: yes, that is what I need. But also when its IN the text, not necessarily at the beginning. So using the * character like: q=smart* the product is found, but when I do this: q=*mart* it isnt...why is that? -- View this message in context:

Re: Need tokenization that finds part of stringvalue

2012-03-01 Thread PeterKerk
@iorixxx: Where can I find that example schema.xml? I downloaded the latest version here: ftp://apache.mirror.easycolocate.nl//lucene/solr/3.5.0 And checked \example\example-DIH\solr\db\conf\schema.xml But no text_rev type is defined in there. And when I find it, can I just make the title field

Re: Need tokenization that finds part of stringvalue

2012-03-04 Thread PeterKerk
@iorixxx I tried making my title_search of type text_rev and tried adding the ReversedWildcardFilterFactory to my existing text type, but in both cases no luck. @Erick Erickson On frequent method of doing leading and trailing wildcards is to use ngrams (as distinct from edgengrams). That in

org.apache.solr.common.SolrException: Error loading class 'org.apache.solr.handler.dataimport.DataImportHandler'

2012-03-04 Thread PeterKerk
I wanted to to upgrade from version apache-solr-4.0-2010-10-12_08-05-48 to apache-solr-3.5.0. I installed apache-solr-3.5.0 and then copied all stuff from \example-DIH\solr of old installation to \example-DIH\solr but then I get the following error after I restart my server and try to do a

Re: Need tokenization that finds part of stringvalue

2012-03-06 Thread PeterKerk
@iorixxx: Sorry it took so long, had some difficulties upgrading to 3.5.0 It still doesnt work. Here's what I have now: I copied text_general_rev from http://svn.apache.org/repos/asf/lucene/dev/trunk/solr/example/solr/conf/schema.xml to my schema.xml: fieldType name=text_general_rev

Re: Need tokenization that finds part of stringvalue

2012-03-06 Thread PeterKerk
edismax did the trick! Thanks! -- View this message in context: http://lucene.472066.n3.nabble.com/Need-tokenization-that-finds-part-of-stringvalue-tp3785366p3805045.html Sent from the Solr - User mailing list archive at Nabble.com.

Filter on multiple word field of type string not showing any results

2012-12-31 Thread PeterKerk
I'm trying to filter on the field functiontitle_nl when the user selects Management en Organisatie, but I'm getting 0 results. The actual value in the DB is Management en Organisatie. This is the URL I build up to query the Solr index:

how to perform a delta-import when related table is updated

2013-01-11 Thread PeterKerk
My delta-import (http://localhost:8983/solr/freemedia/dataimport?command=delta-import) does not correctly update my solr fields. Please see my data-config here: entity name=freemedia query=select * from freemedia WHERE categoryid0 deltaImportQuery=select * from freemedia

RE: how to perform a delta-import when related table is updated

2013-01-11 Thread PeterKerk
Hi James, Ok, so I did this: entity name=freemedia query=select * from freemedia WHERE categoryid0 deltaImportQuery=select * from freemedia WHERE updatedate lt; getdate() AND id='${dataimporter.delta.id}' AND categoryid0 deltaQuery=select id from freemedia where id in

RE: how to perform a delta-import when related table is updated

2013-01-11 Thread PeterKerk
Awesome! This one line did the trick: entity name=freemedia pk=id query=select * from freemedia WHERE categoryid0 Thanks! -- View this message in context: http://lucene.472066.n3.nabble.com/how-to-perform-a-delta-import-when-related-table-is-updated-tp4032587p4032671.html Sent from the Solr

Implement price range filter: DataImportHandler started. Not Initialized. No commands can be run

2013-02-14 Thread PeterKerk
On all products I have I want to implement a price range filter. Since this pricerange is applied on the entire population and not on a single product, my assumption was that it would not make sense to define this within the shopitem entity, but rather under the document shopitems. So that's what

RE: Implement price range filter: DataImportHandler started. Not Initialized. No commands can be run

2013-02-14 Thread PeterKerk
Ok, but I restarted solr several times and the issue still occurs. So my guess is that the entity I added contains errors: entity name=amp;quot;pricerangeamp;quot; query=amp;quot;;With Categorized as (Select CASE When prijs amp;amp;lt;= 1000 Then 'amp;lt;10' When prijs amp;amp;gt; 1000

RE: Implement price range filter: DataImportHandler started. Not Initialized. No commands can be run

2013-02-14 Thread PeterKerk
Ok, something went wrong with posting the code,since I did not escape the quotes and ampersands. I tried your code, but nu luck. Here's the original query I'm trying to execute. What characters do I need to escape? I thought only the and characters? Thanks! -- View this message in

geodist() spatial sorting: sort param could not be parsed as a query, and is not a field that exists in the index: geodist()

2013-02-28 Thread PeterKerk
I want to sort the results of my query on distance. But I get this error: sort param could not be parsed as a query, and is not a field that exists in the index: geodist() On this query:

Re: geodist() spatial sorting: sort param could not be parsed as a query, and is not a field that exists in the index: geodist()

2013-02-28 Thread PeterKerk
You were right, sloppy on my side. I replaced the %20 with (in more than 1 place) and now it does work. Thanks. -- View this message in context:

full-data import suddenly stopped working. Total Rows Fetched remains 0

2011-12-16 Thread PeterKerk
My full-data import stopped working all of a sudden. Afaik I have not made any changes that would cause this. The response is: response script/ lst name=responseHeader int name=status0/int int name=QTime0/int /lst lst name=initArgs lst name=defaults str name=configwedding-data-config.xml/str

full-data import suddenly stopped working. Total Rows Fetched remains 0

2011-12-19 Thread PeterKerk
My full-data import stopped working all of a sudden. Afaik I have not made any changes that would cause this. Everything is deleted from the index, but no files are added anymore. I dont receive any errors either...:S STARTING via Cygwin: cd /cygdrive/c/My\

Re: full-data import suddenly stopped working. Total Rows Fetched remains 0

2011-12-19 Thread PeterKerk
Hi Chantal, I reduced my data-config.xml to a bare minimum: dataConfig dataSource driver=com.microsoft.sqlserver.jdbc.SQLServerDriver url=jdbc:sqlserver://localhost:1433;databaseName=tt user=sa password=dfgjLJSFSD / document name=weddinglocations entity name=location query=select

Re: full-data import suddenly stopped working. Total Rows Fetched remains 0

2011-12-20 Thread PeterKerk
Chantal...you are the queen! :p That was it, I downgraded to 6.27 and now it works again...thank god! -- View this message in context: http://lucene.472066.n3.nabble.com/full-data-import-suddenly-stopped-working-Total-Rows-Fetched-remains-0-tp3599004p3601013.html Sent from the Solr - User

Re: Spatial search in Solr 1.5

2010-10-12 Thread PeterKerk
Hey Grant, Just came accross this post of yours. Run a query: http://localhost:8983/solr/select/?q=_val_:recip(dist(2, store, vector(34.0232,-81.0664)),1,1,0)fl=*,score // Note, I just updated this, it used to be point instead of vector and that was wrong. What does your suggested query

Re: Spatial search in Solr 1.5

2010-10-12 Thread PeterKerk
Ok, so does this actually say: for now you have to do calculations based on bounding box instead of great circle? And the fact that on top of the page it says Solr4.0, does that imply I cant use this right now? Or where could I find the latest trunk for this? (and ofcourse this might all change

Re: Spatial search in Solr 1.5

2010-10-13 Thread PeterKerk
Hi, Thanks for the quick reply :) I downloaded the latest version from the trunk. Got it up and running, and got the error below: URL:

Re: Spatial search in Solr 1.5

2010-10-13 Thread PeterKerk
Im now thinking I downloaded the wrong solr zip, I tried this one: https://hudson.apache.org/hudson/job/Solr-trunk/lastSuccessfulBuild/artifact/trunk/solr/dist/apache-solr-4.0-2010-10-12_08-05-48.zip In that example scheme

Re: Spatial search in Solr 1.5

2010-10-13 Thread PeterKerk
haha ;) But so I DO have the right solr version? Anyways...I have added the lines you mentioned, what else can I do? Thanks again! -- View this message in context: http://lucene.472066.n3.nabble.com/Spatial-search-in-Solr-1-5-tp489948p1694683.html Sent from the Solr - User mailing list

Re: Spatial search in Solr 1.5

2010-10-13 Thread PeterKerk
ArggghhhI was working in OLD data-config...it now works! :) Thanks, this is a GREAT addition. I do like to know when the final implementation of this feature is implemented (as I understood it might change in the final release). Which issue can I subscribe to, to be informed? Thanks

Re: check if field CONTAINS a value, as opposed to IS of a value

2010-10-14 Thread PeterKerk
This is the definition fieldType name=string class=solr.StrField sortMissingLast=true omitNorms=true/ field name=introtext type=string indexed=true stored=true/ -- View this message in context:

Re: check if field CONTAINS a value, as opposed to IS of a value

2010-10-14 Thread PeterKerk
Correct, thanks! I have used the following: fieldType name=text class=solr.TextField positionIncrementGap=100 analyzer type=index tokenizer class=solr.WhitespaceTokenizerFactory/ filter class=solr.StopFilterFactory ignoreCase=true words=stopwords_dutch.txt/

Re: check if field CONTAINS a value, as opposed to IS of a value

2010-10-14 Thread PeterKerk
It DOES work :) Oh and on the filtersis there some sort of debug/overview tool to see what each filter does and what an input string look like after going through a filter? -- View this message in context:

Re: check if field CONTAINS a value, as opposed to IS of a value

2010-10-14 Thread PeterKerk
Awesome again! And for my understanding, I type a single word Boston and then I see 7 lines of output: Boston Boston Boston Boston boston boston boston So each line represents what is done to the query value after it has passed through the filter? -- View this message in context:

Uppercase and lowercase queries

2010-10-19 Thread PeterKerk
I want to query on cityname. This works when I query for example: Boston But when I query boston it didnt show any results. In the database is stored: Boston. So I thought: I should change the filter on this field to make everything lowercase. The field definition for city is: field name=city

Re: Uppercase and lowercase queries

2010-10-19 Thread PeterKerk
I now used textfield...and it works, so thanks! :) -- View this message in context: http://lucene.472066.n3.nabble.com/Uppercase-and-lowercase-queries-tp1731349p1731423.html Sent from the Solr - User mailing list archive at Nabble.com.

Solr Javascript+JSON not optimized for SEO

2010-10-22 Thread PeterKerk
Hi, When I retrieve data via javascript+JSON method (instead of REST via URL), the link which I click does not reflect what the user will end up seeing. Example for showing the features belonging to a LED TV product: JSON getFeatureFacets('LEDTV') Get features for LED TV REST

Re: Solr Javascript+JSON not optimized for SEO

2010-10-23 Thread PeterKerk
Unfortunately its not online yet, but is there anything I can clarify in more detail? Thanks! -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-Javascript-JSON-not-optimized-for-SEO-tp1751641p1758054.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Solr Javascript+JSON not optimized for SEO

2010-10-25 Thread PeterKerk
Offering both...that sounds to me like duplicating development efforts? Or am I overseeing something here? Nick Jenkin-2 wrote: NB: it's faster is not a valid answer! Why is it not valid? Because its not necessarily faster or...? And what about user experience? Instead of needing to

indexing '-

2010-10-31 Thread PeterKerk
I have a city named 's-Hertogenbosch I want it to be indexed exactly like that, so 's-Hertogenbosch (without ) But now I get: lst name=city int name=hertogenbosch1/int int name=s1/int int name=shertogenbosch1/int /lst What filter should I add/remove from my field

Re: indexing '-

2010-10-31 Thread PeterKerk
I already tried the normal string type, but that doesnt work either. I now use this: fieldType name=mytype class=solr.TextField sortMissingLast=true omitNorms=true analyzer tokenizer class=solr.KeywordTokenizerFactory/ /analyzer /fieldType But that doesnt do it

RE: indexing '-

2010-11-01 Thread PeterKerk
Guys, the string type did the trick :) Thanks -- View this message in context: http://lucene.472066.n3.nabble.com/indexing-tp1816969p1823199.html Sent from the Solr - User mailing list archive at Nabble.com.

Solr like for autocomplete field?

2010-11-02 Thread PeterKerk
I have a city field. Now when a user starts typing in a city textbox I want to return found matches (like Google). So for example, user types new, and I will return new york, new hampshire etc. my schema.xml field name=city type=string indexed=true stored=true/ my current url:

Facet showing MORE results than expected when its selected?

2010-11-10 Thread PeterKerk
A facet shows the amount of results that match with that facet, e.g. New York (433) So when the facet is clicked, you'd expect that amount of results (433). However, I have a facet Hotel en Restaurant (321), that, when clicked shows 370 results! :s 1st query:

RE: Facet showing MORE results than expected when its selected?

2010-11-10 Thread PeterKerk
LOL, very clever indeed ;) The thing is: when I select the amount of records matching the theme 'Hotel en Restaurant' in my db, I end up with 321 records. So that is correct. I dont know where the 370 is coming from. Now when I change the query to this: fq=themes_raw:Hotel en Restaurant I end

Re: Facet showing MORE results than expected when its selected?

2010-11-10 Thread PeterKerk
Nope, I restarted my server to reload schema.xml, and did a reindex, as I've done a thousand times before, but still the same behaviour :( -- View this message in context: http://lucene.472066.n3.nabble.com/Facet-showing-MORE-results-than-expected-when-its-selected-tp1878828p1879218.html Sent

Re: Facet showing MORE results than expected when its selected?

2010-11-10 Thread PeterKerk
Nope, thats not possible either since the themename is stored in the database in table [themes] only once, and other locations refer to it using the link table [location_themes] simple DB scheme using a link table: [themes] id name [location_themes] locationid themeid [locations] id name etc

Re: Facet showing MORE results than expected when its selected?

2010-11-10 Thread PeterKerk
O wow, the quotes did the trick...thanks! :) -- View this message in context: http://lucene.472066.n3.nabble.com/Facet-showing-MORE-results-than-expected-when-its-selected-tp1878828p1879335.html Sent from the Solr - User mailing list archive at Nabble.com.

full text search in multiple fields

2010-11-12 Thread PeterKerk
I want to provide a full text search function. This function has to search through the 2 fields: title and description that I have defined in my schema.xml (both of type string). Now, since solr doesnt (by default) provide an or operator, I thought I should somehow combine these fields into 1

Re: full text search in multiple fields

2010-11-13 Thread PeterKerk
All helpful responses, so thank you for that. I checked the url: http://wiki.apache.org/solr/DisMaxQParserPlugin When I execute this url on my local machine: http://localhost:8983/solr/select/?q=videoqt=defType=dismaxqf=features^20.0+text^0.3 I get the error: unknown handler: defType=dismax

Re: full text search in multiple fields

2010-11-14 Thread PeterKerk
Ok, thanks. it works now for title and description fields. :) But now I also need it for the city. And I cant get that to work, even though im doing the exact same (or so I think). I now have the code below for the city field. (Im defining city field twice in my data-config and schema.xml but

Re: full text search in multiple fields

2010-11-14 Thread PeterKerk
both queries give me 0 results... -- View this message in context: http://lucene.472066.n3.nabble.com/full-text-search-in-multiple-fields-tp1888328p1900648.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: full text search in multiple fields

2010-11-14 Thread PeterKerk
Ok, that makes sense ;) but I dont understand why its not indexed. IMO, I've defined the city_search field the exact same as city in the schema.xml: field name=city type=string indexed=true stored=true/ field name=city_search type=string indexed=true stored=true/ copyField source=city_search

Re: full text search in multiple fields

2010-11-15 Thread PeterKerk
@Erick: Nope, those fields indeed arent chainable, I used iorixxx's solution and now it works. :) -- View this message in context: http://lucene.472066.n3.nabble.com/full-text-search-in-multiple-fields-tp1888328p1903486.html Sent from the Solr - User mailing list archive at Nabble.com.

finding exact case insensitive matches on single and multiword values

2010-12-03 Thread PeterKerk
Users call this URL on my site: /?search=1city=den+haag or even /?search=1city=Den+Haag (casing of ctyname can be anything) Under water I call Solr: http://localhost:8983/solr/db/select/?indent=onfacet=truefq=city:den+haagq=*:*start=0rows=25fl=id,title,friendlyurl,cityfacet.field=city but

Re: finding exact case insensitive matches on single and multiword values

2010-12-03 Thread PeterKerk
You are right, this is what I see when I append the debug query (very very useful btw!!!) in old situation: arr name=parsed_filter_queries strcity:den title:haag/str strPhraseQuery(themes:hotel en restaur)/str /arr I then changed the schema.xml to: fieldType name=myField

Re: finding exact case insensitive matches on single and multiword values

2010-12-04 Thread PeterKerk
Geert-Jan and Erick, thanks! What I tried first is making it work with string type, that works perfect for all lowercase values! What I do not understand is how and why I have to make the casing work at the client, since the casing differs in the database. Right now in the database I have

RE: finding exact case insensitive matches on single and multiword values

2010-12-05 Thread PeterKerk
Alright guys, thanks! I went for storing everything lowercase in DB. I also lowercased all solr queries and only on client for UX purposes I applied the proper casing logic. Thanks for suggestions! -- View this message in context:

Re: full text search in multiple fields

2010-12-11 Thread PeterKerk
Ok, Im back ;) There's one final thing that needs to be fixed.. Im trying to apply the same logic as on cities, but now for the title of a location. There's a location with title: hortus rodondendrus This location is found using this query:

Re: full text search in multiple fields

2010-12-12 Thread PeterKerk
I went for the * operator, and it works now! Thanks! -- View this message in context: http://lucene.472066.n3.nabble.com/full-text-search-in-multiple-fields-tp1888328p2075140.html Sent from the Solr - User mailing list archive at Nabble.com.

  1   2   3   >