Bulk "set author from author sort"

fncll · 01-07-2018, 01:52 PM

How can I perform the "set author from author sort" action on many titles at once? Thanks!

theducks · 01-07-2018, 02:13 PM

one way would be to use Bulk mode Metadata edit: Search and replace (in REGEX MODE )

Search field: author_sort
Pattern (.*) <finds anything
replace field: authors
replace value: \1 <puts it here

If you have not used (and are comfortable with) Bulk mode S&R, BACKUP YOUR LIBRARY, there is no other way to undo

Graham Hurst · 02-18-2018, 06:06 PM

Hi

I too have been struggling with this, see attached jpg, I thought I was following the instructions but the result looks the same as the original.

theducks · 02-18-2018, 06:30 PM

My bad (I think. it should have worked)
(.*) says 0 or 1 of pattern
use
(.) everything

ilovejedd · 02-18-2018, 06:37 PM

(.*) is correct as that means any length from 0 or more.

(.) matches exactly one character.

Isn't the screenshot the desired outcome?

The authors will be set to Yumemakura, Baku and Young, Stuart. The original value for authors I assume is Baku Yumemakura and Stuart Young.

The left side shows the original value for author_sort. The right side shows the value that will be stored in authors. In this case, you do want them to be the same.

Graham Hurst · 02-18-2018, 06:55 PM

Sorry it's not what I'm after, I have hundreds of books where the Author field appears LN, FN but thousands where it is the right way round, what I would like is a function the same as when you edit books individually and can set author from author sort function. The attached image test is what I'm after not what it's actually doing.

theducks · 02-18-2018, 08:26 PM

Quote:

Originally Posted by Graham Hurst

Sorry it's not what I'm after, I have hundreds of books where the Author field appears LN, FN but thousands where it is the right way round, what I would like is a function the same as when you edit books individually and can set author from author sort function. The attached image test is what I'm after not what it's actually doing.

Use the Quality check Plugin
2 parts (stages)
1)Quality Check:Check metadata: <undesired Author comma>

2a) Select all results
2b)Quality Check: Fix: Swap Author...
This sets both properly, as default Author_sort rules dictate

Graham Hurst · 02-19-2018, 03:27 PM

Many thanks, think I've finally got my head on straight

01-07-2018, 01:52 PM	#1
fncll Enthusiast Posts: 34 Karma: 10 Join Date: Oct 2002 Location: AK	Bulk "set author from author sort" How can I perform the "set author from author sort" action on many titles at once? Thanks!

02-18-2018, 06:06 PM	#3
Graham Hurst Member Posts: 12 Karma: 10 Join Date: Sep 2014 Location: UK Device: Kobo Aura, Kindle Paperwhite Signature Edition	Author_sort -> Author for bulk changes Hi I too have been struggling with this, see attached jpg, I thought I was following the instructions but the result looks the same as the original. Attached Thumbnails

02-18-2018, 06:55 PM	#6
Graham Hurst Member Posts: 12 Karma: 10 Join Date: Sep 2014 Location: UK Device: Kobo Aura, Kindle Paperwhite Signature Edition	Author sort Sorry it's not what I'm after, I have hundreds of books where the Author field appears LN, FN but thousands where it is the right way round, what I would like is a function the same as when you edit books individually and can set author from author sort function. The attached image test is what I'm after not what it's actually doing. Attached Thumbnails

02-19-2018, 03:27 PM	#8
Graham Hurst Member Posts: 12 Karma: 10 Join Date: Sep 2014 Location: UK Device: Kobo Aura, Kindle Paperwhite Signature Edition	Thank you Many thanks, think I've finally got my head on straight

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Is it possible to force "Ln, Fn" for Author and Author sort?	Kuram	Kobo Reader	14	11-02-2017 12:23 AM
Bulk changing author names to author sort in tag browser	AussieTupp	Library Management	6	02-05-2017 04:22 AM
cancel the bulk overwriting of the "author" , possible or not?	lubu63	Calibre	5	10-19-2012 06:31 AM
"author" and "author sort" fields	Peter2	Library Management	0	03-09-2011 01:04 PM
"Sort By Author" not sorting correctly within author's collection	Sonist	Amazon Kindle	1	08-05-2009 07:52 PM

01-07-2018, 02:13 PM	#2
theducks Well trained by Cats Posts: 29,800 Karma: 54830978 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	one way would be to use Bulk mode Metadata edit: Search and replace (in REGEX MODE ) Search field: author_sort Pattern (.) <finds anything replace field: authors* replace value: \1 <puts it here If you have not used (and are comfortable with) Bulk mode S&R, BACKUP YOUR LIBRARY, there is no other way to undo

02-18-2018, 06:30 PM	#4
theducks Well trained by Cats Posts: 29,800 Karma: 54830978 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	My bad (I think. it should have worked) (.*) says 0 or 1 of pattern use (.) everything

02-18-2018, 06:37 PM	#5
ilovejedd hopeless n00b Posts: 5,111 Karma: 19597086 Join Date: Jan 2009 Location: in the middle of nowhere Device: PW4, PW3, Libra H2O, iPad 10.5, iPad 11, iPad 12.9	(.*) is correct as that means any length from 0 or more. (.) matches exactly one character. Isn't the screenshot the desired outcome? The authors will be set to Yumemakura, Baku and Young, Stuart. The original value for authors I assume is Baku Yumemakura and Stuart Young. The left side shows the original value for author_sort. The right side shows the value that will be stored in authors. In this case, you do want them to be the same.

Advert

Advert