Retrieve WMS data extract files with SFTP
Introduction
This document provides detailed information about available WMS data extract files including:
- Naming conventions
- Frequency
- Data outputs
- Date restrictions
Reconciliation reports are placed on an SFTP server as delimited text documents that can be downloaded and imported into other software as needed. Report files are retained 90 days. Report files older than 30 days are subject to zipping. For more information, see Download files with SFTP.
Row limit
All reports can be used with Microsoft Excel, regardless of size; however, depending on your version of Excel, there may be a row limit per sheet. Consequently, several sheets are generated if a report exceeds the row limit.
Field names and order
Any fields (report columns) that have been added or field names that have been updated are identified in bold formatting. The field names are listed in the order that the columns appear in the report.
Circulation Item Inventories
| Description: All inventoried items. | |||
| Frequency: Weekly (every Sunday) | |||
| Time (EST): 22:00 | |||
| Date restrictions (UTC): None | |||
| Other restrictions: None | |||
|
Output
|
|||
|
File name examples <OCLC Symbol>.Circulation_Item_Inventories.yyyymmdd.txt |
|||
| Additional information: As of September 30, 2018, this report replaced the Item Inventories Report. |
Circulation Patron Full
| Description: All current patrons for an institution. | |||
| Frequency: Weekly (every Sunday) | |||
| Time (EST): 23:00 | |||
| Date restrictions (UTC): None | |||
| Other restrictions: None | |||
|
Output
|
|||
|
File name examples IST = Institution Symbol IST.Circulation_Patron_Report_Full.YYYYMMDD.txt IST.Circulation_Patron_Report_Full.YYYYMMDD.csv |
|||
| Additional information: This report replaced the Patron_Report_Full report. |
Circulation Patron Week
| Description: All patrons that have been modified over the last week. | |||
| Frequency: Weekly (every Sunday) | |||
| Time (EST): 22:00 | |||
| Date restrictions (UTC): Only covering last week of activity (05:00-05:00) | |||
| Other restrictions: None | |||
|
Output
|
|||
|
File name examples IST = Institution Symbol IST.Circulation_Patron_Report_wk.YYYYMMDD.txt IST.Circulation_Patron_Report_wk.YYYYMMDD.csv |
|||
| Additional information: This report replaced the Patron_Report_wk report. |