[Archivesspace_Users_Group] customizing your own reports, especially for locations?

[Elizabeth Dunham]

Hi Donnelly,

I've been using MySQL Workbench to run "reports," including one that counts all the linear footage we have stored off-site.  I'd be happy to share my script with you if that would be helpful.  I've had to teach myself SQL as I go, so it's not the most elegant thing around, but it works.

There is a "LocationsReport" in my installation of 1.0.7 - would that work, or does it not return what you were looking for?

Good luck with your move!

Elizabeth Dunham

------------------------
Assistant Archivist and Acting University Archivist
Arizona State University Libraries
Archives and Special Collections
Tempe, AZ 85287-1006
Elizabeth.Dunham at asu.edu

-----Original Message-----
From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of Lancaster, Donelly
Sent: Tuesday, April 22, 2014 9:57 AM
To: Archivesspace Users Group
Subject: [Archivesspace_Users_Group] customizing your own reports, especially for locations?

We are migrating from AT to ArchivesSpace.  We also happen to be moving portions of our collections from one physical location to another this summer.  The ability to create location reports is crucial for our planning.  

ArchivesSpace does not feature reports for locations at this time.  Is anyone out there doing anything in-house to create your own reports?  

Many thanks,


Donnelly Lancaster Walton
W.S. Hoole Special Collections Library
University Libraries
The University of Alabama
205-348-0505 (fax 205-348-1699)


_______________________________________________
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group at lyralists.lyrasis.org
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group