Logo for devconnect-events

Virtual community series
Starting April 2025

A Lighter Burden of Proof: SQLite and Pymarc to Perform Proofing and Statistics for WMS Catalogers

Published on ‎18-Mar-2025 08:37 AM by OCLC staff · Community manager | Updated on ‎1-Apr-2025 12:21 PM

In response to organizational restructuring, West Virginia University's Metadata Unit streamlined quality control workflows for a more distributed team of cataloging staff by running python scripts on raw MARC delivered by a query collection. The scripts deliver a count of each cataloger's new and edited bibliographic and holdings records, and provide a selection of fields relevant to their current projects in a spreadsheet that can be easily reviewed and used to assign manual corrections. API calls to execute corrections could also be integrated easily into these scripts. I will provide line by line explanation of code, which uses pandas, pymarc, and SQLite in a Google Colab environment on data accessible to any WorldShare Management Services (WMS) subscriber, and I will reflect on how the scripts assisted with change management during a large, organizational transition.
 


Featured Guests
Community Member


Start:
Thu, Apr 10, 2025 11:00 AM EDT
End:
Thu, Apr 10, 2025 12:00 PM EDT
2 Comments
PatrickFiset
Community Member

Hello, I missed the event. 

Will it be available to watch later ? 

Thank you

Carly_DiVito-OCLC
OCLC staff · Community manager
OCLC staff · Community manager

Hello, 

This session was recorded and can now be viewed on the DevConnect Recordings board. 

Thank you!
Carly DiVito
OCLC Community Manager