BookNet Canada Sales Data Analysis Reports
Sierra can generate two separate reports to support libraries that participate in BookNet Canada's Sales Data Analysis program. The reports are output as comma-separated values (.csv) files. Using Sierra Scheduler, your library can configure the system to automatically generate and transfer these reports to BookNet Canada using FTP. This process involves:
- Creating a task for each of the report types below. For more information, see the "Task Profile for BookNet Canada" on Sierra Scheduler Task Builder.
- Creating a job for to run each task at a library-specified time. For more information, see Sierra Scheduler Job Scheduler.
For information on the report formats, see:
Branch Data Report
The Branch Data report contains branch information for each branch in the library. Sierra uses the following format when generating this file:
YYYYMMDD_BRANCHDATA_[SITE_CODE].csv
Where [SITE_CODE] is the library's Innovative customer site code. For example:
20220330_BRANCHDATA_RLLS.csv
The Branch Data report contains the following elements:
| Data Element Name | Description | Limits | Example |
|---|---|---|---|
| Library_Code | The library's Innovative customer site code. | Maximum 15 characters | rlls |
| Library_Name | The Library's name. | Maximum 50 characters | Rose Lake Library System |
| Branch_Code | The branch code from the Branches Table. | Maximum 15 characters | main |
| Branch_Name | The branch name from the Branches Table. | Maximum 50 characters | Main Library |
| Postal_Code | The branch’s Canadian postal code from the Branch Addresses Table. | Maximum 12 characters | K1A 1M8 |
| Address | The branch’s mailing address from the Branch Addresses Table. The address appears as a single line, and data elements in the branch’s address field are separated by semicolons. The address is parsed based on the Canadian address format. | n/a | 123 Main Ave.; Ottawa; Ontario |
| User_Count | The number of Sierra active users who have the branch assigned as their home branch. An active user is one that has any activity within the last three years. | n/a | 50 |
| DateEnd | The date and time the report was generated in mm/dd/yyyy hh:mm:ss tt format. | n/a | 03/30/2022 11:59:59 PM |
Lending Data Report
The Lending Data report contains circulation and holdings data for each branch in the library. Sierra uses the following format when generating this file:
YYYYMMDD_LENDINGDATA_[SITE_CODE].csv
Where [SITE_CODE] is the library's Innovative customer site code. For example:
20220330_LENDINGDATA_RLLS.csv
The Lending Data report contains the following elements:
| Data Element Name | Description | Example |
|---|---|---|
| Branch_Code | The branch location. This value is the branch code from the Branches Table and can be up to 15 characters. | main |
| Catalogue_Key | The bibliographic record that this row applies to. The value is the bibliographic record number without the leading "b". For the bibliographic record to appear in the report, it must have a value in one or more of the following columns at the time the report is generated: Loans, Renewals, Holds, Copies, Copies_Out, and Copies_on_Order. | 1022270 |
| EAN_ISBN13 | List of ISBNs separated by semicolons. Only valid ISBNs are included. | 9780538707688;9780915216536 |
| Loans | The total number of new checkouts during the past seven days for the bibliographic record. Sierra counts the transaction for the branch that checked out the item, not the owning branch. | 3 |
| Renewals | The total number of renewals during the past seven days for the bibliographic record. Sierra counts the transaction for the branch that checked out the item, not the owning branch. | 1 |
| Holds | The total number of bibliographic-, item-, and volume-level holds associated with the bibliographic record. Sierra only counts holds on bibliographic records where the branch is the pickup location. | 3 |
| Copies | The total number of copies currently linked to the bibliographic record. | 24 |
| Copies_Out | The total number of copies associated with the bibliographic record that are owned by the branch and are currently checked out. | 2 |
| Copies_on_Order | The total number of copies for the bibliographic record that are currently on order. Copies that have been received are excluded from this count. | 12 |
| DateEnd | The date and time the report was generated in mm/dd/yyyy hh:mm:ss tt format. | 03/30/2022 11:59:59 PM |