- Koha - lists.katipo.co.nz

Re: [Koha] Sql report for list of items according to shelving location
by Stefano Bargioni 04 Nov '13

04 Nov '13

Hi Godfrey, you do not specify fields you are interested in. Only some fields from the items table? Or some fields from the bilio table too? Anyway, maybe you can start trying select * from items order by cn_sort or select * from biblio b, items i where b.biblionumber=i.biblionumber order by i.cn_sort and then replace * with a comma delimited list of fields you need to print. HTH. Stefano > Halo friends, I need technical help in sql, Am at zero level hence I > need your help from scratch. Always grateful. > > Godfrey > > > Quoting Saira Asghar <saira.asghar23(a)gmail.com>: > >> Hello Everyone >> >> I need a report for list of items according to shelving location. If anyone >> has this kind of sql report then please send me or help me in generating >> this. >> >> I shall be very thankful for your kind help. >> >> Waiting for reply >> >> -- >> *Regards* >> >> Saira Asghar

1 0

CCSR and PROG
by Landers, Paul 04 Nov '13

04 Nov '13

I just stood up a brand new test instance of 3.12.06 to experiment with CCSR vs. PROG themes for OPAC. The default PROG works fine, but when I switch to CCSR the OPAC displays completely wrong. Here are 2 screen shots (if you can ignore the TinyPic ads): PROG: http://oi42.tinypic.com/15wlco0.jpg CCSR: http://oi40.tinypic.com/nf4mx2.jpg Tested in FF, Chrome and IE. ===================================== Paul

2 3

Sql report for list of items according to shelving location
by Saira Asghar 04 Nov '13

04 Nov '13

Hello Everyone I need a report for list of items according to shelving location. If anyone has this kind of sql report then please send me or help me in generating this. I shall be very thankful for your kind help. Waiting for reply -- *Regards* Saira Asghar Librarian Namal College, 30-Kilometer Talagang Road, Mianwali, Pakistan. Ph: 0459 236995 Ext. 138

2 1

Dealing with error 500
by Arnold 04 Nov '13

04 Nov '13

hi i am new to koha and have gone through the "Using Koha as a Content Management System" steps so as to be able to add custom pages. My problem is when I finished adding a custom page and try testing it i get the error 500. On checking the logs, it says; [error][client 127.0.0.1] Can't open perl script "usr/share/koha/opac/cgi-bin/opac/pages.pl": Permission denied, referer: http://127.0.1.1/cgi-bin/koha/pages.pl?p=test Any advice on how I can solve this? Thanks

2 2

Re: [Koha] koha - consortia
by Joel Sasse 04 Nov '13

04 Nov '13

Yes. There are several demo sites for Koha available here: http://koha-community.org/demo/ I believe these servers reset themselves to a default configuration daily but they should give you a good idea of what Koha is capable of. Also, take a look at the manual: http://koha-community.org/documentation/ 3.12 is the current stable version and 3.14 is the next release due at the end of this month. Joel Sasse Network Systems Administrator Plum Creek Library System 507-376-5803 From: Richard Maileseni [mailto:rmaileseni@gmail.com] Sent: Sunday, November 03, 2013 7:53 PM To: Joel Sasse Subject: Re: [Koha] koha - consortia Our consortia has only six libraries, is there any way for me to test the setup of a library consortia on koha? On Sat, Oct 26, 2013 at 6:49 PM, Joel Sasse <jsasse(a)plumcreeklibrary.net> wrote: Could you be a bit more specific? I administer Koha for a 32 member library consortium and each library has different loan periods and fine structures as well as patron categories unique to some members. Koha handles this quite well. Koha also allows for different overdue messaging preferences and checkout slip configurations for member libraries. Joel Sasse Network Systems Administrator Plum Creek Library System 507-376-5803 -----Original Message----- From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Richard Maileseni Sent: Friday, October 25, 2013 10:48 PM To: koha(a)lists.katipo.co.nz Subject: [Koha] koha - consortia Greetings! Please can anyone explain how koha deals with a library consortia. Thanks! _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Richard W. Maileseni Mob: 027-934-2039 PH: 042367222 Email: lisiate.maileseni(a)tti.to facebook: www.facebook.com/rmaileseni scype: ma_richie ~\\~

1 0

