Import Author And Title From Filename & Import Other Tags And Cover From File

[DoctorOhh]

Originally Posted by DazJWood

We all like to do things different!

You're spot on with that statement.

Originally Posted by DazJWood

I would prefer to have all tags correct of course but the author and title are the priority. I would like them formatted to how I like them; which is not necessarily how they are embedded in the mobi files. Equally I don't want to lose some of the information / tags that are already on the file.

Unless I put the tags in the file myself I never want to use the tags that are in a file, instead I use the GoodReads Metadata download plugin to retrieve my as outlined in this post.

Also I never allow the metadata download process to alter the Author, Title or Series of a book, because I already put them the way I want them.

Good Reading.

[BetterRed]

Non commercial 'technical' publications often have useful tags and comments in their metadata, but incorrect title & author, and the original filename is often just a reference number. I'm thinking of public domain documents from academia, governments, think tanks, supra-nationals such as UN, IMF, EU etc. There are no 3rd party metadata sources for these publications.

For many people the 'title & author(s)' are the primary identification for their documents - so existing collections will often have file-names with accurate title and author, whilst the embedded metadata will remain untouched because without Calibre there's no convenient way to even view it - let alone get it right.

When I was initially loading Calibre with my existing collection of 'technical' publications I would have appreciated an option to take 'title & author(s)' from the file-name and the cover & other metadata from whatever was embedded in the document. I ended up adding books to a "New Books" library, taking all the metadata from the document, and then correcting the 'title & author(s)' before moving the books to the "Main" library. I still do this with all books - even real ebooks from Amazon, B&N etc.

Originally Posted by DazJWood

Incidentally, when I try to capitalize every word in the title (using Title Case), why does it not capitalize words like of, a, the, etc...?

"Title Case" like most things English, has no single authoritative definition see ===>>> http://grammar.about.com/od/grammarf...italstitle.htm

What you're asking for is more often called "Capital Case". What Calibre's Capitalize option does is more often referred to as "Sentence Case".

Other languages have different rules and conventions often maintained by government sponsored regulatory agencies - e.g. in French and German its probably defined by the Académie française and Rat für deutsche Rechtschreibung respectively

BR

[DazJWood]

Originally Posted by BetterRed

For many people the 'title & author(s)' are the primary identification for their documents - so existing collections will often have file-names with accurate title and author, whilst the embedded metadata will remain untouched because without Calibre there's no convenient way to even view it - let alone get it right.

When I was initially loading Calibre with my existing collection of 'technical' publications I would have appreciated an option to take 'title & author(s)' from the file-name and the cover & other metadata from whatever was embedded in the document. I ended up adding books to a "New Books" library, taking all the metadata from the document, and then correcting the 'title & author(s)' before moving the books to the "Main" library. I still do this with all books - even real ebooks from Amazon, B&N etc.

Yay I'm not the only one that misses this functionality!
It is frustrating that I have the information in the file names but no way of importing them unless I forgo the rest of the metadata from the file.

Originally Posted by BetterRed

"Title Case" like most things English, has no single authoritative definition see ===>>> http://grammar.about.com/od/grammarf...italstitle.htm

What you're asking for is more often called "Capital Case". What Calibre's Capitalize option does is more often referred to as "Sentence Case".

Capital Case would be a good additional option then. I name all my files and titles using capitals for the first letter of each word.

The problem is everyone wants something different!

Daz

[BetterRed]

Daz - I did suggest a possible way to do it

Originally Posted by BetterRed

Maybe one way to do it would be to extract the opf from from the MOBI with the MobiUnpack plugin and then use the from-opf option of the ebook-meta command to update the Calibre metadata with what's in the opf file - see http://manual.calibre-ebook.com/cli/ebook-meta.html. I think the MobiUnpack plug-in is a wrapper around a command line program, if you used the latter should make it simpler to write a script

Did you try it

If it works on a single book then it should be possible to write a script to execute the mobiunpack and ebook-meta commands on each book in your library to extract the metadata out of the mobi files and write it into the calibre database. As I read the from-opf option you should be able to select the metadata items you want - ie you wouldn't select the author and title.

Sorry, I can't help with the scripting - that bit of my brain died years ago.

Cheers BR

[mdb5972]

Possible suggestion:

1. Create a Custom Column text field {disk_filename}
2. Add the books via the CLI calibredb add
3. Use the calibredb add -f #{disk_filename}:{filename}
-- one at a time so will be slower
4. Use RegEx in the multiple edit to parse the custom {disk_namefield} to the Author, Title fields -- saving them for quick use next time.

This would let you leave it on 'Read metadata from file' but allow you to quickly parse the custom field to adjust the title and author.

I use custom tags like '_ADDED' (from Preferences:'Add Books' and Tweaks:'Control how tags are applied...'=True) on add books to quickly search for a subset of records that I need to process after adding new books/records. Or for command line changes to existing records set an custom yes/no updated (#ie #upd) flag to find the changed subset.


Windows: update example

FOR /F "SKIP=1 TOKENS=1,2 DELIMS=," %a in (UNPROCESSED.CSV) DO @ECHO. && @ECHO BOOK ID: %~a && ECHO ISBN : %~b && ECHO. && @IF EXIST E:\xRESULTS\%~b.opf (calibredb set_metadata --dont-notify-gui --with-library="E:\CALIBRE\WORK" -f #upd:yes %~a e:\xRESULTS\%~b.opf)


%~b cuz my export adds double-quotes around the fields; %~ strips them