<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
Hey Kris,<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
<br>
For this problem, you could either update the file URIs in bulk by directly editing the data in the database or use the API. If you have access to either, I would go with whichever you are more comfortable. Editing in the database would be the fastest, but
I would test any updates in a copy database first (either a local copy or a dev/staging instance you have). If you want to give the API a try (also testing in a copy instance), I would approach it by first creating a CSV or Excel file that lists the 100+ digital
objects you want to update (the Digital Object ArchivesSpace URI) and the new digital object file URI you want to replace the old one, like this:<br>
<br>
<table style="border-collapse:collapse;width:337pt" width="449">
<colgroup><col style="mso-width-source:userset;mso-width-alt:8704;width:179pt" width="238"><col style="mso-width-source:userset;mso-width-alt:7716;width:158pt" width="211"></colgroup>
<tbody>
<tr style="height:15.0pt" height="20">
<td style="padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 11pt; font-family: Calibri, sans-serif; vertical-align: bottom; border: 1px solid rgb(212, 212, 212); white-space: nowrap !important; height: 15pt; width: 179pt;" width="238" height="20">
/repositories/4/digital_objects/1</td>
<td class="xl65" style="padding-top: 1px; padding-right: 1px; padding-left: 1px; font-size: 11pt; font-family: Calibri, sans-serif; vertical-align: bottom; border: 1px solid rgb(212, 212, 212); white-space: nowrap !important; color: rgb(5, 99, 193); text-decoration: underline; width: 158pt;" width="211">
<a href="https://www.mynewfileuri.com/">https://www.mynewfileuri.com</a></td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 11pt; font-family: Calibri, sans-serif; vertical-align: bottom; border: 1px solid rgb(212, 212, 212); white-space: nowrap !important; height: 15pt;" height="20">
/repositories/4/digital_objects/2</td>
<td class="xl65" style="padding-top: 1px; padding-right: 1px; padding-left: 1px; font-size: 11pt; font-family: Calibri, sans-serif; vertical-align: bottom; border: 1px solid rgb(212, 212, 212); white-space: nowrap !important; color: rgb(5, 99, 193); text-decoration: underline;">
<a href="https://www.mynewfileuri.com/">https://www.mynewfileuri.com</a></td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 11pt; font-family: Calibri, sans-serif; vertical-align: bottom; border: 1px solid rgb(212, 212, 212); white-space: nowrap !important; height: 15pt;" height="20">
/repositories/4/digital_objects/3</td>
<td class="xl65" style="padding-top: 1px; padding-right: 1px; padding-left: 1px; font-size: 11pt; font-family: Calibri, sans-serif; vertical-align: bottom; border: 1px solid rgb(212, 212, 212); white-space: nowrap !important; color: rgb(5, 99, 193); text-decoration: underline;">
<a href="https://www.mynewfileuri.com/">https://www.mynewfileuri.com</a></td>
</tr>
<tr style="height:15.0pt" height="20">
<td style="padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 11pt; font-family: Calibri, sans-serif; vertical-align: bottom; border: 1px solid rgb(212, 212, 212); white-space: nowrap !important; height: 15pt;" height="20">
/repositories/4/digital_objects/4</td>
<td class="xl65" style="padding-top: 1px; padding-right: 1px; padding-left: 1px; font-size: 11pt; font-family: Calibri, sans-serif; vertical-align: bottom; border: 1px solid rgb(212, 212, 212); white-space: nowrap !important; color: rgb(5, 99, 193); text-decoration: underline;">
<a href="https://www.mynewfileuri.com/">https://www.mynewfileuri.com</a></td>
</tr>
</tbody>
</table>
<br>
Then, using python, I would go through each row and do a <a href="https://archivesspace.github.io/archivesspace/api/#get-a-digital-object" title="https://archivesspace.github.io/archivesspace/api/#get-a-digital-object">
GET request</a> for every digital object using the first column, update the returned JSON with the new file URI in the second column, then do a
<a href="https://archivesspace.github.io/archivesspace/api/#update-a-digital-object" title="https://archivesspace.github.io/archivesspace/api/#update-a-digital-object">
POST</a> to ArchivesSpace with the updated JSON for the digital object. If you need more help or want to walk through writing such a script, feel free to email me as I'd be more than happy to help. There's also
<a href="https://support.atlas-sys.com/hc/en-us/articles/360052217114-The-ArchivesSpace-API-Playbook#h_01EG0SJEJV5N9VE2ZM160T0VAQ" title="https://support.atlas-sys.com/hc/en-us/articles/360052217114-The-ArchivesSpace-API-Playbook#h_01EG0SJEJV5N9VE2ZM160T0VAQ">
this great resource</a> written by Valerie Addonizio for working with the API where she lists when to use the database vs. when to use the API.<br>
<br>
Hope this helps,<br>
<br>
Corey<br>
<div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div>
<div></div>
<div></div>
<div>
<p style="font:12px 'Georgia','Times','sans-serif'"><span style="font-weight:900">Corey Schmidt</span>
<br>
<span>Special Collections Libraries | <span style="font-style:italic">ArchivesSpace Project Manager</span></span></p>
<p style="font:12px 'Georgia','Times','sans-serif'"><span><span style="font-style:italic"><br>
</span></span></p>
<p style="font:12px 'Georgia','Times','sans-serif'"><span><a href="mailto:Corey.Schmidt@uga.edu">Corey.Schmidt@uga.edu</a><br>
</span></p>
</div>
</div>
</div>
</div>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Kris Santos
<ksantos@dalton.org><br>
<b>Sent:</b> Monday, March 28, 2022 10:39 AM<br>
<b>To:</b> archivesspace_users_group@lyralists.lyrasis.org <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> [Archivesspace_Users_Group] Bulk update File URIs for individual digital objects</font>
<div> </div>
</div>
<div><font color="BA0C2F">[EXTERNAL SENDER - PROCEED CAUTIOUSLY]</font><br>
<br>
<div>
<div dir="ltr">Hello all, <br>
<br>
<div>Is there a way to bulk update File URIs for digital objects? Our goal is just to update over 100 digital object's URI without having to do this item by item. While we have a solution for instances, we just want to know if there's a way to change the current
URIs to the new ones in bulk. </div>
<div><br>
</div>
<div>If anyone in the community may have resources or insights to accomplish this process - whether it is 100 digital objects or 1000 digital objects - I appreciate your assistance and insights. Thank you for any help you can provide. </div>
<div><br>
Best,<br>
Kris<br>
-- <br>
<div dir="ltr" class="x_gmail_signature">
<div dir="ltr"><b>Kris Santos</b>
<div>Archivist<br>
<img width="200" height="19" src="https://docs.google.com/uc?export=download&id=1-4IeOMCXpWairkTfb-CQOoXOCblL8O6L&revid=0B96s-lAKxHvMcE80d1h1SVd1QTQ3T0tHL3BOMTFFVmhSOTBVPQ"><br>
</div>
<div>(212) 423-5247</div>
<div><a href="mailto:ksantos@dalton.org" target="_blank">ksantos@dalton.org</a> |
<a href="mailto:archives@dalton.org" target="_blank">archives@dalton.org</a></div>
<div><a href="https://www.dalton.org/programs/library/dalton-school-archives" target="_blank">Dalton School Archives </a></div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>