- Koha - lists.katipo.co.nz

Error when: buildnonmarc.pl
by Bo Schafers 01 Jun '07

01 Jun '07

Hi I'm using version 2.2.9 on Ubuntu Feisty with mysql 5.0 When running buildnonmarc.pl to fix koha/marc linking I get the following error message after record the script cycles through: </collection> at /usr/local/koha/intranet/modules/C4/Biblio.pm line 597. .DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at ./rebuildnonmarc.pl line 98. DBD::mysql::st execute failed: Column 'biblionumber' cannot be null at /usr/local/koha/intranet/modules/C4/Biblio.pm line 1924. XML : <?xml version="1.0" encoding="UTF-8"?> <collection Should I log this under bugs/database in Bugzilla? Or is this not a bug, possible a misconfiguration? If so any idea where to look, what to try? TIA, Bo

2 3

Suggestions Oddity 2.2.9
by Bo Schafers 01 Jun '07

01 Jun '07

In the Opac when viewing suggestions there are 6 search conditions: -Any asked accepted ordered declined available In the Aquisitions module the librarian can only do 2 states -Reject accept Also when the a suggestion is rejected by the librarian it's simply 'blown away' and no longer on the opac suggestion list. So the person who submitted the suggestion cannot see what the response to her suggestion was....even if it was rejected it would be courteous just to have this visible. I'll be adding these to Bugzilla. Bugzilla does not have an option for assigning to 2.2.9 by the way.... Bo

2 1

query
by Archana Nanda 01 Jun '07

01 Jun '07

i have instaled successfully koha ...but problem is somewhere koha is not accepting data ...or where it goes don't know....e.g. we have entered a branch record but it is not showing.. CAN any body tell me as a new user to koha and librarysystem both...how can we use koha? thanx

2 1

Stocktaking and inventory
by Sandra Brook 01 Jun '07

01 Jun '07

Hi..it's Sandra again (KOHA 2.2.5 user)...David, Jason and Thomas...thanks for your suggestions on exporting the data..I'm sure they're all possible and would work.....but our IT have not been able to come up with the requested table :(. The data they have extracted is jumbled and incomplete. >From our 4000 biblio records we have only 1750 titles, (and actually with matching author in adjoining colomn), but without matching barcodes, classification and pricing of the almost 8000 items, they're in separate colomns elsewhere on the 1000 page excel sheet. Our IT have asked me to give step by step instructions on how to export the requested data: the data I wanted on the table is (exactly as in the email I wrote to out IT) : Information to include in library inventory Excel or Access database, Excel format is the easiest for us to use. Title: Tab 1 *245a* Author: Tab 0 *100a * or Tab1 245c Classification: Tab0 082a or Tab5 *942k* Price: from *Item Price* Barcode: Tab0 082b or Tab5 942a or from *Item Barcode* One other fields that it would be useful for you to include is: Itemtype: Tab 5 *942c* The bold type indicates the preferred source for information, many thanks in advance. Failing step-by-step instructions on how to extract this information what are the alternatives within the system for an efficient stocktaking? I've not been able to find anything about this subject in help documentation. Our accounting has also requested a print list of our inventory - help please Many thanks in advance Sandra Brook Cairo, Egypt

1 0

Fwd: KOHA - not obeying...
by S P Suresh 01 Jun '07

01 Jun '07

Hi, We are very new to Koha and this list. Our librarian is testing things out and reports some problems which you can find in the attached mail. We will be pestering the more experienced members in this list for some time as we are settling down. I thank all of you in advance for the time you will be sparing for us. Looking forward to some suggestions about the following problems. Many thanks in anticipation. Cheers, Suresh S P Suresh Chennai Mathematical Institute India Begin forwarded message: > From: "Saritha ." <saritha(a)cmi.ac.in> > Date: 1 June 11:41 > To: S P Suresh <SPSuresh(a)cmi.ac.in> > Subject: KOHA - not obeying... > > Hi > Suresh, i tried working on KOHA- it shows certain problems..they r > listed below > * When the MARK records are imported for a book we usually save it > by clicking an option "Add bibliographic records and go to items" > which takes us to the item frame where we could type the barcode > number(ie. acc.no)--which is reflected on the OPAC. now i am unable > to make changes..the full item list does not appear and in the opac > when the acc.no is typed only the biblio.details reflect leaving > the item box empty... u can check this please..(acc.no 3671,3672) > * Not able to issue books that are catalouged though the opac shows > the existance of the books..while trying to issue Koha says"Issuing > impossible-barcode unknown" am not sure if i've gone wrong in > importing the details or if the bib.details not saved due to the > "item frame".. > i would also like to know if there is any way to get the list of > books cataloged in a lib. ie the books cataloged in a day/week/ > total books cataloged etc.i tried to,but could not find any.. > If any suggestion please inform. > Saritha

