Re: [MCN-L] Assistance needed with ULAN data

2019-08-16 Thread Shyam Oberoi
"My network team took it away because they believe open source is generally not 
secure."

That's insane, the product was developed by Google!

https://en.wikipedia.org/wiki/OpenRefine


Shyam Oberoi
Chief Digital Officer
Royal Ontario Museum
O: 416-586-7935
E: sobe...@rom.on.ca



-Original Message-
From: mcn-l  On Behalf Of Nancy Hoffman
Sent: Friday, August 16, 2019 2:48 PM
To: Museum Computer Network Listserv 
Subject: Re: [MCN-L] Assistance needed with ULAN data

Hi Samantha -

I have a question related to your answer for Erin. Do you know of a program 
other than OpenRefine that can fetch URIs from the Getty's reconciliation 
services? I have been using OpenRefine for AAT vocabulary terms in a data 
publishing project. My network team took it away because they believe open 
source is generally not secure.

Thanks!

-Nancy

Nancy Buck Hoffman

Project Assistant

Archaeology Collections

Kellogg Center

Minnesota Historical Society

Saint Paul, MN  55102

612-725-2371


On Fri, Aug 16, 2019 at 12:40 PM Sami Norling 
wrote:

> Hi Erin,
>
> I would highly recommend using OpenRefine '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.ht
> > ml
> >
> > 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
> > 
> >
> > 518.577.0186
> >
> > LinkedIn 
> > ___
> > 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/
>
___
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/
ON NOW
Treasures of a Desert Kingdom: The Royal Arts of Jodhpur, 
India
In the Age of Rembrandt: Dutch Paintings from the Museum of Fine Arts, 

Re: [MCN-L] Assistance needed with ULAN data

2019-08-16 Thread Erin Richardson
Thank you so much, everyone! I discovered a love of data during the PhD
program I completed last year - I feel like it's late to discover the
analytical side of my brain mid-career. As such, I'm definitely a novice,
but recognized immediately that many museums are just terrible about data
as a general concept so I try to put on the data hat every time I sign on
with a new project to understand how we can work toward letting data help
us be more efficient in cataloging. Thank you, Getty (and David, in
particular) for creating this tool. I'll let you know how it goes with this
project! I think i might be a representative of the target market for
OpenRefine (someone who kind of knows what they're doing - or at least
knows what should be possible, but nothing about the architecture required
to make it work), so I'll make careful notes about my experience with the
tutorial.

Again, Thank you!

Erin

_

Erin Richardson, PhD, Principal

Erin Richardson Consulting 

518.577.0186

LinkedIn 


On Fri, Aug 16, 2019 at 3:07 PM David Newbury  wrote:

> 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 '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 

Re: [MCN-L] Assistance needed with ULAN data

2019-08-16 Thread David Newbury
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"  wrote:

Hi Erin,

I would highly recommend using OpenRefine '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 
>
> 518.577.0186
>
> LinkedIn 
> ___
> 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:

Re: [MCN-L] Assistance needed with ULAN data

2019-08-16 Thread Nancy Hoffman
Hi Samantha -

I have a question related to your answer for Erin. Do you know of a program
other than OpenRefine that can fetch URIs from the Getty's reconciliation
services? I have been using OpenRefine for AAT vocabulary terms in a data
publishing project. My network team took it away because they believe open
source is generally not secure.

Thanks!

-Nancy

Nancy Buck Hoffman

Project Assistant

Archaeology Collections

Kellogg Center

Minnesota Historical Society

Saint Paul, MN  55102

612-725-2371


On Fri, Aug 16, 2019 at 12:40 PM Sami Norling 
wrote:

> Hi Erin,
>
> I would highly recommend using OpenRefine '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 
> >
> > 518.577.0186
> >
> > LinkedIn 
> > ___
> > 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/
>
___
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/


Re: [MCN-L] Assistance needed with ULAN data

2019-08-16 Thread Sami Norling
Hi Erin,

I would highly recommend using OpenRefine '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 
>
> 518.577.0186
>
> LinkedIn 
> ___
> 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/


[MCN-L] Assistance needed with ULAN data

2019-08-16 Thread Erin Richardson
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 

518.577.0186

LinkedIn 
___
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/