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 04-27-2023, 03:33 PM   #1
Dragonhomer
Junior Member
Dragonhomer began at the beginning.
 
Posts: 6
Karma: 10
Join Date: Apr 2023
Device: iPad
Question Commas in some of the Author's name fields

I am trying to clean-up my mother's Calibre - she requested that I go through and check that all the series titles are correct, that she has all the titles from that author and that I remove any author that hasn't written a book in the past 5 years.

It is quite the job, but I am doing this as a birthday present for her (at her request). But in doing this I am finding some of the authors are listed both ways - First Name Last Name as well as Last Name, First Name.

I have calibre sorting author names by first name, last name. but, for some reason, some of the author names are Last Name, First Name

I want to do a search to find the books that have the author listed as Last Name, First Name, then I can run the "Quality Check" plug in to fix those.

Tried search for , (comma space) in the Author name field - it gives me all the authors

Tried search for , (comma space) in the Author_Sort field - I get all the authors

Tried search for , (comma space) in Advanced_Search - again all the authors

Anyone have any suggestions? My mom is picky, and wants everything "correct" so she can easily move all the books from an author to her iPad. Since she has so many books in Calibre, she just moves books from one author or one series over at a time (it is easier for her this way).

Any help will be greatly appreciated.
Dragonhomer is offline   Reply With Quote
Old 04-27-2023, 04:30 PM   #2
chaley
Grand Sorcerer
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: 11,791
Karma: 7029971
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Two ways I can think of:
  • Get the Quality Check plugin. It has tools to find books with authors with and without commas.
  • A way that I prefer: use Manage Authors (right-click on Authors in the tag browser) then "filter" for comma. This will find all authors containing a comma. You can then fix them however you want, and all books with those authors will automatically be changed.
chaley is offline   Reply With Quote
Old 04-27-2023, 04:30 PM   #3
mbovenka
Wizard
mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.
 
Posts: 2,024
Karma: 13471689
Join Date: Oct 2007
Location: Almere, The Netherlands
Device: Kobo Sage
The Quality Check plugin can find them for you (Check Metadata -> Check authors with commas)
mbovenka is offline   Reply With Quote
Old 04-27-2023, 06:36 PM   #4
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: 29,984
Karma: 56143930
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 mbovenka View Post
The Quality Check plugin can find them for you (Check Metadata -> Check authors with commas)
And then it can FIX them (select first). It flips the selected.
The only time it fails is when the is a mix in {authors}
theducks is online now   Reply With Quote
Old 04-28-2023, 07:41 AM   #5
chaley
Grand Sorcerer
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: 11,791
Karma: 7029971
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by theducks View Post
And then it can FIX them (select first). It flips the selected.
The only time it fails is when the is a mix in {authors}
Note that it fixes the author for the selected book(s), not globally. It isn't hard to end up with both Joe Blogs and Blogs, Joe.
chaley is offline   Reply With Quote
Old 04-28-2023, 01:50 PM   #6
Dragonhomer
Junior Member
Dragonhomer began at the beginning.
 
Posts: 6
Karma: 10
Join Date: Apr 2023
Device: iPad
Smile


THANK YOU everyone for the assistance. Your suggestions help me get that part of the clean up done.
Dragonhomer is offline   Reply With Quote
Old 05-04-2024, 04:13 AM   #7
giannib
Junior Member
giannib began at the beginning.
 
Posts: 5
Karma: 10
Join Date: Oct 2010
Device: Android
filter not search for ,
giannib is offline   Reply With Quote
Old 05-04-2024, 04:27 AM   #8
giannib
Junior Member
giannib began at the beginning.
 
Posts: 5
Karma: 10
Join Date: Oct 2010
Device: Android
From a big import, I have many authors as Name, Surname
in manage authors this is proper in the "author sort" field, but it's wrong in the Author field
Quality check doesnt do anything
giannib is offline   Reply With Quote
Old 05-04-2024, 07:45 AM   #9
Comfy.n
want to learn what I want
Comfy.n ought to be getting tired of karma fortunes by now.Comfy.n ought to be getting tired of karma fortunes by now.Comfy.n ought to be getting tired of karma fortunes by now.Comfy.n ought to be getting tired of karma fortunes by now.Comfy.n ought to be getting tired of karma fortunes by now.Comfy.n ought to be getting tired of karma fortunes by now.Comfy.n ought to be getting tired of karma fortunes by now.Comfy.n ought to be getting tired of karma fortunes by now.Comfy.n ought to be getting tired of karma fortunes by now.Comfy.n ought to be getting tired of karma fortunes by now.Comfy.n ought to be getting tired of karma fortunes by now.
 
