- Koha - lists.katipo.co.nz

Re: [Koha] Set permissions: cataloguer need the privilege to upload book jacket
by Vimal Kumar V. 27 Jul '13

27 Jul '13

Dear Friends, I could solve the problem by enbaling Set permissions > Tools > upload local cover images. Thank you Vinod and Jared. -- Vimal Kumar V. Technical Assistant Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.info Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

1 0

Set permissions: cataloguer need the privilege to upload book jacket
by Vimal Kumar V. 26 Jul '13

26 Jul '13

Dear Friends, In our library, we careated staff user (working in periodical section) and given privilege to access serials and cataloguing module. She want to add journal cover image (helpful to identify journal) in serials biblio. She can create and edit biblio, but not able to upload cover images. But a super user can upload book jacket. Privilege for uoload cover image is essential for a user who has access on cataloguing module. Regards, -- Vimal Kumar V. Technical Assistant Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.info Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

2 1

Resrvation of books
by yoonus para 26 Jul '13

26 Jul '13

Sir, How to reserve a book in koha? Thanks

2 1

Type vs. Item Type
by David Cook 26 Jul '13

26 Jul '13

Hi Steve: I assume that you're using the XSLT system preferences for search results? The "Type" field is determined by analysing the MARC record's "Leader" tag (i.e. it comes directly from the MARCXML - not a DB field). A type of "Book" comes up if position 6 of your Leader is "a" (Language material) or "t" (Manuscript language material), and if position 7 of your Leader is "c" (Collection), "d" (Subunit), or "m" (Monograph). If "Book" is coming up for records with item types of "DVD" and "Tape", it's because those records have been catalogued as books. This link might elucidate (or confuse) things more: http://www.loc.gov/marc/formatintegration.html In order to avoid a situation where you might have misleading information in your search results...you have several options: 1) Turn off the "DisplayOPACiconsXSLT" system preference. This will remove the "Type", "Format", etc. information from the OPAC search results (although it will still display in the intranet, if you've enabled XSLT there). 2) Fix the Leader in your catalogue records so that they are properly coded 3) Turn off XSLT for search results Hope that helps! David Cook Systems Librarian Prosentient Systems P/L ABN 31 078 409 168 72/330 Wattle St, Ultimo NSW 2007 tel: 02 92120899 fax: 02 92120885 dcook(a)prosentient.com.au -----Original Message----- Date: Thu, 25 Jul 2013 11:13:50 -0400 From: Steven Nickerson <snicker1(a)maine.rr.com> To: KOHA Mailing List <koha(a)lists.katipo.co.nz> Subject: [Koha] Type vs. Item Type Message-ID: <69D82AE0-C3B3-418D-9F36-6302A8E7B194(a)maine.rr.com> Content-Type: text/plain; charset=us-ascii Hi everyone, Can someone explain to me where the "Type" field in the search results comes from in the DB? Currently everything shows up as type "Book" even though in the details the Item Type shows correctly (i.e. DVD, Tape, etc). Thank you in advance! Steve

1 0

SQL Circulation report on Check in books
by Mayoora 26 Jul '13

26 Jul '13

Dear friends Do any one have created a report on SQL Circulation report on Check in books date wise if yes kindly mail to me. I am new to KOHA Mayoora -- View this message in context: http://koha.1045719.n5.nabble.com/SQL-Circulation-report-on-Check-in-books-… Sent from the Koha-general mailing list archive at Nabble.com.

2 1

Problems with Zebra indexing
by Coehoorn, Joel 25 Jul '13

25 Jul '13