1 0

RE: [Koha] Re: Koha Digest, Vol 19, Issue 39
by Rifaudeen M.M. 31 May '07

31 May '07

Dear friends, I also requested the same throgh this email already. The manual for each module is necessary for the new user like me. If u find any please email to me also. Best regards, MM Rifaudeen Acting Librarian _________________________________ Library South Eastern University of Sri Lanka P.O. Box No.01, University Park, Oluvil #32360, SRI LANKA. Ph./Fax: +94 67 2255160 Mobile: +94 77 6576115 E-mail: rifayiqa(a)seu.ac.lk Web: www.seu.ac.lk ________________________________ From: koha-bounces(a)lists.katipo.co.nz on behalf of Simon Joseph ENGITU Sent: Wed 5/30/2007 10:33 AM To: koha(a)lists.katipo.co.nz Subject: [Koha] Re: Koha Digest, Vol 19, Issue 39 Dear Members I am a recent recruit in the use of Koha system and I am supposed to implement the system and yet we were given only 2 days and half of a demonstration on the use of the system, is there anybody of this listserv who has an easy-to- follow manual, the one which has examples how to use each of the modules? I would be more than grateful to have it sent to me. Background UNDESA sent an expert to install this system for us three or 4 weeks a go. The Expert encouraged us to be in contact with him after the demonstration, however, our ICT Boss discourages us from writing directly to the Expert, but to the ICT Dept for any problems and yet the librarian's module is specific to us to ICT. We are now in a dilema what to do. Simon Joseph ENGITU Asstt Director; Library Services Sec. to Assoc. of Parliamentary Libs. in Eastern and Southern Africa (APLESA) Parliament of Uganda P.O. Box 7178 Kampala- Uganda EAST AFRICA Mobile 256 (772) 488937 Ph. 256 (41) 4377242 Quoting koha-request(a)lists.katipo.co.nz: > Send Koha mailing list submissions to > koha(a)lists.katipo.co.nz > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.katipo.co.nz/mailman/listinfo/koha > or, via email, send a message with subject or body 'help' to > koha-request(a)lists.katipo.co.nz > > You can reach the person managing the list at > koha-owner(a)lists.katipo.co.nz > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Koha digest..." > > > Today's Topics: > > 1. Re: 3 Bugs Making Librarian's Job a Challenge (Joshua M. Ferraro) > 2. Re: 3 Bugs Making Librarian's Job a Challenge (Jason Ronallo) > 3. Re: 3 Bugs Making Librarian's Job a Challenge (Bo Schafers) > 4. Re: How to make MARC Fields Appear in Opac? (Bo Schafers) > 5. Re: How to make MARC Fields Appear in Opac? (Joshua M. Ferraro) > 6. Re: How to make MARC Fields Appear in Opac? (Jason Ronallo) > 7. Re: How to make MARC Fields Appear in Opac? (Bo Schafers) > 8. Internal Server Error (Rifaudeen M.M.) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Tue, 29 May 2007 08:25:27 -0500 (CDT) > From: "Joshua M. Ferraro" <jmf(a)liblime.com> > Subject: Re: [Koha] 3 Bugs Making Librarian's Job a Challenge > To: bo(a)weavebrain.com.au > Cc: koha(a)lists.katipo.co.nz > Message-ID: <3282960.38581180445127606.JavaMail.root(a)mail.liblime.com> > Content-Type: text/plain; charset=utf-8 > > Hi Bo, > > See comments below: > > ----- "Bo Schafers" <bo(a)weavebrain.com.au> wrote: > > Sorry to post yet again, but I've been working all afternoon to try > > and make Koha operational for our organisation...Version 2.2.9 > > > > 1. In Cataloging, librarians are: > > A) Unable to edit a biblio's 'item values' and update/save them - the > > stored values are not even loaded into the from fields from the DB > > B) Unable to delete a biblio's 'items'. Clicking delete, nothing > > happens. > > > > 2. In Cataloging, when changing updating values in field 942c > > (itemtypes) in the Marc editor screen it does not update the new value > > in the biblioitems table. > These two issues would appear to be problems in the way you have > defined your Bibliographic Frameworks. Could you double-check that > you have mapped items fields to the items table in your framework? More > details on these issues would be useful to determine what the problem > might be. > > > 3. When Deleting a book from Koha, the Biblio Subtitle (245b) is not > > erased from the subtitle database. When new books are added then the > > subtitles of the other books get all screwed up, Wrong, random > > subtitles for the books. Only solution is command line or phpmyadmin. > > Spooky! > Nice catch, this definitely was a bug, it was logged in bugzilla > as #1346: http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1346 > > Thanks to Henri-Damian, it has been fixed in CVS (added two lines > to Biblio.pm. Here's the changelog: > > http://cvs.savannah.nongnu.org/viewvc/koha/C4/Biblio.pm? view=log&root=koha&pathrev=rel_2_2 > > > Not sure if I can present such a system to our library workers as yet. > > Bu then I have high hopes that the answers to the above can be found > > via the venerable readers of this list. > Thanks for your feedback thusfar, and keep it coming! > > Cheers, > > -- > Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE > President, Technology migration, training, maintenance, support > LibLime Featuring Koha Open-Source ILS > jmf(a)liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS > > > ------------------------------ > > Message: 2 > Date: Tue, 29 May 2007 10:28:58 -0400 > From: "Jason Ronallo" <jronallo(a)gmail.com> > Subject: Re: [Koha] 3 Bugs Making Librarian's Job a Challenge > To: bo(a)weavebrain.com.au > Cc: koha(a)lists.katipo.co.nz > Message-ID: > <763570460705290728n68b6bd19sfada883fd5da8676(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Hi, Bo, > Let's see if we can get you back on track some. > > On 5/27/07, Bo Schafers <bo(a)weavebrain.com.au> wrote: > > Sorry to post yet again, but I've been working all afternoon to try and > > make Koha operational for our organisation...Version 2.2.9 > > What are your other specs? Operating system and version of mysql. > Include those in your messages helps folks get a quicker read on what > might be happening. > > > 1. In Cataloging, librarians are: > > A) Unable to edit a biblio's 'item values' and update/save them - the > > stored values are not even loaded into the from fields from the DB > > B) Unable to delete a biblio's 'items'. Clicking delete, nothing happens. > > > > 2. In Cataloging, when changing updating values in field 942c > > (itemtypes) in the Marc editor screen it does not update the new value > > in the biblioitems table. > > Koha gives you lots of room to configure your system exactly how you > want. It's powerful, but a whole lot of work once you start making > changes from the default. Leave yourself a good bit of time to > completely configure your system. > > Be sure to do the MARC check before importing records. It won't catch > everything but will notice the major errors. Any time you make a > change to your framework or the other parameters in the check, run the > MARC check again. > > My best advice here would be to carefully follow the guide here: > http://www.kohadocs.org/usersguide/ > I skimmed through it once before following it step by step to get an > overview of the whole system. If you run into something particular > that you don't understand, let the list know specifics and someone > should have an idea how to proceed. > > > > > 3. When Deleting a book from Koha, the Biblio Subtitle (245b) is not > > erased from the subtitle database. When new books are added then the > > subtitles of the other books get all screwed up, Wrong, random subtitles > > for the books. Only solution is command line or phpmyadmin. Spooky! > > Thank you for confirming this bug affected someone else. I reported > this bug (1346) and it appears to be fixed in CVS. I applied a patch > to my 2.2.8 based on latest CVS and it now works for me. > > > Not sure if I can present such a system to our library workers as yet. > > Bu then I have high hopes that the answers to the above can be found via > > the venerable readers of this list. > > Stick with it. Setting things up how you want them takes some time, > but you'll end up with just the system your location needs. > > And do continue to report possible bugs. When you report a bug that > helps get something fixed for you, you're also helping the whole Koha > community. > > take care, > > --Jason > > > ------------------------------ > > Message: 3 > Date: Wed, 30 May 2007 00:37:30 +0800 > From: Bo Schafers <bo(a)weavebrain.com.au> > Subject: Re: [Koha] 3 Bugs Making Librarian's Job a Challenge > To: Koha(a)lists.katipo.co.nz > Message-ID: <465C56CA.8090107(a)weavebrain.com.au> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Hi HD! > > First of all thank you *again* for solving some of my problems. I do > apologise for being a bit pushy by flooding the list with postings, > some of which probably belong in Bugzilla. I was a bit hesitant putting > anything in there, it looked to me like a bunch of devs communicating, > did not want to intrude putting my dilletante comments in there... > > Bo Schafers a écrit : > >> 1. In Cataloging, librarians are: > >> A) Unable to edit a biblio's 'item values' and update/save them - the > >> stored values are not even loaded into the from fields from the DB > >> B) Unable to delete a biblio's 'items'. Clicking delete, nothing > >> happens. > >> > > Did you link itemnumber to tag_item$9 subfield ? > > OK. I took me a looong time (about 3 hours) to figure out what you were > trying to tell me there. So I started poking a round in the subfield > interface again and remembered that when doing the MARC check on sunday > I kept getting the following cryptic error message: > itemnum : the field itemnumber must be mapped to a field in tab -1 (ignore) > > Huh? Itemnum? I couldn't find a field called 'itemnumber', so I guessed > it must be that. Then, whenever I put the field in tab -1 -I got an > error message saying item fields must all be in Tab 10. Setting > Ignore just didn't make sense, because I would NOT WANT Koha to ignore > itemnumber field. So I ran around in circles until eventually I unmapped > the field and ran MARC check again. It reporteed no errors, so i though > that's what the solutionthat error message was.....Sorry about the long > story...just trying to say..I'm not posting flippnatly to the list to > give you guys a hard time, I'm actually spending a lot of time guessing > and working by trial and error, deeply respectful of all the good work > you guys have done... > > So today I finally figured out that intemnumber subfield *has* to be set > to ignore. And now the editing and deleting of items works :-) > > >> 2. In Cataloging, when changing updating values in field 942c > >> (itemtypes) in the Marc editor screen it does not update the new > >> value in the biblioitems table. > > Have you linked 942c to biblioitems.itemtype in Biblioframework ? > > Is biblioitems.itemtype linked to only one subfield in the framework > > you use ? > > YES! I have simply made a list of all the Koha fields, set virtually all > other MARC fields to ignore, so I have the complete set of koha tags > mapped *correctly*. As mentined before I can actually edit/update the > MARC form and it all works, in MARC view- but it does not translate to > simple view. I make a change- say the title, or item type, then it shows > up in MARC view, however the Opac renders the tradtional, simple view > and the changes are not reflected. I AM sure there is something wrong > there, I can replicate this behaviour in the the Liblime demo installation! > > >> 3. When Deleting a book from Koha, the Biblio Subtitle (245b) is not > >> erased from the subtitle database. When new books are added then the > >> subtitles of the other books get all screwed up, Wrong, random > >> subtitles for the books. Only solution is command line or phpmyadmin. > >> Spooky! > >> > Thank you for the updated biblio.pm in the the CVS. Subtitles are now > correctly deleted and I'm very thankful. I urge all users of 2.9.9 to > update this file. > > Maybe a solution would be to upload libLime's MARC framework in your > > DB rather than trying to build one on your own. > > Koha MARC frameworks are quite sensitive to bad configuration. > > > Hmmm. One can do that? That's cool! But how would I do that? And how do > I import it. Sorry to bother you with this, but I have not read or seen > anything about this, a link to some info would do, I'll figure out the rest. > > > I also tested npl templates for all the problems you speak about. > > Everything works well. > > > When you get a moment please check if MARC form edits show up in > simple/Opac view, > > Thanks again and kind regards, > Bo > > > ------------------------------ > > Message: 4 > Date: Wed, 30 May 2007 00:56:21 +0800 > From: Bo Schafers <bo(a)weavebrain.com.au> > Subject: Re: [Koha] How to make MARC Fields Appear in Opac? > To: bo(a)weavebrain.com.au > Cc: koha(a)lists.katipo.co.nz > Message-ID: <465C5B35.3000407(a)weavebrain.com.au> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Hi , > > Now that I have my fields, how do I control which field displays in > > the Opac? Also, changing the label to the field? > Just wondered if anyone had any pointers to this topic posted a few days > ago. I have tried -via the subfields screens- to use the 17 visibility > setting mentioned in the help file but have not been able to make tags > apear... > > Here's a small, specifically related example. In my Koha installation I > have defined: > > For Marc: 942K Dewy/Call Number > For Items: 952K Call Number (Combined) > > These display fine throughout various screens on the intranet but how > can I make the call number show in the opac? Which subfield/linkage is > required for the opac field to display 942/952 fields. Go to > http://opac.bswa.org/cgi-bin/koha/opac-detail.pl?bib=3 - the call > number area is not filled here. If you go into MARC view you can see the > call number. > > Any help would be much appreciated. > > Bo > > (Koha 2.9.9 MYSQL 5.0 Apache 2 on Ubuntu Feisty) > > > > > ------------------------------ > > Message: 5 > Date: Tue, 29 May 2007 12:08:31 -0500 (CDT) > From: "Joshua M. Ferraro" <jmf(a)liblime.com> > Subject: Re: [Koha] How to make MARC Fields Appear in Opac? > To: bo(a)weavebrain.com.au > Cc: koha(a)lists.katipo.co.nz > Message-ID: > <28446066.39361180458511395.JavaMail.root(a)mail.liblime.com> > Content-Type: text/plain; charset=utf-8 > > Hi Bo, > > The visibility settings in Koha are designed to affect the visibility > of fields in the MARC view of the OPAC, not the default view. If you > want to alter the view of the default view you'll have to edit the > template directly. > > We've had some ideas for a while for using an XSLT stylesheet to > change what is visible, and indeed, we've even done some mockups > of what that could look like and the flexibility it would give > us, but unfortunately, no library has stepped forward and sponsored > that feature enhancement. > > If you're interested, here's a mockup of what could be done: > > XSLT Stylesheet: > http://search.athenscounty.lib.oh.us/opac-tmpl/compact.xsl > > Resulting view: > http://search.athenscounty.lib.oh.us/cgi-bin/koha/opac-cardview.pl?bib=88099 > > By altering that simple XSLT stylesheet you could drastically change > the 'simple' view of a given record. ... anyway ... > > Cheers, > > -- > Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE > President, Technology migration, training, maintenance, support > LibLime Featuring Koha Open-Source ILS > jmf(a)liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS > > ----- "Bo Schafers" <bo(a)weavebrain.com.au> wrote: > > Hi , > > > Now that I have my fields, how do I control which field displays in > > > > > the Opac? Also, changing the label to the field? > > Just wondered if anyone had any pointers to this topic posted a few > > days > > ago. I have tried -via the subfields screens- to use the 17 visibility > > > > setting mentioned in the help file but have not been able to make tags > > > > apear... > > > > Here's a small, specifically related example. In my Koha installation > > I > > have defined: > > > > For Marc: 942K Dewy/Call Number > > For Items: 952K Call Number (Combined) > > > > These display fine throughout various screens on the intranet but how > > > > can I make the call number show in the opac? Which subfield/linkage is > > > > required for the opac field to display 942/952 fields. Go to > > http://opac.bswa.org/cgi-bin/koha/opac-detail.pl?bib=3 - the call > > number area is not filled here. If you go into MARC view you can see > > the > > call number. > > > > Any help would be much appreciated. > > > > Bo > > > > (Koha 2.9.9 MYSQL 5.0 Apache 2 on Ubuntu Feisty) > > > > > > _______________________________________________ > > Koha mailing list > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > ------------------------------ > > Message: 6 > Date: Tue, 29 May 2007 13:11:18 -0400 > From: "Jason Ronallo" <jronallo(a)gmail.com> > Subject: Re: [Koha] How to make MARC Fields Appear in Opac? > To: bo(a)weavebrain.com.au > Cc: koha(a)lists.katipo.co.nz > Message-ID: > <763570460705291011t6423419ds19040920bb3a1326(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > > These display fine throughout various screens on the intranet but how > > can I make the call number show in the opac? Which subfield/linkage is > > required for the opac field to display 942/952 fields. Go to > > http://opac.bswa.org/cgi-bin/koha/opac-detail.pl?bib=3 - the call > > number area is not filled here. If you go into MARC view you can see the > > call number. > > Bo, > I took a look at the link you provided. Is the call number you want to > show up in the call number column KOS 540? If so you might just have > to edit your template to have it show in that column. Make sure you're > changing the template you've selected in your parameters. > > > --Jason > > > ------------------------------ > > Message: 7 > Date: Wed, 30 May 2007 01:17:01 +0800 > From: Bo Schafers <bo(a)weavebrain.com.au> > Subject: Re: [Koha] How to make MARC Fields Appear in Opac? > To: "Joshua M. Ferraro" <jmf(a)liblime.com> > Cc: koha(a)lists.katipo.co.nz > Message-ID: <465C600D.8030302(a)weavebrain.com.au> > Content-Type: text/plain; charset=UTF-8; format=flowed > > Joshua M. Ferraro wrote: > > If you > > want to alter the view of the default view you'll have to edit the > > template directly. > > > > > OK! Thanks,,, > > > If you're interested, here's a mockup of what could be done: > > > > > Yes that kind of thing would be marvellous. Once I have Koha running > for our little non profit organisation's library I'll promote it no > end, perhaps eventually a bigger player will sponsor such enhancement. > > Regards, > Bo > > > ------------------------------ > > Message: 8 > Date: Tue, 29 May 2007 23:36:06 +0600 > From: "Rifaudeen M.M." <rifayiqa(a)seu.ac.lk> > Subject: [Koha] Internal Server Error > To: <koha(a)lists.katipo.co.nz> > Message-ID: <B178C67BD25A1445A0588113CDDE65F98A9CC4(a)mailolv.seu.ac.lk> > Content-Type: text/plain; charset="iso-8859-1" > > > > > > Dear friends, > > I have installed the KOHA 2.2.8 win version on XP environment. After > installation, when I try to access the OPAc as well as intranet , the > following error message appear. > > Could u please guide me how to resolve it. > > > > Error message is; > > > "Internal Server Error > > > The server encountered an internal error or misconfiguration and was unable > to complete your request. > > Please contact the server administrator, webmaster@dummy-opac and inform them > of the time the error occurred, and anything you might have done that may > have caused the error. > > More information about this error may be available in the server error log." > > > Best regards, > > MM Rifaudeen > Acting Librarian > _________________________________ > Library > South Eastern University of Sri Lanka > P.O. Box No.01, University Park, Oluvil #32360, > SRI LANKA. > Ph./Fax: +94 67 2255160 > Mobile: +94 77 6576115 > E-mail: rifayiqa(a)seu.ac.lk > Web: www.seu.ac.lk > >

