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

Go Back   MobileRead Forums > E-Book Software > Calibre

Notices

Reply
 
Thread Tools Search this Thread
Old 06-07-2010, 09:22 AM   #1
Turt99
Connoisseur
Turt99 began at the beginning.
 
Posts: 92
Karma: 14
Join Date: Apr 2010
Device: Kindle Paperwhite
Updating Metadata in Bulk

I'm looking to edit the metadata on all my books, The download bulk feature works great but now I need to clean up the downloaded information and since my Kobo doesn't do collections I'm looking to add the series name to the beginning of the title.

For example I've been putting

Enders Saga 01 - Enders Game

This way I know the correct order of the books and they are all located together, the problem I'm having is that when I say edit individually I get an edit window for each but the window is taking 10 seconds each book (might be my computer Aspire One Netbook) so each book take the 10 seconds to load the screen then I need to look up the series information (Amazon.com or Wikipedia) making it very time consuming. Plus I have hit the Next button several times when I wasn't finished with the book so I'll need to go through all the books again to validate I guess. I was wondering if there was a way to edit the data in a spreadsheet layout?

I saw somewhere that there are command line controls maybe I could export a spreadsheet of the current data make some changes and then write a script to push it back in?

Its not as simple as manipulating the current data since some of the books don't have the real series information currently.
Turt99 is offline   Reply With Quote
Old 06-07-2010, 10:01 AM   #2
chaley
"chaley", not "charley"
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: 5,919
Karma: 1673776
Join Date: Jan 2010
Location: France
Device: Many android devices
Quote:
Originally Posted by Turt99 View Post
I was wondering if there was a way to edit the data in a spreadsheet layout?
You can edit in the library view by double-clicking on the entry you wish to change.
chaley is offline   Reply With Quote
 
Advertisement
Old 06-07-2010, 10:01 AM   #3
Starson17
Wizard
Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.
 
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
Quote:
Originally Posted by Turt99 View Post
since my Kobo doesn't do collections I'm looking to add the series name to the beginning of the title.

For example I've been putting

Enders Saga 01 - Enders Game
There are lots of ways to approach the problem you asked about, but are you 100% certain you want to change the title of the books in the Calibre database? Can't you just change the filename saved out via either Send to Device or Save to Disk? That's the preferred way to do this, and keeps your database correct for when you change readers. Have you looked at the Save to Device templates in Preferences | Add/Save | Send tab and in the Plugin for your e-reader? If neither of those will do it, what about sending to it as a USB disk - does your device support that?

If none of those will do it, then there are some bulk metadata options you can consider.
Starson17 is offline   Reply With Quote
Old 06-07-2010, 10:16 AM   #4
Turt99
Connoisseur
Turt99 began at the beginning.
 
Posts: 92
Karma: 14
Join Date: Apr 2010
Device: Kindle Paperwhite
Doesn't the eReader, (mine is a Kobo) just read the Metadata? I don't think changing the file name will make any difference once its loaded to the reader.

Plus as I mentioned the data isn't complete at this point so even if I'm just going to populate the Series information in the correct way (using the field in Calibre) I'm still looking at the same bulk edit issue.

Also your right it might be better to use the correct metadata information so that its clean if I switch readers at some point.
Turt99 is offline   Reply With Quote
Old 06-07-2010, 10:43 AM   #5
Starson17
Wizard
Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.
 
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
Quote:
Originally Posted by Turt99 View Post
Doesn't the eReader, (mine is a Kobo) just read the Metadata? I don't think changing the file name will make any difference once its loaded to the reader.
It probably depends on the e-reader and software. I haven't got an ereader (I use PDAs and phones) and some of my software reads the filename, and other software reads metadata.

Quote:
Plus as I mentioned the data isn't complete at this point so even if I'm just going to populate the Series information in the correct way (using the field in Calibre) I'm still looking at the same bulk edit issue.

Also your right it might be better to use the correct metadata information so that its clean if I switch readers at some point.
You'll have to decide what data you want in Calibre, but I'd lean towards correct metadata if you can get it work with your reader. As to bulk changes, what's wrong with selecting all the books you want to change and using the bulk metadata editor?
Starson17 is offline   Reply With Quote
Old 06-07-2010, 04:19 PM   #6
Turt99
Connoisseur
Turt99 began at the beginning.
 
Posts: 92
Karma: 14
Join Date: Apr 2010
Device: Kindle Paperwhite
Now that I have taken a closer look at the Bulk Metadata Editor I think it covers most of what I'm looking for. I thought at first I was just going to let me set everything the same. It looks like it does a little more then that.
Turt99 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
Editing Metadata in Bulk ballast Calibre 5 08-15-2010 04:14 PM
Performance in Bulk Metadata Changes pfooti Calibre 3 01-02-2010 08:59 PM
metadata in bulk Lorraine Froggy Calibre 1 11-14-2009 10:42 PM
Bulk Metadata Download iain_benson Calibre 1 09-29-2009 12:42 PM
Editing Metadata in Bulk Question lwpack Calibre 10 07-20-2009 12:40 AM


All times are GMT -4. The time now is 10:24 AM.


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