View Single Post
Old 11-08-2012, 09:02 PM   #402
theducks
Grand Sorcerer
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 14,534
Karma: 5567087
Join Date: Aug 2009
Location: The (original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by BetterRed View Post
What I wrote was



Typically there would less than 15 books displayed in the list from a library approaching 4000, the selection being based on the #status custom column.

Currently I
  1. create a Temporary library using the structure from my Main library
  2. move the displayed books (#status:"=72 finalCheck") from my Main Library to the Temporary library,
  3. close Calibre
  4. process everything in the Temporary library via a powershell script
  5. start Calibre
  6. update the #status column for all the books in the Temporary library to '85 Final'
  7. move all the books in the Temporary library to the Main library
  8. remove the Temporary library, from Calibre and Windows

The list would obviate the need for the Temporary library - I would use it drive the powershell script and update the book files in-situ - ie in the Main library.

Thanks BR
All books are currently displayed unless you STATE you are using a restricted view (you did not, so I assumed you want the pat for ALL of the library )

How good is your SQL ?
'Path' is stored in the Books table
calibredb List --fields=All gets you an output listing file that include the book ID. You can ad a --search to the command to limit the returned items
theducks is online now   Reply With Quote