[Archivesspace_Users_Group] Error Running Report

[Christine Di Bella]

Dear Jesse,

This is an area the is under very active revision and development right now and I'm afraid what reports are available and working is a bit of a moving target. The Reports subteam of the ArchivesSpace User Advisory Council is preparing a message that explains what is going on, but information about their current work is available on our wiki at https://archivesspace.atlassian.net/wiki/display/AC/ArchivesSpace+Reports.

The March release of ArchivesSpace will remove any reports that are not working and aim to get the highest priority reports from the list at the bottom of https://archivesspace.atlassian.net/wiki/pages/viewpage.action?pageId=98009123 working again. Additional work on reports is being evaluated for the June release.

In case it is helpful for you, I'll mention a couple other workarounds for working with your data. The v1.5 versions provide a way for getting data out in CSV format. You can access this option from the Browse or search results page for any of the primary record types (Accessions, Resources, Digital Objects, Agents, etc.). This will export every field from every record in the result set, but the data can be refined outside ArchivesSpace.

Another option that some people are using with success is setting up an ODBC connection or otherwise hooking ArchivesSpace up to output data to an external program. Nancy Enneking of the Getty presented a lightning talk titled DIY Reports in ArchivesSpace at a session called Making ArchivesSpace Work for You at SAA last summer. Nancy's talk is in the file posted at http://schd.ws/hosted_files/archives2016/3e/Session501-All_presenters.pptx; Nancy's starts on page 40. (There are lots of other great talks in this file too!)

I hope this helps a bit. We know that these issues with reports present significant difficulties for people and we're working to resolve them as quickly as we can, but it's a complex process, unfortunately.

Christine

Christine Di Bella
ArchivesSpace Program Manager
christine.dibella at lyrasis.org<mailto:christine.dibella at lyrasis.org>
800.999.8558 x2905
678-235-2905
cdibella13 (Skype)

[ASpaceOrgHomeMedium]



From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of Teitelbaum, Jesse
Sent: Monday, February 13, 2017 9:50 AM
To: archivesspace_users_group at lyralists.lyrasis.org
Subject: [Archivesspace_Users_Group] Error Running Report

I just finished migrating from Archon to AS 1.4.2 and have moved the installation to our production server. Everything seems to be running fine, except for some of the reports. When running the DigitalObjectListReport, for example, the attached error shows up. About 12 of the reports generate a similar error. On the migration server, they ran fine. Any help would be appreciated.


Jesse Teitelbaum | Associate Archivist
Pennsylvania House of Representatives | Archives
469 Forum Building | Harrisburg PA 17120
Phone: 717.783.3866 | Fax: 717.772.1233
Email: jteitelbaum at pabmc.net<mailto:jteitelbaum at pabmc.net>
www.house.state.pa.us/BMC/archives<http://www.house.state.pa.us/BMC/archives>


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20170216/40aad762/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.jpg
Type: image/jpeg
Size: 4144 bytes
Desc: image003.jpg
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20170216/40aad762/attachment.jpg>