Register Guidelines E-Books Today's Posts Search

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

Notices

Reply
 
Thread Tools Search this Thread
Old 01-15-2012, 10:24 PM   #1
Nicko
Groupie
Nicko shares his or her toysNicko shares his or her toysNicko shares his or her toysNicko shares his or her toysNicko shares his or her toysNicko shares his or her toysNicko shares his or her toysNicko shares his or her toysNicko shares his or her toysNicko shares his or her toysNicko shares his or her toys
 
Posts: 184
Karma: 5590
Join Date: Sep 2011
Device: Kindle Paperwhite3
Print-out of book titles and authors only

I am trying to print out the Titles and Authors of the books I have in my Calibre Library. Instead of getting just the Titles and Authors the CSV file opens in Excel (which I am not familiar with) and shows all the columns.

This is how I have been trying to do it:
1. I highlighted all the books in the Calibre Library.
2. Clicked on the small arrow right side of Convert Books.
3. Selected Create a Catalogue.
4. In the two tabs that pop up I selected CSV as my Catalogue Format,
when I select this the second tab changes to CSV/XML Options.
5. In Catalogue Title, I typed Title and Author, which is all that I want.

When I open the CSV file it comes up in Excel and shows all the listings information and not just the Titles and Authors.
What am I doing wrong?. Any help will be appreciated.
Nicko is offline   Reply With Quote
Old 01-15-2012, 10:36 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: 30,939
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by Nicko View Post
I am trying to print out the Titles and Authors of the books I have in my Calibre Library. Instead of getting just the Titles and Authors the CSV file opens in Excel (which I am not familiar with) and shows all the columns.

This is how I have been trying to do it:
1. I highlighted all the books in the Calibre Library.
2. Clicked on the small arrow right side of Convert Books.
3. Selected Create a Catalogue.
4. In the two tabs that pop up I selected CSV as my Catalogue Format,
when I select this the second tab changes to CSV/XML Options.
5. In Catalogue Title, I typed Title and Author, which is all that I want.

When I open the CSV file it comes up in Excel and shows all the listings information and not just the Titles and Authors.
What am I doing wrong?. Any help will be appreciated.
There are CSV Catalog format options on the second tab for which fields to include.

Excel or Open Office Calc is fairly easy to learn. Print Preview lets yo see the proposed output.
theducks is offline   Reply With Quote
Advert
Old 01-15-2012, 11:25 PM   #3
Nicko
Groupie
Nicko shares his or her toysNicko shares his or her toysNicko shares his or her toysNicko shares his or her toysNicko shares his or her toysNicko shares his or her toysNicko shares his or her toysNicko shares his or her toysNicko shares his or her toysNicko shares his or her toysNicko shares his or her toys
 
Posts: 184
Karma: 5590
Join Date: Sep 2011
Device: Kindle Paperwhite3
I cannot see any optiions on the second TAB that allows which fields to include. When I look in the second TAB it lists BIB CSV EPUB MOBI and XML. Am I missing something?.
Nicko is offline   Reply With Quote
Old 01-16-2012, 10:02 AM   #4
Synamon
Lunatic
Synamon ought to be getting tired of karma fortunes by now.Synamon ought to be getting tired of karma fortunes by now.Synamon ought to be getting tired of karma fortunes by now.Synamon ought to be getting tired of karma fortunes by now.Synamon ought to be getting tired of karma fortunes by now.Synamon ought to be getting tired of karma fortunes by now.Synamon ought to be getting tired of karma fortunes by now.Synamon ought to be getting tired of karma fortunes by now.Synamon ought to be getting tired of karma fortunes by now.Synamon ought to be getting tired of karma fortunes by now.Synamon ought to be getting tired of karma fortunes by now.
 
Synamon's Avatar
 
Posts: 1,691
Karma: 4386372
Join Date: Dec 2011
Location: Land of the Loonie
Device: Kindle Paperwhite and Keyboard, Kobo Aura, iPad mini, iPod Touch
Select CSV in the box you are referring to.

Then look above that, right at the top of the page, next to 'Catalog Options' is a tab labeled 'CSV/XML Options', click that one and select which fields to include in the output.
Synamon is offline   Reply With Quote
Old 01-16-2012, 06:40 PM   #5
Nicko
Groupie
Nicko shares his or her toysNicko shares his or her toysNicko shares his or her toysNicko shares his or her toysNicko shares his or her toysNicko shares his or her toysNicko shares his or her toysNicko shares his or her toysNicko shares his or her toysNicko shares his or her toysNicko shares his or her toys
 
Posts: 184
Karma: 5590
Join Date: Sep 2011
Device: Kindle Paperwhite3
Quote:
Originally Posted by Synamon View Post
Select CSV in the box you are referring to.

Then look above that, right at the top of the page, next to 'Catalog Options' is a tab labeled 'CSV/XML Options', click that one and select which fields to include in the output.
DUH!! I have just wacked myself on the head in an endeavour to wake me up. Many thanks for steering me in the right direction.
Nicko is offline   Reply With Quote
Advert
Reply


Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Bloomsbury Reader: New Digital Publisher of Out-of-Print Crime Fiction Titles NightBird Reading Recommendations 7 10-03-2011 05:15 PM
Renaming authors and titles BookieNookie Calibre 1 06-07-2011 01:56 AM
Survey for indie authors: What percent of your sales are ebooks vs. print books? Smashwords Writers' Corner 0 05-05-2011 07:02 PM
PRS-950 Changing file names / Book titles and authors sarabadara Sony Reader 2 12-26-2010 05:28 PM
Changes in Titles/Authors Not Shown Ralob Bookeen 20 04-07-2008 08:16 AM


All times are GMT -4. The time now is 09:41 AM.


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