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 06-19-2012, 09:55 PM   #1
affa
Connoisseur
affa can extract oil from cheeseaffa can extract oil from cheeseaffa can extract oil from cheeseaffa can extract oil from cheeseaffa can extract oil from cheeseaffa can extract oil from cheeseaffa can extract oil from cheeseaffa can extract oil from cheeseaffa can extract oil from cheese
 
Posts: 56
Karma: 1234
Join Date: Apr 2011
Device: kindle
Series 'Report' Generation?

Ok, I've been running into hurdle after hurdle... my basic problem is that I'm trying to deal with 'series' across various devices. I've gotten plugboards to work, but that breaks 'on device' for me, and it also looks bad on some devices (that have limited screen real estate for title).

SO....

I've decided all I want to do for series is generate a report of all series in my library, save it as a file in my library, and upload said file to my devices. That way, if I'm reading a series, I can just open that file, check for the title of the next book, and be done with it. No plugboards, no extra-long titles, just... exactly what I need.

So my question is this - is there an easy way to generate this report? It doesn't need to be fancy, just something like

The Trilogy -
[1] First Book
[2] Second Book
[3] Third Book

John Doe Detective
[1] Doe's Derring Do
[2] Doe Done It

etc...
affa is offline   Reply With Quote
Old 06-19-2012, 10:46 PM   #2
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: 25,511
Karma: 35353393
Join Date: Aug 2009
Location: The Central Coast of California
Device: K4NT(Fixed,New Bat.), Galaxy Tab A, Kobo Aura2
Quote:
Originally Posted by affa View Post
Ok, I've been running into hurdle after hurdle... my basic problem is that I'm trying to deal with 'series' across various devices. I've gotten plugboards to work, but that breaks 'on device' for me, and it also looks bad on some devices (that have limited screen real estate for title).

SO....

I've decided all I want to do for series is generate a report of all series in my library, save it as a file in my library, and upload said file to my devices. That way, if I'm reading a series, I can just open that file, check for the title of the next book, and be done with it. No plugboards, no extra-long titles, just... exactly what I need.

So my question is this - is there an easy way to generate this report? It doesn't need to be fancy, just something like

The Trilogy -
[1] First Book
[2] Second Book
[3] Third Book

John Doe Detective
[1] Doe's Derring Do
[2] Doe Done It

etc...

IIRC you used to be able to create a CSV Catalog of only Selected books.
This has not worked for some time (on XP).

SO

Use the CLI (use the filter : series:true or any valid search bar term) http://manual.calibre-ebook.com/cli/calibredb.html
theducks is offline   Reply With Quote
Advert
Old 06-19-2012, 11:28 PM   #3
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,830
Karma: 13774200
Join Date: Feb 2009
Location: North Carolina
Device: Icarus Illumina XL HD, Nexus 7
Quote:
Originally Posted by affa View Post
Ok, I've been running into hurdle after hurdle... my basic problem is that I'm trying to deal with 'series' across various devices. I've gotten plugboards to work, but that breaks 'on device' for me, and it also looks bad on some devices (that have limited screen real estate for title).
Just curious, what devices are you using? For my Sony devices I include the Series info in the author line and leave the title alone (see attached).

Quote:
Originally Posted by affa View Post
So my question is this - is there an easy way to generate this report?
Create a catalog using the dropdown arrow to the right of the conversion icon (see attached).
Attached Thumbnails
Click image for larger version

Name:	2012-6-19.jpg
Views:	115
Size:	49.9 KB
ID:	88044   Click image for larger version

Name:	createcatalog.jpg
Views:	101
Size:	53.4 KB
ID:	88046  
DoctorOhh is offline   Reply With Quote
Old 06-20-2012, 12:50 AM   #4
affa
Connoisseur
affa can extract oil from cheeseaffa can extract oil from cheeseaffa can extract oil from cheeseaffa can extract oil from cheeseaffa can extract oil from cheeseaffa can extract oil from cheeseaffa can extract oil from cheeseaffa can extract oil from cheeseaffa can extract oil from cheese
 
