Register Guidelines E-Books Today's Posts Search

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

Notices

Reply
 
Thread Tools Search this Thread
Old 05-04-2011, 03:27 PM   #1
MildBill
Enthusiast
MildBill doesn't litterMildBill doesn't litter
 
Posts: 31
Karma: 192
Join Date: Jan 2011
Device: Probably the Nook
Simple question - hopefully!

OK, I'll admit to being a bit of an idiot!

What I would like to know is how to add a custom column showing the nimber used in parenthesis after the name of the book in the folder name. I believe this is the db_id, from what I have been able to figure out so far, but I am at a loss after several tries to get it to display.


Any assistance would be greatly appreciated!

MildBill
MildBill is offline   Reply With Quote
Old 05-04-2011, 03:45 PM   #2
kiwidude
Calibre Plugins Developer
kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.
 
Posts: 4,637
Karma: 2162064
Join Date: Oct 2010
Location: Australia
Device: Kindle Oasis
Create a "Column built from other columns" with this formula:
Code:
{id}
Though the obvious question is why? This is an internal id. The only use I can think of it is for debugging plugins...
kiwidude is offline   Reply With Quote
Advert
Old 05-04-2011, 04:39 PM   #3
MildBill
Enthusiast
MildBill doesn't litterMildBill doesn't litter
 
Posts: 31
Karma: 192
Join Date: Jan 2011
Device: Probably the Nook
Quote:
Though the obvious question is why? This is an internal id. The only use I can think of it is for debugging plugins...

Well, actually, I have created a separate library that has several duplicate book titles (all one format), I am looking through them to decide which to delete, and if they are otherwise the same (and many are) I will delete the one added last, I.E. the one with the higher ID. Having it displayed is simpler.

MildBill
MildBill is offline   Reply With Quote
Old 05-04-2011, 04:51 PM   #4
kiwidude
Calibre Plugins Developer
kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.
 
Posts: 4,637
Karma: 2162064
Join Date: Oct 2010
Location: Australia
Device: Kindle Oasis
Ok, though why not use the date column?
kiwidude is offline   Reply With Quote
Old 05-04-2011, 04:56 PM   #5
MildBill
Enthusiast
MildBill doesn't litterMildBill doesn't litter
 
Posts: 31
Karma: 192
Join Date: Jan 2011
Device: Probably the Nook
Quote:
Originally Posted by kiwidude View Post
Ok, though why not use the date column?
Most of them (over 1100) were added on the same date, in one operation.

MildBill

PS Thanks, your code worked perfectly.
PPS All a part of trying to get my various e-books together in one system, next thing to figure out is how to merge the two librarys once I have weeded these, and then again eliminate duplicates.

Last edited by MildBill; 05-04-2011 at 04:58 PM.
MildBill is offline   Reply With Quote
Advert
Old 05-04-2011, 05:18 PM   #6
kiwidude
Calibre Plugins Developer
kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.
 
Posts: 4,637
Karma: 2162064
Join Date: Oct 2010
Location: Australia
Device: Kindle Oasis
Date is a timestamp field, so even though you are not seeing the hour/minute/seconds they are still present in the data and will be applied when you sort. But whatever works for you

Are you using the Find Duplicates plugin out of curiosity? As for merging the libraries, you can use the Copy to Library function, and you might want to investigate the automerge options having it applied or not as you may prefer.
kiwidude is offline   Reply With Quote
Old 05-04-2011, 05:38 PM   #7
MildBill
Enthusiast
MildBill doesn't litterMildBill doesn't litter
 
Posts: 31
Karma: 192
Join Date: Jan 2011
Device: Probably the Nook
Quote:
Originally Posted by kiwidude View Post
Are you using the Find Duplicates plugin out of curiosity? As for merging the libraries, you can use the Copy to Library function, and you might want to investigate the automerge options having it applied or not as you may prefer.
No, actually, I am not... -> But I will download it and give it a try!

MildBill

I have downloaded and installed the plugin (using the excellent 'Plugin Updater' plugin!), and, so far, it works great! Thanks! Very fast, too!

Last edited by MildBill; 05-04-2011 at 05:45 PM.
MildBill is offline   Reply With Quote
Reply


Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple question jdomingos76 Recipes 1 03-31-2011 01:48 PM
Should be a simple question jbcohen Apple Devices 14 03-20-2011 02:19 PM
erm, simple question , hope for simple answer! al zymers Amazon Kindle 5 09-25-2010 01:01 PM
Simple question for a simple mind :) PKFFW OpenInkpot 6 08-27-2009 09:00 PM
SIMPLE QUESTION wrgoodman Sony Reader 3 09-12-2007 11:04 PM


All times are GMT -4. The time now is 04:28 PM.


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