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: 10 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?

07-05-2012, 12:16 PM	#2
kiwidude calibre/Sigil Developer Posts: 4,087 Karma: 1211084 Join Date: Oct 2010 Location: London, UK Device: Kindle 3 3G, iPad 2, iPad 3	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. __________________ Like my calibre plugins or Sigil work? Say thanks with PayPal

07-07-2012, 02:26 PM	#4
kiwidude calibre/Sigil Developer Posts: 4,087 Karma: 1211084 Join Date: Oct 2010 Location: London, UK Device: Kindle 3 3G, iPad 2, iPad 3	@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. __________________ Like my calibre plugins or Sigil work? Say thanks with PayPal

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

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-07-2012, 01:54 PM	#3
djrm Member Posts: 19 Karma: 10 Join Date: Aug 2010 Location: NJ, USA Device: iPod touch 4g, iPad 2	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:49 PM	#5
djrm Member Posts: 19 Karma: 10 Join Date: Aug 2010 Location: NJ, USA Device: iPod touch 4g, iPad 2	Thank you. I did not know that. Learn something new everyday!


Advertisement Enthusiast