Strange issue with date sorting - CC thinks nobody reads books after midday?
#1  vikarti 12-26-2019, 01:24 PM
Configuration (I try to list everything that could be important):
Calibre 4.6 on macOS Mojave. Russian locale.
Galaxy Note 9 with Russian locale.
CC version (391). Automatically switched to Russian language.

Sync column for Date Read: #dateread , this column defined as dd MMM yyyy hh:mm:ss (not default dd MMM yyy)

#dateread is also being used as grouping/sorting column sometimes.

Here lies problem:

I configure calibre to sort by #dateread, first book
Calibre sees: 26 дек 2019 23:22:24 ("дек" is correct abbrev. for December, no issues here)
but connected CC sees 26 Dec 2019 11:22:42 and it's not first book in CC (book with #dateread 26 Dec 2019 5:12:49 (per CC) (26 дек 2019 17:12:49 per Calibre) is before. And so on.
So sorting in Calibre and CC appears to differ if date column value is in 12-24 hours (and not 0-11) range.

Changing #dateread format in Calibre to dd MMM yyyy hh:mm:ss AP messes up CC's parser and it stars to show up datetimes in iso format but with +0 offset.

Changing #dateread format in Calibre to dd-MM-yyyy hh:mm:ss so Calibre now shows 26-12-2019 23:22:42 as date results in same issue except that CC shows 26-12-2019 11:22:42 )

How to make CC correctly show books I read after midday as such?

restored format to dd MMM yyyy hh:mm:ss
Read another book in CC (and Moon+) and synced. Calibre's #dateread column now shows 27 Дек 2019 00:29:43, CC shows 27/Dec/2019 12:29:43 (Opened (CC) shows 27 Dec 2019 12:30 AM which at least clear that we are speaking about AM/PM here)
upd: (392) from (and not Play Store) works exactly same in this regard

#2  vikarti 12-31-2019, 01:45 AM
It was ... slightly counterintuitive but for this setup to work it's better (in addition to regular #dateread sorting setup) to choose Date Read (CC) as sort column, not custom #datteread.

Appears to work great even when multiple devices syncs to Calibre(it appears that Date Read (CC) is synced to my #dateread column on all devices).

Multi-device sync via Calibre was reason for all of this in first place.

#3  Josieb1 01-02-2020, 09:41 AM
The new app developer doesn’t seem to care. The app is a joke now.

#4  stumped 01-02-2020, 09:47 AM
Quote Josieb1
The new app developer doesnÂ’t seem to care. The app is a joke now.
but would delete the words " seem to", for improved accuracy

he also seems to have forgotten how to apologise for ongoing bugs, missed targets....

#5  vikarti 01-02-2020, 11:00 AM
I (arleady) have read iOS thread at this time . CC looked very good and I thought I made big mistake by not checking hybrid setup (CC + Moon+ + Samsung DeX). Now I'm sad. I hope it works at least until promised Bookfusion 's android app redesign.

Today's Posts | Search this Thread | Login | Register