<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=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><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;}
/* 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
        {mso-style-priority:99;
        margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman",serif;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
        {mso-style-priority:34;
        margin-top:0in;
        margin-right:0in;
        margin-bottom:0in;
        margin-left:.5in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman",serif;}
span.EmailStyle18
        {mso-style-type:personal;
        font-family:"Calibri",sans-serif;
        color:#1F497D;}
span.EmailStyle20
        {mso-style-type:personal-compose;
        font-family:"Calibri",sans-serif;
        color:windowtext;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@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:2059011701;
        mso-list-type:hybrid;
        mso-list-template-ids:-1139249558 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
        {mso-level-tab-stop:none;
        mso-level-number-position:left;
        text-indent:-.25in;}
@list l0:level2
        {mso-level-number-format:alpha-lower;
        mso-level-tab-stop:none;
        mso-level-number-position:left;
        text-indent:-.25in;}
@list l0:level3
        {mso-level-number-format:roman-lower;
        mso-level-tab-stop:none;
        mso-level-number-position:right;
        text-indent:-9.0pt;}
@list l0:level4
        {mso-level-tab-stop:none;
        mso-level-number-position:left;
        text-indent:-.25in;}
@list l0:level5
        {mso-level-number-format:alpha-lower;
        mso-level-tab-stop:none;
        mso-level-number-position:left;
        text-indent:-.25in;}
@list l0:level6
        {mso-level-number-format:roman-lower;
        mso-level-tab-stop:none;
        mso-level-number-position:right;
        text-indent:-9.0pt;}
@list l0:level7
        {mso-level-tab-stop:none;
        mso-level-number-position:left;
        text-indent:-.25in;}
@list l0:level8
        {mso-level-number-format:alpha-lower;
        mso-level-tab-stop:none;
        mso-level-number-position:left;
        text-indent:-.25in;}
@list l0:level9
        {mso-level-number-format:roman-lower;
        mso-level-tab-stop:none;
        mso-level-number-position:right;
        text-indent:-9.0pt;}
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:"Calibri",sans-serif;color:#1F497D">Hi Chris,<o:p></o:p></span></p>
<p class="MsoNormal"><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:"Calibri",sans-serif;color:#1F497D">Thanks for the examples, which are always appreciated! 
<o:p></o:p></span></p>
<p class="MsoNormal"><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:"Calibri",sans-serif;color:#1F497D">As to why we haven’t made this particular example into a report, that reason is threefold:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l0 level1 lfo1"><![if !supportLists]><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><span style="mso-list:Ignore">1.<span style="font:7.0pt "Times New Roman"">      
</span></span></span><![endif]><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">We just (finally!) upgraded to version 1.4.2, so Jasper reports are now (almost) an option for us.<o:p></o:p></span></p>
<p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l0 level1 lfo1"><![if !supportLists]><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><span style="mso-list:Ignore">2.<span style="font:7.0pt "Times New Roman"">      
</span></span></span><![endif]><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">We don’t have any reports working in our server environment just yet (and I’m outside of that work, so I’m not entirely sure what the holdup is there). 
 I do have the Jasper reports, both packaged and custom, working fine on a local machine, though, so that roadblock should be addressed…. eventually.<o:p></o:p></span></p>
<p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l0 level1 lfo1"><![if !supportLists]><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><span style="mso-list:Ignore">3.<span style="font:7.0pt "Times New Roman"">      
</span></span></span><![endif]><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">The other reason is because I don’t know of a documented way yet to pass parameters to newly-created reports.  The only parameters currently passed
 in the reports module are contained in the last 3 reports (last in the list of reports, since I believe that these 3 reports were actually the first available in a previous release), which are run completely within ASpace, using the API to get data out, and
 not with Jasper, right?  I also haven’t heard of anyone who has those last 3 API reports set up correctly in version 1.4.2 (but I could get the Jasper reports to run fine, on a fresh, local install at least).  There was another thread on the listserv about
 those 3 reports, but I don’t know if a resolution was provided.  And without being able to pass those date parameters for this specific report, we need to do run them outside of the ASpace application for the time being.  I also got an error while trying to
 run one of those 3 API reports on test.aspace, <a href="http://test.archivesspace.org/jobs/30">
http://test.archivesspace.org/jobs/30</a>, and ditto (although a different error), when trying to run things on the sandbox,
<a href="http://sandbox.archivesspace.org/reports">http://sandbox.archivesspace.org/reports</a>
<o:p></o:p></span></p>
<p class="MsoNormal"><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:"Calibri",sans-serif;color:#1F497D">I really appreciate all of the other tips, and at some point I’ll go through those examples and experiment with a few other options since I really would like
 to do be able to do this reporting with the API in addition to Jasper.<o:p></o:p></span></p>
<p class="MsoNormal"><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:"Calibri",sans-serif;color:#1F497D">All that said, the feedback I still keep hearing from our users, at least (and at least one other member of the Report subteam) is that they want to be able to
 take a query from their advanced search, and then export that data.  I still see a need for more detailed, PDF-style reports for those annual reporting needs (and Jasper seems a good fit to me for that, since it’s open-source), but there’s also the more immediate
 need of the daily user – and often those users just want to get some data out of the application, quickly, for whatever reason.<o:p></o:p></span></p>
<p class="MsoNormal"><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:"Calibri",sans-serif;color:#1F497D">Mark<o:p></o:p></span></p>
<p class="MsoNormal"><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:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<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 [mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org]
<b>On Behalf Of </b>Chris Fitzpatrick<br>
<b>Sent:</b> Thursday, January 21, 2016 12:02 PM<br>
<b>To:</b> Archivesspace Users Group<br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Reporting update request<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div id="divtagdefaultwrapper">
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">Hi Mark,<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">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?
<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">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.
<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">The query :<o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__sandbox.archivesspace.org_advanced-5Fsearch-3Fadvanced-3Dtrue-26dop1-3Dgreater-5Fthan-26dop2-3Dlesser-5Fthan-26f0-3Dkeyword-26f1-3Dcreate-5Ftime-26f2-3Dcreate-5Ftime-26f3-3Dsuppressed-26filter-5Fterm-255B-255D-3D-257B-2522primary-5Ftype-2522-253A-2522accession-2522-257D-26op1-3DAND-26op2-3DAND-26op3-3DAND-26t0-3Dtext-26t1-3Ddate-26t2-3Ddate-26t3-3Dboolean-26v0-3Dpape-252A-26v1-3D2015-2D06-2D30-26v2-3D2016-2D07-2D01-26v3-3Dfalse&d=AwMF-g&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=s7ciGQfUJeaV_ryx908hbeXDoU9aqDwDN0Z0VbfsJ3Y&m=hFfmAru0om87a7nxCojHz0OfAx01FLvwPsPBmA-ufDI&s=STagCl1jnT8OQFR5iqydW9RbBmbfdyI17QWX3dyCEEM&e=" title="Cmd&#43;Click or tap to follow the link" id="LPlnk772638"><span style="color:#0563C1">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</span></a>,</span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">Essential is just passed to Solr as:
<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__localhost-3A8090_collection1_select-3Fq-3D-2528-2528-2528fullrecord-3A-2528pape-2A-2529-26-2343-3BAND-26-2343-3Bcreate-5Ftime-3A-5B2015-2D06-2D30T00-3A00-3A00Z-252B1DAY-26-2343-3BTO-26-2343-3B-2A-5D-2529-26-2343-3BAND-26-2343-3Bcreate-5Ftime-3A-5B-2A-26-2343-3BTO-26-2343-3B2016-2D07-2D01T00-3A00-3A00Z-2D1MILLISECOND-5D-2529-26-2343-3BAND-26-2343-3Bsuppressed-3A-2528false-2529-2529-26facet.limit-3D100-26facet.field-3Dprimary-5Ftype-26facet.field-3Dcreators-26facet.field-3Dsubjects-26start-3D0-26fq-3Drepository-3A-2522_repositories_2-2522-26-2343-3BOR-26-2343-3Brepository-3Aglobal-26fq-3D-2Dexclude-5Fby-5Fdefault-3Atrue-26sort-3D-26rows-3D10-26wt-3Djson-26facet-3Dtrue&d=AwMF-g&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=s7ciGQfUJeaV_ryx908hbeXDoU9aqDwDN0Z0VbfsJ3Y&m=hFfmAru0om87a7nxCojHz0OfAx01FLvwPsPBmA-ufDI&s=zo_glrEEnRPys-2BJRQlvv_hVfCkyDREu3DGLo76EOc&e=" title="Cmd&#43;Click or tap to follow the link" id="LPlnk689583">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><o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">All you have to do is change the wt ( response format ) to csv and the rows to something like 100000.<br>
<a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__localhost-3A8090_collection1_select-3Fq-3D-2528-2528-2528fullrecord-3A-2528pape-2A-2529-26-2343-3BAND-26-2343-3Bcreate-5Ftime-3A-5B2015-2D06-2D30T00-3A00-3A00Z-252B1DAY-26-2343-3BTO-26-2343-3B-2A-5D-2529-26-2343-3BAND-26-2343-3Bcreate-5Ftime-3A-5B-2A-26-2343-3BTO-26-2343-3B2016-2D07-2D01T00-3A00-3A00Z-2D1MILLISECOND-5D-2529-26-2343-3BAND-26-2343-3Bsuppressed-3A-2528false-2529-2529-26facet.limit-3D100-26facet.field-3Dprimary-5Ftype-26facet.field-3Dcreators-26facet.field-3Dsubjects-26start-3D0-26fq-3Drepository-3A-2522_repositories_2-2522-26-2343-3BOR-26-2343-3Brepository-3Aglobal-26rows-3D10000-26wt-3Dcsv&d=AwMF-g&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=s7ciGQfUJeaV_ryx908hbeXDoU9aqDwDN0Z0VbfsJ3Y&m=hFfmAru0om87a7nxCojHz0OfAx01FLvwPsPBmA-ufDI&s=Et96aZ2Ua3ALDNxyIZsgBm-kVoX6rEBQwi6TQ54p64E&e=" id="LPlnk75862">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><o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">( you can drop the facet stuff, since you're not needing to display that ).<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">Solr query syntax is pretty
<a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__wiki.apache.org_solr_SolrQuerySyntax&d=AwMF-g&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=s7ciGQfUJeaV_ryx908hbeXDoU9aqDwDN0Z0VbfsJ3Y&m=hFfmAru0om87a7nxCojHz0OfAx01FLvwPsPBmA-ufDI&s=S3XIHi0sbPjFlieRfz5Q7Ym0oME64mWfdp3UbXObfHc&e=">
well documented. </a><o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">And there's the Solr control panel that is available at port :8090 .
<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">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. <o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">For Solr search, the log will look like :<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">INFO: [collection1] webapp= path=/select params={ ....<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">Take whats in params ( it'll start with a ?q= ) and just past that into
<a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__your.aspace.org-3A8090_collection1_select-3Fq&d=AwMF-g&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=s7ciGQfUJeaV_ryx908hbeXDoU9aqDwDN0Z0VbfsJ3Y&m=hFfmAru0om87a7nxCojHz0OfAx01FLvwPsPBmA-ufDI&s=oFw_iB0KZIWxOjRQ8dEr58D1YjEQ36YNe_w1oAArdKM&e=" id="LPlnk205982">
http://your.aspace.org:8090/collection1/select?q</a>......<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">Make sense?
<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">b,chris.<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<div id="Signature">
<div name="divtagdefaultwrapper">
<div>
<div>
<p class="MsoNormal" style="background:white"><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 href="http://archivesspace.org/">http://archivesspace.org/</a><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt;background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<div>
<div class="MsoNormal" align="center" style="text-align:center;background:white">
<span style="font-family:"Calibri",sans-serif;color:black">
<hr size="2" width="98%" align="center">
</span></div>
<div id="divRplyFwdMsg">
<p class="MsoNormal" style="background:white"><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 href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
 on behalf of Custer, Mark <<a href="mailto:mark.custer@yale.edu">mark.custer@yale.edu</a>><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</span><span style="font-family:"Calibri",sans-serif;color:black">
<o:p></o:p></span></p>
<div>
<p class="MsoNormal" style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Chris,</span><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><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><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p style="margin-left:.5in;text-indent:-.25in;background:white"><span style="font-size:11.0pt;font-family:Symbol;color:#1F497D">·</span><span style="font-size:7.0pt;color:#1F497D">        
</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><span style="color:black"><o:p></o:p></span></p>
<p style="margin-left:.5in;text-indent:-.25in;background:white"><span style="font-size:11.0pt;font-family:Symbol;color:#1F497D">·</span><span style="font-size:7.0pt;color:#1F497D">        
</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 href="https://urldefense.proofpoint.com/v2/url?u=http-3A__sandbox.archivesspace.org_advanced-5Fsearch-3Fadvanced-3Dtrue-26dop1-3Dgreater-5Fthan-26dop2-3Dlesser-5Fthan-26f0-3Dkeyword-26f1-3Dcreate-5Ftime-26f2-3Dcreate-5Ftime-26f3-3Dsuppressed-26filter-5Fterm-255B-255D-3D-257B-2522primary-5Ftype-2522-253A-2522accession-2522-257D-26op1-3DAND-26op2-3DAND-26op3-3DAND-26t0-3Dtext-26t1-3Ddate-26t2-3Ddate-26t3-3Dboolean-26v0-3Dpape-252A-26v1-3D2015-2D06-2D30-26v2-3D2016-2D07-2D01-26v3-3Dfalse&d=AwMF-g&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=s7ciGQfUJeaV_ryx908hbeXDoU9aqDwDN0Z0VbfsJ3Y&m=hFfmAru0om87a7nxCojHz0OfAx01FLvwPsPBmA-ufDI&s=STagCl1jnT8OQFR5iqydW9RbBmbfdyI17QWX3dyCEEM&e=" id="LPlnk772638">
<span style="color:#0563C1">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</span></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><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><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><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><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><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">select value as 'Accession type'</span><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">, COUNT(*) as 'Total accessions measured in linear feet'</span><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">, ROUND(SUM(extent.number), 2) as 'Linear feet'</span><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">from accession</span><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">left join extent on accession.id = extent.accession_id</span><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><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><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">where
</span><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">(extent_type_id IN (select id</span><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">from enumeration_value</span><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">where LOWER(value) like '%linear%'))</span><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">and repo_id = 11 #hardcoded value for now</span><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">and accession.accession_date >= '20151001' #change dates as needed</span><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">and accession.accession_date <= '20151231'</span><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">group by acquisition_type_id;</span><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Mark</span><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><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><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p style="background:white"><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 href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> [<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org</a>]
<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><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
<p style="background:white"><span style="color:black"> <o:p></o:p></span></p>
<div id="divtagdefaultwrapper">
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></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?
<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">b,chris.
<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
<div id="Signature">
<div name="divtagdefaultwrapper">
<div>
<div>
<p style="background:white"><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 href="https://urldefense.proofpoint.com/v2/url?u=http-3A__archivesspace.org_&d=AwMF-g&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=s7ciGQfUJeaV_ryx908hbeXDoU9aqDwDN0Z0VbfsJ3Y&m=hFfmAru0om87a7nxCojHz0OfAx01FLvwPsPBmA-ufDI&s=EMHRiAuQtK1oZMntaPct5n3BJt9m21J-0lQxBLVDJpc&e="><span style="color:#0563C1">http://archivesspace.org/</span></a></span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
<p style="background:white;background-attachment:scroll;background-position-x:0%;background-position-y:0%">
<span style="font-family:"Calibri",sans-serif;color:black"> </span><span style="color:black"><o:p></o:p></span></p>
<div>
<div class="MsoNormal" align="center" style="text-align:center;background:white">
<span style="font-family:"Calibri",sans-serif;color:black">
<hr size="2" width="98%" align="center">
</span></div>
<div id="divRplyFwdMsg">
<p style="background:white"><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 href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org"><span style="color:#0563C1">archivesspace_users_group-bounces@lyralists.lyrasis.org</span></a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org"><span style="color:#0563C1">archivesspace_users_group-bounces@lyralists.lyrasis.org</span></a>>
 on behalf of Carll, Johanna <<a href="mailto:jcarll@radcliffe.harvard.edu"><span style="color:#0563C1">jcarll@radcliffe.harvard.edu</span></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><span style="color:black"><o:p></o:p></span></p>
<div>
<p style="background:white;background-attachment:scroll;background-position-x:0%;background-position-y:0%">
<span style="font-family:"Calibri",sans-serif;color:black"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">Hi all<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></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-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:#333333;background:white"> </span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></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-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">Thanks<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">Johanna<o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black"> </span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black"> </span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></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 href="mailto:jcarll@radcliffe.harvard.edu"><span style="color:#0563C1">jcarll@radcliffe.harvard.edu</span></a></span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">
</span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black"> </span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>