You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Sanjeev Gupta <su...@sanjeevg.com> on 2012/06/05 20:11:35 UTC
Has anyone implemented Faceted Search using SOLR?
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.
Re: Has anyone implemented Faceted Search using SOLR?
Posted by Ritu Raj Lakhera <rr...@gmail.com>.
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 <ra...@yahoo.com> 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.
>>
>>
>
Re: Has anyone implemented Faceted Search using SOLR?
Posted by Sanjeev Gupta <su...@sanjeevg.com>.
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....
-----
Rgds
Sanjeev
www.sanjeevg.com
@sanjeevgcom
--
View this message in context: http://ofbiz.135035.n4.nabble.com/Has-anyone-implemented-Faceted-Search-using-SOLR-tp4633260p4633953.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Has anyone implemented Faceted Search using SOLR?
Posted by barkavi <ba...@gmail.com>.
It was very helpful. Thanks :)
--
View this message in context: http://ofbiz.135035.n4.nabble.com/Has-anyone-implemented-Faceted-Search-using-SOLR-tp4633260p4637952.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Has anyone implemented Faceted Search using SOLR?
Posted by madppiper <pp...@ilscipio.com>.
Perhaps, you may be interested in this:
https://issues.apache.org/jira/browse/OFBIZ-5042
--
View this message in context: http://ofbiz.135035.n4.nabble.com/Has-anyone-implemented-Faceted-Search-using-SOLR-tp4633260p4637019.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Has anyone implemented Faceted Search using SOLR?
Posted by "Robert G." <ga...@mercon24.de>.
great, thank you...I only checked the osafe-admin :) great!
--
View this message in context: http://ofbiz.135035.n4.nabble.com/Has-anyone-implemented-Faceted-Search-using-SOLR-tp4633260p4634742.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Has anyone implemented Faceted Search using SOLR?
Posted by Praveen Agarwal <pr...@gmail.com>.
Robert,
Find the java files SolrServices.java and SolrEvents.java under src
directory of osafe component.
Regards,
Praveen Agrawal
On Wed, Jul 11, 2012 at 11:53 PM, Robert G. <ga...@mercon24.de> wrote:
> 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!
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Has-anyone-implemented-Faceted-Search-using-SOLR-tp4633260p4634704.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
Re: Has anyone implemented Faceted Search using SOLR?
Posted by Paul Piper <pp...@ilscipio.com>.
Hi,
there is a fully committed solr component available for you (no need for
third party plugins): https://issues.apache.org/jira/browse/OFBIZ-5042
Just download and run. It comes with an example schema.xml that is set up
for facetted search and several functions that make use of it.
--
View this message in context: http://ofbiz.135035.n4.nabble.com/Has-anyone-implemented-Faceted-Search-using-SOLR-tp4633260p4637967.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Has anyone implemented Faceted Search using SOLR?
Posted by "Robert G." <ga...@mercon24.de>.
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!
--
View this message in context: http://ofbiz.135035.n4.nabble.com/Has-anyone-implemented-Faceted-Search-using-SOLR-tp4633260p4634704.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Has anyone implemented Faceted Search using SOLR?
Posted by Praveen Agarwal <pr...@gmail.com>.
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. <ga...@mercon24.de> 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.
>
Re: Has anyone implemented Faceted Search using SOLR?
Posted by "Robert G." <ga...@mercon24.de>.
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.
Re: Has anyone implemented Faceted Search using SOLR?
Posted by Deepak Agarwal <da...@gmail.com>.
Great. Switching over to bigfish :)
On Sun, Jun 24, 2012 at 7:18 AM, varun bhansaly <vb...@gmail.com> 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 <dagarwal82@gmail.com
> >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 <nr...@salmonllc.com>
> > 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
> > > nrosser@salmonllc.com
> > >
> > >
> > > On Jun 23, 2012, at 3:33 PM, Mike <mz...@gmail.com> 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 <
> dagarwal82@gmail.com
> > >> >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 <mz...@gmail.com> 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 <
> > subscribe@sanjeevg.com
> > >>>>
> > >>>>> 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: deepak.agarwal@paxcel.net
> > >>>> Mobile: +91 9910322604
> > >>>>
> > >>>> --
> > >>>> Thanks,
> > >>>> Deepak Agarwal,
> > >>>>
> > >>>> Paxcel Technologies Pvt Ltd.
> > >>>> Hartron Complex, Sector 18, Gurgaon, India.
> > >>>> E-Mail: deepak.agarwal@paxcel.net
> > >>>> Mobile: +91 9910322604
> > >>>>
> > >>>> <%2B91%209910322604>
> > >>>
> > >>>
> >
>
>
>
> --
> Regards,
> Varun Bhansaly
>
> --
> Thanks,
> Deepak Agarwal,
>
> Paxcel Technologies Pvt Ltd.
> Hartron Complex, Sector 18, Gurgaon, India.
> E-Mail: deepak.agarwal@paxcel.net
> Mobile: +91 9910322604
>
>
Re: Has anyone implemented Faceted Search using SOLR?
Posted by varun bhansaly <vb...@gmail.com>.
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 <da...@gmail.com>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 <nr...@salmonllc.com>
> 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
> > nrosser@salmonllc.com
> >
> >
> > On Jun 23, 2012, at 3:33 PM, Mike <mz...@gmail.com> 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 <dagarwal82@gmail.com
> >> >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 <mz...@gmail.com> 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 <
> subscribe@sanjeevg.com
> >>>>
> >>>>> 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: deepak.agarwal@paxcel.net
> >>>> Mobile: +91 9910322604
> >>>>
> >>>> --
> >>>> Thanks,
> >>>> Deepak Agarwal,
> >>>>
> >>>> Paxcel Technologies Pvt Ltd.
> >>>> Hartron Complex, Sector 18, Gurgaon, India.
> >>>> E-Mail: deepak.agarwal@paxcel.net
> >>>> Mobile: +91 9910322604
> >>>>
> >>>> <%2B91%209910322604>
> >>>
> >>>
>
--
Regards,
Varun Bhansaly
Re: Has anyone implemented Faceted Search using SOLR?
Posted by Mike <mz...@gmail.com>.
Found in an old thread:
> On Wed, Mar 9, 2011 at 12:43 PM, James Lawton
> <ja...@tofinosoftware.com>
> 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.
Re: Has anyone implemented Faceted Search using SOLR?
Posted by Deepak Agarwal <da...@gmail.com>.
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 <nr...@salmonllc.com> 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
> nrosser@salmonllc.com
>
>
> On Jun 23, 2012, at 3:33 PM, Mike <mz...@gmail.com> 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 <dagarwal82@gmail.com
>> >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 <mz...@gmail.com> 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 <subscribe@sanjeevg.com
>>>>
>>>>> 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: deepak.agarwal@paxcel.net
>>>> Mobile: +91 9910322604
>>>>
>>>> --
>>>> Thanks,
>>>> Deepak Agarwal,
>>>>
>>>> Paxcel Technologies Pvt Ltd.
>>>> Hartron Complex, Sector 18, Gurgaon, India.
>>>> E-Mail: deepak.agarwal@paxcel.net
>>>> Mobile: +91 9910322604
>>>>
>>>> <%2B91%209910322604>
>>>
>>>
Re: Has anyone implemented Faceted Search using SOLR?
Posted by Nick Rosser <nr...@salmonllc.com>.
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
nrosser@salmonllc.com
On Jun 23, 2012, at 3:33 PM, Mike <mz...@gmail.com> 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
> <da...@gmail.com>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 <mz...@gmail.com> 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 <subscribe@sanjeevg.com
>>>> 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: deepak.agarwal@paxcel.net
>>> Mobile: +91 9910322604
>>>
>>>
>>
Re: Has anyone implemented Faceted Search using SOLR?
Posted by Mike <mz...@gmail.com>.
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 <da...@gmail.com>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 <mz...@gmail.com> 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 <subscribe@sanjeevg.com
> > >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: deepak.agarwal@paxcel.net
> > Mobile: +91 9910322604
> >
> >
>
Re: Has anyone implemented Faceted Search using SOLR?
Posted by Deepak Agarwal <da...@gmail.com>.
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 <mz...@gmail.com> 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 <subscribe@sanjeevg.com
> >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: deepak.agarwal@paxcel.net
> Mobile: +91 9910322604
>
>
Re: Has anyone implemented Faceted Search using SOLR?
Posted by Mike <mz...@gmail.com>.
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 <su...@sanjeevg.com>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.
>
Re: Has anyone implemented Faceted Search using SOLR?
Posted by Rajbir Saini <ra...@yahoo.com>.
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.
>
Re: Has anyone implemented Faceted Search using SOLR?
Posted by Sanjeev Gupta <su...@sanjeevg.com>.
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.
Re: Has anyone implemented Faceted Search using SOLR?
Posted by Rajbir Saini <ra...@yahoo.com>.
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.
>
Re: Has anyone implemented Faceted Search using SOLR?
Posted by Mike <mz...@gmail.com>.
Hey Paul. Do you have a patch for SOLR?
On Tue, Jun 5, 2012 at 11:46 AM, madppiper <pp...@ilscipio.com> 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.
>
Re: Has anyone implemented Faceted Search using SOLR?
Posted by madppiper <pp...@ilscipio.com>.
Also: www.syracus.net uses solr as a basis for alot of its output.
--
View this message in context: http://ofbiz.135035.n4.nabble.com/Has-anyone-implemented-Faceted-Search-using-SOLR-tp4633260p4633264.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Has anyone implemented Faceted Search using SOLR?
Posted by madppiper <pp...@ilscipio.com>.
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.