View Single Post
Old 07-16-2020, 09:15 AM   #462
capink
Wizard
capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.
 
Posts: 1,203
Karma: 1995558
Join Date: Aug 2015
Device: Kindle
Version 1.4.9

Version 1.4.9
Update: Add a progress dialog.
Update: Add datatype validation.
Update: Add context menu for exporting to csv.
Fix: title/author match not matching books with multiple authors even if identical.
Fix: Update predefined sources: Amazon, NY Bestsellers.
Fix: Removed dead predefined sources: BookChart, Amazon Listmania, Play.com, SFFJazz, WHSmith
Fix: Guess form headers now ignores duplicate headers.
Fix: Update universal line mode to use open newline arg.
Fix: Remove unused custom series indices headers.
Fix: Error when removing and re-adding encodings.
Fix: Buttons in encoding dialog now change their state based on selected item.

Datatype validation: This feature is added to avoid the problem of the plugin failing midway with an exception because a value was not suitable for a column it was supposed to go (e.g text value for column that only accepts int or float). If you are importing a large dataset this can happen several minutes — or hours — into the import process. Now the datatype validation checks before proceeding, and if errors are found; a validation error message appears offering details. It also highlights errors in the preview table with a red color, and offers a checkbox option to filter the rows with errors, so that you inspect them, and if you want delete them and proceed with the rest of data. Also the new export to csv feature allows you to export the rows containing the errors to a csv file to deal with them later.

The only type of validation the plugin used to do before is checking title field, and preventing the user from proceeding if an empty title was found, but without any details of what and where the failure is. The title field check is included in the datatype validation but with details and highlighting.

The datatype validation only catches errors that used to stop the import process. This includes int, float, rating, datetime and title fields. Errors that are ignored by the plugin and discarded or replaced by default values are not included in the datatype validation. Examples of these are: illegal language values which are replaced with UNDEFINED by the plugin, and illegal boolean values which are replaced by False, series_index for which invalid values are replaced with 0, ivalid enum types which are discarded by the plugin.

There is also a fix for a problem with the original title/author matching of the plugin not being able to match books with multiple authors. It is surprising this has not been reported until now given how long ago this plugin was developed. @Rellwood reported problems with author/title matching without specifying multiple authors being the problem. I don't know if this solves his issues.

As with the previous version you are advised to use this only on a test library until you are satisfied it can be used on a daily basis.
Attached Thumbnails
Click image for larger version

Name:	1.png
Views:	260
Size:	348.1 KB
ID:	180679   Click image for larger version

Name:	2.png
Views:	241
Size:	309.3 KB
ID:	180680   Click image for larger version

Name:	3.png
Views:	255
Size:	243.7 KB
ID:	180681   Click image for larger version

Name:	4.png
Views:	273
Size:	159.0 KB
ID:	180682  

Last edited by capink; 08-13-2020 at 11:30 AM. Reason: remove link
capink is offline   Reply With Quote