Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 11-18-2020, 06:59 AM   #1
Dan Goodale
Junior Member
Dan Goodale began at the beginning.
 
Posts: 5
Karma: 10
Join Date: Dec 2019
Device: Honor 8
Cant figure out how to catalog using calibredb

Hi folks. I have 45,000 books across 7 Calibre libraries. I want to use calibredb to create catalogs for all the libraries and merge them into one .csv file to make it easier to find all of an authors books, regardless of genre.

The documentation for calibredb isn't clear enough to help me do this successfully. For my test, I tried to catalog my archive library
C:\"Program Files"\Calibre\calibredb catalog archives C:\batch\test\archives.csv

But I get:
Failed to initialize plugin: 'C:\\Users\\Dan\\AppData\\Roaming\\calibre\\plugin s\\DeDRM.zip'
Usage: calibredb.exe command [options] [arguments]

Can someone explain to me how to write a script that actually works, please?

Thanks!

Dan Goodale
Dan Goodale is offline   Reply With Quote
Old 11-18-2020, 07:30 AM   #2
georgemk
Connoisseur
georgemk can tie a knot in a cherry stem with his or her tonguegeorgemk can tie a knot in a cherry stem with his or her tonguegeorgemk can tie a knot in a cherry stem with his or her tonguegeorgemk can tie a knot in a cherry stem with his or her tonguegeorgemk can tie a knot in a cherry stem with his or her tonguegeorgemk can tie a knot in a cherry stem with his or her tonguegeorgemk can tie a knot in a cherry stem with his or her tonguegeorgemk can tie a knot in a cherry stem with his or her tonguegeorgemk can tie a knot in a cherry stem with his or her tonguegeorgemk can tie a knot in a cherry stem with his or her tonguegeorgemk can tie a knot in a cherry stem with his or her tongue
 
Posts: 90
Karma: 22792
Join Date: Oct 2019
Device: nook Simple Touch with Glowlight
The syntax is

calibredb catalog outputfilenamehere --library-path=path to the archive library


For a full list of what options are available use

calibredb catalog outputfilenamehere --help

Last edited by georgemk; 11-18-2020 at 07:32 AM.
georgemk is offline   Reply With Quote
Old 11-18-2020, 10:26 AM   #3
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 25,820
Karma: 39099821
Join Date: Aug 2009
Location: The Central Coast of California
Device: K4NT(Fixed,New Bat.), Galaxy Tab A, Kobo Aura2
Quote:
Originally Posted by Dan Goodale View Post
Hi folks. I have 45,000 books across 7 Calibre libraries. I want to use calibredb to create catalogs for all the libraries and merge them into one .csv file to make it easier to find all of an authors books, regardless of genre.

The documentation for calibredb isn't clear enough to help me do this successfully. For my test, I tried to catalog my archive library
C:\"Program Files"\Calibre\calibredb catalog archives C:\batch\test\archives.csv

But I get:
Failed to initialize plugin: 'C:\\Users\\Dan\\AppData\\Roaming\\calibre\\plugin s\\DeDRM.zip'
Usage: calibredb.exe command [options] [arguments]

Can someone explain to me how to write a script that actually works, please?

Thanks!

Dan Goodale
Your issue may be because you are using 5.x, which precludes the above mentioned PI. Uninstall the PI.

AFAIK calibredb has no ability to append to a single CSV
theducks is offline   Reply With Quote
Old 11-20-2020, 04:40 AM   #4
Dan Goodale
Junior Member
Dan Goodale began at the beginning.
 
Posts: 5
Karma: 10
Join Date: Dec 2019
Device: Honor 8
So I used "C:\Program Files\Calibre\calibredb catalog c:\batch\archives.csv" and actually got a catalog for my Fantasy library.

How do I tell it what library to catalog? I need one for all 7 libraries so I can merge them all into 1 file.
Dan Goodale is offline   Reply With Quote
Old 11-20-2020, 05:20 AM   #5
BetterRed
null operator
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 16,730
Karma: 19705250
Join Date: Mar 2012
Location: Sydney Australia
Device: none
See the --library-path, --with-library Global options in ==>> calibredb — calibre 5.5.0 documentation

