<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 14 (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:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-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.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.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:1034187126;
mso-list-type:hybrid;
mso-list-template-ids:343843472 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l1
{mso-list-id:1364794285;
mso-list-type:hybrid;
mso-list-template-ids:746866338 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l1:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l1:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l1:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l1:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l1:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l1:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l1:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
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" style="margin-bottom:10.0pt;line-height:115%">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.<o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:10.0pt;line-height:115%">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?<o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:10.0pt;line-height:115%">Record selection issues:<o:p></o:p></p>
<ul style="margin-top:0in" type="disc">
<li class="MsoNormalCxSpMiddle" style="margin-bottom:10.0pt;mso-add-space:auto;line-height:115%;mso-list:l1 level1 lfo1">
The Accessions Acquired and Accessions Production reports supposedly allow for specified time periods, but no date parameters show up in the report user interface.<o:p></o:p></li></ul>
<p class="MsoNormalCxSpMiddle" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:10.0pt;margin-left:.5in;mso-add-space:auto;line-height:115%">
<img width="624" height="291" id="Picture_x0020_1" src="cid:image001.jpg@01D0CF75.A0567BD0"><o:p></o:p></p>
<p class="MsoNormalCxSpMiddle" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:10.0pt;margin-left:.5in;mso-add-space:auto;line-height:115%">
<o:p> </o:p></p>
<ul style="margin-top:0in" type="disc">
<li class="MsoNormalCxSpMiddle" style="margin-bottom:10.0pt;mso-add-space:auto;line-height:115%;mso-list:l1 level1 lfo1">
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?<o:p></o:p></li></ul>
<p class="MsoNormal" style="margin-bottom:10.0pt;line-height:115%"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:10.0pt;line-height:115%">Report format issues:<o:p></o:p></p>
<ul style="margin-top:0in" type="disc">
<li class="MsoNormalCxSpMiddle" style="margin-bottom:10.0pt;mso-add-space:auto;line-height:115%;mso-list:l1 level1 lfo1">
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.<o:p></o:p></li></ul>
<p class="MsoNormalCxSpMiddle" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:10.0pt;margin-left:.5in;mso-add-space:auto;line-height:115%">
<o:p> </o:p></p>
<ul style="margin-top:0in" type="disc">
<li class="MsoNormalCxSpMiddle" style="margin-bottom:10.0pt;mso-add-space:auto;line-height:115%;mso-list:l1 level1 lfo1">
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"<o:p></o:p></li></ul>
<p class="MsoNormalCxSpMiddle" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:10.0pt;margin-left:.5in;mso-add-space:auto;line-height:115%">
<o:p> </o:p></p>
<ul style="margin-top:0in" type="disc">
<li class="MsoNormalCxSpMiddle" style="margin-bottom:10.0pt;mso-add-space:auto;line-height:115%;mso-list:l1 level1 lfo1">
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:<o:p></o:p></li></ul>
<p class="MsoNormalCxSpMiddle" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:10.0pt;margin-left:.5in;mso-add-space:auto;line-height:115%">
<o:p> </o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:10.0pt;margin-left:.5in;line-height:115%">
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,,,,:").<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:10.0pt;margin-left:.5in;line-height:115%">
<o:p> </o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:10.0pt;margin-left:.5in;line-height:115%">
Here is a screen shot:<o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:10.0pt;line-height:115%"><img width="624" height="541" id="Picture_x0020_2" src="cid:image002.jpg@01D0CF75.A0567BD0"><o:p></o:p></p>
<ul style="margin-top:0in" type="disc">
<li class="MsoNormalCxSpMiddle" style="margin-bottom:10.0pt;mso-add-space:auto;line-height:115%;mso-list:l0 level1 lfo2">
Here’s another example:<o:p></o:p></li></ul>
<p class="MsoNormal" style="margin-bottom:10.0pt;line-height:115%"><img width="624" height="352" id="Picture_x0020_4" src="cid:image003.jpg@01D0CF75.A0567BD0"><o:p></o:p></p>
<ul style="margin-top:0in" type="disc">
<li class="MsoNormalCxSpMiddle" style="margin-bottom:10.0pt;mso-add-space:auto;line-height:115%;mso-list:l1 level1 lfo1">
In the case of an HTML report, it displays page footers – odd for online display.<o:p></o:p></li></ul>
<p class="MsoNormal" style="margin-bottom:10.0pt;line-height:115%"><img width="624" height="450" id="Picture_x0020_6" src="cid:image004.jpg@01D0CF75.A0567BD0" alt="htmlreport"><o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:10.0pt;line-height:115%"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:10.0pt;line-height:115%">Report failure/timeout:<o:p></o:p></p>
<ul style="margin-top:0in" type="disc">
<li class="MsoNormalCxSpMiddle" style="margin-bottom:10.0pt;mso-add-space:auto;line-height:115%;mso-list:l1 level1 lfo1">
We encountered many failures.<o:p></o:p></li></ul>
<p class="MsoNormalCxSpMiddle" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:10.0pt;margin-left:.5in;mso-add-space:auto;line-height:115%">
Example:<o:p></o:p></p>
<p class="MsoNormalCxSpMiddle" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:10.0pt;margin-left:.5in;mso-add-space:auto;line-height:115%">
When we attempted to download an XLSX AccessionsAcquired report in the ArchivesSpace sandbox, we got the following message:<o:p></o:p></p>
<p class="MsoNormalCxSpMiddle" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:10.0pt;margin-left:.5in;mso-add-space:auto;line-height:115%">
<o:p> </o:p></p>
<p class="MsoNormalCxSpMiddle" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:10.0pt;margin-left:1.0in;mso-add-space:auto;line-height:115%">
Internal Server Error (500)<o:p></o:p></p>
<p class="MsoNormalCxSpMiddle" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:10.0pt;margin-left:1.0in;mso-add-space:auto;line-height:115%">
Request Method: GET<o:p></o:p></p>
<p class="MsoNormalCxSpMiddle" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:10.0pt;margin-left:1.0in;mso-add-space:auto;line-height:115%">
Request URL: http://localhost:8089/repositories/4/reports/accessionsacquiredreport?lock_version=&format=xlsx<o:p></o:p></p>
<p class="MsoNormalCxSpMiddle" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:10.0pt;margin-left:1.0in;mso-add-space:auto;line-height:115%">
<o:p> </o:p></p>
<p class="MsoNormalCxSpMiddle" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:10.0pt;margin-left:1.0in;mso-add-space:auto;line-height:115%">
(TypeError) can't convert nil into String<o:p></o:p></p>
<p class="MsoNormalCxSpMiddle" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:10.0pt;margin-left:1.0in;mso-add-space:auto;line-height:115%">
<o:p> </o:p></p>
<p class="MsoNormalCxSpMiddle" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:10.0pt;margin-left:1.0in;mso-add-space:auto;line-height:115%">
You're seeing this error because you use JRuby::Rack::ErrorApp::ShowStatus.<o:p></o:p></p>
<p class="MsoNormalCxSpMiddle" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:10.0pt;margin-left:.5in;mso-add-space:auto;line-height:115%">
<o:p> </o:p></p>
<p class="MsoNormalCxSpMiddle" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:10.0pt;margin-left:.5in;mso-add-space:auto;line-height:115%">
Another example:<o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:10.0pt;line-height:115%"><img width="630" height="340" id="Picture_x0020_5" src="cid:image005.jpg@01D0CF75.A0567BD0"><o:p></o:p></p>
<ul style="margin-top:0in" type="disc">
<li class="MsoNormalCxSpMiddle" style="margin-bottom:10.0pt;mso-add-space:auto;line-height:115%;mso-list:l1 level1 lfo1">
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.<o:p></o:p></li></ul>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Robin McElheny<o:p></o:p></p>
<p class="MsoNormal">Associate University Archivist for Collections and Public Services<o:p></o:p></p>
<p class="MsoNormal">Harvard University Archives<o:p></o:p></p>
<p class="MsoNormal">Pusey Library<o:p></o:p></p>
<p class="MsoNormal">Cambridge, MA 02138<o:p></o:p></p>
<p class="MsoNormal">Email: robin_mcelheny@harvard.edu<o:p></o:p></p>
<p class="MsoNormal">Phone: 617-495-2461<o:p></o:p></p>
<p class="MsoNormal">Fax: 617-495-8011<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>