Exporting large record sets from EBSCOhost and ProQuest databases

ProQuest and EBSCOhost logos

ENHANCEMENTS HAVE BEEN rolled out to support the export of larger quantities of search results from databases on both the EBSCOhost and ProQuest database platforms.

Interest has been growing, amongst students and researchers, in the ability to export multiple thousands of records from two of the library’s most widely used database platforms.

EBSCOhost

When staff and students search on any of the databases on the EBSCOhost platform (such as Academic Search Complete, Business Source Complete or SportDiscus – with Full Text) the Share feature now includes the option to generate a downloadable set of search results, up to a maximum of 25,000 records in any one set (see illustration below).

Choosing that option loads a screen on which the requester can add a preferred email address and the format in which the records should be generated (such as a .ris file).

The 25k record threshold is in effect whether the search is carried out on a single EBSCOhost database or when searching several EBSCOhost databases in combination.

The Export Results option on the EBSCOhost platform

Once the requested records have been compiled, the requester will receive an email including a direct download link.

ProQuest

In order to take avantage of the full export options on the ProQuest platform (which provides access to the ASSIA [Applied Social Sciences Index and Abstracts] and IBSS [International Bibliography of the Social Sciences] databases amongst many others) staff and students need to create and then log in to their PQ My Research account (see illustration below).

The Sign into My Research option on the ProQuest platform

Once logged in to My Research, it’s possible to export a total of 10 thousand records in a single set.

The 10k record threshold is in effect whether the search is carried out on a single ProQuest database or when searching several ProQuest databases in combination.

When a results set contains fewer than 10k records, the Export Results feature is available (see illustration below). If a search returns more than 10k records, the Export Results option is disabled.

A display of a results set from a database on the ProQuest platform

Licensing restrictions mean that records in some of the databases provided through the ProQuest platform are not available for export. This can be an issue when searching across multiple databases on the ProQuest site simultaneously.

When that occurs attempts to export the results will generate a pop-up message indicating that: “Your selection includes one or more articles that can’t be included in your request” (see illustration below).

A message indicating that a result set contains records that cannot be exported from the ProQuest platform

There is no option which allows the automatic removal of the records in the set of search results preventing the export. However, clicking or tapping the ‘question mark’ icon in the top-right of the pop-up message (see illustration above) will display a list of the databases from which the export of records is restricted.

To remove the offending records from the export, first select the Database facet from the result set, and choose the More option (see illustration below).

The Databases facet in a result set on the ProQuest platform

In the Database pop-up, select the Exclude option for export-restricted databases and choose Apply (see illustration below).

The option to exclude individual databases from a results set on the ProQuest platform

Once any unexportable database records have been removed, the Export results option will open a new pop-up. Having read the ‘Terms and Conditions’, select the required export format, choose whether or not to include Abstracts, and click or tap Accept.

The requested records will not be immediately available for export, as the record set needs first to be processed on ProQuest’s servers.

To retrieve the records, access the My Research area, and select the Searches tab (see illustration below).

The Searches tab of the My Research area on the ProQuest platform

Newly requested exports will display and may indicate that ProQuest is still “Processing Results…” (see illustration below).

A set of requested search results being processed for export on the ProQuest platform

Once the processing has completed, the Exports Results option will be activated for that results set (see illustration below). Selecting the Export Results option will trigger the download of the matching saved search items in the selected format.

The Export Results option in the Searches tab of the My Research area on the ProQuest platform

There is no need to remain logged into the ProQuest platform while a set of search results is processed. The next time that a student or researcher logs into their My Research area, previously saved searches will be listed in the Searches tab, along with the Export Results option.

ProQuest apply a limit of two such large exports per day. Additional search results sets can be saved in the Searches tab for future export.

New resource: MEDLINE with Full Text

ACCESS TO THE MEDLINE with Full Text database on the EBSCOhost platform is now available through the library’s Find Databases service.

The resource is described as follows:

Created by the National Library of Medicine, MEDLINE with Full Text provides access to a breadth of information on health care, nursing, dentistry, medicine, veterinary medicine and pre-clinical science. It is a gateway to access the full text of more than 1400 medical journals. The records of MEDLINE with Full Text can be search independently, or in conjunction with other databases on the EBSCOhost platform including CINAHL with Full Text.

Authenticated access to MEDLINE with Full Text is by university username and password.

Access to individual journal titles from the MEDLINE with Full Text service has also been enabled in the SFX (Find it @ NTU) service.

New resource: CINAHL with Full Text

ACCESS TO THE CINAHL with Full Text database on the EBSCOhost platform is now available through the library’s Find Databases service.

The resource is described as follows:

