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> 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 > 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 (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
