Re: [CODE4LIB] Solr and Koha
Say what? Riley Childs Student Asst. Head of IT Services Charlotte United Christian Academy (704) 497-2086 RileyChilds.net Sent from my Windows Phone, please excuse mistakes From: Chris Fitzpatrick<mailto:chrisfitz...@gmail.com> Sent: 5/30/2014 3:34 AM To: CODE4LIB@LISTSERV.ND.EDU<mailto:CODE4LIB@LISTSERV.ND.EDU> Subject: Re: [CODE4LIB] Solr and Koha Solr with Koha? Now you have 2 problems. I setup Koha to use Blacklight. I was fairly easy.It's been awhile, but if I recall, I added a single-column table in Koha to queue bibkeys. Then I added a db trigger to the bib table to add bibkeys to the queue table whenever there was an create/update/delete performed on a row. Then I setup a service that queried the database queue table, got bibkeys needing creation/update/deletion, pulled the MARC from Koha's REST api, indexed their MARC into Solr, and then delete the bibkeys from the queue. On Fri, May 30, 2014 at 12:47 AM, Chris Cormack wrote: > On 30 May 2014 05:21, Boyd, Evan wrote: > > > The "forked" versions of Koha from LibLime/PTFS use a Solr index. They > may > > have some insight. > > > > > > Yeah, thats a 5 year old fork (no need for "" no one in their right mind > would claim it anything other than a fork), so it probably wont be much use > for actual Koha, id just export them as MARCXML as Andrew mentioned. Or > look at the elastic search code in Koha which makes use of Catmandu, you > could use Catmandu to do the same for Solr > > http://search.cpan.org/~nics/Catmandu-0.01/lib/Catmandu/Store/Solr.pm > > Chris > > > > evan > > > > -Original Message- > > From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of > > Riley Childs > > Sent: Wednesday, May 28, 2014 10:22 PM > > To: CODE4LIB@LISTSERV.ND.EDU > > Subject: [CODE4LIB] Solr and Koha > > > > Does anybody have any direction about how to get koha export to solr so > it > > can be utilized by black light, server power is not an issue (if needed I > > can dedicate one to it). Has anyone done this if so...benefits, > > disadvantages? We have a collection of 1 books (small but growing). > > > > Honestly this is just something to do as a learning experience, but if I > > commit, I commit! > > > > > > Thx! > > //Riley > > > > Riley Childs > > Student > > Asst. Head of IT Services > > Charlotte United Christian Academy > > (704) 497-2086 > > RileyChilds.net > > Sent from my Windows Phone, please excuse mistakes > > >
Re: [CODE4LIB] Solr and Koha
Solr with Koha? Now you have 2 problems. I setup Koha to use Blacklight. I was fairly easy.It's been awhile, but if I recall, I added a single-column table in Koha to queue bibkeys. Then I added a db trigger to the bib table to add bibkeys to the queue table whenever there was an create/update/delete performed on a row. Then I setup a service that queried the database queue table, got bibkeys needing creation/update/deletion, pulled the MARC from Koha's REST api, indexed their MARC into Solr, and then delete the bibkeys from the queue. On Fri, May 30, 2014 at 12:47 AM, Chris Cormack wrote: > On 30 May 2014 05:21, Boyd, Evan wrote: > > > The "forked" versions of Koha from LibLime/PTFS use a Solr index. They > may > > have some insight. > > > > > > Yeah, thats a 5 year old fork (no need for "" no one in their right mind > would claim it anything other than a fork), so it probably wont be much use > for actual Koha, id just export them as MARCXML as Andrew mentioned. Or > look at the elastic search code in Koha which makes use of Catmandu, you > could use Catmandu to do the same for Solr > > http://search.cpan.org/~nics/Catmandu-0.01/lib/Catmandu/Store/Solr.pm > > Chris > > > > evan > > > > -Original Message- > > From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of > > Riley Childs > > Sent: Wednesday, May 28, 2014 10:22 PM > > To: CODE4LIB@LISTSERV.ND.EDU > > Subject: [CODE4LIB] Solr and Koha > > > > Does anybody have any direction about how to get koha export to solr so > it > > can be utilized by black light, server power is not an issue (if needed I > > can dedicate one to it). Has anyone done this if so...benefits, > > disadvantages? We have a collection of 1 books (small but growing). > > > > Honestly this is just something to do as a learning experience, but if I > > commit, I commit! > > > > > > Thx! > > //Riley > > > > Riley Childs > > Student > > Asst. Head of IT Services > > Charlotte United Christian Academy > > (704) 497-2086 > > RileyChilds.net > > Sent from my Windows Phone, please excuse mistakes > > >
Re: [CODE4LIB] Solr and Koha
On 30 May 2014 05:21, Boyd, Evan wrote: > The "forked" versions of Koha from LibLime/PTFS use a Solr index. They may > have some insight. > > > Yeah, thats a 5 year old fork (no need for "" no one in their right mind would claim it anything other than a fork), so it probably wont be much use for actual Koha, id just export them as MARCXML as Andrew mentioned. Or look at the elastic search code in Koha which makes use of Catmandu, you could use Catmandu to do the same for Solr http://search.cpan.org/~nics/Catmandu-0.01/lib/Catmandu/Store/Solr.pm Chris > evan > > -Original Message- > From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of > Riley Childs > Sent: Wednesday, May 28, 2014 10:22 PM > To: CODE4LIB@LISTSERV.ND.EDU > Subject: [CODE4LIB] Solr and Koha > > Does anybody have any direction about how to get koha export to solr so it > can be utilized by black light, server power is not an issue (if needed I > can dedicate one to it). Has anyone done this if so...benefits, > disadvantages? We have a collection of 1 books (small but growing). > > Honestly this is just something to do as a learning experience, but if I > commit, I commit! > > > Thx! > //Riley > > Riley Childs > Student > Asst. Head of IT Services > Charlotte United Christian Academy > (704) 497-2086 > RileyChilds.net > Sent from my Windows Phone, please excuse mistakes >
Re: [CODE4LIB] Solr and Koha
The "forked" versions of Koha from LibLime/PTFS use a Solr index. They may have some insight. evan -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Riley Childs Sent: Wednesday, May 28, 2014 10:22 PM To: CODE4LIB@LISTSERV.ND.EDU Subject: [CODE4LIB] Solr and Koha Does anybody have any direction about how to get koha export to solr so it can be utilized by black light, server power is not an issue (if needed I can dedicate one to it). Has anyone done this if so...benefits, disadvantages? We have a collection of 1 books (small but growing). Honestly this is just something to do as a learning experience, but if I commit, I commit! Thx! //Riley Riley Childs Student Asst. Head of IT Services Charlotte United Christian Academy (704) 497-2086 RileyChilds.net Sent from my Windows Phone, please excuse mistakes
Re: [CODE4LIB] Solr and Koha
You can export your records from Koha in marc or xml format by using the `Export bibliographic and holdings` option in the tools module in the staff client (quick tutorial here: http://bywatersolutions.com/2012/07/04/exporting-marc-records-in-koha-3-8/). For 1 bib records you should be able to do it in one shot. This is all for hosted Koha installs, if you are running your own, you should be able to run an export.pl script from the terminal. With the .mrc file, it's pretty much ready to go to upload into a fresh install of Blacklight with a rake task. So it's totally doable. -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Justin Coyne Sent: Thursday, May 29, 2014 12:20 AM To: CODE4LIB@LISTSERV.ND.EDU Subject: Re: [CODE4LIB] Solr and Koha If you can get the records from Koha in any format. It's not difficult to import them to Solr. When you get Blacklight set up you can do: Blacklight.solr.add(id: 12345, title_t: "One flew over the cuckoo's nest", author_t: "Ken Kesey") Blacklight.solr.commit And you've added your first record into solr. Feel free to ask more on the blackight-development google group or #blacklight on IRC. -Justin On Wed, May 28, 2014 at 10:21 PM, Riley Childs wrote: > Does anybody have any direction about how to get koha export to solr > so it can be utilized by black light, server power is not an issue (if > needed I can dedicate one to it). Has anyone done this if > so...benefits, disadvantages? We have a collection of 1 books (small but > growing). > > Honestly this is just something to do as a learning experience, but if > I commit, I commit! > > > Thx! > //Riley > > Riley Childs > Student > Asst. Head of IT Services > Charlotte United Christian Academy > (704) 497-2086 > RileyChilds.net > Sent from my Windows Phone, please excuse mistakes >
Re: [CODE4LIB] Solr and Koha
If you can get the records from Koha in any format. It's not difficult to import them to Solr. When you get Blacklight set up you can do: Blacklight.solr.add(id: 12345, title_t: "One flew over the cuckoo's nest", author_t: "Ken Kesey") Blacklight.solr.commit And you've added your first record into solr. Feel free to ask more on the blackight-development google group or #blacklight on IRC. -Justin On Wed, May 28, 2014 at 10:21 PM, Riley Childs wrote: > Does anybody have any direction about how to get koha export to solr so it > can be utilized by black light, server power is not an issue (if needed I > can dedicate one to it). Has anyone done this if so...benefits, > disadvantages? We have a collection of 1 books (small but growing). > > Honestly this is just something to do as a learning experience, but if I > commit, I commit! > > > Thx! > //Riley > > Riley Childs > Student > Asst. Head of IT Services > Charlotte United Christian Academy > (704) 497-2086 > RileyChilds.net > Sent from my Windows Phone, please excuse mistakes >
[CODE4LIB] Solr and Koha
Does anybody have any direction about how to get koha export to solr so it can be utilized by black light, server power is not an issue (if needed I can dedicate one to it). Has anyone done this if so...benefits, disadvantages? We have a collection of 1 books (small but growing). Honestly this is just something to do as a learning experience, but if I commit, I commit! Thx! //Riley Riley Childs Student Asst. Head of IT Services Charlotte United Christian Academy (704) 497-2086 RileyChilds.net Sent from my Windows Phone, please excuse mistakes