[Archivesspace_Users_Group] Importing Accessions with CSV File? [Archivesspace_Users_Group Digest, Vol 26, Issue 2]
Kate Tasker
ktasker at library.berkeley.edu
Thu Sep 10 12:37:25 EDT 2015
Hi Marcus,
We completed a large batch import using the Accession CSV file earlier this
year.
We used the template on the ASpace GitHub (https://github.com/
archivesspace/archivesspace/tree/master/backend/app/exporters/examples/
accession) and learned the following (by the way, our import was to version
1.0.9 so some of this may have changed):
- The order of the fields is very important
- Include all the fields, even if some are blank in the data rows. The
exception to this was fields for Agent information; if all our data rows
were blank for all Agent fields, we removed the Agent columns. Including
Agent columns with no data appeared to trigger a problem and cause the test
import to fail. However, we were using an older version (1.0.9), so this
may have been resolved with later versions.
- Our dates did not import until we changed the template fields to
date_1_expression, date_1_begin, etc (the template uses date_expression,
date_begin, etc). We also found we needed to add date_1_type and
date_1_label (which appear to be required fields in the interface)
- Values in date_1_type and date_1_label should be lowercase (ex:
"creation" instead of "Creation")
- Also check the dependencies of some fields; for example, if you use
extent_container_summary, you must also include extent_number and
extent_type
- Make sure the encoding of the CSV file is UTF-8 (if you're editing in
Excel it may save to ANSI by default). If you still get an error try
opening the CSV in a text editor and saving again as UTF-8 (don't change or
edit anything else).
Hope this helps! We are also planning a second CSV file import soon- if
anyone has other tips or an updated accession template for version 1.3.0,
I'd love to know!
Cheers,
-Kate
Kate Tasker
Digital Archivist
The Bancroft Library
University of California
Berkeley, CA 94720-6000
On Thu, Sep 10, 2015 at 9:09 AM, <
archivesspace_users_group-request at lyralists.lyrasis.org> wrote:
> Send Archivesspace_Users_Group mailing list submissions to
> archivesspace_users_group at lyralists.lyrasis.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>
> or, via email, send a message with subject or body 'help' to
> archivesspace_users_group-request at lyralists.lyrasis.org
>
> You can reach the person managing the list at
> archivesspace_users_group-owner at lyralists.lyrasis.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Archivesspace_Users_Group digest..."
>
>
> Today's Topics:
>
> 1. Archival components with multiple dates (Max Eckard)
> 2. Re: Archival components with multiple dates (Custer, Mark)
> 3. Re: Archival components with multiple dates (Max Eckard)
> 4. Re: Problems with ASpace reports (Karrie L Roberson)
> 5. Re: Problems with ASpace reports (Brian Hoffman)
> 6. Re: Problems with ASpace reports (Karrie L Roberson)
> 7. Re: Problems with ASpace reports (Brian Hoffman)
> 8. Re: Problems with ASpace reports (Karrie L Roberson)
> 9. import error, record_uri=doesn't exist
> (Hughes, Margaret (Library))
> 10. Upper limit on PDF output? (Emily Pyers)
> 11. Re: Help With Access (Hurt, Tara (Library))
> 12. Re: Database Integrity Constraint Error on Agent Save
> (Joshua D. Shaw)
> 13. default values in Accession and Resource Records (Kate Tasker)
> 14. Re: default values in Accession and Resource Records
> (Brad Westbrook)
> 15. ArchivesSpace functionality issues (Suda, Phillip J)
> 16. Re: ArchivesSpace functionality issues (Maura Carbone)
> 17. Re: ArchivesSpace functionality issues (Custer, Mark)
> 18. Re: ArchivesSpace functionality issues (Suda, Phillip J)
> 19. Re: ArchivesSpace functionality issues (Suda, Phillip J)
> 20. Re: ArchivesSpace functionality issues (Maura Carbone)
> 21. Re: ArchivesSpace functionality issues (Suda, Phillip J)
> 22. Re: ArchivesSpace functionality issues (Maura Carbone)
> 23. upgrading to v1.3.0 question about copying files #linux
> (Fleming, Jason)
> 24. Re: SPAM?? upgrading to v1.3.0 question about copying files
> #linux (Kutzuba, Jamie)
> 25. Re: Help With Access (Hurt, Tara (Library))
> 26. FW: Help With Access (Hurt, Tara (Library))
> 27. Re: Help With Access (Steven Majewski)
> 28. Re: Help With Access (Hurt, Tara (Library))
> 29. Re: Help With Access (Steven Majewski)
> 30. I didn't know you could do this... (Steven Majewski)
> 31. Plugin: Custom import mapping for MarcXML Agents, help
> (Carlos Lemus)
> 32. Re: Plugin: Custom import mapping for MarcXML Agents, help
> (Brian Hoffman)
> 33. Plugin: Custom import mapping for MarcXML Agents, help
> (Carlos Lemus)
> 34. Re: How to delete a populated repository? (Katherine Collett)
> 35. Importing Accessions with CSV File? (Ladd, Marcus)
> 36. Re: Help With Access (Hurt, Tara (Library))
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 1 Sep 2015 13:35:49 -0400
> From: Max Eckard <eckardm at umich.edu>
> To: Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: [Archivesspace_Users_Group] Archival components with multiple
> dates
> Message-ID:
> <CAOEoOqX8ZAMBQJAgtkVAP=
> fgZem8wAiw0QJc5TpaE2Y-isSMGg at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Hello ASpacers,
>
> I'm about to report a bug we think we've found on the JIRA site, but I'm
> posting a message here first "asking for help in understanding and
> verifying" (from How to Report a Bug
> <https://archivesspace.atlassian.net/wiki/display/ADC/How+to+Report+a+Bug
> >)
> the bug we've encountered.
>
> So here it is:
>
> When creating archival components with multiple dates, only the first date
> shows up in the display string. Expected behavior would be that the display
> string shows all dates.
>
> I've attached two screenshots, one showing the dates I created and the
> other showing the resulting display string.
>
> I've tried this on 1.2 and 1.3.
>
> Have any of you noticed this as well, or can you confirm that we're not
> missing something?
>
> Thanks!
> Max
>
> --
> *Max Eckard*
> *Assistant Archivist for Digital Curation*
>
>
> Bentley Historical Library
> 1150 Beal Ave.
> Ann Arbor, MI 48109-2113
> 734/763-7518 <734.763.7518>
> http://bentley.umich.edu/
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150901/db7fb933/attachment-0001.html
> >
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: Capture-1.PNG
> Type: image/png
> Size: 41811 bytes
> Desc: not available
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150901/db7fb933/attachment-0002.png
> >
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: Capture-2.PNG
> Type: image/png
> Size: 27263 bytes
> Desc: not available
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150901/db7fb933/attachment-0003.png
> >
>
> ------------------------------
>
> Message: 2
> Date: Tue, 1 Sep 2015 19:25:14 +0000
> From: "Custer, Mark" <mark.custer at yale.edu>
> To: Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] Archival components with
> multiple dates
> Message-ID:
> <DCB910FAD4CF9343B3E424AF5F3310252563588C at x10-mbx8.yu.yale.edu>
> Content-Type: text/plain; charset="utf-8"
>
> You?re not missing anything. We?ve noticed that issue, as well. Given
> enough ArchivesSpace members, all bugs will eventually be logged!
>
>
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of Max
> Eckard
> Sent: Tuesday, September 01, 2015 1:36 PM
> To: Archivesspace Users Group
> Subject: [Archivesspace_Users_Group] Archival components with multiple
> dates
>
> Hello ASpacers,
> I'm about to report a bug we think we've found on the JIRA site, but I'm
> posting a message here first "asking for help in understanding and
> verifying" (from How to Report a Bug<
> https://urldefense.proofpoint.com/v2/url?u=https-3A__archivesspace.atlassian.net_wiki_display_ADC_How-2Bto-2BReport-2Ba-2BBug&d=AwMFaQ&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=s7ciGQfUJeaV_ryx908hbeXDoU9aqDwDN0Z0VbfsJ3Y&m=c8YboJEGDFC8nPpo31UrFdAfwPmDjNEZ1acz6zslNR4&s=f-JQ0qfjN25nbDqXtaI9TaBhS1mrFGE3D36y8DZP3Q4&e=>)
> the bug we've encountered.
>
> So here it is:
> When creating archival components with multiple dates, only the first date
> shows up in the display string. Expected behavior would be that the display
> string shows all dates.
> I've attached two screenshots, one showing the dates I created and the
> other showing the resulting display string.
>
> I've tried this on 1.2 and 1.3.
>
> Have any of you noticed this as well, or can you confirm that we're not
> missing something?
> Thanks!
> Max
>
> --
> Max Eckard
> Assistant Archivist for Digital Curation
>
> [https://webapps.lsa.umich.edu/dean/lsa_emails/bentley-sig-em.png]
> Bentley Historical Library
> 1150 Beal Ave.
> Ann Arbor, MI 48109-2113
> 734/763-7518<tel:734.763.7518>
> http://bentley.umich.edu/<
> https://urldefense.proofpoint.com/v2/url?u=http-3A__bentley.umich.edu_&d=AwMFaQ&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=s7ciGQfUJeaV_ryx908hbeXDoU9aqDwDN0Z0VbfsJ3Y&m=c8YboJEGDFC8nPpo31UrFdAfwPmDjNEZ1acz6zslNR4&s=tEOBMXk9st2N46B6glji28DfhYdVDnKaUUvU7fZs-Sw&e=
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150901/6a853935/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 3
> Date: Tue, 1 Sep 2015 15:35:46 -0400
> From: Max Eckard <eckardm at umich.edu>
> To: Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] Archival components with
> multiple dates
> Message-ID:
> <CAOEoOqX+UJ6MW7yuAkWK5gGOFxECEOYiDq05GvRoA=
> RTXMzaEA at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Thanks, Mark!
>
> For the record, bug report created!
>
> https://archivesspace.atlassian.net/browse/AS-47
>
> Max
>
>
>
> On Tue, Sep 1, 2015 at 3:25 PM, Custer, Mark <mark.custer at yale.edu> wrote:
>
> > You?re not missing anything. We?ve noticed that issue, as well. Given
> > enough ArchivesSpace members, all bugs will eventually be logged!
> >
> >
> >
> >
> >
> >
> >
> > *From:* archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:
> > archivesspace_users_group-bounces at lyralists.lyrasis.org] *On Behalf Of
> *Max
> > Eckard
> > *Sent:* Tuesday, September 01, 2015 1:36 PM
> > *To:* Archivesspace Users Group
> > *Subject:* [Archivesspace_Users_Group] Archival components with multiple
> > dates
> >
> >
> >
> > Hello ASpacers,
> >
> > I'm about to report a bug we think we've found on the JIRA site, but I'm
> > posting a message here first "asking for help in understanding and
> > verifying" (from How to Report a Bug
> > <
> https://urldefense.proofpoint.com/v2/url?u=https-3A__archivesspace.atlassian.net_wiki_display_ADC_How-2Bto-2BReport-2Ba-2BBug&d=AwMFaQ&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=s7ciGQfUJeaV_ryx908hbeXDoU9aqDwDN0Z0VbfsJ3Y&m=c8YboJEGDFC8nPpo31UrFdAfwPmDjNEZ1acz6zslNR4&s=f-JQ0qfjN25nbDqXtaI9TaBhS1mrFGE3D36y8DZP3Q4&e=
> >)
> > the bug we've encountered.
> >
> >
> >
> > So here it is:
> >
> > When creating archival components with multiple dates, only the first
> date
> > shows up in the display string. Expected behavior would be that the
> display
> > string shows all dates.
> >
> > I've attached two screenshots, one showing the dates I created and the
> > other showing the resulting display string.
> >
> >
> >
> > I've tried this on 1.2 and 1.3.
> >
> > Have any of you noticed this as well, or can you confirm that we're not
> > missing something?
> >
> > Thanks!
> >
> > Max
> >
> >
> > --
> >
> > *Max Eckard*
> > *Assistant Archivist for Digital Curation*
> >
> >
> >
> > Bentley Historical Library
> >
> > 1150 Beal Ave.
> > Ann Arbor, MI 48109-2113
> > 734/763-7518 <734.763.7518>
> >
> > http://bentley.umich.edu/
> > <
> https://urldefense.proofpoint.com/v2/url?u=http-3A__bentley.umich.edu_&d=AwMFaQ&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=s7ciGQfUJeaV_ryx908hbeXDoU9aqDwDN0Z0VbfsJ3Y&m=c8YboJEGDFC8nPpo31UrFdAfwPmDjNEZ1acz6zslNR4&s=tEOBMXk9st2N46B6glji28DfhYdVDnKaUUvU7fZs-Sw&e=
> >
> >
> >
> > _______________________________________________
> > Archivesspace_Users_Group mailing list
> > Archivesspace_Users_Group at lyralists.lyrasis.org
> > http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
> >
> >
>
>
> --
> *Max Eckard*
> *Assistant Archivist for Digital Curation*
>
>
> Bentley Historical Library
> 1150 Beal Ave.
> Ann Arbor, MI 48109-2113
> 734/763-7518 <734.763.7518>
> http://bentley.umich.edu/
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150901/93550fd2/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 4
> Date: Tue, 01 Sep 2015 21:08:35 +0000
> From: Karrie L Roberson <robersonkl at sfasu.edu>
> To: Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
> Message-ID:
> <FB588ACBDDC20844988B2EDA4EB2496B01C66FE4C2 at EXCHMBOX01.sfasu.nac>
> Content-Type: text/plain; charset="windows-1252"
>
> We're seeing the same type of messages as below with the messages that are
> seen below. Our error message is "ResourcesLocationsListReport -
> net.sf.jasperreports.engine.JRException: Error executing SQL statement for
> : resourcesLocationsList".
>
> We edited the 'config.rb' file with the jasper reports uncommented,
> updated the 2 files in the PR issue mentioned below, and restarted
> Archivesspace.
>
> 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.
>
> Thanks,
> Karrie
>
> ?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.?
> ________________________________
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org [
> archivesspace_users_group-bounces at lyralists.lyrasis.org] on behalf of
> Emma Jolley [EJOLLEY at nla.gov.au]
> Sent: Sunday, August 30, 2015 11:57 PM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
>
> Hi
>
> 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?
>
> Thanks
>
> Emma
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Nathan Stevens
> Sent: Friday, 14 August 2015 10:28 PM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
>
> Hi,
>
> 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?
>
> On Fri, Aug 14, 2015 at 3:31 AM, Emma Jolley <EJOLLEY at nla.gov.au<mailto:
> EJOLLEY at nla.gov.au>> wrote:
> 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?
>
> Many thanks
>
> Emma
> ****
>
> The log entry when running (as an example) the report mentioned in the
> email below is:
>
>
> D, [2015-08-10T17:58:14.599000 #3236] DEBUG -- : Thread-10076116: GET
> /repositories/2/reports/accessionsunprocessedreport?lock_version=&format=json
> [session: nil]
>
> D, [2015-08-10T17:58:14.602000 #3236] DEBUG -- : Thread-10076116:
> Post-processed params: {:format=>"json", :repo_id=>2}
>
> 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
>
> Rendered shared/_breadcrumb.html.erb (1.0ms)
>
> Rendered
> /opt/archivesspace-1.3.0/archivesspace/plugins/nla_accession_reports/frontend/views/reports/index.html.erb
> within layouts/application (82.0ms)
>
> Rendered shared/_browser_support.html.erb (0.0ms)
>
> Rendered shared/_header_user.html.erb (6.0ms)
>
> Rendered shared/_header_global.html.erb (6.0ms)
>
> Rendered site/_branding.html.erb (0.0ms)
>
> Rendered shared/_advanced_search.html.erb (5.0ms)
>
> Rendered shared/_header_repository.html.erb (18.0ms)
>
> Rendered site/_footer.html.erb (0.0ms)
>
> Rendered shared/_templates.html.erb (2.0ms)
>
> Completed 200 OK in 448.0ms (Views: 114.0ms)
>
> Which is not helpful as it essentially just says exactly what gets
> displayed on the interface.
>
> net.sf.jasperreports.engine.JRException: Error executing SQL statement for
> : accessionsUnprocessed
>
> I?ve run the query in this report directly against the database
> successfully (cut and paste from
> reports/Accessions/AccessionsUnprocessedReport/AccessionsUnprocessedReport.jrxml
> and substituting in the repo id) so I think the SQL itself is sound.
>
> Further info:
>
> The report config being used are:
>
> #AppConfig[:report_page_layout] = "letter landscape"
>
> AppConfig[:enable_jasper] = true
> AppConfig[:compile_jasper] = true
> I?ve tried with the report_page_layout both commented and uncommented.
>
> The java version is:
>
> java version "1.7.0_85"
>
> OpenJDK Runtime Environment (rhel-2.6.1.3.el6_7-x86_64 u85-b01)
>
> OpenJDK 64-Bit Server VM (build 24.85-b03, mixed mode)
>
> Could there be an issue with using the OpenJDK rather than Oracle?s JDK
> perhaps ?
>
>
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>] On Behalf Of
> Brian Hoffman
> Sent: Friday, 14 August 2015 12:37 PM
> To: Archivesspace Users Group
>
> Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
>
> 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:
>
> https://github.com/archivesspace/archivesspace/pull/244<
> 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=
> >
>
> Brian
>
>
>
> On Aug 7, 2015, at 5:49 AM, Chris Fitzpatrick <
> Chris.Fitzpatrick at lyrasis.org<mailto:Chris.Fitzpatrick at lyrasis.org>>
> wrote:
>
>
> Hi Emma,
>
> Can you look at what's being output into the log?
>
> The easiest way to see what the report is doing is to look at the Jasper
> XML, which you can see here =>
> https://github.com/archivesspace/archivesspace/blob/master/reports/Accessions/AccessionsUnprocessedReport/AccessionsUnprocessedReport.jrxml#L20-L37
> <
> 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=
> >
>
> 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.
>
> b,chris.
>
> Chris Fitzpatrick | Developer, ArchivesSpace
> Skype: chrisfitzpat | Phone: 918.236.6048<tel:918.236.6048>
> http://archivesspace.org/<
> 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=
> >
>
> ________________________________
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> <
> archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>> on behalf of
> Emma Jolley <EJOLLEY at nla.gov.au<mailto:EJOLLEY at nla.gov.au>>
> Sent: Friday, August 7, 2015 7:13 AM
> To: Archivesspace Users Group (
> archivesspace_users_group at lyralists.lyrasis.org<mailto:
> archivesspace_users_group at lyralists.lyrasis.org>)
> Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
>
> Hi Chris
>
> 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?
>
> 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?
>
> Many thanks
>
> Emma
>
> <image007.png>
>
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Chris Fitzpatrick
> Sent: Thursday, 6 August 2015 9:16 PM
> To: Archivesspace Users Group
> Cc: Zalduendo, Ines; Wendler, Robin King; Della Monica, Ilaria
> Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
>
>
>
> Hi Robin,
>
> So, first you need to make sure you compiled your jasper reports on
> startup. To do this, edit the config.rb<
> 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=>
> file to have:
> AppConfig[:compile_jasper] = true
>
> and restart ASpace.
>
>
> This will compile the jasper jxml files ( which is most likely what's
> causing the "can't convert nil to String" errors)
>
> 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.
>
> 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 Jasper studio<
> 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=>.
> Just be sure to recompile your reports.
>
> For the parameters, yes this feature is going to be included in a future
> release. I believe those labels are artifacts from AT.
>
> best, Chris.
>
>
> Chris Fitzpatrick | Developer, ArchivesSpace
> Skype: chrisfitzpat | Phone: 918.236.6048<tel:918.236.6048>
> http://archivesspace.org/<
> 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=
> >
>
> ________________________________
> From:archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> <
> archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>> on behalf of
> McElheny, Robin G. <robin_mcelheny at harvard.edu<mailto:
> robin_mcelheny at harvard.edu>>
> Sent: Wednesday, August 5, 2015 5:55 PM
> To: Archivesspace Users Group
> Cc: Zalduendo, Ines; Wendler, Robin King; Della Monica, Ilaria
> Subject: [Archivesspace_Users_Group] Problems with ASpace reports
>
> 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.
> 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?
> Record selection issues:
>
> * The Accessions Acquired and Accessions Production reports supposedly
> allow for specified time periods, but no date parameters show up in the
> report user interface.
> <image008.jpg>
>
>
> * 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?
>
> Report format issues:
>
> * 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.
>
>
> * 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"
>
>
> * 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:
>
> 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,,,,:").
>
> Here is a screen shot:
> <image009.jpg>
>
> * Here?s another example:
> <image010.jpg>
>
> * In the case of an HTML report, it displays page footers ? odd for
> online display.
> <image011.jpg>
>
> Report failure/timeout:
>
> * We encountered many failures.
> Example:
> When we attempted to download an XLSX AccessionsAcquired report in the
> ArchivesSpace sandbox, we got the following message:
>
> Internal Server Error (500)
> Request Method: GET
> Request URL:
> http://localhost:8089/repositories/4/reports/accessionsacquiredreport?lock_version=&format=xlsx
> <
> 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=
> >
>
> (TypeError) can't convert nil into String
>
> You're seeing this error because you use JRuby::Rack::ErrorApp::ShowStatus.
>
> Another example:
> <image012.jpg>
>
> * 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.
>
>
> Robin McElheny
> Associate University Archivist for Collections and Public Services
> Harvard University Archives
> Pusey Library
> Cambridge, MA 02138
> Email: robin_mcelheny at harvard.edu<mailto:robin_mcelheny at harvard.edu>
> Phone: 617-495-2461<tel:617-495-2461>
> Fax: 617-495-8011<tel:617-495-8011>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:
> Archivesspace_Users_Group at lyralists.lyrasis.org>
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group<
> 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=
> >
>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:
> Archivesspace_Users_Group at lyralists.lyrasis.org>
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group<
> 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=
> >
>
>
>
> --
> Nathan Stevens
> Programmer/Analyst
> Digital Library Technology Services
> New York University
>
> 1212-998-2653
> ns96 at nyu.edu<mailto:ns96 at nyu.edu>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150901/25bec7a0/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 5
> Date: Tue, 1 Sep 2015 17:28:37 -0400
> From: Brian Hoffman <brianjhoffman at gmail.com>
> To: Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
> Message-ID: <6DC69989-AC47-48B5-AB01-939232F6BCB2 at gmail.com>
> Content-Type: text/plain; charset="windows-1252"
>
> Hi,
>
> It sounds like you may have lost the mysql stored procedures that the
> reports require.
>
> What happens when you log in to mysql and type:
>
> > select name from mysql.proc
>
> ?
>
> P.S. What caused you to dump the mysql file, edit it, and reload it? That
> is not something I recommend doing.
>
>
>
> > On Sep 1, 2015, at 5:08 PM, Karrie L Roberson <robersonkl at sfasu.edu>
> wrote:
> >
> > We're seeing the same type of messages as below with the messages that
> are seen below. Our error message is "ResourcesLocationsListReport -
> net.sf.jasperreports.engine.JRException: Error executing SQL statement for
> : resourcesLocationsList".
> >
> > We edited the 'config.rb' file with the jasper reports uncommented,
> updated the 2 files in the PR issue mentioned below, and restarted
> Archivesspace.
> >
> > 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.
> >
> > Thanks,
> > Karrie
> >
> > ?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.?
> > From: archivesspace_users_group-bounces at lyralists.lyrasis.org [
> archivesspace_users_group-bounces at lyralists.lyrasis.org] on behalf of
> Emma Jolley [EJOLLEY at nla.gov.au]
> > Sent: Sunday, August 30, 2015 11:57 PM
> > To: Archivesspace Users Group
> > Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
> >
> > Hi
> >
> > 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?
> >
> > Thanks
> >
> > Emma
> >
> > From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Nathan Stevens
> > Sent: Friday, 14 August 2015 10:28 PM
> > To: Archivesspace Users Group
> > Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
> >
> > Hi,
> >
> > 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?
> >
> > On Fri, Aug 14, 2015 at 3:31 AM, Emma Jolley <EJOLLEY at nla.gov.au
> <mailto:EJOLLEY at nla.gov.au>> wrote:
> > 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?
> >
> > Many thanks
> >
> > Emma
> > ****
> >
> > The log entry when running (as an example) the report mentioned in the
> email below is:
> >
> > D, [2015-08-10T17:58:14.599000 #3236] DEBUG -- : Thread-10076116: GET
> /repositories/2/reports/accessionsunprocessedreport?lock_version=&format=json
> [session: nil]
> >
> > D, [2015-08-10T17:58:14.602000 #3236] DEBUG -- : Thread-10076116:
> Post-processed params: {:format=>"json", :repo_id=>2}
> >
> > 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
> >
> > Rendered shared/_breadcrumb.html.erb (1.0ms)
> >
> > Rendered
> /opt/archivesspace-1.3.0/archivesspace/plugins/nla_accession_reports/frontend/views/reports/index.html.erb
> within layouts/application (82.0ms)
> >
> > Rendered shared/_browser_support.html.erb (0.0ms)
> >
> > Rendered shared/_header_user.html.erb (6.0ms)
> >
> > Rendered shared/_header_global.html.erb (6.0ms)
> >
> > Rendered site/_branding.html.erb (0.0ms)
> >
> > Rendered shared/_advanced_search.html.erb (5.0ms)
> >
> > Rendered shared/_header_repository.html.erb (18.0ms)
> >
> > Rendered site/_footer.html.erb (0.0ms)
> >
> > Rendered shared/_templates.html.erb (2.0ms)
> >
> > Completed 200 OK in 448.0ms (Views: 114.0ms)
> >
> >
> > Which is not helpful as it essentially just says exactly what gets
> displayed on the interface.
> >
> > net.sf.jasperreports.engine.JRException: Error executing SQL statement
> for : accessionsUnprocessed
> >
> > I?ve run the query in this report directly against the database
> successfully (cut and paste from
> reports/Accessions/AccessionsUnprocessedReport/AccessionsUnprocessedReport.jrxml
> and substituting in the repo id) so I think the SQL itself is sound.
> >
> > Further info:
> >
> > The report config being used are:
> > #AppConfig[:report_page_layout] = "letter landscape"
> >
> > AppConfig[:enable_jasper] = true
> >
> > AppConfig[:compile_jasper] = true
> > I?ve tried with the report_page_layout both commented and uncommented.
> >
> > The java version is:
> > java version "1.7.0_85"
> >
> > OpenJDK Runtime Environment (rhel-2.6.1.3.el6_7-x86_64 u85-b01)
> >
> > OpenJDK 64-Bit Server VM (build 24.85-b03, mixed mode)
> >
> >
> > Could there be an issue with using the OpenJDK rather than Oracle?s JDK
> perhaps ?
> >
> >
> >
> > From: archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>] On Behalf Of
> Brian Hoffman
> > Sent: Friday, 14 August 2015 12:37 PM
> > To: Archivesspace Users Group
> >
> > Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
> >
> > 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:
> >
> > https://github.com/archivesspace/archivesspace/pull/244 <
> 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=
> >
> >
> > Brian
> >
> >
> >
> > On Aug 7, 2015, at 5:49 AM, Chris Fitzpatrick <
> Chris.Fitzpatrick at lyrasis.org <mailto:Chris.Fitzpatrick at lyrasis.org>>
> wrote:
> >
> >
> > Hi Emma,
> >
> > Can you look at what's being output into the log?
> >
> > The easiest way to see what the report is doing is to look at the Jasper
> XML, which you can see here =>
> https://github.com/archivesspace/archivesspace/blob/master/reports/Accessions/AccessionsUnprocessedReport/AccessionsUnprocessedReport.jrxml#L20-L37
> <
> 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=
> >
> >
> > 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.
> >
> > b,chris.
> >
> > Chris Fitzpatrick | Developer, ArchivesSpace
> > Skype: chrisfitzpat | Phone: 918.236.6048 <tel:918.236.6048>
> > http://archivesspace.org/ <
> 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=
> >
> >
> > From: archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> <
> archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>> on behalf of
> Emma Jolley <EJOLLEY at nla.gov.au <mailto:EJOLLEY at nla.gov.au>>
> > Sent: Friday, August 7, 2015 7:13 AM
> > To: Archivesspace Users Group (
> archivesspace_users_group at lyralists.lyrasis.org <mailto:
> archivesspace_users_group at lyralists.lyrasis.org>)
> > Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
> >
> > Hi Chris
> >
> > 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?
> >
> > 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?
> >
> > Many thanks
> >
> > Emma
> >
> > <image007.png>
> >
> >
> > From: archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>] On Behalf Of
> Chris Fitzpatrick
> > Sent: Thursday, 6 August 2015 9:16 PM
> > To: Archivesspace Users Group
> > Cc: Zalduendo, Ines; Wendler, Robin King; Della Monica, Ilaria
> > Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
> >
> >
> >
> > Hi Robin,
> >
> > So, first you need to make sure you compiled your jasper reports on
> startup. To do this, edit the config.rb <
> 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=>
> file to have:
> > AppConfig[:compile_jasper] = true
> >
> > and restart ASpace.
> >
> >
> > This will compile the jasper jxml files ( which is most likely what's
> causing the "can't convert nil to String" errors)
> >
> > 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.
> >
> > 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 Jasper studio <
> 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=>.
> Just be sure to recompile your reports.
> >
> > For the parameters, yes this feature is going to be included in a future
> release. I believe those labels are artifacts from AT.
> >
> > best, Chris.
> >
> >
> > Chris Fitzpatrick | Developer, ArchivesSpace
> > Skype: chrisfitzpat | Phone: 918.236.6048 <tel:918.236.6048>
> > http://archivesspace.org/ <
> 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=
> >
> >
> > From:archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> <
> archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>> on behalf of
> McElheny, Robin G. <robin_mcelheny at harvard.edu <mailto:
> robin_mcelheny at harvard.edu>>
> > Sent: Wednesday, August 5, 2015 5:55 PM
> > To: Archivesspace Users Group
> > Cc: Zalduendo, Ines; Wendler, Robin King; Della Monica, Ilaria
> > Subject: [Archivesspace_Users_Group] Problems with ASpace reports
> >
> > 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.
> > 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?
> > Record selection issues:
> > The Accessions Acquired and Accessions Production reports supposedly
> allow for specified time periods, but no date parameters show up in the
> report user interface.
> > <image008.jpg>
> >
> > 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?
> >
> > Report format issues:
> > 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.
> >
> > 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"
> >
> > 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:
> >
> > 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,,,,:").
> >
> > Here is a screen shot:
> > <image009.jpg>
> > Here?s another example:
> > <image010.jpg>
> > In the case of an HTML report, it displays page footers ? odd for online
> display.
> > <image011.jpg>
> >
> > Report failure/timeout:
> > We encountered many failures.
> > Example:
> > When we attempted to download an XLSX AccessionsAcquired report in the
> ArchivesSpace sandbox, we got the following message:
> >
> > Internal Server Error (500)
> > Request Method: GET
> > Request URL:
> http://localhost:8089/repositories/4/reports/accessionsacquiredreport?lock_version=&format=xlsx
> <
> 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=
> >
> >
> > (TypeError) can't convert nil into String
> >
> > You're seeing this error because you use
> JRuby::Rack::ErrorApp::ShowStatus.
> >
> > Another example:
> > <image012.jpg>
> > 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.
> >
> >
> > Robin McElheny
> > Associate University Archivist for Collections and Public Services
> > Harvard University Archives
> > Pusey Library
> > Cambridge, MA 02138
> > Email: robin_mcelheny at harvard.edu <mailto:robin_mcelheny at harvard.edu>
> > Phone: 617-495-2461 <tel:617-495-2461>
> > Fax: 617-495-8011 <tel:617-495-8011>
> >
> > _______________________________________________
> > Archivesspace_Users_Group mailing list
> > Archivesspace_Users_Group at lyralists.lyrasis.org <mailto:
> Archivesspace_Users_Group at lyralists.lyrasis.org>
> > http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
> <
> 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=
> >
> >
> >
> > _______________________________________________
> > Archivesspace_Users_Group mailing list
> > Archivesspace_Users_Group at lyralists.lyrasis.org <mailto:
> Archivesspace_Users_Group at lyralists.lyrasis.org>
> > http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
> <
> 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=
> >
> >
> >
> >
> > --
> > Nathan Stevens
> > Programmer/Analyst
> > Digital Library Technology Services
> > New York University
> >
> > 1212-998-2653
> > ns96 at nyu.edu <mailto:ns96 at nyu.edu
> >_______________________________________________
> > Archivesspace_Users_Group mailing list
> > Archivesspace_Users_Group at lyralists.lyrasis.org
> > http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150901/172a1efc/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 6
> Date: Tue, 01 Sep 2015 21:33:44 +0000
> From: Karrie L Roberson <robersonkl at sfasu.edu>
> To: Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
> Message-ID:
> <FB588ACBDDC20844988B2EDA4EB2496B01C66FE525 at EXCHMBOX01.sfasu.nac>
> Content-Type: text/plain; charset="windows-1252"
>
> It returns "empty set". Is there anything we can do to add those stored
> procedures back?
>
> We had to make some changes to the data that got carried over from the
> migration from Archon. :/
>
> Thanks,
> Karrie
> ________________________________
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org [
> archivesspace_users_group-bounces at lyralists.lyrasis.org] on behalf of
> Brian Hoffman [brianjhoffman at gmail.com]
> Sent: Tuesday, September 01, 2015 4:28 PM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
>
> Hi,
>
> It sounds like you may have lost the mysql stored procedures that the
> reports require.
>
> What happens when you log in to mysql and type:
>
> > select name from mysql.proc
>
> ?
>
> P.S. What caused you to dump the mysql file, edit it, and reload it? That
> is not something I recommend doing.
>
>
>
> On Sep 1, 2015, at 5:08 PM, Karrie L Roberson <robersonkl at sfasu.edu
> <mailto:robersonkl at sfasu.edu>> wrote:
>
> We're seeing the same type of messages as below with the messages that are
> seen below. Our error message is "ResourcesLocationsListReport -
> net.sf.jasperreports.engine.JRException: Error executing SQL statement for
> : resourcesLocationsList".
>
> We edited the 'config.rb' file with the jasper reports uncommented,
> updated the 2 files in the PR issue mentioned below, and restarted
> Archivesspace.
>
> 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.
>
> Thanks,
> Karrie
>
> ?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.?
> ________________________________
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [
> archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>] on behalf of
> Emma Jolley [EJOLLEY at nla.gov.au<mailto:EJOLLEY at nla.gov.au>]
> Sent: Sunday, August 30, 2015 11:57 PM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
>
> Hi
>
> 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?
>
> Thanks
>
> Emma
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Nathan Stevens
> Sent: Friday, 14 August 2015 10:28 PM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
>
> Hi,
>
> 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?
>
> On Fri, Aug 14, 2015 at 3:31 AM, Emma Jolley <EJOLLEY at nla.gov.au<mailto:
> EJOLLEY at nla.gov.au>> wrote:
> 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?
>
> Many thanks
>
> Emma
> ****
>
> The log entry when running (as an example) the report mentioned in the
> email below is:
>
>
> D, [2015-08-10T17:58:14.599000 #3236] DEBUG -- : Thread-10076116: GET
> /repositories/2/reports/accessionsunprocessedreport?lock_version=&format=json
> [session: nil]
>
> D, [2015-08-10T17:58:14.602000 #3236] DEBUG -- : Thread-10076116:
> Post-processed params: {:format=>"json", :repo_id=>2}
>
> 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
>
> Rendered shared/_breadcrumb.html.erb (1.0ms)
>
> Rendered
> /opt/archivesspace-1.3.0/archivesspace/plugins/nla_accession_reports/frontend/views/reports/index.html.erb
> within layouts/application (82.0ms)
>
> Rendered shared/_browser_support.html.erb (0.0ms)
>
> Rendered shared/_header_user.html.erb (6.0ms)
>
> Rendered shared/_header_global.html.erb (6.0ms)
>
> Rendered site/_branding.html.erb (0.0ms)
>
> Rendered shared/_advanced_search.html.erb (5.0ms)
>
> Rendered shared/_header_repository.html.erb (18.0ms)
>
> Rendered site/_footer.html.erb (0.0ms)
>
> Rendered shared/_templates.html.erb (2.0ms)
>
> Completed 200 OK in 448.0ms (Views: 114.0ms)
>
> Which is not helpful as it essentially just says exactly what gets
> displayed on the interface.
>
> net.sf.jasperreports.engine.JRException: Error executing SQL statement for
> : accessionsUnprocessed
>
> I?ve run the query in this report directly against the database
> successfully (cut and paste from
> reports/Accessions/AccessionsUnprocessedReport/AccessionsUnprocessedReport.jrxml
> and substituting in the repo id) so I think the SQL itself is sound.
>
> Further info:
>
> The report config being used are:
>
> #AppConfig[:report_page_layout] = "letter landscape"
>
> AppConfig[:enable_jasper] = true
>
> AppConfig[:compile_jasper] = true
> I?ve tried with the report_page_layout both commented and uncommented.
>
> The java version is:
>
> java version "1.7.0_85"
>
> OpenJDK Runtime Environment (rhel-2.6.1.3.el6_7-x86_64 u85-b01)
>
> OpenJDK 64-Bit Server VM (build 24.85-b03, mixed mode)
>
> Could there be an issue with using the OpenJDK rather than Oracle?s JDK
> perhaps ?
>
>
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>] On Behalf Of
> Brian Hoffman
> Sent: Friday, 14 August 2015 12:37 PM
> To: Archivesspace Users Group
>
> Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
>
> 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:
>
> https://github.com/archivesspace/archivesspace/pull/244<
> 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=
> >
>
> Brian
>
>
>
> On Aug 7, 2015, at 5:49 AM, Chris Fitzpatrick <
> Chris.Fitzpatrick at lyrasis.org<mailto:Chris.Fitzpatrick at lyrasis.org>>
> wrote:
>
>
> Hi Emma,
>
> Can you look at what's being output into the log?
>
> The easiest way to see what the report is doing is to look at the Jasper
> XML, which you can see here =>
> https://github.com/archivesspace/archivesspace/blob/master/reports/Accessions/AccessionsUnprocessedReport/AccessionsUnprocessedReport.jrxml#L20-L37
> <
> 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=
> >
>
> 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.
>
> b,chris.
>
> Chris Fitzpatrick | Developer, ArchivesSpace
> Skype: chrisfitzpat | Phone: 918.236.6048<tel:918.236.6048>
> http://archivesspace.org/<
> 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=
> >
>
> ________________________________
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> <
> archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>> on behalf of
> Emma Jolley <EJOLLEY at nla.gov.au<mailto:EJOLLEY at nla.gov.au>>
> Sent: Friday, August 7, 2015 7:13 AM
> To: Archivesspace Users Group (
> archivesspace_users_group at lyralists.lyrasis.org<mailto:
> archivesspace_users_group at lyralists.lyrasis.org>)
> Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
>
> Hi Chris
>
> 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?
>
> 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?
>
> Many thanks
>
> Emma
>
> <image007.png>
>
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Chris Fitzpatrick
> Sent: Thursday, 6 August 2015 9:16 PM
> To: Archivesspace Users Group
> Cc: Zalduendo, Ines; Wendler, Robin King; Della Monica, Ilaria
> Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
>
>
>
> Hi Robin,
>
> So, first you need to make sure you compiled your jasper reports on
> startup. To do this, edit the config.rb<
> 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=>
> file to have:
> AppConfig[:compile_jasper] = true
>
> and restart ASpace.
>
>
> This will compile the jasper jxml files ( which is most likely what's
> causing the "can't convert nil to String" errors)
>
> 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.
>
> 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 Jasper studio<
> 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=>.
> Just be sure to recompile your reports.
>
> For the parameters, yes this feature is going to be included in a future
> release. I believe those labels are artifacts from AT.
>
> best, Chris.
>
>
> Chris Fitzpatrick | Developer, ArchivesSpace
> Skype: chrisfitzpat | Phone: 918.236.6048<tel:918.236.6048>
> http://archivesspace.org/<
> 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=
> >
>
> ________________________________
> From:archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> <
> archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>> on behalf of
> McElheny, Robin G. <robin_mcelheny at harvard.edu<mailto:
> robin_mcelheny at harvard.edu>>
> Sent: Wednesday, August 5, 2015 5:55 PM
> To: Archivesspace Users Group
> Cc: Zalduendo, Ines; Wendler, Robin King; Della Monica, Ilaria
> Subject: [Archivesspace_Users_Group] Problems with ASpace reports
>
> 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.
> 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?
> Record selection issues:
>
> * The Accessions Acquired and Accessions Production reports supposedly
> allow for specified time periods, but no date parameters show up in the
> report user interface.
>
> <image008.jpg>
>
>
> * 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?
>
> Report format issues:
>
> * 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.
>
>
> * 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"
>
>
> * 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:
>
> 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,,,,:").
>
> Here is a screen shot:
> <image009.jpg>
>
> * Here?s another example:
>
> <image010.jpg>
>
> * In the case of an HTML report, it displays page footers ? odd for
> online display.
>
> <image011.jpg>
>
> Report failure/timeout:
>
> * We encountered many failures.
>
> Example:
> When we attempted to download an XLSX AccessionsAcquired report in the
> ArchivesSpace sandbox, we got the following message:
>
> Internal Server Error (500)
> Request Method: GET
> Request URL:
> http://localhost:8089/repositories/4/reports/accessionsacquiredreport?lock_version=&format=xlsx
> <
> 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=
> >
>
> (TypeError) can't convert nil into String
>
> You're seeing this error because you use JRuby::Rack::ErrorApp::ShowStatus.
>
> Another example:
> <image012.jpg>
>
> * 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.
>
>
> Robin McElheny
> Associate University Archivist for Collections and Public Services
> Harvard University Archives
> Pusey Library
> Cambridge, MA 02138
> Email: robin_mcelheny at harvard.edu<mailto:robin_mcelheny at harvard.edu>
> Phone: 617-495-2461<tel:617-495-2461>
> Fax: 617-495-8011<tel:617-495-8011>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:
> Archivesspace_Users_Group at lyralists.lyrasis.org>
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group<
> 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=
> >
>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:
> Archivesspace_Users_Group at lyralists.lyrasis.org>
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group<
> 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=
> >
>
>
>
> --
> Nathan Stevens
> Programmer/Analyst
> Digital Library Technology Services
> New York University
>
> 1212-998-2653
> ns96 at nyu.edu<mailto:ns96 at nyu.edu>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:
> Archivesspace_Users_Group at lyralists.lyrasis.org>
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group<
> 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=
> >
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150901/a1294729/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 7
> Date: Tue, 1 Sep 2015 17:38:32 -0400
> From: Brian Hoffman <brianjhoffman at gmail.com>
> To: Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
> Message-ID: <AA818295-FCC5-470D-B018-53FB54994642 at gmail.com>
> Content-Type: text/plain; charset="windows-1252"
>
> Hi Karrie,
>
> 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!
>
> https://github.com/quoideneuf/aspace_stored_procedures <
> https://github.com/quoideneuf/aspace_stored_procedures>
>
> 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!
>
> Brian
>
>
> > On Sep 1, 2015, at 5:33 PM, Karrie L Roberson <robersonkl at sfasu.edu>
> wrote:
> >
> > It returns "empty set". Is there anything we can do to add those stored
> procedures back?
> >
> > We had to make some changes to the data that got carried over from the
> migration from Archon. :/
> >
> > Thanks,
> > Karrie
> > From: archivesspace_users_group-bounces at lyralists.lyrasis.org [
> archivesspace_users_group-bounces at lyralists.lyrasis.org] on behalf of
> Brian Hoffman [brianjhoffman at gmail.com]
> > Sent: Tuesday, September 01, 2015 4:28 PM
> > To: Archivesspace Users Group
> > Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
> >
> > Hi,
> >
> > It sounds like you may have lost the mysql stored procedures that the
> reports require.
> >
> > What happens when you log in to mysql and type:
> >
> > > select name from mysql.proc
> >
> > ?
> >
> > P.S. What caused you to dump the mysql file, edit it, and reload it?
> That is not something I recommend doing.
> >
> >
> >
> >> On Sep 1, 2015, at 5:08 PM, Karrie L Roberson <robersonkl at sfasu.edu
> <mailto:robersonkl at sfasu.edu>> wrote:
> >>
> >> We're seeing the same type of messages as below with the messages that
> are seen below. Our error message is "ResourcesLocationsListReport -
> net.sf.jasperreports.engine.JRException: Error executing SQL statement for
> : resourcesLocationsList".
> >>
> >> We edited the 'config.rb' file with the jasper reports uncommented,
> updated the 2 files in the PR issue mentioned below, and restarted
> Archivesspace.
> >>
> >> 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.
> >>
> >> Thanks,
> >> Karrie
> >>
> >> ?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.?
> >> From: archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [
> archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>] on behalf of
> Emma Jolley [EJOLLEY at nla.gov.au <mailto:EJOLLEY at nla.gov.au>]
> >> Sent: Sunday, August 30, 2015 11:57 PM
> >> To: Archivesspace Users Group
> >> Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
> >>
> >> Hi
> >>
> >> 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?
> >>
> >> Thanks
> >>
> >> Emma
> >>
> >> From: archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>] On Behalf Of
> Nathan Stevens
> >> Sent: Friday, 14 August 2015 10:28 PM
> >> To: Archivesspace Users Group
> >> Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
> >>
> >> Hi,
> >>
> >> 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?
> >>
> >> On Fri, Aug 14, 2015 at 3:31 AM, Emma Jolley <EJOLLEY at nla.gov.au
> <mailto:EJOLLEY at nla.gov.au>> wrote:
> >> 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?
> >>
> >> Many thanks
> >>
> >> Emma
> >> ****
> >>
> >> The log entry when running (as an example) the report mentioned in the
> email below is:
> >>
> >> D, [2015-08-10T17:58:14.599000 #3236] DEBUG -- : Thread-10076116: GET
> /repositories/2/reports/accessionsunprocessedreport?lock_version=&format=json
> [session: nil]
> >>
> >> D, [2015-08-10T17:58:14.602000 #3236] DEBUG -- : Thread-10076116:
> Post-processed params: {:format=>"json", :repo_id=>2}
> >>
> >> 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
> >>
> >> Rendered shared/_breadcrumb.html.erb (1.0ms)
> >>
> >> Rendered
> /opt/archivesspace-1.3.0/archivesspace/plugins/nla_accession_reports/frontend/views/reports/index.html.erb
> within layouts/application (82.0ms)
> >>
> >> Rendered shared/_browser_support.html.erb (0.0ms)
> >>
> >> Rendered shared/_header_user.html.erb (6.0ms)
> >>
> >> Rendered shared/_header_global.html.erb (6.0ms)
> >>
> >> Rendered site/_branding.html.erb (0.0ms)
> >>
> >> Rendered shared/_advanced_search.html.erb (5.0ms)
> >>
> >> Rendered shared/_header_repository.html.erb (18.0ms)
> >>
> >> Rendered site/_footer.html.erb (0.0ms)
> >>
> >> Rendered shared/_templates.html.erb (2.0ms)
> >>
> >> Completed 200 OK in 448.0ms (Views: 114.0ms)
> >>
> >>
> >> Which is not helpful as it essentially just says exactly what gets
> displayed on the interface.
> >>
> >> net.sf.jasperreports.engine.JRException: Error executing SQL statement
> for : accessionsUnprocessed
> >>
> >> I?ve run the query in this report directly against the database
> successfully (cut and paste from
> reports/Accessions/AccessionsUnprocessedReport/AccessionsUnprocessedReport.jrxml
> and substituting in the repo id) so I think the SQL itself is sound.
> >>
> >> Further info:
> >>
> >> The report config being used are:
> >> #AppConfig[:report_page_layout] = "letter landscape"
> >>
> >> AppConfig[:enable_jasper] = true
> >>
> >> AppConfig[:compile_jasper] = true
> >> I?ve tried with the report_page_layout both commented and uncommented.
> >>
> >> The java version is:
> >> java version "1.7.0_85"
> >>
> >> OpenJDK Runtime Environment (rhel-2.6.1.3.el6_7-x86_64 u85-b01)
> >>
> >> OpenJDK 64-Bit Server VM (build 24.85-b03, mixed mode)
> >>
> >>
> >> Could there be an issue with using the OpenJDK rather than Oracle?s JDK
> perhaps ?
> >>
> >>
> >>
> >> From: archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>] On Behalf Of
> Brian Hoffman
> >> Sent: Friday, 14 August 2015 12:37 PM
> >> To: Archivesspace Users Group
> >>
> >> Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
> >>
> >> 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:
> >>
> >> https://github.com/archivesspace/archivesspace/pull/244 <
> 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=
> >
> >>
> >> Brian
> >>
> >>
> >>
> >> On Aug 7, 2015, at 5:49 AM, Chris Fitzpatrick <
> Chris.Fitzpatrick at lyrasis.org <mailto:Chris.Fitzpatrick at lyrasis.org>>
> wrote:
> >>
> >>
> >> Hi Emma,
> >>
> >> Can you look at what's being output into the log?
> >>
> >> The easiest way to see what the report is doing is to look at the
> Jasper XML, which you can see here =>
> https://github.com/archivesspace/archivesspace/blob/master/reports/Accessions/AccessionsUnprocessedReport/AccessionsUnprocessedReport.jrxml#L20-L37
> <
> 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=
> >
> >>
> >> 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.
> >>
> >> b,chris.
> >>
> >> Chris Fitzpatrick | Developer, ArchivesSpace
> >> Skype: chrisfitzpat | Phone: 918.236.6048 <tel:918.236.6048>
> >> http://archivesspace.org/ <
> 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=
> >
> >>
> >> From: archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> <
> archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>> on behalf of
> Emma Jolley <EJOLLEY at nla.gov.au <mailto:EJOLLEY at nla.gov.au>>
> >> Sent: Friday, August 7, 2015 7:13 AM
> >> To: Archivesspace Users Group (
> archivesspace_users_group at lyralists.lyrasis.org <mailto:
> archivesspace_users_group at lyralists.lyrasis.org>)
> >> Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
> >>
> >> Hi Chris
> >>
> >> 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?
> >>
> >> 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?
> >>
> >> Many thanks
> >>
> >> Emma
> >>
> >> <image007.png>
> >>
> >>
> >> From: archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>] On Behalf Of
> Chris Fitzpatrick
> >> Sent: Thursday, 6 August 2015 9:16 PM
> >> To: Archivesspace Users Group
> >> Cc: Zalduendo, Ines; Wendler, Robin King; Della Monica, Ilaria
> >> Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
> >>
> >>
> >>
> >> Hi Robin,
> >>
> >> So, first you need to make sure you compiled your jasper reports on
> startup. To do this, edit the config.rb <
> 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=>
> file to have:
> >> AppConfig[:compile_jasper] = true
> >>
> >> and restart ASpace.
> >>
> >>
> >> This will compile the jasper jxml files ( which is most likely what's
> causing the "can't convert nil to String" errors)
> >>
> >> 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.
> >>
> >> 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 Jasper studio <
> 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=>.
> Just be sure to recompile your reports.
> >>
> >> For the parameters, yes this feature is going to be included in a
> future release. I believe those labels are artifacts from AT.
> >>
> >> best, Chris.
> >>
> >>
> >> Chris Fitzpatrick | Developer, ArchivesSpace
> >> Skype: chrisfitzpat | Phone: 918.236.6048 <tel:918.236.6048>
> >> http://archivesspace.org/ <
> 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=
> >
> >>
> >> From:archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> <
> archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>> on behalf of
> McElheny, Robin G. <robin_mcelheny at harvard.edu <mailto:
> robin_mcelheny at harvard.edu>>
> >> Sent: Wednesday, August 5, 2015 5:55 PM
> >> To: Archivesspace Users Group
> >> Cc: Zalduendo, Ines; Wendler, Robin King; Della Monica, Ilaria
> >> Subject: [Archivesspace_Users_Group] Problems with ASpace reports
> >>
> >> 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.
> >> 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?
> >> Record selection issues:
> >> The Accessions Acquired and Accessions Production reports supposedly
> allow for specified time periods, but no date parameters show up in the
> report user interface.
> >> <image008.jpg>
> >>
> >> 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?
> >>
> >> Report format issues:
> >> 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.
> >>
> >> 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"
> >>
> >> 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:
> >>
> >> 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,,,,:").
> >>
> >> Here is a screen shot:
> >> <image009.jpg>
> >> Here?s another example:
> >> <image010.jpg>
> >> In the case of an HTML report, it displays page footers ? odd for
> online display.
> >> <image011.jpg>
> >>
> >> Report failure/timeout:
> >> We encountered many failures.
> >> Example:
> >> When we attempted to download an XLSX AccessionsAcquired report in the
> ArchivesSpace sandbox, we got the following message:
> >>
> >> Internal Server Error (500)
> >> Request Method: GET
> >> Request URL:
> http://localhost:8089/repositories/4/reports/accessionsacquiredreport?lock_version=&format=xlsx
> <
> 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=
> >
> >>
> >> (TypeError) can't convert nil into String
> >>
> >> You're seeing this error because you use
> JRuby::Rack::ErrorApp::ShowStatus.
> >>
> >> Another example:
> >> <image012.jpg>
> >> 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.
> >>
> >>
> >> Robin McElheny
> >> Associate University Archivist for Collections and Public Services
> >> Harvard University Archives
> >> Pusey Library
> >> Cambridge, MA 02138
> >> Email: robin_mcelheny at harvard.edu <mailto:robin_mcelheny at harvard.edu>
> >> Phone: 617-495-2461 <tel:617-495-2461>
> >> Fax: 617-495-8011 <tel:617-495-8011>
> >>
> >> _______________________________________________
> >> Archivesspace_Users_Group mailing list
> >> Archivesspace_Users_Group at lyralists.lyrasis.org <mailto:
> Archivesspace_Users_Group at lyralists.lyrasis.org>
> >> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
> <
> 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=
> >
> >>
> >>
> >> _______________________________________________
> >> Archivesspace_Users_Group mailing list
> >> Archivesspace_Users_Group at lyralists.lyrasis.org <mailto:
> Archivesspace_Users_Group at lyralists.lyrasis.org>
> >> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
> <
> 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=
> >
> >>
> >>
> >>
> >> --
> >> Nathan Stevens
> >> Programmer/Analyst
> >> Digital Library Technology Services
> >> New York University
> >>
> >> 1212-998-2653
> >> ns96 at nyu.edu <mailto:ns96 at nyu.edu
> >_______________________________________________
> >> Archivesspace_Users_Group mailing list
> >> Archivesspace_Users_Group at lyralists.lyrasis.org <mailto:
> Archivesspace_Users_Group at lyralists.lyrasis.org>
> >> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
> <
> 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=
> >
> > _______________________________________________
> > Archivesspace_Users_Group mailing list
> > Archivesspace_Users_Group at lyralists.lyrasis.org <mailto:
> Archivesspace_Users_Group at lyralists.lyrasis.org>
> > http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
> <http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150901/214b8179/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 8
> Date: Tue, 01 Sep 2015 21:43:02 +0000
> From: Karrie L Roberson <robersonkl at sfasu.edu>
> To: Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
> Message-ID:
> <FB588ACBDDC20844988B2EDA4EB2496B01C66FE545 at EXCHMBOX01.sfasu.nac>
> Content-Type: text/plain; charset="windows-1252"
>
> (Lol...after this I won't...;) ) 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.
>
> Thank you Brian for such a quick response!
>
> Thanks,
> Karrie
>
> ?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.?
> ________________________________
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org [
> archivesspace_users_group-bounces at lyralists.lyrasis.org] on behalf of
> Brian Hoffman [brianjhoffman at gmail.com]
> Sent: Tuesday, September 01, 2015 4:38 PM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
>
> Hi Karrie,
>
> 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!
>
> https://github.com/quoideneuf/aspace_stored_procedures<
> 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=
> >
>
> 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!
>
> Brian
>
>
> On Sep 1, 2015, at 5:33 PM, Karrie L Roberson <robersonkl at sfasu.edu
> <mailto:robersonkl at sfasu.edu>> wrote:
>
> It returns "empty set". Is there anything we can do to add those stored
> procedures back?
>
> We had to make some changes to the data that got carried over from the
> migration from Archon. :/
>
> Thanks,
> Karrie
> ________________________________
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [
> archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>] on behalf of
> Brian Hoffman [brianjhoffman at gmail.com<mailto:brianjhoffman at gmail.com>]
> Sent: Tuesday, September 01, 2015 4:28 PM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
>
> Hi,
>
> It sounds like you may have lost the mysql stored procedures that the
> reports require.
>
> What happens when you log in to mysql and type:
>
> > select name from mysql.proc
>
> ?
>
> P.S. What caused you to dump the mysql file, edit it, and reload it? That
> is not something I recommend doing.
>
>
>
> On Sep 1, 2015, at 5:08 PM, Karrie L Roberson <robersonkl at sfasu.edu
> <mailto:robersonkl at sfasu.edu>> wrote:
>
> We're seeing the same type of messages as below with the messages that are
> seen below. Our error message is "ResourcesLocationsListReport -
> net.sf.jasperreports.engine.JRException: Error executing SQL statement for
> : resourcesLocationsList".
>
> We edited the 'config.rb' file with the jasper reports uncommented,
> updated the 2 files in the PR issue mentioned below, and restarted
> Archivesspace.
>
> 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.
>
> Thanks,
> Karrie
>
> ?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.?
> ________________________________
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [
> archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>] on behalf of
> Emma Jolley [EJOLLEY at nla.gov.au<mailto:EJOLLEY at nla.gov.au>]
> Sent: Sunday, August 30, 2015 11:57 PM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
>
> Hi
>
> 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?
>
> Thanks
>
> Emma
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Nathan Stevens
> Sent: Friday, 14 August 2015 10:28 PM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
>
> Hi,
>
> 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?
>
> On Fri, Aug 14, 2015 at 3:31 AM, Emma Jolley <EJOLLEY at nla.gov.au<mailto:
> EJOLLEY at nla.gov.au>> wrote:
> 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?
>
> Many thanks
>
> Emma
> ****
>
> The log entry when running (as an example) the report mentioned in the
> email below is:
>
>
> D, [2015-08-10T17:58:14.599000 #3236] DEBUG -- : Thread-10076116: GET
> /repositories/2/reports/accessionsunprocessedreport?lock_version=&format=json
> [session: nil]
>
> D, [2015-08-10T17:58:14.602000 #3236] DEBUG -- : Thread-10076116:
> Post-processed params: {:format=>"json", :repo_id=>2}
>
> 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
>
> Rendered shared/_breadcrumb.html.erb (1.0ms)
>
> Rendered
> /opt/archivesspace-1.3.0/archivesspace/plugins/nla_accession_reports/frontend/views/reports/index.html.erb
> within layouts/application (82.0ms)
>
> Rendered shared/_browser_support.html.erb (0.0ms)
>
> Rendered shared/_header_user.html.erb (6.0ms)
>
> Rendered shared/_header_global.html.erb (6.0ms)
>
> Rendered site/_branding.html.erb (0.0ms)
>
> Rendered shared/_advanced_search.html.erb (5.0ms)
>
> Rendered shared/_header_repository.html.erb (18.0ms)
>
> Rendered site/_footer.html.erb (0.0ms)
>
> Rendered shared/_templates.html.erb (2.0ms)
>
> Completed 200 OK in 448.0ms (Views: 114.0ms)
>
> Which is not helpful as it essentially just says exactly what gets
> displayed on the interface.
>
> net.sf.jasperreports.engine.JRException: Error executing SQL statement for
> : accessionsUnprocessed
>
> I?ve run the query in this report directly against the database
> successfully (cut and paste from
> reports/Accessions/AccessionsUnprocessedReport/AccessionsUnprocessedReport.jrxml
> and substituting in the repo id) so I think the SQL itself is sound.
>
> Further info:
>
> The report config being used are:
>
> #AppConfig[:report_page_layout] = "letter landscape"
>
> AppConfig[:enable_jasper] = true
>
> AppConfig[:compile_jasper] = true
> I?ve tried with the report_page_layout both commented and uncommented.
>
> The java version is:
>
> java version "1.7.0_85"
>
> OpenJDK Runtime Environment (rhel-2.6.1.3.el6_7-x86_64 u85-b01)
>
> OpenJDK 64-Bit Server VM (build 24.85-b03, mixed mode)
>
> Could there be an issue with using the OpenJDK rather than Oracle?s JDK
> perhaps ?
>
>
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>] On Behalf Of
> Brian Hoffman
> Sent: Friday, 14 August 2015 12:37 PM
> To: Archivesspace Users Group
>
> Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
>
> 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:
>
> https://github.com/archivesspace/archivesspace/pull/244<
> 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=
> >
>
> Brian
>
>
>
> On Aug 7, 2015, at 5:49 AM, Chris Fitzpatrick <
> Chris.Fitzpatrick at lyrasis.org<mailto:Chris.Fitzpatrick at lyrasis.org>>
> wrote:
>
>
> Hi Emma,
>
> Can you look at what's being output into the log?
>
> The easiest way to see what the report is doing is to look at the Jasper
> XML, which you can see here =>
> https://github.com/archivesspace/archivesspace/blob/master/reports/Accessions/AccessionsUnprocessedReport/AccessionsUnprocessedReport.jrxml#L20-L37
> <
> 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=
> >
>
> 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.
>
> b,chris.
>
> Chris Fitzpatrick | Developer, ArchivesSpace
> Skype: chrisfitzpat | Phone: 918.236.6048<tel:918.236.6048>
> http://archivesspace.org/<
> 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=
> >
>
> ________________________________
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> <
> archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>> on behalf of
> Emma Jolley <EJOLLEY at nla.gov.au<mailto:EJOLLEY at nla.gov.au>>
> Sent: Friday, August 7, 2015 7:13 AM
> To: Archivesspace Users Group (
> archivesspace_users_group at lyralists.lyrasis.org<mailto:
> archivesspace_users_group at lyralists.lyrasis.org>)
> Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
>
> Hi Chris
>
> 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?
>
> 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?
>
> Many thanks
>
> Emma
>
> <image007.png>
>
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Chris Fitzpatrick
> Sent: Thursday, 6 August 2015 9:16 PM
> To: Archivesspace Users Group
> Cc: Zalduendo, Ines; Wendler, Robin King; Della Monica, Ilaria
> Subject: Re: [Archivesspace_Users_Group] Problems with ASpace reports
>
>
>
> Hi Robin,
>
> So, first you need to make sure you compiled your jasper reports on
> startup. To do this, edit the config.rb<
> 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=>
> file to have:
> AppConfig[:compile_jasper] = true
>
> and restart ASpace.
>
>
> This will compile the jasper jxml files ( which is most likely what's
> causing the "can't convert nil to String" errors)
>
> 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.
>
> 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 Jasper studio<
> 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=>.
> Just be sure to recompile your reports.
>
> For the parameters, yes this feature is going to be included in a future
> release. I believe those labels are artifacts from AT.
>
> best, Chris.
>
>
> Chris Fitzpatrick | Developer, ArchivesSpace
> Skype: chrisfitzpat | Phone: 918.236.6048<tel:918.236.6048>
> http://archivesspace.org/<
> 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=
> >
>
> ________________________________
> From:archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> <
> archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>> on behalf of
> McElheny, Robin G. <robin_mcelheny at harvard.edu<mailto:
> robin_mcelheny at harvard.edu>>
> Sent: Wednesday, August 5, 2015 5:55 PM
> To: Archivesspace Users Group
> Cc: Zalduendo, Ines; Wendler, Robin King; Della Monica, Ilaria
> Subject: [Archivesspace_Users_Group] Problems with ASpace reports
>
> 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.
> 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?
> Record selection issues:
>
> * The Accessions Acquired and Accessions Production reports supposedly
> allow for specified time periods, but no date parameters show up in the
> report user interface.
>
> <image008.jpg>
>
>
> * 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?
>
> Report format issues:
>
> * 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.
>
>
> * 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"
>
>
> * 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:
>
> 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,,,,:").
>
> Here is a screen shot:
> <image009.jpg>
>
> * Here?s another example:
>
> <image010.jpg>
>
> * In the case of an HTML report, it displays page footers ? odd for
> online display.
>
> <image011.jpg>
>
> Report failure/timeout:
>
> * We encountered many failures.
>
> Example:
> When we attempted to download an XLSX AccessionsAcquired report in the
> ArchivesSpace sandbox, we got the following message:
>
> Internal Server Error (500)
> Request Method: GET
> Request URL:
> http://localhost:8089/repositories/4/reports/accessionsacquiredreport?lock_version=&format=xlsx
> <
> 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=
> >
>
> (TypeError) can't convert nil into String
>
> You're seeing this error because you use JRuby::Rack::ErrorApp::ShowStatus.
>
> Another example:
> <image012.jpg>
>
> * 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.
>
>
> Robin McElheny
> Associate University Archivist for Collections and Public Services
> Harvard University Archives
> Pusey Library
> Cambridge, MA 02138
> Email: robin_mcelheny at harvard.edu<mailto:robin_mcelheny at harvard.edu>
> Phone: 617-495-2461<tel:617-495-2461>
> Fax: 617-495-8011<tel:617-495-8011>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:
> Archivesspace_Users_Group at lyralists.lyrasis.org>
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group<
> 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=
> >
>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:
> Archivesspace_Users_Group at lyralists.lyrasis.org>
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group<
> 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=
> >
>
>
>
> --
> Nathan Stevens
> Programmer/Analyst
> Digital Library Technology Services
> New York University
>
> 1212-998-2653
> ns96 at nyu.edu<mailto:ns96 at nyu.edu>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:
> Archivesspace_Users_Group at lyralists.lyrasis.org>
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group<
> 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=
> >
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:
> Archivesspace_Users_Group at lyralists.lyrasis.org>
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group<
> 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=
> >
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150901/94454e23/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 9
> Date: Tue, 1 Sep 2015 22:41:03 +0000
> From: "Hughes, Margaret (Library)" <Margaret.Hughes at ucsf.edu>
> To: "archivesspace_users_group at lyralists.lyrasis.org"
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: [Archivesspace_Users_Group] import error, record_uri=doesn't
> exist
> Message-ID:
> <97D70967DDC99445AD5ECD700A905CAC5DE7E355 at ex08.net.ucsf.edu>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi all,
>
> I'm receiving this error when attempting to import an accessions csv file:
>
> !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
> IMPORT ERROR
> !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
>
>
> Error: #<Sequel::Error: method record_uri= doesn't exist>
> !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
>
> I saw Jared Campbell's earlier emails regarding the same error, but I'm
> not quite sure what I need to do to fix this. We are using v1.2.0 and it's
> hosted by the CDL. Any help would be much appreciated!
>
> Best,
>
> Margaret Hughes
>
> UCSF Archives & Special Collections
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150901/3673b0eb/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 10
> Date: Wed, 2 Sep 2015 05:05:18 +0000
> From: Emily Pyers <epyers at slv.vic.gov.au>
> To: "archivesspace_users_group at lyralists.lyrasis.org"
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: [Archivesspace_Users_Group] Upper limit on PDF output?
> Message-ID: <0d342a274ba046ddb470cc3f861294ad at STAFFEXCH01.staff.local>
> Content-Type: text/plain; charset="utf-8"
>
> Hi,
>
> I?ve been waiting 4 hours for AS to print a resource to PDF. As far as I
> can tell, the log has been frozen on the same action for about 2 of those
> hours.
>
> It?s a pretty hefty list ? around 7,000 items under 26 series, so I?m
> wondering if I?ve maxed out the print to PDF option and it?s fallen over..
> Has anyone else had success with printing similarly large lists to PDF?
> And is there a known upper limit on Print to PDF?
>
> I tested the same list in Archivist?s Toolkit, and it managed to output
> the list in under 10 mins.
>
>
> Thanks,
> Emily Pyers
>
> Emily Pyers | Collections Cataloguing Librarian | Storage & Digital
> Collection Services
> State Library Victoria | 328 Swanston Street | Melbourne VIC 3000
> T +61 3 8664 7368 | epyers at slv.vic.gov.au
> slv.vic.gov.au<http://slv.vic.gov.au>
>
> [Australian Sketchbook]<
> http://www.slv.vic.gov.au/australian-sketchbook-exhibition?utm_source=esig&utm_medium=email&utm_campaign=Australian_Sketchbook
> >
>
> This message and any attachment is intended only for the use of the
> Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL.
> If you are not the intended recipient, you are hereby notified that any
> dissemination of this communication is strictly prohibited. If you have
> received this communication in error, please delete all copies of the
> message and its attachments and notify the sender immediately. Thank you.
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150902/88201039/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 11
> Date: Wed, 2 Sep 2015 12:29:09 +0000
> From: "Hurt, Tara (Library)" <HurtT at easternct.edu>
> To: Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] Help With Access
> Message-ID:
> <E1EA15AAC1FCD241BF30D0EA356C09842FB77D1C at ECSUMB2.easternct.edu>
> Content-Type: text/plain; charset="us-ascii"
>
> Good afternoon Brad. I followed the instructions to run a log report but
> I think I need out Systems Librarian to do this (I keep getting a
> administrative login screen).
>
> I am trying to get a log run now so I can send it to you. Tara
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Brad Westbrook
> Sent: Monday, August 31, 2015 10:12 AM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Help With Access
>
> Tara,
>
> Could you repeat the activity that produces the problem and then send us
> the log?
>
> Thanks,
>
> Brad W.
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Hurt, Tara (Library)
> Sent: Monday, August 31, 2015 9:55 AM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Help With Access
>
> Hi Brad.
>
> I have access to the following browsers, I usually use FireFox, but I have
> tried getting access on all three, with the same runtime error.
>
> Internet Explorer 10.0
> Mozilla FireFox
>
> I have even tried on a Mac, using Safari and I get the same runtime error.
>
> Thank you so much for your help, AS has been working very well so I am not
> sure why we are not having this glitch.
>
> I am in a meeting from 10-11 but then back at my office / machine. Thank
> you. Tara
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Brad Westbrook
> Sent: Monday, August 31, 2015 9:39 AM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Help With Access
>
> Hi, Tara,
>
> In what browser are you experiencing this problem? If IE, what version
> are you using?
>
> Brad W.
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Hurt, Tara (Library)
> Sent: Monday, August 31, 2015 9:34 AM
> To: Archivesspace Users Group
> Subject: [Archivesspace_Users_Group] Help With Access
>
> Good morning, I am still having trouble accessing Archives Space and I am
> getting run time errors.
> Last week I could not get the screen to stay active enough to capture BUT
> I did capture some screens today.
>
> The first capture below (first attachment) is the home screen I get ...
> all seems to be as normal here.
>
> Sometimes when I click to login in I get the run time error screen below.
> Sometimes if it does let me login, then as soon as I click on anything in
> AS, I get the run time error below (second screen shot attached).
>
> Cannot seem to get by this error .. we really need your help, it is the
> start of the academic year and we need the AS access.
>
> Thanks again for your help. Tara
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150902/ec4c56e3/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 12
> Date: Wed, 2 Sep 2015 17:24:50 +0000
> From: "Joshua D. Shaw" <Joshua.D.Shaw at dartmouth.edu>
> To: Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] Database Integrity Constraint
> Error on Agent Save
> Message-ID: <E5D9FCE3-2B1A-438F-910D-704BDE2AD8EF at dartmouth.edu>
> Content-Type: text/plain; charset="utf-8"
>
> Thanks, Brian. I'll try and reproduce and report back if I can.
>
> Joshua
>
> From: Brian Hoffman
> Reply-To: Archivesspace Users Group
> Date: Sunday, August 30, 2015 at 8:16 AM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Database Integrity Constraint
> Error on Agent Save
>
> Yes, I think this is related to the number field of the telephone table.
> Are you able to create the same agent record out of the context of the
> resource record? If you are able to reproduce this from a blank agent
> record, could you record the steps and file a bug?
>
>
> On Aug 28, 2015, at 4:56 PM, Joshua D. Shaw <Joshua.D.Shaw at dartmouth.edu
> <mailto:Joshua.D.Shaw at dartmouth.edu>> wrote:
>
> Has anyone seen the following error?
>
> Error:
> en.validation_errors.database_integrity_constraint_conflict__java__javasql__sqlexception__field__number__doesn_t_have_a_default_value
>
> This occurred when a user attempted to save an agent while creating a
> resources - i.e. the agent was created in the process of creating the
> resource.
>
> The error *may* be related to a plugin we had developed for us by
> Hudson-Molonglo, but the error is so unspecific its *very* difficult to
> tell exactly what caused the issue and none of the fields in the tables
> used by that plugin are named "number." I'm leaning toward the telephone
> table (the subsection of contact details) as the culprit since it does have
> a field "number" that does not have a default value set. Unfortunately, I
> haven't been able to replicate this issue, so its just the one data point:-(
>
> We are running at 1.3.0 *without* the latest performance patches.
>
> Thanks!
> Joshua
>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:
> Archivesspace_Users_Group at lyralists.lyrasis.org>
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150902/f197cfd2/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 13
> Date: Wed, 2 Sep 2015 17:04:28 -0700
> From: Kate Tasker <ktasker at library.berkeley.edu>
> To: ArchivesSpace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: [Archivesspace_Users_Group] default values in Accession and
> Resource Records
> Message-ID:
> <
> CAMYySQ31umEX_7m9XpPug0yxgvaMbAueDkj1MYZC+7CdmZh8AA at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Dear list,
>
> Can anyone share instructions on how to create and use default values in
> Accession and Resource records in version 1.3?
>
> I can see there's now an option to Edit Default Values in the
> Browse/Accessions or Browse/Resources results screens, and I located and
> ticked the check-box to "Pre-Populate Records" under the User Preference
> Defaults options. But for some reason the saved default values are still
> not appearing when I try and create new Accession or Resource Records -
> what am I missing?
>
> Thanks for any hints or help- we're eager to take advantage of this
> fabulous new feature!
>
> -Kate
>
>
> Kate Tasker
> Digital Archivist
> The Bancroft Library
> University of California
> Berkeley, CA 94720-6000
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150902/0ba1b900/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 14
> Date: Thu, 3 Sep 2015 13:07:34 +0000
> From: Brad Westbrook <brad.westbrook at lyrasis.org>
> To: "ktasker at library.berkeley.edu" <ktasker at library.berkeley.edu>,
> Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] default values in Accession
> and Resource Records
> Message-ID:
> <
> BN1PR08MB011E0246C2A7067590CCF9F94680 at BN1PR08MB011.namprd08.prod.outlook.com
> >
>
> Content-Type: text/plain; charset="utf-8"
>
> Hi, Kate, and everybody else,
>
> Here is first draft (still under review) for how to set default values in
> ArchivesSpace v. 1.3.0. Let me know if anything is unclear or even wrong.
>
> Best,
>
> Brad W.
>
> *********
>
>
> Default values
>
> Users can set default values throughout the application. Default values
> are typically set when the value of a field is very frequently the same
> across records. For instance, a segment of the identifier in an accession
> and / or resource record might be to indicate the custodial repository. If
> the repository identifier is set as a default value for a segment of the
> accession and / or resource identifier, then that segment will be populated
> with that identifier whenever a new accession or resource record is
> created. In short, setting default values for repetitive data values is a
> good way for repositories to streamline data input.
>
> Default values can be edited in a record that they have been applied to.
> Also default values can be reset at any time. Doing so will have no
> impact on applications of the prior default value; they will be retained in
> the records in which they were applied. But default values are not applied
> in spawning an accession or resource record from a source accession record.
>
> How to set default values:
>
> To set default values you need to log in to ArchivesSpaces as either an
> administrator or repository manager.
>
> Click on the option for My Repository Preferences
>
> [cid:image001.jpg at 01D0E628.5A7B3A50]
>
>
> And activate the option to pre-populate records
>
> [cid:image002.jpg at 01D0E628.5A7B3A50]
>
> Then click on Save to save your new preferences.
>
> Now open the browse list for the record type you want to set default
> values for and click on the option to Edit Default Values at the top of the
> list
>
> [cid:image003.jpg at 01D0E628.5A7B3A50]
>
> In the case of resources and digital objects, you will need to select
> between setting default values for the parent record or the component
> record:
>
> [cid:image004.jpg at 01D0E628.5A7B3A50]
>
> Next, open up a blank record of the type you set default values for, and
> enter the value defaults into the appropriate fields:
>
> [cid:image005.jpg at 01D0E628.5A7B3A50]
>
>
> Click on Save to save the default values to the template.
>
> When creating a new record, the default values should populate the fields
> to which they are assigned:
>
> [cid:image006.jpg at 01D0E628.5A7B3A50]
>
>
> At any time that you want to not apply the default values, simply return
> to and de-activate the option to pre-populate records. This will result in
> an empty template when you start a new record.
>
> Remember, setting default values is most effective for values that are the
> same across many records.
>
>
>
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Kate Tasker
> Sent: Wednesday, September 02, 2015 8:04 PM
> To: ArchivesSpace Users Group
> Subject: [Archivesspace_Users_Group] default values in Accession and
> Resource Records
>
> Dear list,
>
> Can anyone share instructions on how to create and use default values in
> Accession and Resource records in version 1.3?
>
> I can see there's now an option to Edit Default Values in the
> Browse/Accessions or Browse/Resources results screens, and I located and
> ticked the check-box to "Pre-Populate Records" under the User Preference
> Defaults options. But for some reason the saved default values are still
> not appearing when I try and create new Accession or Resource Records -
> what am I missing?
>
> Thanks for any hints or help- we're eager to take advantage of this
> fabulous new feature!
>
> -Kate
>
>
> Kate Tasker
> Digital Archivist
> The Bancroft Library
> University of California
> Berkeley, CA 94720-6000
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150903/69ee3ab3/attachment-0001.html
> >
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image001.jpg
> Type: image/jpeg
> Size: 8103 bytes
> Desc: image001.jpg
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150903/69ee3ab3/attachment-0006.jpg
> >
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image002.jpg
> Type: image/jpeg
> Size: 15501 bytes
> Desc: image002.jpg
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150903/69ee3ab3/attachment-0007.jpg
> >
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image003.jpg
> Type: image/jpeg
> Size: 8081 bytes
> Desc: image003.jpg
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150903/69ee3ab3/attachment-0008.jpg
> >
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image004.jpg
> Type: image/jpeg
> Size: 8393 bytes
> Desc: image004.jpg
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150903/69ee3ab3/attachment-0009.jpg
> >
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image005.jpg
> Type: image/jpeg
> Size: 29579 bytes
> Desc: image005.jpg
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150903/69ee3ab3/attachment-0010.jpg
> >
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image006.jpg
> Type: image/jpeg
> Size: 29942 bytes
> Desc: image006.jpg
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150903/69ee3ab3/attachment-0011.jpg
> >
>
> ------------------------------
>
> Message: 15
> Date: Thu, 3 Sep 2015 13:39:56 +0000
> From: "Suda, Phillip J" <psuda1 at tulane.edu>
> To: Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: [Archivesspace_Users_Group] ArchivesSpace functionality
> issues
> Message-ID:
> <
> CY1PR0301MB1273B4732DD9D4189B8F8269E5680 at CY1PR0301MB1273.namprd03.prod.outlook.com
> >
>
> Content-Type: text/plain; charset="us-ascii"
>
> Good morning all,
>
> We are noticing some basic functionality issues with
> ArchivesSpace; we are not sure if these are "baked in" and if an
> enhancement request is in order.
>
>
> 1. After clicking the repository tab, selecting a repository and
> performing a search; the search "breaks" and the user is no longer looking
> at materials soley within that repository; the search provides results from
> all objects/repos
>
> 2. Is there a way to append the container label to the end of a
> component title (i.e. 'component title + folder' or 'component title + box')
>
> 3. Has anyone created the ability to sort by Collection or Component
> ID in the public interface (not the staff interface where this is
> possible)? We have staff/users that like to sort these in order
>
> 4. We are noticing that Blank Note Fields are display in the public
> interface. Is there an option to simply have these blank note fields not
> display?
>
> Thank you,
>
> Phil
>
> Phillip Suda
> Systems Librarian
> Howard-Tilton Memorial Library
> Tulane University
> psuda1 at tulane.edu
> 504-865-5607
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150903/c5c337ef/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 16
> Date: Thu, 3 Sep 2015 10:35:23 -0400
> From: Maura Carbone <mauraa at brandeis.edu>
> To: Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] ArchivesSpace functionality
> issues
> Message-ID:
> <
> CANdYjfEFSjG9M-+rDkjBWWOBcdDF2+GZ1ATmd4ByAU1CfjBeqA at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Hi Phil,
>
> With regards to 2, I think you'd have to create a plugin and modify the
> code for that particular display
>
> I'm not entirely sure what you mean by 3. In the staff side, the resource
> sorting appears to be title, created, and modified.
>
> As for 4, if you unpublish them they shouldn't show up. Although if they're
> completely blank, it might make more sense to delete them?
>
> -Maura
>
> On Thu, Sep 3, 2015 at 9:39 AM, Suda, Phillip J <psuda1 at tulane.edu> wrote:
>
> > Good morning all,
> >
> >
> >
> > We are noticing some basic functionality issues with
> > ArchivesSpace; we are not sure if these are ?baked in? and if an
> > enhancement request is in order.
> >
> >
> >
> > 1. After clicking the repository tab, selecting a repository and
> > performing a search; the search ?breaks? and the user is no longer
> looking
> > at materials soley within that repository; the search provides results
> from
> > all objects/repos
> >
> > 2. Is there a way to append the container label to the end of a
> > component title (i.e. ?component title + folder? or ?component title +
> box?)
> >
> > 3. Has anyone created the ability to sort by Collection or
> > Component ID in the public interface (not the staff interface where this
> is
> > possible)? We have staff/users that like to sort these in order
> >
> > 4. We are noticing that Blank Note Fields are display in the public
> > interface. Is there an option to simply have these blank note fields not
> > display?
> >
> >
> >
> > Thank you,
> >
> >
> >
> > Phil
> >
> >
> >
> > Phillip Suda
> >
> > Systems Librarian
> >
> > Howard-Tilton Memorial Library
> >
> > Tulane University
> >
> > psuda1 at tulane.edu
> >
> > 504-865-5607
> >
> >
> >
> > _______________________________________________
> > Archivesspace_Users_Group mailing list
> > Archivesspace_Users_Group at lyralists.lyrasis.org
> > http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
> >
> >
>
>
> --
> Maura Carbone
> Digital Initiatives Librarian
> Brandeis University
> Library and Technology Services
> (781) 736-4659
> 415 South Street, (MS 017/P.O. Box 549110)
> Waltham, MA 02454-9110
> email: mauraa at brandeis.edu
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150903/1dd6f892/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 17
> Date: Thu, 3 Sep 2015 15:20:46 +0000
> From: "Custer, Mark" <mark.custer at yale.edu>
> To: Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] ArchivesSpace functionality
> issues
> Message-ID:
> <DCB910FAD4CF9343B3E424AF5F3310252C5334BA at X10-MBX12.yu.yale.edu>
> Content-Type: text/plain; charset="utf-8"
>
> Phil,
>
> Just a quick note to say that all of the issues that you raised are
> currently under review of the ArchivesSpace Public Interface Enhancement
> group,
> https://archivesspace.atlassian.net/wiki/display/ADC/Public+Interface+Enhancement+Project
> . This group is still in its early stages, and we?re still uncovering
> changes needed for the public interface, so there isn?t a firm timeline yet
> for when the first round of enhancements will be added to the core code.
>
> Right off the top of my head, I?d say that #1 is definitely a bug (and
> it?s one that?s bugged me, too); #2 is something that I?d like to have more
> information about, since I don?t know if that would work for most archival
> descriptions (but you could always create that behavior with a plugin, as
> Maura notes); to me, the container information just needs to display closer
> to the title, not in an ?Instance? section, and certainly not with any
> labels like ?container 2 indicator? in the display; #3 has certainly come
> up in user testing, so it will be added to the interface in some way; and
> #4 is also something that I?d consider a sensible default (i.e. blank data
> can be suppressed, whether it has a header or not), but as Maura mentions
> this is just masking the issue at hand, and you won?t want to keep around
> blank fields in the database anyway?. So on that point, I?d say that it
> would be nice, in the future, if members developed plugins or other means
> to support data cleanup activ
> ities on the staff side (validate and remediate, as needed!)
>
> Also, please keep reporting any issues that you see with the public
> interface. Many of these issues are logged in the ArchivesSpace JIRA
> account, but not all of them just yet, and it?s likely that other issues
> still need to be discovered and reported.
>
> Mark
>
>
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Maura Carbone
> Sent: Thursday, September 03, 2015 10:35 AM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] ArchivesSpace functionality issues
>
> Hi Phil,
>
> With regards to 2, I think you'd have to create a plugin and modify the
> code for that particular display
>
> I'm not entirely sure what you mean by 3. In the staff side, the resource
> sorting appears to be title, created, and modified.
>
> As for 4, if you unpublish them they shouldn't show up. Although if
> they're completely blank, it might make more sense to delete them?
>
> -Maura
>
> On Thu, Sep 3, 2015 at 9:39 AM, Suda, Phillip J <psuda1 at tulane.edu<mailto:
> psuda1 at tulane.edu>> wrote:
> Good morning all,
>
> We are noticing some basic functionality issues with
> ArchivesSpace; we are not sure if these are ?baked in? and if an
> enhancement request is in order.
>
>
> 1. After clicking the repository tab, selecting a repository and
> performing a search; the search ?breaks? and the user is no longer looking
> at materials soley within that repository; the search provides results from
> all objects/repos
>
> 2. Is there a way to append the container label to the end of a
> component title (i.e. ?component title + folder? or ?component title + box?)
>
> 3. Has anyone created the ability to sort by Collection or Component
> ID in the public interface (not the staff interface where this is
> possible)? We have staff/users that like to sort these in order
>
> 4. We are noticing that Blank Note Fields are display in the public
> interface. Is there an option to simply have these blank note fields not
> display?
>
> Thank you,
>
> Phil
>
> Phillip Suda
> Systems Librarian
> Howard-Tilton Memorial Library
> Tulane University
> psuda1 at tulane.edu<mailto:psuda1 at tulane.edu>
> 504-865-5607<tel:504-865-5607>
>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:
> Archivesspace_Users_Group at lyralists.lyrasis.org>
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group<
> https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=AwMFaQ&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=s7ciGQfUJeaV_ryx908hbeXDoU9aqDwDN0Z0VbfsJ3Y&m=f2DYnx-rKcxx-dUpmoXENzt48EXipCQ9z16fPb-TqN0&s=B011-iEpyrkQ91ZegR17UbywbgO9cwNkati6NOB-Kz0&e=
> >
>
>
>
> --
> Maura Carbone
> Digital Initiatives Librarian
> Brandeis University
> Library and Technology Services
> (781) 736-4659
> 415 South Street, (MS 017/P.O. Box 549110)
> Waltham, MA 02454-9110
> email: mauraa at brandeis.edu<mailto:mauraa at brandeis.edu>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150903/25d9abc1/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 18
> Date: Thu, 3 Sep 2015 15:43:14 +0000
> From: "Suda, Phillip J" <psuda1 at tulane.edu>
> To: Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] ArchivesSpace functionality
> issues
> Message-ID:
> <
> CY1PR0301MB1273DAECB624707BDA6C80A9E5680 at CY1PR0301MB1273.namprd03.prod.outlook.com
> >
>
> Content-Type: text/plain; charset="utf-8"
>
> Thanks Maura,
>
> #2, I will look into a plugin to modify the display.
>
> #3, Staff/Users want to sort by Collection ID as well as by title,
> created, modified. The staff side does have this capability
>
> #4, I will definitely recommend having staff unpublish blank note fields.
> I was hoping that during the migration, these fields could be ?unpublished?
> as they are blank to being with.
>
> Thanks for your help,
>
> Phil
>
>
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Maura Carbone
> Sent: Thursday, September 03, 2015 9:35 AM
> To: Archivesspace Users Group <
> archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] ArchivesSpace functionality issues
>
> Hi Phil,
>
> With regards to 2, I think you'd have to create a plugin and modify the
> code for that particular display
>
> I'm not entirely sure what you mean by 3. In the staff side, the resource
> sorting appears to be title, created, and modified.
>
> As for 4, if you unpublish them they shouldn't show up. Although if
> they're completely blank, it might make more sense to delete them?
>
> -Maura
>
> On Thu, Sep 3, 2015 at 9:39 AM, Suda, Phillip J <psuda1 at tulane.edu<mailto:
> psuda1 at tulane.edu>> wrote:
> Good morning all,
>
> We are noticing some basic functionality issues with
> ArchivesSpace; we are not sure if these are ?baked in? and if an
> enhancement request is in order.
>
>
> 1. After clicking the repository tab, selecting a repository and
> performing a search; the search ?breaks? and the user is no longer looking
> at materials soley within that repository; the search provides results from
> all objects/repos
>
> 2. Is there a way to append the container label to the end of a
> component title (i.e. ?component title + folder? or ?component title + box?)
>
> 3. Has anyone created the ability to sort by Collection or Component
> ID in the public interface (not the staff interface where this is
> possible)? We have staff/users that like to sort these in order
>
> 4. We are noticing that Blank Note Fields are display in the public
> interface. Is there an option to simply have these blank note fields not
> display?
>
> Thank you,
>
> Phil
>
> Phillip Suda
> Systems Librarian
> Howard-Tilton Memorial Library
> Tulane University
> psuda1 at tulane.edu<mailto:psuda1 at tulane.edu>
> 504-865-5607<tel:504-865-5607>
>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:
> Archivesspace_Users_Group at lyralists.lyrasis.org>
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>
>
>
> --
> Maura Carbone
> Digital Initiatives Librarian
> Brandeis University
> Library and Technology Services
> (781) 736-4659
> 415 South Street, (MS 017/P.O. Box 549110)
> Waltham, MA 02454-9110
> email: mauraa at brandeis.edu<mailto:mauraa at brandeis.edu>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150903/cf36fd02/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 19
> Date: Thu, 3 Sep 2015 15:49:19 +0000
> From: "Suda, Phillip J" <psuda1 at tulane.edu>
> To: Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] ArchivesSpace functionality
> issues
> Message-ID:
> <
> CY1PR0301MB12739092C87745BEE5AC0810E5680 at CY1PR0301MB1273.namprd03.prod.outlook.com
> >
>
> Content-Type: text/plain; charset="utf-8"
>
> Thanks Mark, I will definitely be looking at the JIRA tickets (adding
> votes or new tickets as necessary).
>
>
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Custer, Mark
> Sent: Thursday, September 03, 2015 10:21 AM
> To: Archivesspace Users Group <
> archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] ArchivesSpace functionality issues
>
> Phil,
>
> Just a quick note to say that all of the issues that you raised are
> currently under review of the ArchivesSpace Public Interface Enhancement
> group,
> https://archivesspace.atlassian.net/wiki/display/ADC/Public+Interface+Enhancement+Project
> . This group is still in its early stages, and we?re still uncovering
> changes needed for the public interface, so there isn?t a firm timeline yet
> for when the first round of enhancements will be added to the core code.
>
> Right off the top of my head, I?d say that #1 is definitely a bug (and
> it?s one that?s bugged me, too); #2 is something that I?d like to have more
> information about, since I don?t know if that would work for most archival
> descriptions (but you could always create that behavior with a plugin, as
> Maura notes); to me, the container information just needs to display closer
> to the title, not in an ?Instance? section, and certainly not with any
> labels like ?container 2 indicator? in the display; #3 has certainly come
> up in user testing, so it will be added to the interface in some way; and
> #4 is also something that I?d consider a sensible default (i.e. blank data
> can be suppressed, whether it has a header or not), but as Maura mentions
> this is just masking the issue at hand, and you won?t want to keep around
> blank fields in the database anyway?. So on that point, I?d say that it
> would be nice, in the future, if members developed plugins or other means
> to support data cleanup activ
> ities on the staff side (validate and remediate, as needed!)
>
> Also, please keep reporting any issues that you see with the public
> interface. Many of these issues are logged in the ArchivesSpace JIRA
> account, but not all of them just yet, and it?s likely that other issues
> still need to be discovered and reported.
>
> Mark
>
>
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Maura Carbone
> Sent: Thursday, September 03, 2015 10:35 AM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] ArchivesSpace functionality issues
>
> Hi Phil,
>
> With regards to 2, I think you'd have to create a plugin and modify the
> code for that particular display
>
> I'm not entirely sure what you mean by 3. In the staff side, the resource
> sorting appears to be title, created, and modified.
>
> As for 4, if you unpublish them they shouldn't show up. Although if
> they're completely blank, it might make more sense to delete them?
>
> -Maura
>
> On Thu, Sep 3, 2015 at 9:39 AM, Suda, Phillip J <psuda1 at tulane.edu<mailto:
> psuda1 at tulane.edu>> wrote:
> Good morning all,
>
> We are noticing some basic functionality issues with
> ArchivesSpace; we are not sure if these are ?baked in? and if an
> enhancement request is in order.
>
>
> 1. After clicking the repository tab, selecting a repository and
> performing a search; the search ?breaks? and the user is no longer looking
> at materials soley within that repository; the search provides results from
> all objects/repos
>
> 2. Is there a way to append the container label to the end of a
> component title (i.e. ?component title + folder? or ?component title + box?)
>
> 3. Has anyone created the ability to sort by Collection or Component
> ID in the public interface (not the staff interface where this is
> possible)? We have staff/users that like to sort these in order
>
> 4. We are noticing that Blank Note Fields are display in the public
> interface. Is there an option to simply have these blank note fields not
> display?
>
> Thank you,
>
> Phil
>
> Phillip Suda
> Systems Librarian
> Howard-Tilton Memorial Library
> Tulane University
> psuda1 at tulane.edu<mailto:psuda1 at tulane.edu>
> 504-865-5607<tel:504-865-5607>
>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:
> Archivesspace_Users_Group at lyralists.lyrasis.org>
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group<
> https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=AwMFaQ&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=s7ciGQfUJeaV_ryx908hbeXDoU9aqDwDN0Z0VbfsJ3Y&m=f2DYnx-rKcxx-dUpmoXENzt48EXipCQ9z16fPb-TqN0&s=B011-iEpyrkQ91ZegR17UbywbgO9cwNkati6NOB-Kz0&e=
> >
>
>
>
> --
> Maura Carbone
> Digital Initiatives Librarian
> Brandeis University
> Library and Technology Services
> (781) 736-4659
> 415 South Street, (MS 017/P.O. Box 549110)
> Waltham, MA 02454-9110
> email: mauraa at brandeis.edu<mailto:mauraa at brandeis.edu>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150903/37ffeab4/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 20
> Date: Thu, 3 Sep 2015 15:02:50 -0400
> From: Maura Carbone <mauraa at brandeis.edu>
> To: Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] ArchivesSpace functionality
> issues
> Message-ID:
> <CANdYjfHfLTmFnNFO-Y8dcaNikZn9wGJanFdzkSfeOwfsV2=
> wOw at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Just curious, where on the staff page can you sort by Collection ID? I only
> see Title, Created, Modified in my version and in the sandbox, but I might
> not be looking at the proper view.
>
> On Thu, Sep 3, 2015 at 11:49 AM, Suda, Phillip J <psuda1 at tulane.edu>
> wrote:
>
> > Thanks Mark, I will definitely be looking at the JIRA tickets (adding
> > votes or new tickets as necessary).
> >
> >
> >
> >
> >
> >
> >
> > *From:* archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:
> > archivesspace_users_group-bounces at lyralists.lyrasis.org] *On Behalf Of
> *Custer,
> > Mark
> > *Sent:* Thursday, September 03, 2015 10:21 AM
> > *To:* Archivesspace Users Group <
> > archivesspace_users_group at lyralists.lyrasis.org>
> >
> > *Subject:* Re: [Archivesspace_Users_Group] ArchivesSpace functionality
> > issues
> >
> >
> >
> > Phil,
> >
> >
> >
> > Just a quick note to say that all of the issues that you raised are
> > currently under review of the ArchivesSpace Public Interface Enhancement
> > group,
> >
> https://archivesspace.atlassian.net/wiki/display/ADC/Public+Interface+Enhancement+Project
> > . This group is still in its early stages, and we?re still uncovering
> > changes needed for the public interface, so there isn?t a firm timeline
> yet
> > for when the first round of enhancements will be added to the core code.
> >
> >
> >
> > Right off the top of my head, I?d say that #1 is definitely a bug (and
> > it?s one that?s bugged me, too); #2 is something that I?d like to have
> more
> > information about, since I don?t know if that would work for most
> archival
> > descriptions (but you could always create that behavior with a plugin, as
> > Maura notes); to me, the container information just needs to display
> closer
> > to the title, not in an ?Instance? section, and certainly not with any
> > labels like ?container 2 indicator? in the display; #3 has certainly come
> > up in user testing, so it will be added to the interface in some way; and
> > #4 is also something that I?d consider a sensible default (i.e. blank
> data
> > can be suppressed, whether it has a header or not), but as Maura mentions
> > this is just masking the issue at hand, and you won?t want to keep around
> > blank fields in the database anyway?. So on that point, I?d say that it
> > would be nice, in the future, if members developed plugins or other means
> > to support data cleanup activities on the staff side (validate and
> > remediate, as needed!)
> >
> >
> >
> > Also, please keep reporting any issues that you see with the public
> > interface. Many of these issues are logged in the ArchivesSpace JIRA
> > account, but not all of them just yet, and it?s likely that other issues
> > still need to be discovered and reported.
> >
> >
> >
> > Mark
> >
> >
> >
> >
> >
> >
> >
> > *From:* archivesspace_users_group-bounces at lyralists.lyrasis.org [
> > mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org
> > <archivesspace_users_group-bounces at lyralists.lyrasis.org>] *On Behalf
> Of *Maura
> > Carbone
> > *Sent:* Thursday, September 03, 2015 10:35 AM
> > *To:* Archivesspace Users Group
> > *Subject:* Re: [Archivesspace_Users_Group] ArchivesSpace functionality
> > issues
> >
> >
> >
> > Hi Phil,
> >
> >
> >
> > With regards to 2, I think you'd have to create a plugin and modify the
> > code for that particular display
> >
> >
> >
> > I'm not entirely sure what you mean by 3. In the staff side, the resource
> > sorting appears to be title, created, and modified.
> >
> >
> >
> > As for 4, if you unpublish them they shouldn't show up. Although if
> > they're completely blank, it might make more sense to delete them?
> >
> >
> >
> > -Maura
> >
> >
> >
> > On Thu, Sep 3, 2015 at 9:39 AM, Suda, Phillip J <psuda1 at tulane.edu>
> wrote:
> >
> > Good morning all,
> >
> >
> >
> > We are noticing some basic functionality issues with
> > ArchivesSpace; we are not sure if these are ?baked in? and if an
> > enhancement request is in order.
> >
> >
> >
> > 1. After clicking the repository tab, selecting a repository and
> > performing a search; the search ?breaks? and the user is no longer
> looking
> > at materials soley within that repository; the search provides results
> from
> > all objects/repos
> >
> > 2. Is there a way to append the container label to the end of a
> > component title (i.e. ?component title + folder? or ?component title +
> box?)
> >
> > 3. Has anyone created the ability to sort by Collection or
> > Component ID in the public interface (not the staff interface where this
> is
> > possible)? We have staff/users that like to sort these in order
> >
> > 4. We are noticing that Blank Note Fields are display in the public
> > interface. Is there an option to simply have these blank note fields not
> > display?
> >
> >
> >
> > Thank you,
> >
> >
> >
> > Phil
> >
> >
> >
> > Phillip Suda
> >
> > Systems Librarian
> >
> > Howard-Tilton Memorial Library
> >
> > Tulane University
> >
> > psuda1 at tulane.edu
> >
> > 504-865-5607
> >
> >
> >
> >
> > _______________________________________________
> > Archivesspace_Users_Group mailing list
> > Archivesspace_Users_Group at lyralists.lyrasis.org
> > http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
> > <
> https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=AwMFaQ&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=s7ciGQfUJeaV_ryx908hbeXDoU9aqDwDN0Z0VbfsJ3Y&m=f2DYnx-rKcxx-dUpmoXENzt48EXipCQ9z16fPb-TqN0&s=B011-iEpyrkQ91ZegR17UbywbgO9cwNkati6NOB-Kz0&e=
> >
> >
> >
> >
> >
> >
> > --
> >
> > Maura Carbone
> >
> > Digital Initiatives Librarian
> > Brandeis University
> > Library and Technology Services
> > (781) 736-4659
> > 415 South Street, (MS 017/P.O. Box 549110)
> > Waltham, MA 02454-9110
> > email: mauraa at brandeis.edu
> >
> > _______________________________________________
> > Archivesspace_Users_Group mailing list
> > Archivesspace_Users_Group at lyralists.lyrasis.org
> > http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
> >
> >
>
>
> --
> Maura Carbone
> Digital Initiatives Librarian
> Brandeis University
> Library and Technology Services
> (781) 736-4659
> 415 South Street, (MS 017/P.O. Box 549110)
> Waltham, MA 02454-9110
> email: mauraa at brandeis.edu
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150903/19ef928b/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 21
> Date: Thu, 3 Sep 2015 19:13:31 +0000
> From: "Suda, Phillip J" <psuda1 at tulane.edu>
> To: Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] ArchivesSpace functionality
> issues
> Message-ID:
> <
> CY1PR0301MB12739878870245E67389B41EE5680 at CY1PR0301MB1273.namprd03.prod.outlook.com
> >
>
> Content-Type: text/plain; charset="utf-8"
>
> If you click on the dropdown next to your username in staff interface (top
> right corner) there are options for global/repo preferences where you can
> order things by id, accession date, etc.
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Maura Carbone
> Sent: Thursday, September 03, 2015 2:03 PM
> To: Archivesspace Users Group <
> archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] ArchivesSpace functionality issues
>
> Just curious, where on the staff page can you sort by Collection ID? I
> only see Title, Created, Modified in my version and in the sandbox, but I
> might not be looking at the proper view.
>
> On Thu, Sep 3, 2015 at 11:49 AM, Suda, Phillip J <psuda1 at tulane.edu
> <mailto:psuda1 at tulane.edu>> wrote:
> Thanks Mark, I will definitely be looking at the JIRA tickets (adding
> votes or new tickets as necessary).
>
>
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>] On Behalf Of
> Custer, Mark
> Sent: Thursday, September 03, 2015 10:21 AM
> To: Archivesspace Users Group <
> archivesspace_users_group at lyralists.lyrasis.org<mailto:
> archivesspace_users_group at lyralists.lyrasis.org>>
>
> Subject: Re: [Archivesspace_Users_Group] ArchivesSpace functionality issues
>
> Phil,
>
> Just a quick note to say that all of the issues that you raised are
> currently under review of the ArchivesSpace Public Interface Enhancement
> group,
> https://archivesspace.atlassian.net/wiki/display/ADC/Public+Interface+Enhancement+Project
> . This group is still in its early stages, and we?re still uncovering
> changes needed for the public interface, so there isn?t a firm timeline yet
> for when the first round of enhancements will be added to the core code.
>
> Right off the top of my head, I?d say that #1 is definitely a bug (and
> it?s one that?s bugged me, too); #2 is something that I?d like to have more
> information about, since I don?t know if that would work for most archival
> descriptions (but you could always create that behavior with a plugin, as
> Maura notes); to me, the container information just needs to display closer
> to the title, not in an ?Instance? section, and certainly not with any
> labels like ?container 2 indicator? in the display; #3 has certainly come
> up in user testing, so it will be added to the interface in some way; and
> #4 is also something that I?d consider a sensible default (i.e. blank data
> can be suppressed, whether it has a header or not), but as Maura mentions
> this is just masking the issue at hand, and you won?t want to keep around
> blank fields in the database anyway?. So on that point, I?d say that it
> would be nice, in the future, if members developed plugins or other means
> to support data cleanup activ
> ities on the staff side (validate and remediate, as needed!)
>
> Also, please keep reporting any issues that you see with the public
> interface. Many of these issues are logged in the ArchivesSpace JIRA
> account, but not all of them just yet, and it?s likely that other issues
> still need to be discovered and reported.
>
> Mark
>
>
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Maura Carbone
> Sent: Thursday, September 03, 2015 10:35 AM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] ArchivesSpace functionality issues
>
> Hi Phil,
>
> With regards to 2, I think you'd have to create a plugin and modify the
> code for that particular display
>
> I'm not entirely sure what you mean by 3. In the staff side, the resource
> sorting appears to be title, created, and modified.
>
> As for 4, if you unpublish them they shouldn't show up. Although if
> they're completely blank, it might make more sense to delete them?
>
> -Maura
>
> On Thu, Sep 3, 2015 at 9:39 AM, Suda, Phillip J <psuda1 at tulane.edu<mailto:
> psuda1 at tulane.edu>> wrote:
> Good morning all,
>
> We are noticing some basic functionality issues with
> ArchivesSpace; we are not sure if these are ?baked in? and if an
> enhancement request is in order.
>
>
> 1. After clicking the repository tab, selecting a repository and
> performing a search; the search ?breaks? and the user is no longer looking
> at materials soley within that repository; the search provides results from
> all objects/repos
>
> 2. Is there a way to append the container label to the end of a
> component title (i.e. ?component title + folder? or ?component title + box?)
>
> 3. Has anyone created the ability to sort by Collection or Component
> ID in the public interface (not the staff interface where this is
> possible)? We have staff/users that like to sort these in order
>
> 4. We are noticing that Blank Note Fields are display in the public
> interface. Is there an option to simply have these blank note fields not
> display?
>
> Thank you,
>
> Phil
>
> Phillip Suda
> Systems Librarian
> Howard-Tilton Memorial Library
> Tulane University
> psuda1 at tulane.edu<mailto:psuda1 at tulane.edu>
> 504-865-5607<tel:504-865-5607>
>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:
> Archivesspace_Users_Group at lyralists.lyrasis.org>
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group<
> https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=AwMFaQ&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=s7ciGQfUJeaV_ryx908hbeXDoU9aqDwDN0Z0VbfsJ3Y&m=f2DYnx-rKcxx-dUpmoXENzt48EXipCQ9z16fPb-TqN0&s=B011-iEpyrkQ91ZegR17UbywbgO9cwNkati6NOB-Kz0&e=
> >
>
>
>
> --
> Maura Carbone
> Digital Initiatives Librarian
> Brandeis University
> Library and Technology Services
> (781) 736-4659<tel:%28781%29%20736-4659>
> 415 South Street, (MS 017/P.O. Box 549110)
> Waltham, MA 02454-9110
> email: mauraa at brandeis.edu<mailto:mauraa at brandeis.edu>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:
> Archivesspace_Users_Group at lyralists.lyrasis.org>
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>
>
>
> --
> Maura Carbone
> Digital Initiatives Librarian
> Brandeis University
> Library and Technology Services
> (781) 736-4659
> 415 South Street, (MS 017/P.O. Box 549110)
> Waltham, MA 02454-9110
> email: mauraa at brandeis.edu<mailto:mauraa at brandeis.edu>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150903/2fde7455/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 22
> Date: Thu, 3 Sep 2015 15:29:21 -0400
> From: Maura Carbone <mauraa at brandeis.edu>
> To: Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] ArchivesSpace functionality
> issues
> Message-ID:
> <CANdYjfGEW_cVfyJ8j5rqSz1pY+JBfyrnznb6jApLNb=uHk=
> cXQ at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Ahhh yes that was not where I was looking. Thanks!
>
> On Thu, Sep 3, 2015 at 3:13 PM, Suda, Phillip J <psuda1 at tulane.edu> wrote:
>
> > If you click on the dropdown next to your username in staff interface
> (top
> > right corner) there are options for global/repo preferences where you can
> > order things by id, accession date, etc.
> >
> >
> >
> > *From:* archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:
> > archivesspace_users_group-bounces at lyralists.lyrasis.org] *On Behalf Of
> *Maura
> > Carbone
> > *Sent:* Thursday, September 03, 2015 2:03 PM
> >
> > *To:* Archivesspace Users Group <
> > archivesspace_users_group at lyralists.lyrasis.org>
> > *Subject:* Re: [Archivesspace_Users_Group] ArchivesSpace functionality
> > issues
> >
> >
> >
> > Just curious, where on the staff page can you sort by Collection ID? I
> > only see Title, Created, Modified in my version and in the sandbox, but I
> > might not be looking at the proper view.
> >
> >
> >
> > On Thu, Sep 3, 2015 at 11:49 AM, Suda, Phillip J <psuda1 at tulane.edu>
> > wrote:
> >
> > Thanks Mark, I will definitely be looking at the JIRA tickets (adding
> > votes or new tickets as necessary).
> >
> >
> >
> >
> >
> >
> >
> > *From:* archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:
> > archivesspace_users_group-bounces at lyralists.lyrasis.org] *On Behalf Of
> *Custer,
> > Mark
> > *Sent:* Thursday, September 03, 2015 10:21 AM
> > *To:* Archivesspace Users Group <
> > archivesspace_users_group at lyralists.lyrasis.org>
> >
> >
> > *Subject:* Re: [Archivesspace_Users_Group] ArchivesSpace functionality
> > issues
> >
> >
> >
> > Phil,
> >
> >
> >
> > Just a quick note to say that all of the issues that you raised are
> > currently under review of the ArchivesSpace Public Interface Enhancement
> > group,
> >
> https://archivesspace.atlassian.net/wiki/display/ADC/Public+Interface+Enhancement+Project
> > . This group is still in its early stages, and we?re still uncovering
> > changes needed for the public interface, so there isn?t a firm timeline
> yet
> > for when the first round of enhancements will be added to the core code.
> >
> >
> >
> > Right off the top of my head, I?d say that #1 is definitely a bug (and
> > it?s one that?s bugged me, too); #2 is something that I?d like to have
> more
> > information about, since I don?t know if that would work for most
> archival
> > descriptions (but you could always create that behavior with a plugin, as
> > Maura notes); to me, the container information just needs to display
> closer
> > to the title, not in an ?Instance? section, and certainly not with any
> > labels like ?container 2 indicator? in the display; #3 has certainly come
> > up in user testing, so it will be added to the interface in some way; and
> > #4 is also something that I?d consider a sensible default (i.e. blank
> data
> > can be suppressed, whether it has a header or not), but as Maura mentions
> > this is just masking the issue at hand, and you won?t want to keep around
> > blank fields in the database anyway?. So on that point, I?d say that it
> > would be nice, in the future, if members developed plugins or other means
> > to support data cleanup activities on the staff side (validate and
> > remediate, as needed!)
> >
> >
> >
> > Also, please keep reporting any issues that you see with the public
> > interface. Many of these issues are logged in the ArchivesSpace JIRA
> > account, but not all of them just yet, and it?s likely that other issues
> > still need to be discovered and reported.
> >
> >
> >
> > Mark
> >
> >
> >
> >
> >
> >
> >
> > *From:* archivesspace_users_group-bounces at lyralists.lyrasis.org [
> > mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org
> > <archivesspace_users_group-bounces at lyralists.lyrasis.org>] *On Behalf
> Of *Maura
> > Carbone
> > *Sent:* Thursday, September 03, 2015 10:35 AM
> > *To:* Archivesspace Users Group
> > *Subject:* Re: [Archivesspace_Users_Group] ArchivesSpace functionality
> > issues
> >
> >
> >
> > Hi Phil,
> >
> >
> >
> > With regards to 2, I think you'd have to create a plugin and modify the
> > code for that particular display
> >
> >
> >
> > I'm not entirely sure what you mean by 3. In the staff side, the resource
> > sorting appears to be title, created, and modified.
> >
> >
> >
> > As for 4, if you unpublish them they shouldn't show up. Although if
> > they're completely blank, it might make more sense to delete them?
> >
> >
> >
> > -Maura
> >
> >
> >
> > On Thu, Sep 3, 2015 at 9:39 AM, Suda, Phillip J <psuda1 at tulane.edu>
> wrote:
> >
> > Good morning all,
> >
> >
> >
> > We are noticing some basic functionality issues with
> > ArchivesSpace; we are not sure if these are ?baked in? and if an
> > enhancement request is in order.
> >
> >
> >
> > 1. After clicking the repository tab, selecting a repository and
> > performing a search; the search ?breaks? and the user is no longer
> looking
> > at materials soley within that repository; the search provides results
> from
> > all objects/repos
> >
> > 2. Is there a way to append the container label to the end of a
> > component title (i.e. ?component title + folder? or ?component title +
> box?)
> >
> > 3. Has anyone created the ability to sort by Collection or
> > Component ID in the public interface (not the staff interface where this
> is
> > possible)? We have staff/users that like to sort these in order
> >
> > 4. We are noticing that Blank Note Fields are display in the public
> > interface. Is there an option to simply have these blank note fields not
> > display?
> >
> >
> >
> > Thank you,
> >
> >
> >
> > Phil
> >
> >
> >
> > Phillip Suda
> >
> > Systems Librarian
> >
> > Howard-Tilton Memorial Library
> >
> > Tulane University
> >
> > psuda1 at tulane.edu
> >
> > 504-865-5607
> >
> >
> >
> >
> > _______________________________________________
> > Archivesspace_Users_Group mailing list
> > Archivesspace_Users_Group at lyralists.lyrasis.org
> > http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
> > <
> https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=AwMFaQ&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=s7ciGQfUJeaV_ryx908hbeXDoU9aqDwDN0Z0VbfsJ3Y&m=f2DYnx-rKcxx-dUpmoXENzt48EXipCQ9z16fPb-TqN0&s=B011-iEpyrkQ91ZegR17UbywbgO9cwNkati6NOB-Kz0&e=
> >
> >
> >
> >
> >
> >
> > --
> >
> > Maura Carbone
> >
> > Digital Initiatives Librarian
> > Brandeis University
> > Library and Technology Services
> > (781) 736-4659
> > 415 South Street, (MS 017/P.O. Box 549110)
> > Waltham, MA 02454-9110
> > email: mauraa at brandeis.edu
> >
> >
> > _______________________________________________
> > Archivesspace_Users_Group mailing list
> > Archivesspace_Users_Group at lyralists.lyrasis.org
> > http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
> >
> >
> >
> >
> >
> > --
> >
> > Maura Carbone
> >
> > Digital Initiatives Librarian
> > Brandeis University
> > Library and Technology Services
> > (781) 736-4659
> > 415 South Street, (MS 017/P.O. Box 549110)
> > Waltham, MA 02454-9110
> > email: mauraa at brandeis.edu
> >
> > _______________________________________________
> > Archivesspace_Users_Group mailing list
> > Archivesspace_Users_Group at lyralists.lyrasis.org
> > http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
> >
> >
>
>
> --
> Maura Carbone
> Digital Initiatives Librarian
> Brandeis University
> Library and Technology Services
> (781) 736-4659
> 415 South Street, (MS 017/P.O. Box 549110)
> Waltham, MA 02454-9110
> email: mauraa at brandeis.edu
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150903/9f74e0bd/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 23
> Date: Fri, 4 Sep 2015 11:18:49 -0400
> From: "Fleming, Jason" <flemingj at uncw.edu>
> To: "Archivesspace Users Group
> (archivesspace_users_group at lyralists.lyrasis.org)"
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: [Archivesspace_Users_Group] upgrading to v1.3.0 question
> about copying files #linux
> Message-ID:
> <1BB45AE37908DF40B3C2FAB9665E0945413DA6FA77 at uncwexmb1.dcs.uncw.edu
> >
> Content-Type: text/plain; charset="us-ascii"
>
> I have been trying to use the documentation on this page to upgrade from
> v1.1.0 tp v1.3.0 and have been having a difficult time
> https://github.com/archivesspace/archivesspace/blob/master/UPGRADING.md
>
> My question pertains to this section:
>
> $ cd archivesspace-1.2.0/archivesspace
> $ cp -a /path/to/archivesspace-1.2.0/archivesspace/data/* data/
> $ cp -a /path/to/archivesspace-1.2.0/archivesspace/config/* config/
> $ cp -a /path/to/archivesspace-1.2.0/archivesspace/lib/mysql-connector*
> lib/
> $ cp -a /path/to/archivesspace-1.2.0/archivesspace/plugins/local plugins/
> $ cp -a
> /path/to/archivesspace-1.2.0/archivesspace/plugins/wonderful_plugin plugins/
>
> Earlier on the page it talked about downloading v1.2.0 so I assume when it
> mentions 1.2.0 it means the new directory that was just unpacked (1.3.0)
>
> I unpacked 1.3.0 to /ArchivesSpace/archivesspace (current working
> archivesspace program is in another directory)
>
> So I altered the first copy command above and entered this
>
> cp -a /ArchivesSpace/archivesspace/data/* data/
>
> I get an error message
>
> cp: `/ArchivesSpace/archivesspace/data/archivesspace_demo_db' and
> `data/archivesspace_demo_db' are the same file
> cp:
> `/ArchivesSpace/archivesspace/data/frontend_cookie_secret_cookie_secret.dat'
> and `data/frontend_cookie_secret_cookie_secret.dat' are the same file
> cp: `/ArchivesSpace/archivesspace/data/indexer_state' and
> `data/indexer_state' are the same file
> cp:
> `/ArchivesSpace/archivesspace/data/public_cookie_secret_cookie_secret.dat'
> and `data/public_cookie_secret_cookie_secret.dat' are the same file
> cp: `/ArchivesSpace/archivesspace/data/solr_index' and `data/solr_index'
> are the same file
> cp: `/ArchivesSpace/archivesspace/data/tmp' and `data/tmp' are the same
> file
>
> which is I assume because I just told it to copy it onto itself. My
> understanding is that the copy command syntax is
> cp -a <source> <destination>
>
> Even if I put the correct path to my current data set it would copy the
> wrong way wouldn't it?
>
> --
>
> I tried just deleting the data and config directories altogether and
> copying them from the v1.1.0 directory but then 8080 and 8081 didn't
> respond at all when started, so I assume that was NOT the way to go about
> it.
>
> If you would be so kind as to explain what I am missing here I would
> appreciate it.
>
> Sincerely,
>
> -Jason
>
> Jason Fleming
> Information Technology Librarian
>
> 601 South College Road | Wilmington, NC 28403-5990
> T: 910-962-2675<tel:910-962-2675> | flemingj at uncw.edu<mailto:
> flemingj at uncw.edu>
> http://library.uncw.edu<http://library.uncw.edu/>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150904/72d968e5/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 24
> Date: Fri, 4 Sep 2015 18:06:05 +0000
> From: "Kutzuba, Jamie" <KUTZUBA at hws.edu>
> To: Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] SPAM?? upgrading to v1.3.0
> question about copying files #linux
> Message-ID: <45ccef1630504da58d8c10032f215781 at MBX6.hws.edu>
> Content-Type: text/plain; charset="us-ascii"
>
> Hi Jason-
>
> I was a bit confused about this during my upgrade as well. If I remember
> correctly, it is basically like you are patching the existing version with
> the new files. You want to cd into the newest version of ASpace and copy
> those files to the older version. So the first line of code from the
> instructions should be:
>
> $ cd archivesspace-1.3.0/archivesspace
>
> Followed by a command to copy to the directory of the existing version:
> $ cp -a /archivesspace-1.1.0/archivesspace/data/* data/
>
> Because you are overwriting existing files, I recommend saving, at least,
> a copy of the original config file before you do the update.
>
> I hope that helps.
>
> Thanks- Jamie
> 315.781.4355
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Fleming, Jason
> Sent: Friday, September 04, 2015 11:19 AM
> To: Archivesspace Users Group (
> archivesspace_users_group at lyralists.lyrasis.org) <
> archivesspace_users_group at lyralists.lyrasis.org>
> Subject: SPAM??[Archivesspace_Users_Group] upgrading to v1.3.0 question
> about copying files #linux
>
> I have been trying to use the documentation on this page to upgrade from
> v1.1.0 tp v1.3.0 and have been having a difficult time
> https://github.com/archivesspace/archivesspace/blob/master/UPGRADING.md
>
> My question pertains to this section:
>
> $ cd archivesspace-1.2.0/archivesspace
> $ cp -a /path/to/archivesspace-1.2.0/archivesspace/data/* data/
> $ cp -a /path/to/archivesspace-1.2.0/archivesspace/config/* config/
> $ cp -a /path/to/archivesspace-1.2.0/archivesspace/lib/mysql-connector*
> lib/
> $ cp -a /path/to/archivesspace-1.2.0/archivesspace/plugins/local plugins/
> $ cp -a
> /path/to/archivesspace-1.2.0/archivesspace/plugins/wonderful_plugin plugins/
>
> Earlier on the page it talked about downloading v1.2.0 so I assume when it
> mentions 1.2.0 it means the new directory that was just unpacked (1.3.0)
>
> I unpacked 1.3.0 to /ArchivesSpace/archivesspace (current working
> archivesspace program is in another directory)
>
> So I altered the first copy command above and entered this
>
> cp -a /ArchivesSpace/archivesspace/data/* data/
>
> I get an error message
>
> cp: `/ArchivesSpace/archivesspace/data/archivesspace_demo_db' and
> `data/archivesspace_demo_db' are the same file
> cp:
> `/ArchivesSpace/archivesspace/data/frontend_cookie_secret_cookie_secret.dat'
> and `data/frontend_cookie_secret_cookie_secret.dat' are the same file
> cp: `/ArchivesSpace/archivesspace/data/indexer_state' and
> `data/indexer_state' are the same file
> cp:
> `/ArchivesSpace/archivesspace/data/public_cookie_secret_cookie_secret.dat'
> and `data/public_cookie_secret_cookie_secret.dat' are the same file
> cp: `/ArchivesSpace/archivesspace/data/solr_index' and `data/solr_index'
> are the same file
> cp: `/ArchivesSpace/archivesspace/data/tmp' and `data/tmp' are the same
> file
>
> which is I assume because I just told it to copy it onto itself. My
> understanding is that the copy command syntax is
> cp -a <source> <destination>
>
> Even if I put the correct path to my current data set it would copy the
> wrong way wouldn't it?
>
> --
>
> I tried just deleting the data and config directories altogether and
> copying them from the v1.1.0 directory but then 8080 and 8081 didn't
> respond at all when started, so I assume that was NOT the way to go about
> it.
>
> If you would be so kind as to explain what I am missing here I would
> appreciate it.
>
> Sincerely,
>
> -Jason
>
> Jason Fleming
> Information Technology Librarian
>
> 601 South College Road | Wilmington, NC 28403-5990
> T: 910-962-2675<tel:910-962-2675> | flemingj at uncw.edu<mailto:
> flemingj at uncw.edu>
> http://library.uncw.edu<http://library.uncw.edu/>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150904/30cdfc72/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 25
> Date: Fri, 4 Sep 2015 18:15:32 +0000
> From: "Hurt, Tara (Library)" <HurtT at easternct.edu>
> To: Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] Help With Access
> Message-ID:
> <E1EA15AAC1FCD241BF30D0EA356C09842FB788AB at ECSUMB2.easternct.edu>
> Content-Type: text/plain; charset="us-ascii"
>
> Hi Brad. I am sitting with our System Librarian now.
>
> In order to solve the issue we are having now, I am hopeful it is helpful
> to review our path over the last few years.
>
> We started by using Archivist Toolkit. When Archive Space (AS) was
> created we decided to move our date from Archivist Toolkit to AS.
> So we migrated to AS and due to various local networking issues we have
> our data on a local workstation and AS uses its internal database and not
> MySQL.
> We did this approximately a year ago and all was working well.
>
> But about a month ago we started getting the error messages, we were
> promoted vie email help to upgrade to 1.3, which we did but has not
> resolved the issue. which seemed to go well. Now we are in the situation
> where the run time error which I sent you, constantly comes up.
>
> You asked us to send you a MySQL log but as I noted above there is no
> MySQL to run a log from.
>
> Where do we go from here? Tara
>
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Brad Westbrook
> Sent: Monday, August 31, 2015 10:12 AM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Help With Access
>
> Tara,
>
> Could you repeat the activity that produces the problem and then send us
> the log?
>
> Thanks,
>
> Brad W.
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Hurt, Tara (Library)
> Sent: Monday, August 31, 2015 9:55 AM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Help With Access
>
> Hi Brad.
>
> I have access to the following browsers, I usually use FireFox, but I have
> tried getting access on all three, with the same runtime error.
>
> Internet Explorer 10.0
> Mozilla FireFox
>
> I have even tried on a Mac, using Safari and I get the same runtime error.
>
> Thank you so much for your help, AS has been working very well so I am not
> sure why we are not having this glitch.
>
> I am in a meeting from 10-11 but then back at my office / machine. Thank
> you. Tara
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Brad Westbrook
> Sent: Monday, August 31, 2015 9:39 AM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Help With Access
>
> Hi, Tara,
>
> In what browser are you experiencing this problem? If IE, what version
> are you using?
>
> Brad W.
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Hurt, Tara (Library)
> Sent: Monday, August 31, 2015 9:34 AM
> To: Archivesspace Users Group
> Subject: [Archivesspace_Users_Group] Help With Access
>
> Good morning, I am still having trouble accessing Archives Space and I am
> getting run time errors.
> Last week I could not get the screen to stay active enough to capture BUT
> I did capture some screens today.
>
> The first capture below (first attachment) is the home screen I get ...
> all seems to be as normal here.
>
> Sometimes when I click to login in I get the run time error screen below.
> Sometimes if it does let me login, then as soon as I click on anything in
> AS, I get the run time error below (second screen shot attached).
>
> Cannot seem to get by this error .. we really need your help, it is the
> start of the academic year and we need the AS access.
>
> Thanks again for your help. Tara
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150904/ef568150/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 26
> Date: Fri, 4 Sep 2015 18:36:11 +0000
> From: "Hurt, Tara (Library)" <HurtT at easternct.edu>
> To: Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: [Archivesspace_Users_Group] FW: Help With Access
> Message-ID:
> <E1EA15AAC1FCD241BF30D0EA356C09842FB788D5 at ECSUMB2.easternct.edu>
> Content-Type: text/plain; charset="us-ascii"
>
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Hurt, Tara (Library)
> Sent: Friday, September 04, 2015 2:16 PM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Help With Access
>
> Hi Brad. I am sitting with our System Librarian now.
>
> In order to solve the issue we are having now, I am hopeful it is helpful
> to review our path over the last few years.
>
> We started by using Archivist Toolkit. When Archive Space (AS) was
> created we decided to move our date from Archivist Toolkit to AS.
> So we migrated to AS and due to various local networking issues we have
> our data on a local workstation and AS uses its internal database and not
> MySQL.
> We did this approximately a year ago and all was working well.
>
> But about a month ago we started getting the error messages, we were
> promoted vie email help to upgrade to 1.3, which we did but has not
> resolved the issue. which seemed to go well. Now we are in the situation
> where the run time error which I sent you, constantly comes up.
>
> You asked us to send you a MySQL log but as I noted above there is no
> MySQL to run a log from.
>
> Where do we go from here? Tara
>
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Brad Westbrook
> Sent: Monday, August 31, 2015 10:12 AM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Help With Access
>
> Tara,
>
> Could you repeat the activity that produces the problem and then send us
> the log?
>
> Thanks,
>
> Brad W.
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Hurt, Tara (Library)
> Sent: Monday, August 31, 2015 9:55 AM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Help With Access
>
> Hi Brad.
>
> I have access to the following browsers, I usually use FireFox, but I have
> tried getting access on all three, with the same runtime error.
>
> Internet Explorer 10.0
> Mozilla FireFox
>
> I have even tried on a Mac, using Safari and I get the same runtime error.
>
> Thank you so much for your help, AS has been working very well so I am not
> sure why we are not having this glitch.
>
> I am in a meeting from 10-11 but then back at my office / machine. Thank
> you. Tara
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Brad Westbrook
> Sent: Monday, August 31, 2015 9:39 AM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Help With Access
>
> Hi, Tara,
>
> In what browser are you experiencing this problem? If IE, what version
> are you using?
>
> Brad W.
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Hurt, Tara (Library)
> Sent: Monday, August 31, 2015 9:34 AM
> To: Archivesspace Users Group
> Subject: [Archivesspace_Users_Group] Help With Access
>
> Good morning, I am still having trouble accessing Archives Space and I am
> getting run time errors.
> Last week I could not get the screen to stay active enough to capture BUT
> I did capture some screens today.
>
> The first capture below (first attachment) is the home screen I get ...
> all seems to be as normal here.
>
> Sometimes when I click to login in I get the run time error screen below.
> Sometimes if it does let me login, then as soon as I click on anything in
> AS, I get the run time error below (second screen shot attached).
>
> Cannot seem to get by this error .. we really need your help, it is the
> start of the academic year and we need the AS access.
>
> Thanks again for your help. Tara
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150904/71161748/attachment-0001.html
> >
> -------------- next part --------------
> An embedded and charset-unspecified text was scrubbed...
> Name: ATT00001.txt
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150904/71161748/attachment-0001.txt
> >
>
> ------------------------------
>
> Message: 27
> Date: Fri, 4 Sep 2015 14:46:38 -0400
> From: Steven Majewski <sdm7g at virginia.edu>
> To: Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] Help With Access
> Message-ID: <D5418342-AA34-4A6F-B41B-A4CB90ED78B8 at virginia.edu>
> Content-Type: text/plain; charset="utf-8"
>
>
>
> What do you get it you query the backend directly at
> HOSTNAME:8089/repositories ?
>
>
>
>
>
>
> > On Sep 4, 2015, at 2:15 PM, Hurt, Tara (Library) <HurtT at easternct.edu>
> wrote:
> >
> > Hi Brad. I am sitting with our System Librarian now.
> >
> > In order to solve the issue we are having now, I am hopeful it is
> helpful to review our path over the last few years.
> >
> > We started by using Archivist Toolkit. When Archive Space (AS) was
> created we decided to move our date from Archivist Toolkit to AS.
> > So we migrated to AS and due to various local networking issues we have
> our data on a local workstation and AS uses its internal database and not
> MySQL.
> > We did this approximately a year ago and all was working well.
> >
> > But about a month ago we started getting the error messages, we were
> promoted vie email help to upgrade to 1.3, which we did but has not
> resolved the issue. which seemed to go well. Now we are in the situation
> where the run time error which I sent you, constantly comes up.
> >
> > You asked us to send you a MySQL log but as I noted above there is no
> MySQL to run a log from.
> >
> > Where do we go from here? Tara
> >
> >
> > From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Brad Westbrook
> > Sent: Monday, August 31, 2015 10:12 AM
> > To: Archivesspace Users Group
> > Subject: Re: [Archivesspace_Users_Group] Help With Access
> >
> > Tara,
> >
> > Could you repeat the activity that produces the problem and then send us
> the log?
> >
> > Thanks,
> >
> > Brad W.
> >
> > From: archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>] On Behalf Of
> Hurt, Tara (Library)
> > Sent: Monday, August 31, 2015 9:55 AM
> > To: Archivesspace Users Group
> > Subject: Re: [Archivesspace_Users_Group] Help With Access
> >
> > Hi Brad.
> >
> > I have access to the following browsers, I usually use FireFox, but I
> have tried getting access on all three, with the same runtime error.
> >
> > Internet Explorer 10.0
> > Mozilla FireFox
> >
> > I have even tried on a Mac, using Safari and I get the same runtime
> error.
> >
> > Thank you so much for your help, AS has been working very well so I am
> not sure why we are not having this glitch.
> >
> > I am in a meeting from 10-11 but then back at my office / machine. Thank
> you. Tara
> >
> > From: archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>] On Behalf Of
> Brad Westbrook
> > Sent: Monday, August 31, 2015 9:39 AM
> > To: Archivesspace Users Group
> > Subject: Re: [Archivesspace_Users_Group] Help With Access
> >
> > Hi, Tara,
> >
> > In what browser are you experiencing this problem? If IE, what version
> are you using?
> >
> > Brad W.
> >
> > From: archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>] On Behalf Of
> Hurt, Tara (Library)
> > Sent: Monday, August 31, 2015 9:34 AM
> > To: Archivesspace Users Group
> > Subject: [Archivesspace_Users_Group] Help With Access
> >
> > Good morning, I am still having trouble accessing Archives Space and I
> am getting run time errors.
> > Last week I could not get the screen to stay active enough to capture
> BUT I did capture some screens today.
> >
> > The first capture below (first attachment) is the home screen I get ?
> all seems to be as normal here.
> >
> > Sometimes when I click to login in I get the run time error screen below.
> > Sometimes if it does let me login, then as soon as I click on anything
> in AS, I get the run time error below (second screen shot attached).
> >
> > Cannot seem to get by this error .. we really need your help, it is the
> start of the academic year and we need the AS access.
> >
> > Thanks again for your help. Tara
> > _______________________________________________
> > Archivesspace_Users_Group mailing list
> > Archivesspace_Users_Group at lyralists.lyrasis.org
> > http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150904/966403e5/attachment-0001.html
> >
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: smime.p7s
> Type: application/pkcs7-signature
> Size: 4943 bytes
> Desc: not available
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150904/966403e5/attachment-0001.p7s
> >
>
> ------------------------------
>
> Message: 28
> Date: Fri, 4 Sep 2015 18:51:50 +0000
> From: "Hurt, Tara (Library)" <HurtT at easternct.edu>
> To: Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] Help With Access
> Message-ID:
> <E1EA15AAC1FCD241BF30D0EA356C09842FB7890F at ECSUMB2.easternct.edu>
> Content-Type: text/plain; charset="utf-8"
>
> Thank you ?.. do you mean if we query the backend directly at our server
> which is http://EDFLIBRGDG:8080 ?
>
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Steven Majewski
> Sent: Friday, September 04, 2015 2:47 PM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Help With Access
>
>
>
> What do you get it you query the backend directly at
> HOSTNAME:8089/repositories ?
>
>
>
>
>
>
> On Sep 4, 2015, at 2:15 PM, Hurt, Tara (Library) <HurtT at easternct.edu
> <mailto:HurtT at easternct.edu>> wrote:
>
> Hi Brad. I am sitting with our System Librarian now.
>
> In order to solve the issue we are having now, I am hopeful it is helpful
> to review our path over the last few years.
>
> We started by using Archivist Toolkit. When Archive Space (AS) was
> created we decided to move our date from Archivist Toolkit to AS.
> So we migrated to AS and due to various local networking issues we have
> our data on a local workstation and AS uses its internal database and not
> MySQL.
> We did this approximately a year ago and all was working well.
>
> But about a month ago we started getting the error messages, we were
> promoted vie email help to upgrade to 1.3, which we did but has not
> resolved the issue. which seemed to go well. Now we are in the situation
> where the run time error which I sent you, constantly comes up.
>
> You asked us to send you a MySQL log but as I noted above there is no
> MySQL to run a log from.
>
> Where do we go from here? Tara
>
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Brad Westbrook
> Sent: Monday, August 31, 2015 10:12 AM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Help With Access
>
> Tara,
>
> Could you repeat the activity that produces the problem and then send us
> the log?
>
> Thanks,
>
> Brad W.
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Hurt, Tara (Library)
> Sent: Monday, August 31, 2015 9:55 AM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Help With Access
>
> Hi Brad.
>
> I have access to the following browsers, I usually use FireFox, but I have
> tried getting access on all three, with the same runtime error.
>
> Internet Explorer 10.0
> Mozilla FireFox
>
> I have even tried on a Mac, using Safari and I get the same runtime error.
>
> Thank you so much for your help, AS has been working very well so I am not
> sure why we are not having this glitch.
>
> I am in a meeting from 10-11 but then back at my office / machine. Thank
> you. Tara
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Brad Westbrook
> Sent: Monday, August 31, 2015 9:39 AM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Help With Access
>
> Hi, Tara,
>
> In what browser are you experiencing this problem? If IE, what version
> are you using?
>
> Brad W.
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Hurt, Tara (Library)
> Sent: Monday, August 31, 2015 9:34 AM
> To: Archivesspace Users Group
> Subject: [Archivesspace_Users_Group] Help With Access
>
> Good morning, I am still having trouble accessing Archives Space and I am
> getting run time errors.
> Last week I could not get the screen to stay active enough to capture BUT
> I did capture some screens today.
>
> The first capture below (first attachment) is the home screen I get ? all
> seems to be as normal here.
>
> Sometimes when I click to login in I get the run time error screen below.
> Sometimes if it does let me login, then as soon as I click on anything in
> AS, I get the run time error below (second screen shot attached).
>
> Cannot seem to get by this error .. we really need your help, it is the
> start of the academic year and we need the AS access.
>
> Thanks again for your help. Tara
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:
> Archivesspace_Users_Group at lyralists.lyrasis.org>
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150904/9656b41e/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 29
> Date: Fri, 4 Sep 2015 15:05:54 -0400
> From: Steven Majewski <sdm7g at virginia.edu>
> To: Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] Help With Access
> Message-ID: <61B7BE60-D5FA-4A58-BD3E-437495FC81DF at virginia.edu>
> Content-Type: text/plain; charset="utf-8"
>
>
> > On Sep 4, 2015, at 2:51 PM, Hurt, Tara (Library) <HurtT at easternct.edu>
> wrote:
> >
> > Thank you ?.. do you mean if we query the backend directly at our
> server which is http://EDFLIBRGDG:8080 <http://edflibrgdg:8080/> ?
> >
> >
>
>
> No: The frontend server is running on port 8080. The backend is running on
> 8089.
> ( If you haven?t changed the defaults. There is also a public server on
> port 8081 )
>
> The screenshot of an error message you posted at the start of this thread
> showed
> the Welcome controller on the frontend server throwing an error when IT
> tried to
> access the backend server at http://localhost:8089/repositories <
> http://localhost:8089/repositories> , but the screenshot
> cut off before any more info was displayed.
>
> Try (maybe): http://EDFLIBRDG:8089/repositories <
> http://edflibrdg:8089/repositories>
>
>
>
>
>
>
> > From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Steven Majewski
> > Sent: Friday, September 04, 2015 2:47 PM
> > To: Archivesspace Users Group
> > Subject: Re: [Archivesspace_Users_Group] Help With Access
> >
> >
> >
> > What do you get it you query the backend directly at
> HOSTNAME:8089/repositories ?
> >
> >
> >
> >
> >
> >
> > On Sep 4, 2015, at 2:15 PM, Hurt, Tara (Library) <HurtT at easternct.edu
> <mailto:HurtT at easternct.edu>> wrote:
> >
> > Hi Brad. I am sitting with our System Librarian now.
> >
> > In order to solve the issue we are having now, I am hopeful it is
> helpful to review our path over the last few years.
> >
> > We started by using Archivist Toolkit. When Archive Space (AS) was
> created we decided to move our date from Archivist Toolkit to AS.
> > So we migrated to AS and due to various local networking issues we have
> our data on a local workstation and AS uses its internal database and not
> MySQL.
> > We did this approximately a year ago and all was working well.
> >
> > But about a month ago we started getting the error messages, we were
> promoted vie email help to upgrade to 1.3, which we did but has not
> resolved the issue. which seemed to go well. Now we are in the situation
> where the run time error which I sent you, constantly comes up.
> >
> > You asked us to send you a MySQL log but as I noted above there is no
> MySQL to run a log from.
> >
> > Where do we go from here? Tara
> >
> >
> > From: archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>] On Behalf Of
> Brad Westbrook
> > Sent: Monday, August 31, 2015 10:12 AM
> > To: Archivesspace Users Group
> > Subject: Re: [Archivesspace_Users_Group] Help With Access
> >
> > Tara,
> >
> > Could you repeat the activity that produces the problem and then send us
> the log?
> >
> > Thanks,
> >
> > Brad W.
> >
> > From: archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>] On Behalf Of
> Hurt, Tara (Library)
> > Sent: Monday, August 31, 2015 9:55 AM
> > To: Archivesspace Users Group
> > Subject: Re: [Archivesspace_Users_Group] Help With Access
> >
> > Hi Brad.
> >
> > I have access to the following browsers, I usually use FireFox, but I
> have tried getting access on all three, with the same runtime error.
> >
> > Internet Explorer 10.0
> > Mozilla FireFox
> >
> > I have even tried on a Mac, using Safari and I get the same runtime
> error.
> >
> > Thank you so much for your help, AS has been working very well so I am
> not sure why we are not having this glitch.
> >
> > I am in a meeting from 10-11 but then back at my office / machine. Thank
> you. Tara
> >
> > From: archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>] On Behalf Of
> Brad Westbrook
> > Sent: Monday, August 31, 2015 9:39 AM
> > To: Archivesspace Users Group
> > Subject: Re: [Archivesspace_Users_Group] Help With Access
> >
> > Hi, Tara,
> >
> > In what browser are you experiencing this problem? If IE, what version
> are you using?
> >
> > Brad W.
> >
> > From: archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org <mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org>] On Behalf Of
> Hurt, Tara (Library)
> > Sent: Monday, August 31, 2015 9:34 AM
> > To: Archivesspace Users Group
> > Subject: [Archivesspace_Users_Group] Help With Access
> >
> > Good morning, I am still having trouble accessing Archives Space and I
> am getting run time errors.
> > Last week I could not get the screen to stay active enough to capture
> BUT I did capture some screens today.
> >
> > The first capture below (first attachment) is the home screen I get ?
> all seems to be as normal here.
> >
> > Sometimes when I click to login in I get the run time error screen below.
> > Sometimes if it does let me login, then as soon as I click on anything
> in AS, I get the run time error below (second screen shot attached).
> >
> > Cannot seem to get by this error .. we really need your help, it is the
> start of the academic year and we need the AS access.
> >
> > Thanks again for your help. Tara
> > _______________________________________________
> > Archivesspace_Users_Group mailing list
> > Archivesspace_Users_Group at lyralists.lyrasis.org <mailto:
> Archivesspace_Users_Group at lyralists.lyrasis.org>
> > http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
> <http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group>
> >
> > _______________________________________________
> > Archivesspace_Users_Group mailing list
> > Archivesspace_Users_Group at lyralists.lyrasis.org <mailto:
> Archivesspace_Users_Group at lyralists.lyrasis.org>
> > http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
> <http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150904/ce7e410a/attachment-0001.html
> >
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: smime.p7s
> Type: application/pkcs7-signature
> Size: 4943 bytes
> Desc: not available
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150904/ce7e410a/attachment-0001.p7s
> >
>
> ------------------------------
>
> Message: 30
> Date: Sat, 5 Sep 2015 15:33:18 -0400
> From: Steven Majewski <sdm7g at virginia.edu>
> To: Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: [Archivesspace_Users_Group] I didn't know you could do
> this...
> Message-ID: <34BF5901-F7F7-4938-BD3E-E25B52B6B311 at virginia.edu>
> Content-Type: text/plain; charset="utf-8"
>
> I didn?t know you could do this: break the app using the backend API.
>
>
> Attempting to figure out the parameters to post an import job to the
> backend,
> I got the JSON parameters wrong or incomplete, and now all I get from
> trying to
> GET /repository/$REPO/jobs?page=1 in the backend is:
>
> {
> "error": "Had some trouble parsing your request: unexpected token at
> 'null'"
> }
>
>
> And accessing jobs in the frontend browser returns this page:
>
>
> NoMethodError in Jobs#index
>
> Showing
> /projects/Archivespace/1archivesspace/data/tmp/jetty-0.0.0.0-8088-frontend.war-_-any-/webapp/WEB-INF/app/views/jobs/index.html.erb
> where line #25 raised:
>
> undefined method `[]' for nil:NilClass
>
> Extracted source (around line #25):
>
> 22: <% end %>
> 23:
> 24: <h3><%= I18n.t("job._frontend.section.archived_jobs") %></h3>
> 25: <% if @search_data['results'].length > 0 %>
> 26: <%= render_aspace_partial :partial => "jobs/listing", :locals
> => {:jobs => @search_data['results']} %>
> 27: <%= render_aspace_partial :partial => "shared/pagination" %>
> 28: <% else %>
>
>
> Rails.root:
> /projects/Archivespace/1archivesspace/data/tmp/jetty-0.0.0.0-8088-frontend.war-_-any-/webapp/WEB-INF
>
> Application Trace <http://localhost:8088/jobs#> | Framework Trace <
> http://localhost:8088/jobs#> | Full Trace <http://localhost:8088/jobs#>
> app/views/jobs/index.html.erb:25:in
> `_app_views_jobs_index_html_erb__573411897_16740'
>
>
>
>
> Luckily, I was working on a test instance where I can blow away the
> database and start over if necessary.
> But deleting the last row in the mysql ?job? table appears to have fixed
> it.
>
> ? Steve Majewski
>
>
>
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150905/34d1de7b/attachment-0001.html
> >
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: smime.p7s
> Type: application/pkcs7-signature
> Size: 4943 bytes
> Desc: not available
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150905/34d1de7b/attachment-0001.p7s
> >
>
> ------------------------------
>
> Message: 31
> Date: Tue, 8 Sep 2015 22:35:51 -0700
> From: Carlos Lemus <carlos.lemus at unlv.edu>
> To: archivesspace_users_group at lyralists.lyrasis.org
> Subject: [Archivesspace_Users_Group] Plugin: Custom import mapping for
> MarcXML Agents, help
> Message-ID:
> <CAPsSwYq_1SZvus0BcwMmBRaidQo47S4Qisf6s=
> 7YX3iKtj7Yyg at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Hello,
>
> My question is how do i map the controlfield to one agent? it is currently
> creating two and the control field does not have a primary name to complete
> the job (Returns an error primary name missing)
>
> I am working on a plugin to import agents from a marcxml file. There is a
> lot of fields the current mapping for agents doesn't have. To begin, I have
> started with trying to import the authority id from the controlfield
> tag=001. I have been able to mimic and learn a lot of the mapping system
> through yale_marcxml2accession plugin.
>
> I've been able to accomplish importing mapping the authority id to the
> field, but only if i add a pirmary name to the name_person object, because
> what is happening is it is creating two agents as far as I can see from the
> log debugs I created. One of the log debugs is in the agent template
> (working with the agent/person template mix)
> #<JSONModel(:agent_person) {"jsonmodel_type"=>"agent_person",
> "agent_contacts"=>[], "linked_agent_roles"=>[], "external_documents"=>[],
> "rights_statements"=>[], "notes"=>[], "dates_of_existence"=>[],
> "names"=>[#<JSONModel(:name_person) {"jsonmodel_type"=>"name_person",
> "use_dates"=>[], "authorized"=>false, "is_display_name"=>false,
> "sort_name_auto_generate"=>true, "uri"=>nil, "primary_name"=>"Goodman",
> "rest_of_name"=>"Oscar Baylin,", "dates"=>"1939-",
> "name_order"=>"inverted", "source"=>"ingest"}>], "related_agents"=>[],
> "uri"=>"/agents/people/import_7faac81f-c32b-4bb5-8a5a-8daff5d1161b",
> "dates"=>"1939-"}>
>
> and the other is from the mapping of the code below (working with the
> authority id)
> #<JSONModel(:agent_person) {"jsonmodel_type"=>"agent_person",
> "agent_contacts"=>[], "linked_agent_roles"=>[], "external_documents"=>[],
> "rights_statements"=>[], "notes"=>[], "dates_of_existence"=>[],
> "names"=>[#<JSONModel(:name_person) {"jsonmodel_type"=>"name_person",
> "use_dates"=>[], "authorized"=>false, "is_display_name"=>false,
> "sort_name_auto_generate"=>true, "uri"=>nil, "authority_id"=>"n
> 2003051366", "name_order"=>"direct", "source"=>"ingest"}>],
> "related_agents"=>[],
> "uri"=>"/agents/people/import_9ff38423-fbaa-4d9c-bd1e-e3a65f4244c7"}>
>
>
> The code below also debugs the resource that shows both agents under the
> linked agents
> #<JSONModel(:resource) {"jsonmodel_type"=>"resource", "external_ids"=>[],
> "subjects"=>[], "linked_events"=>[], "extents"=>[], "dates"=>[],
> "external_documents"=>[], "rights_statements"=>[],
> "linked_agents"=>[{:role=>"subject", :terms=>[], :relator=>nil,
> :ref=>"/agents/people/import_7faac81f-c32b-4bb5-8a5a-8daff5d1161b"},
> {:role=>"subject", :terms=>[], :relator=>nil,
> :ref=>"/agents/people/import_9ff38423-fbaa-4d9c-bd1e-e3a65f4244c7"}],
> "restrictions"=>false, "revision_statements"=>[], "instances"=>[],
> "deaccessions"=>[], "related_accessions"=>[], "classifications"=>[],
> "notes"=>[], "hello_worlds"=>[],
>
> "uri"=>"/repositories/import/resources/import_9ed9d5ea-7ee6-47a5-986c-db937dd78d88",
> "language"=>nil, "finding_aid_description_rules"=>"rda",
> "id_0"=>"imported-1e46e675-3833-4483-ada1-5960a16004c6"}>
>
> I want to basically end up with the two of these combined in the sense of
> primary_name, dates, authority_id, etc can be imported as one agent. There
> is some relationship to the first agent created I'm missing if someone
> could help me fill that link I'd appreciate it. Let me know if I need to
> clarify anything.
>
>
> config["/record"][:map]["controlfield[@tag='001']"] = {
> :rel => -> resource, agent {
> resource[:linked_agents] << {
> # stashed value for the role
> :role => agent['_role'] || 'subject',
> :terms => agent['_terms'] || [],
> :relator => agent['_relator'],
> :ref => agent.uri
> }
> Log.debug(agent)
> Log.debug(resource)
> },
> :obj => :agent_person,
> :map => {
> "self::controlfield" => {
> :obj => :name_person,
> :rel => :names,
> :map => {
> "self::controlfield" => -> name, node {
>
> val = node.inner_text
> #name['primary_name'] = test
> name['authority_id'] = val
> }
> },
> :defaults => {
> :name_order => 'direct',
> :source => 'ingest'
> }
> }
> }
> }
>
> Thank you
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150908/b69ab113/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 32
> Date: Wed, 9 Sep 2015 08:20:01 -0400
> From: Brian Hoffman <brianjhoffman at gmail.com>
> To: Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] Plugin: Custom import mapping
> for MarcXML Agents, help
> Message-ID: <75124D4F-D697-4336-9732-0AF7E441B147 at gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Hi,
>
> I think you made the problem quite clear. I think the key is this: it?s
> not that obvious, but the MarcXML converter has a few different styles for
> mapping XML nodes to the ASpace data model. You are using the ?object?
> mapping:
>
>
> > config["/record"][:map]["controlfield[@tag='001']"] = {:rel =>
> something, :obj => something ?}
>
>
> This is meant to make it easy to do the mappings by just filling out those
> object properties, but it isn?t that flexible. You probably want to just
> use the other option, which is to map the controlfield to a functional
> block that will receive two parameters: the base resource record and the
> XML node. For an example, see:
>
>
> https://github.com/archivesspace/archivesspace/blob/master/backend/app/converters/marcxml_accession_converter.rb#L74
> <
> https://github.com/archivesspace/archivesspace/blob/master/backend/app/converters/marcxml_accession_converter.rb#L74
> >
>
> However, your case is a little unusual, in that you are mapping two
> siblings to a single ASpace record, so you?re going to have to use a trick
> to get access to the agent record created by the standard mapping.
> Something like this:
>
> config["/record"][:map]["controlfield[@tag='001']?] = -> (resource, node) {
> existing_agent_uri = resource.linked_agents.find {|link| link[:ref] =~
> /people/ }
> existing_agent = @batch.working_area.find {|obj| obj.uri ==
> existing_agent_uri }
> make(:name_person) do |name|
> name.primary = node.xpath(?subfield[@code=?a?]).inner_text
> # add more name fields as necessary
> existing_agent.names << name
> end
> }
>
> That?s just an idea and may not work as is. If you want to put your code
> up on Github I can try to help more.
>
> Brian
>
>
>
>
> > On Sep 9, 2015, at 1:35 AM, Carlos Lemus <carlos.lemus at unlv.edu> wrote:
> >
> > Hello,
> >
> > My question is how do i map the controlfield to one agent? it is
> currently creating two and the control field does not have a primary name
> to complete the job (Returns an error primary name missing)
> >
> > I am working on a plugin to import agents from a marcxml file. There is
> a lot of fields the current mapping for agents doesn't have. To begin, I
> have started with trying to import the authority id from the controlfield
> tag=001. I have been able to mimic and learn a lot of the mapping system
> through yale_marcxml2accession plugin.
> >
> > I've been able to accomplish importing mapping the authority id to the
> field, but only if i add a pirmary name to the name_person object, because
> what is happening is it is creating two agents as far as I can see from the
> log debugs I created. One of the log debugs is in the agent template
> (working with the agent/person template mix)
> > #<JSONModel(:agent_person) {"jsonmodel_type"=>"agent_person",
> "agent_contacts"=>[], "linked_agent_roles"=>[], "external_documents"=>[],
> "rights_statements"=>[], "notes"=>[], "dates_of_existence"=>[],
> "names"=>[#<JSONModel(:name_person) {"jsonmodel_type"=>"name_person",
> "use_dates"=>[], "authorized"=>false, "is_display_name"=>false,
> "sort_name_auto_generate"=>true, "uri"=>nil, "primary_name"=>"Goodman",
> "rest_of_name"=>"Oscar Baylin,", "dates"=>"1939-",
> "name_order"=>"inverted", "source"=>"ingest"}>], "related_agents"=>[],
> "uri"=>"/agents/people/import_7faac81f-c32b-4bb5-8a5a-8daff5d1161b",
> "dates"=>"1939-"}>
> >
> > and the other is from the mapping of the code below (working with the
> authority id)
> > #<JSONModel(:agent_person) {"jsonmodel_type"=>"agent_person",
> "agent_contacts"=>[], "linked_agent_roles"=>[], "external_documents"=>[],
> "rights_statements"=>[], "notes"=>[], "dates_of_existence"=>[],
> "names"=>[#<JSONModel(:name_person) {"jsonmodel_type"=>"name_person",
> "use_dates"=>[], "authorized"=>false, "is_display_name"=>false,
> "sort_name_auto_generate"=>true, "uri"=>nil, "authority_id"=>"n
> 2003051366", "name_order"=>"direct", "source"=>"ingest"}>],
> "related_agents"=>[],
> "uri"=>"/agents/people/import_9ff38423-fbaa-4d9c-bd1e-e3a65f4244c7"}>
> >
> >
> > The code below also debugs the resource that shows both agents under the
> linked agents
> > #<JSONModel(:resource) {"jsonmodel_type"=>"resource",
> "external_ids"=>[], "subjects"=>[], "linked_events"=>[], "extents"=>[],
> "dates"=>[], "external_documents"=>[], "rights_statements"=>[],
> "linked_agents"=>[{:role=>"subject", :terms=>[], :relator=>nil,
> :ref=>"/agents/people/import_7faac81f-c32b-4bb5-8a5a-8daff5d1161b"},
> {:role=>"subject", :terms=>[], :relator=>nil,
> :ref=>"/agents/people/import_9ff38423-fbaa-4d9c-bd1e-e3a65f4244c7"}],
> "restrictions"=>false, "revision_statements"=>[], "instances"=>[],
> "deaccessions"=>[], "related_accessions"=>[], "classifications"=>[],
> "notes"=>[], "hello_worlds"=>[],
> "uri"=>"/repositories/import/resources/import_9ed9d5ea-7ee6-47a5-986c-db937dd78d88",
> "language"=>nil, "finding_aid_description_rules"=>"rda",
> "id_0"=>"imported-1e46e675-3833-4483-ada1-5960a16004c6"}>
> >
> > I want to basically end up with the two of these combined in the sense
> of primary_name, dates, authority_id, etc can be imported as one agent.
> There is some relationship to the first agent created I'm missing if
> someone could help me fill that link I'd appreciate it. Let me know if I
> need to clarify anything.
> >
> >
> > config["/record"][:map]["controlfield[@tag='001']"] = {
> > :rel => -> resource, agent {
> > resource[:linked_agents] << {
> > # stashed value for the role
> > :role => agent['_role'] || 'subject',
> > :terms => agent['_terms'] || [],
> > :relator => agent['_relator'],
> > :ref => agent.uri
> > }
> > Log.debug(agent)
> > Log.debug(resource)
> > },
> > :obj => :agent_person,
> > :map => {
> > "self::controlfield" => {
> > :obj => :name_person,
> > :rel => :names,
> > :map => {
> > "self::controlfield" => -> name, node {
> >
> > val = node.inner_text
> > #name['primary_name'] = test
> > name['authority_id'] = val
> > }
> > },
> > :defaults => {
> > :name_order => 'direct',
> > :source => 'ingest'
> > }
> > }
> > }
> > }
> >
> > Thank you
> >
> >
> >
> > _______________________________________________
> > Archivesspace_Users_Group mailing list
> > Archivesspace_Users_Group at lyralists.lyrasis.org
> > http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150909/6282af7f/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 33
> Date: Wed, 9 Sep 2015 21:44:20 -0700
> From: Carlos Lemus <carlos.lemus at unlv.edu>
> To: brianjhoffman at gmail.com,
> archivesspace_users_group at lyralists.lyrasis.org
> Subject: [Archivesspace_Users_Group] Plugin: Custom import mapping for
> MarcXML Agents, help
> Message-ID:
> <
> CAPsSwYoT8E3LVVRYm7eCLbsPk93kHjchHDgO9DMEnjTc64QPGw at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Hello Brian,
>
> Sorry if I'm not replying to our current thread correctly. I have yet to
> set up git for the plugin, but as soon as I do I will let you know. It is
> mostly some of the yale marcxml plugin setup and a lot of commented trial
> and error code at this point anyways.
>
> I tried the code you gave me and I think you understand perfectly what my
> issue is and I understand what you're trying to do by matching the agent to
> the current resource, exactly what I need.
> However, it's not working because the batch object seems to be Null. Not
> sure if maybe I'm required to import something.
>
> Error: #<NoMethodError: undefined method `working_area' for
> nil:NilClass>
>
> Here is the current state of my code
>
> UNLVMarcXMLAgentsConverter.configure do |config|
> config["/record"][:map]["controlfield[@tag='001']"] = -> resource, node {
> existing_agent_uri = resource.linked_agents.find {|link| link[:ref] =~
> /people/ }
> existing_agent = @batch.working_area.find {|obj| obj.uri ==
> existing_agent_uri }
> make(:name_person) do |name|
> name.primary = node.xpath("subfield[@code='a']").inner_text
> # add more name fields as necessary
> val = node.inner_text
> name['authority_id'] = val
> existing_agent.names << name
> end
> }
> end
> Thanks for the quick reply by the way. I would have gotten to you sooner,
> but I didn't get an email that you had replied. I'll keep an eye on the
> listserv from now on.
>
> Carlos Lemus
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150909/4ea3d479/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 34
> Date: Thu, 10 Sep 2015 09:28:03 -0400
> From: Katherine Collett <kcollett at hamilton.edu>
> To: Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] How to delete a populated
> repository?
> Message-ID: <01F5D268-84B3-4E33-9259-F930E7DE5DD3 at hamilton.edu>
> Content-Type: text/plain; charset=windows-1252
>
> We would also like to delete some old test repositories (and the Lyrasis
> training repository) ? will this script do that, without bothering our
> current active repository? And is it still working with the current
> version of ArchivesSpace?
>
> When I try to delete the unwanted repositories I get the ?repository not
> empty? error message.
>
> Katherine
>
>
> Katherine Collett, Archivist
> Hamilton College Archives
> Burke Library
> 198 College Hill Road
> Clinton, NY 13323
> askarch at hamilton.edu
> 315-859-4471
> www.hamilton.edu/library/library_collections/archives.html
> www.facebook.com/BurkeLibrary
> Hours: M-F 9:00am-12:00 noon and by appointment; contact to ascertain
> staff availability before visiting.
>
> On Mar 26, 2015, at 9:35 AM, Chris Fitzpatrick <
> Chris.Fitzpatrick at lyrasis.org> wrote:
>
> > Hi Mark,
> >
> > I wrote this script last summer to do this:
> >
> > https://gist.github.com/cfitz/4fefcfa659ef18bfbe6c
> >
> > It's ruby and you'll have to have a rest_client and highline gems
> installed...
> >
> > Does that work for you?
> >
> > b,chris.
> >
> >
> > Chris Fitzpatrick | Developer, ArchivesSpace
> > Skype: chrisfitzpat | Phone: 918.236.6048
> > http://archivesspace.org/
> >
> > ________________________________________
> > From: archivesspace_users_group-bounces at lyralists.lyrasis.org <
> archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of
> Mark Cyzyk <mcyzyk at jhu.edu>
> > Sent: Wednesday, March 25, 2015 9:52 PM
> > To: archivesspace_users_group at lyralists.lyrasis.org
> > Subject: [Archivesspace_Users_Group] How to delete a populated
> repository?
> >
> > All,
> >
> > Does anyone know how to delete a populated repository? (We
> > inadvertently clicked the wrong thing while performing a migration which
> > set in stone our previously-pushed-through erroneous recordset.)
> >
> > I tried to Delete, but it won't delete a repository if it is populated.
> > I tried to simply move that repository, transferring its content into a
> > dummy repository for the time being. No joy. ("There was an error")
> > I reran the ./scripts/setup-database.sh script hoping it might drop each
> > table before recreating/reinitializing. No joy.
> > I attempted to Drop tables individually but can't because of foreign key
> > constraints.
> >
> > The only other thing I can think to do is to drop, then recreate, the
> > whole DB schema in MySQL (which, insofar as I don't have root access
> > there, I can't do).
> >
> > I kind of expected the Delete button would delete the repository --
> > including all its content -- and not leave behind any orphans in the
> > backend database?
> >
> > How can I delete this pesky repository?!
> >
> > Advice much appreciated,
> >
> > Mark
> >
> > --
> >
> > <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
> > Mark Cyzyk, M.A., M.L.S.
> > Scholarly Communication Architect
> > User Interface Applications Group
> > The Sheridan Libraries
> > The Johns Hopkins University
> > mcyzyk at jhu.edu
> >
> > Verba volant, scripta manent.
>
>
>
>
>
> ------------------------------
>
> Message: 35
> Date: Thu, 10 Sep 2015 09:38:13 -0400
> From: "Ladd, Marcus" <laddmm at miamioh.edu>
> To: archivesspace_users_group at lyralists.lyrasis.org
> Subject: [Archivesspace_Users_Group] Importing Accessions with CSV
> File?
> Message-ID:
> <CAFuHD3E=
> Dx+PDMHrm1qMdSZBqBs1-bR1y+X206SYbFy3rdt3wQ at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Hi all,
> Does anyone have experience with using a CSV file to batch import accession
> records? We've been struggling for months. The current errors we are
> getting are:
>
> Error: #<Argument
> Error: invalid byte sequence in UTF-8>
>
> Has anyone encountered this before or can anyone share with me a CSV file
> they successfully used?
> Thanks,
> Marcus
>
>
> --------
> *Marcus Ladd*
> Special Collections Digital Librarian
> Miami University, Oxford, OH
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150910/fa0ee203/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 36
> Date: Thu, 10 Sep 2015 14:57:09 +0000
> From: "Hurt, Tara (Library)" <HurtT at easternct.edu>
> To: Archivesspace Users Group
> <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] Help With Access
> Message-ID:
> <E1EA15AAC1FCD241BF30D0EA356C09842FB87247 at ECSUMB2.easternct.edu>
> Content-Type: text/plain; charset="utf-8"
>
> Good morning Brad.
>
> We did a query on the backend directly at
> localhost:8089/repositories
> and I have attached the message.
>
> Thank you for your continued help. The sooner we can get access to
> Archives Space the better.
>
> Tara
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Hurt, Tara (Library)
> Sent: Friday, September 04, 2015 2:52 PM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Help With Access
>
> Thank you ?.. do you mean if we query the backend directly at our server
> which is http://EDFLIBRGDG:8080 ?
>
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Steven Majewski
> Sent: Friday, September 04, 2015 2:47 PM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Help With Access
>
>
>
> What do you get it you query the backend directly at
> HOSTNAME:8089/repositories ?
>
>
>
>
>
>
> On Sep 4, 2015, at 2:15 PM, Hurt, Tara (Library) <HurtT at easternct.edu
> <mailto:HurtT at easternct.edu>> wrote:
>
> Hi Brad. I am sitting with our System Librarian now.
>
> In order to solve the issue we are having now, I am hopeful it is helpful
> to review our path over the last few years.
>
> We started by using Archivist Toolkit. When Archive Space (AS) was
> created we decided to move our date from Archivist Toolkit to AS.
> So we migrated to AS and due to various local networking issues we have
> our data on a local workstation and AS uses its internal database and not
> MySQL.
> We did this approximately a year ago and all was working well.
>
> But about a month ago we started getting the error messages, we were
> promoted vie email help to upgrade to 1.3, which we did but has not
> resolved the issue. which seemed to go well. Now we are in the situation
> where the run time error which I sent you, constantly comes up.
>
> You asked us to send you a MySQL log but as I noted above there is no
> MySQL to run a log from.
>
> Where do we go from here? Tara
>
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Brad Westbrook
> Sent: Monday, August 31, 2015 10:12 AM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Help With Access
>
> Tara,
>
> Could you repeat the activity that produces the problem and then send us
> the log?
>
> Thanks,
>
> Brad W.
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Hurt, Tara (Library)
> Sent: Monday, August 31, 2015 9:55 AM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Help With Access
>
> Hi Brad.
>
> I have access to the following browsers, I usually use FireFox, but I have
> tried getting access on all three, with the same runtime error.
>
> Internet Explorer 10.0
> Mozilla FireFox
>
> I have even tried on a Mac, using Safari and I get the same runtime error.
>
> Thank you so much for your help, AS has been working very well so I am not
> sure why we are not having this glitch.
>
> I am in a meeting from 10-11 but then back at my office / machine. Thank
> you. Tara
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Brad Westbrook
> Sent: Monday, August 31, 2015 9:39 AM
> To: Archivesspace Users Group
> Subject: Re: [Archivesspace_Users_Group] Help With Access
>
> Hi, Tara,
>
> In what browser are you experiencing this problem? If IE, what version
> are you using?
>
> Brad W.
>
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of
> Hurt, Tara (Library)
> Sent: Monday, August 31, 2015 9:34 AM
> To: Archivesspace Users Group
> Subject: [Archivesspace_Users_Group] Help With Access
>
> Good morning, I am still having trouble accessing Archives Space and I am
> getting run time errors.
> Last week I could not get the screen to stay active enough to capture BUT
> I did capture some screens today.
>
> The first capture below (first attachment) is the home screen I get ? all
> seems to be as normal here.
>
> Sometimes when I click to login in I get the run time error screen below.
> Sometimes if it does let me login, then as soon as I click on anything in
> AS, I get the run time error below (second screen shot attached).
>
> Cannot seem to get by this error .. we really need your help, it is the
> start of the academic year and we need the AS access.
>
> Thanks again for your help. Tara
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:
> Archivesspace_Users_Group at lyralists.lyrasis.org>
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150910/a1fdfa20/attachment.html
> >
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: 8089 message.png
> Type: image/png
> Size: 54653 bytes
> Desc: 8089 message.png
> URL: <
> http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150910/a1fdfa20/attachment.png
> >
>
> ------------------------------
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>
>
> End of Archivesspace_Users_Group Digest, Vol 26, Issue 2
> ********************************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150910/6a26ad99/attachment.html>
More information about the Archivesspace_Users_Group
mailing list