Has anyone implemented Faceted Search using SOLR?

[Sanjeev Gupta]

I'm trying to implement Faceted Search using SOLR. So far I've managed to install Solr on the ofbiz server, but not sure how to move forward.
Would appreciate any help / guidance with it.

[Paul Piper]

Hey Sanjeev,

The key to it all is your solr template and how you integrate solr with your category tree.

Cheers,
Paul

[Paul Piper]

Also: www.syracus.net uses solr as a basis for alot of its output.

[Mike Z]

Hey Paul.  Do you have a patch for SOLR?

On Tue, Jun 5, 2012 at 11:46 AM, madppiper <[hidden email]> wrote:

> Hey Sanjeev,
>
> The key to it all is your solr template and how you integrate solr with
> your
> category tree.
>
> Cheers,
> Paul
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Has-anyone-implemented-Faceted-Search-using-SOLR-tp4633260p4633262.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[Rajbir Saini]

Hello Sanjeev,

This is how I did it:

1. Install Solr within OFbiz as component or on an external server.
2. Create a schema to suite your requirement. Few of the must have
fields are productId, categories (multi valued), price, inStock, product
name, description, etc. If you have variants, you would also like to
include features like size, colors etc.
3. Write a service to index the complete database. Disable out of the
box EECA as it may take many hours to index depending on your product set.
4. Modify out of the indexing EECA to index the products in Solr while
you add/update product, product price, category members etc.
5. Write an request event to fetch the facets while you show the product
categories. Alternatively, you can also use the Solr search engine to
drive the category pages as your products are indexed with category
information. For example if you have category A and making a solr
keyword search call by passing A as filterQuery parameter. For example,
if category field is categories in Solr, you solr query would look like
q=*.*&fq=categories:A.

6. Once you have all the products, it is upto you how you show them on
category pages.

Regards,

Raj

I have used productId as unique field to identify each product in the
On Tuesday 05 June 2012 11:41 PM, Sanjeev Gupta wrote:

> I'm trying to implement Faceted Search using SOLR. So far I've managed to
> install Solr on the ofbiz server, but not sure how to move forward.
> Would appreciate any help / guidance with it.
>
>
> -----
> Rgds
> Sanjeev
> www.sanjeevg.com
> @sanjeevgcom
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Has-anyone-implemented-Faceted-Search-using-SOLR-tp4633260.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[Sanjeev Gupta]

Hi Rajbir,
I spent a couple of days trying to play around with the approach you recommended but couldn't get it to work for me. So finally gave it up.

Will probably wait for someone to contribute the feature to the trunk.

[Rajbir Saini]

Hello Sanjeev,

What is that did not work? I will be happy to help if you can share the
problems you had faced.

Regards,

Raj

On Friday 22 June 2012 12:10 AM, Sanjeev Gupta wrote:

> Hi Rajbir,
> I spent a couple of days trying to play around with the approach you
> recommended but couldn't get it to work for me. So finally gave it up.
>
> Will probably wait for someone to contribute the feature to the trunk.
>
>
>
> -----
> Rgds
> Sanjeev
> www.sanjeevg.com
> @sanjeevgcom
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Has-anyone-implemented-Faceted-Search-using-SOLR-tp4633260p4633892.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[Mike Z]

You can check out BigFish:

http://bigfish.salmonllc.com <http://bigfish.salmonllc.com/bfDownload.html>

It's an awesome OFBiz ecommerce frontend (and simplified backend) that has
SOLR built-in.  Nick Rosser and his team of experts at  sammonllc.com have
put together a great set of features that is nothing short of amazing.  I'm
sold on it [grin].

You can always download it and checkout how they integrated SOLR.

On Thu, Jun 21, 2012 at 11:40 AM, Sanjeev Gupta <[hidden email]>wrote:

> Hi Rajbir,
> I spent a couple of days trying to play around with the approach you
> recommended but couldn't get it to work for me. So finally gave it up.
>
> Will probably wait for someone to contribute the feature to the trunk.
>
>
>
> -----
> Rgds
> Sanjeev
> www.sanjeevg.com
> @sanjeevgcom
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Has-anyone-implemented-Faceted-Search-using-SOLR-tp4633260p4633892.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[Sanjeev Gupta]

I agree with you Mike, Bigfish brings together quite a rich set of feature both for the storefont as well as the backend. it's quite impressive and I have been following it closely. However I could only get it's First version to work, but not the subsequent releases including the most recent one.
Nick has also been kind enough to offer his teams guidance to help me replicate the SOLR configuration on my system but that didn't work either.

