- Koha - lists.katipo.co.nz

Envisionware Questions
by Lee Phillips 18 Aug '11

18 Aug '11

Please let me know if you are using Envisionware with a Linux/Koha config.. I need a few questions answered. Thanks, Lee in Butte

1 0

Weeding Out
by Prajeesh 18 Aug '11

18 Aug '11

Dear Friends Is there any provision available in Koha to mark the weeded out books separately ?. How Koha manages weeded out books ? -- With Regards Prajeesh Bhaskaran Mahatma Gandhi University Library Kottayam, Kerala- 686 560

2 1

version number stored in database?
by nreese 18 Aug '11

18 Aug '11

Hi all, I need to carry out a version upgrade on an old koha database - does someone know if I can do an sql query to find out which version the database is? Thanks, Nick -- View this message in context: http://koha.1045719.n5.nabble.com/version-number-stored-in-database-tp47108… Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 1

report help
by Nicole Engard 17 Aug '11

17 Aug '11

Can someone help me out here. I need to alter this to show only titles that haven't circulated in X number of years. SELECT b.title, b.author, b.copyrightdate, i.itemcallnumber, i.barcode, i.datelastborrowed, i.issues as totalcheckouts, i.dateaccessioned FROM items i LEFT JOIN issues USING (itemnumber) LEFT JOIN biblio b USING (biblionumber) WHERE i.itemnumber NOT IN (SELECT issues.itemnumber FROM issues) UNION (SELECT b.title, b.author, b.copyrightdate, i.itemcallnumber, i.barcode, i.datelastborrowed, i.issues as totalcheckouts, i.dateaccessioned FROM items i LEFT JOIN issues USING (itemnumber) LEFT JOIN biblio b USING (biblionumber) WHERE i.itemnumber NOT IN (SELECT old_issues.itemnumber FROM old_issues))

1 0

Patron import bug or expectations too high?
by Chris Hobbs 17 Aug '11

17 Aug '11

We've about 13,000 students that we want to refresh regularly from our student information system. We've done so using import_borrowers.pl, but since upgrading from 3.0 to a released 3.2 up through a very recent git build (3.05.00.008) we've been unable to update our patrons using this tool. We always get Apache's Gateway Timeout error after 10 minutes. If we import only new patrons (the "Ignore this one, keep the existing one" is selected), then the import succeeds even though the import file is still 13,000 records long. It's only when we choose the "Overwrite the existing one with this" option that it stalls out. If I break it up into smaller chunks (~1000 student patrons) it works. So am I asking too much? Should I just figure out how to split my import file up into smaller batches? Are there adjustments to Apache's config I could safely make to try to increase the timeout? I tried making some changes to Apache to resolve this in the past that seemed to make it very unstable, so I reverted those. It's been months, and I do not recall what I changed - bad sysadmin!. Or is there something wrong with import_borrowers.pl that could be causing it to take too long? Thanks for your suggestions! -- Chris Hobbs Director, Technology New Haven Unified School District

1 0

Acquisitions Fields
by Nicole Engard 17 Aug '11

17 Aug '11

Can someone tell me what the unitprice, rrp, and ecost fields in the aqorders table are? Which field is for which price field? Thanks Nicole

3 3

Re: Koha shows error on adding an item
by Msgr. Marion J. Makarewicz 17 Aug '11

17 Aug '11

