<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p><br>
</p>
<p>Hi Mark,</p>
<p><br>
</p>
<br>
<p>The resources we had on the project team for reports has transitioned off the project with the expectation that the community would be creating their own reports. Jasper was seen as a primary way for doing this, but there seems to be some mixed reactions
to that. So, you have the SQL query and you're comfortable using Jasper...why haven't you made this into a report? What is the road block?
<br>
</p>
<p><br>
</p>
<p>In regards to getting data out from the API, can do it with the aspace API (which would give you JSON) but it's also actually pretty easy to do with the Solr API.
<br>
</p>
<p><br>
</p>
<p>The query :</p>
<p><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D"><a title="Cmd+Click or tap to follow the link" id="LPlnk772638" style="color: rgb(5, 99, 193); text-decoration: underline;" href="http://sandbox.archivesspace.org/advanced_search?advanced=true&dop1=greater_than&dop2=lesser_than&f0=keyword&f1=create_time&f2=create_time&f3=suppressed&filter_term%5B%5D=%7B%22primary_type%22%3A%22accession%22%7D&op1=AND&op2=AND&op3=AND&t0=text&t1=date&t2=date&t3=boolean&v0=pape%2A&v1=2015-06-30&v2=2016-07-01&v3=false">http://sandbox.archivesspace.org/advanced_search?advanced=true&dop1=greater_than&dop2=lesser_than&f0=keyword&f1=create_time&f2=create_time&f3=suppressed&filter_term%5B%5D=%7B%22primary_type%22%3A%22accession%22%7D&op1=AND&op2=AND&op3=AND&t0=text&t1=date&t2=date&t3=boolean&v0=pape%2A&v1=2015-06-30&v2=2016-07-01&v3=false</a>,</span></p>
<p><br>
</p>
<p>Essential is just passed to Solr as: <br>
</p>
<p><a title="Cmd+Click or tap to follow the link" id="LPlnk689583" href="http://localhost:8090/collection1/select?q=%28%28%28fullrecord:%28pape*%29+AND+create_time:[2015-06-30T00:00:00Z%2B1DAY+TO+*]%29+AND+create_time:[*+TO+2016-07-01T00:00:00Z-1MILLISECOND]%29+AND+suppressed:%28false%29%29&facet.limit=100&facet.field=primary_type&facet.field=creators&facet.field=subjects&start=0&fq=repository:%22/repositories/2%22+OR+repository:global&fq=-exclude_by_default:true&sort=&rows=10&wt=json&facet=true">http://localhost:8090/collection1/select?q=%28%28%28fullrecord:%28pape*%29+AND+create_time:[2015-06-30T00:00:00Z%2B1DAY+TO+*]%29+AND+create_time:[*+TO+2016-07-01T00:00:00Z-1MILLISECOND]%29+AND+suppressed:%28false%29%29&facet.limit=100&facet.field=primary_type&facet.field=creators&facet.field=subjects&start=0&fq=repository:%22/repositories/2%22+OR+repository:global&fq=-exclude_by_default:true&sort=&rows=10&wt=json&facet=true</a></p>
<p><br>
</p>
<p><br>
</p>
All you have to do is change the wt ( response format ) to csv and the rows to something like 100000.<br>
<a id="LPlnk75862" href="http://localhost:8090/collection1/select?q=%28%28%28fullrecord:%28pape*%29+AND+create_time:[2015-06-30T00:00:00Z%2B1DAY+TO+*]%29+AND+create_time:[*+TO+2016-07-01T00:00:00Z-1MILLISECOND]%29+AND+suppressed:%28false%29%29&facet.limit=100&facet.field=primary_type&facet.field=creators&facet.field=subjects&start=0&fq=repository:%22/repositories/2%22+OR+repository:global&fq=-exclude_by_default:true&sort=&rows=10&wt=json&facet=true"></a><a id="LPlnk431126" href="http://localhost:8090/collection1/select?q=%28%28%28fullrecord:%28pape*%29+AND+create_time:[2015-06-30T00:00:00Z%2B1DAY+TO+*]%29+AND+create_time:[*+TO+2016-07-01T00:00:00Z-1MILLISECOND]%29+AND+suppressed:%28false%29%29&facet.limit=100&facet.field=primary_type&facet.field=creators&facet.field=subjects&start=0&fq=repository:%22/repositories/2%22+OR+repository:global&rows=10000&wt=csv">http://localhost:8090/collection1/select?q=%28%28%28fullrecord:%28pape*%29+AND+create_time:[2015-06-30T00:00:00Z%2B1DAY+TO+*]%29+AND+create_time:[*+TO+2016-07-01T00:00:00Z-1MILLISECOND]%29+AND+suppressed:%28false%29%29&facet.limit=100&facet.field=primary_type&facet.field=creators&facet.field=subjects&start=0&fq=repository:%22/repositories/2%22+OR+repository:global&rows=10000&wt=csv</a><br>
<p><br>
</p>
<p>( you can drop the facet stuff, since you're not needing to display that ).</p>
<p><br>
</p>
<p>Solr query syntax is pretty <a href="https://wiki.apache.org/solr/SolrQuerySyntax">
well documented. </a><br>
</p>
<p>And there's the Solr control panel that is available at port :8090 . </p>
<p>A pro tip is to have apace running and watch the log as you submit some queries. You'll see the request go to the frontend and then see it pass to the backend api, then passed to Solr.
</p>
<p><br>
</p>
<p>For Solr search, the log will look like :</p>
<p>INFO: [collection1] webapp= path=/select params={ ....</p>
<p><br>
</p>
<p>Take whats in params ( it'll start with a ?q= ) and just past that into <a id="LPlnk205982" href="http://your.aspace.org:8090/collection1/select?q">
http://your.aspace.org:8090/collection1/select?q</a>......</p>
<p>Make sense? <br>
</p>
<p><br>
</p>
<p>b,chris.<br>
</p>
<p><br>
</p>
<p> <br>
</p>
<p><br>
</p>
<div id="Signature">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:; margin:0">
<div class="BodyFragment"><font size="2">
<div class="PlainText">Chris Fitzpatrick | <font size="2">Developer, ArchivesSpace</font><br>
Skype: chrisfitzpat | Phone: 918.236.6048<br>
http://archivesspace.org/<br>
</div>
</font></div>
</div>
</div>
<br>
<br>
<div style="color: rgb(0, 0, 0);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Custer, Mark
<mark.custer@yale.edu><br>
<b>Sent:</b> Thursday, January 21, 2016 3:06 PM<br>
<b>To:</b> Archivesspace Users Group<br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Reporting update request</font>
<div> </div>
</div>
<div>
<div style="">
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">Chris,</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">Speaking as a former member of the UAC Reports subteam, we found that the most (only?) useful report for former AT users was the print-screen report. Given that, and in addition
to feedback from staff here, it sounds to me like the biggest help of all for reporting would be the following:</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></p>
<p style="text-indent: -0.25in; margin: 0in 0in 0.0001pt 0.5in; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:Symbol; color:#1F497D"><span style="">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">Staff could specify what columns they would like to display in a the search result screen (and multiple dates could display as a list in a single column, whereas
description from the notes table couldn’t display, just like they didn’t in the AT)</span></p>
<p style="text-indent: -0.25in; margin: 0in 0in 0.0001pt 0.5in; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:Symbol; color:#1F497D"><span style="">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">Staff could take any search result that they produced, like this one,
<a id="LPlnk772638" style="color: rgb(5, 99, 193); text-decoration: underline;" href="http://sandbox.archivesspace.org/advanced_search?advanced=true&dop1=greater_than&dop2=lesser_than&f0=keyword&f1=create_time&f2=create_time&f3=suppressed&filter_term%5B%5D=%7B%22primary_type%22%3A%22accession%22%7D&op1=AND&op2=AND&op3=AND&t0=text&t1=date&t2=date&t3=boolean&v0=pape%2A&v1=2015-06-30&v2=2016-07-01&v3=false">
http://sandbox.archivesspace.org/advanced_search?advanced=true&dop1=greater_than&dop2=lesser_than&f0=keyword&f1=create_time&f2=create_time&f3=suppressed&filter_term%5B%5D=%7B%22primary_type%22%3A%22accession%22%7D&op1=AND&op2=AND&op3=AND&t0=text&t1=date&t2=date&t3=boolean&v0=pape%2A&v1=2015-06-30&v2=2016-07-01&v3=false</a>,
and then export those results as a CSV file. And let’s pretend, in this case, that the user has also added columns for the Identifier and the Accession Date. Also, every page of results would need to be exported. In this example, there are just 3 results,
but even if there were 3,333 results, then all of those results should be exported into a single CSV file.</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">From my understanding, that’s the biggest user request: as a staff user, I want to select what fields display for my search results (title isn’t enough), perform an advanced search,
and then export my results.</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">Right now, for our statistical reports, we just run these “reports” to get our data out with a read-only MySQL user with a few SQL scripts, like this one:</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">select value as 'Accession type'</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">, COUNT(*) as 'Total accessions measured in linear feet'</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">, ROUND(SUM(extent.number), 2) as 'Linear feet'</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">from accession</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">left join extent on accession.id = extent.accession_id</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">left join enumeration_value on acquisition_type_id = enumeration_value.id
</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">where
</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">(extent_type_id IN (select id</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">from enumeration_value</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">where LOWER(value) like '%linear%'))</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">and repo_id = 11 #hardcoded value for now</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">and accession.accession_date >= '20151001' #change dates as needed</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">and accession.accession_date <= '20151231'</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">group by acquisition_type_id;</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">Mark</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">P.S. All that said, I really like Jasper, actually! But until it’s easy to pass in different parameters in the staff interface when running a report (date ranges, search terms,
etc.), I don’t think it’ll be as useful to most ASpace users as being able to export all of their search results in some fashion.</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></p>
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<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 [mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org]
<b>On Behalf Of </b>Chris Fitzpatrick<br>
<b>Sent:</b> Thursday, January 21, 2016 7:51 AM<br>
<b>To:</b> Archivesspace Users Group<br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Reporting update request</span></p>
</div>
</div>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
</p>
<div id="divtagdefaultwrapper">
<p style="background:white"><span style="font-family:"Calibri",sans-serif; color:black"> </span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif; color:black">I can help in regards to getting data out via the API. What are some things you're wanting to get out?
</span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif; color:black"> </span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif; color:black">b,chris.
</span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif; color:black"> </span></p>
<div id="Signature">
<div name="divtagdefaultwrapper">
<div>
<div>
<p style="background: white none repeat scroll 0% 0%; margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-size:10.0pt; font-family:"Calibri",sans-serif; color:black">Chris Fitzpatrick | Developer, ArchivesSpace<br>
Skype: chrisfitzpat | Phone: 918.236.6048<br>
<a style="color: rgb(5, 99, 193); text-decoration: underline;" href="http://archivesspace.org/">http://archivesspace.org/</a></span></p>
</div>
</div>
</div>
</div>
<p style="background: white none repeat scroll 0% 0%; margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-family:"Calibri",sans-serif; color:black"> </span></p>
<div>
<div style="text-align: center; background: white none repeat scroll 0% 0%; margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;" align="center">
<span style="font-family:"Calibri",sans-serif; color:black">
<hr align="center" size="2" width="98%">
</span></div>
<div id="divRplyFwdMsg">
<p style="background: white none repeat scroll 0% 0%; margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<b><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black">From:</span></b><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black">
<a style="color: rgb(5, 99, 193); text-decoration: underline;" href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">
archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a style="color: rgb(5, 99, 193); text-decoration: underline;" href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>> on
behalf of Carll, Johanna <<a style="color: rgb(5, 99, 193); text-decoration: underline;" href="mailto:jcarll@radcliffe.harvard.edu">jcarll@radcliffe.harvard.edu</a>><br>
<b>Sent:</b> Wednesday, January 20, 2016 5:46 PM<br>
<b>To:</b> Archivesspace Users Group<br>
<b>Subject:</b> [Archivesspace_Users_Group] Reporting update request</span><span style="font-family:"Calibri",sans-serif; color:black">
</span></p>
<div>
<p style="background: white none repeat scroll 0% 0%; margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman",serif;">
<span style="font-family:"Calibri",sans-serif; color:black"> </span></p>
</div>
</div>
<div>
<div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif; color:black">Hi all</span><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black"></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif; color:black"> </span><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black"></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif; color:black">As we begin the second half of the fiscal year and plan for how we will produce our end of year statistical reports, it would be useful to have an update on AS reports.
Specifically, is there a timeline for when we can expect a release that includes improved functionality of the existing reports (date limiting, improved csv exports, etc.)</span><span style="font-family:"Calibri",sans-serif; color:#333333; background:white">?
Also, have there been any further developments on the approach proposed in the below report from the Reports sub-group in the UAC minutes from November 5th?</span><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black"></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif; color:#333333; background:white"> </span><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black"></span></p>
<p style="background:white"><span style="font-size:10.5pt; font-family:"Arial",sans-serif; color:#333333; background:white">currently testing reports to assist features prioritization sub-team; team wants to approach reports in a different way–get data out
to use in own way; Brad Westbrook will talk to programmers about getting data out via API; sub-team feels that Jasper is not user friendly–stored reports are difficult to edit or customize unless you are a programmer and difficult to write canned reports that
can be used by multiple repositories</span><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black"></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif; color:black"> </span><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black"></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif; color:black">Thanks</span><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black"></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif; color:black">Johanna</span><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black"></span></p>
<p style="background:white"><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black"> </span></p>
<p style="background:white"><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black"> </span></p>
<p style="background:white"><span style="font-size:10.0pt; font-family:"Arial",sans-serif; color:black">Johanna Carll
</span><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black"><br>
</span><span style="font-size:10.0pt; font-family:"Arial",sans-serif; color:black">Archivist and Metadata Specialist</span><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black"><br>
</span><span style="font-size:10.0pt; font-family:"Arial",sans-serif; color:black">Schlesinger Library</span><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black">
<br>
</span><span style="font-size:10.0pt; font-family:"Arial",sans-serif; color:black">Radcliffe Institute for Advanced Study</span><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black">
<br>
</span><span style="font-size:10.0pt; font-family:"Arial",sans-serif; color:black">Harvard University</span><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black">
<br>
</span><span style="font-size:10.0pt; font-family:"Arial",sans-serif; color:black">10 Garden Street</span><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black">
<br>
</span><span style="font-size:10.0pt; font-family:"Arial",sans-serif; color:black">Cambridge, MA 02138</span><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black">
<br>
</span><span style="font-size:10.0pt; font-family:"Arial",sans-serif; color:black">617-495-8524</span><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black">
<br>
</span><span style="font-size:10.0pt; font-family:"Arial",sans-serif; color:black"><a style="color: rgb(5, 99, 193); text-decoration: underline;" href="mailto:jcarll@radcliffe.harvard.edu">jcarll@radcliffe.harvard.edu</a></span><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black">
</span></p>
<p style="background:white"><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black"> </span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>