So for now I'm using JavaScript to simulate SOLR like filtering. Will till try out Rajbir's approach next and lets see how it goes....

[Deepak Agarwal-2]

Mike,

I checked your admin panel. Amazing... great work I must say. Is it free to
use. Can I move just switch to it without any hassle of configurations ?

On Sat, Jun 23, 2012 at 5:12 AM, Mike <[hidden email]> wrote:

> You can check out BigFish:
>
> http://bigfish.salmonllc.com <http://bigfish.salmonllc.com/bfDownload.html
> >
>
> It's an awesome OFBiz ecommerce frontend (and simplified backend) that has
> SOLR built-in.  Nick Rosser and his team of experts at  sammonllc.com have
> put together a great set of features that is nothing short of amazing.  I'm
> sold on it [grin].
>
> You can always download it and checkout how they integrated SOLR.
>
> On Thu, Jun 21, 2012 at 11:40 AM, Sanjeev Gupta <[hidden email]
> >wrote:
>
> > Hi Rajbir,
> > I spent a couple of days trying to play around with the approach you
> > recommended but couldn't get it to work for me. So finally gave it up.
> >
> > Will probably wait for someone to contribute the feature to the trunk.
> >
> >
> >
> > -----
> > Rgds
> > Sanjeev
> > www.sanjeevg.com
> > @sanjeevgcom
> > --
> > View this message in context:
> >
> http://ofbiz.135035.n4.nabble.com/Has-anyone-implemented-Faceted-Search-using-SOLR-tp4633260p4633892.html
> > Sent from the OFBiz - User mailing list archive at Nabble.com.
> >
>
> --
> Thanks,
> Deepak Agarwal,
>
> Paxcel Technologies Pvt Ltd.
> Hartron Complex, Sector 18, Gurgaon, India.
> E-Mail: [hidden email]
> Mobile: [phone]
>
>

[Mike Z]

It's not my project.  It's Nicks with salmonllc.com.  I believe it has an
Apache 2.0 license, so it is free it use.  Maybe Nick can clarify.   I'm
still evaluating it, but so far very impressed.  It appears to fully
integrate with OFBiz's back-end as well.

On Sat, Jun 23, 2012 at 12:24 PM, Deepak Agarwal <[hidden email]>wrote:

> Mike,
>
> I checked your admin panel. Amazing... great work I must say. Is it free to
> use. Can I move just switch to it without any hassle of configurations ?
>
> On Sat, Jun 23, 2012 at 5:12 AM, Mike <[hidden email]> wrote:
>
> > You can check out BigFish:
> >
> > http://bigfish.salmonllc.com <
> http://bigfish.salmonllc.com/bfDownload.html
> > >
> >
> > It's an awesome OFBiz ecommerce frontend (and simplified backend) that
> has
> > SOLR built-in.  Nick Rosser and his team of experts at  sammonllc.comhave
> > put together a great set of features that is nothing short of amazing.
>  I'm
> > sold on it [grin].
> >
> > You can always download it and checkout how they integrated SOLR.
> >
> > On Thu, Jun 21, 2012 at 11:40 AM, Sanjeev Gupta <[hidden email]
> > >wrote:
> >
> > > Hi Rajbir,
> > > I spent a couple of days trying to play around with the approach you
> > > recommended but couldn't get it to work for me. So finally gave it up.
> > >
> > > Will probably wait for someone to contribute the feature to the trunk.
> > >
> > >
> > >
> > > -----
> > > Rgds
> > > Sanjeev
> > > www.sanjeevg.com
> > > @sanjeevgcom
> > > --
> > > View this message in context:
> > >
> >
> http://ofbiz.135035.n4.nabble.com/Has-anyone-implemented-Faceted-Search-using-SOLR-tp4633260p4633892.html
> > > Sent from the OFBiz - User mailing list archive at Nabble.com.
> > >
> >
> > --
> > Thanks,
> > Deepak Agarwal,
> >
> > Paxcel Technologies Pvt Ltd.
> > Hartron Complex, Sector 18, Gurgaon, India.
> > E-Mail: [hidden email]
> > Mobile: [phone]
> >
> >
>

[Nick Rosser]

Yes it's free to use. Apache license. The intent is to totally  
integrate with ofbiz so any order placed via the bigfish ecommerce ui  
can be fufilled in the backend ofbiz. We are working with a client  
currently that will use a bigfish ecomm solution and run thru an erp  
solution we built for them some time ago.