First off: we're on Ubuntu 12.04, using Debian packages, now running koha 3.10. This is my first experience with koha, and from what I can tell I must have done some things during the original setup as root instead of as the koha user. It's far enough in the past now that I'm not sure exactly what. In spite of this, search has been fully working until this week, with the caveat that I would have to manually run the rebuild_zebra.pl script. This had always involved using sudo to rebuild the indexes (one part of why I think I must have done something as root). That was all fine when the only materials that change are bulk imports (one import per item type) from our old system, done by me, but it's not going to fly long term, when my librarians need to be able to add records on their own, so this week I dug into why index updates were not happening automatically, and I found a simple permissions error. I updated the zebra export folders to give the koha user write access to the zebra folders, and now nothing shows up in search. When I watch the re-index process, I see a few additional folders that cause permissions issues under /var/lock. I can update permissions on these as well, but they are removed and re-created with the bad permissions every time the server reboots. Rare enough, but still a problem. *How can I fix this so that the lock folders get the correct permissions when they are recreated after reboot? Is this something I'll need to script? * Also watching the re-index process I see we have four cases where marc records that are too large for the spec that somehow made it into the system. I found and removed two of those, but I'm having a hard time finding the other two. I only know they're somewhere near the end of our biblios (should have larger biblio numbers), because they're up past 92000 out of 99769 during the import, but I can't see where exactly to pin them down. This brings up two questions: *How I can find the over-sized marc records?* and *How can I get koha to use handle these large items? *I know it's possible, because until this week I was able to search on those records. With just the two bad records, I can then watch zebra index those first 92000 or so records. After the exporting biblios phase, during the reindex phase, with extra verbosity set I do see this error: about bad marc records. I don't have exact message handy now, but I remember it was explicit about skipping everything after the error event. Everything else looks to have committed. In spite of this, all searches still come up empty. I tried re-indexing with the -x switch, in an attempt to use the xml format to get around the marc 99999 byte limit. This completes with no errors. However, I still don't see any search results. I know the zebra server is running. Joel Coehoorn Director of Information Technology York College, Nebraska 402.363.5603 jcoehoorn(a)york.edu *The mission of York College is to transform lives through Christ-centered education and to equip students for lifelong service to God, family, and society*

3 5

Type vs. Item Type
by Steven Nickerson 25 Jul '13

25 Jul '13

Hi everyone, Can someone explain to me where the "Type" field in the search results comes from in the DB? Currently everything shows up as type "Book" even though in the details the Item Type shows correctly (i.e. DVD, Tape, etc). Thank you in advance! Steve

1 0

Re: [Koha] Need help to create SQL query to display list of books issued date wise
by Vimal Kumar V. 25 Jul '13

25 Jul '13

Dear Friends, I just created one query for the purpose. It list all books checked in date wise. SELECT old_issues.returndate,items.barcode,biblio.title,biblio.author,borrowers.firstname,borrowers.surname,borrowers.cardnumber,borrowers.categorycode FROM old_issues LEFT JOIN borrowers ON borrowers.borrowernumber=old_issues.borrowernumber LEFT JOIN items ON old_issues.itemnumber=items.itemnumber LEFT JOIN biblio ON items.biblionumber=biblio.biblionumber where old_issues.returndate BETWEEN <<Between Date (yyyy-mm-dd)>> and <<and (yyyy-mm-dd)>> ORDER BY old_issues.returndate DESC Thank you all, -- Vimal Kumar V. Technical Assistant Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.info Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

1 0

Need help to create SQL query to display list of books issued date wise
by Vimal Kumar V. 25 Jul '13

25 Jul '13

Dear Friends Please help me to create an SQL report to display list of books issued date wise. Regards -- Vimal Kumar V. Technical Assistant Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.info Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

2 1

* Field 245 is mandatory, at least one of its subfields must be filled
by praba 25 Jul '13

25 Jul '13

Dear All,    I have recently installed Koha and testing its features, when I do a catalogue through Z39.50 search its taking the records fine but when I do a catalogue as “New Record” manually filling the necessary field and “Save record” its showing error like this even though the fields are filled,  “ * Field 245 is mandatory, at least one of its subfields must be filled. * Field 300 is mandatory, at least one of its subfields must be filled.”   After this error, I clicked the fields to check what was happened,  its creating one more empty field again and if I try to save the record its showing the same error, if I delete the extra field created nothing is working.  Any help. With Regards, P.Prabahar

1 0