Posts: 56
Karma: 1234
Join Date: Apr 2011
Device: kindle
awesome. dwanthny's solution worked perfectly. generated a series listing directly into my library in my preferred format, can't ask for more than that.

Quote:
Originally Posted by theducks View Post
IIRC you used to be able to create a CSV Catalog of only Selected books.
This has not worked for some time (on XP).
Actually, it does seem to work on Windows 7... in fact, you can generate it directly into mobi or epub, etc.


Quote:
Originally Posted by dwanthny View Post
Just curious, what devices are you using? For my Sony devices I include the Series info in the author line and leave the title alone (see attached).
Ah, I really like the idea of using the Author line... might consider that for the devices it'll work for.
To answer your question, I have a couple devices in use -- I mainly use the Kindle app on the Ipad, which has plenty of room for titles/authors. I also have a Kindle Touch in the family, though it's traveling so I can't picture the interface offhand. The real problem display space wise is our Kindle (w/ keyboard) -- it chops off long author names and long title names -- adding series info to either is brutal, sometimes I lose the entire title.

Quote:
Originally Posted by dwanthny View Post
Create a catalog using the dropdown arrow to the right of the conversion icon (see attached).
worked like a dream
affa is offline   Reply With Quote
Old 06-20-2012, 04:15 AM   #5
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: 25,511
Karma: 35353393
Join Date: Aug 2009
Location: The Central Coast of California
Device: K4NT(Fixed,New Bat.), Galaxy Tab A, Kobo Aura2
Quote:
Originally Posted by affa View Post
Quote:
Originally Posted by theducks
IIRC you used to be able to create a CSV Catalog of only Selected books.
This has not worked for some time (on XP).
Actually, it does seem to work on Windows 7... in fact, you can generate it directly into mobi or epub, etc.
It creates a Catalog (Epub, Mobi or CSV), just not OF the 'Selected' records... it always does 'The whole Shebang' (4K books)
theducks is offline   Reply With Quote
Advert
Old 06-20-2012, 05:52 AM   #6
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,830
Karma: 13774200
Join Date: Feb 2009
Location: North Carolina
Device: Icarus Illumina XL HD, Nexus 7
Quote:
Originally Posted by theducks View Post
It creates a Catalog (Epub, Mobi or CSV), just not OF the 'Selected' records... it always does 'The whole Shebang' (4K books)
I haven't tried it but simply restricting the library to the "selected" should work to limit the Catalog.
DoctorOhh is offline   Reply With Quote
Old 06-20-2012, 06:38 AM   #7
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 37,566
Karma: 16528911
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
Quote:
Originally Posted by theducks View Post
It creates a Catalog (Epub, Mobi or CSV), just not OF the 'Selected' records... it always does 'The whole Shebang' (4K books)
Works for me. IIRC the restriction only applies if you have selected atleast 5 books or something like that.
kovidgoyal is offline   Reply With Quote
Old 06-20-2012, 09:18 AM   #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: 25,511
Karma: 35353393
Join Date: Aug 2009
Location: The Central Coast of California
Device: K4NT(Fixed,New Bat.), Galaxy Tab A, Kobo Aura2
Quote:
Originally Posted by kovidgoyal View Post
Works for me. IIRC the restriction only applies if you have selected at least 5 books or something like that.
I definitely selected more than 5 books. (I was making a 90 day catalog of Adds/Edits/Updated metadata: Modified:>= 90daysago)

I just peeked under the skirts... It did work .
It is 8M vs 46M for the full Library
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
It’s Start a New Series Month! 30% Off First Books In A Series! UntreedReads Self-Promotions by Authors and Publishers 0 02-02-2012 05:46 PM
Show series number but not if they aren't in a series? M4cc45 Library Management 10 09-03-2011 07:35 PM
Different export filenames for series / non-series books? HarryT Calibre 3 08-18-2010 12:30 PM
Free Report (Kindle) - Economic Report of the President koland Deals and Resources (No Self-Promotion or Affiliate Links) 5 02-13-2010 12:07 PM
Pet peeve: series authors who introduce things in non-series books! ficbot Reading Recommendations 12 02-06-2010 02:14 AM


All times are GMT -4. The time now is 03:50 PM.


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