More news next week, we have a release ready.

And we'll get solr working for sanjeev!

Nick
C: 516.901.1720
[hidden email]

On Jun 23, 2012, at 3:33 PM, Mike <[hidden email]> wrote:

> It's not my project.  It's Nicks with salmonllc.com.  I believe it  
> has an
> Apache 2.0 license, so it is free it use.  Maybe Nick can clarify.    
> I'm
> still evaluating it, but so far very impressed.  It appears to fully
> integrate with OFBiz's back-end as well.
>
> On Sat, Jun 23, 2012 at 12:24 PM, Deepak Agarwal  
> <[hidden email]>wrote:
>
>> Mike,
>>
>> I checked your admin panel. Amazing... great work I must say. Is it  
>> free to
>> use. Can I move just switch to it without any hassle of  
>> configurations ?
>>
>> On Sat, Jun 23, 2012 at 5:12 AM, Mike <[hidden email]> wrote:
>>
>>> You can check out BigFish:
>>>
>>> http://bigfish.salmonllc.com <
>> http://bigfish.salmonllc.com/bfDownload.html
>>>>
>>>
>>> It's an awesome OFBiz ecommerce frontend (and simplified backend)  
>>> that
>> has
>>> SOLR built-in.  Nick Rosser and his team of experts at  
>>> sammonllc.comhave
>>> put together a great set of features that is nothing short of  
>>> amazing.
>> I'm
>>> sold on it [grin].
>>>
>>> You can always download it and checkout how they integrated SOLR.
>>>
>>> On Thu, Jun 21, 2012 at 11:40 AM, Sanjeev Gupta <[hidden email]
>>>> wrote:
>>>
>>>> Hi Rajbir,
>>>> I spent a couple of days trying to play around with the approach  
>>>> you
>>>> recommended but couldn't get it to work for me. So finally gave  
>>>> it up.
>>>>
>>>> Will probably wait for someone to contribute the feature to the  
>>>> trunk.
>>>>
>>>>
>>>>
>>>> -----
>>>> Rgds
>>>> Sanjeev
>>>> www.sanjeevg.com
>>>> @sanjeevgcom
>>>> --
>>>> View this message in context:
>>>>
>>>
>> http://ofbiz.135035.n4.nabble.com/Has-anyone-implemented-Faceted-Search-using-SOLR-tp4633260p4633892.html
>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>
>>>
>>> --
>>> Thanks,
>>> Deepak Agarwal,
>>>
>>> Paxcel Technologies Pvt Ltd.
>>> Hartron Complex, Sector 18, Gurgaon, India.
>>> E-Mail: [hidden email]
>>> Mobile: [phone]
>>>
>>>
>>

[Deepak Agarwal-2]

ant run-install-seed throws following . my mysql version is 5.5.16. Could
you quickly tell me if this is a known issue.

     [java] 2012-06-24 02:09:35,132 (main) [
DatabaseUtil.java:352:ERROR]
Could not create table [WORK_EFFORT_TYPE_ATTR]: SQL Exception while
executing th
e following:
     [java] CREATE TABLE WORK_EFFORT_TYPE_ATTR (WORK_EFFORT_TYPE_ID
VARCHAR(20)
CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL, ATTR_NAME
VARCHAR(60) C
HARACTER SET latin1 COLLATE latin1_general_cs NOT NULL, LAST_UPDATED_STAMP
DATET
IME, LAST_UPDATED_TX_STAMP DATETIME, CREATED_STAMP DATETIME,
CREATED_TX_STAMP DA
TETIME, CONSTRAINT PK_WORK_EFFORT_TYPE_ATTR PRIMARY KEY
(WORK_EFFORT_TYPE_ID, AT
TR_NAME)) TYPE InnoDB CHARACTER SET latin1 COLLATE latin1_general_cs
     [java] Error was:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
: You have an error in your SQL syntax; check the manual that corresponds
to you
r MySQL server version for the right syntax to use near 'TYPE InnoDB
CHARACTER S
ET latin1 COLLATE latin1_general_cs' at line 1

On Sun, Jun 24, 2012 at 1:27 AM, Nick Rosser <[hidden email]> wrote:

