- Koha - lists.katipo.co.nz

Bibliographic frameworks
by Beth Willis 15 Aug '09

15 Aug '09

Dear Koha users, I have created a new bibliographic framework, but am unclear as to how I associate this framework with the file of bibliographic records that I wish to import. I am not using the bulk marc import, but am importing through the Web interface. I know that I must be missing something really obvious or else I am misunderstanding how the frameworks function. Is it possible to align my framework with my file? I much appreciate your help. beth

3 2

Request for interview on a Master Thesis
by Merete Iversen 14 Aug '09

14 Aug '09

Hello I'm writing a Master Thesis that is to be delivered by Oct. 1.st. in the University of Oslo. To put it short I'm interested in looking at how you are able to communicate the necessary information through a virtual network.I wish to understand how the process is running from a new feature is suggested until it is implemented, tested and approved on. How do you avoid misunderstandings in the communication with users when you often are not located at the same spot? And how you are able to develøp code that do not conflict with each other both functionally and technically. Could I please get in contact with two users (that have ordered new features) and two developers who could let me have an interview either on mail or over the phone. I do prefer the latter and will of course be the one to call in that case. I will also send a list of questions in advance. This is such an interesting project, and I really hope I will get in touch with some of you! Best regards. Merete Iversen check out the rest of the Windows Live™. More than mail–Windows Live™ goes way beyond your inbox. More than messages _________________________________________________________________ Show them the way! Add maps and directions to your party invites. http://www.microsoft.com/windows/windowslive/products/events.aspx

2 1

Independent Branches that share patrons
by Martin Longo 14 Aug '09

14 Aug '09

Hello there.... I'm running Koha 3.00.01.005. I have set up 11+ branches and turned IndependentBranches ON to increase security between those branches regarding the renewals/returns/issues of items from other branches. This works great. The thing is that the patrons from one library are allowed to borrow items from the others, but setting IndependentBranches ON makes that staff members from one branch cannot 'see' patrons from another branch ... and then... they cannot borrow items to them ie.. staff members from Branch A can only search and find patrons from Branch A, and not from Branch B, so it not posible that a patron registered at Branch B borrow an item which hamebranch is Branch A Can I keep branches independent allowing them to share the patrons? Thank in advance -- Ing. J. Martin Longo Depto. Gestion Informatica SID - UNCuyo http://sid.uncu.edu.ar

2 1

SQL Reports Reminder
by Nicole Engard 13 Aug '09

13 Aug '09

Hi all, I know we're all super busy getting ready for the feature freeze, but I just wanted to drop a line to remind everyone that at the bottom of this page: http://wiki.koha.org/doku.php?id=sql_library we have some requests for reports from the experts :) If you know how to solve someone's problem feel free to edit the page and put your query on the wiki to help out our fellow Koha users. Thanks, Nicole Koha Doc Manager

1 0

Paying fines with manual credit
by Agnes Rivers-Moore 13 Aug '09

13 Aug '09

2 1

Need help with reports
by Scott Zollars 13 Aug '09

13 Aug '09

I need help constructing the following reports in SQL. I am still not fluent in that. I need a list of interlibrary loan materials checked out to other libraries by the month and by the day for our ILL record keeping. Also I need a report that lists all cataloging records with NULL in the source of acquisition field in the item records within a specific date range. Thanks, Scotty Zollars Director of Library Services Labette Community College 200 S. 14th Parsons, KS 67357 620-820-1168 620-421-1469 FAX Four things you can't recover: The stone after the throw, the word after it's said, the occasion after it's missed and the time after it's gone.

2 2

Re: [Koha] koha and library homepage integration
by BWS Johnson 12 Aug '09

12 Aug '09

Salvete! >Of course! Sorry Owen for forgetting to mention you - we got heaps of >value from your blog - thank you too. :-) Owen is so smart (how smart is he?) that even a moron like me can understand what he's trying to get you to do since he explains everything so clearly. Cheers, Brooke

1 0

koha and library homepage integration
by Erik Lewis 12 Aug '09

12 Aug '09

I'm trying to see how far I can integrate my library website with the koha opac. Has there been any work with integrating a cms with the koha opac? Any good examples I should checkout where the catalog and the library homepage are blended really nicely?

4 4

creating a report for patrons without an email that have items overdue
by Melanie Hedgespeth 12 Aug '09

12 Aug '09

Can anyone tell me how to "combine" the following reports? We want to create a report that gives us a list of patrons who do not have email accounts and have items overdue. (information from http://wiki.koha.org/doku.php?id=sql_library) Sharon Moreland Circulation Overdue materials SELECT borrowers.surname, borrowers.firstname, borrowers.cardnumber, issues.date_due, (TO_DAYS(curdate())-TO_DAYS(date_due)) AS 'days overdue', items.itemcallnumber, items.barcode, biblio.title, biblio.author FROM borrowers LEFT JOIN issues ON (borrowers.borrowernumber=issues.borrowernumber) LEFT JOIN items ON (issues.itemnumber=items.itemnumber) LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber) WHERE (TO_DAYS(curdate())-TO_DAYS(date_due)) >= '28' AND homebranch = 'LIBRARY' ORDER BY issues.date_due asc, borrowers.surname ASC Complete Sharon Moreland Patron Missing e-mails SELECT cardnumber, surname, firstname, branchcode, debarred, dateexpiry FROM borrowers WHERE ' ' IN (email) Melanie <http://www.facebook.com/pages/Salina-KS/Salina-Public-Library/917121931 39?ref=s>

2 1

Error when returning and checking out books
by ed c 12 Aug '09

12 Aug '09

Hello all, On my Koha install I am receiving errors when I check in a book. The error when I have it set to debug mode I am sent to an error page that reads: Koha error The following fatal error has occurred: Can't use an undefined value as an ARRAY reference at /usr/share/koha/lib/C4/ItemCirculationAlertPreference.pm line 226. Apache Server version: Apache/2.2.8 (Ubuntu) Server built: Mar 10 2009 18:09:05 Koha 3.00.02.012 Koha DB 3.0002012 MySQL mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2 OS Linux cassidy 2.6.24-23-server #1 SMP Wed Apr 1 22:22:14 UTC 2009 i686 Perl 5.008008 In production mode, I get a Web site that says: "production mode - trapped fatal error" The return and or check out actually does go through but obviously I can't have library staff seeing this error every time they check in or out a book. I don't remember seeing these earlier, but I am not sure. However, nothing has changed recently that could have caused this. I did try temporarily copying the latest ItemCirculationAlertPreference.pm from the git repository, but that didn't do anything but change the line number in the error. Any ideas? Edward Edward

2 4