![]() |
#46 | |
Member
![]() ![]() Posts: 21
Karma: 128
Join Date: Jan 2020
Device: Kobo Libre2
|
Is there a way to pull a "Name" formatted column into a Column, Built from Other Columns (Behaves like tags)?
My #koboshelves composite column template is Quote:
Right now I created a work around by using Action Chains to manually copy the info from the #characters column into a new plain "Comma separated text" column and pulling THAT into the #koboshelves column, but I'd like to remove that extra step if possible. ETA: And another question! Is there an easy way (preferably using mass edit/search & replace) to take information from the #pairing column (formatted as Character A/Character B) and copy that into a #characters column as Character A & Character B? Last edited by shinykari; 09-03-2023 at 08:04 PM. |
|
![]() |
![]() |
![]() |
#47 | ||
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 11,915
Karma: 7176769
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Quote:
Here is my column definition for the column like your #characters. Here is the template for my composite column Here is the result, shown in the book list. Do note that there can be problems copying data from a 'contains names' column (& separated) to a 'like tags' column (comma separated). If a name contains a comma than it is considered 2 tags. If this is possible then you should use re() to convert the commas into something else, perhaps a semicolon. Also note that the tags in "like tags" composites are sorted. The order won't be the implied order in the template. Quote:
Here is the booklist before running the S&R And after running the S&R |
||
![]() |
![]() |
Advert | |
|
![]() |
#48 | |
Member
![]() ![]() Posts: 21
Karma: 128
Join Date: Jan 2020
Device: Kobo Libre2
|
Quote:
Thank you! I will give this a try. ![]() |
|
![]() |
![]() |
![]() |
#49 |
Member
![]() ![]() Posts: 21
Karma: 128
Join Date: Jan 2020
Device: Kobo Libre2
|
@chaley This worked!!!
![]() ![]() For those who are interested in doing something similar, here's the details: For the Pairing to Characters conversion, I set up an Action Chain exactly as chaley said, so I could run it on the books currently in my library. (New books imported will automatically populate #characters based on that field in FanFicFare.) The #characters column is a Comma Separated Text, like tags, shown in Tag Browser, with the "Names" option checked. For my #koboshelves column, I set up a custom column as a "Column built from other columns, behaves like tags" with the following template: Code:
{#fandom},{#pairing},{#characters:re(&, \,)} |
![]() |
![]() |
![]() |
#50 |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 11,915
Karma: 7176769
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
I strongly suspect that in this case a template search that uses a python template will be faster than the regular search, as long as there aren't any search terms other than the template search. The python template will be pre-compiled then run for each book at python speed instead of GPM speed.
|
![]() |
![]() |
Advert | |
|
![]() |
#51 | |
Zealot
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 112
Karma: 53342
Join Date: Jun 2013
Device: Sony PRS-600
|
Quote:
I've used this format a few times in a library that tracks when a title went into the store, when it was last updated, when I bought it, when I last downloaded it. It's actually not treated as a date, it's just a specifically-formatted string. If they are date fields, you can create a custom column with a template to convert the date to the format above. However, I found (in the version I tried this with) that did some unfortunate things to GUI performance. I instead made it a static string and then updated my scripts to populate both the date fields and the formatted date fields. |
|
![]() |
![]() |
![]() |
#52 |
Leftutti
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 416
Karma: 1153449
Join Date: Feb 2019
Location: Bavaria
Device: iPad Pro, Kobo Libra 2
|
What a happy coincidence!
I just saw @chaley's post in the template language changes thread https://www.mobileread.com/forums/sh...&postcount=124 and thought of the problem I've been having for a few days. How can I bulk add my #dateread entries to a comma separated tag like column in the format yyyy.mm.dd? Some books already have entries, some do not. edit: I just saw it's something similar @kjdavies is talking about ![]() Last edited by Wiggo; 09-17-2023 at 07:12 AM. |
![]() |
![]() |
![]() |
#53 | |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 11,915
Karma: 7176769
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Quote:
|
|
![]() |
![]() |
![]() |
#54 | |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,236
Karma: 63194753
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
Quote:
This lets me store multiple read dates but with only two columns, a date and a taglike. Last edited by ownedbycats; 09-17-2023 at 07:28 AM. |
|
![]() |
![]() |
![]() |
#55 | |
Leftutti
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 416
Karma: 1153449
Join Date: Feb 2019
Location: Bavaria
Device: iPad Pro, Kobo Libra 2
|
Quote:
But I want my "date-tags" hierarchical - yyyy.mm.dd So e.g. a book has the #readdates 2016.12.01, 2023.09.17 But I can't manage to add the last dateread (instead of replace) and make it hierarchical edit: @obc how do you do incrementig the readcount, I'm also to stupid for? Last edited by Wiggo; 09-17-2023 at 07:35 AM. |
|
![]() |
![]() |
![]() |
#56 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,236
Karma: 63194753
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
I think something like this in an Action Chains SFE should work - I'm not on source and can't test at the moment. Run it in the tester first.
Code:
program: list_union(strcat(format_date_field('#lastread', 'yyyy.MM.dd')), $#readdates, ',') Last edited by ownedbycats; 09-17-2023 at 07:48 AM. Reason: forgot some aporstrophes |
![]() |
![]() |
![]() |
#57 |
Leftutti
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 416
Karma: 1153449
Join Date: Feb 2019
Location: Bavaria
Device: iPad Pro, Kobo Libra 2
|
Thanks for this code @obc - I wait for the Calibre update to test it.
I'm very interested in your mark-as-read action chain, would you attach it here, please? |
![]() |
![]() |
![]() |
#58 | |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,236
Karma: 63194753
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
Quote:
|
|
![]() |
![]() |
![]() |
#59 | |
Leftutti
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 416
Karma: 1153449
Join Date: Feb 2019
Location: Bavaria
Device: iPad Pro, Kobo Libra 2
|
Quote:
![]() I‘m looking forward for testing it. ![]() |
|
![]() |
![]() |
![]() |
#60 | |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,236
Karma: 63194753
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
Quote:
Set #lastread. (If you don't use Kobo Utilities, you can just replace this with a predefined value for current datetime.) Code:
program: ## Check Kobo status column. If it's empty, set to current datetime. if $#kobostatus=='' then format_date(today(),'iso') ## If kobostatus is populated, date imports from Kobo Utilities - don't overwrite! else $$#lastread fi Add dnf to admintags: Code:
program: list_union($#admintags, 'dnf', ',') Code:
program: $$#timesread + 1 Code:
program: list_union(strcat(format_date($$#lastread, 'MMM d yyyy')), $#readdates, ',') Last edited by ownedbycats; 09-17-2023 at 09:52 AM. |
|
![]() |
![]() |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Templates: various questions not worth their own thread | ownedbycats | Library Management | 712 | Today 04:17 AM |
Forma Questions about quick management of Collections. | droopy | Kobo Reader | 5 | 10-10-2019 11:34 PM |
2 questions; library management & calibre version | Blue2u | Library Management | 4 | 04-15-2018 07:53 PM |
eBook/Comic/Manga Library Management Workflow: How do you manage your library? | Inukami | Library Management | 16 | 08-02-2017 12:24 PM |
Thread management questions | meme | Feedback | 6 | 01-31-2011 05:07 PM |