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

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 01-17-2018, 06:20 PM   #1
mjshuster
Junior Member
mjshuster began at the beginning.
 
Posts: 2
Karma: 10
Join Date: Jan 2018
Device: Kobo Aura One
Categorize by type, then print a list?

I’ve never tried to do anything other than use Calibre as a repository for my e-books.

Yesterday a friend asked for a list of my fantasy novels. How can I add or use an existing field for Category? I’d like to categorize my e-books by “type”, that is, (F)iction, (B)iography, (FA)ntasy, etc. Is there a coloured tag that I can use? Or can I add a field to the file structure?

Then I’d like to print off a list of my “Fantasy” e-books to give, or email, to my friend.

Over 20 years ago, I was a programmer. But I was a business programmer so I wrote programs in COBOL or in an SQL query language. I didn’t do any object oriented programming.
mjshuster is offline   Reply With Quote
Advert
Old 01-17-2018, 06:30 PM   #2
BetterRed
null operator
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 10,003
Karma: 9778218
Join Date: Mar 2012
Location: Sydney Australia
Device: none
What you want is hierarchical tags, see Managing subgroups of books

Then you can search by subgroup (genre) and create a catalogue to send to your friend

BR

Last edited by BetterRed; 01-17-2018 at 06:32 PM.
BetterRed is offline   Reply With Quote
Old 01-17-2018, 07:05 PM   #3
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 21,593
Karma: 20950032
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: K4NT, Galaxy Tab 2(RIP)
Create a CSV Catalog (use you fav spreadsheet for printing)
Catalog respects the current view
So search tags:fantasy (verify results meet your needs)
Right click the convert Icon: Catalog: Select CSV: Use the options tab to select fields to include.
Run:save to a target folder: Open CSV with spreadsheet
theducks is offline   Reply With Quote
Old 01-17-2018, 08:04 PM   #4
sjfan
Addict
sjfan ought to be getting tired of karma fortunes by now.sjfan ought to be getting tired of karma fortunes by now.sjfan ought to be getting tired of karma fortunes by now.sjfan ought to be getting tired of karma fortunes by now.sjfan ought to be getting tired of karma fortunes by now.sjfan ought to be getting tired of karma fortunes by now.sjfan ought to be getting tired of karma fortunes by now.sjfan ought to be getting tired of karma fortunes by now.sjfan ought to be getting tired of karma fortunes by now.sjfan ought to be getting tired of karma fortunes by now.sjfan ought to be getting tired of karma fortunes by now.
 
Posts: 242
Karma: 7568340
Join Date: Sep 2017
Location: Bethesda, MD, USA
Device: Kobo Aura H20
Quote:
Originally Posted by mjshuster View Post
I’ve never tried to do anything other than use Calibre as a repository for my e-books.

Yesterday a friend asked for a list of my fantasy novels. How can I add or use an existing field for Category? I’d like to categorize my e-books by “type”, that is, (F)iction, (B)iography, (FA)ntasy, etc. Is there a coloured tag that I can use? Or can I add a field to the file structure?

Then I’d like to print off a list of my “Fantasy” e-books to give, or email, to my friend.

Over 20 years ago, I was a programmer. But I was a business programmer so I wrote programs in COBOL or in an SQL query language. I didn’t do any object oriented programming.
Calibre has tags built in (comma-separated). So as you add books, you just make sure you tag things appropriately. If you've already added things, a search by author and bulk edit can be handy for authors who write mainly in one genre. For instance you can search for “Agatha Christie”, select all, bulk edit tags to “Fiction, Mystery”, and then go hand edit only those books that don't fit the category.

Than you can search for “tag:Fantasy” or whatever. theducks explained how to generate a CSV catalog from this if you want.

If you want tags to show in the main view, right-click on one of the existing columns and choose “Show column -> Tags”. See the attached image for an example.
Attached Thumbnails
Click image for larger version

Name:	calibre.jpg
Views:	57
Size:	183.5 KB
ID:	161648  
sjfan is offline   Reply With Quote
Old 01-19-2018, 10:22 AM   #5
mjshuster
Junior Member
mjshuster began at the beginning.
 
Posts: 2
Karma: 10
Join Date: Jan 2018
Device: Kobo Aura One
Thanks.

To the 3 people who responded to this question. These suggestions worked like a charm.

I am also curious as to what Calibre’s underlying file structure is. Is it a flat file or is there a relational database in there?
mjshuster is offline   Reply With Quote
Advert
Old 01-19-2018, 12:41 PM   #6
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 21,593
Karma: 20950032
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: K4NT, Galaxy Tab 2(RIP)
Quote:
Originally Posted by mjshuster View Post
To the 3 people who responded to this question. These suggestions worked like a charm.

I am also curious as to what Calibre’s underlying file structure is. Is it a flat file or is there a relational database in there?
HUGE RDB

SQLITE spy (just don't tamper )
theducks is offline   Reply With Quote
Old 01-19-2018, 01:54 PM   #7
retiredbiker
Enthusiast
retiredbiker is faster than slow light.retiredbiker is faster than slow light.retiredbiker is faster than slow light.retiredbiker is faster than slow light.retiredbiker is faster than slow light.retiredbiker is faster than slow light.retiredbiker is faster than slow light.retiredbiker is faster than slow light.retiredbiker is faster than slow light.retiredbiker is faster than slow light.retiredbiker is faster than slow light.
 
retiredbiker's Avatar
 
Posts: 36
Karma: 29896
Join Date: May 2013
Device: Kindle KB, Oasis, Ubuntu, Jutoh
Quote:
Originally Posted by theducks View Post
HUGE RDB
As theducks said...So don't even think of mucking about with the file structure of the library with your file manager!
retiredbiker is offline   Reply With Quote
Old 01-19-2018, 02:14 PM   #8
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 21,593
Karma: 20950032
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: K4NT, Galaxy Tab 2(RIP)
Quote:
Originally Posted by retiredbiker View Post
As theducks said...So don't even think of mucking about with the file structure of the library with your file manager!
I was talking about the structure of metadata.db. But your point also stands.
theducks 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
Wish list -print option for book list C-novice Library Management 3 04-16-2017 01:37 AM
Print a List Susan A Calibre 2 11-14-2014 01:25 AM
list-style-type bullet odedta ePub 14 06-18-2014 09:53 AM
print a list of my books? StickMaker Amazon Kindle 11 03-04-2011 10:34 AM
Print List silverraven Calibre 5 09-15-2010 07:55 PM


All times are GMT -4. The time now is 02:55 PM.


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