CINAHL with Full Text brings together the contents of more than 600 journals in the field of nursing and allied health disciplines. These include biomedicine, health sciences librarianship, alternative and complementary medicine and consumer health. CINAHL with Full Text also provides a gateway to access health care books, nursing dissertations, selected conference proceedings, standards of practice, educational software and audiovisual materials.

Authenticated access to CINAHL with Full Text is by university username and password.

Access to individual journal titles from the CINAHL with Full Text service has also been enabled in the SFX (Find it @ NTU) service.

Additional electronic and online resources: EBSCO eBook collections

EBSCOhost logo

TWO MORE eBOOK collections have been added to the current list of temporary additional electronic and online resources in the Find Databases service.

eBook Harvard Business Publishing Collection

A collection of academic eBooks covering a wide variety of fields in business and economics from the imprint of Harvard Business Publishing

eBook Academic Collection

A collection of academic eBooks covering a wide variety of subjects and disciplines, including economics, social sciences, history, computing, cultural studies and study skills

Off-campus access to both resources is by university username and password.

EBSCOhost – issues affecting off-campus article-level access resolved

EBSCOhost logo

THE PROBLEMS AFFECTING off-campus access to article-level content on the EBSCOhost platform reported earlier this week have now been resolved.

Off-campus request from Library OneSearch, or from any other discovery location, now resolve through a two-step process to the NTU Single Sign-on page. Once authentication is complete, off-campus access to article-level material completes successfully.

EBSCOhost – issues with article-level off-campus access from Library OneSearch and SFX

EBSCOhost logo

THE LIBRARY IS working with the technical team at EBSCOhost to resolve an issue with article-level access to EBSCOhost content from off-campus locations.

At present, content requests are, in some cases, resolving to an error page displaying an ‘Authentication Error 103’ (see below) following an the attempt to login through the NTU Single Sign-on service.

EBSCOhost 103 error

Database level access to all EBSCOhost content is unaffected. For the time being, the recommended workaround when access article-level EBSCOhost content from off-campus is to access the the required database from the Find Databases service and then locate the required content.

A further update will follow once the issue is confirmed as resolved.

UPDATE: This issue was confirmed as resolved on 27 February 2020.

SPORTDiscus with Full Text accessible once again

Access to the SPORTDiscus with Full Text service on the EBSCOhost platform, which was confirmed to be temporarily unavailable on Friday (30 June 2017), has now been restored.

Access to SPORTDiscus with Full Text is available once again through Library OneSearch and access to the full-text content of the publications in the collection is available once more through SFX.

EBSCOhost - SPORTDiscus with full-text

SPORTDiscus with Full Text currently inaccessible

Access to the SPORTDiscus with Full Text service on the EBSCOhost platform is currently unavailable to Libraries and Learning Resources’ customers. Requests to either the article level (through SFX) or to the database level (through Library OneSearch) are resolving to the EBSCOhost homepage (which does not list SPORTDiscus with Full Text as an option). A further update will follow once access is confirmed as restored.

EBSCOhost - SPORTDiscus with full-text

Upgraded resource: SPORTDiscus now with full-text

The Library’s subscription to the SPORTDiscus abstract and indexing database has now been upgraded to provide full-text content for more than 700 titles in the SPORTDiscus With Full-Text collection. Access remains direct on-campus and by university username and password from off-campus.

Access to the A&I version of SPORTDiscus will continue to be available until April. Full-text titles have been activated in the SFX service and will be added to the indexed inventory of the library’s electronic journal collection shortly.

EBSCOhost - SPORTDiscus with full-text

UPDATE, 20 APRIL 2017: Access to the A&I version of SPORTDiscus has been withdrawn from Library OneSearch, with SPORTDiscus – with Full Text now presented by default. This has also been replicated in the EBSCOhost interface.

Find Databases: resource review (September 2016)

Find Databases - Library OneSearch
 
Following a detailed review by the Research Support and Learning and Teaching teams, a number of changes have been made to the list of resources made available through the Find Databases service of Library OneSearch (which will also be reflected, later today, in searches in the ‘All’ search tab of LOS). The changes are detailed below:

Updated

  • AEI (Australian Education Index)
  • arlis.net
  • Bankscope
  • British Library Sounds
  • Child Development and Adolescent Studies
  • Construction Information Service
  • CPAG (Child Poverty Action Group) Online Publications
  • FAME
  • Family Law Online
  • Information Asset Register
  • Interior Internet
  • LACORS
  • Mintel
  • MyiLibrary
  • NBS Educator
  • NBS TV
  • Passport (formerly Passport GMID)
  • Planning portal
  • PoliticsHome
  • Westlaw

Withdrawn

  • Biosciences Image Bank
  • biz/ed
  • Epistemelinks
  • LexisPSL
  • Women’s Studies
  • WWW Virtual Library: Archnet

If you’d like any further information about the specific changes that have been made to any of the resources listed above, please get in touch.