Thread: PRS-T2 Lost 'date added' after a calibre transfer
View Single Post
Old 11-01-2013, 02:17 PM   #5
ebmr
Zealot
ebmr is out to avenge the death of his or her father, Domingo Montoya.ebmr is out to avenge the death of his or her father, Domingo Montoya.ebmr is out to avenge the death of his or her father, Domingo Montoya.ebmr is out to avenge the death of his or her father, Domingo Montoya.ebmr is out to avenge the death of his or her father, Domingo Montoya.ebmr is out to avenge the death of his or her father, Domingo Montoya.ebmr is out to avenge the death of his or her father, Domingo Montoya.ebmr is out to avenge the death of his or her father, Domingo Montoya.ebmr is out to avenge the death of his or her father, Domingo Montoya.ebmr is out to avenge the death of his or her father, Domingo Montoya.ebmr is out to avenge the death of his or her father, Domingo Montoya.
 
Posts: 101
Karma: 34554
Join Date: Aug 2012
Device: none
Well, the single steps for a distinct book named book.epub are:
  • Get the date for book.epub, let's say 2010-05-01 14:10:00.
  • Convert the date into seconds since 1970-01-01 00:00:00 UTC by (e.g.)
    Code:
    date --date="2010-05-01 14:10:00" +"%s"
  • Add 000 to the result and get 1272715800000.
  • Perform SQL on books.db:
    Code:
    update books set added_date=1272715800000 where file_name=book.epub;
Try to make that a batch and backup your database before.
ebmr is offline   Reply With Quote