Library Management: various questions not worth their own thread - Page 2

Comfy.n · 08-12-2023, 11:08 PM

Quote:

Originally Posted by ownedbycats

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.

wow, I like this..

theducks · 08-12-2023, 11:14 PM

ISO date: (Text) is YYYY MM DD because that sorts. You can't use Mon and have it sort

ownedbycats · 08-13-2023, 12:52 AM

Additional question: I changed one of my saved searches to account for my multi-date column:

Code:

#readdates:"2020"
AND #percentread:=100
AND NOT #fanficstatus:"~(In-Progress|Dormant|Oneshot)"

The first line is also picking up "Jun 20 2021". What should I do?

JSWolf · 08-13-2023, 04:28 AM

Quote:

Originally Posted by ownedbycats

Additional question: I changed one of my saved searches to account for my multi-date column:

Code:

#readdates:"2020"
AND #percentread:=100
AND NOT #fanficstatus:"~(In-Progress|Dormant|Oneshot)"

The first line is also picking up "Jun 20 2021". What should I do?

Change the day to 19 or 21?

BetterRed · 08-13-2023, 05:18 AM

I have a quasi multi-value date column, its a 'Comma separated text, like tags, shown in the Tag browser' column. I fill it with ISO dates as strings i.e. 2021-05-17, 2023-08-13.

Book details shows values on separate lines… oldest to newest.

Any ideas for showing a newest to oldest list, would save me having to find my upside down specs

BR

Wiggo · 08-13-2023, 05:59 AM

If you place periods "." instead of dashes "-" wouldn't you get hierarchical tags by year-month-day? So your tag list wouldn't be so cluttered?

ownedbycats · 08-13-2023, 06:09 AM

Quote:

Originally Posted by JSWolf

Change the day to 19 or 21?

Really?

Quote:

Originally Posted by Wiggo

If you place periods "." instead of dashes "-" wouldn't you get hierarchical tags by year-month-day? So your tag list wouldn't be so cluttered?

You only get hierarchical tags if specifically enabled on that column.

BetterRed · 08-13-2023, 06:17 AM

Quote:

Originally Posted by Wiggo

If you place periods "." instead of dashes "-" wouldn't you get hierarchical tags by year-month-day? So your tag list wouldn't be so cluttered?

If you're responding to my post, where did I say or imply anything was cluttered.

Added: I hide the column in question in the Tag browser.

BR

Wiggo · 08-13-2023, 06:22 AM

nowhere. I say it is cluttered

Quoth · 08-13-2023, 07:38 AM

Quote:

Originally Posted by ownedbycats

Additional question: I changed one of my saved searches to account for my multi-date column:

Code:

#readdates:"2020"
AND #percentread:=100
AND NOT #fanficstatus:"~(In-Progress|Dormant|Oneshot)"

The first line is also picking up "Jun 20 2021". What should I do?

Don't use USA format

ownedbycats · 08-13-2023, 02:57 PM

I figured it out. Using the pointy '^' for ignoring character variants also works for spaces.

Quoth · 08-13-2023, 03:32 PM

Carat, or a circumflex when it's ô û â etc

Glad you sorted

However, the USA data format is the worst. ISO yyyy mm dd (with leading zeroes, use no spacing or -, but never : or /) is best, no ambiguity in different countries, or needing english (Three letter mmm is bad), and it sorts easily.

ownedbycats · 08-13-2023, 03:42 PM

I've used ISO format for years.

Unfortunately, recently I've started misreading "2020-08-12" for December 8 rather than August 12. Hence why I'm using a format with a bit less ambiguity.

This is intended for display only in the book details (not tag browser or book list) so sorting is less of an issue, as long as they appear in chronological order in the list.

BetterRed · 08-13-2023, 07:57 PM

Quote:

Originally Posted by Quoth

Carat, or a circumflex when it's ô û â etc

Carat is a unit of mass, the name of the '^' character is caret, I call it a 'hat'.

chaley · 08-14-2023, 05:46 AM

Quote:

Originally Posted by ownedbycats

I've used ISO format for years.

Unfortunately, recently I've started misreading "2020-08-12" for December 8 rather than August 12. Hence why I'm using a format with a bit less ambiguity.

This is intended for display only in the book details (not tag browser or book list) so sorting is less of an issue, as long as they appear in chronological order in the list.

Store it as "yyyy-mm-dd (month)"? as in "2023-08-14 (Aug)"? That will sort and have less ambiguity.

08-13-2023, 12:52 AM	#18
ownedbycats Custom User Title Posts: 8,639 Karma: 61234567 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	Additional question: I changed one of my saved searches to account for my multi-date column: Code: #readdates:"2020" AND #percentread:=100 AND NOT #fanficstatus:"~(In-Progress\|Dormant\|Oneshot)" The first line is also picking up "Jun 20 2021". What should I do?

08-13-2023, 03:42 PM	#28
ownedbycats Custom User Title Posts: 8,639 Karma: 61234567 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	I've used ISO format for years. Unfortunately, recently I've started misreading "2020-08-12" for December 8 rather than August 12. Hence why I'm using a format with a bit less ambiguity. This is intended for display only in the book details (not tag browser or book list) so sorting is less of an issue, as long as they appear in chronological order in the list. Last edited by ownedbycats; 08-13-2023 at 03:45 PM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Templates: various questions not worth their own thread	ownedbycats	Library Management	662	03-23-2024 01:20 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

08-12-2023, 11:14 PM	#17
theducks Well trained by Cats Posts: 29,809 Karma: 54830978 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	ISO date: (Text) is YYYY MM DD because that sorts. You can't use Mon and have it sort

08-13-2023, 05:18 AM	#20
BetterRed null operator (he/him) Posts: 20,575 Karma: 26954694 Join Date: Mar 2012 Location: Sydney Australia Device: none	I have a quasi multi-value date column, its a 'Comma separated text, like tags, shown in the Tag browser' column. I fill it with ISO dates as strings i.e. 2021-05-17, 2023-08-13. Book details shows values on separate lines… oldest to newest. Any ideas for showing a newest to oldest list, would save me having to find my upside down specs BR

08-13-2023, 05:59 AM	#21
Wiggo Leftutti Posts: 400 Karma: 1121267 Join Date: Feb 2019 Location: Bavaria Device: iPad Pro, Kobo Libra 2	If you place periods "." instead of dashes "-" wouldn't you get hierarchical tags by year-month-day? So your tag list wouldn't be so cluttered?

08-13-2023, 06:22 AM	#24
Wiggo Leftutti Posts: 400 Karma: 1121267 Join Date: Feb 2019 Location: Bavaria Device: iPad Pro, Kobo Libra 2	nowhere. I say it is cluttered

08-13-2023, 02:57 PM	#26
ownedbycats Custom User Title Posts: 8,639 Karma: 61234567 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	I figured it out. Using the pointy '^' for ignoring character variants also works for spaces.

08-13-2023, 03:32 PM	#27
Quoth the rook, bossing Never. Posts: 11,163 Karma: 85874891 Join Date: Jun 2017 Location: Ireland Device: All 4 Kinds: epub eink, Kindle, android eink, NxtPaper11	Carat, or a circumflex when it's ô û â etc Glad you sorted However, the USA data format is the worst. ISO yyyy mm dd (with leading zeroes, use no spacing or -, but never : or /) is best, no ambiguity in different countries, or needing english (Three letter mmm is bad), and it sorts easily.

Advert

Advert