> Yes it's free to use. Apache license. The intent is to totally integrate
> with ofbiz so any order placed via the bigfish ecommerce ui can be fufilled
> in the backend ofbiz. We are working with a client currently that will use
> a bigfish ecomm solution and run thru an erp solution we built for them
> some time ago.
>
> More news next week, we have a release ready.
>
> And we'll get solr working for sanjeev!
>
> Nick
> C: 516.901.1720
> [hidden email]
>
>
> On Jun 23, 2012, at 3:33 PM, Mike <[hidden email]> wrote:
>
>  It's not my project.  It's Nicks with salmonllc.com.  I believe it has an
>> Apache 2.0 license, so it is free it use.  Maybe Nick can clarify.   I'm
>> still evaluating it, but so far very impressed.  It appears to fully
>> integrate with OFBiz's back-end as well.
>>
>> On Sat, Jun 23, 2012 at 12:24 PM, Deepak Agarwal <[hidden email]
>> >wrote:
>>
>>  Mike,
>>>
>>> I checked your admin panel. Amazing... great work I must say. Is it free
>>> to
>>> use. Can I move just switch to it without any hassle of configurations ?
>>>
>>> On Sat, Jun 23, 2012 at 5:12 AM, Mike <[hidden email]> wrote:
>>>
>>>  You can check out BigFish:
>>>>
>>>> http://bigfish.salmonllc.com <
>>>>
>>> http://bigfish.salmonllc.com/**bfDownload.html<http://bigfish.salmonllc.com/bfDownload.html>
>>>
>>>>
>>>>>
>>>> It's an awesome OFBiz ecommerce frontend (and simplified backend) that
>>>>
>>> has
>>>
>>>> SOLR built-in.  Nick Rosser and his team of experts at
>>>>  sammonllc.comhave
>>>> put together a great set of features that is nothing short of amazing.
>>>>
>>> I'm
>>>
>>>> sold on it [grin].
>>>>
>>>> You can always download it and checkout how they integrated SOLR.
>>>>
>>>> On Thu, Jun 21, 2012 at 11:40 AM, Sanjeev Gupta <[hidden email]
>>>>
>>>>> wrote:
>>>>>
>>>>
>>>>  Hi Rajbir,
>>>>> I spent a couple of days trying to play around with the approach you
>>>>> recommended but couldn't get it to work for me. So finally gave it up.
>>>>>
>>>>> Will probably wait for someone to contribute the feature to the trunk.
>>>>>
>>>>>
>>>>>
>>>>> -----
>>>>> Rgds
>>>>> Sanjeev
>>>>> www.sanjeevg.com
>>>>> @sanjeevgcom
>>>>> --
>>>>> View this message in context:
>>>>>
>>>>>
>>>>  http://ofbiz.135035.n4.nabble.**com/Has-anyone-implemented-**
>>> Faceted-Search-using-SOLR-**tp4633260p4633892.html<http://ofbiz.135035.n4.nabble.com/Has-anyone-implemented-Faceted-Search-using-SOLR-tp4633260p4633892.html>
>>>
>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>>
>>>>>
>>>> --
>>>> Thanks,
>>>> Deepak Agarwal,
>>>>
>>>> Paxcel Technologies Pvt Ltd.
>>>> Hartron Complex, Sector 18, Gurgaon, India.
>>>> E-Mail: [hidden email]
>>>> Mobile: [phone]
>>>>
>>>> --
>>>> Thanks,
>>>> Deepak Agarwal,
>>>>
>>>> Paxcel Technologies Pvt Ltd.
>>>> Hartron Complex, Sector 18, Gurgaon, India.
>>>> E-Mail: [hidden email]
>>>> Mobile: [phone]
>>>>
>>>>  <%2B91%209910322604>
>>>
>>>

[Mike Z]

Found in an old thread:

> On Wed, Mar 9, 2011 at 12:43 PM, James Lawton
> <[hidden email]>
> wrote:
>> Ahhh...just found a change in the MySQL manuals
>>
>> ====================================
>>
>> Section 5.1.7, "Server SQL Modes".
>>
>> Note
>> The older TYPE option was synonymous with ENGINE. TYPE was deprecated
>> in MySQL 4.0 and removed in MySQL 5.5. When upgrading to MySQL 5.5 or
>> later, you must convert existing applications that rely on TYPE to
>> use ENGINE instead.
>>

I don't know if OFBiz trunk/11.04 were ever updated to work with the later
versions of MySql, but since BigFish is based on 10.04, this may be the
problem.

It's another good reason to use postgresql over mysql.

[Varun Bhansaly]

Hi Deepak,

