[Archivesspace_Users_Group] Generating a list of collections URLs

[Cornwall, Daniel D (EED)]

Hi Blake,

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

From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> On Behalf Of Blake Carver
Sent: Tuesday, March 22, 2022 1:55 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] Generating a list of collections URLs


CAUTION: 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.

 Hey Dan

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.

I did look at the reports on test:
https://test.archivesspace.org/staff/custom_report_templates/new
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.

That being said...

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."

Do you mean you just want to be sure they're all PUBLISHED?

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.

Anything that has the "Published" checkbox checked has a PUI URL.

The API would be another option. Not sure if you have access to that either.
________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> <archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org>> on behalf of Cornwall, Daniel D (EED) <daniel.cornwall at alaska.gov<mailto:daniel.cornwall at alaska.gov>>
Sent: Tuesday, March 22, 2022 4:44 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>>
Subject: [Archivesspace_Users_Group] Generating a list of collections URLs


Hi All,



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.



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:



Collection Name

Collection Identifier

Collection URL



For example,



George L. Harrington Photograph Collection, ca. 1909-1917

Identifier: PCA 6

https://alaska.libraryhost.com/repositories/2/resources/458<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>



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.



Thanks for any thoughts, insight or experience. - Daniel









[cid:image001.png at 01D84024.41C37B00]

====================================================

Daniel Cornwall

Pronouns: he/him/his

Continuing Resources Libarian

Information Services Staff, Alaska State Library



Andrew P. Kashevaroff Building

Phone: 907.465.2988

Mail: PO Box 110571, Juneau, AK 99811

Visit: 395 Whittier St., Juneau, AK 99801



email<mailto:daniel.cornwall at alaska.gov> | web<http://library.alaska.gov/> |  sign up for event notifications<http://list.state.ak.us/mailman/listinfo/at-apk-and-sjm>






-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20220325/b890eacf/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 16846 bytes
Desc: image001.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20220325/b890eacf/attachment.png>