This is great news.  Just in time for preparing ACRL statistical reports (uhg) and updating our holdings with Rapid ILL.  Thanks!




Christine E. Ryan

UC Foundation Associate Professor &

Electronic Resources Librarian

University of Tennessee at Chattanooga

voice:  423-425-4470

email: [log in to unmask]


This correspondence should be considered public record and subject to public inspection pursuant to the Tennessee Public Records Act.




From: Goldrush Discussion List [mailto:[log in to unmask]] On Behalf Of George Machovec
Sent: Thursday, September 03, 2009 6:37 PM
To: [log in to unmask]
Subject: Gold Rush "Export All Holdings" Report




For Immediate Release: Denver, CO. September 3, 2009





The Colorado Alliance of Research Libraries is pleased to announce a new “Export All Holdings” report in the Gold Rush Staff Toolbox.  This report is available to all libraries that use Gold Rush for A-Z/link resolution and/or ERM (electronic resource management). The new report allows a library to easily export their entire set of holdings from Gold Rush in .csv (comma separated value) format which can then be easily imported into Excel or other applications.


The “Export All Holdings” feature allows libraries to export everything or to customize the extract to exclude classes of materials such as open access journals, print journals and indexed-only titles.  These customizations can be run in any combination.  Once the report is staged the user will receive an email indicating report availability (usually within 15 minutes) and will receive a link to a Website where it can be downloaded.  These reports can be quite large and this avoids the problem of email limitations, firewalls and spam filters.


“Export All Holdings” shows all journals from all title lists which a library has configured (selected) in the Gold Rush “Holdings” tab.  This report does not de-duplicate titles but lists journals in every database in which they appear.   It is recommended that if the export is loaded into Excel, that version 2007 or later be used since older versions have a limit of 65,536 rows.


Gold Rush supports a wide array of data export options and to facilitate easy access to some of the options a new section has been created in the Reports tab which groups many of the export options together so that a library can determine what report is best for them.   The reports included in this tab include:


1.       Export All Holdings (described above)

2.       Download Journal Information for Provider and Database (this supports the export of an individual title list)

3.       My Full Text Journals (this is a simple list of journal titles/ISSNs which is de-duplicated and is a great place to get a full-text journal count)

4.       XML Google Scholar Holdings (this is a library’s XML holdings which are shared with Google Scholar if a library has configured this feature.  It is a de-duplicated list and shows maximum years of coverage)


Not included above is a full XML extraction report which can be run through the Gold Rush XML Gateway (called GRX) which allows a library to essentially extract the same data as found in the new Export All Holdings report but it is formatted in an XML markup.  This full XML extraction has been available for over a year and is described in the GRX Documentation.



About Gold Rush

Gold Rush is Web-based central digital registry of databases and electronic journals including both stand-alone and titles embedded within aggregated services. Gold Rush Complete offers a suite of tools for public access and staff management.   Gold Rush Complete offers openURL link resolution, subscription management (ERM), a public search interface (A-Z) with an additional Web services layer and content comparison.

 About The Colorado Alliance of Research Libraries


The Colorado Alliance of Research Libraries (  is a non-profit consortium of eleven libraries in Colorado and Wyoming.  It is a long term partnership of academic, special and public libraries with a history of working in concert to share resources through cooperative purchasing, special projects, systems management and consulting services. 


 For more information contact:

 George Machovec or Rose Nelson

Colorado Alliance of Research Libraries

3801 E. Florida, Suite 515

Denver, CO  80210

(303) 759-3399 (phone)

(303) 759-3363 (fax)

[log in to unmask] This email address is being protected from spam bots, you need Javascript enabled to view it or [log in to unmask]This email address is being protected from spam bots, you need Javascript enabled to view it



George Machovec

Associate Director

Colorado Alliance of Research Libraries

3801 E. Florida, Suite 515

Denver, CO  80210

(303) 759-3399 x.101

(303) 759-3363 (fax)

[log in to unmask]