Re: [Koha] Using different port
I tried the commands but still no result while searching. I also got some warnings. What this means? root@debiankohabjar:/home/bjar# koha-rebuild-zebra --full $(koha-list) 22:00:43-25/05 zebraidx(20725) [warn] Record didn't contain match fields in (bib1,Local-number) 22:00:45-25/05 zebraidx(20734) [warn] Record didn't contain match fields in (bib1,Local-number) root@debiankohabjar:/home/bjar# Thanks Marius 2011/5/25 Robin Sheat ro...@catalyst.net.nz Marius Stoica schreef op di 24-05-2011 om 13:25 [+0300]: Anyway It seems that zebra is not working after importing the database: searching gives no results. The first thing I always do in this case is: sudo /etc/init.d/koha-common restart this'll make sure your daemons are running. Then, if you're still not seeing anything, do: sudo koha-rebuild-zebra --full $(sudo koha-list) -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Zebra: to daemon, or not to daemon
On 26 May 2011 07:51, Doug Dearden dear...@sarsf.org wrote: Hello all, The FAQ regarding searching found here: http://koha-community.org/documentation/faq/searching/ contains the following caution: 4. Be sure you are *not* running the zebraqueue daemon. Currently this daemon has major problems and the recommended method of indexing is to run rebuild_zebra.pl as a cron job. Running both causes more problems. Is this still true with the latest 3.4.1 release? Still true for 3.4.1 there is a bug with patches attached for a full rewrite that looks promising. It should make it into master and 3.6.0 not sure if the release maintainer will add it to a 3.4.x release Chris (Another post in this list made me wonder). Thanks, Doug Dearden Director, IT School for Advanced Research (505)954-7220 sarweb.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] [Koha-devel] Z39.50 server authentication
Hie, In our configuration, authentification is managed by serverinfo tag in koha-conf.xml : serverinfo id=publicserver ccl2rpn/etc/koha/zebradb/ccl.properties/ccl2rpn userusername/user passworduserpassword/password /serverinfo Regards, 2011/5/24 Altaf Mahmud altaf.mah...@gmail.com Dear community, I've enabled the Z39.50 server in my Koha server following these steps: 1. Edited /etc/koha/koha-conf.xml file and uncommented the publicserver line: listen id=publicserver tcp:@:/listen And change this line: server id=biblioserver listenref=biblioserver to server id=biblioserver It forces Zebra to listen on unix socket (for Koha) and on TCP port (for external usage). 2. Restarted Zebra server. MARC data can now accessed from my z39.50 server. Now I want to implement the authentication process so that user id and login required to connect to my server. I don't know how to do it, could you please give me an advise? Thank you. -- Altaf Mahmud System Programmer Ayesha Abed Library BRAC University Bangladesh. ___ Koha-devel mailing list koha-de...@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/ -- Fridolyn SOMERS ICT engineer PROGILONE - Lyon - France fridolyn.som...@gmail.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report help
Is this run at the MySQL level or in the reports module? * * * * Beverly Church LibLime Project Manager phone: 1-888-564-2457 ext. 717 1-301-654-8088 ext. 292 email: bchu...@liblime.com skype: beverlychurch On Wed, May 25, 2011 at 4:23 PM, Nicole Engard neng...@gmail.com wrote: I did try it and it does work. You need a more recent version of MySQL for it to work ... 5. something ... It's in Debian Squueze. Nicole On Wed, May 25, 2011 at 3:21 PM, Church, Beverly bchu...@liblime.com wrote: Have you tried it? I can't get it to work. Bev * * * * Beverly Church LibLime Project Manager phone: 1-888-564-2457 ext. 717 1-301-654-8088 ext. 292 email: bchu...@liblime.com skype: beverlychurch On Wed, May 25, 2011 at 3:08 PM, Nicole Engard neng...@gmail.com wrote: For those who are curious, cait found my answer and it's on the wiki: http://wiki.koha-community.org/wiki/SQL_Reports_Library#Title.2FSubtitle_List Nicole On Wed, May 25, 2011 at 1:49 PM, Nicole Engard neng...@gmail.com wrote: Bev, I was thinking more along the lines of this type of thing: http://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC which I can do with the version of MySQL that I have installed. Just wants sure how to fit it in to the report. Nicole On Wed, May 25, 2011 at 11:59 AM, Church, Beverly bchu...@liblime.com wrote: Hi Nicole, This query should work: select title, IF( LOCATE('datafield tag=245', biblioitems.marcxml) = 0 OR LOCATE('subfield code=b', biblioitems.marcxml, LOCATE('datafield tag=245', biblioitems.marcxml)) = 0 OR LOCATE('subfield code=b', biblioitems.marcxml, LOCATE('datafield tag=245', biblioitems.marcxml)) LOCATE('/datafield', biblioitems.marcxml, LOCATE('datafield tag=245', biblioitems.marcxml)), '', SUBSTRING( biblioitems.marcxml, LOCATE('subfield code=b', biblioitems.marcxml, LOCATE('datafield tag=245', biblioitems.marcxml)) + 19, LOCATE('/subfield', biblioitems.marcxml, LOCATE('subfield code=b', biblioitems.marcxml, LOCATE('datafield tag=245', biblioitems.marcxml)) + 19) - (LOCATE('subfield code=b', biblioitems.marcxml, LOCATE('datafield tag=245', biblioitems.marcxml)) + 19))) AS 'Sub-title' FROM biblioitems, biblio where biblioitems.biblionumber = biblio.biblionumber and LOCATE('datafield tag=245', biblioitems.marcxml) != 0 ORDER BY title asc * * * * Beverly Church LibLime Project Manager phone: 1-888-564-2457 ext. 717 1-301-654-8088 ext. 292 email: bchu...@liblime.com skype: beverlychurch On Wed, May 25, 2011 at 12:10 PM, Nicole Engard neng...@gmail.com wrote: I'm looking for some help with using the marc xml reports trick :) I need a report that shows the title and the subtitle, how would I do that? Thanks in advance! Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report help
MySQL 5.1 or greater is required. The queries should work either from the reports module, or directly on the MySQL command line. -Ian 2011/5/25 Church, Beverly bchu...@liblime.com Is this run at the MySQL level or in the reports module? * * * * Beverly Church LibLime Project Manager phone: 1-888-564-2457 ext. 717 1-301-654-8088 ext. 292 email: bchu...@liblime.com skype: beverlychurch On Wed, May 25, 2011 at 4:23 PM, Nicole Engard neng...@gmail.com wrote: I did try it and it does work. You need a more recent version of MySQL for it to work ... 5. something ... It's in Debian Squueze. Nicole On Wed, May 25, 2011 at 3:21 PM, Church, Beverly bchu...@liblime.com wrote: Have you tried it? I can't get it to work. Bev * * * * Beverly Church LibLime Project Manager phone: 1-888-564-2457 ext. 717 1-301-654-8088 ext. 292 email: bchu...@liblime.com skype: beverlychurch On Wed, May 25, 2011 at 3:08 PM, Nicole Engard neng...@gmail.com wrote: For those who are curious, cait found my answer and it's on the wiki: http://wiki.koha-community.org/wiki/SQL_Reports_Library#Title.2FSubtitle_List Nicole On Wed, May 25, 2011 at 1:49 PM, Nicole Engard neng...@gmail.com wrote: Bev, I was thinking more along the lines of this type of thing: http://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC which I can do with the version of MySQL that I have installed. Just wants sure how to fit it in to the report. Nicole On Wed, May 25, 2011 at 11:59 AM, Church, Beverly bchu...@liblime.com wrote: Hi Nicole, This query should work: select title, IF( LOCATE('datafield tag=245', biblioitems.marcxml) = 0 OR LOCATE('subfield code=b', biblioitems.marcxml, LOCATE('datafield tag=245', biblioitems.marcxml)) = 0 OR LOCATE('subfield code=b', biblioitems.marcxml, LOCATE('datafield tag=245', biblioitems.marcxml)) LOCATE('/datafield', biblioitems.marcxml, LOCATE('datafield tag=245', biblioitems.marcxml)), '', SUBSTRING( biblioitems.marcxml, LOCATE('subfield code=b', biblioitems.marcxml, LOCATE('datafield tag=245', biblioitems.marcxml)) + 19, LOCATE('/subfield', biblioitems.marcxml, LOCATE('subfield code=b', biblioitems.marcxml, LOCATE('datafield tag=245', biblioitems.marcxml)) + 19) - (LOCATE('subfield code=b', biblioitems.marcxml, LOCATE('datafield tag=245', biblioitems.marcxml)) + 19))) AS 'Sub-title' FROM biblioitems, biblio where biblioitems.biblionumber = biblio.biblionumber and LOCATE('datafield tag=245', biblioitems.marcxml) != 0 ORDER BY title asc * * * * Beverly Church LibLime Project Manager phone: 1-888-564-2457 ext. 717 1-301-654-8088 ext. 292 email: bchu...@liblime.com skype: beverlychurch On Wed, May 25, 2011 at 12:10 PM, Nicole Engard neng...@gmail.com wrote: I'm looking for some help with using the marc xml reports trick :) I need a report that shows the title and the subtitle, how would I do that? Thanks in advance! Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Ian Walls Lead Development Specialist ByWater Solutions ALA Booth 732 Phone # (888) 900-8944 http://bywatersolutions.com ian.wa...@bywatersolutions.com Twitter: @sekjal ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha - changing the item edits screen
Linda, Since no one's answered you yet, I'll offer some jQuery code to add to your intranetuserjs, with the caveats that I'm on LLEK and that I'm a jQuery neophyte whose naive solution is probably not bulletproof: $(#cataloguing_additem_itemlist th:contains('Permanent location')).remove(); $(#cataloguing_additem_itemlist th:contains('Current location')).remove(); $(#cataloguing_additem_itemlist tbody tr td:nth-child(9)).remove(); $(#cataloguing_additem_itemlist tbody tr td:nth-child(10)).remove(); I hope that someone more experienced with jQuery sees this, laughs at it, jumps in with a more sophisticated solution, and adds it to the http://wiki.koha-community.org/wiki/JQuery_Library jQuery Library . Cheers, Daniel Grobani Library Technology Specialist John A. Graziano Memorial Library Samuel Merritt University -- View this message in context: http://koha.1045719.n5.nabble.com/Koha-changing-the-item-edits-screen-tp4413552p4426732.html Sent from the Koha - Discuss mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Using different port
Marius Stoica schreef op wo 25-05-2011 om 22:12 [+0300]: root@debiankohabjar:/home/bjar# koha-rebuild-zebra --full $(koha-list) 22:00:43-25/05 zebraidx(20725) [warn] Record didn't contain match fields in (bib1,Local-number) 22:00:45-25/05 zebraidx(20734) [warn] Record didn't contain match fields in (bib1,Local-number) This means that there are some bad records, although I don't think they should abort the indexing (someone please correct me if I'm wrong.) However, if searching isn't running, then it may be that this is what's happening. Try this instead: sudo -u 'koha-LIBRARY' -H env PERL5LIB=/usr/share/koha/lib KOHA_CONF='/etc/koha/sites/LIBRARY/koha-conf.xml' /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -a -v -r replace LIBRARY with whatever you called your koha instance. This will do the same thing, however it'll give you verbose output. If this doesn't give you any clues, paste the whole output into http://paste.koha-community.org and tell us the URL - maybe we'll see something useful in it. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D signature.asc Description: This is a digitally signed message part ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report help
Bev, I wrote that gnarly marcxml-parsing query you offered below because at the time, LLEK was running on a pre-5.1 version of MySQL and I couldn't use the simpler ExtractValue(). I just ran cait's query that Nicole offered from the SQL Reports Library against our LLEK report server and it worked fine, but it bombs when I run it as a report in our production instance. I suspect LLEK's production version is still pre-5.1. Cheers, Daniel Grobani Library Technology Specialist John A. Graziano Memorial Library Samuel Merritt University -- View this message in context: http://koha.1045719.n5.nabble.com/Report-help-tp4425796p4426913.html Sent from the Koha - Discuss mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha