Holds data
Find instructions, a file template, and a sample record for formatting and sending your holds data to OCLC.
Purpose
This document contains instructions for formatting and sending your holds data to OCLC. Holds data should only be sent for current hold requests yet to be fulfilled, not holds that are on the shelf waiting to be checked out.
Note: Circulation files are required to beFile template
File | Descrizione |
---|---|
Tab-delimited holds template (Microsoft Excel) | Contains 9 columns. Save as a tab-delimited text file (an Excel file cannot be used to send data). Note: Required fields have red column headings. |
Column rules
- The text file must contain all 9 tab-delimited columns in the order listed in the table below.
- The first row of the text file is the header and must contain column names separated by tabs.
- I nomi delle intestazioni delle colonne non sono sensibili alle maiuscole e alle minuscole, ma devono essere scritti correttamente.
- Each line in the tab-delimited file must contain 8 tab characters, which function as column separators.
- Tutti i valori delle colonne sono stringhe (stringhe di testo, stringhe numeriche, ecc.).
- If you have no data to put in a column, include the column header, but leave the rest of the column empty (do not delete the column header).
Note: If columns are deleted, moved, or renamed, the file cannot be used to load data.
Filename rules
Send holds data
Send your holds data files via SFTP with your OCLC file exchange account.
Elenco | Usato per |
---|---|
/xfer/wms/test/in/circdata/holds | Loading holds data to WMS |
Holds file format
Note: None of the columns are repeatable.
Column number | Nome della colonna | Richiesto | Esempio | Descrizione |
---|---|---|---|---|
1 | institutionID | x | 127941 | The WorldCat Registry ID for the institution that owns the item. |
2 | borrowerBarcode | x | 123456789 | The barcode of the patron who has the hold request on the material. |
3 | oclcNumber | x | 12345678 | The OCLC number of the bibliographic record for the title that is on hold. |
4 | pickupBranch | x | 127111 | The Branch ID of the patron's preferred pickup location. |
5 | earliestDateNeeded | 2020-01-01 |
|
|
6 | neededBeforeDate | 2020-01-10 |
|
|
7 | suspensionStartDate | 2020-01-01 |
|
|
8 | suspensionEndDate | 2020-01-01 |
|
|
9 | borrowerInstitutionId | x | 127941 |
|
Sample record
File | Descrizione |
---|---|
Tab-delimited holds text file example (Text file) | An example of a tab-delimited text file that results from saving the tab-delimited holds template as text. It contains sample data. |