The keyword TYPE was deprecated in earlier version of MySQL and is
non-existent in the version you are using.
To get across this, you can,
Edit ofbiz/framework/entity/src/org/ofbiz/entity/jdbc/DatabaseUtil.java in
eclipse and replace sqlBuf.append(" TYPE ") with sqlBuf.append(" ENGINE ")
Compile OFBiz & try to install again.

On Sun, Jun 24, 2012 at 2:12 AM, Deepak Agarwal <[hidden email]>wrote:

> ant run-install-seed throws following . my mysql version is 5.5.16. Could
> you quickly tell me if this is a known issue.
>
>     [java] 2012-06-24 02:09:35,132 (main) [
> DatabaseUtil.java:352:ERROR]
> Could not create table [WORK_EFFORT_TYPE_ATTR]: SQL Exception while
> executing th
> e following:
>     [java] CREATE TABLE WORK_EFFORT_TYPE_ATTR (WORK_EFFORT_TYPE_ID
> VARCHAR(20)
> CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL, ATTR_NAME
> VARCHAR(60) C
> HARACTER SET latin1 COLLATE latin1_general_cs NOT NULL, LAST_UPDATED_STAMP
> DATET
> IME, LAST_UPDATED_TX_STAMP DATETIME, CREATED_STAMP DATETIME,
> CREATED_TX_STAMP DA
> TETIME, CONSTRAINT PK_WORK_EFFORT_TYPE_ATTR PRIMARY KEY
> (WORK_EFFORT_TYPE_ID, AT
> TR_NAME)) TYPE InnoDB CHARACTER SET latin1 COLLATE latin1_general_cs
>     [java] Error was:
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
> : You have an error in your SQL syntax; check the manual that corresponds
> to you
> r MySQL server version for the right syntax to use near 'TYPE InnoDB
> CHARACTER S
> ET latin1 COLLATE latin1_general_cs' at line 1
>
> On Sun, Jun 24, 2012 at 1:27 AM, Nick Rosser <[hidden email]>
> wrote:
>
> > Yes it's free to use. Apache license. The intent is to totally integrate
> > with ofbiz so any order placed via the bigfish ecommerce ui can be
> fufilled
> > in the backend ofbiz. We are working with a client currently that will
> use
> > a bigfish ecomm solution and run thru an erp solution we built for them
> > some time ago.
> >
> > More news next week, we have a release ready.
> >
> > And we'll get solr working for sanjeev!
> >
> > Nick
> > C: 516.901.1720
> > [hidden email]
> >
> >
> > On Jun 23, 2012, at 3:33 PM, Mike <[hidden email]> wrote:
> >
> >  It's not my project.  It's Nicks with salmonllc.com.  I believe it has
> an
> >> Apache 2.0 license, so it is free it use.  Maybe Nick can clarify.   I'm
> >> still evaluating it, but so far very impressed.  It appears to fully
> >> integrate with OFBiz's back-end as well.
> >>
> >> On Sat, Jun 23, 2012 at 12:24 PM, Deepak Agarwal <[hidden email]
> >> >wrote:
> >>
> >>  Mike,
> >>>
> >>> I checked your admin panel. Amazing... great work I must say. Is it
> free
> >>> to
> >>> use. Can I move just switch to it without any hassle of configurations
> ?
> >>>
> >>> On Sat, Jun 23, 2012 at 5:12 AM, Mike <[hidden email]> wrote:
> >>>
> >>>  You can check out BigFish:
> >>>>
> >>>> http://bigfish.salmonllc.com <
> >>>>
> >>> http://bigfish.salmonllc.com/**bfDownload.html<
> http://bigfish.salmonllc.com/bfDownload.html>
> >>>
> >>>>
> >>>>>
> >>>> It's an awesome OFBiz ecommerce frontend (and simplified backend) that
> >>>>
> >>> has
> >>>
> >>>> SOLR built-in.  Nick Rosser and his team of experts at
> >>>>  sammonllc.comhave
> >>>> put together a great set of features that is nothing short of amazing.
> >>>>
> >>> I'm
> >>>
> >>>> sold on it [grin].
> >>>>
> >>>> You can always download it and checkout how they integrated SOLR.
> >>>>
> >>>> On Thu, Jun 21, 2012 at 11:40 AM, Sanjeev Gupta <
> [hidden email]
> >>>>
> >>>>> wrote:
> >>>>>
> >>>>
> >>>>  Hi Rajbir,
> >>>>> I spent a couple of days trying to play around with the approach you
> >>>>> recommended but couldn't get it to work for me. So finally gave it
> up.
> >>>>>
> >>>>> Will probably wait for someone to contribute the feature to the
> trunk.
> >>>>>
> >>>>>
> >>>>>
> >>>>> -----
> >>>>> Rgds
> >>>>> Sanjeev
> >>>>> www.sanjeevg.com
> >>>>> @sanjeevgcom
> >>>>> --
> >>>>> View this message in context:
> >>>>>
> >>>>>
> >>>>  http://ofbiz.135035.n4.nabble.**com/Has-anyone-implemented-**
> >>> Faceted-Search-using-SOLR-**tp4633260p4633892.html<
> http://ofbiz.135035.n4.nabble.com/Has-anyone-implemented-Faceted-Search-using-SOLR-tp4633260p4633892.html
> >
> >>>
> >>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
> >>>>>
> >>>>>
> >>>> --
> >>>> Thanks,
> >>>> Deepak Agarwal,
> >>>>
> >>>> Paxcel Technologies Pvt Ltd.
> >>>> Hartron Complex, Sector 18, Gurgaon, India.
> >>>> E-Mail: [hidden email]
> >>>> Mobile: [phone]
> >>>>
> >>>> --
> >>>> Thanks,
> >>>> Deepak Agarwal,
> >>>>
> >>>> Paxcel Technologies Pvt Ltd.
> >>>> Hartron Complex, Sector 18, Gurgaon, India.
> >>>> E-Mail: [hidden email]
> >>>> Mobile: [phone]
> >>>>
> >>>>  <%2B91%209910322604>
> >>>
> >>>
>

