02-03-2011, 02:29 PM | #1 |
Zealot
Posts: 143
Karma: 387
Join Date: Sep 2010
Device: Kindle 3
|
How do I download metadata only for books that don't have them?
Hi,
could someone please educate me how I can select the books in my library that
I am trying to clean up my library and would like to download the metadata only for the books which have, say, an empty product description (comment) field. In a separate search I'd also like to find the books for which I do not have covers yet. Is there a nice search command that one can use? Thanks a million, Mixx |
02-03-2011, 03:13 PM | #2 |
Sigil & calibre developer
Posts: 2,488
Karma: 1063785
Join Date: Jan 2009
Location: Florida, USA
Device: Nook STR
|
field:false
cover:false will show all books without a cover. |
Advert | |
|
02-03-2011, 04:26 PM | #3 |
Zealot
Posts: 143
Karma: 387
Join Date: Sep 2010
Device: Kindle 3
|
Thank you, user_none,
even PHP Code:
Thank you, Mixx |
02-04-2011, 12:38 PM | #4 |
Junior Member
Posts: 2
Karma: 10
Join Date: Feb 2011
Device: Droid X
|
whre do you put the PHP code. New to using Calibre for this.
|
02-04-2011, 12:43 PM | #5 |
350 Hoarder
Posts: 3,574
Karma: 8281267
Join Date: Dec 2010
Location: Midwest USA
Device: Sony PRS-350, Kobo Glo & Glo HD, PW2
|
Enter that code in the search box at the top of Calibre.
Btw, if you didn't go through the tutorials for Calibre, it's well worth your time to do so. The program is just amazing with what it can do that I wouldn't have been even half aware of without watching at least the 2 main videos. |
Advert | |
|
02-04-2011, 04:11 PM | #6 |
Junior Member
Posts: 2
Karma: 10
Join Date: Feb 2011
Device: Droid X
|
Thanks I will have to do that, did not realize how powerful calibre was.
|
02-05-2011, 09:25 AM | #7 |
Wizard
Posts: 1,674
Karma: 3111989
Join Date: Dec 2010
Location: Jianghu
Device: PW1, PW5, iPhone SE 2016, iPhone 13 Pro, iPad Pro 9.7, iPad Pro 2021
|
The same here! I was using calibre for over 6 mths just for conversions until I watched the videos and realized how much more it could do. I know I probably still use only about 1/2 of its capabilities but that half is just awesome!
|
04-21-2011, 12:23 PM | #8 |
Junior Member
Posts: 8
Karma: 10
Join Date: Apr 2011
Device: Sony 650
|
That works fine,
but how i can get comments under 10 or 15 words? Some like sience or book or ebook all that would be ignore if i try comment:false. How i can catch them to change them? wkr Lothar Last edited by knopix; 04-21-2011 at 12:25 PM. |
04-21-2011, 03:50 PM | #9 |
Wizard
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
|
I'm not certain I understand you, but I think you want to find books where the comments field has content, but not much content. I suspect you need the len() function. I'm pretty sure you can't do that with search. You might be able to do it by creating a custom column, but a quick check through the functions available didn't turn up len. I suspect we need Charles the guru for this one.
|
04-21-2011, 04:04 PM | #10 | |
Well trained by Cats
Posts: 29,800
Karma: 54830978
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Quote:
Code:
Select books.title,comments.text from comments,books where length(text)<25 and comments.id=books.id Last edited by theducks; 04-21-2011 at 04:18 PM. Reason: updated query |
|
04-21-2011, 04:04 PM | #11 | |
Grand Sorcerer
Posts: 11,741
Karma: 6997045
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Quote:
Code:
program:cmp(count(field('comments'), ' '), 15, 'true', 'true', 'false') You could just as easily use Code:
program:count(field('comments'), ' ') Code:
#column:<=15 |
|
04-21-2011, 05:55 PM | #12 | ||
Junior Member
Posts: 8
Karma: 10
Join Date: Apr 2011
Device: Sony 650
|
Thank @ all!
Quote:
Because its not all of them shown (i know some books and they will not shown) ------------ Quote:
You does great work. THX wkr Lothar Last edited by knopix; 04-21-2011 at 06:11 PM. |
||
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Metadata download - does it automatically search isbndb and Google books? | OakIris | Calibre | 22 | 10-27-2010 12:54 AM |
Metadata download | spacemonkey | Calibre | 13 | 08-13-2010 11:51 AM |
Metadata download plugins | newbino | Plugins | 3 | 07-31-2010 11:25 PM |
Download Metadata not working in 6.52 | Sydney's Mom | Calibre | 4 | 05-15-2010 01:34 PM |
Metadata - I only want to download Comments | guyanonymous | Calibre | 9 | 01-23-2010 07:36 AM |