MobileRead Forums
Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre
Reload this Page Is there a way to export the information in the left panel?

Notices

Reply
 
Thread Tools Search this Thread
Old 10-05-2010, 01:25 PM   #1
Over
Wizard
Over ought to be getting tired of karma fortunes by now.Over ought to be getting tired of karma fortunes by now.Over ought to be getting tired of karma fortunes by now.Over ought to be getting tired of karma fortunes by now.Over ought to be getting tired of karma fortunes by now.Over ought to be getting tired of karma fortunes by now.Over ought to be getting tired of karma fortunes by now.Over ought to be getting tired of karma fortunes by now.Over ought to be getting tired of karma fortunes by now.Over ought to be getting tired of karma fortunes by now.Over ought to be getting tired of karma fortunes by now.
 
Over's Avatar
 
Posts: 1,462
Karma: 6061516
Join Date: May 2008
Location: Cascais, Portugal
Device: Kindle PW, Samsung Galaxy Note Pro 12.2", OnePlus 6
Lightbulb Is there a way to export the information in the left panel?
I would like to export to an html file (or other format) the information in the left panel (total number of books, number of authors, number of series, number of each tag, number of each ebook format, etc).

Is there a way to do that?
Over is offline   Reply With Quote
Old 10-05-2010, 02:37 PM   #2
jackie_w
Grand Sorcerer
jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.
 
Posts: 6,249
Karma: 16539642
Join Date: Sep 2009
Location: UK
Device: ClaraHD, Forma, Libra2, Clara2E, LibraCol, PBTouchHD3
This is probably more long-winded than you had in mind, but if you use the Catalog feature to create your library in CSV format then you could import it into Excel (or similar) and get to those figures with a bit (a lot) of sorting and subtotalling.
jackie_w is offline   Reply With Quote
Advert
Old 10-06-2010, 01:21 PM   #3
Over
Wizard
Over ought to be getting tired of karma fortunes by now.Over ought to be getting tired of karma fortunes by now.Over ought to be getting tired of karma fortunes by now.Over ought to be getting tired of karma fortunes by now.Over ought to be getting tired of karma fortunes by now.Over ought to be getting tired of karma fortunes by now.Over ought to be getting tired of karma fortunes by now.Over ought to be getting tired of karma fortunes by now.Over ought to be getting tired of karma fortunes by now.Over ought to be getting tired of karma fortunes by now.Over ought to be getting tired of karma fortunes by now.
 
Over's Avatar
 
Posts: 1,462
Karma: 6061516
Join Date: May 2008
Location: Cascais, Portugal
Device: Kindle PW, Samsung Galaxy Note Pro 12.2", OnePlus 6
Yeah, that's a little bit complex. It would be great if Calibre could do that. It already does, we just need to be able to export that information (directly).
Over is offline   Reply With Quote
Old 10-06-2010, 07:37 PM   #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: 9,890
Karma: 13806776
Join Date: Feb 2009
Location: North Carolina
Device: Icarus Illumina XL HD, Kindle PaperWhite SE 11th Gen
Quote:
Originally Posted by Over View Post
Quote:
Originally Posted by jackie_w View Post
This is probably more long-winded than you had in mind, but if you use the Catalog feature to create your library in CSV format then you could import it into Excel (or similar) and get to those figures with a bit (a lot) of sorting and subtotalling.
Yeah, that's a little bit complex. It would be great if Calibre could do that. It already does, we just need to be able to export that information (directly).
That is calibre exporting that information directly.

Are you looking for some sort of stat sheet or app you can place on a blog?
DoctorOhh is offline   Reply With Quote
Old 10-07-2010, 11:38 AM   #5
chaley
Grand Sorcerer
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: 12,345
Karma: 8012652
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
The next release has a new command-line function: calibredb list_categories

Documentation:
Spoiler:
calibre_development>calibredb list_categories --help
Usage: calibredb.exe list_categories [options]

Produce a report of the category information in the database. The
information is the equivalent of what is shown in the tags pane.


Whenever you pass arguments to calibredb.exe that have spaces in them, enclose the arguments in quotation marks.

Options:
--version show program's version number and exit

-h, --help show this help message and exit

-i, --item_count Output only the number of items in a category instead
of the counts per item within the category

-c, --csv Output in CSV