Swaprava, I looked through my old logs to see what I did regarding that error when I did my first install, but I had deleted them. If I can recall correctly, it had to do with not getting required fields filled in when I imported my data from the previous ILS. It took me a while to figure it out but it had to do with making sure that the item subfield itype had BK in it. Also I didn't have both the homebranch and holding branch filled in for all the records. Another problem on some records was series information in the biblioitems were in two different fields. Double check your MARC structure and make sure that all the required fields have the necessary data in them. Remember that as you set up your framework, you also have to ensure that all the fields are visible in the proper view in the biblio and item editing tabs. Is the error on all records? Search on this thread to get some more info: Problems after upgrade to 3.4.3 What version are you running? Marion >Hello all, >We recently installed Koha for our small library, and we don't have any exposure to library sciences, we're just amateurs. We could install Koha properly. But there is one error which is showing up at the end of adding the item. I couldn't attach the csv file of our customized MARC structure for the 40KB limit of mails. >screenshot of the error: Software error: >Can't call method "subfield" on an undefined value at /usr/share/koha/lib/C4/Biblio.pm line 2881. For help, please send mail to the webmaster ( <http://koha.1045719.n5.nabble.com/user/SendEmail.jtp?type=node&node=4703467 &i=0> [hidden email]), giving this error message and the time and date of the error. >Even if we use the default MARC structure, we still get the error. Interestingly, the item gets added to the record. However, while checking out the item against a patron, after giving the Barcode and pressing ok, we hit the same error >page again. Even while returning the book once we click on return the book, the same error comes. We saw some community pages where people encountered this kind of a problem. We don't have any clue to fix this. Any inputs? >Thanks in advance. >Swaprava

1 0

Re: [Koha] Kohacon11 : Last date of paper submission extended till August 30 2011
by Koustubha Kale 17 Aug '11

17 Aug '11

On Tue, Aug 16, 2011 at 4:59 PM, Chris Cormack <chrisc(a)catalyst.net.nz>wrote: > * Koustubha Kale (kmkale(a)anantcorp.com) wrote: > > Hi All, > > We have extended the last date of paper submission ( which was today > 15th > > August ) till 30th August 2011. > > > > Request all of you who would like to present at Kohacon111 to step > forward > > and submit an abstract at > > http://kohacon11.vpmthane.org/ocs/index.php/k/k11/schedConf/cfp for > > review. > > > > Also request all of you whose abstracts have been accepted to hurry up > and > > submit the full papers / presentations.. > > > Hi Koustubha > > I don't ever write full presentations, only notes for myself. > Submitting full papers is a very academic conference type of thing to > do, this would definitely be the first Kohacon that had written papers. > > Is this a must have, or just a 'it would be nice to have' condition? > > Chris > -- > Chris Cormack > Catalyst IT Ltd. > +64 4 803 2238 > PO Box 11-053, Manners St, Wellington 6142, New Zealand > Hi chris, Actually we are planning to have all the presentations / papers published as a Souvenir plus CD. So in order to have the same ready for handing over to participants during the conference itself, its necessary to have the papers / presentations in beforehand. Still if the community feels this is not done. Let me know and I will discuss with VPM. Regards, Koustubha Kale Anant Corporation Contact Details : Address : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka, Thane (w), Maharashtra, India, Pin : 400601. TeleFax : +91-22-21720108, +91-22-21720109 Mobile : +919820715876 Website : http://www.anantcorp.com Blog : http://www.anantcorp.com/blog/?author=2

4 4

Kohacon11 : Last date of paper submission extended till August 30 2011
by Koustubha Kale 16 Aug '11

16 Aug '11

Hi All, We have extended the last date of paper submission ( which was today 15th August ) till 30th August 2011. Request all of you who would like to present at Kohacon111 to step forward and submit an abstract at http://kohacon11.vpmthane.org/ocs/index.php/k/k11/schedConf/cfp for review. Also request all of you whose abstracts have been accepted to hurry up and submit the full papers / presentations.. Regards, Koustubha Kale Anant Corporation Contact Details : Address : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka, Thane (w), Maharashtra, India, Pin : 400601. TeleFax : +91-22-21720108, +91-22-21720109 Mobile : +919820715876 Website : http://www.anantcorp.com Blog : http://www.anantcorp.com/blog/?author=2

3 2

KohaCon
by Carlin, William 16 Aug '11

16 Aug '11

Does anyone know where I can get the number of attendees over the years at KohaCon? Best wishes, William Carlin Systems Washoe County Library System

3 3