[Remediation] Mass replace URIs by field

[sseymore]

Mass replace URIs by field.

• Metadata folks check each URI in UO_label_remediation sheet.
• Once done, if there are any mass replace remediation actions needed, create a spreadsheet with old URIs in first column and the replacement URI in the second column.
• Put that sheet here for Linda.
• Check box next to field under Ready for Linda and notify her in a comment.
• See local_collection_name for example.
• Once Linda is done, check the box under Remediated by Linda.

Ready for Linda:

• local collection name
• repository
• publisher
• worktype
• style period
• subject
• photographer
• donor
• author
• contributor
• creator

Remediated by Linda:

• local collection name
• repository
• publisher
• worktype
• style period
• subject
• photographer
• donor
• author
• contributor
• creator

[sseymore]

@lsat12357 local collection name is ready for remediation. thanks!

[lharka]

@lsat12357 worktype is ready for remediation. Thank you!

[jsimic]

@lsat12357 Ready for mass replace: photographer, donor, author, contributor, creator. There is nothing for lyricist, interviewee or composer, so I am removing those from the checklists

[lsat12357]

Can you please check to make sure that you are using the correct form of the terms? eg, the authors list is using https rather than http for opaquenamespace

[jsimic]

@lsat12357 Done

[lharka]

style period and work type are ready for mass remediation. note: for subject, there are 2 spreadsheets in the "ready_for_Linda" google drive folder. 1 is mass replace (replaceURIs_style_period), 2 is mass removal with no replacement (removeURIs_subject).

Also, I'm unchecking tgn, ethnographic term, and military branch in the "Ready for Linda" section above. The spreadsheets for these terms are ones that I was able to correct and finish without needing any additional mass remediation steps (so these terms are complete, with no need for further work on Linda's end). Just unchecking them for the sake of clarity.

Please let me know if you have any questions, thank you!

[sseymore]

@lsat12357 repository is ready for mass replace URIs. Thank you.

[sseymore]

Edited to remove tgn, ethno term, military branch, recipient, and collector since all corrected by hand. Trying to finish publisher ASAP.

[sseymore]

There is actually no mass replacements needed for publisher, so also marked that complete.

[lsat12357]

re replaceURIs_repository.xlsx
I noticed that towards the end, there are a few replacement uris that have special chars in them, for instance http://opaquenamespace.org/ns/repository/MuséedArtContemporainMontreal
so I tried replacing the é with a regular e, but it still does not resolve. how do you want to proceed? If you want me to run them anyway, I can.

[sseymore]

I thought I got them all. I checked again and corrected these:

http://opaquenamespace.org/ns/repository/ChâteauMuséeBoulogna
http://opaquenamespace.org/ns/repository/MuséeLapidaireVienne
http://opaquenamespace.org/ns/repository/MuséedArtContemporainMontreal

I added these to the URIs that need to be created in opns. Sorry about that.