Version 2023.01.16

Release Notes

• Allow renaming of Custom Query favorites. GitHub discussion.
• Batch Activities Browser: do not display a file dialog if an export would be empty.
• Book SRU query results: set Alternate Identifier to control field 003's ark value if Alternate Identifier is empty. GitHub discussion.
• CSV Import Browser: empty ISBN-10 and ISBN-13 substitutions. Values may be prepared manually.
• Completed GitHub ticket #228. Allow UPDATE queries on selected items.
• Custom queries executed via the Custom Query menu will be executed through the same logic as the Custom Query browser.
• Do not convert ISBN-13 to ISBN-10 unless the prefix is 978 (biblioteq_misc_functions::isbn13to10()). GitHub ticket #269.
• Do not disconnect the current database if a future database does not have a database driver.
• Happy New Year!
• Item field colors. New options in Other Options. GitHub ticket #272.
• Publication Date Formats are now open. Correct formats are expected. See Other Options. GitHub ticket #270.
• Replaced all instaces of MM/dd/yyyy with biblioteq::s_databaseDateFormat. GitHub ticket #270.
• Show a warning label if the selected database's driver does not exist in Branch Selection.
• Some operators believe that BiblioteQ should correct their malformed data regardless of the effort, interest, and time. Modified the import mechanism such that it attempts to correct publication dates. GitHub ticket #270.
• Source-only release! Preparing release files requires a significant effort and an interest. Requests for release files will be ignored! Apologies. The tar bundle for Linux is created in Ubuntu 20.04.

Version 2022.12.25

Release Notes

• Added book_target_audiences to Custom Query tree widget.
• Added book_target_audiences to Merge SQLite Databases.
• Added member_history_dnt to Custom Query tree widget.
• Allow null ISBN book searches.
• Audio and Batch Activities Browser. Multimedia system required.
• Avoid searching of duplicate items in Batch Activities Browser.
• Bottom-scroll-on-add added to Batch Activities Browser. Setting is ephemeral.
• Close and reset the Merge SQLite Databases window upon a database disconnect.
• Completed Qt 6.2 LTS regular expressions. Some glitches may remain.
• Corrected discovery of grey literature items in the Batch Activities Browser. Problem caused by referencing incorrect database field.
• Corrected grey literature searches. The query was missing fields.
• Corrected magazine searches. The query was missing a space character.
• Corrected queries which include single quotes for SQLite and PostgreSQL.
• Corrected section scrolling order in Database Enumerations Browser.
• Custom queries and favorites. Please see Custom Query and View menu.
• Do not include empty myoid information in the Merge SQLite Databases utility during error reporting.
• Export missing items function in Batch Activities Browser's Discover panel.
• Hyperlinks for SQLite. Please activate a link by pressing and holding the Alt key while clicking on the link. Also functional on editable PostgreSQL entries.
• Ignore empty scanned input in Batch Activities Browser.
• Improved error reporting of biblioteq_misc_functions::getNextCopy().
• Include item title in the Discover portion of the Batch Activities Browser.
• New database tables book_conditions, book_originality. Please upgrade the databases. Static values have been removed from relevant widgets.
• Removed Poppler (PDF), PostgreSQL, and YAZ from MacOS.
• Removed SQLite libraries and source. Qt provides sufficient SQLite services.
• Removed duplicate tool tips from Other Options.
• Reset numerous panels after a database is closed.
• Revised text on numerous menu items.
• Save tear-off menus setting only if Automatically Save Settings On Exit is active or the settings are explicitly saved.
• This will be the final package release. Future releases will include source only. Good luck!
• Woody tree widgets. Collapse / expand trees.

Version 2022.11.25

Release Notes

• Batch Activities categories.
• Batch Activities discovery.
• Maximum reserved books. Limits are now enforced.
• Optional tear-off menus.
• PostgreSQL 10.23; Windows.
• PostgreSQL files require book_target_audiences permissions.
• Qt 5.15.2; Windows.
• Qt 5.15.7; Mac.
• Remove hyphens from multi-volume ISBN in book search.
• Removed vertical headers from many table widgets.
• SQLite 3.40; Windows.

Version 2022.09.15

Release Notes

• As requested, display the Alternate Identifier for books category.
• Corrected book import and copy generation.
• Corrected order of widgets in Database Enumerations Browser.
• Import locale-specific prices. Thank you meteos77.
• Per request, Batch Activities Browser.
• PostgreSQL 10.22.1; Windows.
• Qt 5.15.5 LTS; Mac.
• Report failures of biblioteq_misc_functions::getOID().
• SQLite 3.39.3; Android and Windows.
• Scroll-to-section for Database Enumerations Browser.
• Sort some combination box entries.
• Standard optimization (O2).
• Version information in About is incorrect for Debian and Mac releases.
• YAZ 5.31.1; Windows.

Version 2022.05.30

Release Notes

