Exported Holding Lists
To retrieve exported lists click on the details icon near your user name in the far upper right of the screen and navigate to MY DOWNLOADS. GreenGlass item lists that contain fewer than 300,000 rows (or items) are made available in Excel .xlsx format. Lists that exceed 300,000 rows will be delivered as .csv files.
These Excel spreadsheets are lightly formatted but it is recommended that you delete columns you don't need. You may also wish to add Filters to the header row (via the DATA menu) to isolate items with specific values, etc. Sometimes pivot tables can be helpful for certain types of analyses. If you are unfamiliar with Excel or if you have any questions about your downloaded files, contact your GreenGlass liaison.
Each item in exported lists is represented by a line in the spreadsheet, sorted by Title. The first row contains a label/header for each column.
Note: Some columns are not included in all exports, and even if the column is included, data may not be available for individual items. This could be the result of custom project specifications and/or inconsistencies in your library's data.
| Serial Export Fields | Description |
|---|---|
| Collection Code | The GreenGlass Collection Code for this holding record. This is an optional field, used when a library has two different levels of location (e.g. library and shelving location). |
| Location Code | The GreenGlass Location Code for this holding record. |
| Display Call Number | The display call number derived from your catalog records. |
| Display Call Number Normalized | The normalized display call number which allows you to sort your lists by call number. |
| Title | The title of the publication, as it appears in the library's bib record. It's rare for this to be missing, but it does happen (a concatenation of all 245 subfields except $6 & $8). |
| Author | The first cited author in the library's record (a concatenation of all 1XX (first occurrence) subfields except $0, $4, $6, & $8). |
| Publisher | The first publisher cited in the library's record (a concatenation of all 260/264 subfields). |
| WorldCat Preceding Name Entry | Preceding Name entry from the WorldCat MARC 780. |
| WorldCat Succeeding Name Entry | Preceding Name entry from the WorldCat MARC 785. |
| WorldCat Publication Status | Taken from the WorldCat 008 field (continuing, discontinuing, other). |
| WorldCat Publication Dates | Taken from the WorldCat 008 field (Date1, Date2). |
| Sequential Designation (362) | Value from WorldCat MARC 362 sequential designation field. |
| Primary Language | The MARC language code, as it appears in the library's MARC field 008; 35-37. |
| Government Document | Yes or No. If a value if found in the MARC 086 (Gov Doc Number) or MARC 074 (GPO number) or in the MARC 008 Gov document indicator the title is flagged as government document. |
| LC Subclass | Assigned LC Subclass if there was sufficient data available to assign one. |
| Dewey Class | Assigned Dewey Number if there was sufficient data available to assign one. |
| Local Holding Details | Local holding details per location as taken from holding and/or item records. |
| Local Holding Date Range | Date of first holding to date of last holding as identifiable from local holding details. |
| Local Holding Date Span | Span in years taken from the Local Holding Date Range (above). |
| JOURNAL ARCHIVE - Holding Details | Show holdings description from archive if matched. |
| HathiTrust Public Domain | Show holdings description aggregated from HathiTrust Public Domain matches. |
| HathiTrust In Copyright | Show holdings description aggregated from HathiTrust In Copyright matches. |
| HathiTrust URL | Links to the HathiTrust Catalog Record and can be embedded in local catalogs for users to access full text for public domain titles. |
| Global Holdings - Same Edition | The count of all holdings for the exact edition; as set in WorldCat™. |
| Country Holdings - Same Edition | Exact edition WorldCat™ tallies. This tally includes your library's holding. |
| Country Holdings - Any Edition | Related edition WorldCat™ tallies. This tally includes your library's holding. |
| State/Province Holdings - Same Edition | Exact edition WorldCat™ tallies. This tally includes your library's holding. |
| State/Province Holdings- Any Edition | Related edition WorldCat™ tallies. This tally includes your library's holding. |
| Comparator Library Holdings - Same Edition | Exact edition WorldCat™ tallies. This tally includes your library's holding. |
| Comparator Library Holdings - AnyEdition | Related edition WorldCat™ tallies. This tally includes your library's holding. |
| OPAC URL | A URL link to the library's public catalog. |
| WorldCat URL | A URL link to the bib record in WorldCat™. |
| OCLC Work ID | An OCLC assigned number used to associate various editions of a given work. |
| WorldCat OCLC Number | The OCLC number from the WorldCat™ record that the GreenGlass team matched to the library's bib record. |
| Bib Record Number | The library's internal unique identifier for the bibliographic record. |
| Holding Control Number | The library's internal unique identifier for a holding record. |
| ISSN | The International Standard Serial Number as taken from MARC 022 field of the library record. |