<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:"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:Menlo-Regular;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.apple-converted-space
{mso-style-name:apple-converted-space;}
span.EmailStyle19
{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;}
--></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="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Steve, a happy trick is to SET system_mtime = NOW() when updating the db, with credit back to the
<a href="https://archivesspace.github.io/tech-docs/administration/indexes.html">Tech Doc</a> writers for that lovely tip.<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 <archivesspace_users_group-bounces@lyralists.lyrasis.org>
<b>On Behalf Of </b>Majewski, Steven Dennis (sdm7g)<br>
<b>Sent:</b> Thursday, December 16, 2021 4:15 PM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Digital Object Edit Batch<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal">How are the links encoded ? In file_version/file_uri ? <o:p></o:p></p>
<div>
<p class="MsoNormal">If that is the case it should be easy to change in MySQL. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">( Note that if you make changes to the database via MySQL rather than the API, you will need to trigger a full reindex, as going thru the backdoor doesn’t trigger an individual resource reindex. ) <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">— Steve. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<p class="MsoNormal"><br>
<br>
<o:p></o:p></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal">On Dec 16, 2021, at 4:03 PM, Pryse, JA <<a href="mailto:japryse@ou.edu">japryse@ou.edu</a>> wrote:<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal"><span style="color:#1F3864">Hello everyone, I need to batch edit a bunch of digital objects that contain links to an internal content management system. I know that I can import data that created new digital objects and have played around
with trying to ‘update’ the files with no luck (in a batch or bulk sense). There are thousands of DOs that need to be edited and cannot do this one at a time. Also, I cannot break the link in anyway shape or form as it does cause a mess. I have copied all
of the exported data with links and such to the new CSV but, of course, it just wants to create new records and none of the information in the new csv will be unique to the catalog. I do not want to remove the records and then upload new ones (I did try this
on a few) but this broke the links. I have no idea where to go from here.</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#1F3864"> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#1F3864">Thanks,<span class="apple-converted-space"> </span></span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#1F3864"> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#1F3864">JA Pryse, Curator and Senior Archivist III</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#1F3864">Carl Albert Congressional Research and Studies Center</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#1F3864">University of Oklahoma</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#1F3864"> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#1F3864">Facebook:</span><span class="apple-converted-space"><span style="color:#2F04E6"> </span></span><span style="color:#2F04E6"><a href="https://www.facebook.com/CarlAlbertCenter"><span style="color:#2F04E6">@CarlAlbertCenter</span></a></span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#1F3864">Twitter:<span class="apple-converted-space"> </span></span><span style="color:#2F04E6"><a href="https://twitter.com/CarlAlbertCtr"><span style="color:#2F04E6">@CarlAlbertCtr</span></a></span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#1F3864">YouTube:<span class="apple-converted-space"> </span></span><span style="color:#2F04E6"><a href="https://www.youtube.com/channel/UCOv6GKHVTmllPjIMKlp9lpA"><span style="color:#2F04E6">Congressional Archives Carl
Albert</span></a></span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Menlo-Regular",serif">_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
</span><a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org"><span style="font-size:12.0pt;font-family:"Menlo-Regular",serif">Archivesspace_Users_Group@lyralists.lyrasis.org</span></a><span style="font-size:12.0pt;font-family:"Menlo-Regular",serif"><br>
</span><a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group"><span style="font-size:12.0pt;font-family:"Menlo-Regular",serif">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</span></a><o:p></o:p></p>
</div>
</blockquote>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</body>
</html>