Thanks very much, Terry. Anthony
From: Terry Brady [mailto:terry.br...@georgetown.edu] Sent: Tuesday, August 04, 2015 2:09 PM To: Anthony Petryk <anthony.pet...@uottawa.ca> Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Report of items including usage statistics Anthony, Check out the following code. There might be some useful code to clone. * Statistics report tool (this code reports collection by collection): https://github.com/Georgetown-University-Libraries/batch-tools/blob/master/web/stats/qcHierarchyStats.php * Populate a PHP array with the collection list using SQL: https://github.com/Georgetown-University-Libraries/batch-tools/blob/master/web/community.php * Package a SOLR query with an ajax call: https://github.com/Georgetown-University-Libraries/batch-tools/blob/master/web/stats/qcHierarchyStats.php#L41-L50 Here is a wiki page describing our statistics reports. * https://github.com/Georgetown-University-Libraries/batch-tools/wiki/Statistics-reporting Good luck, Terry On Tue, Aug 4, 2015 at 10:45 AM, Anthony Petryk <anthony.pet...@uottawa.ca<mailto:anthony.pet...@uottawa.ca>> wrote: Hi Terry, PHP works for me. :) Thanks for your overview of the 2 approaches. The first one looks easier so I’ll try that one. Best, Anthony From: Terry Brady [mailto:terry.br...@georgetown.edu<mailto:terry.br...@georgetown.edu>] Sent: Tuesday, August 04, 2015 12:52 PM To: Anthony Petryk <anthony.pet...@uottawa.ca<mailto:anthony.pet...@uottawa.ca>> Cc: dspace-tech@lists.sourceforge.net<mailto:dspace-tech@lists.sourceforge.net> Subject: Re: [Dspace-tech] Report of items including usage statistics Do you have a preferred technology stack for the solution? I have some PHP code that may be useful. The total views, total downloads, and owning collection id can be pulled from the solr statistics repository. * Query solr for item views, facet by item id * Query solr for bitstream downloads, facet by item id (do you want to include thumbnail views?) The title, author, abstract, and date created are probably easiest to pull from the database. Here are 2 approaches that would work. 1. Query the database for all items. As you iterate over the SQL results, query SOLR for the view/download counts 2. Run the faceted SOLR queries by item number. As you iterate over the XML/JSON results, query the database for supplemental metadata. Terry On Tue, Aug 4, 2015 at 8:29 AM, Anthony Petryk <anthony.pet...@uottawa.ca<mailto:anthony.pet...@uottawa.ca>> wrote: Hello, We’re interested in creating a report (spreadsheet) of items, which includes basic metadata AND associated usage statistics. For instance: - Title - Author - Abstract - Date Created - Owning Collection - Total Views (since accessioned) - Total Downloads (all bitstreams) What’s the best way to do this? Best, Anthony ------------------------------------------------------------------------------ _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net<mailto:DSpace-tech@lists.sourceforge.net> https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- Terry Brady Applications Programmer Analyst Georgetown University Library Information Technology https://www.library.georgetown.edu/lit/code 425-298-5498<tel:425-298-5498> (Seattle, WA) -- Terry Brady Applications Programmer Analyst Georgetown University Library Information Technology https://www.library.georgetown.edu/lit/code 425-298-5498 (Seattle, WA)
------------------------------------------------------------------------------
_______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette