| 
			
			 | 
		#1 | 
| 
			
			
			
			 Junior Member 
			
			![]() Posts: 5 
				Karma: 10 
				Join Date: Jan 2009 
				
				
				
				Device: iLiad 
				
				
				 | 
	
	
	
		
		
			
			 
				
				Storing the publish date for books
			 
			
			
			I have read other posts about being able to edit the date column, and I believe the published date of the book is even more important than the publisher. I guess I could get a mysqlite editor and change the timestamp manually, but is'nt that information available from isbndb? Even just an extra column with a short int for the year would be enough. 
		
	
		
		
		
		
		
		
		
		
		
		
	
	Good work on the software as a whole though, I wouldn't change anything else if I made it my self Cheers!  | 
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| 
			
			 | 
		#2 | 
| 
			
			
			
			 creator of calibre 
			
			![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 45,609 
				Karma: 28549044 
				Join Date: Oct 2006 
				Location: Mumbai, India 
				
				
				Device: Various 
				
				
				 | 
	
	
	
		
		
		
		
		 
			
			You can always add the first published date to the comments. The reason it isn't a column is because there isn't much need to sort on it, in normal usage patterns
		 
		
	
		
		
		
		
		
		
		
		
		
		
	
	 | 
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| Advert | |
| 
         | 
    
| 
			
			 | 
		#3 | 
| 
			
			
			
			 Grand Sorcerer 
			
			![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 7,452 
				Karma: 7185064 
				Join Date: Oct 2007 
				Location: Linköpng, Sweden 
				
				
				Device: Kindle Voyage, Nexus 5, Kindle PW 
				
				
				 | 
	
	
	
		
		
		
		
		 
			
			I always sort books by an author according to copyright date. I thought that was very common to do and to read them in copyright order.
		 
		
	
		
		
		
		
		
		
		
		
		
		
	
	 | 
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| 
			
			 | 
		#4 | 
| 
			
			
			
			 creator of calibre 
			
			![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 45,609 
				Karma: 28549044 
				Join Date: Oct 2006 
				Location: Mumbai, India 
				
				
				Device: Various 
				
				
				 | 
	
	|
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| 
			
			 | 
		#5 | 
| 
			
			
			
			 Grand Sorcerer 
			
			![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 7,452 
				Karma: 7185064 
				Join Date: Oct 2007 
				Location: Linköpng, Sweden 
				
				
				Device: Kindle Voyage, Nexus 5, Kindle PW 
				
				
				 | 
	
	
	
		
		
		
		
		 
			
			But what about authors that do not write series? I read new authors in copyright order even if they do not write series (I assume that "misc" could be a serie so you can solve it that way). It is also interesting to know when a book was written when you read it especially for contemporary books.
		 
		
	
		
		
		
		
		
		
		
		
		
		
	
	 | 
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| Advert | |
| 
         | 
    
| 
			
			 | 
		#6 | |
| 
			
			
			
			 creator of calibre 
			
			![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 45,609 
				Karma: 28549044 
				Join Date: Oct 2006 
				Location: Mumbai, India 
				
				
				Device: Various 
				
				
				 | 
	
	
	
		
		
		
		
		 Quote: 
	
  | 
|
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| 
			
			 | 
		#7 | 
| 
			
			
			
			 Evangelist 
			
			![]() ![]() ![]() ![]() ![]() ![]() Posts: 405 
				Karma: 692 
				Join Date: Sep 2006 
				
				
				
				Device: Samsung Galaxy Note 3 | Kindle Paperwhite | iPad Mini 
				
				
				 | 
	
	
	
		
		
		
		
		 
			
			I also use the copyright date for books (alot of romance readers do because of reprints and reissues w/in the genre).  I'm using the tag field to sort the date, but it would be nice to have a copyright date. It's one of the fields of information that almost all publishers give.
		 
		
	
		
		
		
		
		
		
		
		
		
		
	
	 | 
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| 
			
			 | 
		#8 | 
| 
			
			
			
			 Junior Member 
			
			![]() Posts: 5 
				Karma: 10 
				Join Date: Jan 2009 
				
				
				
				Device: iLiad 
				
				
				 | 
	
	
	
		
		
		
		
		 
			
			It sounds to me that other people would find this a useful addition to the software, can i get a show of thumbs from others that think its a good idea?  
		
	
		
		
		
		
		
		
		
		
		
		
	
	 | 
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| 
			
			 | 
		#9 | 
| 
			
			
			
			 What the Dog Saw 
			
			![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 311 
				Karma: 981684 
				Join Date: Jul 2008 
				Location: Dunn Loring 
				
				
				Device: Sony PRS-650, Surface3 
				
				
				 | 
	
	|
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| 
			
			 | 
		#10 | 
| 
			
			
			
			 Junior Member 
			
			![]() Posts: 7 
				Karma: 10 
				Join Date: Mar 2008 
				Location: Netherlands 
				
				
				Device: Iliad, PRS505 
				
				
				 | 
	
	
	
		
		
		
		
		 
			
			Lack of the date of publication in the metadata is but part of a wider problem. The metadata in Calibre does not comply with any standard for bibliographical information such as Dublin Core. This makes Calibre entirely useless for professional cataloguing, e.g. in libraries. In fact, Calibre is great for creating RSS-documents and for format conversion. But as a cataloguing application it is, unfortunately, rather amateurish.  
		
	
		
		
		
		
		
		
		
		
		
		
	
	But I do give thumbs-up for adding a field for the publication date. That would be a small step forward at least.  | 
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| 
			
			 | 
		#11 | 
| 
			
			
			
			 Literacy = Understanding 
			
			![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 4,833 
				Karma: 59674358 
				Join Date: Dec 2007 
				Location: The World of Books 
				
				
				Device: Nook, Nook Tablet 
				
				
				 | 
	
	
	
		
		
		
		
		 | 
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| 
			
			 | 
		#12 | 
| 
			
			
			
			 Guru 
			
			![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 834 
				Karma: 102419 
				Join Date: Sep 2007 
				Location: Vienna, Austria 
				
				
				Device: iPhone 
				
				
				 | 
	
	
	
		
		
		
		
		 
			
			HA! 
		
	
		
		
		
		
		
		
		
		
		
		
	
	So I am not the only freak around here ![]() I thought of another reason why the publishing date might be of interest: Authors sometimes re-publish their books to make them more contemporary, remove references to "dead" technologies (such as car phones or LPs) etc. But using the "Series" field (which is awesome, by the way, but strange since most programs/databases/etc. do not give this info) is a plausible "plan B" for my needs.  | 
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| 
			
			 | 
		#13 | |
| 
			
			
			
			 creator of calibre 
			
			![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 45,609 
				Karma: 28549044 
				Join Date: Oct 2006 
				Location: Mumbai, India 
				
				
				Device: Various 
				
				
				 | 
	
	
	
		
		
		
		
		 Quote: 
	
  | 
|
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| 
			
			 | 
		#14 | |
| 
			
			
			
			 Grand Sorcerer 
			
			![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 7,452 
				Karma: 7185064 
				Join Date: Oct 2007 
				Location: Linköpng, Sweden 
				
				
				Device: Kindle Voyage, Nexus 5, Kindle PW 
				
				
				 | 
	
	
	
		
		
		
		
		 Quote: 
	
 I just looked at Dublin Core Metadata Element Set and I would like to have all 15 elements in my book data base. I also might need additional elements. A lot of my friends use the library classification system for their books. I assume they also use other meta information inspired from libraries.  | 
|
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| 
			
			 | 
		#15 | |
| 
			
			
			
			 creator of calibre 
			
			![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 45,609 
				Karma: 28549044 
				Join Date: Oct 2006 
				Location: Mumbai, India 
				
				
				Device: Various 
				
				
				 | 
	
	
	
		
		
		
		
		 Quote: 
	
   They need a tool that allows them to get a certain minimum amount of metadata reasonabl correct, with as little effort as possible. Librarians on the other hand, never actually read all their books, they spend their time making sure all the metadata associated with each book is correct. And let me say this one last time in bold: calibre allows you store arbitrary metadata for each book. It just doesn't allow you to sort on the arbitrary metadata. You can still search on it, refer to it, admire it, show it to all your friends.  | 
|
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
![]()  | 
            
        
            
            
  | 
    
			 
			Similar Threads
		 | 
	||||
| Thread | Thread Starter | Forum | Replies | Last Post | 
| Calibre 0.6.14 incorrect publish date | elmoglick | Calibre | 16 | 02-09-2011 03:24 PM | 
| Google Signs a Deal to e-Publish Out-of-Print Books | Mitchll | News | 1 | 11-10-2008 10:21 AM | 
| Penguin to publish new titles simultaneously as e-books | M.H. | News | 57 | 06-08-2008 03:16 PM | 
| Using Publish eBook to Create PalmDoc Books | Bob Russell | Other formats | 2 | 07-09-2005 11:55 AM | 
| Pirates publish e-books on copyright theft | Alexander Turcic | News | 0 | 01-17-2005 07:05 AM |