BNC Reporting Now Includes New Data and Transmission Method

Three new data elements have been added for libraries that participate in BookNet Canada's (BNC) Sales Data Analysis (SDA) program. Each participating library can now configure automatic data extraction and schedule automatic FTP transmission of weekly data files. The two data files contain library information and circulation information. To the circulation information, the following new data elements have been added:

• Copies
• Copies out
• Copies on order

Customers using the existing integration will no longer need to schedule and generate the reports to email to BNC. Once configured, this will be done for them automatically. After the data files are sent, customers are encouraged to delete the files from the server to keep server space free.

Customers can configure the BNC extraction and FTP transmission using the following new settings, found in Administration Explorer > Profiles > Patron Services:

1. Contribute to BNC [Yes/No]
   • Default is no
2. FTP URI for BNC
   • Default is null
   • Max length 255
3. FTP username for the BNC account
   • Default is null
   • Max length 255
4. FTP password for the BNC account
   • Default is null
   • Max length 255
5. FTP: Active [Yes]

Once you enable and setup the BNC profiles, confirm the BNC LibrarySDA Structured Query Language (SQL) job is enabled and scheduled. See Polaris SQL Jobs Reference for more information.