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-boun...@lists.katipo.co.nz] On Behalf Of koha-requ...@lists.katipo.co.nz Sent: Tuesday, April 15, 2014 2:00 AM To: koha@lists.katipo.co.nz Subject: Koha Digest, Vol 102, Issue 27 Send Koha mailing list submissions to koha@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-requ...@lists.katipo.co.nz You can reach the person managing the list at koha-ow...@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.sa...@regionhalland.se) 2. Where are subject headings ( field 650$a) stored in in Koha database (amutsik...@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.sa...@regionhalland.se> To: <koha@lists.katipo.co.nz> Subject: Re: [Koha] Possible APP development Message-ID: <7f90beb05d15bf4c972c39d71c96646903cf9...@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-boun...@lists.katipo.co.nz] F?r Robin Sheat Skickat: den 10 april 2014 02:12 Till: koha@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ Message: 2 Date: Mon, 14 Apr 2014 11:51:55 +0200 From: <amutsik...@uzlib.uz.ac.zw> To: <koha@lists.katipo.co.nz> Subject: [Koha] Where are subject headings ( field 650$a) stored in in Koha database Message-ID: <004501cf57c7$2bd791d0$8386b570$@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 <dudzikmic...@wp.pl> To: koha@lists.katipo.co.nz Subject: Re: [Koha] Where are subject headings ( field 650$a) stored in in Koha database Message-ID: <1397474718483-5794016.p...@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.mcmil...@stdc.govt.nz> To: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> Subject: Re: [Koha] Possible APP development Message-ID: <f080c0113cf5f741be2b9541ca30acda93d57...@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 <ro...@catalyst.net.nz> To: koha@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@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. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha