Bash Script/SQL Query for ISBN in filename?

zenrhino · 09-26-2010, 03:08 AM

Hi,

Here's the scenario:

I have a large number of PDF's with the ISBN number in the filename (and therefore a number of books in my Calibre library that also have the ISBN in the title).

I was wondering if anyone had come up with either a bash script or a SQL query that would read for ISBN in the title field and then automagically drop the ISBN into the ISBN field and hit ISBNDB for the social metadata?

Perhaps this would be a nice feature for future versions?

All the best,

ZR

Starson17 · 09-26-2010, 08:55 AM

Use {isbn} in the regex Add field of Prefs|Import/Export|"Adding Books" to import the isbn from the file name. Turn off "Read metadata from file contents", import all your books, highlight them and fetch the metadata in bulk.

09-26-2010, 03:08 AM	#1
zenrhino Junior Member Posts: 8 Karma: 22 Join Date: Aug 2010 Device: iPad	Bash Script/SQL Query for ISBN in filename? Hi, Here's the scenario: I have a large number of PDF's with the ISBN number in the filename (and therefore a number of books in my Calibre library that also have the ISBN in the title). I was wondering if anyone had come up with either a bash script or a SQL query that would read for ISBN in the title field and then automagically drop the ISBN into the ISBN field and hit ISBNDB for the social metadata? Perhaps this would be a nice feature for future versions? All the best, ZR

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using SQL against Calibre database	jjansen	Calibre	3	03-29-2010 10:14 AM
Is it possible to execute a bash script from the SD card?	godel10	iRex	25	06-25-2009 03:55 PM
SQL Queries	iain_benson	Calibre	9	06-04-2009 06:08 PM
BASH script for *2lrf utilities (thanks Kovid!)...	KaiGoth	Sony Reader	0	08-05-2007 01:30 AM

09-26-2010, 08:55 AM	#2
Starson17 Wizard Posts: 4,004 Karma: 177841 Join Date: Dec 2009 Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T	Use {isbn} in the regex Add field of Prefs\|Import/Export\|"Adding Books" to import the isbn from the file name. Turn off "Read metadata from file contents", import all your books, highlight them and fetch the metadata in bulk.

Advert