![]() |
#1 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,163
Karma: 62872439
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
Library Management: various questions not worth their own thread
Hopefully this'll cut down on people posting small questions in the template question thread
![]() Question: Why do author-type columns use a different separator (ampersand '&' instead of comma ',')? |
![]() |
![]() |
![]() |
#2 |
creator of calibre
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 44,256
Karma: 23661992
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
|
commas are used for sort names. Like Cats, Owned by
|
![]() |
![]() |
Advert | |
|
![]() |
#3 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,163
Karma: 62872439
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
I forgot about the sort. That makes sense!
|
![]() |
![]() |
![]() |
#4 |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 11,903
Karma: 7076137
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Also commas appear in names with degrees or tities, such as Joe Bloggs, PhD. Some people put them in names with suffixes such as Jr, Second, etc., as in Joe Bloggs, II.
|
![]() |
![]() |
![]() |
#5 |
the rook, bossing Never.
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 12,230
Karma: 89531599
Join Date: Jun 2017
Location: Ireland
Device: All 4 Kinds: epub eink, Kindle, android eink, NxtPaper11
|
|
![]() |
![]() |
Advert | |
|
![]() |
#6 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,163
Karma: 62872439
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
Question: Is the lookup name for the 'Date' column date or timestamp?
I see 'date' in the column header tooltip, and 'timestamp' in Preferences > Add Your Own Column. |
![]() |
![]() |
![]() |
#7 | |
want to learn what I want
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 1,089
Karma: 6425162
Join Date: Sep 2020
Device: Calibre E-book viewer
|
Quote:
some plugins use 'timestamp' to refer to the date column, like JS "Visualize Metadata" tool |
|
![]() |
![]() |
![]() |
#8 |
Connoisseur
![]() Posts: 87
Karma: 10
Join Date: Sep 2018
Device: iPad mini
|
Is there a way to delete all or batch delete in columns that are textboxes like comments, or IDs?
I’m redoing my BookFusion catalog so I want to clear the old ids, and also accidentally sent the wrong information to a column using fanficfare , and I’ve got it all fixed but I just need to delete the errors |
![]() |
![]() |
![]() |
#9 | |
Zealot
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 116
Karma: 295672
Join Date: Jul 2021
Device: iPhone
|
Quote:
|
|
![]() |
![]() |
![]() |
#10 | |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 11,903
Karma: 7076137
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Quote:
As for searching, the only acceptable value is "date". Below is the "field metadata" that shows most of what calibre knows about the field. Code:
('timestamp', {'table':None, 'column':None, 'datatype':'datetime', 'is_multiple':{}, 'kind':'field', 'name':_('Date'), 'search_terms':['date'], 'is_custom':False, 'is_category':False, 'is_csp': False}), |
|
![]() |
![]() |
![]() |
#11 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,163
Karma: 62872439
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
Is it possible to display a composite column as a list rather than comma-separated?
|
![]() |
![]() |
![]() |
#12 |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 11,903
Karma: 7076137
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
|
![]() |
![]() |
![]() |
#13 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,163
Karma: 62872439
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
Sorry, I meant a bulleted list. I thought I saw a screenshot of one before, but maybe that was just a regular longtext column.
|
![]() |
![]() |
![]() |
#14 | |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 11,903
Karma: 7076137
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Quote:
What I would consider is making a contains-html text column that reformats the list with bullets then show that in book details. Up to you whether you show the original in book details. This wouldn't have impact on performance because the new composite would be evaluated only when the book's details are shown. |
|
![]() |
![]() |
![]() |
#15 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,163
Karma: 62872439
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
For this specific case, I have a column, #readdates, which stores multiple dates, and a composite column to sort them.
Is there a better way to store multiple dates? In a regular tag column, 'Aug 12 2023' sorts alphabetically. |
![]() |
![]() |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Templates: various questions not worth their own thread | ownedbycats | Library Management | 705 | 07-27-2024 03:29 PM |
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 |