<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<p>You could, in theory, use a tool for automating repetitive tasks
in a web browser. There are various open source and proprietary
options, used for testing user interfaces, or screen-scraping
information from web sites. Configure it to open each digital
object in turn, edit the URL, and save. Then set it going and
watch it do all the clicking and scrolling necessary. But finding
one with the capabilities you require, yet won't require a month
learning how to program it, might be difficult. However, if you
tell your IT department that they've left you no other choice but
to use some dodgy web browser plug-in that runs macros, they might
be more inclined to run some SQL for you, or give you access to
the API so you can run an off-the-shelf script someone here might
have.</p>
<p>Andrew.</p>
<p><br>
</p>
<div class="moz-cite-prefix">On 16/12/2021 21:32, Pryse, JA wrote:<br>
</div>
<blockquote type="cite" cite="mid:SA1PR03MB6483AB7D85170985564F9B45DC779@SA1PR03MB6483.namprd03.prod.outlook.com">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style>@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:"Helvetica Neue";
panose-1:0 0 0 0 0 0 0 0 0 0;}@font-face
{font-family:Menlo-Regular;
panose-1:0 0 0 0 0 0 0 0 0 0;}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.EmailStyle21
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:#1F3864;}.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}div.WordSection1
{page:WordSection1;}</style>
<div class="WordSection1">
<p class="MsoNormal"><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.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F3864"><o:p> </o:p></span></p>
<p class="MsoNormal"><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=<a class="moz-txt-link-freetext" href="http://oucac.access.preservica.com/archive/sdb%3|9cdc92af-sdasdasdwww-15bfvd/">http://oucac.access.preservica.com/archive/sdb%3|9cdc92af-sdasdasdwww-15bfvd/</a>>Preservica
Access</a></span><span style="color:#1F3864"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F3864"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F3864"><o:p> </o:p></span></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 class="moz-txt-link-abbreviated" href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>
<a class="moz-txt-link-rfc2396E" href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org"><archivesspace_users_group-bounces@lyralists.lyrasis.org></a>
<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
<a class="moz-txt-link-rfc2396E" href="mailto:archivesspace_users_group@lyralists.lyrasis.org"><archivesspace_users_group@lyralists.lyrasis.org></a><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" moz-do-not-send="true">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" moz-do-not-send="true"><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" moz-do-not-send="true"><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" moz-do-not-send="true"><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" moz-do-not-send="true"><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" moz-do-not-send="true"><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>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Archivesspace_Users_Group mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org">Archivesspace_Users_Group@lyralists.lyrasis.org</a>
<a class="moz-txt-link-freetext" href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a>
</pre>
</blockquote>
</body>
</html>