[Archivesspace_Users_Group] splitting containers encoded as box:folder

[Majewski, Steven Dennis (sdm7g)]

We have thousands of archival_objects where container type_1 is encoded as “box:folder” ( with some variation of case and punctuation ) and with the value encoded in a similar manner ( i.e. “1:1” ) 

This was our normal encoding practice in EAD. I have since added code to our pre-import stylesheet to split these into separate container elements, but these records have already been imported previous to discovering this issue. 

It would seem easier to fix and split these values before doing the 1.5.1 migration. 
In test migrations, the result is separate top containers for all of the 
I’ve been exploring my options for doing this. 
Using the backend API would appear to be too difficult and time consuming, so I’m probably going to shutdown the servers and run the backend server from the console to run a script to convert all of the values. ( I suppose an alternative would be to do the updates directly from MySQL, but I’ve been advising others not to do this. And I probably feel more comfortable doing it in ruby thru the sequel GEM than directly in MySQL. And I don’t trust EAD roundtripping in ASpace enough to try to export/fix/import via EAD. ) 

Just wondering if anyone else has had to deal with a similar problem and how it was managed? 


— Steve Majewski