Can I Add "Days Remaining" column to Calibre GUI?

soloist66 · 06-24-2011, 07:50 AM

Hi. I have a SONY PRS-650. Occasionally, I borrow books from the NYPL and use Calibre to download the book to my device.

I would like to add a column to the Calibre gui that shows the number of days remaining on a particular borrowed book. I see such a field is available in the Sony Reader Library app and the information is also displayed beneath the borrowed book's thumbnail on the device itself. But I'd also like to see it (as another reminder to hurry up and finish reading) on Calibre -- since I exclusively use Calibre to download eBooks to my device.

I've had a look at the "Add Your Own Columns" functionality on Calibre and am a bit stumped as to how to proceed. Would someone know whether it's possible to create such a field on Calibre? If so, how?

chaley · 06-24-2011, 11:13 AM

No. Getting that information requires mucking with the DRM information to find the rights, and nothing in calibre does this. I don't know if it is even possible to do, as getting that information might require registering with ADE and decrypting the book.

What I would do if I were you is make a date custom column and put the due date in it. You can then sort by that column to see the check-in order, and you can use searche to find books with check-in dates in the next few days. Something like the search #checkin_date:>-5daysago will find any checkin date within 5 days of today. The '-5' makes it a future reference, minus 5 days from today. Making it a saved search will save some time in the future.

soloist66 · 06-24-2011, 04:53 PM

Chaley, your suggestion of creating a custom field, adding the due date and creating a saved search based upon that custom field works for me. Thanks!

chaley · 06-25-2011, 05:50 AM

Note that with 0.8.7, it is possible to color a column based on the difference between two dates. Assume your column is called #mydate. The following advanced coloring rule will return the color red if #mydate is within 5 days of today.

Code:

program: 
  t=days_between(field('#mydate'), today());
  test(t, cmp(t, 5, 'red', '', ''), '')

Go to preferences/look and feel/coloring to create the advanced coloring rule.

soloist66 · 06-27-2011, 05:46 AM

Many thanks, indeed chaley. This is really very helpful...and gives me ideas for other custom fields!

06-24-2011, 07:50 AM	#1
soloist66 Enthusiast Posts: 25 Karma: 18490 Join Date: Nov 2010 Location: Irvington, NY Device: Sony PRS-650, Kindle PW11, iPad Air	Can I Add "Days Remaining" column to Calibre GUI? Hi. I have a SONY PRS-650. Occasionally, I borrow books from the NYPL and use Calibre to download the book to my device. I would like to add a column to the Calibre gui that shows the number of days remaining on a particular borrowed book. I see such a field is available in the Sony Reader Library app and the information is also displayed beneath the borrowed book's thumbnail on the device itself. But I'd also like to see it (as another reminder to hurry up and finish reading) on Calibre -- since I exclusively use Calibre to download eBooks to my device. I've had a look at the "Add Your Own Columns" functionality on Calibre and am a bit stumped as to how to proceed. Would someone know whether it's possible to create such a field on Calibre? If so, how?

06-25-2011, 05:50 AM	#4
chaley Grand Sorcerer Posts: 11,743 Karma: 6997045 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	Note that with 0.8.7, it is possible to color a column based on the difference between two dates. Assume your column is called #mydate. The following advanced coloring rule will return the color red if #mydate is within 5 days of today. Code: program: t=days_between(field('#mydate'), today()); test(t, cmp(t, 5, 'red', '', ''), '') Go to preferences/look and feel/coloring to create the advanced coloring rule.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sony software "running" but no gui	domromer	Sony Reader	2	03-30-2011 04:40 PM
"integrity error column book is not unique"	Atiajar	Calibre	4	12-21-2010 11:22 PM
Getting calibre to detect "Prologue" and "Epilogue" for TOC	sherman	Calibre	2	09-20-2010 02:21 AM
BUG: GUI View button not working if Author tag contains "ë"	ShellShock	Calibre	1	11-15-2008 01:21 PM
"Remaining" column in eBook Library?	anotherchance	Sony Reader	3	11-11-2008 11:16 PM

06-24-2011, 11:13 AM	#2
chaley Grand Sorcerer Posts: 11,743 Karma: 6997045 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	No. Getting that information requires mucking with the DRM information to find the rights, and nothing in calibre does this. I don't know if it is even possible to do, as getting that information might require registering with ADE and decrypting the book. What I would do if I were you is make a date custom column and put the due date in it. You can then sort by that column to see the check-in order, and you can use searche to find books with check-in dates in the next few days. Something like the search #checkin_date:>-5daysago will find any checkin date within 5 days of today. The '-5' makes it a future reference, minus 5 days from today. Making it a saved search will save some time in the future.

06-24-2011, 04:53 PM	#3
soloist66 Enthusiast Posts: 25 Karma: 18490 Join Date: Nov 2010 Location: Irvington, NY Device: Sony PRS-650, Kindle PW11, iPad Air	Chaley, your suggestion of creating a custom field, adding the due date and creating a saved search based upon that custom field works for me. Thanks!

06-27-2011, 05:46 AM	#5
soloist66 Enthusiast Posts: 25 Karma: 18490 Join Date: Nov 2010 Location: Irvington, NY Device: Sony PRS-650, Kindle PW11, iPad Air	Many thanks, indeed chaley. This is really very helpful...and gives me ideas for other custom fields!

Advert

Advert