[Archivesspace_Users_Group] Container Checker

[Chris Fitzpatrick]

Hi Valerie,


Yeah, the approach I started down for this turned out to not be very consistent in identifying all the issues. I had to turn my attention to a couple of plugins that were needed and haven't been able to get back to restart this.


The best bet is to do the conversion on a backup and run the container_checker report, which will generate a CSV of pre- and post- conversion containers and show a diff.


If you want, I can run this report for you if you send me a dump of your mysql db.


b,chris.


Chris Fitzpatrick | Developer, ArchivesSpace
Skype: chrisfitzpat  | Phone: 918.236.6048
http://archivesspace.org/


________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Valerie Addonizio <vaddoniz at jhu.edu>
Sent: Tuesday, April 26, 2016 4:53 PM
To: Archivesspace Users Group
Subject: Re: [Archivesspace_Users_Group] Container Checker


Greetings. I'm picking this thread back up to ask about the pre-flight checker mentioned below:



I'm also working on something to do a pre-flight conversion check that will try and call out some potential issues with conversion, which I should have done in the next 24 hours or so.



Thanks!



From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of Chris Fitzpatrick
Sent: Monday, April 18, 2016 7:39 AM
To: Archivesspace Users Group
Subject: [Archivesspace_Users_Group] Container Checker



Hi,



I put together some SQL queries that might help some people verify their data post-container conversion.



Have a look at : https://github.com/archivesspace/container_checker



There's a few things here:



A SQL script<https://github.com/archivesspace/container_checker/blob/master/container.sql> to dump out a CSV file of all your containers and their associated resources/accessions/archival objects and locations.



Another SQL scrip<https://github.com/archivesspace/container_checker/blob/master/top_container.sql>t to pull out a CSV file of all you top_containers and their associated resources/accessions/archival objects and locations



A shell script<https://github.com/archivesspace/container_checker/blob/master/cc.sh> to run both the container and top_container SQL queries and diff them using the excellent Daff <https://github.com/paulfitz/daff> library and make a HTML table that shows the changes. ( script is linux only...sorry [&#X02639] )



In theory, the CSV files should be identical after conversion. In reality, this won't be the case since the data can change for a variety of reasons ( most of them beneficial ). However, you can get an overview of what's going on with this and look at it in the comfort of Excel or your preferred Excel alternative.



Please give a go and let us know what you think. If you don't feel capable, or are too busy, or your IT guy is too busy, you can email me an MySQL dump of your database ( zipped up, please ) and I can send you back csv files and html output.



I'm also working on something to do a pre-flight conversion check that will try and call out some potential issues with conversion, which I should have done in the next 24 hours or so.



Thanks and let us know what you think.



best, Chris.



















Chris Fitzpatrick | Developer, ArchivesSpace
Skype: chrisfitzpat  | Phone: 918.236.6048
http://archivesspace.org/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20160426/49403ea5/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 506 bytes
Desc: image001.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20160426/49403ea5/attachment.png>