Version 2 (modified by Dan Scott, 14 years ago) (diff)


Adding a MFHD record to a bibliographic record

Assuming that your cataloguers are willing to create brand new 853 and 863 fields, the following approach will generate a stub MFHD record for them:

  1. Start by finding the record ID for the bibliographic record
  2. Then issue the following SQL (substituting the record ID and owning library ID in the appropriate spots):
    INSERT INTO serial.record_entry (record, marc, last_xact_id, owning_lib)
    VALUES (859846,  '<record xsi:schemaLocation="" 
      <leader>00263cy  a22000974  4500</leader> 
      <controlfield tag="001">40640</controlfield>
      <controlfield tag="005">20090714132854.0</controlfield>
      <controlfield tag="008">040712                eng 080109</controlfield>
      <datafield tag="852" ind1=" " ind2=" ">
        <subfield code="b">DESMARAIS</subfield>
        <subfield code="c">Periodicals</subfield>
      <datafield tag="866" ind1=" " ind2=" ">
        <subfield code="a">PLACEHOLDER</subfield>
    </record>', 'foo', 103);