- Koha - lists.katipo.co.nz

Migrate transaction data
by gk 26 Apr '13

26 Apr '13

Dear Sir/Madam, I tried to export current circulation data from my legacy software to koha 3.8 but not successful. I tried LOAD DATA LOCAL INFILE '<PATH>/transactions.txt' INTO TABLE issues; and got the following error: ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`issues`, CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON UPDATE CASCADE). Please help me port current circulation data to koha. -- With Warm Regards *Gopalakrishna* Librarian *BMS Institute of Technology* Avalahalli, Dodballapur Main Road, Yelahanka, BANGALORE-560064 080-65369469 9741898674

1 0

String freeze for Koha 3.12
by Jared Camins-Esakov 26 Apr '13

26 Apr '13

Hello. The string freeze for Koha 3.12 will begin on May 1, next Wednesday. Any patches with string changes need to be written, signed off, and QAed before then. The absolute deadline for anything other than security fixes is 6am EST on Wednesday, May 1*. Regards, Jared Camins-Esakov [*] http://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+3.12+string+f… -- Jared Camins-Esakov Bibliographer, C & P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcamins(a)cpbibliography.com (web) http://www.cpbibliography.com/

1 0

local use recorded / borrower
by Samuel Desseaux 25 Apr '13

25 Apr '13

Hi, I've a bug on koha When i scan the card of the borrower, i've this message "local use recorded". What does it mean? Best regards samuel

1 0

How to download koha plzzzz tell me
by Afzal Imam 25 Apr '13

25 Apr '13

-- Afzal imam Aligarh contact no.:-09319135278

2 1

April 2013 Koha Community Newsletter has been published
by Daniel Grobani 25 Apr '13

25 Apr '13

Hi, The April 2013 edition of the Koha Community Newsletter has been posted to http://koha-community.org/koha-community-newsletter-april-2013/. Cheers, Daniel Grobani Koha Community Newsletter Editor

1 0

clarification on Zebra configuration
by amutsikiwa 25 Apr '13

25 Apr '13

Hi All, On my server, I have zebra configured as a demon via the symbolic link /etc/init.d/zebra-server -> /usr/share/koha/bin/koha-zebra-ctl.sh And /etc/init.d/zebraqueue-daemon -> /usr/share/koha/bin/koha-zebraqueue-ctl.sh And I also have it scheduled to run as a cron job via Linux Koha user's cron file as shown */10 7-20 * * * /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -z -v 2>/dev/null 0 1 * * * /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -r -v 2>/dev/null My question is can the two be configured to run concurrently or they will conflict. If conflicting, which one is superior and recommended? Regards, Admire Mutsikiwa

3 2

Re: [Koha] [Koha-devel] Patch vs Plugin
by Owen Leonard 24 Apr '13

24 Apr '13

> I have a library that is interested in being able to renew items in batch by > just scanning the item barcodes. This is a bit of an unusual feature I wonder if it's so unusual? Our previous ILS had it, and I know our staff missed it when we switched to Koha. > I'm not sure where we'd put it, perhaps in the tools section, or more > apropo, the circulation home page? I would put it on the circ home page, yes. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

3 4

All old circulation issues and their corresponding borrowers and the titles of the items borrowed
by schnydszch 24 Apr '13

24 Apr '13

Good day Koha users and developers! I would like to share this mysql report that I came up to when my boss requested me to show all old circulation issues since the beginning. I went to the koha mysql report wiki but did not find what my boss wanted so I just created one and I'm sharing it. Here is the mysql query: SELECT old_issues.*, borrowers.cardnumber, borrowers.surname, borrowers.firstname, borrowers.sort1, borrowers.sort2, items.barcode, items.datelastborrowed, items.datelastseen, items.itemcallnumber, items.issues, items.holdingbranch, items.location, items.permanent_location, items.onloan, items.ccode, items.itype, items.enumchron, items.copynumber, items.location, b.totalissues, EXTRACTVALUE( b.marcxml, '//datafield[@tag="245"]/subfield[@code>="a"]' ) as TITLE FROM old_issues LEFT JOIN borrowers ON ( borrowers.borrowernumber = old_issues.borrowernumber ) LEFT JOIN items ON ( items.itemnumber = old_issues.itemnumber ) LEFT JOIN biblioitems AS b ON ( items.biblioitemnumber = b.biblioitemnumber) -- View this message in context: http://koha.1045719.n5.nabble.com/All-old-circulation-issues-and-their-corr… Sent from the Koha-general mailing list archive at Nabble.com.

