Register Guidelines E-Books Today's Posts Search

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

Notices

Reply
 
Thread Tools Search this Thread
Old 09-20-2017, 12:56 PM   #1
BaronKrause
Member
BaronKrause began at the beginning.
 
Posts: 23
Karma: 10
Join Date: Sep 2017
Device: Android
Custom column for "Volume" and "Version" (Revision)

Hello! I use Caliber to manage both my ebooks and manga collection.

Manga and comic titles are usually released as separate chapters either from a magazine release or as part of a larger volume of work. Also often a release will be re released as a "v2" or "v3" indicating something was fixed from the previous.

It would be nice to be able to record that info (and in a way that caliber companion could parse into the file name if desired).

I just made 2 custom columns, 1 called "Volume" and set it to "Floating point numbers" just like how books normal numbering is (in case of some rare instance where there would be an in between standard numbering release) and made another custom column called "Version" and set it to "Integers" so I could select things like 2 or 3, etc.

While both will be parsable in calibre companion with {#volume} and {#version}, if I wanted it to look nice like "v2" at the end of a volume, or something like "Volume 4" somewhere I would need to do "v{#version}" and "Volume {#volume}" and that would leave extra garbage like "v" and "Volume " with no number in the names of all items that have that info undefined (the majority).

Also it seems once you change those values from the default "Undefined" in an item's metadata, you can't go back to Undefined, it will always show that field name and a number under a books details. Typing in "Undefined" again just goes to 0 or 0.00, and shows as such in the books info instead of the default Undefined and not shown. Is there a way to clear those fields, or once changed they are stuck until you delete that column or book?


Is this the most elegant way of doing this? Would it be better to make just 2 Columns called "Volume" and "Version" and set the type to "Long text, like comments, not shown in the Tag browser" (since it would not offer anything useful to be able to see all unrelated books labeled Volume 3 or Version 5) and just type in "Volume 3" or "v5" into the comment of that field if it has one? There doesn't seem to be any issue with clearing it after the fact either. I can also add " {#version}" to the end of the file name in Calibre Companion this way and it will add a v2/3/4, etc to the end with a space before, but if there is no version listed the file name will just end without an additional space, since a file name cannot have spaces after the last character which works out well here.

Last edited by BaronKrause; 09-20-2017 at 01:16 PM.
BaronKrause is offline   Reply With Quote
Old 09-20-2017, 05:56 PM   #2
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 20,565
Karma: 26954694
Join Date: Mar 2012
Location: Sydney Australia
Device: none
@Baron Krause - individual ints and floats can be reset to 'Undefined' in the book list by the selecting cell, pressing F2 to get into Edit mode, then Space, then Enter. That also works in the Metadata edit dialogues.

BR
BetterRed is offline   Reply With Quote
Advert
Old 09-23-2017, 11:33 AM   #3
Nicolas F
Groupie
Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.
 
Posts: 161
Karma: 1842
Join Date: Jan 2016
Device: Kobo Glo HD
Quote:
Originally Posted by BaronKrause View Post
I just made 2 custom columns, 1 called "Volume" and set it to "Floating point numbers" just like how books normal numbering is (in case of some rare instance where there would be an in between standard numbering release) and made another custom column called "Version" and set it to "Integers" so I could select things like 2 or 3, etc.

While both will be parsable in calibre companion with {#volume} and {#version}, if I wanted it to look nice like "v2" at the end of a volume, or something like "Volume 4" somewhere I would need to do "v{#version}" and "Volume {#volume}" and that would leave extra garbage like "v" and "Volume " with no number in the names of all items that have that info undefined (the majority).
Calibre allows you to format the number has you want when you create a custom column.
So in the edit custom column dialog, in format for numbers you could enter:
  • for the "Version" column (integers):
    Code:
    v {0:d}
  • for the "Volume" column (Floating point numbers):
    Code:
    Volume {:.2f}
where {0:d} represents your integers and {:.2f} is a number with two digits after the point. Just put what you want before (v, volume, version...)
Nicolas F is offline   Reply With Quote
Old 09-23-2017, 01:33 PM   #4
BaronKrause
Member
BaronKrause began at the beginning.
 
Posts: 23
Karma: 10
Join Date: Sep 2017
Device: Android
Quote:
Originally Posted by Nicolas F View Post
Calibre allows you to format the number has you want when you create a custom column.
So in the edit custom column dialog, in format for numbers you could enter:
  • for the "Version" column (integers):
    Code:
    v {0:d}
  • for the "Volume" column (Floating point numbers):
    Code:
    Volume {:.2f}
where {0:d} represents your integers and {:.2f} is a number with two digits after the point. Just put what you want before (v, volume, version...)
Oh man that would've been so cool. I just tested it and it with an Integer set as v{0:d} to create a number that looks like "v2" for instance and it worked, but when I use that field in Calibre Companion's custom naming template, it only shows the number. I'm assuming the custom number formatting is just a change to how that number is displayed locally.

For now it seems i'm sticking with a Version column set to a Long comment like text field, and just type in things like "v2" so that way Calibre Companion will show that at the end of a file name when formatted with " {#version}" at the end of the template (If I were to use v{#version} in CC's text field, if there isn't a version number, it would still show a space followed by a "v" with no number at the end of every file).

Much rather do an Integer (or even floating point, though it would be wasted for this field) but the way its displayed is the most important thing about this one as I really would never need to sort by revisions of various community translated works.

Last edited by BaronKrause; 09-23-2017 at 01:38 PM.
BaronKrause is offline   Reply With Quote
Old 09-24-2017, 03:53 AM   #5
Nicolas F
Groupie
Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.
 
Posts: 161
Karma: 1842
Join Date: Jan 2016
Device: Kobo Glo HD
Quote:
Originally Posted by BaronKrause View Post
Oh man that would've been so cool. I just tested it and it with an Integer set as v{0:d} to create a number that looks like "v2" for instance and it worked, but when I use that field in Calibre Companion's custom naming template, it only shows the number. I'm assuming the custom number formatting is just a change to how that number is displayed locally.

For now it seems i'm sticking with a Version column set to a Long comment like text field, and just type in things like "v2" so that way Calibre Companion will show that at the end of a file name when formatted with " {#version}" at the end of the template (If I were to use v{#version} in CC's text field, if there isn't a version number, it would still show a space followed by a "v" with no number at the end of every file).

Much rather do an Integer (or even floating point, though it would be wasted for this field) but the way its displayed is the most important thing about this one as I really would never need to sort by revisions of various community translated works.
Ah, too bad. I don't use Calibre Companion so I didn't know.

One thing you could do that may be easier to use is using a column of type "text, but with a fixed set of permitted values" and use
Code:
v1,v2,v3
as values for example
This way you type it only once and the next time you only have to select the value you want.

And this way you can even sort ( even if it's useless!)

Last edited by Nicolas F; 09-24-2017 at 10:17 AM. Reason: code correction
Nicolas F is offline   Reply With Quote
Advert
Old 09-24-2017, 06:44 AM   #6
BaronKrause
Member
BaronKrause began at the beginning.
 
Posts: 23
Karma: 10
Join Date: Sep 2017
Device: Android
Ahh very cool I might try that! Can you alter the fixed permitted values after the fact (in case I get some version with a crazy high revision number) or do I need to plan it out entirely on creation of the column?
BaronKrause is offline   Reply With Quote
Old 09-24-2017, 10:17 AM   #7
Nicolas F
Groupie
Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.Nicolas F once ate a cherry pie in a record 7 seconds.
 
Posts: 161
Karma: 1842
Join Date: Jan 2016
Device: Kobo Glo HD
Yes you can change it later. And apparently you don't need to add the space value, a blank one is added automatically.
Nicolas F is offline   Reply With Quote
Old 11-01-2017, 04:25 PM   #8
MarjaE
Guru
MarjaE ought to be getting tired of karma fortunes by now.MarjaE ought to be getting tired of karma fortunes by now.MarjaE ought to be getting tired of karma fortunes by now.MarjaE ought to be getting tired of karma fortunes by now.MarjaE ought to be getting tired of karma fortunes by now.MarjaE ought to be getting tired of karma fortunes by now.MarjaE ought to be getting tired of karma fortunes by now.MarjaE ought to be getting tired of karma fortunes by now.MarjaE ought to be getting tired of karma fortunes by now.MarjaE ought to be getting tired of karma fortunes by now.MarjaE ought to be getting tired of karma fortunes by now.
 
Posts: 924
Karma: 53902736
Join Date: Jun 2015
Device: multiple
I'm running into a similar problem with other multi-volume works.

My first reaction was a volume column, but my second is a "full title" column, where I can use an abridged title in the "title" column. When browsing Calibre, the volume number wouldn't be hidden, and when exporting, the title and file path wouldn't be truncated.
MarjaE is offline   Reply With Quote
Old 11-01-2017, 04:36 PM   #9
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: 29,798
Karma: 54830978
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Make use of a builtin behavior of Calibre:
title: the title (v1)
title_sort (standard Generated): title, the

Notice what did not get Auto moved to title sort when you click the copy icon
theducks is online now   Reply With Quote
Old 11-02-2017, 08:22 PM   #10
MarjaE
Guru
MarjaE ought to be getting tired of karma fortunes by now.MarjaE ought to be getting tired of karma fortunes by now.MarjaE ought to be getting tired of karma fortunes by now.MarjaE ought to be getting tired of karma fortunes by now.MarjaE ought to be getting tired of karma fortunes by now.MarjaE ought to be getting tired of karma fortunes by now.MarjaE ought to be getting tired of karma fortunes by now.MarjaE ought to be getting tired of karma fortunes by now.MarjaE ought to be getting tired of karma fortunes by now.MarjaE ought to be getting tired of karma fortunes by now.MarjaE ought to be getting tired of karma fortunes by now.
 
Posts: 924
Karma: 53902736
Join Date: Jun 2015
Device: multiple
The volume number, which both of us were trying to make more visible, not less.
MarjaE is offline   Reply With Quote
Old 11-02-2017, 09:20 PM   #11
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: 29,798
Karma: 54830978
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by MarjaE View Post
The volume number, which both of us were trying to make more visible, not less.
Ah! Then A custom column is the way. The Template language does support custom columns
theducks is online now   Reply With Quote
Reply


Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom column: "pubdate" and "ifempty" StillReading Library Management 3 04-07-2015 01:04 AM
Custom column: "Updated date", when adding new "versions" of the same file? enriquep Library Management 16 11-03-2011 10:46 AM


All times are GMT -4. The time now is 05:18 PM.


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