Re: [Koha] Kohacon16 - live streaming and videos

Yes, thank you for sharing this information! -Heather On Mon, May 30, 2016 at 8:36 PM Decka David wrote: > Thank you for sharing this information > > Decka David > > -Original Message- > From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of David >

[Koha] NEKLS Job opportunity for NExpress Coordinator and ILS Systems Manager

Last call for applicants. NEKLS will begin reviewing applications after April 15. The Northeast Kansas Library System (NEKLS) in Lawrence, KS , has an opening and we’re looking for a diplomatic applicant with lots of energy, enthusiasm, and

Re: [Koha] [Koha-devel] Kylie Brice Hall

Congratulations Kyle, Chelsea, and Daria and and welcome Kylie!!! On Fri, Mar 18, 2016 at 11:53 AM Nick Clemens wrote: > Amazing! > > On Fri, Mar 18, 2016, 12:19 PM Todd Goatley < > todd.goat...@bywatersolutions.com> wrote: > >> So awesome Kyle! He's a beauty! >> >>

Re: [Koha] SQL report help

Kerrie, Are you just wanting count of items per collection code at a set branch? And no other information displayed? If so, try SELECT items.ccode, count(items.itemnumber) FROM items WHERE items.homebranch=<> GROUP BY items.ccode That should get you what you are you looking for, if I'm

Re: [Koha] Report includes renewals?

It does -- see in the WHERE clause: WHERE s.type IN ('issue','renew') -Heather Heather Braum NExpress Coordinator Resource Sharing Librarian Northeast Kansas Library System hbr...@nekls.org "The illiterate of the 21st century will not be those who cannot read and write, but those who cannot

[Koha] NEKLS Job posting for NExpress Coordinator and ILS Systems Manager

The Northeast Kansas Library System (NEKLS) in Lawrence, KS , has an opening and we’re looking for a diplomatic applicant with lots of energy, enthusiasm, and excellent custom service skills to come work with us! *NExpress Coordinator and ILS

Re: [Koha] Bibliocommons + Koha?

Rebecca, I've had a couple of conversations with someone at Bibliocommons over the past couple of years, as several of the large urban libraries in our region have implemented Bibliocommons. The response has always been (so far) that Bibliocommons doesn't yet work with Koha, and we would have to

[Koha] Holds Queue Idea for Patrons

Has anything like this idea ever been proposed for Koha? A Netflix-like holds queue that patrons can set up? https://alissadale.wordpress.com/2011/10/03/i-want-a-library-book-queue/ It was suggested on our statewide Tech group, and I was intrigued enough by the idea that I thought I'd inquire...

Re: [Koha] Expiring soon borrower notice?

Agnes, I think this would be a great idea! Would you post a bug number when you get it filed? We are running into this in our consortia with people who only use the computers and authenticate against the database for computer access, as well as digital content. -Heather On Wed, Dec 2, 2015 at

Re: [Koha] Few general Koha questions

I can help on #3 -- you can write a custom SQL report through the reports module that returns all bibs and then has a column that has a link directly to the item editor... This should work -- it will return all records that don't have items attached and include a direct link to the add item

Re: [Koha] Expiring soon borrower notice?

gt; with Koha 3.22 :) > > Bug 6810 - Send membership expiry reminder notices > http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6810 > > Hope this helps, > > Katrin > > > Am 02.12.2015 um 21:43 schrieb Heather Braum (NEKLS): > > Agnes, I think this wou

Re: [Koha] Using Koha to manage equipment loans

Elaine, you could setup a collection code that all the equipment is housed under, and then use the OpacHiddenItems sys pref to hide that collection code. That's a possible easy solution... You could also set up a separate branch and hide it from the public using the same sys pref. -Heather On

Re: [Koha] Can I limit the opac to see only the main library?

Tim, you can use the OpacHiddenItems sys pref to hide items that match a specific setting you set up. I've used it to hide items from entire branches during the summer, while schools are closed, to hide items with specific item types or collection codes, or to hide items matching other fields.

Re: [Koha] Record matching rules setup for the 024

Cecil, For the search index, try Identifier-standard instead of identifier-other and see if that works. Also, I didn't use a normalization rule. Heather Braum NExpress Coordinator Resource Sharing Librarian Northeast Kansas Library System hbr...@nekls.org The illiterate of the 21st century will

Re: [Koha] Catalogue - SQL Report Help

I find the guided reports wizard, frankly, to be very unhelpful, especially since I work with 50 branch locations in our consortia. I usually write my own custom reports, as a result, for much more granular control. To get this kind of data you gave as an example, you have to query and join three

Re: [Koha] Catalogue - SQL Report Help (Paul A)

