Mobileread
Strange issue with date sorting - CC thinks nobody reads books after midday?
#1  vikarti 12-26-2019, 02: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 5.4.3.3 (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?

upd:
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:
5.4.4.1 (392) from http://charles.the-haleys.org/CC_Updates/ (and not Play Store) works exactly same in this regard
Reply 

#2  vikarti 12-31-2019, 02: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.
Reply 

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

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

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

#5  vikarti 01-02-2020, 12:00 PM
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.
Reply 

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