2 1

MySQL Error on 2.2.9 Install
by Bo Schafers 31 May '07

31 May '07

Someone on the list recently asked me if I had any install errors with Version 2.2.9 - ?? I hope it's allright to post it here? (Ubuntu Feisty Apache2 and MySql 5.0 server) My question would be, what does this mean. How corrupt are my database tables? Is there anything that I need to do to stabilise the system? CREATING DATABASE Creating the MySQL database for Koha... DBD::mysql::st execute failed: Invalid default value for 'aqbudgetid' at scripts/updater/updatedatabase line 1717. DBD::mysql::st execute failed: Invalid default value for 'id' at scripts/updater/updatedatabase line 1717. synch'ing borrowers creating column textmessaging creating column password creating column flags creating column userid creating column homezipcode creating column zipcode creating column sort1 creating column sort2 synch'ing items creating column itemcallnumber synch'ing biblio synch'ing biblioitems creating column place

3 3

RE: Koha Digest, Vol 19, Issue 42
by Khaliq Yar Haidary 31 May '07

31 May '07

Can anybody tell me how to remove / unstall Koha from Fedora Core 6. With thank Khaliq Yar khaidary(a)auaf.net -----Original Message----- From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request(a)lists.katipo.co.nz Sent: Wednesday, May 30, 2007 8:30 PM To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 19, Issue 42 Send Koha mailing list submissions to koha(a)lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request(a)lists.katipo.co.nz You can reach the person managing the list at koha-owner(a)lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..." Today's Topics: 1. Re: Overdues notices and fines: what scripts are supposed to work? (Kyle Hall) 2. Re: Overdues notices and fines: what scripts are supposed to work? (Kevin O'Rourke) 3. Re: Overdues notices and fines: what scripts are supposed to work? (Kevin O'Rourke) 4. Re: Overdues notices and fines: what scripts are supposed to work? (Joshua M. Ferraro) 5. Re: Overdues notices and fines: what scripts are supposed to work? (Kevin O'Rourke) 6. Re: data entry and barcode generation (Steven F.Baljkas) 7. Re: "Purchase Suggestion" Form Available but does not work (Joshua M. Ferraro) ---------------------------------------------------------------------- Message: 1 Date: Wed, 30 May 2007 09:21:55 -0400 From: "Kyle Hall" <kyle.m.hall(a)gmail.com> Subject: Re: [Koha] Overdues notices and fines: what scripts are supposed to work? To: "Kevin O'Rourke" <lists(a)caboose.org.uk> Cc: Koha Mailing List <koha(a)lists.katipo.co.nz> Message-ID: <aa4e12320705300621s3854a02ak4fa03057312fa11e(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed If you are interested, I've written alternative fines and overdues generators that are part of koha-tools ( http://kylehall.info/index.php/projects/koha-tools/ ). The fines generator creates fines for an item upon the return of an item, rather then generating fines each night. That means that each item will only have one fine listed that totals the amount due, rather than a fine for each day overdue. This more closely emulates our previous ILS and our librarians preferred it. The overdues generator allows you to specify the period of 'overdueness' and allows one to create a shelf list to check for items that might have been accidentally shelved without first being returned, and also a pdf of nicely formatted notices to mail out. Both of them are written in PHP rather than Perl, and that's why I've kept them in a separate project rather than as part of the Koha repository. Kyle On 5/30/07, Kevin O'Rourke <lists(a)caboose.org.uk> wrote: > I've just started looking into emailing overdue notices to our members. > I tried out the overduenotices.pl script but it doesn't seem to be > working. I don't get any output when I run it with the -n parameter (no > email, output to stdout) but I also don't get any errors. Does anyone > have this working correctly in 2.2.9 (Debian Sarge)? > > The documentation at kohadocs.org seems to suggest that since version > 2.2 none of the scripts for calculating fines work. Is this true? > > -- > Kevin O'Rourke > ICT Coordinator, National Teachers' Institute, Kaduna, Nigeria > 062 316972 > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > -- IT Tech Crawford County Federated Library System ------------------------------ Message: 2 Date: Wed, 30 May 2007 14:46:59 +0100 From: Kevin O'Rourke <lists(a)caboose.org.uk> Subject: Re: [Koha] Overdues notices and fines: what scripts are supposed to work? To: Koha Mailing List <koha(a)lists.katipo.co.nz> Message-ID: <465D8053.7020709(a)caboose.org.uk> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Kyle Hall wrote: > If you are interested, I've written alternative fines and overdues > generators that are part of koha-tools ( > http://kylehall.info/index.php/projects/koha-tools/ ). > > The fines generator creates fines for an item upon the return of an > item, rather then generating fines each night. That means that each > item will only have one fine listed that totals the amount due, rather > than a fine for each day overdue. This more closely emulates our > previous ILS and our librarians preferred it. That sounds very interesting. Having to run cron jobs for things like fines is one of the parts of Koha that seems unnecessarily complicated to me. > Both of them are written in PHP rather than Perl, and that's why I've > kept them in a separate project rather than as part of the Koha > repository. I'm a little bit concerned about adding separate things like this to our Koha setup, especially when the download is only possible from a Subversion repository. I can deal with all these things, but I'm only here until September so I'm trying to keep the system as easy to deal with as possible. Thanks -- Kevin O'Rourke ICT Coordinator, National Teachers' Institute, Kaduna, Nigeria 062 316972 ------------------------------ Message: 3 Date: Wed, 30 May 2007 15:20:39 +0100 From: Kevin O'Rourke <lists(a)caboose.org.uk> Subject: Re: [Koha] Overdues notices and fines: what scripts are supposed to work? To: "Joshua M. Ferraro" <jmf(a)liblime.com> Cc: Koha Mailing List <koha(a)lists.katipo.co.nz> Message-ID: <465D8837.7020507(a)caboose.org.uk> Content-Type: text/plain; charset="utf-8" Joshua M. Ferraro wrote: >>> The documentation at kohadocs.org seems to suggest that since >>> >> version >> >>> 2.2 none of the scripts for calculating fines work. Is this true? >>> >> I'm still curious which fines script I should use. >> > The fines module in Koha is a fine example of a feature that hasn't > been fully exposed to the system administration section of the admin > interface. For now, the assumption is that if you need to enable > fines and you're managing Koha yourself (as opposed to getting > commercial support from one of the available providers), you'll be > spending some time customizing the fines script and module to suit > your needs. That said, have a look at the fines2.pl in misc/ that > relies on C4/Circulation/Fines.pm, it's a good example of how to > start out with fines management in Koha. > Thanks for the information. So it looks like the documentation is wrong and fines2.pl does work, but needs customisation. I've had a look at it and it's not pretty, there are far too many magic numbers in there. For example, there's a maximum fine variable buried in the code, set to 5. However, here in Nigeria that's far too low (there are about 130 Naira to the US Dollar). If I had the time I'd rewrite it to read things out of system preferences. Would I be right in saying that for each "fine cycle" (7 days or whatever) this will add an additional line item to the borrower's record? Getting support from one of the available providers would be great, but Nigerian educational organisations just don't have the money. -- Kevin O'Rourke ICT Coordinator, National Teachers' Institute, Kaduna, Nigeria 062 316972

2 1

3 Bugs Making Librarian's Job a Challenge
by Bo Schafers 30 May '07

30 May '07

Sorry to post yet again, but I've been working all afternoon to try and make Koha operational for our organisation...Version 2.2.9 1. In Cataloging, librarians are: A) Unable to edit a biblio's 'item values' and update/save them - the stored values are not even loaded into the from fields from the DB B) Unable to delete a biblio's 'items'. Clicking delete, nothing happens. 2. In Cataloging, when changing updating values in field 942c (itemtypes) in the Marc editor screen it does not update the new value in the biblioitems table. 3. When Deleting a book from Koha, the Biblio Subtitle (245b) is not erased from the subtitle database. When new books are added then the subtitles of the other books get all screwed up, Wrong, random subtitles for the books. Only solution is command line or phpmyadmin. Spooky! Not sure if I can present such a system to our library workers as yet. Bu then I have high hopes that the answers to the above can be found via the venerable readers of this list. Regards, Bo

3 5

"Purchase Suggestion" Form Available but does not work
by Bo Schafers 30 May '07

30 May '07

Hello, The 'purchase suggestion' form can be accessed and filled in by all, even visitors who are not logged in... However when submitting the form as an anonymous visitor the form fails transparently, no error message, no confirmation. The patron might believe he's actually sent a request to a librarian when in reality her well-researched and thoughtful book suggestion has has fallen into a boundless, digital vaccum -never to be seen again or heard of again. (Version 2.2.9) Something for the devs... Regards, Bo

2 2