Thread: Glo Glo Battery Problems
View Single Post
Old 03-16-2013, 08:38 PM   #234
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by Rev. Bob View Post
To chip in my tuppence, as I've just been dealing with moving sets of EPUBs onto my new Glo/2.4.0 - after a fresh load, that section of the Recent Reads order is in straight Z-A order by raw book title, regardless of directory, filename, or opf:file-as metadata. (I say Z-A order because, of course, the Most Recent files are the ones last processed, so the Zs appear at the top of that list.)

Caveat: This is manually loading books onto the internal memory, not using Calibre or other software.
You're right. It looks like there has been a change since the last time I did this. Or at least the last time I paid attention.

I just put my test SD card into the Touch. This card has about 550 fairly random books. They are all either epubs or PDFs. It was populated some time in the past while it was in the Touch using calibre. With a few more added occasionally since. So the path for the books is "{author_sort}/{title} - {authors}". The timestamps on the books and folders are nearly all in five minute range.

My investigations into what shows on the home screen before was that it is based on reading status (unread or being read) and two timestamp columns. These are "DateLastRead" and "___SyncTime". The "DateLastRead" is used if it is set, otherwise it is "___SyncTime". And for a sideloaded book, "___SyncTime" is when the book was processed. As the books have all just been added, only "___SyncTime" is used.

My memory from when I did this before was that the books were listed in the order returned with "ORDER BY ___SyncTime DESC". And because of the way the rows are added to the table, this effectively meant the last five rows in the table that matched the criteria. It looks like this has changed to "ORDER BY ___SyncTime DESC, Title DESC".

The other thing that goes with all this is the order the books are processed in. This isn't important unless there is a book that is breaking the processing and preventing other books being added. I am sure that with firmware 2.0.0, the order was the fully qualified file name, which made finding the bad book fairly easy. But, looking at it now, it definitely isn't. Or at least, that isn't the order that they are put into the database. It is also not file timestamp or any other obvious value.
davidfor is offline   Reply With Quote