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 03-23-2017, 06:00 PM   #1
Rellwood
Library Breeder (She/Her)
Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.
 
Rellwood's Avatar
 
Posts: 1,239
Karma: 1937891
Join Date: Apr 2015
Location: Fullerton, California
Device: Paperwhite 2015 (2), PW 2024 (12 GEN), PW 2023 (11 GEN), Scribe (1st)
Custom Columns Questions

Any ideas on how to create a column that keeps track of changes in other columns? A comment (long text) column that keeps track of each date change in a date column, or tag change in others?

Also, is there a suggestion on how to set up a number column that changes per change in another column?

The primary goal is keeping track of read dates, and times read. I have the "latest read date" column, but as I change from one date to another per read, the previous date is removed and I lose track of both it, and the read count.

Having a column set up to keep track of the dates and having a number column increase with each change would be great. However, it isn't a huge deal for the number column, but having a column in general that keeps a tab of every change in another column whatever it may be (tags, dates, etc.) would really be useful.

Actually, to clarify, I am not looking to keep track of changes per se, but more like keeping all the information available even after it changes. A comma separated column would be great to do as well.

Last edited by Rellwood; 03-23-2017 at 06:02 PM.
Rellwood is offline   Reply With Quote
Old 04-13-2017, 02:26 AM   #2
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: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
I don't know what made me think of this, but it occurs to me, that you might be thinking of this the wrong way around. Or, that it might be easier to do the other way.

Your idea is to have some way were when you change the value in a column, the previous value is appended to the value in another column. But, you can do it the other way without a plugin or other changes to calibre.

If you maintain the column with the list of values, you can have another column that displays the last entry in the list. And as you are interested in the number of times you have read the book, you could have another column that shows the count of the entries.

Another way to do this is via Goodreads. They recently changed things so you could record each time you start and finish a book. Each time you add the book to the "currently-reading" shelf it is marked as started, and when you add it to the "read" shelf it is marked as finished. The Goodreads Sync plugin can do the updating as you go along. Or you can go to Goodreads to record your previous reads.
davidfor is offline   Reply With Quote
Advert
Old 04-14-2017, 03:31 PM   #3
Rellwood
Library Breeder (She/Her)
Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.
 
Rellwood's Avatar
 
Posts: 1,239
Karma: 1937891
Join Date: Apr 2015
Location: Fullerton, California
Device: Paperwhite 2015 (2), PW 2024 (12 GEN), PW 2023 (11 GEN), Scribe (1st)
@davidfor

I never knew that moving a book from the "currently reading" column to the "read" column would change the read count. I always assumed that I had to manually go in and add the extra read dates via edit. I guess this qualifies as one of the new changes you referred to. I tend to just forgo that column all together and just move the book from whatever original column it's in to the read column via Calibre and have the automatically uploaded read date enabled.


I can get the read count in their downloaded csv of my library, but the various dates read per book is not listed. I tend to do a lot of re-reading and it's nice to keep track of each re-read date. But there isn't a sync feature on the plugin that keeps track of each read date, just the "updated" date (which is a really nice feature).

I guess I really need to learn how to create decent custom columns, for the life of me, I cannot get the language. I know there is a way to create a column that keeps track of the changes in others, via appending, but does this work in date columns? Will the changes move to a text column or a tags column? Again, this requires more education.

Thank you so much for giving me more to think about and another way to approach this dilemma!
Rellwood is offline   Reply With Quote
Old 04-14-2017, 10:49 PM   #4
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: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by Rellwood View Post
@davidfor

I never knew that moving a book from the "currently reading" column to the "read" column would change the read count. I always assumed that I had to manually go in and add the extra read dates via edit. I guess this qualifies as one of the new changes you referred to. I tend to just forgo that column all together and just move the book from whatever original column it's in to the read column via Calibre and have the automatically uploaded read date enabled.

