<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" id="owaParaStyle"></style>
</head>
<body class="" style="word-wrap:break-word" fpstyle="1" ocsi="0">
<div style="direction: ltr;font-family: Arial;color: #000000;font-size: 10pt;">(Lol...after this I won't...;) ) <span style="font-size: 10pt;">You're a lifesaver. I'll try it out (on a test database as always first) and let you know if we have any issues.</span>
<div>
<div><br>
</div>
<div>Thank you Brian for such a quick response!<br>
<div><br>
<div class="BodyFragment"><font size="2"><span style="font-size:10pt;">
<div class="PlainText">Thanks,<br>
Karrie</div>
<div class="PlainText"> <br>
“The views and opinions expressed in this message are my own and do not necessarily reflect the views and opinions of Stephen F. Austin State University, its Board of Regents, or the State of Texas.”<br>
</div>
</span></font></div>
</div>
<div style="font-family: Times New Roman; color: #000000; font-size: 16px">
<hr tabindex="-1">
<div id="divRpF524622" style="direction: ltr;"><font face="Tahoma" size="2" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org [archivesspace_users_group-bounces@lyralists.lyrasis.org] on behalf of Brian Hoffman [brianjhoffman@gmail.com]<br>
<b>Sent:</b> Tuesday, September 01, 2015 4:38 PM<br>
<b>To:</b> Archivesspace Users Group<br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Problems with ASpace reports<br>
</font><br>
</div>
<div></div>
<div>Hi Karrie,
<div class=""><br class="">
</div>
<div class="">Yes, as it happens I was dealing with the same issue today. You can install this plugin and it will bring back the stored procedures. Please test this on a copy of your database first!</div>
<div class=""><br class="">
</div>
<div class=""><a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_quoideneuf_aspace-5Fstored-5Fprocedures&d=AwMF-g&c=2X_btuPRWkGwRX26NHIotw&r=FD0Xci-wh01Dc1yt0aSp4ADMuu-zB2G2dpCCNNXfih0&m=5SbDCpus7oNyrgQO2oSCh7umQ6IpUlQMlLiH9uCaKBg&s=gkPtnseSEWZJpDATOpLSPz6liqFrVcYYgwdhx18o3Wk&e=" class="" target="_blank">https://github.com/quoideneuf/aspace_stored_procedures</a></div>
<div class=""><br class="">
</div>
<div class="">And I am obliged to say tsk tsk for doing find and replace on your sql dump but will leave it at that if you promise not to do it again!</div>
<div class=""><br class="">
</div>
<div class="">Brian</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
<div>
<blockquote type="cite" class="">
<div class="">On Sep 1, 2015, at 5:33 PM, Karrie L Roberson <<a href="mailto:robersonkl@sfasu.edu" class="" target="_blank">robersonkl@sfasu.edu</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div class="" 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; direction:ltr; font-family:Arial; font-size:10pt">
It returns "empty set". <span class="" style="font-size:10pt">Is there anything we can do to add those stored procedures back?</span>
<div class=""><br class="">
<div class="">We had to make some changes to the data that got carried over from the migration from Archon. :/<br class="">
<div class="">
<div class="">
<div class="BodyFragment"><font size="2" class=""><span class="" style="font-size:10pt">
<div class="PlainText"><br class="">
</div>
<div class="PlainText">Thanks,</div>
<div class="PlainText">Karrie</div>
</span></font></div>
</div>
<div class="" style="font-family:'Times New Roman'; font-size:16px">
<hr tabindex="-1" class="">
<div id="divRpF779671" class="" style="direction:ltr"><font face="Tahoma" size="2" class=""><b class="">From:</b><span class="Apple-converted-space"> </span><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" class="" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>
[<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" class="" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>] on behalf of Brian Hoffman [<a href="mailto:brianjhoffman@gmail.com" class="" target="_blank">brianjhoffman@gmail.com</a>]<br class="">
<b class="">Sent:</b><span class="Apple-converted-space"> </span>Tuesday, September 01, 2015 4:28 PM<br class="">
<b class="">To:</b><span class="Apple-converted-space"> </span>Archivesspace Users Group<br class="">
<b class="">Subject:</b><span class="Apple-converted-space"> </span>Re: [Archivesspace_Users_Group] Problems with ASpace reports<br class="">
</font><br class="">
</div>
<div class=""></div>
<div class="">Hi,
<div class=""><br class="">
</div>
<div class="">It sounds like you may have lost the mysql stored procedures that the reports require.</div>
<div class=""><br class="">
</div>
<div class="">What happens when you log in to mysql and type:</div>
<div class=""><br class="">
</div>
<div class="">> select name from mysql.proc</div>
<div class=""><br class="">
</div>
<div class="">?</div>
<div class=""><br class="">
</div>
<div class="">P.S. What caused you to dump the mysql file, edit it, and reload it? That is not something I recommend doing.</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
<div class="">
<blockquote type="cite" class="">
<div class="">On Sep 1, 2015, at 5:08 PM, Karrie L Roberson <<a href="mailto:robersonkl@sfasu.edu" class="" target="_blank">robersonkl@sfasu.edu</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div class="" 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; direction:ltr; font-family:Arial; font-size:10pt">
We're seeing the same type of messages as below with the messages that are seen below. Our error message is "<span class="" style="color:rgb(169,68,66); font-family:'Helvetica Neue',Helvetica,Arial,sans-serif; font-size:14px; line-height:20px; background-color:rgb(242,222,222)">ResourcesLocationsListReport
- net.sf.jasperreports.engine.JRException: Error executing SQL statement for : resourcesLocationsList</span>".
<div class="">
<div class=""><br class="">
</div>
<div class="">We edited the 'config.rb' file with the jasper reports uncommented, updated the 2 files in the PR issue mentioned below, and restarted Archivesspace.</div>
<div class=""><span class="" style="font-size:10pt"><br class="">
</span></div>
<div class=""><span class="" style="font-size:10pt">Just FYI: Weeks ago, we've done a command line mysqldump of the database without the "--routines" flag added (with ArchivesSpace shutdown), made some changes to the file and replaced the database with the
updated file.</span></div>
<div class="">
<div class="">
<div class=""><br class="">
<div class="BodyFragment"><font size="2" class=""><span class="" style="font-size:10pt">
<div class="PlainText">Thanks,<br class="">
Karrie </div>
<div class="PlainText"><br class="">
“The views and opinions expressed in this message are my own and do not necessarily reflect the views and opinions of Stephen F. Austin State University, its Board of Regents, or the State of Texas.”<br class="">
</div>
</span></font></div>
</div>
<div class="" style="font-family:'Times New Roman'; font-size:16px">
<hr tabindex="-1" class="">
<div id="divRpF559546" class="" style="direction:ltr"><font face="Tahoma" size="2" class=""><b class="">From:</b><span class="Apple-converted-space"> </span><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" class="" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a><span class="Apple-converted-space"> </span>[<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" class="" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>]
on behalf of Emma Jolley [<a href="mailto:EJOLLEY@nla.gov.au" class="" target="_blank">EJOLLEY@nla.gov.au</a>]<br class="">
<b class="">Sent:</b><span class="Apple-converted-space"> </span>Sunday, August 30, 2015 11:57 PM<br class="">
<b class="">To:</b><span class="Apple-converted-space"> </span>Archivesspace Users Group<br class="">
<b class="">Subject:</b><span class="Apple-converted-space"> </span>Re: [Archivesspace_Users_Group] Problems with ASpace reports<br class="">
</font><br class="">
</div>
<div class=""></div>
<div class="">
<div class="WordSection1">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(31,73,125)">Hi</span></div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(31,73,125)"> </span></p>
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(31,73,125)">Apologies for the long delay in replying. I can send you a MySQL dump of the AS database – however there is a lot of confidential acquisition information in the database.
Are there any procedures for confidential information?</span></div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(31,73,125)"> </span></p>
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(31,73,125)">Thanks</span></div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(31,73,125)"> </span></p>
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(31,73,125)">Emma</span></div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(31,73,125)"> </span></p>
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<b class=""><span lang="EN-US" class="" style="font-size:10pt; font-family:Tahoma,sans-serif">From:</span></b><span lang="EN-US" class="" style="font-size:10pt; font-family:Tahoma,sans-serif"><span class="Apple-converted-space"> </span><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" class="" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a><span class="Apple-converted-space"> </span>[<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" class="" target="_blank">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>Nathan Stevens<br class="">
<b class="">Sent:</b><span class="Apple-converted-space"> </span>Friday, 14 August 2015 10:28 PM<br class="">
<b class="">To:</b><span class="Apple-converted-space"> </span>Archivesspace Users Group<br class="">
<b class="">Subject:</b><span class="Apple-converted-space"> </span>Re: [Archivesspace_Users_Group] Problems with ASpace reports</span></div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
</p>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
Hi,<br class="">
<br class="">
The JDK version shouldn't be a problem. This seems like the report is encountering some data it can't handle. Can you send us a MySQL dump of your ASpace database so we can try and replicate the problem on our end?</div>
</div>
<div class="">
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
</p>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
On Fri, Aug 14, 2015 at 3:31 AM, Emma Jolley <<a href="mailto:EJOLLEY@nla.gov.au" class="" style="color:purple; text-decoration:underline" target="_blank">EJOLLEY@nla.gov.au</a>> wrote:</div>
<div class="">
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(31,73,125)">My apologies for not having sent through the information about the Log. I have to liaise for some time with our IT to get this information. They have sent me the following
information which may be of help?</span></div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(31,73,125)"> </span></p>
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(31,73,125)">Many thanks</span></div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(31,73,125)"> </span></p>
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(31,73,125)">Emma</span></div>
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(31,73,125)">****</span></div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(31,73,125)"> </span></p>
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:10.5pt; font-family:Calibri,sans-serif">The log entry when running (as an example) the report mentioned in the email below is:</span></div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:10.5pt; font-family:Calibri,sans-serif"> </span></p>
<p class="" style="margin-right:0cm; margin-left:0cm; font-size:12pt; font-family:'Times New Roman',serif; background-color:rgb(235,235,235)">
<span class="" style="font-size:9pt; font-family:Courier; color:rgb(1,25,147)">D, [2015-08-10T17:58:14.599000 #3236] DEBUG -- : Thread-10076116: GET /repositories/2/reports/accessionsunprocessedreport?lock_version=&format=json [session: nil]</span></p>
<p class="" style="margin-right:0cm; margin-left:0cm; font-size:12pt; font-family:'Times New Roman',serif; background-color:rgb(235,235,235)">
<span class="" style="font-size:9pt; font-family:Courier; color:rgb(1,25,147)">D, [2015-08-10T17:58:14.602000 #3236] DEBUG -- : Thread-10076116: Post-processed params: {:format=>"json", :repo_id=>2}</span></p>
<p class="" style="margin-right:0cm; margin-left:0cm; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:9pt; font-family:Courier; color:rgb(0,127,0); background-color:aqua">D, [2015-08-10T17:58:14.892000 #3236] DEBUG -- : Thread-10076116: Responded with [404, {"Content-Type"=>"application/json; charset=UTF-8", "Cache-Control"=>"private,
must-revalidate, max-age=0", "Content-Length"=>"144"}, ["{\"error\":{\"AccessionsUnprocessedReport\":[\"net.sf.jasperreports.engine.JRException: Error executing SQL statement for : accessionsUnprocessed\"]}}"]]... in 292.0ms</span></p>
<p class="" style="margin-right:0cm; margin-left:0cm; font-size:12pt; font-family:'Times New Roman',serif; background-color:rgb(235,235,235)">
<span class="" style="font-size:9pt; font-family:Courier; color:rgb(1,25,147)"> Rendered shared/_breadcrumb.html.erb (1.0ms)</span></p>
<p class="" style="margin-right:0cm; margin-left:0cm; font-size:12pt; font-family:'Times New Roman',serif; background-color:rgb(235,235,235)">
<span class="" style="font-size:9pt; font-family:Courier; color:rgb(1,25,147)"> Rendered /opt/archivesspace-1.3.0/archivesspace/plugins/nla_accession_reports/frontend/views/reports/index.html.erb within layouts/application (82.0ms)</span></p>
<p class="" style="margin-right:0cm; margin-left:0cm; font-size:12pt; font-family:'Times New Roman',serif; background-color:rgb(235,235,235)">
<span class="" style="font-size:9pt; font-family:Courier; color:rgb(1,25,147)"> Rendered shared/_browser_support.html.erb (0.0ms)</span></p>
<p class="" style="margin-right:0cm; margin-left:0cm; font-size:12pt; font-family:'Times New Roman',serif; background-color:rgb(235,235,235)">
<span class="" style="font-size:9pt; font-family:Courier; color:rgb(1,25,147)"> Rendered shared/_header_user.html.erb (6.0ms)</span></p>
<p class="" style="margin-right:0cm; margin-left:0cm; font-size:12pt; font-family:'Times New Roman',serif; background-color:rgb(235,235,235)">
<span class="" style="font-size:9pt; font-family:Courier; color:rgb(1,25,147)"> Rendered shared/_header_global.html.erb (6.0ms)</span></p>
<p class="" style="margin-right:0cm; margin-left:0cm; font-size:12pt; font-family:'Times New Roman',serif; background-color:rgb(235,235,235)">
<span class="" style="font-size:9pt; font-family:Courier; color:rgb(1,25,147)"> Rendered site/_branding.html.erb (0.0ms)</span></p>
<p class="" style="margin-right:0cm; margin-left:0cm; font-size:12pt; font-family:'Times New Roman',serif; background-color:rgb(235,235,235)">
<span class="" style="font-size:9pt; font-family:Courier; color:rgb(1,25,147)"> Rendered shared/_advanced_search.html.erb (5.0ms)</span></p>
<p class="" style="margin-right:0cm; margin-left:0cm; font-size:12pt; font-family:'Times New Roman',serif; background-color:rgb(235,235,235)">
<span class="" style="font-size:9pt; font-family:Courier; color:rgb(1,25,147)"> Rendered shared/_header_repository.html.erb (18.0ms)</span></p>
<p class="" style="margin-right:0cm; margin-left:0cm; font-size:12pt; font-family:'Times New Roman',serif; background-color:rgb(235,235,235)">
<span class="" style="font-size:9pt; font-family:Courier; color:rgb(1,25,147)"> Rendered site/_footer.html.erb (0.0ms)</span></p>
<p class="" style="margin-right:0cm; margin-left:0cm; font-size:12pt; font-family:'Times New Roman',serif; background-color:rgb(235,235,235)">
<span class="" style="font-size:9pt; font-family:Courier; color:rgb(1,25,147)"> Rendered shared/_templates.html.erb (2.0ms)</span></p>
<p class="" style="margin-right:0cm; margin-left:0cm; font-size:12pt; font-family:'Times New Roman',serif; background-color:rgb(235,235,235)">
<span class="" style="font-size:9pt; font-family:Courier; color:rgb(1,25,147)">Completed 200 OK in 448.0ms (Views: 114.0ms)</span></p>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:10.5pt; font-family:Calibri,sans-serif"> </span></p>
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:10.5pt; font-family:Calibri,sans-serif">Which is not helpful as it essentially just says exactly what gets displayed on the interface.</span></div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:10.5pt; font-family:Calibri,sans-serif"> </span></p>
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:9pt; font-family:Courier; color:rgb(1,25,147); background-color:rgb(235,235,235)">net.sf.jasperreports.engine.JRException: Error executing SQL statement for : accessionsUnprocessed</span></div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:10.5pt; font-family:Calibri,sans-serif"> </span></p>
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:10.5pt; font-family:Calibri,sans-serif">I’ve run the query in this report directly against the database successfully (cut and paste from </span><span class="" style="font-size:9pt; font-family:Courier; color:rgb(1,25,147); background-color:rgb(235,235,235)">reports/Accessions/AccessionsUnprocessedReport/AccessionsUnprocessedReport.jrxml</span><span class="" style="font-size:10.5pt; font-family:Calibri,sans-serif"> and
substituting in the repo id) so I think the SQL itself is sound. </span></div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:10.5pt; font-family:Calibri,sans-serif"> </span></p>
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:10.5pt; font-family:Calibri,sans-serif">Further info:</span></div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:10.5pt; font-family:Calibri,sans-serif"> </span></p>
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:10.5pt; font-family:Calibri,sans-serif">The report config being used are:</span></div>
<p class="" style="margin-right:0cm; margin-left:0cm; font-size:12pt; font-family:'Times New Roman',serif; background-color:rgb(235,235,235)">
<span class="" style="font-size:9pt; font-family:Courier; color:rgb(1,25,147)">#AppConfig[:report_page_layout] = "letter landscape"</span></p>
<p class="" style="margin-right:0cm; margin-left:0cm; font-size:12pt; font-family:'Times New Roman',serif; background-color:rgb(235,235,235)">
<span class="" style="font-size:9pt; font-family:Courier; color:rgb(1,25,147)">AppConfig[:enable_jasper] = true </span></p>
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:9pt; font-family:Courier; color:rgb(1,25,147); background-color:rgb(235,235,235)">AppConfig[:compile_jasper] = true</span><span class="" style="font-size:9pt; font-family:Courier"> </span></div>
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:10.5pt; font-family:Calibri,sans-serif">I’ve tried with the report_page_layout both commented and uncommented.</span></div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:10.5pt; font-family:Calibri,sans-serif"> </span></p>
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:10.5pt; font-family:Calibri,sans-serif">The java version is:</span></div>
<p class="" style="margin-right:0cm; margin-left:0cm; font-size:12pt; font-family:'Times New Roman',serif; background-color:rgb(235,235,235)">
<span class="" style="font-size:9pt; font-family:Courier; color:rgb(1,25,147)">java version "1.7.0_85"</span></p>
<p class="" style="margin-right:0cm; margin-left:0cm; font-size:12pt; font-family:'Times New Roman',serif; background-color:rgb(235,235,235)">
<span class="" style="font-size:9pt; font-family:Courier; color:rgb(1,25,147)">OpenJDK Runtime Environment (rhel-2.6.1.3.el6_7-x86_64 u85-b01)</span></p>
<p class="" style="margin-right:0cm; margin-left:0cm; font-size:12pt; font-family:'Times New Roman',serif; background-color:rgb(235,235,235)">
<span class="" style="font-size:9pt; font-family:Courier; color:rgb(1,25,147)">OpenJDK 64-Bit Server VM (build 24.85-b03, mixed mode)</span></p>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:10.5pt; font-family:Calibri,sans-serif"> </span></p>
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:10.5pt; font-family:Calibri,sans-serif">Could there be an issue with using the OpenJDK rather than Oracle’s JDK perhaps ?</span></div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:10.5pt; font-family:Calibri,sans-serif"> </span></p>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(31,73,125)"> </span></p>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(31,73,125)"> </span></p>
<div class="">
<div class="" style="border-style:solid none none; border-top-color:rgb(181,196,223); border-top-width:1pt; padding:3pt 0cm 0cm">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<b class=""><span lang="EN-US" class="" style="font-size:10pt; font-family:Tahoma,sans-serif">From:</span></b><span lang="EN-US" class="" style="font-size:10pt; font-family:Tahoma,sans-serif"><span class="Apple-converted-space"> </span><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" class="" style="color:purple; text-decoration:underline" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a><span class="Apple-converted-space"> </span>[mailto:<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" class="" style="color:purple; text-decoration:underline" target="_blank">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>Brian Hoffman<br class="">
<b class="">Sent:</b><span class="Apple-converted-space"> </span>Friday, 14 August 2015 12:37 PM<br class="">
<b class="">To:</b><span class="Apple-converted-space"> </span>Archivesspace Users Group</span></div>
<div class="">
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<br class="">
<b class="">Subject:</b><span class="Apple-converted-space"> </span>Re: [Archivesspace_Users_Group] Problems with ASpace reports</div>
</div>
</div>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
</p>
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="background-color:rgb(255,255,0)">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:</span></div>
<div class="">
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
</p>
</div>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_archivesspace_archivesspace_pull_244&d=AwMGaQ&c=2X_btuPRWkGwRX26NHIotw&r=FD0Xci-wh01Dc1yt0aSp4ADMuu-zB2G2dpCCNNXfih0&m=fW2PblqG-EuWe_NmccDnQngjowe_utp-8LnFzzlbwaU&s=lnMBrdO99DMYnO5QSios7qmzuamXO_pZTlgirFph-9E&e=" class="" style="color:purple; text-decoration:underline" target="_blank">https://github.com/archivesspace/archivesspace/pull/244</a></div>
</div>
<div class="">
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
</p>
</div>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
Brian</div>
</div>
<div class="">
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
</p>
</div>
<div class="">
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
</p>
</div>
<div class="">
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
</p>
<div class="">
<blockquote class="" style="margin-top:5pt; margin-bottom:5pt">
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
On Aug 7, 2015, at 5:49 AM, Chris Fitzpatrick <<a href="mailto:Chris.Fitzpatrick@lyrasis.org" class="" style="color:purple; text-decoration:underline" target="_blank">Chris.Fitzpatrick@lyrasis.org</a>> wrote:</div>
</div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
</p>
<div class="">
<div class="">
<div class="">
<div class="" style="margin:0cm 0cm 12pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span><br class="webkit-block-placeholder">
</div>
</div>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif">Hi Emma,</span></div>
</div>
<div class="">
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span></p>
</div>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif">Can you look at what's being output into the log? </span></div>
</div>
<div class="">
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span></p>
</div>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif">The easiest way to see what the report is doing is to look at the Jasper XML, which you can see here =><a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_archivesspace_archivesspace_blob_master_reports_Accessions_AccessionsUnprocessedReport_AccessionsUnprocessedReport.jrxml-23L20-2DL37&d=AwMGaQ&c=2X_btuPRWkGwRX26NHIotw&r=FD0Xci-wh01Dc1yt0aSp4ADMuu-zB2G2dpCCNNXfih0&m=fW2PblqG-EuWe_NmccDnQngjowe_utp-8LnFzzlbwaU&s=E3g_D7ALOFUy_TOVZ77fVSG_kMXqF5u9AZkt-ff0MVc&e=" class="" style="color:purple; text-decoration:underline" target="_blank">https://github.com/archivesspace/archivesspace/blob/master/reports/Accessions/AccessionsUnprocessedReport/AccessionsUnprocessedReport.jrxml#L20-L37</a></span></div>
</div>
<div class="">
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span></p>
</div>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif">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. </span></div>
</div>
<div class="">
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span></p>
</div>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif">b,chris. </span></div>
</div>
<div class="">
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span></p>
</div>
<div class="">
<div name="divtagdefaultwrapper" class="">
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:10pt; font-family:Calibri,sans-serif">Chris Fitzpatrick | Developer, ArchivesSpace<br class="">
Skype: chrisfitzpat | Phone:<span class="Apple-converted-space"> </span><a href="tel:918.236.6048" class="" style="color:purple; text-decoration:underline" target="_blank">918.236.6048</a><br class="">
<a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__archivesspace.org_&d=AwMGaQ&c=2X_btuPRWkGwRX26NHIotw&r=FD0Xci-wh01Dc1yt0aSp4ADMuu-zB2G2dpCCNNXfih0&m=fW2PblqG-EuWe_NmccDnQngjowe_utp-8LnFzzlbwaU&s=tLDoAR4LkXMLuD8XoLPRfR3Q--MISpnxaUxWqVJPZY8&e=" class="" style="color:purple; text-decoration:underline" target="_blank">http://archivesspace.org/</a></span></div>
</div>
</div>
</div>
<div class="" style="margin:0cm 0cm 12pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span><br class="webkit-block-placeholder">
</div>
<div class="">
<div class="MsoNormal" align="center" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; text-align:center; background-color:white">
<span class="" style="font-family:Calibri,sans-serif">
<hr size="3" width="714" align="center" class="" style="width:428.5pt">
</span></div>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<b class=""><span class="" style="font-size:11pt; font-family:Calibri,sans-serif">From:</span></b><span class="" style="font-size:11pt; font-family:Calibri,sans-serif"> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" class="" style="color:purple; text-decoration:underline" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a><span class="Apple-converted-space"> </span><<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" class="" style="color:purple; text-decoration:underline" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
on behalf of Emma Jolley <<a href="mailto:EJOLLEY@nla.gov.au" class="" style="color:purple; text-decoration:underline" target="_blank">EJOLLEY@nla.gov.au</a>><br class="">
<b class="">Sent:</b> Friday, August 7, 2015 7:13 AM<br class="">
<b class="">To:</b> Archivesspace Users Group (<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" class="" style="color:purple; text-decoration:underline" target="_blank">archivesspace_users_group@lyralists.lyrasis.org</a>)<br class="">
<b class="">Subject:</b> Re: [Archivesspace_Users_Group] Problems with ASpace reports</span></div>
<div class="">
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span></p>
</div>
</div>
<div class="">
<div class="">
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(31,73,125)">Hi Chris</span></div>
</div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(31,73,125)"> </span></p>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(31,73,125)">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>
</div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(31,73,125)"> </span></p>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(31,73,125)">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>
</div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(31,73,125)"> </span></p>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(31,73,125)">Many thanks</span></div>
</div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(31,73,125)"> </span></p>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(31,73,125)">Emma</span></div>
</div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(31,73,125)"> </span></p>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<image007.png></div>
</div>
<div class="">
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:10.5pt; font-family:Calibri,sans-serif"> </span></p>
</div>
<div class="">
<div class="">
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:10pt; font-family:'Segoe UI',sans-serif; color:rgb(31,73,125)"> </span></p>
<div class="">
<div class="" style="border-style:solid none none; border-top-color:rgb(181,196,223); border-top-width:1pt; padding:3pt 0cm 0cm">
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<b class=""><span lang="EN-US" class="" style="font-size:10pt; font-family:Tahoma,sans-serif">From:</span></b><span lang="EN-US" class="" style="font-size:10pt; font-family:Tahoma,sans-serif"> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" class="" style="color:purple; text-decoration:underline" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> [<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" class="" style="color:purple; text-decoration:underline" target="_blank">mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org</a>] <b class="">On
Behalf Of </b>Chris Fitzpatrick<br class="">
<b class="">Sent:</b> Thursday, 6 August 2015 9:16 PM<br class="">
<b class="">To:</b> Archivesspace Users Group<br class="">
<b class="">Cc:</b> Zalduendo, Ines; Wendler, Robin King; Della Monica, Ilaria<br class="">
<b class="">Subject:</b> Re: [Archivesspace_Users_Group] Problems with ASpace reports</span></div>
</div>
</div>
</div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
</p>
<div class="">
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span></p>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span></p>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif">Hi Robin,</span></div>
</div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span></p>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif">So, first you need to make sure you compiled your jasper reports on startup. To do this, edit the<span class="Apple-converted-space"> </span><a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__config.rb&d=AwQGaQ&c=2X_btuPRWkGwRX26NHIotw&r=FD0Xci-wh01Dc1yt0aSp4ADMuu-zB2G2dpCCNNXfih0&m=fW2PblqG-EuWe_NmccDnQngjowe_utp-8LnFzzlbwaU&s=gsazHb5GvapfRKK_QuagvejxEUPByer3KlDtd_8SStI&e=" class="" style="color:purple; text-decoration:underline" target="_blank">config.rb</a><span class="Apple-converted-space"> </span>file
to have:</span></div>
</div>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif">AppConfig[:compile_jasper] = true</span></div>
</div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span></p>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif">and restart ASpace.</span></div>
</div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span></p>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span></p>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif">This will compile the jasper jxml files ( which is most likely what's causing the "can't convert nil to String" errors)</span></div>
</div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span></p>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif">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></div>
</div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span></p>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif">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="https://urldefense.proofpoint.com/v2/url?u=http-3A__community.jaspersoft.com_project_jaspersoft-2Dstudio&d=AwMGaQ&c=2X_btuPRWkGwRX26NHIotw&r=FD0Xci-wh01Dc1yt0aSp4ADMuu-zB2G2dpCCNNXfih0&m=fW2PblqG-EuWe_NmccDnQngjowe_utp-8LnFzzlbwaU&s=1ZkU9fzjJHPAB5OIF_s_JSQTeVGtBEcG5xDJVfwWvww&e=" class="" style="color:purple; text-decoration:underline" target="_blank">Jasper
studio</a>. Just be sure to recompile your reports.</span></div>
</div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span></p>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif">For the parameters, yes this feature is going to be included in a future release. I believe those labels are artifacts from AT. </span></div>
</div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span></p>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif">best, Chris. </span></div>
</div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span></p>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span></p>
<div class="">
<div name="divtagdefaultwrapper" class="">
<div class="">
<div class="">
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:10pt; font-family:Calibri,sans-serif">Chris Fitzpatrick | Developer, ArchivesSpace<br class="">
Skype: chrisfitzpat | Phone:<span class="Apple-converted-space"> </span><a href="tel:918.236.6048" class="" style="color:purple; text-decoration:underline" target="_blank">918.236.6048</a><br class="">
<a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__archivesspace.org_&d=AwMGaQ&c=2X_btuPRWkGwRX26NHIotw&r=FD0Xci-wh01Dc1yt0aSp4ADMuu-zB2G2dpCCNNXfih0&m=fW2PblqG-EuWe_NmccDnQngjowe_utp-8LnFzzlbwaU&s=tLDoAR4LkXMLuD8XoLPRfR3Q--MISpnxaUxWqVJPZY8&e=" class="" style="color:purple; text-decoration:underline" target="_blank">http://archivesspace.org/</a></span></div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span></p>
<div class="">
<div class="MsoNormal" align="center" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; text-align:center; background-color:white">
<span class="" style="font-family:Calibri,sans-serif">
<hr size="2" width="98%" align="center" class="">
</span></div>
<div class="">
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<b class=""><span class="" style="font-size:11pt; font-family:Calibri,sans-serif">From:</span></b><span class="" style="font-size:11pt; font-family:Calibri,sans-serif"><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" class="" style="color:purple; text-decoration:underline" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" class="" style="color:purple; text-decoration:underline" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
on behalf of McElheny, Robin G. <<a href="mailto:robin_mcelheny@harvard.edu" class="" style="color:purple; text-decoration:underline" target="_blank">robin_mcelheny@harvard.edu</a>><br class="">
<b class="">Sent:</b> Wednesday, August 5, 2015 5:55 PM<br class="">
<b class="">To:</b> Archivesspace Users Group<br class="">
<b class="">Cc:</b> Zalduendo, Ines; Wendler, Robin King; Della Monica, Ilaria<br class="">
<b class="">Subject:</b> [Archivesspace_Users_Group] Problems with ASpace reports</span></div>
</div>
<div class="">
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span></p>
</div>
</div>
<div class="">
<div class="">
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
<span class="" style="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.</span></div>
</div>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
<span class="" style="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?</span></div>
</div>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif">Record selection issues:</span></div>
</div>
<ul type="disc" class="" style="margin-bottom:0cm">
<li class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
<span class="" style="font-family:Calibri,sans-serif">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 class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
<image008.jpg></div>
</div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
</p>
<ul type="disc" class="" style="margin-bottom:0cm">
<li class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
<span class="" style="font-family:Calibri,sans-serif">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 class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif"> </span></p>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif">Report format issues:</span></div>
</div>
<ul type="disc" class="" style="margin-bottom:0cm">
<li class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
<span class="" style="font-family:Calibri,sans-serif">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 class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
</p>
<ul type="disc" class="" style="margin-bottom:0cm">
<li class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
<span class="" style="font-family:Calibri,sans-serif">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 class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
</p>
<ul type="disc" class="" style="margin-bottom:0cm">
<li class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
<span class="" style="font-family:Calibri,sans-serif">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 class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
</p>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
<span class="" style="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,,,,:").</span></div>
</div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif"> </span></p>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif">Here is a screen shot:</span></div>
</div>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif"><image009.jpg></span></div>
</div>
<ul type="disc" class="" style="margin-bottom:0cm">
<li class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
<span class="" style="font-family:Calibri,sans-serif">Here’s another example:</span></li></ul>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif"><image010.jpg></span></div>
</div>
<ul type="disc" class="" style="margin-bottom:0cm">
<li class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
<span class="" style="font-family:Calibri,sans-serif">In the case of an HTML report, it displays page footers – odd for online display.</span></li></ul>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif"><image011.jpg></span></div>
</div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif"> </span></p>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif">Report failure/timeout:</span></div>
</div>
<ul type="disc" class="" style="margin-bottom:0cm">
<li class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
<span class="" style="font-family:Calibri,sans-serif">We encountered many failures.</span></li></ul>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
Example:</div>
</div>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
When we attempted to download an XLSX AccessionsAcquired report in the ArchivesSpace sandbox, we got the following message:</div>
</div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
</p>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
Internal Server Error (500)</div>
</div>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
Request Method: GET</div>
</div>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
Request URL: <a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__localhost-3A8089_repositories_4_reports_accessionsacquiredreport-3Flock-5Fversion-3D-26format-3Dxlsx&d=AwMGaQ&c=2X_btuPRWkGwRX26NHIotw&r=FD0Xci-wh01Dc1yt0aSp4ADMuu-zB2G2dpCCNNXfih0&m=fW2PblqG-EuWe_NmccDnQngjowe_utp-8LnFzzlbwaU&s=QLVRITSkiwZ5mUuNKW9IXhybdcp_1VY7kG4axjN1YpI&e=" class="" style="color:purple; text-decoration:underline" target="_blank">http://localhost:8089/repositories/4/reports/accessionsacquiredreport?lock_version=&format=xlsx</a></div>
</div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
</p>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
(TypeError) can't convert nil into String</div>
</div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
</p>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
You're seeing this error because you use JRuby::Rack::ErrorApp::ShowStatus.</div>
</div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
</p>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
Another example:</div>
</div>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif"><image012.jpg></span></div>
</div>
<ul type="disc" class="" style="margin-bottom:0cm">
<li class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; line-height:13.8pt; background-color:white">
<span class="" style="font-family:Calibri,sans-serif">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 class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif"> </span></p>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif"> </span></p>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif">Robin McElheny</span></div>
</div>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif">Associate University Archivist for Collections and Public Services</span></div>
</div>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif">Harvard University Archives</span></div>
</div>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif">Pusey Library</span></div>
</div>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif">Cambridge, MA 02138</span></div>
</div>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif">Email: <a href="mailto:robin_mcelheny@harvard.edu" class="" style="color:purple; text-decoration:underline" target="_blank">robin_mcelheny@harvard.edu</a></span></div>
</div>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif">Phone:<span class="Apple-converted-space"> </span><a href="tel:617-495-2461" class="" style="color:purple; text-decoration:underline" target="_blank">617-495-2461</a></span></div>
</div>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif">Fax:<span class="Apple-converted-space"> </span><a href="tel:617-495-8011" class="" style="color:purple; text-decoration:underline" target="_blank">617-495-8011</a></span></div>
</div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif"> </span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:9pt; font-family:Helvetica,sans-serif">_______________________________________________<br class="">
Archivesspace_Users_Group mailing list<br class="">
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" class="" style="color:purple; text-decoration:underline" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br class="">
<a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=AwMGaQ&c=2X_btuPRWkGwRX26NHIotw&r=FD0Xci-wh01Dc1yt0aSp4ADMuu-zB2G2dpCCNNXfih0&m=fW2PblqG-EuWe_NmccDnQngjowe_utp-8LnFzzlbwaU&s=UKQoV4YFnThAz6ota9QAIQcE7acnwRZOAFv-CYNYT00&e=" class="" style="color:purple; text-decoration:underline" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a></span></div>
</div>
</blockquote>
</div>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
</p>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="margin:0cm 0cm 12pt; font-size:12pt; font-family:'Times New Roman',serif">
<br class="">
_______________________________________________<br class="">
Archivesspace_Users_Group mailing list<br class="">
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" class="" style="color:purple; text-decoration:underline" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br class="">
<a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=AwMGaQ&c=2X_btuPRWkGwRX26NHIotw&r=FD0Xci-wh01Dc1yt0aSp4ADMuu-zB2G2dpCCNNXfih0&m=fW2PblqG-EuWe_NmccDnQngjowe_utp-8LnFzzlbwaU&s=UKQoV4YFnThAz6ota9QAIQcE7acnwRZOAFv-CYNYT00&e=" class="" style="color:purple; text-decoration:underline" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a></p>
</div>
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<br class="">
<br clear="all" class="">
<br class="">
--<span class="Apple-converted-space"> </span></div>
<div class="">
<div class="" style="margin:0cm 0cm 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
Nathan Stevens<br class="">
Programmer/Analyst<br class="">
Digital Library Technology Services<br class="">
New York University<br class="">
<br class="">
1212-998-2653<br class="">
<a href="mailto:ns96@nyu.edu" class="" style="color:purple; text-decoration:underline" target="_blank">ns96@nyu.edu</a></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<span class="" 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; float:none; display:inline!important">_______________________________________________</span><br class="" 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">
<span class="" 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; float:none; display:inline!important">Archivesspace_Users_Group
mailing list</span><br class="" 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">
<span class="" 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; float:none; display:inline!important"><a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" class="" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a></span><br class="" 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">
<span class="" 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; float:none; display:inline!important"><a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=AwMF-g&c=2X_btuPRWkGwRX26NHIotw&r=FD0Xci-wh01Dc1yt0aSp4ADMuu-zB2G2dpCCNNXfih0&m=m4k_eKATRBkkyELfLCrqHTHMjbgOiSmlN0YmAReLKiQ&s=51LSe_Vcf1uCLVXSMRiGrR4DlqfsMUZAUFSH0fTLhYE&e=" class="" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a></span></div>
</blockquote>
</div>
<br class="">
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<span class="" 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; float:none; display:inline!important">_______________________________________________</span><br class="" 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">
<span class="" 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; float:none; display:inline!important">Archivesspace_Users_Group
mailing list</span><br class="" 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">
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" class="" 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" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br class="" 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">
<a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=AwMF-g&c=2X_btuPRWkGwRX26NHIotw&r=FD0Xci-wh01Dc1yt0aSp4ADMuu-zB2G2dpCCNNXfih0&m=5SbDCpus7oNyrgQO2oSCh7umQ6IpUlQMlLiH9uCaKBg&s=u36rIizo4ZcSWI0EBRhi-1NcpIFZQ30VGF21BBgdaV0&e=" class="" 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" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a></div>
</blockquote>
</div>
<br class="">
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>