- Koha - lists.katipo.co.nz

Koha installation on Ubuntu 14.04 LTS
by Vimal Kumar V. 20 Apr '14

20 Apr '14

Dear Friends, I made an attempt to install Koha on Ubuntu 14.04. I got following messages after executing the command apt-get install koha-common. I invite your help to interpret the message. Setting up libapache2-mpm-itk (2.4.6-01-1) ... dpkg: error processing package libapache2-mpm-itk (--configure): subprocess installed post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of apache2-mpm-itk: apache2-mpm-itk depends on libapache2-mpm-itk; however: Package libapache2-mpm-itk is not configured yet. dpkg: error processing package apache2-mpm-itk (--configure): dependency problems - leaving unconfigured dpkg: dependency problems prevent configuration of koha-common: No apport report written because the error message indicates its a followup error from a previous failure. koha-common depends on apache2-mpm-itk; however: Package apache2-mpm-itk is not configured yet. dpkg: error processing package koha-common (--configure): dependency problems - leaving unconfigured No apport report written because the error message indicates its a followup error from a previous failure. Errors were encountered while processing: libapache2-mpm-itk apache2-mpm-itk koha-common E: Sub-process /usr/bin/dpkg returned an error code (1) Regards, -- Vimal Kumar V. Technical Assistant Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.info Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in http://moovandan.blogspot.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

3 2

Koha installation on Ubuntu 14.04 LTS
by Vimal Kumar V. 19 Apr '14

19 Apr '14

Dear Friends, I made an attempt to install Koha on Ubuntu 14.04. I got following messages after executing the command apt-get install koha-common. I invite your help to interpret the message. Setting up libapache2-mpm-itk (2.4.6-01-1) ... dpkg: error processing package libapache2-mpm-itk (--configure): subprocess installed post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of apache2-mpm-itk: apache2-mpm-itk depends on libapache2-mpm-itk; however: Package libapache2-mpm-itk is not configured yet. dpkg: error processing package apache2-mpm-itk (--configure): dependency problems - leaving unconfigured dpkg: dependency problems prevent configuration of koha-common: No apport report written because the error message indicates its a followup error from a previous failure. koha-common depends on apache2-mpm-itk; however: Package apache2-mpm-itk is not configured yet. dpkg: error processing package koha-common (--configure): dependency problems - leaving unconfigured No apport report written because the error message indicates its a followup error from a previous failure. Errors were encountered while processing: libapache2-mpm-itk apache2-mpm-itk koha-common E: Sub-process /usr/bin/dpkg returned an error code (1) Regards, -- Vimal Kumar V. Technical Assistant Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.info Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in http://moovandan.blogspot.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

1 0

Auto zebra update: /etc/cron.d/koha-common
by andrea.furin＠slacky.it 19 Apr '14

19 Apr '14

Hi to all. It seems that /etc/cron.d/koha-common doesn't work: I changed the line in this: */5 * * * * esg-koha esg -x /usr/sbin/koha-rebuild-zebra ETC.. esg-koha: my koha user esh: my database name but nothing happens. Some advices? Thanks in advance Andrea Furin

2 1

Cannot place hold
by Anthony Mao 19 Apr '14

19 Apr '14

Hi, I need your help. I can not place hold from staff interface at 3.14.5 At staff interface, from Home › Catalog find particular item which I try to hold, but Koha reply as: Cannot place hold Too many holds: mao has too many holds. mao is reader name. In fact this is the first hold for mao. I check the Holds Policy at Home › Administration › System preferences. set maxreserves as Patrons can only have 10 holds at once. -- Wishing you all the best. . . . Anthony Mao 毛慶禎＋886 2 29052334 (voice) + 886 2 29017405 (FAX)

2 2

Request to add as KOHA PAID SUPPORT PROVIDER
by vikrant malik 18 Apr '14

18 Apr '14

Dear community, We request you to add our organization in the paid support list,in our State we are providing support and service to KOHA library management system please find the information. *Company Name:* jivesna tech pvt. ltd *Contact Person:* utsav rai, *Contact email:* utsav(a)jivesna.com, info(a)jivesna.com *Website:* http://www.jivesna.com/ *Telephone:* 91-0120-4266526, +91-8860611657,9654093042 *Address:* A/209, Sector -17, Vasundhara, Ghaziabad (u.p) 201012, India *Short description of your services:* Our Koha support includes - Training for all major updates to Koha’s functionality via online training or training in person. - installation and customization for koha - - Technical consulting and Solutions. - User training at 3-levels (User, Librarian and Administrator). - Solutions for Data Migration. - Solutions for Networking of Libraries. -- Best regard's vikrant malik +91-9555927211 Jivesna Tech Pvt.Ltd. www.jivesna.com

2 1

