Swaping "titles" versus "author"

duytrung · 12-05-2014, 03:23 AM

Hi all,

I have in my portable calibre library a lot of items which the title has the name of "author" and in the author property for "title". For example, the Title column, the value appears as "Mr. Bean" and in the Author column is "In the hospital" instead of Title = "In the hospital" and Author is "Mr. Bean".

I think this caused by the automatic functionality of Calibre when dealing with the file name "Mr. Bean - In the hospital".

What can I do to massively swap (one or more of the) titles with the authors of many items so that they look better. I find in context menu but seems not available, and the import function allow to do that handle metadata seems not very flexible for that.

Kind regards

chaley · 12-05-2014, 03:25 AM

Select the books in question, press E for bulk metadata edit, ensure you are on the Basic metadata tab, check the box "Swap title and author", press OK.

eschwartz · 12-05-2014, 03:26 AM

Select all affected books, hit Edit Metadata (or the "E" shortcut key).

Check "Swap title and author" in the Bulk Edit Metadata window.

Edit: Ninjaed!

P.S. chaley, do not suggest merging all books into one!

Check your shortcut keys.

eschwartz · 12-05-2014, 03:33 AM

Also you can fix the import pattern, use author first then title.

Code:

(?P<author>.+) - (?P<title>[^_]+)

BetterRed · 12-05-2014, 03:45 AM

Nearly ninjaded too

Maybe chaley did the same kb short changes as me - E for Edit Book, M for Edit Metadata and nothing for Merge. I use Merge so infrequently it doesn't warrant a kb short, let alone an unmodified one.

BR

eschwartz · 12-05-2014, 03:52 AM

Forgive me,

I should've specified "...and check your defaults".

chaley · 12-05-2014, 04:07 AM

Quote:

Originally Posted by eschwartz

P.S. chaley, do not suggest merging all books into one!

Check your shortcut keys.

Quote:

Originally Posted by BetterRed

Maybe chaley did the same kb short changes as me - E for Edit Book, M for Edit Metadata and nothing for Merge. I use Merge so infrequently it doesn't warrant a kb short, let alone an unmodified one.

BR

Ooops.

My shortcut key is 'E', but I was thinking 'M'etadata when I wrote the post. I put M in the post even though I typed E in calibre to test it.

duytrung · 12-05-2014, 05:41 AM

Oh, wow! Thanks to Chaley, BetterRed and Eschwartz,

Calibre has so many functionalities that I don't really know. I would dedicate some time to learn that for better using of this fantastic software. By the way, what I really want to express is a function in a context menu that allow user to just choose some items and then righ-click and choose to swap.

Once again thank you very much for help :-) Have a good day!

mbovenka · 12-05-2014, 06:37 AM

Quote:

Originally Posted by eschwartz

P.S. chaley, do not suggest merging all books into one!

Check your shortcut keys.

There is a built-in safeguard on that. If you try to merge more than 3 (I think; it's someting around that) book entries, Calibre will pop up an 'Are you sure?'.

I've run into that once or twice on a particularly messy library which turned out to have multiple entries for different formats after metadata cleanup.

eschwartz · 12-05-2014, 10:10 AM

Quote:

Originally Posted by duytrung

Oh, wow! Thanks to Chaley, BetterRed and Eschwartz,

Calibre has so many functionalities that I don't really know. I would dedicate some time to learn that for better using of this fantastic software. By the way, what I really want to express is a function in a context menu that allow user to just choose some items and then righ-click and choose to swap.

Once again thank you very much for help :-) Have a good day!

Well, a shortcut key was recently added, if that helps.

Edit: "Recent",

, so recent it hasn't been released yet.
Today's release was canceled because the developer is feeling under the weather.

duytrung · 12-08-2014, 10:47 PM

Hi all, just a silly question regarding on the "author name", I recognize that there is an inconsistency in the authors in my collection. For example, "John Doe" and "Doe, John".

How to make them consistence in "Name Surname" or "Surname, Name"? Which
functionality allow user to do that automatically?

Thank you! :-D

Regards

eschwartz · 12-08-2014, 10:53 PM

Use the [GUI Plugin] Quality Check to "Check Metadata" for "authors with commas" and "invalid author sort".

