MySQL 8 Syntax Compliance

Escaped system table name in SQL queries to comply with MySQL 8 treating it as a reserved word.

Improved duplicate catalog searching & temp branches functionality

Added

• ability to query NYPL Platform and BPL Solr to retrieve matches in the catalog
• functionality to mark branches as temporarily closed which prompts warnings when distribution with such branch is applied to a cart
• functionality to filter the cart for orders with temp branch locations, for orders identified as duplicates in the catalog, or duplicates in Babel
• functionality to globally remove temp branch locations from orders
• functionality to globally delete orders from cart that were identified as duplicates
• new selector's reports and ability to download them as csv files
• 910 tags with BL or RL for NYPL records
• adds Poetry as dependencies management tool

Changed

• alters Branch and Resource database tables to include data about temporarily closed location, branch-research identifiers for NYPL and catalog duplicates.
• migrates database to a new server (v5.6)
• improves process of saving to MARC and spreadsheet
• button label "load" changed to "open" in the spreadsheet ingest module
• cart name lenght extended to 120 characters

Fixed

• Errors when importing BPL Sierra IDs with changed headers after Sierra update

Security

• Dependencies updates (Pillow, urllib3, numpy, cryptography)

Deprecated

• functionality to web scrape BPL and NYPL Webpacs in search for duplicates
• updating from a shared drive

Win10 compliant

Changes:

• new installation window for building app scaffolding and providing MySQL creds
• dependencies:
  • altgraph from 0.16.1 to 0.17
  • attrs from 19.4.0 to 20.3.0
  • beautifulsoup4 from 4.8.0 to 4.9.3
  • cryptography from 3.2 to 3.3
  • loggly-python-handler from 1.0.0 to 1.0.1
  • openpyxl from 2.6.2 to 3.0.5
  • Pillow from 7.2.0 to 8.0.1
  • psutils from 5.6.6 to 5.7.3
  • py from 1.8.1 to 1.9.0
  • pycryptodome from 3.8.1 to 3.9.9
  • pytest from 5.4.3 to 6.1.2
  • pywin32 from 224 to 300
  • requests from 2.21.0 to 2.25.0
  • urllib3 from 1.24.3 to 126.2
  • removed zipp

Dependencies updates

• Dependencies security updates: Pillow, pytest, psutil

Pyinstaller & reports bugs fixed

Bug fixed:

• manual keyring.backends hook removed (apparently Pyinstaller handles keyring imports by itself)
• Reports layout correction

Reports & CartView enhancements

A major update to Babel functionality (Warning: the release has issues when freezed by Pyinstaller, do not use)

New features:

• Reports feature
• CartView: feature to add manually new resource (order) to existing cart
• CartView: added functionality to selectively add grids to orders in cart
• CartView: search within cart feature added
• GridView: added total qty tally

Bug fixes

• CartView: switching system in Cart window disabled
• CartView: blocking applying funds without specifying library for NYPL
• CartView: navigating to the end of the cart shows last group of orders that remains after equally dividing orders by number of displayed records in a page
• CartView: catalog duplication web scraper timeout extended to 15 seconds
• LogglyAdapter removes apostrophe unicode character code from messages for better readability in Loggly

Dependencies:

• Pyinstaller updated from 3.5 to 3.6 (security issue)
• Matplotlib 3.1.2 added

Grid & Search bugs fixes

Changes:

• Hyphens striped from blanketPOs, new format: {vendor code}{YYYYMMDD}{sequence}, examples: chbks201911130 (BPL), 3433201909060 (NYPL)
• list of carts sorted by default by date in descending order

Security update:

• Pillow module updated to 6.2.0

Bug fixes:

• displays correct grids when distributions are named exactly the same by two or more users (GridView)
• basic search retrieves results from carts without assigned library (error msg before) (SearchView)
• linking records updates a list in carts instantaneously (CartsView)
• cart summary resets when another cart is selected (CartsView)

Cart tabulator & optimization

New features:

• added a button to the CartView which tabulates an order by branch, showing number of titles, copies, and money per branch
• optimized CartView - significantly speeded up traversing between display pages, saves, and validation.
• extra column "comment" added to spreadsheet mapping (IngestView)
• added branch column to datastore view cart_details
• cart owner displayed in search results

Bugs:

• Values of source spreadsheet are forced to strings preventing errors when value was an integer, example title "1984"
• fixed error on traversing to the last page in the cart
• Babel window always anchored to the top left corner - no need to move it on the screen to display it fully

Fund and Search fixes

Enhancements:

• 30 records per page displayed in a cart
• cart name extended to 75 characters
• FundView speeded up significantly

Bug fixes:

• Simple Search functionality fixed (SearchView)
• Deletion of a user deletes related data (orphaned data before on such deletion before)
• Fixed typo in order id range in CartsView's summary
• Corrected display of linked carts (CartsView)
• Corrected display of cart's assigned library (CartView)

Babel 2

Complete rewrite of Babel in Python 3.
New functionality, improved interface, and increased speed.