Yesterday, 04:27 PM | #1 |
Connoisseur
Posts: 77
Karma: 10
Join Date: Sep 2016
Device: Kindle
|
calibredb to get last_modified data
I'm picking back up a project from a few years ago:
https://www.mobileread.com/forums/sh...d.php?t=338741 I got most of my libraries merged but I never got around to cleaning up the extra backup libraries. I can Import the old backups with no problem. Calibre shows all of the timestamps I would expect to see for the dates of the imported library. But it turns out when I tried creating a custom column, Calibre immediately updates the last_modified column to today's date. I want to keep a history of what the last_modified column contains prior to making any changes on a newly imported Library so that in the future I can figure out when a book was merged from another library and when. Otw, I'm using calibredb to get the data and will create a small database to track changes there. Does anyone know if any of the plugins do something like this already? It seems unlikely, but figured I'd ask. For each library directory (not the backup data directories) Code:
calibredb list --with-library "C:\Calibre Library\Old Libraries\<library>" --f title,author,last_modified,timestamp > ".\<library>_premerge_dates.csv" |
Yesterday, 06:24 PM | #2 | |
null operator (he/him)
Posts: 20,752
Karma: 27405072
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
Quote:
BR |
|
Advert | |
|
Tags |
calibredb, dates, list, tracking |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Failed to Export Data - Invalid Argument Error When Exporting Data | zakropotch | Calibre | 6 | 06-18-2022 06:09 PM |
matching last_modified with file date modified? | jiembe | Library Management | 4 | 11-08-2020 08:10 AM |
Cannot modify selected data within Export Calibre data | Pholipe | Library Management | 1 | 09-05-2019 11:34 AM |
Last_modified= 766 books today | theducks | Library Management | 21 | 01-16-2014 11:57 AM |