Posts: 1,051
Karma: 6422750
Join Date: Sep 2020
Device: Calibre E-book viewer
Quote:
Originally Posted by giannib View Post
From a big import, I have many authors as Name, Surname
in manage authors this is proper in the "author sort" field, but it's wrong in the Author field
Quality check doesnt do anything
If I understand correctly, you have:

George, Orwell - author
Douglas, Adams - author

Orwell, George - author sort
Adams, Douglas - author sort

Quality check swapping tool would give you Orwell George and Adams Douglas in author field, which you don't want.

In this case, one solution I can think of is doing a bulk metadata search and replace (do backup first the file metadata.db...) to remove the commas in the author field. Note that this will affect authors fields where there are commas placed correctly, for example in author_name_suffixes such as PhD, MD etc.

A related issue has been discussed recently here:
https://www.mobileread.com/forums/sh...d.php?t=360805

Also, you may want to check what you have in the tweak setup described in this post:
https://www.mobileread.com/forums/sh...10&postcount=5
Comfy.n is offline   Reply With Quote
Old 05-04-2024, 12:36 PM   #10
chaley
Grand Sorcerer
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: 11,791
Karma: 7029971
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by Comfy.n View Post
If I understand correctly, you have:

George, Orwell - author
Douglas, Adams - author

Orwell, George - author sort
Adams, Douglas - author sort

Quality check swapping tool would give you Orwell George and Adams Douglas in author field, which you don't want.

In this case, one solution I can think of is doing a bulk metadata search and replace (do backup first the file metadata.db...) to remove the commas in the author field. Note that this will affect authors fields where there are commas placed correctly, for example in author_name_suffixes such as PhD, MD etc.

A related issue has been discussed recently here:
https://www.mobileread.com/forums/sh...d.php?t=360805

Also, you may want to check what you have in the tweak setup described in this post:
https://www.mobileread.com/forums/sh...10&postcount=5
Assuming your hypotheses are correct, another approach would be to in "Manage authors" use the "Copy all author sort values to author" then press OK. At that point the authors would all be LN, FN (if we are understanding the OP). If desired the OP can then use Quality Check to change all the authors to FN LN.

Finally, a scan through the lines in "Manage authors" would be a good idea to be sure that there aren't any undesired consequences of the name changes.
chaley is offline   Reply With Quote
Old 05-04-2024, 02:02 PM   #11
Comfy.n
want to learn what I want
Comfy.n ought to be getting tired of karma fortunes by now.Comfy.n ought to be getting tired of karma fortunes by now.Comfy.n ought to be getting tired of karma fortunes by now.Comfy.n ought to be getting tired of karma fortunes by now.Comfy.n ought to be getting tired of karma fortunes by now.Comfy.n ought to be getting tired of karma fortunes by now.Comfy.n ought to be getting tired of karma fortunes by now.Comfy.n ought to be getting tired of karma fortunes by now.Comfy.n ought to be getting tired of karma fortunes by now.Comfy.n ought to be getting tired of karma fortunes by now.Comfy.n ought to be getting tired of karma fortunes by now.
 
Posts: 1,051
Karma: 6422750
Join Date: Sep 2020
Device: Calibre E-book viewer
Quote:
Originally Posted by chaley View Post
Assuming your hypotheses are correct, another approach would be to in "Manage authors" use the "Copy all author sort values to author" then press OK. At that point the authors would all be LN, FN (if we are understanding the OP). If desired the OP can then use Quality Check to change all the authors to FN LN.

Finally, a scan through the lines in "Manage authors" would be a good idea to be sure that there aren't any undesired consequences of the name changes.
Perfect.
Comfy.n is offline   Reply With Quote
Reply

Tags
author name format

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Fix commas in author FROM author_sort proctorius Library Management 2 12-13-2017 01:43 PM
Author and author sort fields and importing books guspasho Calibre 3 03-13-2013 11:07 PM
Is it possible to change all commas to ampersands in author column? + more... africalass Library Management 18 04-01-2011 03:06 PM
Deleting AUTHOR fields with mobi2mobi davey Kindle Formats 13 12-17-2008 05:36 AM
Problems with commas in author field when importing Halo Calibre 5 12-05-2008 12:40 AM


All times are GMT -4. The time now is 02:38 PM.


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