• Added alternate_id_1, description, and multivolume_set_isbn fields to all-fields book import.
• Adding living application links.
• Basic search (main window) is now exact, per request. The wildcard character is %.
• Book imports will now create copies upon discovering duplicate ISBNs.
• Check ISBNs checkbox widget if either ISBN is available; book panel.
• Corrected export-as-PNG function. A scene's render() function must be provided the scene's bounding rectangle. Thank you meteos77 for the report.
• Corrected next and previous actions of photograph collections. Problem caused by type() override.
• Corrected photograph Qt signals.
• Improved detection of book binding types for MARC queries.
• Include multi-volume ISBNs in book prints.
• New book target audience field. Please upgrade your databases.
• Other book image retrieval.
• PostgreSQL 10.20.2; Windows.
• Qt 6.2 LTS is more complete!
• Remove ampersands from color buttons. Ampersands may be added by environments to denote mnemonics.
• Removed UNIQUE constraint from multivolume_set_isbn. See March 30, 2022 release notes for SQLite.
• SQLite 3.38.5; Windows.

Version 2022.03.30

Release Notes

• Copy contents of book_sequence and sequence tables during Merge SQLite Databases.
• Display a warning if the current database schema is not current.
• French release notes. Thank you meteos77.
• Limit Files Per Page (Files Browser) and Members Per Page (Members Browser) to 2500.
• Limit copies to 1000.
• New multivolume_set_isbn database field. For SQLite databases, the field cannot be added with a UNIQUE constraint per https://www.sqlite.org/lang_altertable.html. Consider merging the existing database with a newly-created database. See https://github.com//discussions/191.
1. Create a new SQLite database: File -> New SQLite Database.
2. Open Merge SQLite Databases: Tools -> Merge SQLite Databases.
3. Press Add Row.
4. Select the legacy SQLite database file.
5. Press the Merge button.
• PostgreSQL 10.20.1; Windows.
• Qt 6.2.4 LTS for Android.
• Retain SQLite upgrade statements of previous release (2022.02.30) only. All other statements have been archived in the source.
• Revised BiblioteQ.odt: new information, new sections, replaced images, spelling corrections.
• SQLite 3.38.2; Windows.

Version 2022.02.30

Release Notes

• Generate e-mail patron reminders.
• New Mokka information. Thank you tamascz.
• New alternate_id_1 and membership_fees database fields. Please upgrade database schemas.
• Open Library queries via alternate identifiers.
• Overdue Fees in Members Browser.
• Sort basic search (main window) results by titles. Thank you tamascz.

Version 2022.01.30

Release Notes

• BiblioteQ @ 20! Happy New Year!
• Configurable YAZ options.
• Corrected case-insensitive searches. Thank you meteos77.
• Corrected revisions of the main view via item details; persistent indices.
• Database Enumerations (binding types, languages, locations, monetary units) are now included in the book import.
• Disable the Reserve Selected Item context menu action if the current item is a photograph.
• Display import preview header strings in the import template table. For example, the preview table's column 1 text may be set to "Title" and the item at (0, 1) in the template table will have its text also set to "Title". Thank you meteos77.
• Display optimizations of large content.
• Do not disable database-connection widgets if a connection is already present.
• Enable case-sensitive-like for general SQLite searches.
• Export Icons View as PNG.
• Group returns of selected items via the All Reserved category.
• ISBN display format options. Please see Other Options.
• Initialize empty barcodes in copy editors.
• Members Browser pagination.
• New Other Options for setting the number of Icons Mode columns.
• New import template. Thank you meteos77.
• New open-postgresql-database terminal option.
• Print Icons View.
• Remove hyphens from ISBN fields within conditionals.
• SQLite 3.37.2; Windows.
• Simplify text before displaying it in the main table and associated tool tips. Thank you meteos77.

Version 2021.12.15

Release Notes

• Accession Number query; available from the main window.
• Allow for the SQL delete statement to be issued for custom queries.
• Automatically convert ISBN-10 to ISBN-13 during imports.
• Column-configuration option will be disabled for custom queries as the queries describe the desired columns.
• Corrected book read-status and custom queries for SQLite.
• Corrected column-configuration menu. Thank you meteos77.
• Corrected generation of CSV files from custom queries. Thank you meteos77.
• Corrected translations. New translation files.
• Embedded documentation and release notes.
• Inspect the font created from the global_font setting. If the font cannot be recreated, assign a default font.
• Introduced the timeout option for YAZ. The actual timeout varies.
• More complete lists of available database tables in Custom Query.
• New open-sqlite-database terminal option.
• Optional main window images and progress dialogs. Please see Other Options.
• Patron export and import.
• PostgreSQL 10.19; Windows.
• Qt 5.12.12 LTS; Windows.
• Qt 6.2 LTS. One item remaining.
• Restore and retain Members Browser's geometry.
• SQLite 3.37; Windows.
• SQLite database merge.
• Speedy reservations. New option in Members Browser.

Version 2021.10.30

Release Notes

• Android release. SQLite only.
• Avoid duplicate signals in Branch Selection.
• Corrected setting of book images with respect to the read-only column.
• Embedded translation files.
• Maximum reserved books. Please upgrade the database schemas. Limits are not enforced.
• New Total Reserved column in Members Browser.
• PostgreSQL 10.18.2, Windows.
• Qt 6.2 LTS. Incomplete.
• Removed e-mail validation. Qt 6.2 LTS.
• Sample SQLite database. Thank you sunyuyangg555.
• Spanish translation. Thank you caalma.
• YAZ is now optional.