Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre

Notices

Reply
 
Thread Tools Search this Thread
Old 10-06-2011, 07:19 AM   #1
iomari
Zealot
iomari doesn't litteriomari doesn't litter
 
iomari's Avatar
 
Posts: 134
Karma: 100
Join Date: Aug 2003
Location: Nigeria
Device: galaxy tab
date field

greetings,

is there some hidden field that stores the date a book was entered into the database? I would like to bring that out to the front end.
iomari is offline   Reply With Quote
Old 10-06-2011, 07:24 AM   #2
iomari
Zealot
iomari doesn't litteriomari doesn't litter
 
iomari's Avatar
 
Posts: 134
Karma: 100
Join Date: Aug 2003
Location: Nigeria
Device: galaxy tab
nevermind. I've seen the timestamp field in the database. :-)
iomari is offline   Reply With Quote
 
Advertisement
Old 10-06-2011, 07:52 AM   #3
iomari
Zealot
iomari doesn't litteriomari doesn't litter
 
iomari's Avatar
 
Posts: 134
Karma: 100
Join Date: Aug 2003
Location: Nigeria
Device: galaxy tab
Can someone give me a hint how to add the timestamp field as a custom column?
I can't seem to find the right function to use for the template.
iomari is offline   Reply With Quote
Old 10-06-2011, 07:57 AM   #4
DoctorOhh
US Navy, Retired
DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.
 
DoctorOhh's Avatar
 
Posts: 8,909
Karma: 12755553
Join Date: Feb 2009
Location: North Carolina
Device: Nexus 7
Quote:
Originally Posted by iomari View Post
is there some hidden field that stores the date a book was entered into the database? I would like to bring that out to the front end.
I believe the Date column is the date the book was entered into the calibre database.
DoctorOhh is offline   Reply With Quote
Old 10-06-2011, 08:12 AM   #5
iomari
Zealot
iomari doesn't litteriomari doesn't litter
 
iomari's Avatar
 
Posts: 134
Karma: 100
Join Date: Aug 2003
Location: Nigeria
Device: galaxy tab
Quote:
Originally Posted by dwanthny View Post
I believe the Date column is the date the book was entered into the calibre database.

I'm embarrassed.

thanks
iomari is offline   Reply With Quote
Old 10-06-2011, 12:09 PM   #6
chaley
"chaley", not "charley"
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 5,919
Karma: 1673776
Join Date: Jan 2010
Location: France
Device: Many android devices
Quote:
Originally Posted by iomari View Post
Can someone give me a hint how to add the timestamp field as a custom column?
I can't seem to find the right function to use for the template.
Use {timestamp}. No function is necessary.

If you want to format it, then use {timestamp:'format_date($, 'yyyy')'} where 'yyyy' is replaced with the format you wish. If you want the full ISO timestamp including the time, use {:'raw_field('timestamp')'}

Last edited by chaley; 10-06-2011 at 12:27 PM. Reason: corrected the raw_field template
chaley is offline   Reply With Quote
Old 10-06-2011, 12:24 PM   #7
iomari
Zealot
iomari doesn't litteriomari doesn't litter
 
iomari's Avatar
 
Posts: 134
Karma: 100
Join Date: Aug 2003
Location: Nigeria
Device: galaxy tab
Quote:
Originally Posted by chaley View Post
Use {timestamp}. No function is necessary.

If you want to format it, then use {timestamp:'format_date($, 'yyyy')'} where 'yyyy' is replaced with the format you wish. If you want the full ISO timestamp including the time, use {;'raw_field('timestamp')'}

cool
iomari is offline   Reply With Quote
Old 10-09-2011, 04:00 AM   #8
cybmole
Wizard
cybmole ought to be getting tired of karma fortunes by now.cybmole ought to be getting tired of karma fortunes by now.cybmole ought to be getting tired of karma fortunes by now.cybmole ought to be getting tired of karma fortunes by now.cybmole ought to be getting tired of karma fortunes by now.cybmole ought to be getting tired of karma fortunes by now.cybmole ought to be getting tired of karma fortunes by now.cybmole ought to be getting tired of karma fortunes by now.cybmole ought to be getting tired of karma fortunes by now.cybmole ought to be getting tired of karma fortunes by now.cybmole ought to be getting tired of karma fortunes by now.
 
Posts: 2,997
Karma: 1285294
Join Date: Sep 2010
Device: Kobo aura HD, Kobo Arc, Kindle Fire HDX 8.9 , Kindle for PC
Quote:
Originally Posted by dwanthny View Post
I believe the Date column is the date the book was entered into the calibre database.
Hmm - not always, I imported a collection of "found" books" that appear to have come from a calibre collection ( because of how the book folders are structured)

I did this via Add books

they have may/June dates in my calibre library, even though I added them yesterday ???
cybmole is offline   Reply With Quote
Old 10-09-2011, 04:32 AM   #9
DoctorOhh
US Navy, Retired
DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.
 
DoctorOhh's Avatar
 
Posts: 8,909
Karma: 12755553
Join Date: Feb 2009
Location: North Carolina
Device: Nexus 7
Quote:
Originally Posted by cybmole View Post
Hmm - not always, I imported a collection of "found" books" that appear to have come from a calibre collection ( because of how the book folders are structured)

I did this via Add books

they have may/June dates in my calibre library, even though I added them yesterday ???
That is due to the fact that they were added to calibre in may/june and the metadata.opf files that were lying around the same folders as the books were used to add then to your library.

If this date bothers you then you have a few of options:

1. Stop adding "found" books to your library.
2. Delete the metadata.opf files prior to adding the books. The metadata.opf file is for calibre use only and is used to restore books to the library after being saved to disk or used to restore a corrupt metadata.db in the calibre library.
3. If you know that the date is not going to reflect your library you can do a bulk metadata edit after adding the books and change the date to reflect the date you added them to your library.
4. Add the books one at a time via drag and drop from the file manager to the calibre library.

Bottom line is the date column is the date when the books were added to a calibre library, if you add books from someone else' library, with the data from that library, of course the date is going to reflect when they were added to that other person's library.

Last edited by DoctorOhh; 10-09-2011 at 04:37 AM.
DoctorOhh is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Published Date does not appear as a destination field utterlygreat Calibre 2 02-05-2011 01:07 PM
Can't clear "custom" date field? joegearhart Calibre 5 12-20-2010 04:32 AM
Bulk Changing Published Date To Date hmf Calibre 4 10-19-2010 11:19 PM
Up-to-date candy teacher (date being 1921) kacir Deals, Freebies, and Resources (No Self-Promotion) 0 06-16-2010 05:18 PM
new official shipping date / US invitation date R2D2 iRex 18 07-06-2006 03:32 PM


All times are GMT -4. The time now is 07:34 AM.


MobileRead.com is a privately owned, operated and funded community.