[Archivesspace_Users_Group] Querying ArchivesSpace using MySQL Workbench

[Margaret Kidd]

Thank you! The relationship info helps for sure. In the fog of my memory, I
remember making table joins, and I image this info would help.


------------------------------

Margaret Turman Kidd

Access and Electronic Records Archivist, Special Collections & Archives

VCU Libraries | Health Sciences Library

Virginia Commonwealth University

509 N. 12th Street / Box 980582, Richmond, VA 23298-0582

(804) 828-3152

kiddm at vcu.edu

Pronouns: she/her



On Tue, Jun 20, 2023 at 3:44 PM Valerie Addonizio <vaddonizio at atlas-sys.com>
wrote:

> Margaret,
>
>
>
> There is this classic resource that I’ve leaned on in the past:
> https://campuspress.yale.edu/yalearchivesspace/2015/09/08/mucking-around-in-archivesspace-locally/comment-page-1/
>
>
>
> I was recently made aware of this resource on the tech-docs page; though
> it was written against 2.7.1, a lot of the basics are the same:
> https://github.com/archivesspace/tech-docs/blob/master/architecture/backend/database.md
> Though they are complex, you may find the sample queries (halfway down the
> page) helpful to get you started. You’ll also want to scan the relationship
> tables since you’re likely interested in locations and their relationships
> to top containers (or vice versa).
>
>
>
> Neither of those is truly quickstart, but they are the two ASpace-specific
> resources I know of.
>
>
>
> -V
>
>
>
> *From:* archivesspace_users_group-bounces at lyralists.lyrasis.org <
> archivesspace_users_group-bounces at lyralists.lyrasis.org> *On Behalf Of *Margaret
> Kidd
> *Sent:* Tuesday, June 20, 2023 3:13 PM
> *To:* Archivesspace Users Group <
> archivesspace_users_group at lyralists.lyrasis.org>
> *Subject:* [Archivesspace_Users_Group] Querying ArchivesSpace using MySQL
> Workbench
>
>
>
> Hello all,
>
>
>
> I recently gained access to a read-only copy of our production database
> using MySQL Workbench. My hope is that I could use it to query our data to
> create the kinds of reports we need. For example, I would like a better
> shelf list report as the current option in ASpace doesn't suit our needs.
>
>
>
> The problem is that my skills in this area are hopelessly out-of-date. The
> last time I worked with MySQL was 20 years ago in my pre-archives life
> (ugh, it hurts to write that sentence and realize how old I'm getting).
> Does anyone have any tips or could point me to a basic tutorial that may
> help? The stuff I've found so far isn't very helpful for me. I just need to
> learn some quick and dirty basics to get at this information quickly.
> Hopefully, I can spend some time later on tutorials to get more comfortable.
>
>
>
> Any suggestions would be most appreciated.
>
>
>
> Thanks,
>
>
>
> Margaret
>
>
> ------------------------------
>
> *Margaret Turman Kidd*
>
> Access and Electronic Records Archivist, Special Collections & Archives
>
> VCU Libraries | Health Sciences Library
>
> Virginia Commonwealth University
>
> 509 N. 12th Street / Box 980582, Richmond, VA 23298-0582
>
> (804) 828-3152
>
> kiddm at vcu.edu
>
> Pronouns: she/her
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230620/e3a35c89/attachment.html>