<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<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);">
So you don't have API access? Can you install a plugin? Or is AS so locked down that those are also no gos?<br>
<br>
Both of those would allow you to do direct updates. API would be easier, but you can also write data migrations in a plugin.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Joshua<br>
</div>
<div>
<div id="appendonsend"></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Pryse, JA <japryse@ou.edu><br>
<b>Sent:</b> Thursday, December 16, 2021 4:32 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</font>
<div> </div>
</div>
<div style="word-wrap:break-word" lang="EN-US">
<div class="x_WordSection1">
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
<span style="color:#1F3864">Bad news is that I ONLY have access via staff side. Our instance is maintained by the university IT and its like an act of congress (get it, congressional archives…ha) to get them to do anything with AS.
</span></p>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
<span style="color:#1F3864"> </span></p>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
<b><span style="color:#1F3864">In file_version/file_uri:</span></b><span style="color:#1F3864">
</span><span style="font-size:10.5pt; font-family:"Helvetica Neue",serif; color:#333333; background:white"><a href=http://oucac.access.preservica.com/archive/sdb%3|9cdc92af-sdasdasdwww-15bfvd/>Preservica Access</a></span><span style="color:#1F3864"></span></p>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
<span style="color:#1F3864"> </span></p>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
<span style="color:#1F3864"> </span></p>
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
<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 3: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</p>
</div>
</div>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
</p>
<div>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
</p>
</div>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
How are the links encoded ? In file_version/file_uri ? </p>
<div>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
If that is the case it should be easy to change in MySQL. </p>
</div>
<div>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
( 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. ) </p>
</div>
<div>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
</p>
</div>
<div>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
— Steve. </p>
</div>
<div>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
</p>
</div>
<div>
<div>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
<br>
<br>
</p>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<div>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
On Dec 16, 2021, at 4:03 PM, Pryse, JA <<a href="mailto:japryse@ou.edu">japryse@ou.edu</a>> wrote:</p>
</div>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
</p>
<div>
<div>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
<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></p>
</div>
<div>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
<span style="color:#1F3864"> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
<span style="color:#1F3864">Thanks,<span class="x_apple-converted-space"> </span></span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
<span style="color:#1F3864"> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
<span style="color:#1F3864">JA Pryse, Curator and Senior Archivist III</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
<span style="color:#1F3864">Carl Albert Congressional Research and Studies Center</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
<span style="color:#1F3864">University of Oklahoma</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
<span style="color:#1F3864"> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
<span style="color:#1F3864">Facebook:</span><span class="x_apple-converted-space"><span style="color:#2F04E6"> </span></span><span style="color:#2F04E6"><a href="https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2FCarlAlbertCenter&data=04%7C01%7Cjoshua.d.shaw%40dartmouth.edu%7C2e9e5287270048ba254c08d9c0dba1c6%7C995b093648d640e5a31ebf689ec9446f%7C0%7C0%7C637752872274046136%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=XR2S%2BGysGzQ4HJltndYTLBXsPBy72D%2FTPa3%2Blp7WvfM%3D&reserved=0" originalsrc="https://www.facebook.com/CarlAlbertCenter" shash="sa73R0fG3lcqSZBYWHmE2M4CRcfENeTxvKY+Ls8MYb1D9xkcrotvlZ86156cqUGK0hIvbUtqVH4Ll5S569R0PwhXtemFgpLLagPxOtDkCmMGIYmO+0PfA2gME74c6ceUXdoM01HKapNN47pCm1Am7KIM4YXeps/s31xRcMPmcLg="><span style="color:#2F04E6">@CarlAlbertCenter</span></a></span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
<span style="color:#1F3864">Twitter:<span class="x_apple-converted-space"> </span></span><span style="color:#2F04E6"><a href="https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2FCarlAlbertCtr&data=04%7C01%7Cjoshua.d.shaw%40dartmouth.edu%7C2e9e5287270048ba254c08d9c0dba1c6%7C995b093648d640e5a31ebf689ec9446f%7C0%7C0%7C637752872274056124%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=U4Ao1YNYFKMq9JKc8Ov2zEGdcJOEizYB%2BBf0oFKTFm8%3D&reserved=0" originalsrc="https://twitter.com/CarlAlbertCtr" shash="mzqklTggcJ425wpB48Cai/UatjrASGedj1xFhSpQPk9RHNEFAz5icjTwcSmXbI0xi9GmEi8nXLDPgCV4UFmFotStmqKGtyVZcxuWyJplkR/P2hjnp37CjYlRgFlixhwKt1RKEkCP9c3PdeCmBYwRwIHApZw1ul3oGdAuupOZio0="><span style="color:#2F04E6">@CarlAlbertCtr</span></a></span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
<span style="color:#1F3864">YouTube:<span class="x_apple-converted-space"> </span></span><span style="color:#2F04E6"><a href="https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.youtube.com%2Fchannel%2FUCOv6GKHVTmllPjIMKlp9lpA&data=04%7C01%7Cjoshua.d.shaw%40dartmouth.edu%7C2e9e5287270048ba254c08d9c0dba1c6%7C995b093648d640e5a31ebf689ec9446f%7C0%7C0%7C637752872274056124%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=MM%2BwfGOUTOJHyMENZCm6FFE78vbqCgHjAdpbYC7q2Jo%3D&reserved=0" originalsrc="https://www.youtube.com/channel/UCOv6GKHVTmllPjIMKlp9lpA" shash="JjjUuxms0A0s7xITwBkAY0b4PHvNtY4LMojq54ag3pM1W1k2LTnLGmhVNMGsIeP6fQV+yiO+OKoO7+GEQxzy3z5MppjrjNNfnrfRynuT7VWIFNm/a9b5rtB7pAeFvcBVK/9R6CYEPwrWuiXEHu8vdFfA75A8WUHSX2ophxysZDA="><span style="color:#2F04E6">Congressional
Archives Carl Albert</span></a></span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
</p>
</div>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
<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="https://nam12.safelinks.protection.outlook.com/?url=http%3A%2F%2Flyralists.lyrasis.org%2Fmailman%2Flistinfo%2Farchivesspace_users_group&data=04%7C01%7Cjoshua.d.shaw%40dartmouth.edu%7C2e9e5287270048ba254c08d9c0dba1c6%7C995b093648d640e5a31ebf689ec9446f%7C0%7C0%7C637752872274066119%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=pmVNdRgZtnlHEH7haWW%2BP6xmfUeNUfz2bs6L622SJME%3D&reserved=0" originalsrc="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" shash="hnCrCW1UHcHjZOlTU94M4mkvsMUnW/iS9gqZaDEm9ggbL3s93ZlXNRRudbwSSrEHJNJ7D/0IZUuwtDMxkuPJxbfbb6F3ga07B//8RctBF4ZysikbydI3NNjfmyUnOX0RgIx9b7ookVHKBMYRul5rdGa1KjGzoLlVHLw6H5pP0GE="><span style="font-size:12.0pt; font-family:"Menlo-Regular",serif">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</span></a></p>
</div>
</blockquote>
</div>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
</p>
</div>
</div>
</div>
</div>
</body>
</html>