[Archivesspace_Users_Group] data problem with the migrator

Fri Jun 5 10:18:37 EDT 2015

I've removed all of the rights records that way in a test database, but I seem to remember that there were also some events records associated with the rights transferred "events" (but possibly not with all of the rights statements, which seemed odd).  At the point, I stopped looking at how to do this in MySQL, because I wasn't sure if there were other records and relationship tables that we also needed to touch in order to cleanly purge all references.  I can say, though, that just deleting those rights records didn't cause the application to malfunction in any way that I noticed.  Still, we want to make sure that we have as clean a database as possible!

Is there any easy way to tell, as Maureen asked, which tables need to be touched to remove all of the references to those rights records completely?

From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of Callahan, Maureen
Sent: Friday, June 05, 2015 10:02 AM
To: Archivesspace Users Group
Subject: Re: [Archivesspace_Users_Group] data problem with the migrator

I was feeling nervous about doing this in the database - are there any records that reference this rights statement record?

On Jun 5, 2015, at 9:53 AM, Chris Fitzpatrick <Chris.Fitzpatrick at lyrasis.org<mailto:Chris.Fitzpatrick at lyrasis.org>> wrote:

Ah, ok...well..then that might be easier to do just in the database if you want to delete all your rights statments.

Can you issue this MySQL command :
delete from rights_statement;

Then delete the data/indexer_state folder to trigger a reindex. This should remove all your rights statements.

b,chris.

Chris Fitzpatrick | Developer, ArchivesSpace
Skype: chrisfitzpat  | Phone: 918.236.6048
http://archivesspace.org/<https://urldefense.proofpoint.com/v2/url?u=http-3A__archivesspace.org_&d=AwMF-g&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=s7ciGQfUJeaV_ryx908hbeXDoU9aqDwDN0Z0VbfsJ3Y&m=dgNRLSjVXdwOkTsq2Ku52FZkXiREGmdfLPkijumeeQE&s=h6OZPCHyTgO2bQY5m9Fp1G1GyawF5KnRyfRhEjdzrNc&e=>
________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> <archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org>> on behalf of Callahan, Maureen <maureen.callahan at yale.edu<mailto:maureen.callahan at yale.edu>>
Sent: Friday, June 5, 2015 2:47 PM
To: Archivesspace Users Group
Subject: Re: [Archivesspace_Users_Group] data problem with the migrator

Hi Chris,

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.

Thanks,
Maureen

On Jun 5, 2015, at 8:40 AM, Chris Fitzpatrick <Chris.Fitzpatrick at lyrasis.org<mailto:Chris.Fitzpatrick at lyrasis.org>> wrote:

Hi,

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.

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?

b,chris

Chris Fitzpatrick | Developer, ArchivesSpace
Skype: chrisfitzpat  | Phone: 918.236.6048
http://archivesspace.org/<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=>
________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> <archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org>> on behalf of Callahan, Maureen <maureen.callahan at yale.edu<mailto:maureen.callahan at yale.edu>>
Sent: Thursday, June 4, 2015 5:18 PM
To: Archivesspace Users Group
Subject: [Archivesspace_Users_Group] data problem with the migrator

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).

Here's what it looks like (attached, for those without in-line image viewing):

<Screen Shot 2015-06-04 at 11.10.32 AM.png>

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.

I'd like to request that the AT migrator be changed to something a little more modest.

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?

Thanks much,
Maureen
_______________________________________________
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:Archivesspace_Users_Group at lyralists.lyrasis.org>
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=

_______________________________________________
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:Archivesspace_Users_Group at lyralists.lyrasis.org>
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=

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150605/6d600c9f/attachment.html>