A few koha-community sites down, download and bugs
by Chris Cormack 18 Apr '14

18 Apr '14

I am going to upgrade my linode, these sites will be down until this is completed Chris

1 1

possible error at ACQ module
by Anthony Mao 17 Apr '14

17 Apr '14

Hi, Is it a bug? I am using Koha 3.14.5 under Ubuntu 12.04. Create New order, from Home › Acquisitions › vendorname(碩陽數位科技有限公司) › Basket 1 › New order Quantity is required. But I could not move cursor to Quantity field box. Koha reply as: - Quantity must be greater than '0' Do I make something wrong? -- Wishing you all the best. . . . Anthony Mao 毛慶禎＋886 2 29052334 (voice) + 886 2 29017405 (FAX)

2 2

Report Help
by manoj382093 16 Apr '14

16 Apr '14

Dear Friends, I am looking for a report which has list of titles(biblio) their number of copies(items) by item type and collection code. -- View this message in context: http://koha.1045719.n5.nabble.com/Report-Help-tp5793161.html Sent from the Koha-general mailing list archive at Nabble.com.

5 9

Re: [Koha] Koha Digest, Vol 102, Issue 27-biblioitems-> marcxml
by amutsikiwa＠uzlib.uz.ac.zw 15 Apr '14

15 Apr '14