-q QUOTE, --quote=QUOTE
The character to put around the category value in CSV
mode. Default is quotes (").

-r REPORT, --categories=REPORT
Comma-separated list of category lookup names.
Default: all

-w LINE_WIDTH, --line-width=LINE_WIDTH
The maximum width of a single line in the output.
Defaults to detecting screen size.

-s SEPARATOR, --separator=SEPARATOR
The string used to separate fields in CSV mode.
Default is a comma.


GLOBAL OPTIONS:
--library-path=LIBRARY_PATH, --with-library=LIBRARY_PATH
Path to the calibre library. Default is to use the
path stored in the settings.


Created by Kovid Goyal <kovid@kovidgoyal.net>


Sample output: calibredb list_categories -i
Spoiler:
> calibredb list_categories -i
Code:
category  tag_name       count rating
authors   CATEGORY ITEMS 17    0.0
formats   CATEGORY ITEMS 6     0.0
news      CATEGORY ITEMS 2     0.0
publisher CATEGORY ITEMS 10    0.0
rating    CATEGORY ITEMS 3     0.0
search    CATEGORY ITEMS 4     0.0
#series   CATEGORY ITEMS 1     0.0
series    CATEGORY ITEMS 3     0.0
tags      CATEGORY ITEMS 30    0.0
#text     CATEGORY ITEMS 2     0.0
#textmult CATEGORY ITEMS 1     0.0
#tool     CATEGORY ITEMS 1     0.0


Sample output: calibredb list_categories (edited)

Spoiler:
Code:
>calibredb list_categories
category  tag_name                                          count rating
authors   calibre                                           2     0
authors   Flint, Eric                                       2     2.0
authors   Rohmer, Sax                                       1     0
authors   Miguel de Cervantes Saavedra                      1     0
authors   Shakespeare, William, 1564-1616                   1     0
authors   Unknown                                           1     0
authors   Jules Verne                                       1     0
authors   Weber, David                                      1     0
formats   EPUB                                              20    0.0
formats   LRF                                               1     0.0
formats   MOBI                                              12    0.0
formats   RTF                                               1     0.0
formats   TXT                                               2     0.0
formats   ZIP                                               1     0.0
news      Dilbert                                           1     0.0
news      LeMonde.fr                                        1     0.0
publisher Ace Books                                         1     3.0
publisher Baen                                              3     2.0
publisher calibre                                           1     0
rating    2                                                 1     3.33333333333
rating    3                                                 1     3.33333333333
rating    5                                                 1     3.33333333333
#series   foo                                               2     0
series    1632                                              5     2.0
tags      a                                                 1     0
tags      Alternate history                                 2     0
tags      b                                                 1     0
tags      c                                                 1     0
tags      Classics                                          2     0
tags      d                                                 1     0
tags      Dilbert                                           1     0
tags      e                                                 1     0
tags      f                                                 1     0
tags      ffff1                                             1     0
tags      Knights and knighthood -- Spain -- Fiction        1     0
tags      LeMonde.fr                                        1     0
tags      Mystery                                           1     0
tags      News                                              2     0
tags      PBook                                             7     0
tags      Picaresque literature                             1     0
tags      Romances                                          1     0
tags      Science Fiction                                   10    4.0
tags      Spain -- Social life and customs -- 16th century  1     0
          -- Fiction
#text     foo                                               2     0
#text     zzz                                               1     2.0
#textmult foo                                               2     0
#tool     asdas                                             1     2.0
chaley is offline   Reply With Quote
Advert
Old 10-07-2010, 01:47 PM   #6
jackie_w
Grand Sorcerer
jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.
 
Posts: 6,249
Karma: 16539642
Join Date: Sep 2009
Location: UK
Device: ClaraHD, Forma, Libra2, Clara2E, LibraCol, PBTouchHD3
That looks as if it should satisfy the original request.

Thank you, Charles, your work is much appreciated.
jackie_w is offline   Reply With Quote
Reply

« Previous Thread | Next Thread »

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
K3 Squeaky, Loose Back Panel yanathin Amazon Kindle 39 08-12-2011 05:53 AM
Panel to the left of catalog pietvo Calibre 3 04-21-2010 07:11 AM
PRS-505 Broken top panel. How to fix it? BeTePoK Sony Reader 7 04-16-2010 12:01 PM
why have I lost the left hand panel of my ebook libary? jolfc Sony Reader 7 04-30-2009 03:07 PM
iLiad Panel Applets for iLiad's Toolbar yokos iRex Developer's Corner 3 05-06-2008 01:56 PM


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

Contact Us - FAQ - Guidelines - Privacy - Top

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