<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Ah, ok...well..then that might be easier to do just in the database if you want to delete all your rights statments.</p>
<p><br>
</p>
<p>Can you issue this MySQL command :</p>
<p>delete from rights_statement;</p>
<p><br>
</p>
<p>Then delete the data/indexer_state folder to trigger a reindex. This should remove all your rights statements.
<br>
</p>
<p><br>
</p>
<p><br>
</p>
<p>b,chris. <br>
</p>
<p><br>
</p>
<div id="Signature">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:; margin:0">
<div class="BodyFragment"><font size="2">
<div class="PlainText">Chris Fitzpatrick | <font size="2">Developer, ArchivesSpace</font><br>
Skype: chrisfitzpat  | Phone: 918.236.6048<br>
http://archivesspace.org/<br>
</div>
</font></div>
</div>
</div>
<div style="word-wrap: break-word; color: rgb(0, 0, 0);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Callahan, Maureen
 <maureen.callahan@yale.edu><br>
<b>Sent:</b> Friday, June 5, 2015 2:47 PM<br>
<b>To:</b> Archivesspace Users Group<br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] data problem with the migrator</font>
<div> </div>
</div>
<div>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>
<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="http://archivesspace.org/" 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="" style="font-size:11pt" face="Calibri, sans-serif"><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>
 <<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"><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>
</body>
</html>