Hi, Erin-- I'd like to second Sami's recommendation. The need to take an existing spreadsheet of information and look up which Getty Vocabulary term matches is very common, and what we've found is that OpenRefine is the best tool for doing that, which is why we've worked to provide integration points for the Getty Vocabularies there.
The URL for the service is http://services.getty.edu/vocab/reconcile, which is the URL you would link to within OpenRefine to add the integration point. For a more useful tutorial on how to use it, https://www.getty.edu/research/tools/vocabularies/obtain/openrefine_tutorial.pdf contains step-by-step instructions. Please let me know if those instructions don't make sense--we're still trying to figure out how best to describe the tool and help people use it, and we'd welcome feedback as we work to improve the documentation. — David David Newbury Enterprise Software Architect, Getty Digital Email: dnewb...@getty.edu Phone: (310) 440-6116 On 8/16/19, 10:37 AM, "mcn-l on behalf of Sami Norling" <mcn-l-boun...@mcn.edu on behalf of sami.norl...@gmail.com> wrote: Hi Erin, I would highly recommend using OpenRefine <http://openrefine.org>'s reconciliation service to reconcile the museum's data with ULAN entities. Once reconciled in OpenRefine, you can then enrich the museum's existing data with any of the data points available in ULAN. I am going through this process with the Indianapolis Museum of Art data to better support our linked data initiatives as well as to ensure that our data is as complete as it can be. As an added step, I would also suggest that when you are done with the reconciliation work, you contact the Getty vocabularies team to inquire about contributing information about artists not currently in ULAN to their data set. My understanding is that they are very encouraging of such contributions. Please consider this e-mail a super basic overview, and feel free to contact me directly for more specific information about how to use OpenRefine and their reconciliation services for your project. I'm more than happy to help! *Samantha Norling* Digital Collections Manager *Newfields Lab* – Technology for Nature & the Arts -------------------------------------------- *Newfields* 4000 Michigan Road Indianapolis, IN 46208 -------------------------------------------- snorl...@discovernewfields.org On Fri, Aug 16, 2019 at 10:20 AM Erin Richardson < e...@erinrichardsonconsulting.com> wrote: > Hi wise MCN-L members! > > I am working with a museum to clean up their data. I don't have a lot of > backend data experience. My task is to populate artist records with ULAN > data. They're using EmbARK. I'd like to upload the relevant metadata using > the ULAN ID as a link. I'm having difficulty accessing the ULAN data from > getty's download center. > https://www.getty.edu/research/tools/vocabularies/obtain/download.html > > Note: I know next to nothing about data that is not in CSV format. I've > tried to convert the sample ULAN XML data to CSV but am getting lots of > errors. > > I don't even really understand the reasonable-ness of this question, so > please bear with me! > > Thanks for any help you're able to offer! > > Erin > > _____________ > > Erin Richardson, PhD, Principal > > Erin Richardson Consulting <https://www.erinrichardsonconsulting.com/> > > 518.577.0186 > > LinkedIn <https://www.linkedin.com/in/erinerichardson/> > _______________________________________________ > You are currently subscribed to mcn-l, the listserv of the Museum Computer > Network (http://www.mcn.edu) > > To post to this list, send messages to: mcn-l@mcn.edu > > To unsubscribe or change mcn-l delivery options visit: > http://mcn.edu/mailman/listinfo/mcn-l > > The MCN-L archives can be found at: > http://www.mail-archive.com/mcn-l@mcn.edu/ > _______________________________________________ You are currently subscribed to mcn-l, the listserv of the Museum Computer Network (http://www.mcn.edu) To post to this list, send messages to: mcn-l@mcn.edu To unsubscribe or change mcn-l delivery options visit: http://mcn.edu/mailman/listinfo/mcn-l The MCN-L archives can be found at: http://www.mail-archive.com/mcn-l@mcn.edu/ CAUTION: This email originated from outside of the Getty. Do not click links or open attachments unless you verify the sender and know the content is safe. _______________________________________________ You are currently subscribed to mcn-l, the listserv of the Museum Computer Network (http://www.mcn.edu) To post to this list, send messages to: mcn-l@mcn.edu To unsubscribe or change mcn-l delivery options visit: http://mcn.edu/mailman/listinfo/mcn-l The MCN-L archives can be found at: http://www.mail-archive.com/mcn-l@mcn.edu/