- Koha - lists.katipo.co.nz

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

Where are subject headings ( field 650$a) stored in in Koha database
by amutsikiwa＠uzlib.uz.ac.zw 14 Apr '14

14 Apr '14

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

2 1

irregular serial numbering
by Giuseppe Angilella 12 Apr '14

12 Apr '14

Hi, I'm having trouble in defining the numbering pattern for a serial. The serial is weekly (number icreases by one every new week, and is never reset to one), but the volume number increases at the beginning of each new second month. This means every 7, or 8, or 9 weeks (i.e., issues), depending on whether the two months contained 7, 8 or 9 weeks. Would it be possible to define such a numbering pattern with Koha? (FYI, the serial is "Nature".) Many thanks and best regards, Giuseppe.

1 0

errors, migrating from 3.10.04 to 3.14.04
by Jürgen Eichenbrenner 11 Apr '14

11 Apr '14

Hello, upgrading from a manually installed 3.10 Koha to a latest stable Koha Debian packages on a new server, I'm facing the following errors, when I run the upgrading database script via: $ sudo koha-upgrade-schema Is it necessary to upgrade in two steps instead, first from 3.10 to 3.12, followed by 3.12 to 3.14? Or do I anyway need to correct all errors manually, by creating missing tables (like the table „koha_INSTANCENAME.borrower_debarments“) which the script updatedatabase.pl fails to create ? Any hints and tips are highly appreciated! Thanks, Jürgen, Stuttgart $ sudo koha-upgrade-schema DBD::mysql::db do failed: Can't create table 'koha_koha3.borrower_attribute_types_branches' (errno: 150) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6118. DBD::mysql::db do failed: Can't create table 'koha_koha3.categories_branches' (errno: 150) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6120. DBD::mysql::db do failed: Can't create table 'koha_koha3.authorised_values_branches' (errno: 150) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6122. [...] DBD::mysql::db do failed: Duplicate entry 'OPACNumbersPreferPhrase' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6404. DBD::mysql::db do failed: Duplicate entry 'IntranetNumbersPreferPhrase' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6405. Upgrade to 3.11.00.018 done (Bug 9395: Problem with callnumber and standard number search in OPAC and Staff Client) DBD::mysql::db do failed: Duplicate entry 'UNIMARCAuthorityField100' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6412. [...] DBD::mysql::db do failed: Duplicate key name 'batch_id_record_type' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6481. [...] DBD::mysql::db do failed: Can't create table 'koha_koha3.#sql-6d24_e0' (errno: 150) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6877. DBD::mysql::db do failed: Can't create table 'koha_koha3.#sql-6d24_e0' (errno: 150) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6899. [...] DBD::mysql::db do failed: Can't create table 'koha_koha3.aqorders_transfers' (errno: 150) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 7110. [...] DBD::mysql::db do failed: Can't create table 'koha_koha3.#sql-6d24_e0' (errno: 150) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 7277. DBD::mysql::db do failed: Can't create table 'koha_koha3.#sql-6d24_e0' (errno: 150) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 7293. [...] DBD::mysql::db do failed: Can't create table 'koha_koha3.borrower_debarments' (errno: 150) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 7599. DBD::mysql::db do failed: Table 'koha_koha3.borrower_debarments' doesn't exist at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 7616. [...] DBD::mysql::db do failed: Can't create table 'koha_koha3.aqbasketusers' (errno: 150) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 7670.

2 2

Summary of the 9 April 2014 general IRC meeting
by Galen Charlton 10 Apr '14

10 Apr '14

Hi, A general meeting was held yesterday in two parts, at 15:00 UTC and 21:00 UTC. Here is a summary of decisions made during the meeting: [1] The next general meeting will be held on 7 May 2014, at 15:00 UTC and 22:00 UTC. [2] The next developer meeting will be held on 23 April 2014, at 15:00 UTC and 22:00 UTC. The formal vote for project roles for 3.18 will take place then. [3] Thomas Dukleth has agreed to issue the call for sites for the 2015 conference, and will do so some time in May. Here are action items from the meeting: [1] Sending a query to koha-devel soliciting the nomination of release maintainers for 3.12.x (and earlier) and starting a discussion about support policy for older releases -- DONE [2] Starting a discussion thread on the module maintainer concept on koha-devel -- DONE Here are ideas proposed during the meeting: [1] After the release of the beta, highlighting the availability of sandboxes and testing environments to encourage broader testing of the beta. [2] The release manageror similar to declare "I am particularly keen to see the following list fixed by anyone", i.e., to put a highlight on long-standing bugs to be fixed or patches to be rescued. Here are links to the minutes and logs: Minutes ------------ Part 1: http://meetings.koha-community.org/2014/general_meeting__9_april_2014__part… Part 2: http://meetings.koha-community.org/2014/general_meeting__9_april_2014__part… Logs -------- Part 1: http://meetings.koha-community.org/2014/general_meeting__9_april_2014__part… Part 2: http://meetings.koha-community.org/2014/general_meeting__9_april_2014__part… Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: gmc(a)esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org

1 0

On syspar.par in Koha
by zolot 10 Apr '14

10 Apr '14

Greetings, Which Koha-file is an analogue of the syspar.par file from the package "CDS/ISIS for Windows" ? Regards, Gennady

3 2