[Remediation] Mass replace URIs by field

OregonDigital / oregondigital

OregonDigital Hydra Application

https://oregondigital.org/catalog/

Other

25 stars 5 forks source link

[Remediation] Mass replace URIs by field #1550

Open sseymore opened 2 years ago

sseymore commented 2 years ago

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:

[x] local collection name
[x] repository
[x] publisher
[x] worktype
[x] style period
[x] subject
[x] photographer
[x] donor
[x] author
[x] contributor
[x] creator

Remediated by Linda:

[x] local collection name
[x] repository
[x] publisher
[x] worktype
[x] style period
[x] subject
[x] photographer
[x] donor
[x] author
[x] contributor
[x] creator

sseymore commented 2 years ago

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

lharka commented 2 years ago

@lsat12357 worktype is ready for remediation. Thank you!

jsimic commented 2 years ago

@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 commented 2 years ago

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 commented 2 years ago

@lsat12357 Done

lharka commented 2 years ago

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 commented 2 years ago

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

sseymore commented 2 years ago

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

sseymore commented 2 years ago

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

lsat12357 commented 2 years ago

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 commented 2 years ago

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.