Kerrie, to select by homebranch, you just need to add a branch parameter, i.homebranch=choose branch|branches So the statement will now look like SELECT DISTINCT b.biblionumber, b.title, b.author, t.editionstatement, t.publishercode, t.isbn, i.ccode, count(i.itemnumber) FROM biblio b LEFT JOIN

Re: [Koha] Koha vs Liblime Koha

Jesse, I don't think anyone intended to come across as rude. There are still -- and always will be -- very hard feelings over the fork of Koha several years ago and everything that happened around that time. Good luck on your install and on your library using Koha. Heather Braum NExpress

Re: [Koha] Report help needed

Elaine, try the below. It looks like you were missing some commas -- that was what was causing the syntax errors; you can then name the columns like I did below or however you want using as ___ single-word (as 780t) or as two or more words (as 780w field_). Make sure every column of data in the

Re: [Koha] Z39.50 server for children's books

Paul, take a look at this z39.50 target list on the Koha wiki. I know my consortia (NEKLS) and the SEKLS consortia may have the kinds of records you're looking for. I believe the Koha manual may have more Z39.50 targets in it as well. Look for public library targets -- those would have the DVD

Re: [Koha] Report help

Kerrie, You need to add the parameter of b.branchcode=choose branch|branches in the WHERE part of your SQL statement, like I did below. The {choose branch} part is actually arbitrary and can be whatever you want. Try this: SELECT concat(b.surname,', ',b.firstname) AS name,

[Koha] 2014 Koha NA Users Group Meeting Summary

), Heather Braum (NEKLS). Any other volunteers who weren't at the conference, please let us know if you're interested in helping lead the direction of this group and next year's face-to-face meeting. - Membership list on the wiki -- what are areas of experience? IRC nicknames. - Future

[Koha] Sandboxes

Fridolin, I know I couldn't get the Biblibre Sandbox 2 upgraded to master yesterday. The staff side login was stuck at the web installer screen, even though I received a sandbox ready email message. In the middle of the email message, there was this text: Upgrade to 3.15.00.048 done (Bug 10195:

Re: [Koha] Http Bad request error messages

Joel, We had this crop up repeatedly on our consortia system after we moved to 3.14.3 in back in February. This bug was filed and the patch written/applied, and fixed our issue: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11369. That patch looks like it was added to the 3.16 release

Re: [Koha] User tagging

Our consortia has had this feature turned on now for 6 years. We have moderation turned on, but almost always allow the tag to go through, regardless of what it is. A few staff and and a few patrons in our consortia use the feature, but not many. Heather Braum NExpress Coordinator Resource

[Koha] Permissions questions

I'm doing an audit of the permissions of our staff accounts in our system, and have several questions about certain permissions. I have already looked at the manual section on permissions and the granular section, too, but it didn't give enough information (

Re: [Koha] [ByWater Partners] Development for 'On Demand' Printouts of Overdue Bills

Lisa, Our NExpress consortia would be interested in being a partner on this development. Heather Braum NExpress Coordinator Resource Sharing Librarian Northeast Kansas Library System hbr...@nekls.org The illiterate of the 21st century will not be those cannot read and write, but those who

Re: [Koha] New patron restrictions data

If it's the old restrictions data (from before the library upgraded to 3.14) the data is located in the borrowers table, in the borrowers.debarred and borrowers.debarred comment fields. Heather Braum NExpress Coordinator Resource Sharing Librarian Northeast Kansas Library System hbr...@nekls.org

Re: [Koha] New patron restrictions data

Thank you Jonathan for correcting me. I completely misread Nicole's question as the data she had was in the borrower_debarments table and she was asking where was the other data was. :) I need much more coffee this morning! Heather Braum NExpress Coordinator Resource Sharing Librarian Northeast

Re: [Koha] Looking to Query Indicators

Nicole, We have a report on our system that looks for 490 tags with the 1 indicator first. Here's the SQL statement: select b.biblionumber, b.title, b.author from biblio b join biblioitems i using (biblionumber) where i.marcxml like '%datafield tag=490 ind1=1%' Maybe work with that statement

Re: [Koha] Follett to Koha 3 Migration

We have migrated several libraries into our Koha consortia from the old Follett Circulation Plus software over the last five years. The biggest helper was purchasing the ODBC Driver from Follett (I believe it's still available, if your paid support contract is current). That software allowed us to

[Koha] ResourceMate migration?

Has anyone ever tried to get MARC data out of a ResourceMate system before? We've got several questions, starting with how do you get MARC records out of it? Thanks in advance! Heather Braum Digital and Technical Services Librarian Northeast Kansas Library System hbr...@nekls.org 4317 W. 6th St.