Library

SRO exporting data

Aimed at a technical audience, this page explains how data about research publications can be exported, in particular for using in other web-based systems.

Sussex Research Online uses the Eprints software platform, an Open Source project based at the University of Southampton.

Eprints has two different ways of listing publications: Browse Views and searches. Both of these provide means to export the data using an http request.

Browse Views are cached pre-configured html views (and html snippets), advanced searches allow you to create flexible requests for lists of items and export them using a number of different formats.

Using Browse Views to create an export feed

You can see a list of browse views currently available on SRO.

To embed a list of publications on to another page you can use an html snippet version of each view which only includes the html for the actual list of items, i.e. not a complete page and no formatting. To access this, replace the .html at the end of any view's URL with .include.

There are additional options to export publication information in different formats; at the top of each html view is a list of export functions. You can select any of these and use the URL as a method for pulling information from SRO. Output formats include Endnote, Refworks, XML and METS. Note: these are generated on-the-fly as requested by the client so will not be as responsive as the pre-generated .html and .include options above. These cached, pre-generated pages are advantageous in two ways: they are fast to respond and place low demand on our server.

Some common views you may wish to use are:

  • Authors - Publications for a particular authors. Just browse to the page for an author and use the options at the top to pull their publication list in a number of formats. Alternatively replace .html with .include at the end of the URL. The latter option has the benefit that these pages are pre-cached.
  • Authors using University id (not shown on the Browse Views page above) - Similar to the option above, however the URLs are predictable to internal developers and systems at Sussex; if you know the personid for one or more people you can use a URL to return their publications. Each URL takes the form: http://sro.sussex.ac.uk/view/person/ + University person id + .html. For example http://sro.sussex.ac.uk/view/person/187918.html - as noted above you can replace .html with .include or use one of the export options. The URLs are predictable; once you have an example for one person you can use this as a template for others by replacing the personid.
  • Departments - If you require publications for one department, browse to the department, select a year, and then either replace .html with .include in the URL or use one of the export formats in the Export list at the top, and note the URL it provides. You can also change how publications are grouped (by author, type, etc).
    The urls use the Sussex id numbers for Schools and Departments (which are used by other systems on campus) and as such once you have a URL with the correct feed for one department, this can be used for other departments by replacing the department id number in the URL. For example a list of publications for Psychology in 2012, and the same using the '.include' html. Using this method you can only see one year of publications at a time, see below for the Advanced Search method if this is not what is required.

The University Web Profiles for academics use SRO to generate the 'Selected Publications' list. Researchers can select which publications they wish to include in the list which appears on their profile. The following feed is used for this: 

http://sro.sussex.ac.uk/cgi/exportview/person/UNIVERSITYID/HTMLProfile/UNIVERSITYID.html

The two UNIVERSITYID are replaced with the University personid number (example).

Using Advanced Search to create an export feed

This method uses the advance search functionality to generate a required list of publications.

  1. Access the Advanced Search.
  2. Create a search. You do not need to enter any search terms, you can just choose criteria such as School/Department (Division), date, publication type, status etc.
  3. Run the Search.
  4. Use one of the Export formats from the drop down list at the top of the page, for example as HTML citations or JSON. Or use the RSS2 link at the top on the right. You can use these URLs to pull the desired information in the desired format in to your website or application.

For example if you do a search for Divison: Chemistry, Publication Status = Published, Refereed (Peer Reviewed) = True and Item type = Article you end up and the following page and URL, from there we can use the drop down list to select the output format we want, and then use the URL as a way to pull content from SRO.  

Note the School and Department identifiers (d232 in the above example URLs) are based on the standard University internal identifers for Schools and Departments, prefixed with d for department or s for school. As such, once you have created one search, it should be possible to predict URLs pulling in information from SRO for other Schools/Departments using the same URL structure.

By using the free text boxes within the Advanced Search screen it is possible to pull information from SRO for keywords, authors or publication title.

OAI-PMH

SRO provides an OAI-PMH URI for harvesting information as Dublin Core and other formats. The base URL is: http://sro.sussex.ac.uk/cgi/oai2

The greenoa set includes just those research output records with public full text Open Acces files attached.

Example OAI-PMH records:

Further information

Contact sro@sussex.ac.uk if you have any querstions regarding using data from SRO.