3 3

Re: [Koha] Koha Digest, Vol 90, Issue 35
by vikrant malik 24 Apr '13

24 Apr '13

hi all . i am using koha version 3.8.11. on dabian squeeze . I have some books with their analytic records in spreadsheet. And I want to import them in koha and link all analytic record with their referenced book record. so can anyone suggest me. vikrant malik On Wed, Apr 24, 2013 at 6:27 AM, <koha-request(a)lists.katipo.co.nz> wrote: > 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. Fwd: search not working (zebra error) ??! (abdallah abdelsalam) > 2. Re: search not working (zebra error) ??! (Mason James) > 3. Re: Koha 3.10.5 released (Robin Sheat) > 4. need help about analytic record (vikrant malik) > 5. Re: need help about analytic record (Indranil Das Gupta) > 6. Decrease the space between barcode label (Vimal Kumar V.) > 7. Web Installer Error (mhathaway) > 8. Re: Web Installer Error (Chris Cormack) > 9. Re: Web Installer Error (mhathaway) > 10. Re: Decrease the space between barcode label (Chris Nighswonger) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 24 Apr 2013 09:10:34 +0300 > From: abdallah abdelsalam <abd.koha(a)gmail.com> > To: koha(a)lists.katipo.co.nz > Subject: [Koha] Fwd: search not working (zebra error) ??! > Message-ID: > < > CA+0PjUjmAJpHA64zCfAj0EejUHq8o5iThysZARjrmVc8VcTMOQ(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Hi > > I use Koha version 3.00.00.094 > > search does not give results(It gives results before) > but i don't know what happened > When making rebuild zebra(migration_tools/rebuild_zebra.pl -b -a -w) > This error appears > > > 20:16:43-23/04 zebraidx(22731) [fatal] Node node_zebra missing > 20:16:43-23/04 zebraidx(22731) [warn] Cannot obtain EXPLAIN information > 20:16:43-23/04 zebraidx(22731) [fatal] zebra_begin_trans: cannot open > register > > any help?? > > > ------------------------------ > > Message: 2 > Date: Wed, 24 Apr 2013 18:46:28 +1200 > From: Mason James <mtj(a)kohaaloha.com> > To: abdallah abdelsalam <abd.koha(a)gmail.com> > Cc: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] search not working (zebra error) ??! > Message-ID: <2AB92F3E-A640-4367-8AB2-D4EE1B01FE74(a)kohaaloha.com> > Content-Type: text/plain; charset=us-ascii > > > On 2013-04-24, at 6:10 PM, abdallah abdelsalam wrote: > > > Hi > > > > I use Koha version 3.00.00.094 > > > woah, thats a very old version! > try upgrading your Koha to a new version - does that fix the problem? > > > but in the meantime, try running your command as... > > ./rebuild_zebra.pl -b -r -v -x > > > > > > > > search does not give results(It gives results before) > > but i don't know what happened > > When making rebuild zebra(migration_tools/rebuild_zebra.pl -b -a -w) > > This error appears > > > > > > 20:16:43-23/04 zebraidx(22731) [fatal] Node node_zebra missing > > 20:16:43-23/04 zebraidx(22731) [warn] Cannot obtain EXPLAIN information > > 20:16:43-23/04 zebraidx(22731) [fatal] zebra_begin_trans: cannot open > > register > > > > any help?? > > > > ------------------------------ > > Message: 3 > Date: Wed, 24 Apr 2013 19:25:36 +1200 > From: Robin Sheat <robin(a)catalyst.net.nz> > To: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Koha 3.10.5 released > Message-ID: <1366788336.23927.29.camel@zarathud> > Content-Type: text/plain; charset="UTF-8" > > Chris Cormack schreef op wo 24-04-2013 om 17:25 [+1200]: > > or wait a day or 2 for the packages to become available. > > More like an hour or two this time around. Packages for both 3.08.12 and > 3.10.5 have been released. > > -- > Robin Sheat > Catalyst IT Ltd. > ? +64 4 803 2204 > GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D > > > > ------------------------------ > > Message: 4 > Date: Wed, 24 Apr 2013 03:43:48 -0400 > From: vikrant malik <vikrantmalik.hiet(a)gmail.com> > To: koha(a)lists.katipo.co.nz > Subject: [Koha] need help about analytic record > Message-ID: > < > CAHDOG3GYBQ+EX1rjRQ318PRbnLuEA_+N3DqKZED8HJ_7xviUPw(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Hello All, > > In koha I add analytic records, and they are working fine. But my problem > is that i have a no. of data in excel format. And I want to bulk import all > this data to my koha. How can I do this. Can Anyone suggest me in this > regard. > > > thanks > vikrant malik > > > ------------------------------ > > Message: 5 > Date: Wed, 24 Apr 2013 13:32:42 +0530 > From: Indranil Das Gupta <indradg(a)gmail.com> > To: koha <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] need help about analytic record > Message-ID: > < > CAEm3SZ0hH0_Dt5xa+hVkfcU1SVyJVwPwx8VgeVxLt_pGvUucSg(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Hi, > > On Wed, Apr 24, 2013 at 1:13 PM, vikrant malik > <vikrantmalik.hiet(a)gmail.com>wrote: > > > Hello All, > > > > In koha I add analytic records, and they are working fine. But my problem > > is that i have a no. of data in excel format. And I want to bulk import > all > > this data to my koha. How can I do this. Can Anyone suggest me in this > > regard. > > > > Which version of Koha? Are you using the tarball or the debian packages? > > what data do you have on the spreadsheet - bibliographic or circulation > data? > > > -- > Indranil Das Gupta > > Phone : +91-98300-20971 > Blog : http://indradg.randomink.org/blog > IRC : indradg on irc://irc.freenode.net > Twitter : indradg > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- > Please exchange editable Office documents only in ODF Format. No other > format is acceptable. Support Open Standards. > > For a free editor supporting ODF, please visit LibreOffice - > http://www.documentfoundation.org > > > ------------------------------ > > Message: 6 > Date: Wed, 24 Apr 2013 14:05:28 +0530 > From: "Vimal Kumar V." <vimal0212(a)gmail.com> > To: Koha-List <koha(a)lists.katipo.co.nz> > Subject: [Koha] Decrease the space between barcode label > Message-ID: > < > CAEaJrwWTOcq3hYRiY03h5k97WfK+ttBE6_jGz460v8GrLH+ZOQ(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Dear Friends, > How to decrease the gap between barcode lines and Call Number. > Please see the picture below give me the suggestion. > > https://plus.google.com/photos/111463704472089509119/albums/554298281532418… > > Regards, > -- > Vimal Kumar V. > 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 > > > ------------------------------ > > Message: 7 > Date: Wed, 24 Apr 2013 02:33:17 -0700 (PDT) > From: mhathaway <mhathaway(a)netherhall.cambs.sch.uk> > To: koha(a)lists.katipo.co.nz > Subject: [Koha] Web Installer Error > Message-ID: <1366795997843-5752139.post(a)n5.nabble.com> > Content-Type: text/plain; charset=us-ascii > > I'm looking into Koha as a potential replacement for our school library > system (we're a Cambridge-based secondary school and sixth form centre). > However, I'm running into difficulties getting a demo installed. > > Details: > Koha 3.10.4 > Ubuntu 12.10 server. > MySQL database and user have been created. > I'm down to step 7 of the installer, which is the Web Installer. > > The error: > Access denied for user 'kohaadmin'@'localhost' (using password: YES) > at > /usr/share/koha/lib/C4/Context.pm line 803. > BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm > line > 63. > Compilation failed in require at > /usr/share/koha/intranet/cgi-bin/mainpage.pl line 25. > BEGIN failed--compilation aborted at > /usr/share/koha/intranet/cgi-bin/mainpage.pl line 25. > > I found Lars J. Helbo's issue > (http://koha.1045719.n5.nabble.com/Installation-problem-td4449146.html) > and > subsequently tried deleting and recreating the MySQL database and user. > But > no luck. > > Logically, I was expecting the first step of the web installer to ask for > the DB details, before it could run. Is it returning this error before the > web installer can be served, or after it has already tried to run? > > This has been bugging me for several days now. Any insight into how to get > past this error would be greatly appreciated. > > > > -- > View this message in context: > http://koha.1045719.n5.nabble.com/Web-Installer-Error-tp5752139.html > Sent from the Koha-general mailing list archive at Nabble.com. > > > ------------------------------ > > Message: 8 > Date: Wed, 24 Apr 2013 21:40:02 +1200 > From: Chris Cormack <chrisc(a)catalyst.net.nz> > To: mhathaway <mhathaway(a)netherhall.cambs.sch.uk> > Cc: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Web Installer Error > Message-ID: <20130424094002.GN19162(a)rorohiko.wgtn.cat-it.co.nz> > Content-Type: text/plain; charset=us-ascii > > * mhathaway (mhathaway(a)netherhall.cambs.sch.uk) wrote: > > I'm looking into Koha as a potential replacement for our school library > > system (we're a Cambridge-based secondary school and sixth form centre). > > However, I'm running into difficulties getting a demo installed. > > > > Details: > > Koha 3.10.4 > > Ubuntu 12.10 server. > > MySQL database and user have been created. > > I'm down to step 7 of the installer, which is the Web Installer. > > > > The error: > > Access denied for user 'kohaadmin'@'localhost' (using password: > YES) at > > /usr/share/koha/lib/C4/Context.pm line 803. > > BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm > line > > 63. > > Compilation failed in require at > > /usr/share/koha/intranet/cgi-bin/mainpage.pl line 25. > > BEGIN failed--compilation aborted at > > /usr/share/koha/intranet/cgi-bin/mainpage.pl line 25. > > > > I found Lars J. Helbo's issue > > (http://koha.1045719.n5.nabble.com/Installation-problem-td4449146.html) > and > > subsequently tried deleting and recreating the MySQL database and user. > But > > no luck. > > > > Logically, I was expecting the first step of the web installer to ask for > > the DB details, before it could run. Is it returning this error before > the > > web installer can be served, or after it has already tried to run? > > > You entered the database name, user and password when running > > perl Makefile.PL it is trying to use that, the web installer doesn't > need to ask, you already told it. > > But it does need you to set up that user and db. > Check your koha-conf.xml if you can't remember what password and user > you told it to use. > > Chris > > -- > Chris Cormack > Catalyst IT Ltd. > +64 4 803 2238 > PO Box 11-053, Manners St, Wellington 6142, New Zealand > > > ------------------------------ > > Message: 9 > Date: Wed, 24 Apr 2013 03:15:01 -0700 (PDT) > From: mhathaway <mhathaway(a)netherhall.cambs.sch.uk> > To: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Web Installer Error > Message-ID: <1366798501959-5752145.post(a)n5.nabble.com> > Content-Type: text/plain; charset=us-ascii > > Many thanks for your quick response Chris. I hunted down the details in the > conf file and have now managed to complete the installation. Thank you for > your help. > > Issue closed. > > > > -- > View this message in context: > http://koha.1045719.n5.nabble.com/Web-Installer-Error-tp5752139p5752145.html > Sent from the Koha-general mailing list archive at Nabble.com. > > > ------------------------------ > > Message: 10 > Date: Wed, 24 Apr 2013 06:26:42 -0400 > From: Chris Nighswonger <cnighswonger(a)foundations.edu> > To: "Vimal Kumar V." <vimal0212(a)gmail.com> > Cc: Koha-List <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Decrease the space between barcode label > Message-ID: > < > CAP3yOomKjoOTL2W_jqn9pReK9SKGC0R6DROshUhg0Mct+nzecg(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Hi Vimal, > > On Wed, Apr 24, 2013 at 4:35 AM, Vimal Kumar V. <vimal0212(a)gmail.com> > wrote: > > > Dear Friends, > > How to decrease the gap between barcode lines and Call Number. > > Please see the picture below give me the suggestion. > > > > > https://plus.google.com/photos/111463704472089509119/albums/554298281532418… > > > > At present that adjustment would require changing some code. > > In the patron card tool these spacings are "adjustable" in the sense that > the position of each element may be specified. That tool was written after > the label tool and so the label tool missed out on that feature. > > At this point with the clear consensus that a CSS based printing tool is > better, the odds of the current label tool having this implemented are > pretty low. > > Kind Regards, > Chris > > > ------------------------------ > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > > End of Koha Digest, Vol 90, Issue 35 > ************************************ >

1 0

Decrease the space between barcode label
by Vimal Kumar V. 24 Apr '13

24 Apr '13

Dear Friends, How to decrease the gap between barcode lines and Call Number. Please see the picture below give me the suggestion. https://plus.google.com/photos/111463704472089509119/albums/554298281532418… Regards, -- Vimal Kumar V. 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