Metadata Plugboards and "On Device"

[kranu]

Hi guys,

I'm using a Metadata Plugboard that I found on this thread:

Originally Posted by kovidgoyal

General Metadata

Metadata: Put series into the title, using either initials or a shortened form. Strip leading articles from the series name (any) (inspired by Gary_M_Mugford)

Spoiler:

The solution requires creating three composite columns. The first column is used to remove the leading articles. The second is used to compute the 'shorten' form. The third is to compute the 'initials' form. Once you have these columns, the plugboard selects between them. You can hide any or all of the three columns on the library view.

First column:
Code:
Name: #stripped_series. Template: {series:re(^(A|The|An)\s+,)||}
Second column (the shortened form):
Code:
Name: #shortened. Template: {#stripped_series:shorten(4,-,4)}
Third column (the initials form):
Code:
Name: #initials. Template: {#stripped_series:re(([^\s])[^\s]+(\s|$),\1)}
Plugboard expression:
Code:
Template:{#stripped_series:lookup(.\s,#initials,., #shortened,series)}{series_index:0>2s| [|] }{title}
Destination field: title
This set of fields and plugboard produces:
Series: The Lord of the Rings
Series index: 2
Title: The Two Towers
Output: LotR [02] The Two Towers

Series: Dahak
Series index: 1
Title: Mutineers Moon
Output: Dahak [01] Mutineers Moon

Series: Berserkers
Series Index: 4
Title: Berserker Throne
Output: Bers-kers [04] Berserker Throne

Series: Meg Langslow Mysteries
Series Index: 3
Title: Revenge of the Wrought-Iron Flamingos
Output: MLM [03] Revenge of the Wrought-Iron Flamingos

It inserts the Series name and number in the title of the book. When I plug in my Kindle, the "Send to Device" button works fine, but for books with series metadata, the column to the left does not show a checkmark after the file is sent.

I'm guessing that this is because the title is changed, since when I load books without series onto my Kindle, the checkmark appears as expected. Is there anyway to fix this?

Update: I've attached a screenshot of two books. The first one has the series information appended to the beginning of the title, so the checkmark is missing. The second book is not tagged as part of a series, so it has the checkmark as expected. Also in the image, you can see that the book is indeed in the library, but does not show up as "On Device"



Thanks,
Kranu

[DoctorOhh]

Originally Posted by kranu

I'm guessing that this is because the title is changed, since when I load books without series onto my Kindle, the checkmark appears as expected. Is there anyway to fix this?

I use the exact same setup, but with a Sony and I don't have this problem. Hopefully someone in the know will have the answer to your question.

[atjnjk]

As I remembered, after upgrading to the version which introduced "Modified Date" column and drive info file (version 0.7.48?), calibre doesn't recognize (means no "On Device" check) books sent before upgrading with title changed by metadata plugboard (added series & authors). I guess you should resend those books (I didn't resend mine because I use a manual check column to control what was sent).