Hi Thanks , it appears it is stored there. Here is the contents of biblioitems-> marcxml <?xml version="1.0" encoding="UTF-8"?> <record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd" xylenes="http://www.loc.gov/MARC21/slim"> <leader>01842cam a2200397 a 4500</leader> <controlfield tag="001">14561611</controlfield> <controlfield tag="003">OSt</controlfield> <controlfield tag="005">20140415120055.0</controlfield> <controlfield tag="008">060921s2007 paua b 001 0 eng </controlfield> <datafield tag="010" ind1=" " ind2=" "> <subfield code="a"> 2006031366</subfield> </datafield> <datafield tag="020" ind1=" " ind2=" "> <subfield code="a">1591409411 (hardcover)</subfield> </datafield> <datafield tag="020" ind1=" " ind2=" "> <subfield code="a">9781591409410 (hardcover)</subfield> </datafield> <datafield tag="020" ind1=" " ind2=" "> <subfield code="a">159140942X (softcover)</subfield> </datafield> <datafield tag="020" ind1=" " ind2=" "> <subfield code="a">9781591409427 (softcover)</subfield> </datafield> <datafield tag="020" ind1=" " ind2=" "> <subfield code="a">1591409438 (ebook)</subfield> </datafield> <datafield tag="020" ind1=" " ind2=" "> <subfield code="a">9781591409434 (ebook)</subfield> </datafield> <datafield tag="035" ind1=" " ind2=" "> <subfield code="a">(OCoLC)ocm71632267</subfield> </datafield> <datafield tag="040" ind1=" " ind2=" "> <subfield code="a">DLC</subfield> <subfield code="c">DLC</subfield> <subfield code="d">BAKER</subfield> <subfield code="d">C#P</subfield> <subfield code="d">YDXCP</subfield> <subfield code="d">IXA</subfield> <subfield code="d">BTCTA</subfield> <subfield code="d">DLC</subfield> </datafield> <datafield tag="050" ind1="0" ind2="0"> <subfield code="a">QA76.758</subfield> <subfield code="b">.A375 2007</subfield> </datafield> <datafield tag="082" ind1="0" ind2="0"> <subfield code="a">005.1</subfield> <subfield code="2">22</subfield> </datafield> <datafield tag="245" ind1="0" ind2="0"> <subfield code="a">Advances in machine learning applications in software engineering /</subfield> <subfield code="c">Du Zhang, Jeffrey J.P. Tsai [editors].</subfield> </datafield> <datafield tag="260" ind1=" " ind2=" "> <subfield code="a">Hershey, PA :</subfield> <subfield code="b">Idea Group Pub.,</subfield> <subfield code="c">c2007.</subfield> </datafield> <datafield tag="300" ind1=" " ind2=" "> <subfield code="a">xv, 480 p. :</subfield> <subfield code="b">ill. ;</subfield> <subfield code="c">26 cm.</subfield> </datafield> <datafield tag="504" ind1=" " ind2=" "> <subfield code="a">Includes bibliographical references and index.</subfield> </datafield> <datafield tag="520" ind1=" " ind2=" "> <subfield code="a">"This book provides analysis, characterization and refinement of software engineering data in terms of machine learning methods. It depicts applications of several machine learning approaches in software systems development and deployment, and the use of machine learning methods to establish predictive models for software quality while offering readers suggestions by proposing future work in this emerging research field"--Provided by publisher.</subfield> </datafield> <datafield tag="650" ind1=" " ind2="0"> <subfield code="a">Software engineering.</subfield> </datafield> <datafield tag="650" ind1=" " ind2="0"> <subfield code="a">Self-adaptive software.</subfield> </datafield> <datafield tag="650" ind1=" " ind2="0"> <subfield code="a">Application software.</subfield> </datafield> <datafield tag="650" ind1=" " ind2="0"> <subfield code="a">Machine learning.</subfield> </datafield> <datafield tag="700" ind1="1" ind2=" "> <subfield code="a">Zhang, Du.</subfield> </datafield> <datafield tag="700" ind1="1" ind2=" "> <subfield code="a">Tsai, Jeffrey J.-P.</subfield> </datafield> <datafield tag="856" ind1="4" ind2="1"> <subfield code="3">Table of contents only</subfield> <subfield code="u">http://www.loc.gov/catdir/toc/ecip071/2006031366.html</subfield> </datafield> <datafield tag="906" ind1=" " ind2=" "> <subfield code="a">7</subfield> <subfield code="b">cbc</subfield> <subfield code="c">orignew</subfield> <subfield code="d">1</subfield> <subfield code="e">ecip</subfield> <subfield code="f">20</subfield> <subfield code="g">y-gencatlg</subfield> </datafield> <datafield tag="942" ind1=" " ind2=" "> <subfield code="2">lcc</subfield> <subfield code="c">BK</subfield> </datafield> <datafield tag="955" ind1=" " ind2=" "> <subfield code="a">jg12 2006-09-22</subfield> <subfield code="i">jg12 2006-09-22</subfield> <subfield code="a">aa24 2006-09-23</subfield> <subfield code="a">ps04 2007-04-03 2 copies rec'd., to CIP ver.</subfield> </datafield> <datafield tag="999" ind1=" " ind2=" "> <subfield code="c">3</subfield> <subfield code="d">3</subfield> </datafield> </record> -----Original Message----- From: Koha [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request(a)lists.katipo.co.nz Sent: Tuesday, April 15, 2014 2:00 AM To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 102, Issue 27 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: Possible APP development (Viktor.Sarge(a)regionhalland.se) 2. Where are subject headings ( field 650$a) stored in in Koha database (amutsikiwa(a)uzlib.uz.ac.zw) 3. Re: Where are subject headings ( field 650$a) stored in in Koha database (Micha? Dudzik) 4. Re: Possible APP development (Sue McMillan) 5. Re: Importing Patron Loan History (old_issues) (Robin Sheat) ---------------------------------------------------------------------- Message: 1 Date: Mon, 14 Apr 2014 09:31:10 +0000 From: <Viktor.Sarge(a)regionhalland.se> To: <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Possible APP development Message-ID: <7F90BEB05D15BF4C972C39D71C96646903CF96CF(a)ltexch1.lthalland.se> Content-Type: text/plain; charset="utf-8" My two cents: If I understand the state of things correctly offline web apps in HTML5 is already possible. Push notifications over the web isn't there yet even if OS X has it and I hope that it becomes more common. I think that the advantage of using push notifications instead of e-mail/SMS isn't big enough to motivate using the resources neded to create and maintain tablet and phone apps for Android, iOS and possible Windows devices. I do however understand if someone wants to code those apps because it's fun :) Worth investigating might also be gateway apps that receives push-notifications for you without the need for installing a native app. I cannot vouch for https://pushover.net/ but a quick search turned it up and the idea seems to be sound. Kind regards/Viktor -----Ursprungligt meddelande----- Fr?n: Koha [mailto:koha-bounces@lists.katipo.co.nz] F?r Robin Sheat Skickat: den 10 april 2014 02:12 Till: koha(a)lists.katipo.co.nz ?mne: Re: [Koha] Possible APP development Miller, Tim schreef op wo 09-04-2014 om 16:15 [-0700]: > One aspect that a native app can offer which a web-based app cannot is > offline work. One other thing that native apps can do that would be of use to library users is push notifications. I.e. your phone tells you when things are nearly overdue, reserves are waiting for you, the thing you suggested has shown up, and so on. -- Robin Sheat Catalyst IT Ltd. ? +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ Message: 2 Date: Mon, 14 Apr 2014 11:51:55 +0200 From: <amutsikiwa(a)uzlib.uz.ac.zw> To: <koha(a)lists.katipo.co.nz> Subject: [Koha] Where are subject headings ( field 650$a) stored in in Koha database Message-ID: <004501cf57c7$2bd791d0$8386b570$(a)uzlib.uz.ac.zw> Content-Type: text/plain; charset="us-ascii" Hi I imported close to 87000 items. I think I miss-align the subject column during data migration from liberty 3 to Koha, so the subjects are out of place. I would like to correct the error. I am interested in establishing which table in Koha holds subject headings and which field in particular. I will appreciate any pointers. Kind Regards, Admire Mutsikiwa ICT Projects Manager Libraries University of Zimbabwe Tel:+263-4-303276 "It is easy to dodge our responsibilities, but we cannot dodge the consequences of dodging our responsibilities." Josiah Charles Stamp, 1880-1941, former director of the Bank of England ------------------------------ Message: 3 Date: Mon, 14 Apr 2014 04:25:18 -0700 (PDT) From: Micha? Dudzik <dudzikmichal(a)wp.pl> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Where are subject headings ( field 650$a) stored in in Koha database Message-ID: <1397474718483-5794016.post(a)n5.nabble.com> Content-Type: text/plain; charset=UTF-8 Hi, look in biblioitems-> marcxml. Greets Micha? Dudzik -- View this message in context: http://koha.1045719.n5.nabble.com/Where-are-subject-headings-field-650-a-sto red-in-in-Koha-database-tp5794003p5794016.html Sent from the Koha-general mailing list archive at Nabble.com. ------------------------------ Message: 4 Date: Mon, 14 Apr 2014 20:23:54 +0000 From: Sue McMillan <sue.mcmillan(a)STDC.govt.nz> To: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Possible APP development Message-ID: <F080C0113CF5F741BE2B9541CA30ACDA93D5775D(a)STDCEXCH02.internal.stdc.govt.nz> Content-Type: text/plain; charset="utf-8" Thanks for everyone's input. The different views are interesting. I see one of the major advantages of having an app that uses push notifications is that here in NZ internet access for people outside of the major centres is patchy at best. Connecting to a webpage over a cell phone network or even a landline is near impossible in rural areas as the connection is weak and/or drops out continuously. High speed broadband is limited to major cities. Towns outside of these areas have broadband but at very low speeds. Some (un)lucky places still have dial up. Most rural cell phone connections get enough signal send and receive texts but not phone calls, and definitely not enough to load a webpage. Personally I would much rather have an app that sends me notifications alerting me to the need to renew books or that a held item is ready for collection than remember to login to a webpage. Regards Susan McMillan Cataloguing and Systems Administrator| South Taranaki District Council 105-111 Albion St, Hawera 4610 | Private Bag 902, Hawera 4640, NZ Phone: +64 6 278 0555 | Cell: | www.southtaranaki.com This e-mail and any attachments may contain confidential and privileged information. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient is unauthorised and may be illegal. Please note that this communication does not designate an information system for the purposes of the Electronic Transactions Act 2002. ------------------------------ Message: 5 Date: Tue, 15 Apr 2014 11:43:28 +1200 From: Robin Sheat <robin(a)catalyst.net.nz> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Importing Patron Loan History (old_issues) Message-ID: <1397519008.26172.18.camel@zarathud> Content-Type: text/plain; charset="UTF-8" jbarker schreef op vr 11-04-2014 om 06:26 [-0700]: > I tried to export our loans history data from our old ILS to koha > 3.14, > using: > load data local infile '/<PATHTO>/importloanstest.csv' into table > koha.old_issues fields terminated by ',' enclosed by '"' lines > terminated by'\n'; > > and got the following error: > ERROR 1452 (23000): Cannot add or update a child row: a foreign key > constraint fails (`koha`.`old_issues`, CONSTRAINT `old_issues_ibfk_1` > FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` > (`borrowernumber`) ON > DELETE SET NULL ON UPDATE SET NULL) This is saying that you're attempting to reference a borrower that doesn't actually exist. > So i'm just wondering how other people got their loans history into > koha from their old ILS? I tend to write scripts to do it, for example: https://gitorious.org/koha-migration-toolbox/koha-migration-toolbox/source/3 95f9d788acf79df53d2c878837ce7cb72b08467:migration/Liberty/circ.pl One thing it does do is discard any records that have a non-existent borrower or item number, as the software that it comes from keeps them around even when they're quite meaningless. -- Robin Sheat Catalyst IT Ltd. ? +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF ------------------------------ Subject: Digest Footer _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ End of Koha Digest, Vol 102, Issue 27 ************************************* -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

1 0

Importing Patron Loan History (old_issues)
by jbarker 15 Apr '14

15 Apr '14

I tried to export our loans history data from our old ILS to koha 3.14, using: load data local infile '/<PATHTO>/importloanstest.csv' into table koha.old_issues fields terminated by ',' enclosed by '"' lines terminated by'\n'; and got the following error: ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`koha`.`old_issues`, CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL) So i'm just wondering how other people got their loans history into koha from their old ILS? Thanks -- View this message in context: http://koha.1045719.n5.nabble.com/Importing-Patron-Loan-History-old-issues-… Sent from the Koha-general mailing list archive at Nabble.com.

2 1