[Archivesspace_Users_Group] AO codes and titles: Need for feed

Blake Carver blake.carver at lyrasis.org
Sat Jan 15 14:06:57 EST 2022

Probably easiest to just do that in the DB directly

SELECT something, title FROM archival_object;

I'm not quite sure what that "archival_object_123456 codes" is, component_id probably?

SELECT component_id AS code, title FROM archival_object;

Custom Reporting is a feature that is coming soon (at least I think it's coming soon?), I think that would do it as well. You can take that for a spin on https://test.archivesspace.org/staff/
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Mark Cyzyk <mcyzyk at gmail.com>
Sent: Saturday, January 15, 2022 11:20 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: [Archivesspace_Users_Group] AO codes and titles: Need for feed

Dear ASpace Forum,

One of our archivists has a need for a data feed out of our ASpace.

> Ideally I would get a CSV with a list of "archival_object_123456"
> codes in one column and the corresponding AO titles in another.

I went searching through the canned Reports thinking these two fields
must be in something like, e.g., the comprehensive Resource report, but
I could not find them.

My next step is to try to extract this via the API.

But does anyone have another suggestion?

I found this plugin, which initially sounded promising, but it's very
old:  https://github.com/quoideneuf/extended_reports

Advice appreciated,


Mark Cyzyk, M.A., M.L.S.
Library Applications Group
The Sheridan Libraries
The Johns Hopkins University
mcyzyk at jhu.edu

Verba volant, scripta manent.

Archivesspace_Users_Group mailing list
Archivesspace_Users_Group at lyralists.lyrasis.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20220115/c11a6893/attachment.html>

More information about the Archivesspace_Users_Group mailing list