--
Regards,
Varun Bhansaly

[Deepak Agarwal-2]

Great. Switching over to bigfish :)

On Sun, Jun 24, 2012 at 7:18 AM, varun bhansaly <[hidden email]> wrote:

> Hi Deepak,
>
> The keyword TYPE was deprecated in earlier version of MySQL and is
> non-existent in the version you are using.
> To get across this, you can,
> Edit ofbiz/framework/entity/src/org/ofbiz/entity/jdbc/DatabaseUtil.java in
> eclipse and replace sqlBuf.append(" TYPE ") with sqlBuf.append(" ENGINE ")
> Compile OFBiz & try to install again.
>
> On Sun, Jun 24, 2012 at 2:12 AM, Deepak Agarwal <[hidden email]
> >wrote:
>
> > ant run-install-seed throws following . my mysql version is 5.5.16. Could
> > you quickly tell me if this is a known issue.
> >
> >     [java] 2012-06-24 02:09:35,132 (main) [
> > DatabaseUtil.java:352:ERROR]
> > Could not create table [WORK_EFFORT_TYPE_ATTR]: SQL Exception while
> > executing th
> > e following:
> >     [java] CREATE TABLE WORK_EFFORT_TYPE_ATTR (WORK_EFFORT_TYPE_ID
> > VARCHAR(20)
> > CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL, ATTR_NAME
> > VARCHAR(60) C
> > HARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
> LAST_UPDATED_STAMP
> > DATET
> > IME, LAST_UPDATED_TX_STAMP DATETIME, CREATED_STAMP DATETIME,
> > CREATED_TX_STAMP DA
> > TETIME, CONSTRAINT PK_WORK_EFFORT_TYPE_ATTR PRIMARY KEY
> > (WORK_EFFORT_TYPE_ID, AT
> > TR_NAME)) TYPE InnoDB CHARACTER SET latin1 COLLATE latin1_general_cs
> >     [java] Error was:
> > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
> > : You have an error in your SQL syntax; check the manual that corresponds
> > to you
> > r MySQL server version for the right syntax to use near 'TYPE InnoDB
> > CHARACTER S
> > ET latin1 COLLATE latin1_general_cs' at line 1
> >
> > On Sun, Jun 24, 2012 at 1:27 AM, Nick Rosser <[hidden email]>
> > wrote:
> >
> > > Yes it's free to use. Apache license. The intent is to totally
> integrate
> > > with ofbiz so any order placed via the bigfish ecommerce ui can be
> > fufilled
> > > in the backend ofbiz. We are working with a client currently that will
> > use
> > > a bigfish ecomm solution and run thru an erp solution we built for them
> > > some time ago.
> > >
> > > More news next week, we have a release ready.
> > >
> > > And we'll get solr working for sanjeev!
> > >
> > > Nick
> > > C: 516.901.1720
> > > [hidden email]
> > >
> > >
> > > On Jun 23, 2012, at 3:33 PM, Mike <[hidden email]> wrote:
> > >
> > >  It's not my project.  It's Nicks with salmonllc.com.  I believe it
> has
> > an
> > >> Apache 2.0 license, so it is free it use.  Maybe Nick can clarify.
> I'm
> > >> still evaluating it, but so far very impressed.  It appears to fully
> > >> integrate with OFBiz's back-end as well.
> > >>
> > >> On Sat, Jun 23, 2012 at 12:24 PM, Deepak Agarwal <
> [hidden email]
> > >> >wrote:
> > >>
> > >>  Mike,
> > >>>
> > >>> I checked your admin panel. Amazing... great work I must say. Is it
> > free
> > >>> to
> > >>> use. Can I move just switch to it without any hassle of
> configurations
> > ?
> > >>>
> > >>> On Sat, Jun 23, 2012 at 5:12 AM, Mike <[hidden email]> wrote:
> > >>>
> > >>>  You can check out BigFish:
> > >>>>
> > >>>> http://bigfish.salmonllc.com <
> > >>>>
> > >>> http://bigfish.salmonllc.com/**bfDownload.html<
> > http://bigfish.salmonllc.com/bfDownload.html>
> > >>>
> > >>>>
> > >>>>>
> > >>>> It's an awesome OFBiz ecommerce frontend (and simplified backend)
> that
> > >>>>
> > >>> has
> > >>>
> > >>>> SOLR built-in.  Nick Rosser and his team of experts at
> > >>>>  sammonllc.comhave
> > >>>> put together a great set of features that is nothing short of
> amazing.
> > >>>>
> > >>> I'm
> > >>>
> > >>>> sold on it [grin].
> > >>>>
> > >>>> You can always download it and checkout how they integrated SOLR.
> > >>>>
> > >>>> On Thu, Jun 21, 2012 at 11:40 AM, Sanjeev Gupta <
> > [hidden email]
> > >>>>
> > >>>>> wrote:
> > >>>>>
> > >>>>
> > >>>>  Hi Rajbir,
> > >>>>> I spent a couple of days trying to play around with the approach
> you
> > >>>>> recommended but couldn't get it to work for me. So finally gave it
> > up.
> > >>>>>
> > >>>>> Will probably wait for someone to contribute the feature to the
> > trunk.
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>> -----
> > >>>>> Rgds
> > >>>>> Sanjeev
> > >>>>> www.sanjeevg.com
> > >>>>> @sanjeevgcom
> > >>>>> --
> > >>>>> View this message in context:
> > >>>>>
> > >>>>>
> > >>>>  http://ofbiz.135035.n4.nabble.**com/Has-anyone-implemented-**
> > >>> Faceted-Search-using-SOLR-**tp4633260p4633892.html<
> >
> http://ofbiz.135035.n4.nabble.com/Has-anyone-implemented-Faceted-Search-using-SOLR-tp4633260p4633892.html
> > >
> > >>>
> > >>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
> > >>>>>
> > >>>>>
> > >>>> --
> > >>>> Thanks,
> > >>>> Deepak Agarwal,
> > >>>>
> > >>>> Paxcel Technologies Pvt Ltd.
> > >>>> Hartron Complex, Sector 18, Gurgaon, India.
> > >>>> E-Mail: [hidden email]
> > >>>> Mobile: [phone]
> > >>>>
> > >>>> --
> > >>>> Thanks,
> > >>>> Deepak Agarwal,
> > >>>>
> > >>>> Paxcel Technologies Pvt Ltd.
> > >>>> Hartron Complex, Sector 18, Gurgaon, India.
> > >>>> E-Mail: [hidden email]
> > >>>> Mobile: [phone]
> > >>>>
> > >>>>  <%2B91%209910322604>
> > >>>
> > >>>
> >
>
>
>
> --
> Regards,
> Varun Bhansaly
>
> --
> Thanks,
> Deepak Agarwal,
>
> Paxcel Technologies Pvt Ltd.
> Hartron Complex, Sector 18, Gurgaon, India.
> E-Mail: [hidden email]
> Mobile: [phone]
>
>