BR
BetterRed is online now   Reply With Quote
Old 11-21-2020, 06:34 AM   #6
Dan Goodale
Junior Member
Dan Goodale began at the beginning.
 
Posts: 5
Karma: 10
Join Date: Dec 2019
Device: Honor 8
almost there

Sorry folks, I'm not good at understanding manuals. But, I've got it pretty much figured out through trial and error. Now all I need is a way to exclude, or only include, certain columns. It looks like you can choose fields if you're generating a list but, I don't see how to exclude them in a catalog without using the GUI.

Any helpful suggestions?
Dan Goodale is offline   Reply With Quote
Old 11-21-2020, 08:15 AM   #7
georgemk
Connoisseur
georgemk can tie a knot in a cherry stem with his or her tonguegeorgemk can tie a knot in a cherry stem with his or her tonguegeorgemk can tie a knot in a cherry stem with his or her tonguegeorgemk can tie a knot in a cherry stem with his or her tonguegeorgemk can tie a knot in a cherry stem with his or her tonguegeorgemk can tie a knot in a cherry stem with his or her tonguegeorgemk can tie a knot in a cherry stem with his or her tonguegeorgemk can tie a knot in a cherry stem with his or her tonguegeorgemk can tie a knot in a cherry stem with his or her tonguegeorgemk can tie a knot in a cherry stem with his or her tonguegeorgemk can tie a knot in a cherry stem with his or her tongue
 
Posts: 90
Karma: 22792
Join Date: Oct 2019
Device: nook Simple Touch with Glowlight
Just add the --fields option at the end of your command line
Quote:
--fields=FIELDS The fields to output when cataloguing books in the
database. Should be a comma-separated list of fields.
Available fields: all, title, title_sort, author_sort,
authors, comments, cover, formats, id, isbn,
library_name, ondevice, pubdate, publisher, rating,
series_index, series, size, tags, timestamp, uuid,
languages, identifiers,
plus user-created custom fields.
Example: --fields=title,authors,tags
Default: 'all'
Applies to: CSV, XML output formats
Code:
calibredb catalog mylibary.csv --fields=title,authors
creates a file containing all my books showing only the title and author
georgemk is offline   Reply With Quote
Old 11-27-2020, 06:28 AM   #8
Dan Goodale
Junior Member
Dan Goodale began at the beginning.
 
Posts: 5
Karma: 10
Join Date: Dec 2019
Device: Honor 8
AWESOME George! You have NO idea how helpful that was. My library grows almost daily and since authors don't stay in one genre, a spreadsheet is really the only way to find an authors books across all libraries, as far as I know. Building it by hand stunk!

Thanks!!!!!
Dan Goodale is offline   Reply With Quote
Old 11-27-2020, 10:08 AM   #9
Sirtel
Wizard
Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.
 
Sirtel's Avatar
 
Posts: 3,396
Karma: 29738420
Join Date: Jan 2014
Location: Estonia
Device: Kindle Oasis 2/Oasis 3, Nook Glowlight Plus 7.8'', Kobo Libra H2O
Quote:
Originally Posted by Dan Goodale View Post
AWESOME George! You have NO idea how helpful that was. My library grows almost daily and since authors don't stay in one genre, a spreadsheet is really the only way to find an authors books across all libraries, as far as I know. Building it by hand stunk!

Thanks!!!!!
You could use virtual libraries instead of actual ones. That way you would retain the option to search for all books of an author.
Sirtel is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Calibredb Catalog "cannot generate catalog in EPUB format rracoon01 Library Management 5 07-13-2018 09:19 PM
calibredb won't export catalog after upgrade to 3.1.1 jvorzimmer Library Management 4 06-26-2017 11:52 PM
"calibredb catalog" and customized column with template commandante Library Management 2 07-19-2016 04:41 PM
command line "calibredb catalog" problems Divingduck Calibre 12 12-26-2014 06:01 PM
calibredb catalog CLI error ilovejedd Library Management 4 02-06-2012 11:26 AM


All times are GMT -4. The time now is 10:25 PM.


MobileRead.com is a privately owned, operated and funded community.