Register Guidelines E-Books Search Today's Posts Mark Forums Read

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

Notices

Reply
 
Thread Tools Search this Thread
Old 10-23-2014, 01:10 AM   #1
JohnnyBook
Zealot
JohnnyBook for a long time would go to bed early.JohnnyBook for a long time would go to bed early.JohnnyBook for a long time would go to bed early.JohnnyBook for a long time would go to bed early.JohnnyBook for a long time would go to bed early.JohnnyBook for a long time would go to bed early.JohnnyBook for a long time would go to bed early.JohnnyBook for a long time would go to bed early.JohnnyBook for a long time would go to bed early.JohnnyBook for a long time would go to bed early.JohnnyBook for a long time would go to bed early.
 
Posts: 124
Karma: 17646
Join Date: Dec 2008
Location: Out There
Device: K3 WF/3G (dead screen) & K4NT
Sort by Calibre Folder ID

Can the books be sorted by the Calibre Folder IDs?

I know the IDs can be displayed in the book details screen.

But don't see a way to display that column in the library display.

I would assume I need to make a custom column?

Thanks,
JohnnyBook is offline   Reply With Quote
Old 10-23-2014, 01:24 AM   #2
chaley
"chaley", not "charley"
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 5,690
Karma: 1137958
Join Date: Jan 2010
Location: France
Device: Many android devices
Make a custom column "built from other columns". Set the template to {id}. Set the Search/Sort type to number.
chaley is offline   Reply With Quote
 
Enthusiast
Old 10-23-2014, 09:08 AM   #3
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,903
Karma: 5880479
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by JohnnyBook View Post
Can the books be sorted by the Calibre Folder IDs?

I know the IDs can be displayed in the book details screen.

But don't see a way to display that column in the library display.

I would assume I need to make a custom column?

Thanks,
'Natural order' (un-sorted), original{id} order closesly follows the Date column if you do not change that value.

I noted original{id} because I believe there are events that impose a new ID number

Having to burden the database with a custom column to get at something that exists naturally tends to 'off' my sensibilities .

By default, Calibre starts with the last sorted column
OR
using the tweak: ID: sort_columns_at_startup
'None' being the standard behavior (above)

sort_columns_at_startup = [('id',0)]
works on Windows for the initial startup of a Calibre session
theducks is offline   Reply With Quote
Old 10-24-2014, 12:34 AM   #4
eschwartz
Irrational Optimist
eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.
 
Posts: 6,725
Karma: 11161085
Join Date: Nov 2012
Location: The Beaten Path, USA, Roundworld, This Side of Infinity
Device: Kindle Touch fw5.3.7 (Wifi only)
Quote:
Originally Posted by theducks View Post
I noted original{id} because I believe there are events that impose a new ID number
New id numbers only happen when book records are deleted and readded, probably through save to disk. (copying to-from staging libraries would do the same.)

Even Restore database uses the same id numbers from the filename. (I guess it recycles the numbers after the last one?)
eschwartz is offline   Reply With Quote
Old 10-24-2014, 10:06 AM   #5
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,903
Karma: 5880479
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by eschwartz View Post
New id numbers only happen when book records are deleted and readded, probably through save to disk. (copying to-from staging libraries would do the same.)

Even Restore database uses the same id numbers from the filename. (I guess it recycles the numbers after the last one?)
Restore DB uses the OPF file which has the id number stored
theducks is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Reimport books from another folder to Calibre folder structure? mendhak Calibre 2 10-11-2013 01:18 AM
Calibre - sort by author last name Switters Calibre 1 07-20-2013 05:39 PM
Folder Sort Options in Windows 7 (Calibre) D_Tomblin Library Management 3 06-17-2012 09:04 PM
Calibre 8.54 - Problem with Sort mitch13 Library Management 3 06-15-2012 02:11 AM
Can I change author sort with Calibre? Sydney's Mom Calibre 4 12-09-2009 09:33 PM


All times are GMT -4. The time now is 02:26 AM.


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