4.0.0: importer and database synchronization #46

stojy · 2022-08-02T08:10:35Z

stojy
Aug 2, 2022
Maintainer

Full release notes moved here to avoid an issue with v3 not supporting scrolled content. Fixed in v4.

Added ability to synchronize the local PinballY/PinballX database with information from online sources (refer update local table pinballX/Y database file with online table information #41).
1. Single table - new dialog to view and (optionally) edit table properties.
  - Update existing table properties. Information can be entered manually or provided via online sources.
  - Add new table. Information is seeded from online sources and can be manually overwritten if required.
2. Multiple tables - for existing tables from local database that are matched against tables from online sources.
  - Add any missing properties, e.g. author, genre, manufacturer, year, etc.
  - Overwrite all properties for all existing tables, e.g. manufacturer, year, name (table files), description (front end media), etc.
More online feed parsing improvements, e.g.
- Handling of specific tables that are known to be incorrect, e.g. wrong manufacturer/year.
- Remove duplicate table entries.
- Upgrade URLs to https.
- IPDB URLs
- Remove author from table name.
- etc.
Added option to selectively disabled/enabled the feed parsign fixes. Recommended to keep them enabled.
Added popup dialogs to indicate.
- How many files were not matched
- Statistics summary when adding missing table properties or updating/overwriting exist properties.

Improved fuzzy matching.
- Support additional special characters, e.g. ellipsis at end of file, ampersand, etc.
- Tweaked scoring to include manufacturer.
- File names containing multiple parenthesis, e.g. "Spider-Man (Limited Edition) (Stern 2016)".
- More performant.
- Various edge cases.
- etc.
Improved logging.
- Clearer logging to assist diagnosis, e.g. for identifyign why tables are (or are not) matched.
- Optionally remove logging for original table matching.
Improved identification of manufactured vs original tables.
Added manual 'check for update' in about menu.
Reduced memory footprint.
Improved UI consistency.
Added popup dialog support in the event of an unhandled error. Closing the dialog will automatically redirect to github to raise a bug.

Added popup dialog indicating how many manufactured table files are missing.
Improved backup folder management.
- Folder names changed to represent the content type instead of the source sub-folder name to make it easier to import files (via 'Importer' feature). e.g. "flyer images\back" instead of just "back"
- Fixed bug where unknown files were backed up in the backup folder without a timestamp.