Export Data

Data from your full results set can be exported. Export options are displayed at the bottom of the search results and visualisations pages. There are four export formats, explained below. Select the format required then select the ‘Export’ button.

Item holdings data

The item holdings data option will export a file containing the following fields from your search results:

Field nameDefinition
copacNumberThe Copac record number
briefRecordBrief summary details of the document
numberOfHoldingLibrariesThe number of libraries whose records have been brought together within Copac as having a copy of the document
holdingLibrariesThe names of the libraries with a copy of the document

The file will be in .csv format with the file name [search result reference].itemholdings.csv. This can be saved or opened in an Excel spreadsheet or other software as required.

If you limited your original search by library or region, you can export item holdings data only for your specified libraries by choosing Item holdings data.csv (selected libraries/groups/regions).

The file will be in .csv format with the file name [search result reference].[library/group/region name].itemholdings.csv. This can be saved or opened in an Excel spreadsheet or other software as required.

OR you can include the details of all the libraries who hold the items returned in your search by choosing Item holdings data.csv (all libraries).

Note: any standard numbers in the export data will be contained within single quotes eg:'0071317945'; this ensures any spreadsheet software you use treats them as text. If a spreadsheet identifies ISBNs, record numbers etc as numbers then we have found that it will strip any leading zero's and they will no longer be valid.

Example of item holdings data:

copacNumberbriefRecordnumberOfHoldingLibrariesholdingLibraries
'131980680'Advice and assistance at police stations and the 24 hour duty solicitor scheme / by Andrew Sanders ... [et al.]. Lord Chancellor's Department, 1989.3 Birmingham; Bristol; Queen Mary, University of London

Library holdings data

The library holdings data option will export a file containing the following fields from your search results:

Field nameDefinition
libcodeCopac 3 character library code
nameThe name of the library with one or more records in the result set
latitudeThe latitude of the main library
longitudeThe longitude of the main library
numberOfRecordsThe number of records from the library within the result set
copacNumbersThe Copac record number(s) for that library's record(s) within the result set
searchTypeThe type of search carried out

The file will be in a .csv format with a file name [search result reference].libraryholdings.csv. This can be saved or opened in an Excel spreadsheet or other software as required.

If you limited your original search by library or region, you can export library holdings data only for your specified libraries by choosing Library holdings data.csv (selected libraries/groups/regions).

The file will be in .csv format with the file name [search result reference].[library/group/region name].libraryholdings.csv. This can be saved or opened in an Excel spreadsheet or other software as required.

OR you can include the details of all the libraries who hold the items returned in your search by choosing Library holdings data.csv (all libraries).

Note: any standard numbers in the export data will be contained within single quotes eg:'0071317945'; this ensures any spreadsheet software you use treats them as text. If a spreadsheet identifies ISBNs, record numbers etc as numbers then we have found that it will strip any leading zero's and they will no longer be valid.

Example of library holdings data:

libcodenamelatitudelongitudenumberOfRecordscopacNumberssearchTypet
SGCSt George's Chapel51.4845-0.60583'80R58432 80R58433 80R59374'subject

Full Copac records

You can export records in MODS, this is a Library of Congress XML schema. The exported records give the full Copac MODS records, which is in the standard MODS format with the Copac local holdings extension. The file will be in an .xml format with a file name [search result reference].xml

Where you have asked for a result set to be deduplicated the title details of all the merged records are included within the deduplicated record to assist in identifying any matching errors. Second and subsequent title details are given in the <extension> in the form of a <localNote>. As for the MARC export this includes the Copac record number plus basic title details.

Example MODS data for three Copac consolidated showing just the consolidated record information within the export record from a deduplicated result set:

 <extension>
 < ...[local locations etc. would be here]... >
 <h:localHolds>
 <h:localNote>
 <note>Deduplicated on-the-fly using ISBN: 015105227. Stockleys Drug Interactions Pocket Companion 2011. Pharmaceutical Press, 2011.</note>
 </h:localNote>
 <h:localNote>
 <note>Deduplicated on-the-fly using ISBN: 20A1423390. Stockley's drug interactions pocket companion 2011 [electronic resource] / editor, by Karen Baxter ; editorial staff Samuel Driver, Rebecca E. Garner, Jennifer M. Sharp ; based on the data produced by the Stockley Editorial Team, Ian A. Baxter ... [et al.]. Pharmaceutical Press, 2011. [2011 ed.]</note>
 </h:localNote>
 </h:localHolds>
 </extension>

Concise records

You can export records in a 'concise' MARC exchange format. This is useful if you wish to incorporate the collection information into your own records in the form of a local note. The file will be in a .mrc format with a file name [search result reference].mrc.

The pseudo-MARC record has the content shown below. Where you have asked for a result set to be deduplicated, any exported record that contains data from more than one Copac record will have a 950 field for each merged record. This allows you to check for misconsolidations arising from the on-the-fly deduplication.

The pseudo-MARC record has the following content:

Field Content
001Copac record number
003Copac code
035Record number of the library that did the search. This may repeat if we have consolidated multiple records from a single library.
245Includes title details, statement of responsibility, publisher and date, edition.
950$a Copac record number. $b Title details. $5 Copac code
959$a Number of copies as a human readable note. $b date stamp of export. $z Number of copies. $5 Copac code

Example of pseudo-MARC Export record.

0010710715253C
003UkMaC
035$aB13497194
245 10$aThe ecology and conservation of European owls : proceedings of a symposium held at Edinburgh University / edited by C.A. Galbraith, I.R. Taylor and S. Percival assisted by S.M. Davies. Joint Nature Conservation Committee, 1992.
950$a03B14325676$bThe Ecology and conservation of European owls : proceedings of a symposium held at Edinburgh University / edited by C.A.Galbraith, I.R.Taylor and S.Percival assisted by S.M.Davies. Joint Nature Conservation Committee, c1992$5UkMaC
950$a72006165274$bThe ecology and conservation of European owls : Symposium : Papers. Joint Nature Conservation Committee, 1992.$5UkMaC
959$aCopies held by: 8 institutions$b$z8$5UkMaC