You can use one of the Fix options to
swap author FN LN <--> LN, FN
when the author has a comma, and from there you can use Bulk Edit Metadata to recalculate all author_sort values, after finding the books with invalid author_sort.

12-05-2014, 03:23 AM	#1
duytrung Member Posts: 23 Karma: 10 Join Date: Jan 2013 Device: PC	Swaping "titles" versus "author" Hi all, I have in my portable calibre library a lot of items which the title has the name of "author" and in the author property for "title". For example, the Title column, the value appears as "Mr. Bean" and in the Author column is "In the hospital" instead of Title = "In the hospital" and Author is "Mr. Bean". I think this caused by the automatic functionality of Calibre when dealing with the file name "Mr. Bean - In the hospital". What can I do to massively swap (one or more of the) titles with the authors of many items so that they look better. I find in context menu but seems not available, and the import function allow to do that handle metadata seems not very flexible for that. Kind regards Last edited by duytrung; 12-05-2014 at 03:26 AM.

12-05-2014, 03:25 AM	#2
chaley Grand Sorcerer Posts: 12,383 Karma: 8012652 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	Select the books in question, press E for bulk metadata edit, ensure you are on the Basic metadata tab, check the box "Swap title and author", press OK. Last edited by chaley; 12-05-2014 at 04:04 AM. Reason: Ooops.

12-05-2014, 03:26 AM	#3
eschwartz Ex-Helpdesk Junkie Posts: 19,421 Karma: 85400180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	Select all affected books, hit Edit Metadata (or the "E" shortcut key). Check "Swap title and author" in the Bulk Edit Metadata window. Edit: Ninjaed! P.S. chaley, do not suggest merging all books into one! Check your shortcut keys. Last edited by eschwartz; 12-05-2014 at 03:28 AM.

12-05-2014, 03:33 AM	#4
eschwartz Ex-Helpdesk Junkie Posts: 19,421 Karma: 85400180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	Also you can fix the import pattern, use author first then title. Code: (?P<author>.+) - (?P<title>[^_]+)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Apple Mac now have a file extension ".iba" for the program "iBooks Author."	brucehobson	Calibre	3	09-15-2014 07:46 PM
A warning for Linux users: slow "Add Books", "Unknown" title and Author	rolgiati	Library Management	8	07-24-2013 04:36 PM
Sudden Problem with "The" and "A" Titles	Otter	Calibre	13	09-05-2010 08:32 PM

12-05-2014, 03:45 AM	#5
BetterRed null operator (he/him) Posts: 21,681 Karma: 29711016 Join Date: Mar 2012 Location: Sydney Australia Device: none	Nearly ninjaded too Maybe chaley did the same kb short changes as me - E for Edit Book, M for Edit Metadata and nothing for Merge. I use Merge so infrequently it doesn't warrant a kb short, let alone an unmodified one. BR

12-05-2014, 03:52 AM	#6
eschwartz Ex-Helpdesk Junkie Posts: 19,421 Karma: 85400180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	Forgive me, I should've specified "...and check your defaults".

12-05-2014, 05:41 AM	#8
duytrung Member Posts: 23 Karma: 10 Join Date: Jan 2013 Device: PC	Oh, wow! Thanks to Chaley, BetterRed and Eschwartz, Calibre has so many functionalities that I don't really know. I would dedicate some time to learn that for better using of this fantastic software. By the way, what I really want to express is a function in a context menu that allow user to just choose some items and then righ-click and choose to swap. Once again thank you very much for help :-) Have a good day!

12-08-2014, 10:47 PM	#11
duytrung Member Posts: 23 Karma: 10 Join Date: Jan 2013 Device: PC	Hi all, just a silly question regarding on the "author name", I recognize that there is an inconsistency in the authors in my collection. For example, "John Doe" and "Doe, John". How to make them consistence in "Name Surname" or "Surname, Name"? Which functionality allow user to do that automatically? Thank you! :-D Regards

12-08-2014, 10:53 PM	#12
eschwartz Ex-Helpdesk Junkie Posts: 19,421 Karma: 85400180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	Use the [GUI Plugin] Quality Check to "Check Metadata" for "authors with commas" and "invalid author sort". You can use one of the Fix options to swap author FN LN <--> LN, FN when the author has a comma, and from there you can use Bulk Edit Metadata to recalculate all author_sort values, after finding the books with invalid author_sort.

Advert

Advert