koha-consortia
by Richard Maileseni 04 Nov '13

04 Nov '13

Hi is there any way for me to test the setup of a library consortia on koha?

1 0

Koha reindex with Zebra doesn't work
by Alex87 03 Nov '13

03 Nov '13

Hi everybody! I have installed Koha 3.6.4 on ubuntu 11.10. All seems to work fine, i can create records and so on, but when i try to reindex the the Zebra database i get the following error: /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -r -v Zebra configuration information ================================ Zebra biblio directory = /var/lib/koha/zebradb/biblios Zebra authorities directory = /var/lib/koha/zebradb/authorities Koha directory = /usr/share/koha/intranet/cgi-bin BIBLIONUMBER in : 001$@ BIBLIOITEMNUMBER in : 090$a ================================ skipping authorities ==================== exporting biblio ==================== 1 Records exported: 1 ==================== REINDEXING zebra ==================== 01:50:58-16/04 zebraidx(5748) [warn] Record didn't contain match fields in (bib1,Local-number) ==================== CLEANING ==================== And the records that i have creaate can't be find in the catalogue. I have the following settings: in /etc/koha/zebradb/marc_defs/unimarc/biblios/record.abs /all any melm 001 Local-number,Local-number:n # Local-number (biblionumber can be either in 090$9 or, on some setup, on 001) melm 009 Identifier-standard:w,Identifier-standard:n melm 090$9 Local-number,Local-number:n melm 099$c date-entered-on-file:s,date-entered-on-file:n,date-entered-on-file:y,Date-of-acquisition,Date-of-acquisition:d,Date-of-acquisition:s melm 099$d Date/time-last-modified:s,Date/time-last-modified:n,Date/time-last-modified:y melm 099$t ccode:w/ And the marc record in the Administration panel of Koha are settings as you can see: http://koha.1045719.n5.nabble.com/file/n5642993/koha_marc_mapping.png http://koha.1045719.n5.nabble.com/file/n5642993/koah_mapping.png http://koha.1045719.n5.nabble.com/file/n5642993/marc_001.png Also if i run a Marc Test in the Administration panel i get this error regarding biblio and biblioitem (maybe relating with the problem with Zebra reindexing?): http://koha.1045719.n5.nabble.com/file/n5642993/biblio_error.png Do you konw how to fix this problem? Thank you very much for your help Alex -- View this message in context: http://koha.1045719.n5.nabble.com/Koha-reindex-with-Zebra-doesn-t-work-tp56… Sent from the Koha-general mailing list archive at Nabble.com.

5 15

Re: [Koha] Sql report for list of items according to shelving location
by Paul A 01 Nov '13

01 Nov '13

At 06:54 PM 11/1/2013 +0500, Saira Asghar wrote: >Hello Everyone > >I need a report for list of items according to shelving location. If anyone >has this kind of sql report then please send me or help me in generating >this. You might try: SELECT biblio.author,biblio.title,biblio.copyrightdate,items.barcode,items.price,items.dateaccessioned,items.location,items.booksellerid FROM items, biblio WHERE items.biblionumber = biblio.biblionumber AND items.location = <<Pick your shelf (use auth. value)>> ORDER BY biblio.author ASC then modify to suit your own needs. Best - Paul

2 1

REMINDER: Next general IRC meeting - 6 November
by Galen Charlton 01 Nov '13

01 Nov '13

Hi, The next general IRC meeting will be held at 02:00 UTC on 6 November 2013. [1] The agenda can be found at http://wiki.koha-community.org/wiki/General_IRC_meeting,_6_November_2013 Of particular note, we will be holding elections for project positions for the release of Koha after 3.14. If you're interested in volunteering for a position, please update the wiki at http://wiki.koha-community.org/wiki/Roles_for_3.16 [1] Time zone converter link is http://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+IRC+General+M… Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: gmc(a)esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org

1 0

Purchase order form customisation
by Iming Chan 01 Nov '13

01 Nov '13

Dear all, I'm wondering whether the Purchase Order form (in acquisitions) can be customised? If so, how can this be done? Iming ----- Iming Chan Translib Information Service Melbourne, Australia -- View this message in context: http://koha.1045719.n5.nabble.com/Purchase-order-form-customisation-tp57770… Sent from the Koha-general mailing list archive at Nabble.com.

1 0