[Koha] [Cataloging] Notes from Cat-SIG, June 4, 2020
eb at efdss.org
Sat Jun 6 06:11:38 NZST 2020
I would just like to say, I wish we'd had this SIG back when we first
started using Koha! I was lucky to be able to spend an afternoon with a
Koha user who helped me understand some of the basics, and got me started,
but the knowledge base in this group is astounding.
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
On Thu, Jun 4, 2020 at 10:17 AM 'Hernandez, Heather H' via Cataloging
Special Interest Group <cataloging at koha-us.org> wrote:
> Hi, all--
> Our Koha-US Cataloging SIG meeting on June 4 was not recorded, but here
> are the notes from the meeting:
> Information on the Koha-US Cataloging SIG is here, open to everyone (you
> don't need to be a Koha-US member to join):
> MarcEdit and batch processes:
> The process in our May meeting for verifying & downloading authority
> records, recorded here https://youtu.be/J2WddLD41uQ , was correct.
> Subsequent testing has shown that sometimes you do get a file full of free
> authority records downloaded from the Library of Congress, but sometimes
> you don't--it seems that sometimes LC is responsive, sometimes it's not.
> Participants have found this also with batch searching/download of
> bibliographic records as well, but more testing is needed. The question
> was asked if LC throttles numbers of records at one time? We don't know at
> this point.
> MarcEdit is available here: https://marcedit.reeset.net/
> Fred played a short video of his use of MarcEdit to batch search and
> download records. If you're new to MarcEdit, there is a good "101 series"
> of videos here: https://marcedit.reeset.net/marcedit-101-workshop
> And Terry Reese (the MarcEdit developer) has posted a lot of updated
> how-to videos on his YouTube channel:
> Record templates:
> I created a page on the Koha wiki with a template for a "good enough"
> bibliographic record, with a link to download this record in MARC:
> It currently doesn't have a subject heading field, but I'll add that.
> I'll also add a link on the Koha wiki to the Library of Congress' MARC21
> page for those who would like to find out more about MARC.
> It was also mentioned that one library has a lot of template records in
> their Koha catalog and that they hide them.
> Elaine shared a link to a .pdf file that she created with tons of useful
> resources that includes many of the resources mentioned here, in addition
> to other great resources:
> Many of us viewed the ByWater video on setting up Z39.50 servers in Koha:
> This video mentions the IRSpy directory of Z39.50 targets--you can add
> your catalog to it, too:
> You can also find Z39.50 targets (and add your catalog) to the Koha wiki:
> Experiences with authority records and authorities workflows were
> shared--some libraries outsource this (one library uses Backstage Library
> Works), some do it in house. Thomas shared this link
> http://www.loc.gov/cds/products/marcDist.php to the MARC record
> distributing from the Library of Congress. Some libraries are cleaning up
> local authority files migrated into Koha from previous systems (and use
> reports available from the Koha wiki
> http://wiki.koha-community.org/wiki/SQL_Reports_Library and/or imported
> from Mana, a capability in later versions of Koha). ByWater did a video of
> how to add reports to the Koha wiki:
> And also did a video on editing reports from Mana:
> Some libraries are also working on correcting/updating headings in their
> bibliographic records. Sharing workflows is encouraged, especially for
> working remotely--we can share these workflows via email and/or in the
> Cataloging Training Resources area of the Koha wiki,
> https://wiki.koha-community.org/wiki/Training_resources#Cataloging ,
> and/or at our future Cataloging SIG meetings (which will be recorded).
> Some folks communicate additions/changes for headings/authority records to
> the Library of Congress; I often use this form to send them information on
> improving existing authority records:
> Resources for LC subject headings are here, including requesting new/added
> subject headings, and the "Approved Lists" which contain new and revised
> subject & genre headings: https://www.loc.gov/aba/cataloging/subject/
> Workflows related to these new/revised subject headings lists were
> discussed--small staffs/solo catalogers skim/read the new lists and keep an
> eye out for headings that would be useful for their materials, are possibly
> in their catalog, etc., then download the new or revised authority
> record(s) which overlay/update on the 010 field (usually) in Koha--linked
> headings in bibliographic records are updated, but if the heading is used
> and not linked (e.g., because of a subdivision), those have to be searched
> and then updated.
> Some libraries created authority records from scratch in databases,
> spreadsheets, etc., then used MarcEdit to convert those to MARC for import
> into Koha.
> Archival resources:
> Many of us have archival resources in our collections--some of them are
> cataloging into Koha, some are waiting to catalog their published materials
> before beginning on the archival resources. Some of these cataloging
> records are directly for the archives, archival resources, items,
> collections, even museum objects, some are bibliographic records for
> finding aids to the archival collections. Some bib records have links to
> online/digital versions. MarcEdit can be used to convert EAD finding aids
> to MARC records. Some also have user copies of archival resources in their
> Koha catalogs for, e.g., digitized versions of the archival resources, or
> even hardcopy photocopies of e.g. manuscripts & other resources in the
> Jason shared some SQL for reports that can be used to send the output
> hyperlinked into a spreadsheet!
> AS URL
> More on subject headings:
> The importance of subject headings in even the most minimal bibliographic
> records was discussed, even just one very general heading. It's common for
> users to need & want this. There is a useful report in the Koha wiki,
> "Bibs without subjects"--I edited it in my Koha catalog to include local
> subject headings (690 fields), to this:
> SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=
> AS bibnumber
> (SELECT biblionumber,
> ExtractValue(metadata,'//datafield[@tag="650"]/subfield[@code>="a"]') AS
> ExtractValue(metadata,'//datafield[@tag="651"]/subfield[@code>="a"]') AS
> ExtractValue(metadata,'//datafield[@tag="600"]/subfield[@code>="a"]') AS
> ExtractValue(metadata,'//datafield[@tag="610"]/subfield[@code>="a"]') AS
> ExtractValue(metadata,'//datafield[@tag="611"]/subfield[@code>="a"]') AS
> ExtractValue(metadata,'//datafield[@tag="630"]/subfield[@code>="a"]') AS
> ExtractValue(metadata,'//datafield[@tag="648"]/subfield[@code>="a"]') AS
> ExtractValue(metadata,'//datafield[@tag="653"]/subfield[@code>="a"]') AS
> ExtractValue(metadata,'//datafield[@tag="654"]/subfield[@code>="a"]') AS
> ExtractValue(metadata,'//datafield[@tag="655"]/subfield[@code>="a"]') AS
> ExtractValue(metadata,'//datafield[@tag="656"]/subfield[@code>="a"]') AS
> ExtractValue(metadata,'//datafield[@tag="657"]/subfield[@code>="a"]') AS
> ExtractValue(metadata,'//datafield[@tag="658"]/subfield[@code>="a"]') AS
> ExtractValue(metadata,'//datafield[@tag="662"]/subfield[@code>="a"]') AS
> ExtractValue(metadata,'//datafield[@tag="690"]/subfield[@code>="a"]') AS
> FROM biblio_metadata) AS subjects
> WHERE sub1 = ""
> AND sub2 = ""
> AND sub3 = ""
> AND sub4 = ""
> AND sub5 = ""
> AND sub6 = ""
> AND sub7 = ""
> AND sub8 = ""
> AND sub9 = ""
> AND sub10 = ""
> AND sub11 = ""
> AND sub12 = ""
> AND sub13 = ""
> AND sub14 = ""
> AND sub15 = ""
> It was a fun discussion! Our next meeting is Thursday, July 2 @ 8 am – 9
> am PT (9 MT/10 CT/11 ET in the United States), open to all, topic TBA, and
> we will return to recording the meeting and posting the recording for those
> who couldn't make it--detailed information on joining the meeting is on the
> Koha-US calendar here: http://koha-us.org/calendar/
> Let's document and share those cataloging & project workflows!
> Ms. Heather Hernandez (she, her, hers)
> Technical Services Librarian
> San Francisco Maritime National Historical Park Research Center
> 2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA 94123-1284
> 415-561-7032, heather_hernandez at nps.gov <https://webmail.lmi.net/src/compose.php?send_to=heather_hernandez%40nps.gov>
> Library catalog: http://keys.bywatersolutions.com/
> You received this message because you are subscribed to the Google Groups
> "Cataloging Special Interest Group" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to cataloging+unsubscribe at koha-us.org.
> To view this discussion on the web visit
More information about the Koha