<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>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
</div>
<div></div>
<div></div>
<div id="divtagdefaultwrapper" dir="ltr" style="color:rgb(0,0,0); background-color:rgb(255,255,255)">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; margin:0px">
Hey Dan
<div><br>
</div>
<div>Do you get access to the DB there? If so, it would be pretty easy to just do a direct MySQL query for that and build the URLS from the IDs.</div>
<div><br>
</div>
<div>I did look at the reports on test:</div>
<div>https://test.archivesspace.org/staff/custom_report_templates/new</div>
<div>And I don't see a way to do exactly what you want, though I could be missing something obvious there. I haven't worked through all the options.
</div>
<div><br>
</div>
<div>That being said...</div>
<div><br>
</div>
<div>I'm not quite sure what you mean... "there is interest to ensure that all of our catalog finding aid records actually have ArchivesSpace URLs."</div>
<div><br>
</div>
<div>Do you mean you just want to be sure they're all PUBLISHED?</div>
<div><br>
</div>
<div>If that's it, then the 3.2 report DO have a limit for "Published" so you can build any Resources report on PUBLISHED and know what's there on the PUI. So that would get you close.</div>
<div><br>
</div>
<div>Anything that has the "Published" checkbox checked has a PUI URL.</div>
<div><br>
</div>
<span>The API would be another option. Not sure if you have access to that either.</span></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 Cornwall, Daniel
D (EED) <daniel.cornwall@alaska.gov><br>
<b>Sent:</b> Tuesday, March 22, 2022 4:44 PM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> [Archivesspace_Users_Group] Generating a list of collections URLs</font>
<div> </div>
</div>
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
@font-face
{font-family:"Open Sans ExtraBold"}
@font-face
{font-family:"Open Sans"}
p.x_MsoNormal, li.x_MsoNormal, div.x_MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
a:link, span.x_MsoHyperlink
{color:#0563C1;
text-decoration:underline}
span.x_EmailStyle17
{font-family:"Calibri",sans-serif;
color:windowtext}
.x_MsoChpDefault
{}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
div.x_WordSection1
{}
-->
</style>
<div lang="EN-US" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="x_WordSection1">
<p class="x_MsoNormal">Hi All, </p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">My institution has cataloged our finding aids into our regular library catalog. With our recent-ish migration to ArchivesSpace, there is interest to ensure that all of our catalog finding aid records actually have ArchivesSpace URLs.</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">I know there is a resource list report in AS, but it doesn’t provide the URL. Ideally, I’d like a report that lists:</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">Collection Name</p>
<p class="x_MsoNormal">Collection Identifier</p>
<p class="x_MsoNormal">Collection URL</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">For example, </p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">George L. Harrington Photograph Collection, ca. 1909-1917</p>
<p class="x_MsoNormal">Identifier: PCA 6</p>
<p class="x_MsoNormal"><a href="https://alaska.libraryhost.com/repositories/2/resources/458">https://alaska.libraryhost.com/repositories/2/resources/458</a></p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">We’re currently on v. 3.1.1 – Could such a report be run on this version, and if not, could something like this be run in the custom reports module in 3.2? I’m not sure we’d immediately upgrade if we couldn’t get such a report anyway.
</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">Thanks for any thoughts, insight or experience. - Daniel</p>
<p class="x_MsoNormal"></p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"> </p>
<table class="x_MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="684" style="width:513.0pt; border-collapse:collapse">
<tbody>
<tr>
<td width="168" valign="top" style="width:126.35pt; padding:0in 5.4pt 0in 5.4pt">
<p class="x_MsoNormal" style="line-height:105%"><span style="font-size:8.0pt; line-height:105%; font-family:"Open Sans",sans-serif"> </span></p>
<p class="x_MsoNormal" style="line-height:105%"><span style="font-size:8.0pt; line-height:105%; font-family:"Open Sans",sans-serif"><img border="0" width="132" height="129" id="x_Picture_x0020_3" style="width:1.375in; height:1.3416in" data-outlook-trace="F:1|T:1" src="cid:image001.png@01D83DEA.286A0CF0"></span><span style="font-family:"Open Sans",sans-serif"></span></p>
</td>
<td width="516" valign="top" style="width:386.65pt; padding:0in 5.4pt 0in 5.4pt">
<p class="x_MsoNormal" style="line-height:105%"><span style="font-size:8.0pt; line-height:105%; font-family:"Open Sans ExtraBold",sans-serif">====================================================</span></p>
<p class="x_MsoNormal" style="line-height:105%"><span style="font-size:8.0pt; line-height:105%; font-family:"Open Sans ExtraBold",sans-serif">Daniel Cornwall</span></p>
<p class="x_MsoNormal" style="line-height:105%"><span style="font-size:8.0pt; line-height:105%; font-family:"Open Sans",sans-serif">Pronouns: he/him/his</span></p>
<p class="x_MsoNormal" style="line-height:105%"><i><span style="font-size:8.0pt; line-height:105%; font-family:"Open Sans",sans-serif">Continuing Resources Libarian</span></i></p>
<p class="x_MsoNormal" style="line-height:105%"><i><span style="font-size:8.0pt; line-height:105%; font-family:"Open Sans",sans-serif">Information Services Staff, Alaska State Library</span></i></p>
<p class="x_MsoNormal" style="line-height:105%"><i><span style="font-size:8.0pt; line-height:105%; font-family:"Open Sans",sans-serif"> </span></i></p>
<p class="x_MsoNormal" style="line-height:105%"><span style="font-size:10.0pt; line-height:105%; font-family:"Open Sans",sans-serif; color:#C00000">Andrew P. Kashevaroff Building</span><span style="font-size:10.0pt; line-height:105%; font-family:"Open Sans",sans-serif"></span></p>
<p class="x_MsoNormal" style="line-height:105%"><b><span style="font-size:10.0pt; line-height:105%; font-family:"Open Sans",sans-serif">Phone:
</span></b><span style="font-size:10.0pt; line-height:105%; font-family:"Open Sans",sans-serif">907.465.2988</span></p>
<p class="x_MsoNormal" style="line-height:105%"><b><span style="font-size:10.0pt; line-height:105%; font-family:"Open Sans",sans-serif">Mail:</span></b><span style="font-size:10.0pt; line-height:105%; font-family:"Open Sans",sans-serif"> PO Box 110571, Juneau,
AK 99811</span></p>
<p class="x_MsoNormal" style="line-height:105%"><b><span style="font-size:10.0pt; line-height:105%; font-family:"Open Sans",sans-serif">Visit:</span></b><span style="font-size:10.0pt; line-height:105%; font-family:"Open Sans",sans-serif"> 395 Whittier St.,
Juneau, AK 99801</span></p>
<p class="x_MsoNormal" style="line-height:105%"><span style="font-size:10.0pt; line-height:105%; font-family:"Open Sans",sans-serif; color:#C00000"> </span><span style="font-size:10.0pt; line-height:105%; font-family:"Open Sans",sans-serif"></span></p>
<p class="x_MsoNormal" style="line-height:105%"><span style="font-size:10.0pt; line-height:105%; font-family:"Open Sans",sans-serif"><a href="mailto:daniel.cornwall@alaska.gov"><span style="color:blue">email</span></a><span style="color:#C00000"> |
</span><a href="http://library.alaska.gov/"><span style="color:blue">web</span></a><span style="color:#C00000"> |
</span><a href="http://list.state.ak.us/mailman/listinfo/at-apk-and-sjm"><span style="color:blue">sign up for event notifications</span></a>
</span></p>
<p class="x_MsoNormal" style="line-height:105%"><span style="font-size:8.0pt; line-height:105%; font-family:"Open Sans",sans-serif"> </span></p>
</td>
</tr>
</tbody>
</table>
<p class="x_MsoNormal"><span style=""> </span></p>
<p class="x_MsoNormal"> </p>
</div>
</div>
</body>
</html>