MobileRead Forums - View Single Post

DaltonST · 03-18-2019, 05:40 PM

Version 1.0.150 - 2019-03-18 Enhancements to "Import CSV File to Update Metadata" to add ability to update the Standard Columns of Comments, Identifiers, Publisher and Tags.

The documentation for this Tool is contained in its ToolTips, which have been revised to reflect new functionality and CSV File value format requirements for Identifiers, etc. Reading the ToolTips is a prerequisite for using this Tool.

Tip: Calibre has a very useful "Create Catalog in CSV File Format" ability to create a CSV File using your personal metadata. Caution: do not select any numeric columns for export, since the resulting CSV File Format will be corrupted with non-text values. Text-only. Caution: 'Yes/No' (boolean) columns are exported as integers (0 or 1 or blank), not "True" or "False" or "". This tool requires Text. Create a brand-new CSV File that is empty in your spreadsheet editor, then copy-and-paste specific columns from the Create Catalog CSV File into your fresh CSV File to avoid any problems. Never import into this tool an original Create Catalog CSV File, since it will likely cause corruption and failure in this tool.

Tip: To match a CSV File row on a Book ID basis, simply create a temporary Custom Column of type "short text" (not Integer), and use Search & Replace (Source = template {id}) to populate it. A CSV File bootstrapped from Create Catalog then could have ID as a column, which would have to be turned into Text (not Numeric) in your Spreadsheet editor for it. This Tool only handles text that is properly double-quoted. You could then "match" each row of the CSV file to each Book ID using the temporary textual ID Custom Column as its proxy. That may be useful for updating Identifiers en masse. Afterwards, delete the temporary Custom Column, then compress/defragment your Library as normal.

DaltonST

03-18-2019, 05:40 PM	#426
DaltonST Deviser Posts: 2,265 Karma: 2090983 Join Date: Aug 2013 Location: Texas Device: none	Version 1.0.150 Upload Standard Columns: Comments, Identifiers, Publisher and Tags Version 1.0.150 - 2019-03-18 Enhancements to "Import CSV File to Update Metadata" to add ability to update the Standard Columns of Comments, Identifiers, Publisher and Tags. The documentation for this Tool is contained in its ToolTips, which have been revised to reflect new functionality and CSV File value format requirements for Identifiers, etc. Reading the ToolTips is a prerequisite for using this Tool. Tip: Calibre has a very useful "Create Catalog in CSV File Format" ability to create a CSV File using your personal metadata. Caution: do not select any numeric columns for export, since the resulting CSV File Format will be corrupted with non-text values. Text-only. Caution: 'Yes/No' (boolean) columns are exported as integers (0 or 1 or blank), not "True" or "False" or "". This tool requires Text. Create a brand-new CSV File that is empty in your spreadsheet editor, then copy-and-paste specific columns from the Create Catalog CSV File into your fresh CSV File to avoid any problems. Never import into this tool an original Create Catalog CSV File, since it will likely cause corruption and failure in this tool. Tip: To match a CSV File row on a Book ID basis, simply create a temporary Custom Column of type "short text" (not Integer), and use Search & Replace (Source = template {id}) to populate it. A CSV File bootstrapped from Create Catalog then could have ID as a column, which would have to be turned into Text (not Numeric) in your Spreadsheet editor for it. This Tool only handles text that is properly double-quoted. You could then "match" each row of the CSV file to each Book ID using the temporary textual ID Custom Column as its proxy. That may be useful for updating Identifiers en masse. Afterwards, delete the temporary Custom Column, then compress/defragment your Library as normal. DaltonST Last edited by DaltonST; 03-20-2019 at 12:38 PM. Reason: (Source = template {id})