<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Is it possible that your database was restored from a backup or that you created your database elsewhere and then imported it into MySQL? If so, you may simply be missing the stored procedures the Jasper reports rely on. There is a PR concerning this issue here:<div class=""><br class=""></div><div class=""><a href="https://github.com/archivesspace/archivesspace/pull/244" class="">https://github.com/archivesspace/archivesspace/pull/244</a></div><div class=""><br class=""></div><div class="">Brian</div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""><div><blockquote type="cite" class=""><div class="">On Aug 7, 2015, at 5:49 AM, Chris Fitzpatrick <<a href="mailto:Chris.Fitzpatrick@lyrasis.org" class="">Chris.Fitzpatrick@lyrasis.org</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div id="divtagdefaultwrapper" style="font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; font-size: 12pt; background-color: rgb(255, 255, 255); font-family: Calibri, Arial, Helvetica, sans-serif;" class=""><div style="margin-top: 0px; margin-bottom: 0px;" class=""><br class="Apple-interchange-newline"><br class=""></div><div style="margin-top: 0px; margin-bottom: 0px;" class="">Hi Emma,</div><div style="margin-top: 0px; margin-bottom: 0px;" class=""><br class=""></div><div style="margin-top: 0px; margin-bottom: 0px;" class="">Can you look at what's being output into the log? </div><div style="margin-top: 0px; margin-bottom: 0px;" class=""><br class=""></div><div style="margin-top: 0px; margin-bottom: 0px;" class="">The easiest way to see what the report is doing is to look at the Jasper XML, which you can see here =><a title="Cmd+Click or tap to follow the link" id="LPlnk954489" href="https://github.com/archivesspace/archivesspace/blob/master/reports/Accessions/AccessionsUnprocessedReport/AccessionsUnprocessedReport.jrxml#L20-L37" class="">https://github.com/archivesspace/archivesspace/blob/master/reports/Accessions/AccessionsUnprocessedReport/AccessionsUnprocessedReport.jrxml#L20-L37</a></div><div style="margin-top: 0px; margin-bottom: 0px;" class=""><br class=""></div><div style="margin-top: 0px; margin-bottom: 0px;" class="">The basic SQL query is defined in the <query> tag, with the formatting happening below. You can edit this file to fit your needs, then restart ASpace to have it recompiled. </div><div style="margin-top: 0px; margin-bottom: 0px;" class=""><br class=""></div><div style="margin-top: 0px; margin-bottom: 0px;" class="">b,chris.<span class="Apple-converted-space"> </span><br class=""></div><div style="margin-top: 0px; margin-bottom: 0px;" class=""><br class=""></div><div id="Signature" class=""><div name="divtagdefaultwrapper" style="font-family: Calibri, Arial, Helvetica, sans-serif; margin: 0px;" class=""><div class="BodyFragment"><font size="2" class="">Chris Fitzpatrick | Developer, ArchivesSpace<br class="">Skype: chrisfitzpat | Phone: 918.236.6048<br class=""><a href="http://archivesspace.org/" class="">http://archivesspace.org/</a><br class=""></font></div></div></div><br class=""><br class=""><div style="" class=""><hr tabindex="-1" style="display: inline-block; width: 571.328125px;" class=""><div id="divRplyFwdMsg" dir="ltr" class=""><font face="Calibri, sans-serif" style="font-size: 11pt;" class=""><b class="">From:</b><span class="Apple-converted-space"> </span><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" class="">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" class="">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>> on behalf of Emma Jolley <<a href="mailto:EJOLLEY@nla.gov.au" class="">EJOLLEY@nla.gov.au</a>><br class=""><b class="">Sent:</b><span class="Apple-converted-space"> </span>Friday, August 7, 2015 7:13 AM<br class=""><b class="">To:</b><span class="Apple-converted-space"> </span>Archivesspace Users Group (<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" class="">archivesspace_users_group@lyralists.lyrasis.org</a>)<br class=""><b class="">Subject:</b><span class="Apple-converted-space"> </span>Re: [Archivesspace_Users_Group] Problems with ASpace reports</font><div class=""> </div></div><div class=""><div class=""><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class="">Hi Chris</span></div><p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class=""> </span></p><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class="">We have had the same issues as Robin with the reports. We have tried to implement your suggested solutions below but now received the following error message which I’ve copied below. Any advice on this?</span></div><p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class=""> </span></p><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class="">In addition, I have asked previously but have never received an answer – I wonder if there is any documentation on what criteria the reports use to identify records that meet the nominated criteria. For example what fields is used to indicate an unprocessed Accession and what field is used to indicate an uncatalogued accession?</span></div><p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class=""> </span></p><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class="">Many thanks</span></div><p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class=""> </span></p><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class="">Emma</span></div><p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class=""> </span></p><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;" class=""><span id="cid:image007.png@01D0D122.90592940"><image007.png></span><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);" class=""></span></div><div class=""><p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;" class=""><span style="font-size: 10.5pt; font-family: Calibri, sans-serif;" class=""> </span></p></div><div class=""><div class=""><p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;" class=""><span style="font-size: 10pt; font-family: 'Segoe UI', sans-serif; color: rgb(31, 73, 125);" class=""> </span><span style="color: rgb(31, 73, 125);" class=""></span></p><div class=""><div style="border-style: solid none none; border-top-color: rgb(181, 196, 223); border-top-width: 1pt; padding: 3pt 0cm 0cm;" class=""><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;" class=""><b class=""><span lang="EN-US" style="font-size: 10pt; font-family: Tahoma, sans-serif;" class="">From:</span></b><span lang="EN-US" style="font-size: 10pt; font-family: Tahoma, sans-serif;" class=""><span class="Apple-converted-space"> </span><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" style="color: blue; text-decoration: underline;" class="">archivesspace_users_group-bounces@lyralists.lyrasis.org</a><span class="Apple-converted-space"> </span>[<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" style="color: blue; text-decoration: underline;" class="">mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org</a>]<span class="Apple-converted-space"> </span><b class="">On Behalf Of<span class="Apple-converted-space"> </span></b>Chris Fitzpatrick<br class=""><b class="">Sent:</b><span class="Apple-converted-space"> </span>Thursday, 6 August 2015 9:16 PM<br class=""><b class="">To:</b><span class="Apple-converted-space"> </span>Archivesspace Users Group<br class=""><b class="">Cc:</b><span class="Apple-converted-space"> </span>Zalduendo, Ines; Wendler, Robin King; Della Monica, Ilaria<br class=""><b class="">Subject:</b><span class="Apple-converted-space"> </span>Re: [Archivesspace_Users_Group] Problems with ASpace reports</span><span style="" class=""></span></div></div></div><p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;" class=""><span style="" class=""> </span></p><div id="divtagdefaultwrapper" class=""><p style="margin-top: 0px; margin-bottom: 0px; background-color: white; background-position: initial initial; background-repeat: initial initial;" class=""><span style="font-family: Calibri, sans-serif;" class=""> </span><span style="" class=""></span></p><p style="margin-top: 0px; margin-bottom: 0px; background-color: white; background-position: initial initial; background-repeat: initial initial;" class=""><span style="font-family: Calibri, sans-serif;" class=""> </span><span style="" class=""></span></p><div style="margin-top: 0px; margin-bottom: 0px; background-color: white;" class=""><span style="font-family: Calibri, sans-serif;" class="">Hi Robin,</span><span style="" class=""></span></div><p style="margin-top: 0px; margin-bottom: 0px; background-color: white; background-position: initial initial; background-repeat: initial initial;" class=""><span style="font-family: Calibri, sans-serif;" class=""> </span><span style="" class=""></span></p><div style="margin-top: 0px; margin-bottom: 0px; background-color: white;" class=""><span style="font-family: Calibri, sans-serif;" class="">So, first you need to make sure you compiled your jasper reports on startup. To do this, edit the config.rb file to have:</span><span style="" class=""></span></div><div style="margin-top: 0px; margin-bottom: 0px; background-color: white;" class=""><span class=""><span style="font-family: Calibri, sans-serif;" class="">AppConfig</span></span><span style="font-family: Calibri, sans-serif;" class="">[<span class="">:compile_jasper</span>]<span class="Apple-converted-space"> </span><span class="">=</span><span class="Apple-converted-space"> </span><span class="">true</span></span><span style="" class=""></span></div><p style="margin-top: 0px; margin-bottom: 0px; background-color: white; background-position: initial initial; background-repeat: initial initial;" class=""><span style="font-family: Calibri, sans-serif;" class=""> </span><span style="" class=""></span></p><div style="margin-top: 0px; margin-bottom: 0px; background-color: white;" class=""><span style="font-family: Calibri, sans-serif;" class="">and restart ASpace.</span><span style="" class=""></span></div><p style="margin-top: 0px; margin-bottom: 0px; background-color: white; background-position: initial initial; background-repeat: initial initial;" class=""><span style="font-family: Calibri, sans-serif;" class=""> </span><span style="" class=""></span></p><p style="margin-top: 0px; margin-bottom: 0px; background-color: white; background-position: initial initial; background-repeat: initial initial;" class=""><span style="font-family: Calibri, sans-serif;" class=""> </span><span style="" class=""></span></p><div style="margin-top: 0px; margin-bottom: 0px; background-color: white;" class=""><span style="font-family: Calibri, sans-serif;" class="">This will compile the jasper jxml files ( which is most likely what's causing the "can't convert nil to String" errors)</span><span style="" class=""></span></div><p style="margin-top: 0px; margin-bottom: 0px; background-color: white; background-position: initial initial; background-repeat: initial initial;" class=""><span style="font-family: Calibri, sans-serif;" class=""> </span><span style="" class=""></span></p><div style="margin-top: 0px; margin-bottom: 0px; background-color: white;" class=""><span style="font-family: Calibri, sans-serif;" class="">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. </span><span style="" class=""></span></div><p style="margin-top: 0px; margin-bottom: 0px; background-color: white; background-position: initial initial; background-repeat: initial initial;" class=""><span style="font-family: Calibri, sans-serif;" class=""> </span><span style="" class=""></span></p><div style="margin-top: 0px; margin-bottom: 0px; background-color: white;" class=""><span style="font-family: Calibri, sans-serif;" class="">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<span class="Apple-converted-space"> </span><a href="http://community.jaspersoft.com/project/jaspersoft-studio" style="color: blue; text-decoration: underline;" class="">Jasper studio</a>. Just be sure to recompile your reports.</span><span style="" class=""></span></div><p style="margin-top: 0px; margin-bottom: 0px; background-color: white; background-position: initial initial; background-repeat: initial initial;" class=""><span style="font-family: Calibri, sans-serif;" class=""> </span><span style="" class=""></span></p><div style="margin-top: 0px; margin-bottom: 0px; background-color: white;" class=""><span style="font-family: Calibri, sans-serif;" class="">For the parameters, yes this feature is going to be included in a future release. I believe those labels are artifacts from AT. </span><span style="" class=""></span></div><p style="margin-top: 0px; margin-bottom: 0px; background-color: white; background-position: initial initial; background-repeat: initial initial;" class=""><span style="font-family: Calibri, sans-serif;" class=""> </span><span style="" class=""></span></p><div style="margin-top: 0px; margin-bottom: 0px; background-color: white;" class=""><span style="font-family: Calibri, sans-serif;" class="">best, Chris. </span><span style="" class=""></span></div><p style="margin-top: 0px; margin-bottom: 0px; background-color: white; background-position: initial initial; background-repeat: initial initial;" class=""><span style="font-family: Calibri, sans-serif;" class=""> </span><span style="" class=""></span></p><p style="margin-top: 0px; margin-bottom: 0px; background-color: white; background-position: initial initial; background-repeat: initial initial;" class=""><span style="font-family: Calibri, sans-serif;" class=""> </span><span style="" class=""></span></p><div id="Signature" class=""><div name="divtagdefaultwrapper" class=""><div class=""><div class=""><div style="margin: 0cm 0cm 0.0001pt; background-image: none; background-attachment: scroll; background-color: white; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="font-size: 10pt; font-family: Calibri, sans-serif;" class="">Chris Fitzpatrick | Developer, ArchivesSpace<br class="">Skype: chrisfitzpat | Phone: 918.236.6048<br class=""><a href="http://archivesspace.org/" style="color: blue; text-decoration: underline;" class="">http://archivesspace.org/</a></span><span style="" class=""></span></div></div></div></div></div><p style="margin: 0cm 0cm 0.0001pt; background-image: none; background-attachment: scroll; background-color: white; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="font-family: Calibri, sans-serif;" class=""> </span><span style="" class=""></span></p><div class=""><div align="center" style="text-align: center; background-image: none; background-attachment: scroll; background-color: white; margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="font-family: Calibri, sans-serif;" class=""><hr align="center" size="2" width="98%" class=""></span></div><div id="divRplyFwdMsg" class=""><div style="margin: 0cm 0cm 0.0001pt; background-image: none; background-attachment: scroll; background-color: white; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><b class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;" class="">From:</span></b><span style="font-size: 11pt; font-family: Calibri, sans-serif;" class=""><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" style="color: blue; text-decoration: underline;" class="">archivesspace_users_group-bounces@lyralists.lyrasis.org</a><span class="Apple-converted-space"> </span><<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" style="color: blue; text-decoration: underline;" class="">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>> on behalf of McElheny, Robin G. <<a href="mailto:robin_mcelheny@harvard.edu" style="color: blue; text-decoration: underline;" class="">robin_mcelheny@harvard.edu</a>><br class=""><b class="">Sent:</b><span class="Apple-converted-space"> </span>Wednesday, August 5, 2015 5:55 PM<br class=""><b class="">To:</b><span class="Apple-converted-space"> </span>Archivesspace Users Group<br class=""><b class="">Cc:</b><span class="Apple-converted-space"> </span>Zalduendo, Ines; Wendler, Robin King; Della Monica, Ilaria<br class=""><b class="">Subject:</b><span class="Apple-converted-space"> </span>[Archivesspace_Users_Group] Problems with ASpace reports</span><span style="" class=""></span></div><div class=""><p style="margin: 0cm 0cm 0.0001pt; background-image: none; background-attachment: scroll; background-color: white; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="font-family: Calibri, sans-serif;" class=""> </span><span style="" class=""></span></p></div></div><div class=""><div class=""><div style="margin-top: 0px; margin-bottom: 0px; line-height: 18.399999618530273px; background-color: white;" class=""><span style="font-size: 11pt; line-height: 16.866666793823242px; font-family: Calibri, sans-serif;" class="">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.</span><span style="" class=""></span></div><div style="margin-top: 0px; margin-bottom: 0px; line-height: 18.399999618530273px; background-color: white;" class=""><span style="font-size: 11pt; line-height: 16.866666793823242px; font-family: Calibri, sans-serif;" class="">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?</span><span style="" class=""></span></div><div style="margin-top: 0px; margin-bottom: 0px; line-height: 18.399999618530273px; background-color: white;" class=""><span style="font-size: 11pt; line-height: 16.866666793823242px; font-family: Calibri, sans-serif;" class="">Record selection issues:</span><span style="" class=""></span></div><ul type="disc" style="margin-bottom: 0cm;" class=""><li style="line-height: 18.399999618530273px; background-image: none; background-attachment: scroll; background-color: white; margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="font-family: Calibri, sans-serif;" class="">The Accessions Acquired and Accessions Production reports supposedly allow for specified time periods, but no date parameters show up in the report user interface.</span></li></ul><div style="margin: 0cm 0cm 0.0001pt; line-height: 18.399999618530273px; background-image: none; background-attachment: scroll; background-color: white; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="" class=""><image008.jpg></span></div><p style="margin: 0cm 0cm 0.0001pt; line-height: 18.399999618530273px; background-image: none; background-attachment: scroll; background-color: white; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="" class=""> </span></p><ul type="disc" style="margin-bottom: 0cm;" class=""><li style="line-height: 18.399999618530273px; background-image: none; background-attachment: scroll; background-color: white; margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="font-family: Calibri, sans-serif;" class="">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?</span></li></ul><p style="margin-top: 0px; margin-bottom: 0px; line-height: 18.399999618530273px; background-color: white; background-position: initial initial; background-repeat: initial initial;" class=""><span style="font-size: 11pt; line-height: 16.866666793823242px; font-family: Calibri, sans-serif;" class=""> </span><span style="" class=""></span></p><div style="margin-top: 0px; margin-bottom: 0px; line-height: 18.399999618530273px; background-color: white;" class=""><span style="font-size: 11pt; line-height: 16.866666793823242px; font-family: Calibri, sans-serif;" class="">Report format issues:</span><span style="" class=""></span></div><ul type="disc" style="margin-bottom: 0cm;" class=""><li style="line-height: 18.399999618530273px; background-image: none; background-attachment: scroll; background-color: white; margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="font-family: Calibri, sans-serif;" class="">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.</span></li></ul><p style="margin: 0cm 0cm 0.0001pt; line-height: 18.399999618530273px; background-image: none; background-attachment: scroll; background-color: white; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="" class=""> </span></p><ul type="disc" style="margin-bottom: 0cm;" class=""><li style="line-height: 18.399999618530273px; background-image: none; background-attachment: scroll; background-color: white; margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="font-family: Calibri, sans-serif;" class="">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"</span></li></ul><p style="margin: 0cm 0cm 0.0001pt; line-height: 18.399999618530273px; background-image: none; background-attachment: scroll; background-color: white; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="" class=""> </span></p><ul type="disc" style="margin-bottom: 0cm;" class=""><li style="line-height: 18.399999618530273px; background-image: none; background-attachment: scroll; background-color: white; margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="font-family: Calibri, sans-serif;" class="">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:</span></li></ul><p style="margin: 0cm 0cm 0.0001pt; line-height: 18.399999618530273px; background-image: none; background-attachment: scroll; background-color: white; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="" class=""> </span></p><div style="margin-top: 0px; margin-bottom: 0px; line-height: 18.399999618530273px; background-color: white;" class=""><span style="font-size: 11pt; line-height: 16.866666793823242px; font-family: Calibri, sans-serif;" class="">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,,,,:").</span><span style="" class=""></span></div><p style="margin-top: 0px; margin-bottom: 0px; line-height: 18.399999618530273px; background-color: white; background-position: initial initial; background-repeat: initial initial;" class=""><span style="font-size: 11pt; line-height: 16.866666793823242px; font-family: Calibri, sans-serif;" class=""> </span><span style="" class=""></span></p><div style="margin-top: 0px; margin-bottom: 0px; line-height: 18.399999618530273px; background-color: white;" class=""><span style="font-size: 11pt; line-height: 16.866666793823242px; font-family: Calibri, sans-serif;" class="">Here is a screen shot:</span><span style="" class=""></span></div><div style="margin-top: 0px; margin-bottom: 0px; line-height: 18.399999618530273px; background-color: white;" class=""><span style="font-size: 11pt; line-height: 16.866666793823242px; font-family: Calibri, sans-serif;" class=""><image009.jpg></span><span style="" class=""></span></div><ul type="disc" style="margin-bottom: 0cm;" class=""><li style="line-height: 18.399999618530273px; background-image: none; background-attachment: scroll; background-color: white; margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="font-family: Calibri, sans-serif;" class="">Here’s another example:</span></li></ul><div style="margin-top: 0px; margin-bottom: 0px; line-height: 18.399999618530273px; background-color: white;" class=""><span style="font-size: 11pt; line-height: 16.866666793823242px; font-family: Calibri, sans-serif;" class=""><image010.jpg></span><span style="" class=""></span></div><ul type="disc" style="margin-bottom: 0cm;" class=""><li style="line-height: 18.399999618530273px; background-image: none; background-attachment: scroll; background-color: white; margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="font-family: Calibri, sans-serif;" class="">In the case of an HTML report, it displays page footers – odd for online display.</span></li></ul><div style="margin-top: 0px; margin-bottom: 0px; line-height: 18.399999618530273px; background-color: white;" class=""><span style="font-size: 11pt; line-height: 16.866666793823242px; font-family: Calibri, sans-serif;" class=""><image011.jpg></span><span style="" class=""></span></div><p style="margin-top: 0px; margin-bottom: 0px; line-height: 18.399999618530273px; background-color: white; background-position: initial initial; background-repeat: initial initial;" class=""><span style="font-size: 11pt; line-height: 16.866666793823242px; font-family: Calibri, sans-serif;" class=""> </span><span style="" class=""></span></p><div style="margin-top: 0px; margin-bottom: 0px; line-height: 18.399999618530273px; background-color: white;" class=""><span style="font-size: 11pt; line-height: 16.866666793823242px; font-family: Calibri, sans-serif;" class="">Report failure/timeout:</span><span style="" class=""></span></div><ul type="disc" style="margin-bottom: 0cm;" class=""><li style="line-height: 18.399999618530273px; background-image: none; background-attachment: scroll; background-color: white; margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="font-family: Calibri, sans-serif;" class="">We encountered many failures.</span></li></ul><div style="margin: 0cm 0cm 0.0001pt; line-height: 18.399999618530273px; background-image: none; background-attachment: scroll; background-color: white; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="" class="">Example:</span></div><div style="margin: 0cm 0cm 0.0001pt; line-height: 18.399999618530273px; background-image: none; background-attachment: scroll; background-color: white; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="" class="">When we attempted to download an XLSX AccessionsAcquired report in the ArchivesSpace sandbox, we got the following message:</span></div><p style="margin: 0cm 0cm 0.0001pt; line-height: 18.399999618530273px; background-image: none; background-attachment: scroll; background-color: white; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="" class=""> </span></p><div style="margin: 0cm 0cm 0.0001pt; line-height: 18.399999618530273px; background-image: none; background-attachment: scroll; background-color: white; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="" class="">Internal Server Error (500)</span></div><div style="margin: 0cm 0cm 0.0001pt; line-height: 18.399999618530273px; background-image: none; background-attachment: scroll; background-color: white; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="" class="">Request Method: GET</span></div><div style="margin: 0cm 0cm 0.0001pt; line-height: 18.399999618530273px; background-image: none; background-attachment: scroll; background-color: white; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="" class="">Request URL: <span class="Apple-converted-space"> </span><a href="http://localhost:8089/repositories/4/reports/accessionsacquiredreport?lock_version=&format=xlsx" style="color: blue; text-decoration: underline;" class="">http://localhost:8089/repositories/4/reports/accessionsacquiredreport?lock_version=&format=xlsx</a></span></div><p style="margin: 0cm 0cm 0.0001pt; line-height: 18.399999618530273px; background-image: none; background-attachment: scroll; background-color: white; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="" class=""> </span></p><div style="margin: 0cm 0cm 0.0001pt; line-height: 18.399999618530273px; background-image: none; background-attachment: scroll; background-color: white; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="" class="">(TypeError) can't convert nil into String</span></div><p style="margin: 0cm 0cm 0.0001pt; line-height: 18.399999618530273px; background-image: none; background-attachment: scroll; background-color: white; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="" class=""> </span></p><div style="margin: 0cm 0cm 0.0001pt; line-height: 18.399999618530273px; background-image: none; background-attachment: scroll; background-color: white; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="" class="">You're seeing this error because you use JRuby::Rack::ErrorApp::ShowStatus.</span></div><p style="margin: 0cm 0cm 0.0001pt; line-height: 18.399999618530273px; background-image: none; background-attachment: scroll; background-color: white; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="" class=""> </span></p><div style="margin: 0cm 0cm 0.0001pt; line-height: 18.399999618530273px; background-image: none; background-attachment: scroll; background-color: white; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="" class="">Another example:</span></div><div style="margin-top: 0px; margin-bottom: 0px; line-height: 18.399999618530273px; background-color: white;" class=""><span style="font-size: 11pt; line-height: 16.866666793823242px; font-family: Calibri, sans-serif;" class=""><image012.jpg></span><span style="" class=""></span></div><ul type="disc" style="margin-bottom: 0cm;" class=""><li style="line-height: 18.399999618530273px; background-image: none; background-attachment: scroll; background-color: white; margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-position: 0% 0%; background-repeat: repeat repeat;" class=""><span style="font-family: Calibri, sans-serif;" class="">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.</span></li></ul><p style="margin-top: 0px; margin-bottom: 0px; background-color: white; background-position: initial initial; background-repeat: initial initial;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;" class=""> </span><span style="" class=""></span></p><p style="margin-top: 0px; margin-bottom: 0px; background-color: white; background-position: initial initial; background-repeat: initial initial;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;" class=""> </span><span style="" class=""></span></p><div style="margin-top: 0px; margin-bottom: 0px; background-color: white;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;" class="">Robin McElheny</span><span style="" class=""></span></div><div style="margin-top: 0px; margin-bottom: 0px; background-color: white;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;" class="">Associate University Archivist for Collections and Public Services</span><span style="" class=""></span></div><div style="margin-top: 0px; margin-bottom: 0px; background-color: white;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;" class="">Harvard University Archives</span><span style="" class=""></span></div><div style="margin-top: 0px; margin-bottom: 0px; background-color: white;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;" class="">Pusey Library</span><span style="" class=""></span></div><div style="margin-top: 0px; margin-bottom: 0px; background-color: white;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;" class="">Cambridge, MA 02138</span><span style="" class=""></span></div><div style="margin-top: 0px; margin-bottom: 0px; background-color: white;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;" class="">Email:<span class="Apple-converted-space"> </span><a href="mailto:robin_mcelheny@harvard.edu" style="color: blue; text-decoration: underline;" class="">robin_mcelheny@harvard.edu</a></span><span style="" class=""></span></div><div style="margin-top: 0px; margin-bottom: 0px; background-color: white;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;" class="">Phone: 617-495-2461</span><span style="" class=""></span></div><div style="margin-top: 0px; margin-bottom: 0px; background-color: white;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;" class="">Fax: 617-495-8011</span><span style="" class=""></span></div><p style="margin-top: 0px; margin-bottom: 0px; background-color: white; background-position: initial initial; background-repeat: initial initial;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif;" class=""> </span><span style="" class=""></span></p></div></div></div></div></div></div></div></div></div></div><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">_______________________________________________</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">Archivesspace_Users_Group mailing list</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class=""><a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" class="">Archivesspace_Users_Group@lyralists.lyrasis.org</a></span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class=""><a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" class="">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a></span></div></blockquote></div><br class=""></div></body></html>