[DaltonST]

@Kay__2:

One thing I'm not sure about if you were aware of: If you come across the add-on in the "add-plugins" section of Calibre (as I did), the plug-in does not include the .csv and .ods files.

Naturally. If someone is not clever enough to find this forum, then they are not capable of using DG without hand-holding, which I do not do for any of my 4 plug-ins/add-ons.

Also I was kind of wondering if there's a chance to put the sheets into the library folder instead of leaving it in the general documents folder. Once I put it into a folder the plug-in can't detect it apparently even if it's standing right next to the metadata of calibre data-file.

Absolutely not. Nothing goes in the Calibre library folder except Calibre library files. Also, Page 16 of the User Guide explains why they go where they go. Nothing was done randomly. It is your decision to put Calibre in your Documents folder. I have Calibre on 4 Windows PCs, and none of them are in My Documents, or even on Drive C:.

I was wondering if there's a plug-in or w/e that could help me extract lists (for example of authors) in spreadsheet form. I've yet to come across one and I think it'd be totally handy for mass-editing meta data in excel/libre office.

Standard Calibre functionality has a special Calibre utility that can do that. It will create a .txt file that you can import into Calc or Google Docs to create a .csv file that is UTF8 compliant. An example .bat file is shown below. Refer to Calibre documentation at: http://manual.calibre-ebook.com/cli/...calibredb-list

c:
cd "C:\Program Files\Calibre2\"
REM calibredb.exe --help > "C:\Users\User\Desktop\mylist_help_entire.txt"
REM calibredb.exe list --help > "C:\Users\User\Desktop\mylist_help.txt"
REM calibredb.exe list --fields=all --limit=10 --with-library="s:\Users\Public\Public eBooks\CalibreMain" > "C:\Users\User\Desktop\mylist_1.txt"
REM calibredb.exe list -f tags --search=tags:true --sort-by=tags --ascending --line-width=80 --limit=100 --with-library="S:\Users\Public\Public eBooks\CalibreMain" > "C:\Users\User\Desktop\mylist_tags.txt"
REM calibredb.exe list --fields=tags,*genre --limit=10 --line-width=99  --with-library="S:\Users\Public\Public eBooks\CalibreMain" > "C:\Users\User\Desktop\mylist_tags.txt"
REM calibredb.exe list --fields=tags --line-width=240 --limit=100 --with-library="S:\Users\Public\Public eBooks\CalibreMain" > "C:\Users\User\Desktop\mylist_tags.txt"
pause

I think it'd be totally handy for mass-editing meta data in excel/libre office.

Page 17 of the DG User Guide states that Excel is not UTF8 compliant and cannot be used. Libre is a fork of OpenOffice, so its Calc equivalent is likely highly UTF8 compliant as mentioned on Page 17 of the User Guide. All of the sample .csv files were created in OpenOffice Calc.

Entering every Author name by hand can be tiresome if you have over 20k books in your library and use it for both private literature as well as university books and cooking guides.

See above re: calibredb.exe. Also, DG comes with a .csv file of 10,000 authors rules that are included in https://www.mobileread.com/forums/att...6&d=1406980979 on the Original Post. I did not key those in by hand, by the way.

If you use the QuarantineAndScrub version of DG that uses tables, and not .csv files, there is a .sql file of the 10,000 author rules for importing directly into the Q&S _dg_genre_author_rules table. The instructions for that are in the Q&S DG User Guide (separate from the original DG User Guide, since Q&S DG is a sub-function of Q&S.).


Best of luck.



DaltonST