<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: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=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<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:"Segoe UI Emoji";
panose-1:2 11 5 2 4 2 4 2 2 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Arial",sans-serif;
color:#1F497D;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:612057221;
mso-list-template-ids:-402514490;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></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="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#1F497D">Good morning.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#1F497D">At Northwestern University, our ArchivesSpace is hosted by Atlas, who has given us ODBC read-only access to the MySQL database. Just yesterday I ran a report that
harvests BiogHist notes from Agents for a cleanup project. My SQL is pretty hacky too (although Mark’s is a good bit more neat looking than mine!), but I could post it on GitHub if it’s of interest.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#1F497D">Karen<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><b><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#272323">Karen D. Miller<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:black">Monographic Cataloger/Metadata Specialist<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#272323">Northwestern University Libraries<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#4E2A85">Northwestern University<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:black">1970 Campus Drive<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:black">Evanston, IL 60208<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#272323">www.library.northwestern.edu<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:black">k-miller3@northwestern.edu<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#272323">874.467.3462</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org>
<b>On Behalf Of </b>Lara Friedman-Shedlov<br>
<b>Sent:</b> Monday, May 18, 2020 4:07 PM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Mrs. Husband's Name / updates in our ArchivesSpace database<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Thanks for sharing this Mark. At the University of Minnesota, we are in the early stages of doing some agent record clean-up as well, so this information is very useful.<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">For one project we were looking at doing with our agents, we wanted to create a report of all of our agent records that would also include the biographical /historical notes from any linked resource records (or at least the URLs to any
associated resource records, so we could easily find the relevant bio/hist notes). Our instance of ArchivesSpace is hosted by Lyrasis so we contacted them to ask about it and were told this is "not possible." I found that surprising and wonder if anyone
else has done something like this and if so, how.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">/ Lara Friedman-Shedlov<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Mon, May 18, 2020 at 4:00 PM Custer, Mark <<a href="mailto:mark.custer@yale.edu">mark.custer@yale.edu</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">All,<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Is anyone else working on Agent-related cleanup projects in ArchivesSpace right now? We’ve got a couple of those going on at Yale, and I wanted to mention one of them on this listserv
since I said that I would last night on Twitter <span style="font-family:"Segoe UI Emoji",sans-serif">
😊</span>. My reasoning was that it would be better to share widely, even early on, in the likely event that others were working on similar projects, and in hopes that it might save time for anyone else looking to get started with such a project.<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Anyhow, just for the sake of sharing, here’s a really hacky SQL database query that you can use in ArchivesSpace to get a list of agents that have any name forms that include “Mrs.”
or “Miss”: <a href="https://urldefense.com/v3/__https:/gist.github.com/fordmadox/d78656fceb04b62000b662a3f2464488__;!!Dq0X2DkFhyF93HkjWTBQKhk!DAGYXPEqRVg0-NFRnfOuJMNhEZpsfUiHPsPJAqb_PiiJHnuc5bD-RHaIWZGvOCZQaQ_p5N6G$" target="_blank">
https://gist.github.com/fordmadox/d78656fceb04b62000b662a3f2464488</a> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">A few caveats:<o:p></o:p></p>
<ul type="disc">
<li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1">
I do *<b>not</b>* know SQL very well, so I know that this could be improved dramatically, but it gets data out of ArchivesSpace.<o:p></o:p></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1">
The query casts a rather wide net, since it looks for Mrs. or Miss in any of the name forms, but it could be altered to just look for those two terms in the “sort_name” only if desired.<o:p></o:p></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1">
The result of the query has at least one Yale-specific field in there, since we store our local ILS bibliographic IDs in ASpace’s “user defined string 2” field. You can ignore that, or add something else, etc., but the gist is that this query should work in
any ASpace instance. It should return one row per agent, with multiple name forms, and a bit more information like which Resources, Archival Objects, and/or Accessions the agent is linked to.<o:p></o:p></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1">
And last, it just searches for variations of “Mrs.” and “Miss”, which works for our dataset, but you could modify the HAVING clause at the end of the query to search for other honorific terms, if needed.<o:p></o:p></li></ul>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Most importantly, though, getting a dataset to review and act on is just the first step. The hard work comes next! Jessica Tai, Alison Clemens, and Karen Spicher are spearheading
this project at Yale. If anyone has specific questions about the project, I’d encourage you to reach out directly to them.<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">For now, though, here’s one interesting example from the project: we’ve got an agent record now in ArchivesSpace for “Brady, John G., Mrs.”, <a href="https://urldefense.com/v3/__https:/archives.yale.edu/agents/people/77599__;!!Dq0X2DkFhyF93HkjWTBQKhk!DAGYXPEqRVg0-NFRnfOuJMNhEZpsfUiHPsPJAqb_PiiJHnuc5bD-RHaIWZGvOCZQadb761Dg$" target="_blank">https://archives.yale.edu/agents/people/77599</a>.
Originally this would just have been text in the finding aid, later a link in a catalog record, and now it’s full-blown, standalone record for a person in ArchivesSpace. But nowhere in that agent record is her given name, Elizabeth, although her name is thankfully
listed multiple times in the finding aid (check out the finding aid author! <span style="font-family:"Segoe UI Emoji",sans-serif">
😊</span>), in the Wikipedia entry for John Green Brady, and elsewhere. So, that agent record will eventually be one of a few hundred local records that we update in ArchivesSpace during the course of this project. And, one of the things that I like about
ArchivesSpace --which helps to make sure that this project is possible without too many workarounds-- is that even if an agent record has a corresponding authority record in, say, the Library of Congress name authority file (e.g.
<a href="https://urldefense.com/v3/__http:/id.loc.gov/authorities/names/n2008076910__;!!Dq0X2DkFhyF93HkjWTBQKhk!DAGYXPEqRVg0-NFRnfOuJMNhEZpsfUiHPsPJAqb_PiiJHnuc5bD-RHaIWZGvOCZQabVrHQ4a$" target="_blank">
http://id.loc.gov/authorities/names/n2008076910</a>), you can still choose to use a different name variant for that agent’s display name, rather than an authorized heading.<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Anyhow, I hope all is doing well!
<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Mark<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="https://urldefense.com/v3/__http:/lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group__;!!Dq0X2DkFhyF93HkjWTBQKhk!DAGYXPEqRVg0-NFRnfOuJMNhEZpsfUiHPsPJAqb_PiiJHnuc5bD-RHaIWZGvOCZQaXQ9H2pz$" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><o:p></o:p></p>
</blockquote>
</div>
<p class="MsoNormal"><br clear="all">
<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal">-- <o:p></o:p></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal">Lara D. Friedman-Shedlov (she, her, hers)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Description and Access Archivist | Kautz Family YMCA Archives |
<a href="https://urldefense.com/v3/__http:/www.lib.umn.edu/ymca__;!!Dq0X2DkFhyF93HkjWTBQKhk!DAGYXPEqRVg0-NFRnfOuJMNhEZpsfUiHPsPJAqb_PiiJHnuc5bD-RHaIWZGvOCZQaZt0MhzS$" target="_blank">
www.lib.umn.edu/ymca</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Digital Records Archivist | Archives & Special Collections |
<a href="https://urldefense.com/v3/__http:/www.lib.umn.edu/special__;!!Dq0X2DkFhyF93HkjWTBQKhk!DAGYXPEqRVg0-NFRnfOuJMNhEZpsfUiHPsPJAqb_PiiJHnuc5bD-RHaIWZGvOCZQabmoZPYY$" target="_blank">
www.lib.umn.edu/special</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">University of Minnesota Libraries | <a href="https://urldefense.com/v3/__http:/lib.umn.edu__;!!Dq0X2DkFhyF93HkjWTBQKhk!DAGYXPEqRVg0-NFRnfOuJMNhEZpsfUiHPsPJAqb_PiiJHnuc5bD-RHaIWZGvOCZQafyhC_NT$" target="_blank">
lib.umn.edu</a> | 612.626.7972<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>