Programmatically set date added to calibre

bob.f · 12-24-2017, 05:29 AM

Hi. I have recently added my kindle collection of around 2000 books to calibre. One piece of information that I have lost in doing so is the purchased date. In other words, on my kindle I could sort by recent date and get, more or less, my collection sorted by oldest to most recent purchase.

What I am wondering is whether there is a way to programmatically set the date added to calibre field. Perhaps via some sort of script? I don't want to have to do this manually but could probably cope with sourcing the dates and copying them to a batch routine.

I have come across the catalog and ebook-meta commands but I haven't put all the pieces together yet.

theducks · 12-24-2017, 10:05 AM

Recent date on the K4, is the date last accessed, not added.
My Kindle Content (your account) has acquisition information, but lacks the ASIN to help match

kovidgoyal · 12-26-2017, 09:05 PM

You can set any field int he calirbe database via the calibredb command line tool. https://manual.calibre-ebook.com/gen...calibredb.html

bob.f · 12-29-2017, 07:59 AM

Quote:

Originally Posted by kovidgoyal

You can set any field int he calirbe database via the calibredb command line tool. https://manual.calibre-ebook.com/gen...calibredb.html

That will do nicely, thank you.

BetterRed · 12-29-2017, 04:01 PM

@bob.f - this is an alternative to using calibredb in a script

If you can wrangle the book title, author and purchase date into a csv file, you should be able to use the Import List plugin to update a purchase date custom column.

BR

12-24-2017, 05:29 AM	#1
bob.f Connoisseur Posts: 76 Karma: 99068 Join Date: Nov 2017 Device: N/A	Programmatically set date added to calibre Hi. I have recently added my kindle collection of around 2000 books to calibre. One piece of information that I have lost in doing so is the purchased date. In other words, on my kindle I could sort by recent date and get, more or less, my collection sorted by oldest to most recent purchase. What I am wondering is whether there is a way to programmatically set the date added to calibre field. Perhaps via some sort of script? I don't want to have to do this manually but could probably cope with sourcing the dates and copying them to a batch routine. I have come across the catalog and ebook-meta commands but I haven't put all the pieces together yet.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calibre not sorting books by date added	pinky62	Library Management	2	09-12-2017 07:50 PM
Custom columns not being set when adding books programmatically	Howlingwolf	Development	4	12-10-2014 07:45 AM
PRS-T2 Lost 'date added' after a calibre transfer	Gozer404	Sony Reader	5	11-11-2013 01:01 PM
Date Added column? Can I set date when book added to library?	fitzhugh	Calibre	4	06-03-2012 05:42 PM
Date Added vs. Date Modified	aglaia761	Calibre	5	11-28-2010 05:34 AM

12-24-2017, 10:05 AM	#2
theducks Well trained by Cats Posts: 31,001 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Recent date on the K4, is the date last accessed, not added. My Kindle Content (your account) has acquisition information, but lacks the ASIN to help match

12-26-2017, 09:05 PM	#3
kovidgoyal creator of calibre Posts: 45,299 Karma: 27111240 Join Date: Oct 2006 Location: Mumbai, India Device: Various	You can set any field int he calirbe database via the calibredb command line tool. https://manual.calibre-ebook.com/gen...calibredb.html

12-29-2017, 04:01 PM	#5
BetterRed null operator (he/him) Posts: 21,693 Karma: 29711016 Join Date: Mar 2012 Location: Sydney Australia Device: none	@bob.f - this is an alternative to using calibredb in a script If you can wrangle the book title, author and purchase date into a csv file, you should be able to use the Import List plugin to update a purchase date custom column. BR

Advert

Advert