07-10-2024, 04:27 PM | #1 |
Connoisseur
Posts: 86
Karma: 38050
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" |
07-10-2024, 06:24 PM | #2 | |
null operator (he/him)
Posts: 20,981
Karma: 27620706
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
Quote:
BR |
|
Advert | |
|
07-11-2024, 04:00 AM | #3 |
want to learn what I want
Posts: 1,243
Karma: 6426810
Join Date: Sep 2020
Device: Calibre E-book viewer
|
Last Modified may be helpful
|
07-12-2024, 02:07 PM | #4 | |
Connoisseur
Posts: 86
Karma: 38050
Join Date: Sep 2016
Device: Kindle
|
Quote:
For the short term, I'm going to start by making a complete CSV file for each library that contains all the preexisting data, then add a #custom_last_modified column to each library. At that point, I'll have to probably write a script to to fill in the #custom_last_modified data using calibredb and the CSV file data. If I get really ambitious, I might add some other columns like #last_merged and #last_library that get filled in by a Template function. Considering the number of old libraries and backups, maybe a small database to track data changes would be more useful. Getting into the project-creep at this point. Otherwise, thanks for the pointers!! |
|
07-12-2024, 03:46 PM | #5 |
Bibliophagist
Posts: 40,353
Karma: 156982136
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
|
You could use Job Spy to backup the last modified date and then restore it after you have made the changes such as adding a custom date column.
|
Advert | |
|
07-13-2024, 05:44 AM | #6 | |
Connoisseur
Posts: 86
Karma: 38050
Join Date: Sep 2016
Device: Kindle
|
Create a column to record the pre-merge Last Modified date
Quote:
1. Order of steps matters. 2. Do NOT add a new column until after you've installed Job Spy and backed up the last_modified column. 3. Choose the target library. Verify the last_modified dates are correct. 4. Backup the Last-modified dates with the JS+ plugin: Tools that are Metadata Related > Backup/Restore Last-Modified Dates > Backup Last-modified dates 5. Add a custom column through Preferences > Add a Column. Choose Type: Long Text. Restart Calibre. 6. Restore the Last-modified dates with the JS+ plugin: Tools that are Metadata Related > Backup/Restore Last-Modified Dates > Restore Last-modified dates 7. Select all books (ie, Ctrl+A on Windows). Hit 'E' for a bulk edit. 8. On the Seach and Replace tab: Search mode: Regular Expression
Search field: last_modified Search for: () Replace with: \1 Destination field: #your_custom_column Save the search, for instance: "Copy Last Modified Click 'Apply' or 'Ok' Last edited by meghane_e; 07-13-2024 at 12:10 PM. Reason: formatting |
|
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 |