[Robert Gan]

hey guys,

im trying to get solr running with ofbiz. The solr server is running - good.

Now I want solr to index the specific data from my database, so i added the fields to my schema.xml.

Now Im thinking about the way to connect.

the normal way, which is described in solr wiki is about the entity within the db-data-config.xml.

But this entity includes the DB connection (hard coded) and the SQL Querey (hard coded). That I do not want. I want to use the existing DB-connection and existing entities of ofbiz. Maybe I want to write a service to index the data.

So do you know, how I can tell Solr to use an existing DB connection and entity?

And if I write a service, lets say in java, how can I send the data than to Solr? With SolrJ? But with SolrJ I have to connect via http, whcih I think is to bad on an existing local server...

what do you think? How have you handled it?


Thanks, Robert

[rrlakhera]

Sanjeev,

This is a right way to integrate the Solr with Ofbiz as Rajveer described.
If you want to test this in hand please go over
http://bigfish.salmonllc.com/bfDownload.html.

BigFish illuminate the Solr capability in very nice manner. Currently
Bigfish integrate the Solr V1.4.
There will be no issue to upgrade Solr in BigFish.

If you need any further help, please feel free to get in touch.

Regards
Ritu

On Wed, Jun 6, 2012 at 10:13 AM, Rajbir Saini <[hidden email]> wrote:

