Remove data from 'publisher' list

rbruce1314 · 01-31-2016, 02:41 AM

A simple but obscure problem.

When I open any metadata page in my library and go to the 'publisher' box, I have acquired over the years a huge long list including duplicates, errors, phantoms and goodness knows what else. I want to edit this list, deleting all surplus.

I have tried editing from the page itself but none of the delete/ctrl+delete/shift+delete/ctrl+ back etc. seem to work..........SO where can I find the list in my calibre program/application data files? I've looked in all the obvious places but if it's in any of those I've missed it!

Can someone point me in the right direction please?

Thanks

(totally irrelevant I guess, but I can get to the search/replace file in Sigil to edit it with no problem at all!!).

eschwartz · 01-31-2016, 02:55 AM

Um, I assume you mean the per-book Edit Metadata popup.
A single book can't have multiple publishers, but you can edit that box -- it is a regular text field...

If you want to clean up junk publishers across your whole library, you can rename a publisher or delete it by right-clicking the name in the Tag Browser. Or selecting multiple books at once and using Bulk Edit Metadata.

Metadata that no longer matches any book in your calibre library, is automatically cleaned.

theducks · 01-31-2016, 10:22 AM

As eschwartz said. The list is self cleaning.

To correct variations there are 2 ways:

1) Open the Tag Browser to the Publisher. Right click: Rename. That will adjust the saved setting for all affected books. If the New Name exists, they will be merged into that entry.

2)Using the Tag Browser to Multi Select a group of Publisher with variations in their name: Select all Results: Bulk Metadata Edit and set the Publisher to what you want. (This assumes that Search is set to only show results)

rbruce1314 · 02-01-2016, 12:55 AM

Thanks for those answers guys - but obviously I haven't made myself clear!

It's not the books themselves that are the problem, but the drop-down publisher (choice) list in the metadata box - it's so cluttered it's getting a pain to use, and is often quicker to type in from scratch if near the end of the alphabet!

Does that make sense??

eschwartz · 02-01-2016, 01:59 AM

That choices list is dynamically created, from all the publishers of all your books.

How is calibre supposed to know which ones are real and which ones aren't, if YOU don't fix the incorrect ones?

Again, you can rename publishers from the Tag Browser, this will let you merge the duplicates etc.
Or just live with the incorrect publisher in one book corrupting the dropdown choices in another book.

rbruce1314 · 02-01-2016, 04:13 AM

Quote:

Originally Posted by eschwartz

That choices list is dynamically created, from all the publishers of all your books.

It's dynamic is it? Never knew that!

So......that means that all my so-called 'useless' ones are in fact actually lurking somewhere in the depths of years ago.....

Hhmm....... thanks for that. Some tracking back to do then

theducks · 02-01-2016, 10:56 AM

Quote:

Originally Posted by rbruce1314

It's dynamic is it? Never knew that!

So......that means that all my so-called 'useless' ones are in fact actually lurking somewhere in the depths of years ago.....

Hhmm....... thanks for that. Some tracking back to do then

Do you have a Filter or VL in place?

Have you been Bad and deleted books using the OS? Time to run Library Maintenance and correct those things

BTW Anything on the those pulldown lists should ALSO show in the Tag Browser

rbruce1314 · 02-02-2016, 01:12 AM

Thanks both - this post should close the thread.

I did exactly as you advised and after a quite satisfying time have a much cleaner publisher library.

And more praise to Kovid - every time I ask something on here I find out Calibre is even more sophisticated than I previously thought. Honour and respect to Mr. Goyal.

Thanks again - problem solved!!

01-31-2016, 02:41 AM	#1
rbruce1314 Groupie Posts: 179 Karma: 1021404 Join Date: Apr 2010 Location: Stroud, UK Device: Xgody tablet, LG G3 (Android), moon+reader	Remove data from 'publisher' list A simple but obscure problem. When I open any metadata page in my library and go to the 'publisher' box, I have acquired over the years a huge long list including duplicates, errors, phantoms and goodness knows what else. I want to edit this list, deleting all surplus. I have tried editing from the page itself but none of the delete/ctrl+delete/shift+delete/ctrl+ back etc. seem to work..........SO where can I find the list in my calibre program/application data files? I've looked in all the obvious places but if it's in any of those I've missed it! Can someone point me in the right direction please? Thanks (totally irrelevant I guess, but I can get to the search/replace file in Sigil to edit it with no problem at all!!).

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Undo bulk metadata edit (remove data in a field)?	rebl	Library Management	7	08-25-2014 07:18 PM
Easier way to remove repeating data in books?	Dullahir	Calibre	5	03-15-2013 08:43 PM
Output list of tag-item data?	unboggling	Library Management	0	09-20-2011 08:23 AM
Office 2003/XP Add-in: Remove Hidden Data	Alexander Turcic	Lounge	0	01-07-2004 05:09 AM

01-31-2016, 02:55 AM	#2
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)	Um, I assume you mean the per-book Edit Metadata popup. A single book can't have multiple publishers, but you can edit that box -- it is a regular text field... If you want to clean up junk publishers across your whole library, you can rename a publisher or delete it by right-clicking the name in the Tag Browser. Or selecting multiple books at once and using Bulk Edit Metadata. Metadata that no longer matches any book in your calibre library, is automatically cleaned.

01-31-2016, 10:22 AM	#3
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	As eschwartz said. The list is self cleaning. To correct variations there are 2 ways: 1) Open the Tag Browser to the Publisher. Right click: Rename. That will adjust the saved setting for all affected books. If the New Name exists, they will be merged into that entry. 2)Using the Tag Browser to Multi Select a group of Publisher with variations in their name: Select all Results: Bulk Metadata Edit and set the Publisher to what you want. (This assumes that Search is set to only show results)

02-01-2016, 12:55 AM	#4
rbruce1314 Groupie Posts: 179 Karma: 1021404 Join Date: Apr 2010 Location: Stroud, UK Device: Xgody tablet, LG G3 (Android), moon+reader	Thanks for those answers guys - but obviously I haven't made myself clear! It's not the books themselves that are the problem, but the drop-down publisher (choice) list in the metadata box - it's so cluttered it's getting a pain to use, and is often quicker to type in from scratch if near the end of the alphabet! Does that make sense??

02-01-2016, 01:59 AM	#5
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)	That choices list is dynamically created, from all the publishers of all your books. How is calibre supposed to know which ones are real and which ones aren't, if YOU don't fix the incorrect ones? Again, you can rename publishers from the Tag Browser, this will let you merge the duplicates etc. Or just live with the incorrect publisher in one book corrupting the dropdown choices in another book.

02-02-2016, 01:12 AM	#8
rbruce1314 Groupie Posts: 179 Karma: 1021404 Join Date: Apr 2010 Location: Stroud, UK Device: Xgody tablet, LG G3 (Android), moon+reader	Thanks both - this post should close the thread. I did exactly as you advised and after a quite satisfying time have a much cleaner publisher library. And more praise to Kovid - every time I ask something on here I find out Calibre is even more sophisticated than I previously thought. Honour and respect to Mr. Goyal. Thanks again - problem solved!!

Advert

Advert