<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><br>
</p>
<p>Hi Robin,</p>
<p><br>
</p>
<p>So, first you need to make sure you compiled your jasper reports on startup. To do this, edit the config.rb file to have:</p>
<p><span class="pl-c1">AppConfig</span>[<span class="pl-c1">:compile_jasper</span>]
<span class="pl-k">=</span> <span class="pl-c1">true</span></p>
<p><br>
</p>
<p>and restart ASpace. </p>
<p><br>
</p>
<p><br>
</p>
<p>This will compile the jasper jxml files ( which is most likely what's causing the "can't convert nil to String" errors)</p>
<p><br>
</p>
<p>Also, you'll need to look at both your application and database server and make sure you're not running into a performance issue. Reports can hit the database really hard, so the timeout errors you're seeing could be the result of your server running out
of RAM. </p>
<p><br>
</p>
<p>In regards to the CSV and Excel and HTML files, yes I would say those are formatted rather poorly by default. You can edit this by modifing your Jasper reports using something like iReport or
<a href="http://community.jaspersoft.com/project/jaspersoft-studio">Jasper studio</a>. Just be sure to recompile your reports.</p>
<p><br>
</p>
<p>For the parameters, yes this feature is going to be included in a future release. I believe those labels are artifacts from AT. </p>
<p><br>
</p>
<p>best, Chris. <br>
</p>
<p><br>
<span class="pl-c1"></span></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 McElheny, Robin
G. <robin_mcelheny@harvard.edu><br>
<b>Sent:</b> Wednesday, August 5, 2015 5:55 PM<br>
<b>To:</b> Archivesspace Users Group<br>
<b>Cc:</b> Zalduendo, Ines; Wendler, Robin King; Della Monica, Ilaria<br>
<b>Subject:</b> [Archivesspace_Users_Group] Problems with ASpace reports</font>
<div> </div>
</div>
<div>
<div style="">
<p style="line-height: 115%; margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
At Harvard, we are having major problems with the reporting functionality in the latest ArchivesSpace release. We have tested the reports in our own installation and in the ASpace sandbox with very little success. See below for more details.</p>
<p style="line-height: 115%; margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
We didn’t see any issues in JIRA that reflects these problems. Has anyone else encountered them? If so, have you resolved them – and how?</p>
<p style="line-height: 115%; margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
Record selection issues:</p>
<ul style="margin-top: 0in; margin-bottom: 0in;" type="disc">
<li class="MsoNormalCxSpMiddle" style="margin-bottom:10.0pt; line-height:115%">The Accessions Acquired and Accessions Production reports supposedly allow for specified time periods, but no date parameters show up in the report user interface.</li></ul>
<p class="MsoNormalCxSpMiddle" style="margin-right:0in; margin-bottom:10.0pt; margin-left:.5in; line-height:115%">
<img style="-moz-user-select: none;" id="Picture_x0020_1" height="291" width="624" src="cid:image001.jpg@01D0CF75.A0567BD0"></p>
<p class="MsoNormalCxSpMiddle" style="margin-right:0in; margin-bottom:10.0pt; margin-left:.5in; line-height:115%">
</p>
<ul style="margin-top: 0in; margin-bottom: 0in;" type="disc">
<li class="MsoNormalCxSpMiddle" style="margin-bottom:10.0pt; line-height:115%">In other cases it is unclear how/where to select records for the report (e.g. Digital Object Record). No selection parameters appear in the report interface. Are we supposed to browse
records, then select them using the check boxes, then generate reports?</li></ul>
<p style="line-height: 115%; margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
</p>
<p style="line-height: 115%; margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
Report format issues:</p>
<ul style="margin-top: 0in; margin-bottom: 0in;" type="disc">
<li class="MsoNormalCxSpMiddle" style="margin-bottom:10.0pt; line-height:115%">In cases where we were able to download CSV and Excel reports (Accessions Cataloged, Accessions Deaccessions List, Accessions Inventory), we were unable to sort these reports because
the formatting appears to be frozen. The output of the report does not match the file type. It is like getting a static document layered on top of a spreadsheet, rather than an actual spreadsheet.</li></ul>
<p class="MsoNormalCxSpMiddle" style="margin-right:0in; margin-bottom:10.0pt; margin-left:.5in; line-height:115%">
</p>
<ul style="margin-top: 0in; margin-bottom: 0in;" type="disc">
<li class="MsoNormalCxSpMiddle" style="margin-bottom:10.0pt; line-height:115%">Xlsx downloads don't export uniform cell sizes, so Excel sorting returns a warning saying "this operation requires the merged cells to be identically sized"</li></ul>
<p class="MsoNormalCxSpMiddle" style="margin-right:0in; margin-bottom:10.0pt; margin-left:.5in; line-height:115%">
</p>
<ul style="margin-top: 0in; margin-bottom: 0in;" type="disc">
<li class="MsoNormalCxSpMiddle" style="margin-bottom:10.0pt; line-height:115%">In order for the Xlsx downloads to be useful, each field should be in a separate column to allow tallying and sorting, but the ASpace downloads don’t do this. Some examples:</li></ul>
<p class="MsoNormalCxSpMiddle" style="margin-right:0in; margin-bottom:10.0pt; margin-left:.5in; line-height:115%">
</p>
<p style="line-height: 115%; margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
In the case of the Accession Deaccession List Report, opening the CSV download in Excel resulted in a very messy, single column spreadsheet that broke data about one deaccesion across multiple rows. (Example: row 48= "Additional records of the League of Women
Voters (Cambridge, Mass.),,,,,,1376,,," and row 49 = ",Accession Date:,,05/01/1968,Extent:,1.00 Linear_feet,,,,:").</p>
<p style="line-height: 115%; margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
</p>
<p style="line-height: 115%; margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
Here is a screen shot:</p>
<p style="line-height: 115%; margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<img style="-moz-user-select: none;" id="Picture_x0020_2" height="541" width="624" src="cid:image002.jpg@01D0CF75.A0567BD0"></p>
<ul style="margin-top: 0in; margin-bottom: 0in;" type="disc">
<li class="MsoNormalCxSpMiddle" style="margin-bottom:10.0pt; line-height:115%">Here’s another example:</li></ul>
<p style="line-height: 115%; margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<img style="-moz-user-select: none;" id="Picture_x0020_4" height="352" width="624" src="cid:image003.jpg@01D0CF75.A0567BD0"></p>
<ul style="margin-top: 0in; margin-bottom: 0in;" type="disc">
<li class="MsoNormalCxSpMiddle" style="margin-bottom:10.0pt; line-height:115%">In the case of an HTML report, it displays page footers – odd for online display.</li></ul>
<p style="line-height: 115%; margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<img style="-moz-user-select: none;" id="Picture_x0020_6" alt="htmlreport" height="450" width="624" src="cid:image004.jpg@01D0CF75.A0567BD0"></p>
<p style="line-height: 115%; margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
</p>
<p style="line-height: 115%; margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
Report failure/timeout:</p>
<ul style="margin-top: 0in; margin-bottom: 0in;" type="disc">
<li class="MsoNormalCxSpMiddle" style="margin-bottom:10.0pt; line-height:115%">We encountered many failures.</li></ul>
<p class="MsoNormalCxSpMiddle" style="margin-right:0in; margin-bottom:10.0pt; margin-left:.5in; line-height:115%">
Example:</p>
<p class="MsoNormalCxSpMiddle" style="margin-right:0in; margin-bottom:10.0pt; margin-left:.5in; line-height:115%">
When we attempted to download an XLSX AccessionsAcquired report in the ArchivesSpace sandbox, we got the following message:</p>
<p class="MsoNormalCxSpMiddle" style="margin-right:0in; margin-bottom:10.0pt; margin-left:.5in; line-height:115%">
</p>
<p class="MsoNormalCxSpMiddle" style="margin-right:0in; margin-bottom:10.0pt; margin-left:1.0in; line-height:115%">
Internal Server Error (500)</p>
<p class="MsoNormalCxSpMiddle" style="margin-right:0in; margin-bottom:10.0pt; margin-left:1.0in; line-height:115%">
Request Method: GET</p>
<p class="MsoNormalCxSpMiddle" style="margin-right:0in; margin-bottom:10.0pt; margin-left:1.0in; line-height:115%">
Request URL: http://localhost:8089/repositories/4/reports/accessionsacquiredreport?lock_version=&format=xlsx</p>
<p class="MsoNormalCxSpMiddle" style="margin-right:0in; margin-bottom:10.0pt; margin-left:1.0in; line-height:115%">
</p>
<p class="MsoNormalCxSpMiddle" style="margin-right:0in; margin-bottom:10.0pt; margin-left:1.0in; line-height:115%">
(TypeError) can't convert nil into String</p>
<p class="MsoNormalCxSpMiddle" style="margin-right:0in; margin-bottom:10.0pt; margin-left:1.0in; line-height:115%">
</p>
<p class="MsoNormalCxSpMiddle" style="margin-right:0in; margin-bottom:10.0pt; margin-left:1.0in; line-height:115%">
You're seeing this error because you use JRuby::Rack::ErrorApp::ShowStatus.</p>
<p class="MsoNormalCxSpMiddle" style="margin-right:0in; margin-bottom:10.0pt; margin-left:.5in; line-height:115%">
</p>
<p class="MsoNormalCxSpMiddle" style="margin-right:0in; margin-bottom:10.0pt; margin-left:.5in; line-height:115%">
Another example:</p>
<p style="line-height: 115%; margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<img style="-moz-user-select: none;" id="Picture_x0020_5" height="340" width="630" src="cid:image005.jpg@01D0CF75.A0567BD0"></p>
<ul style="margin-top: 0in; margin-bottom: 0in;" type="disc">
<li class="MsoNormalCxSpMiddle" style="margin-bottom:10.0pt; line-height:115%">We were unable to generate any successful Resource reports. All attempts to download reports in any format resulted in “Waiting for (server)” messages with no results.</li></ul>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
Robin McElheny</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
Associate University Archivist for Collections and Public Services</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
Harvard University Archives</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
Pusey Library</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
Cambridge, MA 02138</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
Email: robin_mcelheny@harvard.edu</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
Phone: 617-495-2461</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
Fax: 617-495-8011</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
</p>
</div>
</div>
</div>
</div>
</body>
</html>