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, 07: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, 07: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: 9,678
Karma: 8412395
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 07:32 PM.
BetterRed is offline   Reply With Quote
Old 01-17-2018, 08: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,350
Karma: 20890066
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, 09:04 PM   #4
sjfan
Groupie
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: 160
Karma: 4030574
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:	29
Size:	183.5 KB
ID:	161648  
sjfan is offline   Reply With Quote
Old 01-19-2018, 11: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
Old 01-19-2018, 01: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,350
Karma: 20890066
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, 02:54 PM   #7
retiredbiker
Member
retiredbiker began at the beginning.
 
retiredbiker's Avatar
 
Posts: 23
Karma: 10
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, 03: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,350
Karma: 20890066
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 02:37 AM
Print a List Susan A Calibre 2 11-14-2014 02:25 AM
list-style-type bullet odedta ePub 14 06-18-2014 10:53 AM
print a list of my books? StickMaker Amazon Kindle 11 03-04-2011 11:34 AM
Print List silverraven Calibre 5 09-15-2010 08:55 PM


All times are GMT -4. The time now is 03:54 AM.


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