> Hello Sanjeev,
>
> This is how I did it:
>
> 1. Install Solr within OFbiz as component or on an external server.
> 2. Create a schema to suite your requirement. Few of the must have fields
> are productId, categories (multi valued), price, inStock, product name,
> description, etc. If you have variants, you would also like to include
> features like size, colors etc.
> 3. Write a service to index the complete database. Disable out of the box
> EECA as it may take many hours to index depending on your product set.
> 4. Modify out of the indexing EECA to index the products in Solr while you
> add/update product, product price, category members etc.
> 5. Write an request event to fetch the facets while you show the product
> categories. Alternatively, you can also use the Solr search engine to drive
> the category pages as your products are indexed with category information.
> For example if you have category A and making a solr keyword search call by
> passing A as filterQuery parameter. For example, if category field is
> categories in Solr, you solr query would look like q=*.*&fq=categories:A.
>
> 6. Once you have all the products, it is upto you how you show them on
> category pages.
>
> Regards,
>
> Raj
>
> I have used productId as unique field to identify each product in the
>
> On Tuesday 05 June 2012 11:41 PM, Sanjeev Gupta wrote:
>
>> I'm trying to implement Faceted Search using SOLR. So far I've managed to
>> install Solr on the ofbiz server, but not sure how to move forward.
>> Would appreciate any help / guidance with it.
>>
>>
>> -----
>> Rgds
>> Sanjeev
>> www.sanjeevg.com
>> @sanjeevgcom
>> --
>> View this message in context: http://ofbiz.135035.n4.nabble.**
>> com/Has-anyone-implemented-**Faceted-Search-using-SOLR-**tp4633260.html<http://ofbiz.135035.n4.nabble.com/Has-anyone-implemented-Faceted-Search-using-SOLR-tp4633260.html>
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>>
>

[praveen.agrawal]

Hi Robert,

Please take reference from http://bigfish.salmonllc.com/bfDownload.html and
download the BigFish Project.

Bigfish integrated the solr in the way as you want here.

In Bigfish a java service is implemented (that includes all the Queries to
Ofbiz Entities using delegator) to generate the product index file.

Once the index file is generated we can Query to index file using SolrQuery
to get the data.

I think this will help you. Comments and Questions, welcome !

Thanks,
Praveen Agrawal


On Wed, Jul 11, 2012 at 5:47 PM, Robert G. <[hidden email]> wrote:

> hey guys,
>
> im trying to get solr running with ofbiz. The solr server is running -
> good.
>
> Now I want solr to index the specific data from my database, so i added the
> fields to my schema.xml.
>
> Now Im thinking about the way to connect.
>
> the normal way, which is described in solr wiki is about the entity within
> the db-data-config.xml.
>
> But this entity includes the DB connection (hard coded) and the SQL Querey
> (hard coded). That I do not want. I want to use the existing DB-connection
> and existing entities of ofbiz. Maybe I want to write a service to index
> the
> data.
>
> So do you know, how I can tell Solr to use an existing DB connection and
> entity?
>
> And if I write a service, lets say in java, how can I send the data than to
> Solr? With SolrJ? But with SolrJ I have to connect via http, whcih I think
> is to bad on an existing local server...
>
> what do you think? How have you handled it?
>
>
> Thanks, Robert
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Has-anyone-implemented-Faceted-Search-using-SOLR-tp4633260p4634694.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[Robert Gan]

thank you, im allrady searching for the java classes, but I cannot find :) can you help on it (location of these files), I think the rest I get by my self

many thanks!