[OPEN-ILS-DEV] Error on editing MARC record

Lindsay Wicomb lindsay.wicomb at bdsolutions.co.za
Mon Nov 10 01:43:05 EST 2008 

Hi.

After the running SQL script as per Mike's instructions, the following
output was given:


evergreen=# select marc from biblio.record_entry where id > -1 LIMIT 1;
 
marc

----------------------------------------------------------------------------
----
----------------------------------------------------------------------------
----
----------------------------------------------------------------------------
----
------------------------
 <marc:record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http:
//www.loc.gov/MARC21/slim" xmlns:marc="http://www.loc.gov/MARC21/slim"
xsi:schem
aLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/
standards/marcxml/
schema/MARC21slim.xsd">
  <leader>01046cam  2200325 a 4500</leader>
  <controlfield tag="001">2880418</controlfield>
  <controlfield tag="005">20080924142011.0</controlfield>
  <controlfield tag="008">861120s1987    nyu           000 1
eng</controlfield>
  <datafield tag="035" ind1=" " ind2=" ">
    <subfield code="9">(DLC)   86042977</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">ocip</subfield>
    <subfield code="f">19</subfield>
    <subfield code="g">y-gencatlg</subfield>
  </datafield>
  <datafield tag="010" ind1=" " ind2=" ">
    <subfield code="a">86042977</subfield>
  </datafield>
  <datafield tag="020" ind1=" " ind2=" ">
    <subfield code="a">0394560302 :</subfield>
    <subfield code="c">$10.95</subfield>
  </datafield>
  <datafield tag="020" ind1=" " ind2=" ">
    <subfield code="a">0394753097 (pbk.) :</subfield>
    <subfield code="c">$7.95</subfield>
  </datafield>
  <datafield tag="040" ind1=" " ind2=" ">
    <subfield code="a">DLC</subfield>
    <subfield code="c">DLC</subfield>
    <subfield code="d">DLC</subfield>
    <subfield code="d">OCoLC</subfield>
  </datafield>
  <datafield tag="043" ind1=" " ind2=" ">
    <subfield code="a">f-sa---</subfield>
  </datafield>
  <datafield tag="050" ind1="0" ind2="0">
    <subfield code="a">PR9369.3.W53</subfield>
    <subfield code="b">Y6 1987</subfield>
  </datafield>
  <datafield tag="082" ind1="0" ind2="0">
    <subfield code="a">823</subfield>
    <subfield code="2">19</subfield>
  </datafield>
  <datafield tag="100" ind1="1" ind2=" ">
    <subfield code="a">Wicomb, Zo&#xEB;.</subfield>
  </datafield>
  <datafield tag="245" ind1="1" ind2="0">
    <subfield code="a">You can't get lost in Cape Town /</subfield>
    <subfield code="c">Zo&#xEB; Wicomb.</subfield>
  </datafield>
  <datafield tag="250" ind1=" " ind2=" ">
    <subfield code="a">1st American ed.</subfield>
  </datafield>
  <datafield tag="260" ind1=" " ind2=" ">
    <subfield code="a">New York :</subfield>
    <subfield code="b">Pantheon Books,</subfield>
    <subfield code="c">c1987.</subfield>
  </datafield>
  <datafield tag="300" ind1=" " ind2=" ">
    <subfield code="a">185 p. ;</subfield>
    <subfield code="c">21 cm.</subfield>
  </datafield>
  <datafield tag="440" ind1=" " ind2="2">
    <subfield code="a">A Pantheon modern writers original</subfield>
  </datafield>
  <datafield tag="650" ind1=" " ind2="0">
    <subfield code="a">Colored people (South Africa)</subfield>
    <subfield code="x">Fiction.</subfield>
  </datafield>
  <datafield tag="651" ind1=" " ind2="0">
    <subfield code="a">Cape Town (South Africa)</subfield>
    <subfield code="x">Fiction.</subfield>
  </datafield>
  <datafield tag="650" ind1=" " ind2="0">
    <subfield code="a">Young women</subfield>
    <subfield code="x">Fiction.</subfield>
  </datafield>
  <datafield tag="655" ind1=" " ind2="7">
    <subfield code="a">Psychological fiction.</subfield>
    <subfield code="2">lcsh</subfield>
  </datafield>
  <datafield tag="655" ind1=" " ind2="7">
    <subfield code="a">Feminist fiction.</subfield>
    <subfield code="2">lcsh</subfield>
  </datafield>
  <datafield tag="655" ind1=" " ind2="7">
    <subfield code="a">Bildungsromans.</subfield>
    <subfield code="2">gsafd</subfield>
  </datafield>
  <datafield tag="991" ind1=" " ind2=" ">
    <subfield code="b">c-GenColl</subfield>
    <subfield code="h">PR9369.3.W53</subfield>
    <subfield code="i">Y6 1987</subfield>
    <subfield code="t">Copy 1</subfield>
    <subfield code="w">BOOKS</subfield>
  </datafield>
</marc:record>
(1 row)

evergreen=#


Thanks.

-----Original Message-----
From: open-ils-dev-bounces at list.georgialibraries.org
[mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of Mike
Rylander
Sent: 07 November 2008 03:09 PM
To: Evergreen Development Discussion List
Subject: Re: [OPEN-ILS-DEV] Error on editing MARC record

On Fri, Nov 7, 2008 at 5:23 AM, Lindsay Wicomb
<lindsay.wicomb at bdsolutions.co.za> wrote:
>
>
> Hi Dan.
>
> I ran the SQL string and received the following output:
>
>  marc
> ------
>
> (1 row)
>
> Any suggestions regarding what other areas to look at in terms of the
> Evergreen system that might be causing this problem?


There is an intentionally "empty" record there, with an id of -1.
You'll want to use the SQL:

SELECT marc FROM biblio.record_entry WHERE id > -1 LIMIT 1;

--miker

>
> Thanks
>
>
>> This sounds vaguely familiar - I believe there were fixes for
>> MARC21XML namespaces and the like (with complications depending on the
>> underlying versions of libxml2 and the corresponding Perl modules for
>> XML handling) post-1.2.3.0. Can you extract a sample record from
>> biblio.record_entry and attach or paste it inline?
>
>> Issuing the following command in psql should do the trick:
>
>> SELECT marc FROM biblio.record_entry LIMIT 1;
>
>> Here's an example of MARC21XML from Evergreen trunk on Ubuntu Hardy
>> (snipped because this is enough to get an idea):
>
>> <record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>> xmlns="http://www.loc.gov/MARC21/slim"
>> xmlns:marc="http://www.loc.gov/MARC21/slim"
>> xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/
>> standards/marcxml/schema/MARC21slim.xsd">
>>  <leader>01181cjm  22002533a 4500</leader>
>>  <controlfield tag="001">13724622</controlfield>
>>  <controlfield tag="005">20081105193657.0</controlfield>
>>  <controlfield tag="007">sd fsngnnmmned</controlfield>
>>  <controlfield tag="008">040920s2002    xxuuun              > >
>> eng</controlfield>
>
>> --
>> Dan Scott
>> Laurentian University
>
>



-- 
Mike Rylander
 | VP, Research and Design
 | Equinox Software, Inc. / The Evergreen Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  miker at esilibrary.com
 | web:  http://www.esilibrary.com

More information about the Open-ils-dev mailing list