<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:x="urn:schemas-microsoft-com:office:excel" 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=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><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:"Open Sans";}
@font-face
{font-family:"Open Sans ExtraBold";}
/* 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:#0563C1;
text-decoration:underline;}
p.xmsonormal, li.xmsonormal, div.xmsonormal
{mso-style-name:x_msonormal;
margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle23
{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="#0563C1" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Hi Blake,<o:p></o:p></p>
<p class="MsoNormal"><br>
We don’t have access to the API’s but our web host is going to generate a custom report for us. Thanks to you and others for scoping out what is possible. I’m so grateful to have this community! - Daniel<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>Blake Carver<br>
<b>Sent:</b> Tuesday, March 22, 2022 1:55 PM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Generating a list of collections URLs<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left">
<tbody>
<tr>
<td style="background:#BBA555;padding:5.25pt 5.5pt 5.25pt 1.5pt"></td>
<td width="100%" style="width:100.0%;background:#FFE599;padding:5.25pt 3.75pt 5.25pt 11.25pt">
<div>
<p style="mso-element:frame;mso-element-frame-hspace:2.25pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<b><span style="font-family:"Arial",sans-serif;color:#212121">CAUTION:</span></b><span style="font-family:"Arial",sans-serif;color:#212121"> This email originated from outside the State of Alaska mail system. Do not click links or open attachments unless you
recognize the sender and know the content is safe. </span><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div id="Signature">
<div>
<div id="divtagdefaultwrapper">
<div name="divtagdefaultwrapper">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"> Hey Dan
<o:p></o:p></span></p>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">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.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">I did look at the reports on test:<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><a href="https://test.archivesspace.org/staff/custom_report_templates/new">https://test.archivesspace.org/staff/custom_report_templates/new</a><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">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.
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">That being said...<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">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."<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">Do you mean you just want to be sure they're all PUBLISHED?<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">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.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">Anything that has the "Published" checkbox checked has a PUI URL.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">The API would be another option. Not sure if you have access to that either.<o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="98%" align="center">
</div>
<div id="divRplyFwdMsg">
<p class="MsoNormal"><b><span style="color:black">From:</span></b><span style="color:black">
<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
on behalf of Cornwall, Daniel D (EED) <<a href="mailto:daniel.cornwall@alaska.gov">daniel.cornwall@alaska.gov</a>><br>
<b>Sent:</b> Tuesday, March 22, 2022 4:44 PM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> [Archivesspace_Users_Group] Generating a list of collections URLs</span>
<o:p></o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="xmsonormal">Hi All, <o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">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.<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">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:<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">Collection Name<o:p></o:p></p>
<p class="xmsonormal">Collection Identifier<o:p></o:p></p>
<p class="xmsonormal">Collection URL<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">For example, <o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">George L. Harrington Photograph Collection, ca. 1909-1917<o:p></o:p></p>
<p class="xmsonormal">Identifier: PCA 6<o:p></o:p></p>
<p class="xmsonormal"><a href="https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Falaska.libraryhost.com%2Frepositories%2F2%2Fresources%2F458&data=04%7C01%7Cdaniel.cornwall%40alaska.gov%7C134c2a36b0724c3cf38408da0c4eab08%7C20030bf67ad942f7927359ea83fcfa38%7C0%7C0%7C637835829676982155%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=H0jPcE8d7j7QEPD7Manhxoc7yjNdDC0SI%2FBzryIDqDk%3D&reserved=0">https://alaska.libraryhost.com/repositories/2/resources/458</a><o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">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.
<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">Thanks for any thoughts, insight or experience. - Daniel<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<table class="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="xmsonormal" style="line-height:105%"><span style="font-size:8.0pt;line-height:105%;font-family:"Open Sans",sans-serif"> </span><o:p></o:p></p>
<p class="xmsonormal" 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="130" style="width:1.375in;height:1.35in" id="x_Picture_x0020_3" src="cid:image001.png@01D84024.41C37B00"></span><o:p></o:p></p>
</td>
<td width="516" valign="top" style="width:386.65pt;padding:0in 5.4pt 0in 5.4pt">
<p class="xmsonormal" style="line-height:105%"><span style="font-size:8.0pt;line-height:105%;font-family:"Open Sans ExtraBold",sans-serif">====================================================</span><o:p></o:p></p>
<p class="xmsonormal" style="line-height:105%"><span style="font-size:8.0pt;line-height:105%;font-family:"Open Sans ExtraBold",sans-serif">Daniel Cornwall</span><o:p></o:p></p>
<p class="xmsonormal" style="line-height:105%"><span style="font-size:8.0pt;line-height:105%;font-family:"Open Sans",sans-serif">Pronouns: he/him/his</span><o:p></o:p></p>
<p class="xmsonormal" 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><o:p></o:p></p>
<p class="xmsonormal" 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><o:p></o:p></p>
<p class="xmsonormal" style="line-height:105%"><i><span style="font-size:8.0pt;line-height:105%;font-family:"Open Sans",sans-serif"> </span></i><o:p></o:p></p>
<p class="xmsonormal" 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><o:p></o:p></p>
<p class="xmsonormal" 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><o:p></o:p></p>
<p class="xmsonormal" 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><o:p></o:p></p>
<p class="xmsonormal" 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><o:p></o:p></p>
<p class="xmsonormal" style="line-height:105%"><span style="font-size:10.0pt;line-height:105%;font-family:"Open Sans",sans-serif;color:#C00000"> </span><o:p></o:p></p>
<p class="xmsonormal" 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><o:p></o:p></p>
<p class="xmsonormal" style="line-height:105%"><span style="font-size:8.0pt;line-height:105%;font-family:"Open Sans",sans-serif"> </span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="xmsonormal"><span style="color:white"> </span><o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
</div>
</div>
</div>
</div>
</body>
</html>