Metadata create rules to transform publisher

moredrowsy · 02-29-2020, 02:09 PM

To Kovid,

I was wondering if it's possible to add another feature to create rules to transform publisher names.

I've noticed that a lot of times when I download metadata, there's so many variants of the same publisher such as: HarperCollins, HarperCollins AU, HarperCollins UK, Harper Voyager, Harper Perrennial, Harper, HarperOne, and etc. Or Tor, Tor.com, Tom Doherty Associates and etc.

There's so much clutter and I would want to consolidate all variants/imprints into one publisher whenever choose to download/update the metadata.

Thank you.

theducks · 02-29-2020, 02:45 PM

Moved OUT of development. That is for code Developer, not requests.

Not a bad idea. But... (you knew that was coming

)
Downloaded Metadata can be even more wrong

In most cases, the metadata will follow the ISBN.
It is when there is no ISBN (or it was wrong) that Calibre download guesses.

My personal preference is to put the IMPRINT into {Publisher}
Harper Voyager, Baen Fantasy, Baen SF, Baen Books (Baen Publishing Enterprises -> Baen Books. a perfect safe transform

)

BetterRed · 02-29-2020, 04:27 PM

I'd use the Manage Publishers list (click Configure at bottom of Tag Browser) to 'normalise' the names, use F2 to edit the name cells - e.g. I'd change all those "HC" variants to "Harper Collins" etc.

Best time to make metadata 'right' is at the time of adding books.

BR

DaltonST · 02-29-2020, 09:17 PM

If you can keep a spreadsheet of the "from-to" Publisher rules, then there is a tool that you can use to quickly change any "from" to the specified "to".

Job Spy has a tool named "Import CSV to Update Metadata".

https://www.mobileread.com/forums/sh...42118#poststop

See the attached image.

Simply create a spreadsheet (CSV) column named "Old Publisher", and a column named "New Publisher", and copy/past your rules into your spreadsheet. Save-As a CSV File, and import that into the above named JS Tool. "Match" on "Old Publisher", and update Publisher from "New Publisher".

Run as often as needed.

DaltonST

kovidgoyal · 02-29-2020, 09:35 PM

It;s certainly possible, but not something I am interested in personally. Patches are welcome.

02-29-2020, 02:09 PM	#1
moredrowsy Connoisseur Posts: 69 Karma: 10 Join Date: Aug 2016 Device: Kindle Paperwhite 3	Metadata create rules to transform publisher To Kovid, I was wondering if it's possible to add another feature to create rules to transform publisher names. I've noticed that a lot of times when I download metadata, there's so many variants of the same publisher such as: HarperCollins, HarperCollins AU, HarperCollins UK, Harper Voyager, Harper Perrennial, Harper, HarperOne, and etc. Or Tor, Tor.com, Tom Doherty Associates and etc. There's so much clutter and I would want to consolidate all variants/imprints into one publisher whenever choose to download/update the metadata. Thank you. Last edited by moredrowsy; 02-29-2020 at 02:11 PM.

02-29-2020, 09:17 PM	#4
DaltonST Deviser Posts: 2,265 Karma: 2090983 Join Date: Aug 2013 Location: Texas Device: none	"from-to" Publisher rules If you can keep a spreadsheet of the "from-to" Publisher rules, then there is a tool that you can use to quickly change any "from" to the specified "to". Job Spy has a tool named "Import CSV to Update Metadata". https://www.mobileread.com/forums/sh...42118#poststop See the attached image. Simply create a spreadsheet (CSV) column named "Old Publisher", and a column named "New Publisher", and copy/past your rules into your spreadsheet. Save-As a CSV File, and import that into the above named JS Tool. "Match" on "Old Publisher", and update Publisher from "New Publisher". Run as often as needed. DaltonST Attached Thumbnails

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Is there an option to transform publishers when downloading metadata?	ownedbycats	Library Management	5	10-09-2018 07:27 PM
Metadata download in different languages at the same or from a small publisher?	petzi	Library Management	13	07-23-2016 12:05 PM
Author says give ebook to others to read. Publisher says copyright rules ..	Lynx-lynx	General Discussions	53	09-03-2013 02:06 AM
Including publisher info with social metadata download	bwk	Calibre	2	01-12-2011 09:14 PM
Metadata fetch publisher preference?	adolson	Calibre	4	05-03-2010 01:07 AM

02-29-2020, 02:45 PM	#2
theducks Well trained by Cats Posts: 31,000 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Moved OUT of development. That is for code Developer, not requests. Not a bad idea. But... (you knew that was coming ) Downloaded Metadata can be even more wrong In most cases, the metadata will follow the ISBN. It is when there is no ISBN (or it was wrong) that Calibre download guesses. My personal preference is to put the IMPRINT into {Publisher} Harper Voyager, Baen Fantasy, Baen SF, Baen Books (Baen Publishing Enterprises -> Baen Books. a perfect safe transform )

02-29-2020, 04:27 PM	#3
BetterRed null operator (he/him) Posts: 21,691 Karma: 29711016 Join Date: Mar 2012 Location: Sydney Australia Device: none	I'd use the Manage Publishers list (click Configure at bottom of Tag Browser) to 'normalise' the names, use F2 to edit the name cells - e.g. I'd change all those "HC" variants to "Harper Collins" etc. Best time to make metadata 'right' is at the time of adding books. BR

02-29-2020, 09:35 PM	#5
kovidgoyal creator of calibre Posts: 45,297 Karma: 27111240 Join Date: Oct 2006 Location: Mumbai, India Device: Various	It;s certainly possible, but not something I am interested in personally. Patches are welcome.

Advert

Advert