<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Segoe UI Emoji";
panose-1:2 11 5 2 4 2 4 2 2 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:189684511;
mso-list-type:hybrid;
mso-list-template-ids:-263667944 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l1
{mso-list-id:212429164;
mso-list-type:hybrid;
mso-list-template-ids:1453218950 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l1:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l1:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l1:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l1:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l1:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l1:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l1:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l2
{mso-list-id:1073819283;
mso-list-type:hybrid;
mso-list-template-ids:44876638 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l2:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l2:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l2:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l2:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l2:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l2:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l2:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l2:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l2:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l3
{mso-list-id:1499036932;
mso-list-type:hybrid;
mso-list-template-ids:-2046902254 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l3:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l3:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l3:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l3:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l3:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l3:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l3:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l3:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l3:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Lydia,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">No, we definitely did not lose any data like that. Any data that is already part of the record is posted back to the system as is, same as when you edit a record in the staff interface (i.e. if you change a title of a component, you don’t
lose any notes associated with that record once you hit “save”). <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The only thing that I recall right now that our approach did *<b>not</b>* account for is the fact that ArchivesSpace allows you to have multiple “current” locations for a single top container (e.g.
<a href="http://test.archivesspace.org/staff/top_containers/530">http://test.archivesspace.org/staff/top_containers/530</a>). So, I think that our approach linked to below would have to be updated if you wanted, for whatever reason, to retain multiple current
locations. I was hopeful that we could have one “current” and 0 to more “previous” locations, but if I recall correctly, when you have previous locations in ArchivesSpace, those need to be marked as “temporary”. So, right now, we just store one current location
and ignore the fact that the container could have been previously shelved elsewhere.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Mark<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org]
<b>On Behalf Of </b>Tang, Lydia<br>
<b>Sent:</b> Tuesday, 07 January, 2020 3:59 PM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Tools for batch updating locations in ArchivesSpace during a collections move<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt">Thanks for sending this, Mark! When you did this, did you lose container profile info? Just curious!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt">Lydia<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt"><o:p> </o:p></span></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:12.0pt;color:black">From: </span></b><span style="font-size:12.0pt;color:black"><<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
on behalf of "Custer, Mark" <<a href="mailto:mark.custer@yale.edu">mark.custer@yale.edu</a>><br>
<b>Reply-To: </b>Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Date: </b>Tuesday, January 7, 2020 at 3:57 PM<br>
<b>To: </b>Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject: </b>Re: [Archivesspace_Users_Group] Tools for batch updating locations in ArchivesSpace during a collections move<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal">Bo,<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Our approach was pretty similar to the approach that you linked to, in that the whole process is primarily broken down into three main steps:<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<ul style="margin-top:0in" type="disc">
<li class="MsoNormal" style="margin-left:0in;mso-list:l3 level1 lfo1">Extract and merge the data (in our case, primarily from ASpace and our ILS, Voyager)<o:p></o:p></li><li class="MsoNormal" style="margin-left:0in;mso-list:l3 level1 lfo1">Compare and prep the data in a spreadsheet format<o:p></o:p></li><li class="MsoNormal" style="margin-left:0in;mso-list:l3 level1 lfo1">Update ArchivesSpace with an edited version of that spreadsheet.<o:p></o:p></li></ul>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">So, here’s a snippet of a CSV file that we used, with information merged from ASpace and Voyager:
<a href="https://nam05.safelinks.protection.outlook.com/?url=https%3A%2F%2Furldefense.com%2Fv3%2F__https%3A%2Fgithub.com%2FYaleArchivesSpace%2Fdata_cleanup_workgroup%2Fblob%2Fmaster%2Ftop-container-updates%2Fpython-update-scripts%2FARTS-dev-test.csv__%3B!!HXCxUKc!ju-JUh9AVAy9fh2lHpSgwazI7JCwX68McfdrQ5vdxbUqppNCNXOcRMMVex8S7a983A%24&data=02%7C01%7Cmark.custer%40yale.edu%7Cd7a5a97b20334c10ea8908d793b46c1c%7Cdd8cbebb21394df8b4114e3e87abeb5c%7C0%7C0%7C637140275437273317&sdata=VOdaLptx2eOwU%2BmgyZ6Ie78jN6m%2BZA%2FR%2B4mUmWDLVDU%3D&reserved=0">
https://github.com/YaleArchivesSpace/data_cleanup_workgroup/blob/master/top-container-updates/python-update-scripts/ARTS-dev-test.csv</a>
<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Once we verified everything was up-to-date there (we also tested the barcode check digit and other potential errors), we ran a simple API update to update all of those top containers in ArchivesSpace, with a variation of this script:
<a href="https://nam05.safelinks.protection.outlook.com/?url=https%3A%2F%2Furldefense.com%2Fv3%2F__https%3A%2Fgithub.com%2FYaleArchivesSpace%2Fdata_cleanup_workgroup%2Fblob%2Fmaster%2Ftop-container-updates%2Fpython-update-scripts%2Ftop-container-update.py__%3B!!HXCxUKc!ju-JUh9AVAy9fh2lHpSgwazI7JCwX68McfdrQ5vdxbUqppNCNXOcRMMVex__E9D20Q%24&data=02%7C01%7Cmark.custer%40yale.edu%7Cd7a5a97b20334c10ea8908d793b46c1c%7Cdd8cbebb21394df8b4114e3e87abeb5c%7C0%7C0%7C637140275437283309&sdata=UPmdk7RzVNbz0g3wnm6wyqVuHVnLPjZCpUR7T8tonKQ%3D&reserved=0">
https://github.com/YaleArchivesSpace/data_cleanup_workgroup/blob/master/top-container-updates/python-update-scripts/top-container-update.py</a>
<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">In our case, we were only updating three different values in ArchivesSpace: the barcode, the location, and the start date for when the box was added to that location (if no value, it would just default to the date that the script was run).<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Updating the data in ArchivesSpace was the easy part (although it does take time when you have lots and lots of containers!), but you will definitely want to test things out a lot outside of a production system first. Doing everything
else is where it takes a lot more time and planning, I think.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Also, it’s been a while since I’ve looked at resources related to getting up to speed with ArchivesSpace and its API, but here are two that I don’t think will ever go out of style:<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<ul style="margin-top:0in" type="disc">
<li class="MsoNormal" style="margin-left:0in;mso-list:l1 level1 lfo2">Overview by Hudson Molonglo:
<a href="https://nam05.safelinks.protection.outlook.com/?url=https%3A%2F%2Furldefense.com%2Fv3%2F__https%3A%2Fwww.youtube.com%2Fplaylist%3Flist%3DPLJFitFaE9AY_DDlhl3Kq_vFeX27F1yt6I__%3B!!HXCxUKc!ju-JUh9AVAy9fh2lHpSgwazI7JCwX68McfdrQ5vdxbUqppNCNXOcRMMVex82KcywVQ%24&data=02%7C01%7Cmark.custer%40yale.edu%7Cd7a5a97b20334c10ea8908d793b46c1c%7Cdd8cbebb21394df8b4114e3e87abeb5c%7C0%7C0%7C637140275437293303&sdata=BpKt1DDgu7G4lD0nOcjv7rvN3K%2FxpNyR58%2Fxug9Ot9o%3D&reserved=0">
https://www.youtube.com/playlist?list=PLJFitFaE9AY_DDlhl3Kq_vFeX27F1yt6I</a> <o:p>
</o:p></li><li class="MsoNormal" style="margin-left:0in;mso-list:l1 level1 lfo2">ArchivesSpace API workshop developed by Valerie Addonizio and Lora Woodford: <a href="https://nam05.safelinks.protection.outlook.com/?url=https%3A%2F%2Furldefense.com%2Fv3%2F__https%3A%2Fgithub.com%2Farchivesspace%2Fapi-training__%3B!!HXCxUKc!ju-JUh9AVAy9fh2lHpSgwazI7JCwX68McfdrQ5vdxbUqppNCNXOcRMMVex_EGF8nGg%24&data=02%7C01%7Cmark.custer%40yale.edu%7Cd7a5a97b20334c10ea8908d793b46c1c%7Cdd8cbebb21394df8b4114e3e87abeb5c%7C0%7C0%7C637140275437293303&sdata=tzfchGwacXyL2OGoU1%2FfV5O63wRQjWQF1EqMbqsmAoI%3D&reserved=0">https://github.com/archivesspace/api-training</a><o:p></o:p></li></ul>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">I hope that helps,<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Mark<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">
archivesspace_users_group-bounces@lyralists.lyrasis.org</a> [<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org</a>]
<b>On Behalf Of </b>Bolton Kelly Doub<br>
<b>Sent:</b> Tuesday, 07 January, 2020 3:20 PM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Tools for batch updating locations in ArchivesSpace during a collections move<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D">Hi Mark,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D">Thank you so much for your feedback -- this is very helpful.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D">And yes, your observations re: where our barcodes exist are correct:</span><o:p></o:p></p>
<ul style="margin-top:0in" type="disc">
<li class="MsoNormal" style="color:#1F497D;margin-left:0in;mso-list:l0 level1 lfo3">
ArchivesSpace has all of our granular location info (room, row, range, shelf data), but no box barcodes<o:p></o:p></li><li class="MsoNormal" style="color:#1F497D;margin-left:0in;mso-list:l0 level1 lfo3">
Our ILS has the box barcodes, but much less specific location info (basically, there is one location code that covers the whole offsite storage facility that we are moving collections from)<o:p></o:p></li></ul>
<p class="MsoNormal"><span style="color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D">I think we will probably end up going with some variation of the processes that you describe in your three bulleted suggestions. I like the approach of batch creating new locations rather than trying to update
the existing locations. Regarding the use of the ArchivesSpace API to re-associate all of the containers to their new locations, do you have any resources, webinars, tutorials, github repositories, etc. that you could point us to that might help us start on
this process? I have seen some of the resources for batch editing barcodes in ArchivesSpace through the API <</span><a href="https://nam05.safelinks.protection.outlook.com/?url=https%3A%2F%2Furldefense.com%2Fv3%2F__https%3A%2Fnam05.safelinks.protection.outlook.com%2F%3Furl%3Dhttps*3A*2F*2Fwww2.archivists.org*2Fgroups*2Fresearch-libraries-section*2Fbatch-editing-barcodes-in-archivesspace-through-the-api%26data%3D02*7C01*7Cmark.custer*40yale.edu*7C0e82e960359b4b1ee3ea08d793af0f9d*7Cdd8cbebb21394df8b4114e3e87abeb5c*7C0*7C1*7C637140252400902448%26sdata%3DdRN9zZR7is*2F07r*2BaTjmdb2VAed0cXm4SegTVpeih8NM*3D%26reserved%3D0__%3BJSUlJSUlJSUlJSUlJSUlJSU!!HXCxUKc!ju-JUh9AVAy9fh2lHpSgwazI7JCwX68McfdrQ5vdxbUqppNCNXOcRMMVex9uzmN05A%24&data=02%7C01%7Cmark.custer%40yale.edu%7Cd7a5a97b20334c10ea8908d793b46c1c%7Cdd8cbebb21394df8b4114e3e87abeb5c%7C0%7C0%7C637140275437303305&sdata=1d52IDv9SX64QPzgNAcjIWs8Z4tGfqZEMIKbKzQp6z4%3D&reserved=0">https://www2.archivists.org/groups/research-libraries-section/batch-editing-barcodes-in-archivesspace-through-the-api</a><span style="color:#1F497D">>,</span>
<span style="color:#1F497D">but I’m not sure if these address the re-association of containers to new locations.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D">To your last point, we will need to keep all of the granular locations in ArchivesSpace because of the way we use Aeon in connection with ArchivesSpace to retrieve patron requests for archival material. Though
I agree with you that this project should serve as an opportunity to get all of the box barcodes into ArchivesSpace.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D">Thanks again for your help and please let us know about relevant API tools if you know of any.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D">Best,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D">Bo</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span><o:p></o:p></p>
<div>
<p class="MsoNormal"><i><span style="font-size:10.0pt;color:#1F497D">Bo Doub</span></i><o:p></o:p></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt;color:#1F497D">Archival Projects Librarian</span></i><o:p></o:p></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt;color:#1F497D">USC Libraries Special Collections</span></i><o:p></o:p></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt;color:#1F497D">Doheny Memorial Library, Room B22</span></i><o:p></o:p></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt;color:#1F497D"><a href="tel:213-740-8180"><span style="color:#1F497D">tel:213-740-8180</span></a></span></i><o:p></o:p></p>
</div>
<p class="MsoNormal"><span style="color:#1F497D"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">
archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
<b>On Behalf Of </b>Custer, Mark<br>
<b>Sent:</b> Tuesday, January 7, 2020 11:13 AM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Tools for batch updating locations in ArchivesSpace during a collections move<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Bo,<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">This sounds like a very tricky / fun project!<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Though I have not gone through the exact same scenario, I have gone through a process of matching containers in finding aids with item records in corresponding MARC records in an ILS. As with most problems of this type, I suspect that
you will find that there are a variety of data disagreements between the multiple systems (e.g. a finding aid that references 50 different boxes, whereas you might have 52 different item records for that same collection in your ILS) and sometimes none of them
agree with reality.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">It sounds like you have location data in ArchivesSpace, but no barcodes…. Is that right? If so, I’d probably suggest storing both the barcodes and the locations in ArchivesSpace, or barring that, just adding the location data to your ILS
and keeping the barcodes there. Better to have all of that data in one system, I’d think, rather than have it split. But, in my mind, since ArchivesSpace is what’s going to be describing the entire collection, in the long run it might be easier to have the
barcodes in ArchivesSpace, since you can’t just create a new top container record and *<b>not</b>* have it linked to description in your finding aid, whereas you certainly can add an item record to your ILS and not have that linked to any description in a
finding aid.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Anyhow, if your ultimate goal is to add all of this data to ArchivesSpace, I’d suggest:<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<ul style="margin-top:0in" type="disc">
<li class="MsoNormal" style="margin-left:0in;mso-list:l2 level1 lfo4">Creating <i>
new locations</i> for the new offsite facility rather than trying to batch update the existing locations (since there won’t be a one-to-one correspondence with the container associated with those locations);<o:p></o:p></li><li class="MsoNormal" style="margin-left:0in;mso-list:l2 level1 lfo4">Using the API to re-associate all of those containers with their new location;<o:p></o:p></li><li class="MsoNormal" style="margin-left:0in;mso-list:l2 level1 lfo4">Bonus: try to see if you can get those barcodes into ArchivesSpace, since at the very least trying that out will alert you to those cases where there’s a disagreement between what’s in both
systems (that said, you can’t rely on simple counts alone when making that comparison, since I’ve definitely stumbled across cases where the finding aid might have, say, boxes 1-3, and the ILS for that same collection has boxes 1-2 and something else, like,
oversized folder A… so both agree that there are 3 containers… and yet, in reality, there might be 4 containers: three boxes and an oversized folder labelled A<span style="font-family:"Segoe UI Emoji",sans-serif">😊</span>).<o:p></o:p></li></ul>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Last, is there another system aside from ArchivesSpace that keeps track of your offsite locations? I ask because you might not need to be so granular when creating locations in ArchivesSpace in that case. For instance, at Yale we have
a single location for an off-site location – in ASpace we just know that they are off site, and another systems keeps track exactly where that barcode is stored in that offsite facility. So, perhaps it’s just wishful thinking on my part, but I wonder if you
couldn’t just create a single location code in ArchivesSpace for the new offsite facility, and then update all of the top containers currently associated with the multiple locations from the current facility to the new one?
<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Mark<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">
archivesspace_users_group-bounces@lyralists.lyrasis.org</a> [<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org</a>]
<b>On Behalf Of </b>Bolton Kelly Doub<br>
<b>Sent:</b> Monday, 06 January, 2020 4:01 PM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> [Archivesspace_Users_Group] Tools for batch updating locations in ArchivesSpace during a collections move<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Hi All,<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">At the University of Southern California, we are preparing to move a high volume of archival collections (basically the contents of an entire offsite storage building) from one offsite facility to another. We are investigating tools and
methods for batch updating locations in ArchivesSpace to spare us from having to edit each location record’s building, room, row, range, shelf, etc. fields individually.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">One additional challenge to this task is that the capacity of each destination shelf in the new building will not necessarily match the capacity of the corresponding shelving in the old offsite storage building. In many cases, a set of
boxes that shared the same shelf in the old facility will be split up into different shelves in the new facility.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Most of the boxes that are moving have unique barcodes displayed on each box. Most of these boxes also already have locations in ArchivesSpace (with building, room, row, range, and shelf values applied at the box level). However, the box
barcodes are only documented in USC’s ILS system (Alma/Primo). The barcodes are not documented in our instance of ArchivesSpace.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Has anyone on this list worked through a collections move under similar conditions using ArchivesSpace? Do you know of any relevant plugins or ArchivesSpace API tools that we could use to batch change locations?<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Thank you in advance for any help or feedback.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Happy New Year,<o:p></o:p></p>
<p class="MsoNormal">Bo<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">Bo Doub</span></i><o:p></o:p></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">Archival Projects Librarian</span></i><o:p></o:p></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">USC Libraries Special Collections</span></i><o:p></o:p></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">University of Southern California</span></i><o:p></o:p></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">Doheny Memorial Library</span></i><o:p></o:p></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">3550 Trousdale Parkway, Room B22</span></i><o:p></o:p></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">Los Angeles, CA 90089-0189</span></i><o:p></o:p></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt"><a href="tel:213-740-8180"><span style="color:windowtext">tel:213-740-8180</span></a></span></i><o:p></o:p></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt"><a href="mailto:bdoub@usc.edu"><span style="color:windowtext">bdoub@usc.edu</span></a></span></i><o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</body>
</html>