Get Metadata in bulk FROM FILE?

dandichka · 07-05-2012, 12:13 PM

Is there a way to get metadata in bulk from the files after they've been imported into Calibre (i.e. they were imported earlier using "filename" rather than internal metadata)? I am aware that you CAN get covers, but what of the other info?

kiwidude · 07-05-2012, 12:16 PM

I'm not aware of a bulk way to do it. That doesn't mean there isn't one, but it isn't obvious

.

Certainly you can do it for one book at a time by clicking on the blue i icon in the single edit metadata screen.

djrm · 07-07-2012, 01:54 PM

I've actually just found a Firefox plugin that will open the metadata database and allow me to export all of the data to csv files, which can then be opened in Microsoft Excel or Access.

The plugin is called SQLite Manager. (Whenever I use it, I always make a copy of the calibre database file "metadata.db" and use SQLite Manager to open the copy)

Hope this helps.

DJRM

kiwidude · 07-07-2012, 02:26 PM

@djrm - that is a different type of metadata. The original poster was (I interpreted) asking about the metadata embedded inside the files themselves, not the calibre library metadata.

If you just want to do a CSV export of calibre then there is no need to go using tools against the calibre library database. Just use the "Catalog" feature of calibre which has the ability to export to CSV.

djrm · 07-07-2012, 02:49 PM

Thank you. I did not know that. Learn something new everyday!

07-05-2012, 12:13 PM	#1
dandichka Member Posts: 12 Karma: 10 Join Date: Jul 2012 Device: Ipad	Get Metadata in bulk FROM FILE? Is there a way to get metadata in bulk from the files after they've been imported into Calibre (i.e. they were imported earlier using "filename" rather than internal metadata)? I am aware that you CAN get covers, but what of the other info?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Bulk downloading of metadata	Taka B.	Library Management	3	01-12-2012 05:09 PM
how to write calibre metadata to the book file in bulk?	user105	Calibre	7	01-04-2012 05:21 AM
Bulk metadata edit, set cover from ebook file	Stampercam	Calibre	2	01-13-2011 04:43 PM
Updating Metadata in Bulk	Turt99	Calibre	5	06-07-2010 03:19 PM
metadata in bulk	Lorraine Froggy	Calibre	1	11-14-2009 09:42 PM

07-05-2012, 12:16 PM	#2
kiwidude Calibre Plugins Developer Posts: 4,728 Karma: 2197770 Join Date: Oct 2010 Location: Australia Device: Kindle Oasis	I'm not aware of a bulk way to do it. That doesn't mean there isn't one, but it isn't obvious . Certainly you can do it for one book at a time by clicking on the blue i icon in the single edit metadata screen.

07-07-2012, 01:54 PM	#3
djrm Enthusiast Posts: 33 Karma: 10 Join Date: Aug 2010 Location: NJ, USA Device: iPad mini 4, iPhone 6s	I've actually just found a Firefox plugin that will open the metadata database and allow me to export all of the data to csv files, which can then be opened in Microsoft Excel or Access. The plugin is called SQLite Manager. (Whenever I use it, I always make a copy of the calibre database file "metadata.db" and use SQLite Manager to open the copy) Hope this helps. DJRM

07-07-2012, 02:26 PM	#4
kiwidude Calibre Plugins Developer Posts: 4,728 Karma: 2197770 Join Date: Oct 2010 Location: Australia Device: Kindle Oasis	@djrm - that is a different type of metadata. The original poster was (I interpreted) asking about the metadata embedded inside the files themselves, not the calibre library metadata. If you just want to do a CSV export of calibre then there is no need to go using tools against the calibre library database. Just use the "Catalog" feature of calibre which has the ability to export to CSV.

07-07-2012, 02:49 PM	#5
djrm Enthusiast Posts: 33 Karma: 10 Join Date: Aug 2010 Location: NJ, USA Device: iPad mini 4, iPhone 6s	Thank you. I did not know that. Learn something new everyday!

Advert

Advert