[Metadatalibrarians] OpenRefine LCSH reconciliation troubleshooting

Noah Geraci noah.geraci at ucr.edu
Thu Apr 26 11:57:15 PDT 2018


I've been successfully using Christina Harlow's lc-reconcile (https://github.com/cmh2166/lc-reconcile) for this for the past couple years (following the setup under "Run Locally Instructions"), which takes a different approach than the setup described in Free Your Metadata. It queries the id.loc.gov Suggest API and DidYouMean API, and doesn't use the RDF extension. I'm running it on Windows 7 with OpenRefine 2.7. 


Noah Geraci
Digital Assets Metadata Librarian
UCR Library
P.O. Box 5900
Orbach Library, Room G46
Riverside, CA 92517-5900
(951) 827-2814 | noah.geraci at ucr.edu  

-----Original Message-----
From: Metadatalibrarians [mailto:metadatalibrarians-bounces at lists.monarchos.com] On Behalf Of Casey Mullin
Sent: Thursday, April 26, 2018 11:24 AM
To: A listserv for Metadata Librarians <metadatalibrarians at lists.monarchos.com>
Subject: Re: [Metadatalibrarians] OpenRefine LCSH reconciliation troubleshooting


I used to have moderate success with the LCSH recon. service (as recently as several months ago), but the AAT service always gave me the wheel of death.

Good luck,


Casey A. Mullin

(pronouns: he/him/his)

Head of Cataloging and Metadata Services Western Washington University Libraries

Managing Partner
Flourish Music Metadata Solutions

Past Chair
Music OCLC Users Group

E-mail address for Flourish business: musicmetadatasolutions at gmail.com<mailto:musicmetadatasolutions at gmail.com>
E-mail address for all other business: casey at mullingroup.com<mailto:casey at mullingroup.com>

From: Metadatalibrarians <metadatalibrarians-bounces at lists.monarchos.com> on behalf of Amber Billey <abilley at bard.edu>
Sent: Thursday, April 26, 2018 11:09 AM
To: metadatalibrarians at lists.monarchos.com
Subject: [Metadatalibrarians] OpenRefine LCSH reconciliation troubleshooting

Hi Everyone,

I've recently had issues using trying to reconcile terms against LCSH using OpenRefine. I set up the reconciliation service following the instructions laid out on the Free Your Metadata site ( https://nam03.safelinks.protection.outlook.com/?url=http%3A%2F%2Ffreeyourmetadata.org%2Freconciliation%2F&data=02%7C01%7C%7Cfebdef5c82124307e44e08d5aba10223%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636603630363694810&sdata=wv6Yrfq1uArNVyPYuxYzr1uoQOne3%2FNJy45ShcdTrqk%3D&reserved=0). Then when I try to actually reconcile a column of terms using the reconciliation service that I set up, I just get a spinning wheel of death and the program freezes. No progress bar and no reconciliation.

I'm running OpenRefine 2.8

With the latest RDF Extension

I've tried running the reconciliation service on a PC running Windows 7 and Windows 10, and I've tried it on a Mac. Still the same spinning wheel and program freezing.

I used to be able to successfully run this reconciliation service, and munged much metadata using it. But for some reason it's not working anymore. Could it be the SPARQL endpoint?

Is anyone else having these issues?

Is anyone successfully using OpenRefine to reconcile against LCSH? If so, what SPARQL endpoint are you using?

Many thanks,

Amber Billey (she/her/hers)
Systems & Metadata Librarian
Bard College Libraries
1 Library Road
Annandale-on-Hudson, NY 12504
Metadatalibrarians mailing list
Metadatalibrarians at lists.monarchos.com
Metadatalibrarians mailing list
Metadatalibrarians at lists.monarchos.com

More information about the Metadatalibrarians mailing list