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 12-17-2019, 10:01 PM   #841
theducks
Well trained by Cats
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: 24,613
Karma: 34133341
Join Date: Aug 2009
Location: The Central Coast of California
Device: K4NT(RIP), Galaxy Tab A, Kobo Aura2
Quote:
Originally Posted by retro View Post
I setup a metadata plugboard for the KoboTouchExtended driver using this as my source template.

{series}{series_index:0>5.2f|| - }{title} > title_sort

It mostly works, but the series are sorting alphabetically by title rather than series number. The series titles stay together but if an author has more than one series, they aren't alphabetical either. So the results look like this when sorted by author:

Daughter of Atrocity
Sirona Cycle - 2

The Jump Point
Sirona Cycle - 1

Nullifier
Fire and Rust - 6

Refuge
Fire and Rust - 5

Am I doing something wrong or is this expected behavior?
I think it is expected. very few things can handle a biased sort like the Calibre gui does.
FWIW I make {series} into a collection and do NOT put it in the plugboard term.
As a matter of fact, I dont even use the plugboard with my Aura2.
I just configured the driver. Index does not show (and I just noticed ). Kobo uses a Database. I will play, but making Series into a collection is good
Attached Files
File Type: zip device_drivers_KOBO.py.json.zip (352 Bytes, 18 views)
theducks is online now   Reply With Quote
Old 12-17-2019, 11:02 PM   #842
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 18,417
Karma: 30697406
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by retro View Post
I setup a metadata plugboard for the KoboTouchExtended driver using this as my source template.

{series}{series_index:0>5.2f|| - }{title} > title_sort

It mostly works, but the series are sorting alphabetically by title rather than series number. The series titles stay together but if an author has more than one series, they aren't alphabetical either. So the results look like this when sorted by author:

Daughter of Atrocity
Sirona Cycle - 2

The Jump Point
Sirona Cycle - 1

Nullifier
Fire and Rust - 6

Refuge
Fire and Rust - 5

Am I doing something wrong or is this expected behavior?
Kobo devices do not use the author_sort or title_sort. Your metadata plugboard is not actually changing anything the device uses. And what you are seeing above, series grouped when sorting by an author, is a fluke.

When sorting by author or title, the Kobo devices do not use the series. They sort by author (as "LN, FN") and within that, by the book title. The title sorting uses what calibre calls "library_order". That means that articles at the start of the title are moved to the end. So, "The Jump Point" will be sorted as "Jump Point, The". If the above is an example from your device, the fact that the series are grouped together is a fluke. The titles just happen to sort that way.

Kobo devices do support series sorting. As you have the series info on the device, sorting by that will put the series together in the correct order. That will be global in the library, not grouped within authors. But, there is also the authors list. From there you can view individual authors. This supports all the sorting options.
davidfor is online now   Reply With Quote
Advert
Old 12-17-2019, 11:07 PM   #843
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 18,417
Karma: 30697406
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by theducks View Post
I just configured the driver. Index does not show (and I just noticed ). Kobo uses a Database. I will play, but making Series into a collection is good
And I encourage everyone with a Kobo device to ask them to add a series list, just like they did for authors.
davidfor is online now   Reply With Quote
Old 12-18-2019, 09:54 AM   #844
retro
Zealot
retro doesn't litterretro doesn't litterretro doesn't litter
 
Posts: 141
Karma: 245
Join Date: Aug 2009
Location: USA
Device: Kobo Clara Blue PRS 350
Quote:
Originally Posted by davidfor View Post
And I encourage everyone with a Kobo device to ask them to add a series list, just like they did for authors.
I will! My 9 year old sony did it with the pretty much same metadata plugboard. Seems like it would be a simple fix.
Thanks!
retro is offline   Reply With Quote
Old 12-18-2019, 10:52 AM   #845
JSWolf
Resident Curmudgeon
JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.
 
JSWolf's Avatar
 
Posts: 55,497
Karma: 51439670
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Aura H2O, Sony PRS-650, Sony PRS-T1, nook STR, iPad 4, iPhone 5
Quote:
Originally Posted by davidfor View Post
And I encourage everyone with a Kobo device to ask them to add a series list, just like they did for authors.
Where is the best place to ask Kobo for enhancement requests?
JSWolf is offline   Reply With Quote
Advert
Old 12-18-2019, 11:04 AM   #846
JSWolf
Resident Curmudgeon
JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.
 
