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

Reply via email to