I can get the read count in their downloaded csv of my library, but the various dates read per book is not listed. I tend to do a lot of re-reading and it's nice to keep track of each re-read date. But there isn't a sync feature on the plugin that keeps track of each read date, just the "updated" date (which is a really nice feature).
I think these are comments about Goodreads rather than calibre itself. They always had a read count and the start and finish date for the last time you read it. I don't know if they automatically increment the read count as I haven't reread a book since this feature was added.
Quote:
I guess I really need to learn how to create decent custom columns, for the life of me, I cannot get the language. I know there is a way to create a column that keeps track of the changes in others, via appending, but does this work in date columns? Will the changes move to a text column or a tags column? Again, this requires more education.
I don't do enough with the template language to get used to it and have to look it up each time. For the columns, I think you would need to use a text column for the list of dates and just treat them as a text.
davidfor is offline   Reply With Quote
Old 04-14-2017, 11:10 PM   #5
Terisa de morgan
Grand Sorcerer
Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.
 
Terisa de morgan's Avatar
 
Posts: 6,609
Karma: 12595249
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
Quote:
Originally Posted by davidfor View Post
I think these are comments about Goodreads rather than calibre itself. They always had a read count and the start and finish date for the last time you read it. I don't know if they automatically increment the read count as I haven't reread a book since this feature was added.
Yes, they do.
Terisa de morgan is offline   Reply With Quote
Advert
Old 04-30-2017, 03:52 PM   #6
Rellwood
Library Breeder (She/Her)
Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.
 
Rellwood's Avatar
 
Posts: 1,239
Karma: 1937891
Join Date: Apr 2015
Location: Fullerton, California
Device: Paperwhite 2015 (2), PW 2024 (12 GEN), PW 2023 (11 GEN), Scribe (1st)
Quote:
Originally Posted by davidfor View Post
I think these are comments about Goodreads rather than calibre itself. They always had a read count and the start and finish date for the last time you read it. I don't know if they automatically increment the read count as I haven't reread a book since this feature was added.


I don't do enough with the template language to get used to it and have to look it up each time. For the columns, I think you would need to use a text column for the list of dates and just treat them as a text.

I understand that the read count is a Goodreads question. Regarding the template language to treat the date as text, that is what I am trying to do. I am attempting to take a date column already set up (latest date read) and have that data go into another text column that won't erase each time the latest date read column changes. So far the best I can come up with is the column built from other columns but treated like text. I still can't get the dates to stay in that column after changing the original.

Does this make sense?

I simply want a column that keeps track of and doesn't erase data that came from another column. There are no date columns that can be treated like text.

I'll go back to the user manual to see if there is anything in it to help me out.
Rellwood is offline   Reply With Quote
Old 04-30-2017, 05:42 PM   #7
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: 21,662
Karma: 29711016
Join Date: Mar 2012
Location: Sydney Australia
Device: none
@rellwood - maybe this will work.

Add a custom column of type Column built from other columns with a template that formats the date as year, month and day (e.g. 2017-05-01), then in Bulk MDE Search and Replace append that column to a Tag like custom column. Tag like columns can have multiple values, won't allow duplicates, and will display the values in a sensible order.

I'll leave you to work out the custom column template and the Bulk MDE S&R spec (once you have one that works you can save it for later reuse). IIRC the manual has some examples for dealing with dates in templates, and the Mode parameter in Bulk MDE S&R has an Append option.

BR
BetterRed is offline   Reply With Quote
Old 04-30-2017, 06:00 PM   #8
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: 30,944
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
The Template Language has:
format_date(val, format_string) – format the value, which must be a date field, using the format_string, returning a string. The formatting codes are:
YYYY

See https://manual.calibre-ebook.com/template_lang.html
theducks is offline   Reply With Quote
Reply


Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Columns docmartn Library Management 3 08-30-2016 02:18 PM
custom columns from only certain tags areyou Library Management 2 12-15-2012 05:33 AM
Custom Columns - How are you using yours? nynaevelan Library Management 19 04-18-2011 12:42 AM
Custom Columns Question Greg Waddell Calibre 5 03-31-2011 12:34 AM
0.7.46 and custom columns meme Library Management 4 02-21-2011 04:21 AM


All times are GMT -4. The time now is 04:41 PM.


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