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

[Maderik, Rachel A.]

Yes we're connecting directly (using the deprecated mysql_connect right now, though we will be converting to PDO before we go live).

-----Original Message-----
From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of Prom, Christopher John
Sent: Tuesday, April 22, 2014 2:42 PM
To: Archivesspace Users Group
Subject: Re: [Archivesspace_Users_Group] customizing your own reports, especially for locations?

Rachel,

Just to ask, are you connecting directly the the DB using PDO or mysqli, sir some such, or are you connecting to the rest endpoints?

Best,

Chris Prom

On Apr 22, 2014, at 12:34 PM, Maderik, Rachel A. <maderikra at vmi.edu> wrote:

> We're building our own report interface using a PHP form on a separate web server to query the MySQL database directly, essentially bypassing the ArchivesSpace interface. I also use Toad for MySQL if I need to run a quick and dirty report, but the PHP form is meant to be more user-friendly (it allows archives staff to build custom reports without requiring a knowledge of SQL). It's still in the testing phase, but I can send you what we've done so far if you're interested.
> 
> Rachel Maderik
> Metadata Librarian
> 401 Preston Library
> Virginia Military Institute
> Lexington, VA 24450
> 540-464-7572
> 
> -----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 12:57 PM
> 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_grou
> p _______________________________________________
> Archivesspace_Users_Group mailing list 
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_grou
> p

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