JSWolf's Avatar
 
Posts: 55,497
Karma: 51439670
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Aura H2O, Sony PRS-650, Sony PRS-T1, nook STR, iPad 4, iPhone 5
@retro when you first add books to your Kobo, you have to eject the Kobo from the computer so the Kobo can finish updating the database.

Then you have to plug the Kobo back into the computer with Calibre active so it can populate the series. If you've not plugged your Kobo in a second time, your series info won't be there to sort by.
JSWolf is offline   Reply With Quote
Old 12-18-2019, 11:59 AM   #847
retro
Zealot
retro doesn't litterretro doesn't litterretro doesn't litter
 
Posts: 141
Karma: 245
Join Date: Aug 2009
Location: USA
Device: Kobo Clara Blue PRS 350
Quote:
Originally Posted by JSWolf View Post
@retro when you first add books to your Kobo, you have to eject the Kobo from the computer so the Kobo can finish updating the database.

Then you have to plug the Kobo back into the computer with Calibre active so it can populate the series. If you've not plugged your Kobo in a second time, your series info won't be there to sort by.
Yes, my sony is the same. Numerous connects doesn't change the Kobo series sort order under the author sort like sony does.
David and theducks explained that - (thank you, guys!).
retro is offline   Reply With Quote
Old 02-06-2020, 09:08 PM   #848
dcmarquardt
Junior Member
dcmarquardt doesn't litterdcmarquardt doesn't litter
 
dcmarquardt's Avatar
 
Posts: 8
Karma: 130
Join Date: Apr 2011
Device: Kindle
Lightbulb Yes/No Computed Column Based On Single Specific Format

I just wanted to share this here because I spent the last few hours trying to narrow down how to accomplish this...

Background: I recently converted my entire audiobook (multi-mp3 per book) collection into M4B's so that I could manage them with calibre following the "One File Per Book" pattern. (If anyone is interested in a decent way to batch-process that, feel free to PM me)... Once I loaded all of my M4B files into calibre, fixed up all the metadata, etc... it occurred to me that I would create a virtual library called "Audiobooks"... The search expression I used for that is: format:M4B. Easy enough. Now, some of the newly loaded audiobooks that I have, also have various e-book formats (epub, pdf, etc...) that I added to their calibre records for convenience.

Problem: I have a virtual library that shows me all of my audiobooks... that's great, but what if I'm browsing through them and want a specific one to read on my tablet? So I decided to add a custom column that would be called "Audio Only"... basically if the book has only a single format, and that format is equal to "M4B" in my case, then it would show yes, otherwise if there were additional formats available it would show no... or a check/x-mark as it ended up. I'm a software dev, so writing some code isn't anything new, but I was surprised that I couldn't find something out here already to have a simple if... this and this are true ... then 'yes' else 'no' ...

Solution:
I created a custom column template that displays a green check if the book is "Audio Only", and a red X if it has non-audio formats attached to it. Here's how:

Preferences -> Add your own columns -> Add

Lookup Name: onlyaudio
Column Heading: Audio Only
Column Type: Column built from other columns
Show checkmarks: Checked
Template:
Code:
program:cmp(count(template('[[format]]'), ','), 1, 'no', in_list(template('[[format]]'), ',', 'M4B', 'yes', 'no'), 'no')

---

This can be adapted to give you a yes/no column if the book contains only one specific format and no others... just paste that in there and replace the M4B with whatever format you want to single out... if it is the ONLY one present, the column will have a value of yes, otherwise no... you can swap those around as needed also to gain the desired result.

One possible improvement I may work on is in the event I someday store more than a single audio format inside calibre, in which case I would need to go through all of the formats and check them... at that point it becomes more complex because I could potentially have >1 formats but have them all be audio... I'll leave that one for another day.
dcmarquardt is offline   Reply With Quote
Reply

Tags
custom column

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
custom column i need a little help shinken Calibre 3 09-15-2010 04:41 AM
Using Custom Metadata in Save Template EJvdH Calibre 1 07-02-2010 07:06 AM
Accessories Decalgirl Kindle 2 custom skin template srmalloy Amazon Kindle 6 04-09-2010 10:55 PM
Donations for Custom Recipes ddavtian Calibre 5 01-23-2010 05:54 PM
Help understanding custom recipes andersent Calibre 0 12-17-2009 03:37 PM


All times are GMT -4. The time now is 08:57 PM.


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