I need to remove all subsequent (multiple) authors

sulasu · 07-05-2019, 06:28 AM

In my library i filled in multiple authors (with &), but i now see calibre/kobo have trouble with writing/reading the metadata for these books (with more than one author).

When I upload books with more than one author, calibre is in 90% of all cases not capable to match the books between device/library, so "on device" stays empty (but the books have indeed landed on my kobo aura h20. This doesn't fail allways, but a lot.

So, now i'm trying with search and replace to find the first & in author and delete all following authors (only keep the first).
But, I can't manage to get the search string right.

Who can help me?

theducks · 07-05-2019, 09:14 AM

the & you see is not really there in the relational DB.
The DB has 1 entry per author. each has an index, the book has a list of thoe indexes for authors (this is why you can fix the text of Author in the Tag browser and ALL uses get the update. You fixed the Author table, not the book)

Check in the Tag browser: Authors, to see if you have variants of the authors name (case, initials, spacing)

Get the Quality check Plugin: It can find and help Fix(make consistent) many metadata format items listed above

davidfor · 07-05-2019, 10:37 AM

@sulasu: Don't do it. Unfortunately, the way that calibre writes the authors to the book when you send it to the device is not the way the Kobo wants them. It only reads the first author. And it want multiple authors in the format "FN1 LN1, FN2 LN2". You can get calibre to set the author in the way Kobo likes it with a metadata plugboard. Set the author to:

Code:

program: raw_list('authors', ', ')

With that, calibre will match most multi-author books.

sulasu · 07-05-2019, 03:37 PM

@davidfor: too late!
I found out a workaround earlier, made a custom column #firstauthor with only the first author and then search/replace author with #firstauthor.
A bit of a shame, that i lost the multiple authors, but at least my library is consistent again.

theducks · 07-05-2019, 08:40 PM

Quote:

Originally Posted by sulasu

@davidfor: too late!
I found out a workaround earlier, made a custom column #firstauthor with only the first author and then search/replace author with #firstauthor.
A bit of a shame, that i lost the multiple authors, but at least my library is consistent again.

I made a custom column like Authors, then I used Bulk Mode S&R to move them all to the new column. Then I fixed the authors column to read xyz (ed) or <various>
There is a way... Preferences: Searching: Grouped searches: (customize Authors to include the new column). That way, when you select an author in the Tag Browser or Alt-A on a selected Author (in authors column)

07-05-2019, 06:28 AM	#1
sulasu Junior Member Posts: 3 Karma: 10 Join Date: Jul 2019 Location: Nederland Device: Kobo h20 aura	I need to remove all subsequent (multiple) authors In my library i filled in multiple authors (with &), but i now see calibre/kobo have trouble with writing/reading the metadata for these books (with more than one author). When I upload books with more than one author, calibre is in 90% of all cases not capable to match the books between device/library, so "on device" stays empty (but the books have indeed landed on my kobo aura h20. This doesn't fail allways, but a lot. So, now i'm trying with search and replace to find the first & in author and delete all following authors (only keep the first). But, I can't manage to get the search string right. Who can help me?

07-05-2019, 10:37 AM	#3
davidfor Grand Sorcerer Posts: 24,905 Karma: 47303824 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	@sulasu: Don't do it. Unfortunately, the way that calibre writes the authors to the book when you send it to the device is not the way the Kobo wants them. It only reads the first author. And it want multiple authors in the format "FN1 LN1, FN2 LN2". You can get calibre to set the author in the way Kobo likes it with a metadata plugboard. Set the author to: Code: program: raw_list('authors', ', ') With that, calibre will match most multi-author books.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiple Authors	pdurrant	Calibre	33	12-21-2017 12:37 PM
Multiple authors	AlexBell	Upload Help	2	04-17-2015 01:56 AM
Authors smart list for books with multiple authors -bug?	SergeyGomanyuk	Marvin	1	03-29-2014 04:14 AM
How do I automatically remove second and subsequent authors?	makaza	Library Management	6	05-09-2012 12:20 PM
How to specify multiple authors?	dotancohen	Calibre	2	01-08-2011 01:33 PM

07-05-2019, 09:14 AM	#2
theducks Well trained by Cats Posts: 31,048 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	the & you see is not really there in the relational DB. The DB has 1 entry per author. each has an index, the book has a list of thoe indexes for authors (this is why you can fix the text of Author in the Tag browser and ALL uses get the update. You fixed the Author table, not the book) Check in the Tag browser: Authors, to see if you have variants of the authors name (case, initials, spacing) Get the Quality check Plugin: It can find and help Fix(make consistent) many metadata format items listed above

07-05-2019, 03:37 PM	#4
sulasu Junior Member Posts: 3 Karma: 10 Join Date: Jul 2019 Location: Nederland Device: Kobo h20 aura	@davidfor: too late! I found out a workaround earlier, made a custom column #firstauthor with only the first author and then search/replace author with #firstauthor. A bit of a shame, that i lost the multiple authors, but at least my library is consistent again.

Advert

Advert