<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<div class="">I was feeling nervous about doing this in the database — are there any records that reference this rights statement record?</div>
<div class=""><br class="">
</div>
<br class="">
<div>
<blockquote type="cite" class="">
<div class="">On Jun 5, 2015, at 9:53 AM, Chris Fitzpatrick <<a href="mailto:Chris.Fitzpatrick@lyrasis.org" class="">Chris.Fitzpatrick@lyrasis.org</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div id="divtagdefaultwrapper" style="font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; font-size: 12pt; background-color: rgb(255, 255, 255); font-family: Calibri, Arial, Helvetica, sans-serif;" class="">
<div style="margin-top: 0px; margin-bottom: 0px;" class="">Ah, ok...well..then that might be easier to do just in the database if you want to delete all your rights statments.</div>
<div style="margin-top: 0px; margin-bottom: 0px;" class=""><br class="">
</div>
<div style="margin-top: 0px; margin-bottom: 0px;" class="">Can you issue this MySQL command :</div>
<div style="margin-top: 0px; margin-bottom: 0px;" class="">delete from rights_statement;</div>
<div style="margin-top: 0px; margin-bottom: 0px;" class=""><br class="">
</div>
<div style="margin-top: 0px; margin-bottom: 0px;" class="">Then delete the data/indexer_state folder to trigger a reindex. This should remove all your rights statements.<span class="Apple-converted-space"> </span><br class="">
</div>
<div style="margin-top: 0px; margin-bottom: 0px;" class=""><br class="">
</div>
<div style="margin-top: 0px; margin-bottom: 0px;" class=""><br class="">
</div>
<div style="margin-top: 0px; margin-bottom: 0px;" class="">b,chris.<span class="Apple-converted-space"> </span><br class="">
</div>
<div style="margin-top: 0px; margin-bottom: 0px;" class=""><br class="">
</div>
<div id="Signature" class="">
<div name="divtagdefaultwrapper" style="font-family: Calibri, Arial, Helvetica, sans-serif; margin: 0px;" class="">
<div class="BodyFragment"><font size="2" class="">Chris Fitzpatrick | Developer, ArchivesSpace<br class="">
Skype: chrisfitzpat | Phone: 918.236.6048<br class="">
<a href="http://archivesspace.org/" class="">http://archivesspace.org/</a><br class="">
</font></div>
</div>
</div>
<div style="word-wrap: break-word;" class="">
<hr tabindex="-1" style="display: inline-block; width: 608.578125px;" class="">
<div id="divRplyFwdMsg" dir="ltr" class=""><font face="Calibri, sans-serif" style="font-size: 11pt;" class=""><b class="">From:</b><span class="Apple-converted-space"> </span><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" class="">archivesspace_users_group-bounces@lyralists.lyrasis.org</a><span class="Apple-converted-space"> </span><<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" class="">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
on behalf of Callahan, Maureen <<a href="mailto:maureen.callahan@yale.edu" class="">maureen.callahan@yale.edu</a>><br class="">
<b class="">Sent:</b><span class="Apple-converted-space"> </span>Friday, June 5, 2015 2:47 PM<br class="">
<b class="">To:</b><span class="Apple-converted-space"> </span>Archivesspace Users Group<br class="">
<b class="">Subject:</b><span class="Apple-converted-space"> </span>Re: [Archivesspace_Users_Group] data problem with the migrator</font>
<div class=""> </div>
</div>
<div class="">Hi Chris,
<div class=""><br class="">
</div>
<div class="">That’s exactly right — I’d like to remove “copyrighted” rights statements. And actually, at this point, these are the only rights subrecords that we have, so I’d be fine with a method of safely removing them all.</div>
<div class=""><br class="">
</div>
<div class="">Thanks,</div>
<div class="">Maureen</div>
<div class=""><br class="">
<div class="">
<blockquote type="cite" class="">
<div class="">On Jun 5, 2015, at 8:40 AM, Chris Fitzpatrick <<a href="mailto:Chris.Fitzpatrick@lyrasis.org" class="">Chris.Fitzpatrick@lyrasis.org</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div id="divtagdefaultwrapper" class="" style="font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; font-size: 12pt; background-color: rgb(255, 255, 255); font-family: Calibri, Arial, Helvetica, sans-serif;">
<div class="" style="margin-top: 0px; margin-bottom: 0px;">Hi,<span class="Apple-converted-space"> </span></div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><br class="">
</div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;">Yes, so since RightsStatements aren't "first class" type objects ( they can only exists as associations to resources, archival objects, accessions, etc ), there's not an endpoint directly for them.
To remove them, you have to go through the accession/resource/archival object/etc and update that record.<br class="">
</div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><br class="">
</div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;">Are you wanting to delete all "Copyrighted" rights statements? Or is there some kind of filter/qualifier we can use to limit which records should be deleted?</div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><br class="">
</div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;">b,chris<span class="Apple-converted-space"> </span><br class="">
</div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><br class="">
</div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><br class="">
</div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><br class="">
</div>
<div id="Signature" class="">
<div name="divtagdefaultwrapper" class="" style="font-family: Calibri, Arial, Helvetica, sans-serif; margin: 0px;">
<div class="BodyFragment"><font class="" size="2">Chris Fitzpatrick | Developer, ArchivesSpace<br class="">
Skype: chrisfitzpat | Phone: 918.236.6048<br class="">
<a id="LPNoLP" href="https://urldefense.proofpoint.com/v2/url?u=http-3A__archivesspace.org_&d=AwMFAw&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=JgH2YCQ8D3P9-Lm_x4bv3d2CZBYlbx6hxnLFHtfovi8&m=yhB_IuG0lFqIZvLEo9eb0m6KsaX9hg-1UF-kd7nykes&s=nVYFaB6_zgCetArpEUAMo4EPNaG5QlFbWUoV9CXHgJ0&e=" class="">http://archivesspace.org/</a><br class="">
</font></div>
</div>
</div>
<div class="" style="word-wrap: break-word;">
<hr tabindex="-1" class="" style="display: inline-block; width: 608.578125px;">
<div id="divRplyFwdMsg" dir="ltr" class=""><font class="" face="Calibri, sans-serif" style="font-size: 11pt;"><b class="">From:</b><span class="Apple-converted-space"> </span><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" class="">archivesspace_users_group-bounces@lyralists.lyrasis.org</a><span class="Apple-converted-space"> </span><<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" class="">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
on behalf of Callahan, Maureen <<a href="mailto:maureen.callahan@yale.edu" class="">maureen.callahan@yale.edu</a>><br class="">
<b class="">Sent:</b><span class="Apple-converted-space"> </span>Thursday, June 4, 2015 5:18 PM<br class="">
<b class="">To:</b><span class="Apple-converted-space"> </span>Archivesspace Users Group<br class="">
<b class="">Subject:</b><span class="Apple-converted-space"> </span>[Archivesspace_Users_Group] data problem with the migrator</font>
<div class=""> </div>
</div>
<div class="">Something for ALL users going into ASpace from AT to be aware of — the AT migrator creates a rights record in ArchivesSpace if the “Rights Transferred” box is checked in AT. (As I mentioned last month, it only brings over the rights transferred
note if this box is checked, which is a different kind of problem).
<div class=""><br class="">
</div>
<div class="">Here’s what it looks like (attached, for those without in-line image viewing):</div>
<div class=""><br class="">
</div>
<div class=""><span id="cid:73B6380F-4D1E-4339-98A5-C0680A19BC3B@its.yale.internal" class=""><Screen Shot 2015-06-04 at 11.10.32 AM.png></span></div>
<div class=""><br class="">
</div>
<div class="">Guys, I’m sorry, but there are a ton of terrible assumptions here based on the presence of a clicked checkbox. Just because rights were transferred doesn’t mean that COPYRIGHT was transferred (copyright could be transferred to the public domain,
for instance), it doesn’t mean that the copyright is still active, and I also wouldn’t assume that the jurisdiction is the United States.</div>
<div class=""><br class="">
</div>
<div class="">I’d like to request that the AT migrator be changed to something a little more modest.</div>
<div class=""><br class="">
</div>
<div class="">We’ve been working very hard at Yale to get our rights documentation in order and we’d like to keep this in ASpace. This means that I need to delete these often-erroneous rights records.I don’t see anything in the API documentation about deleting
rights records — could you give me some guidance about the safest way to do so?</div>
<div class=""><br class="">
</div>
<div class="">Thanks much,</div>
<div class="">Maureen</div>
</div>
</div>
</div>
<span class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; float: none; display: inline !important;">_______________________________________________</span><br class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<span class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; float: none; display: inline !important;">Archivesspace_Users_Group
mailing list</span><br class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=AwICAg&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=JgH2YCQ8D3P9-Lm_x4bv3d2CZBYlbx6hxnLFHtfovi8&m=FJwl3qOY7mLp1msQxtIhmIJM49u0T2Sb3QXjMz64OMc&s=_tminwi8Mr0YhmNlV-j5YD26BMrVvYNckJURSGrF8jU&e=" class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=AwICAg&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=JgH2YCQ8D3P9-Lm_x4bv3d2CZBYlbx6hxnLFHtfovi8&m=FJwl3qOY7mLp1msQxtIhmIJM49u0T2Sb3QXjMz64OMc&s=_tminwi8Mr0YhmNlV-j5YD26BMrVvYNckJURSGrF8jU&e=</a><span class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; float: none; display: inline !important;"></span></div>
</blockquote>
</div>
<br class="">
</div>
</div>
</div>
</div>
<span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">_______________________________________________</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">Archivesspace_Users_Group
mailing list</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=AwICAg&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=JgH2YCQ8D3P9-Lm_x4bv3d2CZBYlbx6hxnLFHtfovi8&m=yhB_IuG0lFqIZvLEo9eb0m6KsaX9hg-1UF-kd7nykes&s=el-hzK47sspYBmCRnUcs_cZbKWLet3kIwNqor9VcFes&e=" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=AwICAg&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=JgH2YCQ8D3P9-Lm_x4bv3d2CZBYlbx6hxnLFHtfovi8&m=yhB_IuG0lFqIZvLEo9eb0m6KsaX9hg-1UF-kd7nykes&s=el-hzK47sspYBmCRnUcs_cZbKWLet3kIwNqor9VcFes&e=</a><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class=""> </span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
</div>
</blockquote>
</div>
<br class="">
</body>
</html>