Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 10-29-2022, 06:27 PM   #1
jodeum
Junior Member
jodeum began at the beginning.
 
Posts: 7
Karma: 10
Join Date: Nov 2009
Device: Pocketbook Touch HD 3
Question Adding ID's in bulk

I would like to add ID's (identifiers) in bulk to multiple books at the same time. I am referring to the URL based ID's, like ISBN, Amazon, Google. Not the internal Calibre database ID.

I know there is a search and replace in the 'edit metadata in bulk' section. But that does not simply add the same ID to multiple books. That searches for one ID and then allows you to replace it. I don't see any option to just add the same ID to a selection of books at the same time.

Normally an ID will take you to a webpage for that specific book. But there are times where an author has written multiple books in a series and I'd rather not add an exact link one at a time to each entry. For instance, both Fantastic Fiction and Goodreads have a page set up for an entire series by an author. I would like to add that page link to an entire series all at once. Think Piers Anthony Xanth series, I would be perfectly happy having one link to a series page for all the books. Adding a direct book page link to each of them one at a time would get tedious, fast.

Is something like that possible? I don't see the option in edit metadata in bulk. I tried Job Spy plug in, but that doesn't really do what I'm after. And I can't really find an option in any other plugin. Even adding a custom column doesn't seem to allow me to add one based on URL type ID's, it will only pull in the same data that is currently in the id field already. Is there some other custom column option to add clickable links thereby bypassing the ID entry?
jodeum is offline   Reply With Quote
Old 10-29-2022, 07:54 PM   #2
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: 31,047
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Please use the word identifiers to avoid all confusion (of others) with {id}

identifiers:isbn is (supposed to be ) unique per book format. The same with many others.

Trying to make those into a link to series is not a great idea.

Search the internet plugin can be configured to take you to specific sites based upon certain field values. (the author might even be convinced to add series to some of those sites , but they usually are only a click away )
theducks is offline   Reply With Quote
Advert
Old 10-29-2022, 08:35 PM   #3
jodeum
Junior Member
jodeum began at the beginning.
 
Posts: 7
Karma: 10
Join Date: Nov 2009
Device: Pocketbook Touch HD 3
Quote:
Originally Posted by theducks View Post
Please use the word identifiers to avoid all confusion (of others) with {id}

identifiers:isbn is (supposed to be ) unique per book format. The same with many others.

Trying to make those into a link to series is not a great idea.
I clarified the URL based ID to avoid confusion, which seems to have worked since you knew what I was referring to. FYI: they are officially shown as ID in both the edit metadata screen, and the tag browser. Since it's literally shown that way throughout the program itself, I would assume it's not difficult to surmise what I'm talking about, especially when I further mention links to various websites.

As for making ID link to a series, I think it's a perfectly good and valid use of the field. Nowhere does it say it should be a unique link per book. Multiple books could have the same link entered without problem. Why not have them link to a single page that lists the entire series? No reason at all. That's the entire reason the ID field is customizable and can have other URL's entered for sites that aren't in the default list.
jodeum is offline   Reply With Quote
Old 10-29-2022, 10:44 PM   #4
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 45,345
Karma: 27182818
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
ids are meant to be unique to a book, so there isnt really a way to add the same id to multiple books.
kovidgoyal is offline   Reply With Quote
Old 10-30-2022, 01:57 AM   #5
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 10,970
Karma: 75337983
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
Action Chains.

Install the plugin, open Add/Modify Chains, right-click the main part of the window and import the zip file I've attached. It'll let you select multiple books and then add, e.g. url:www.mobileread.com. Be careful though-- if you already have a url id and then try to add another, it will replace it without asking.
Attached Files
File Type: zip AddIDs.zip (373 Bytes, 149 views)

Last edited by ownedbycats; 10-30-2022 at 01:59 AM.
ownedbycats is offline   Reply With Quote
Advert
Old 10-30-2022, 06:30 AM   #6
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,718
Karma: 29711016
Join Date: Mar 2012
Location: Sydney Australia
Device: none
I would do this

SETUP

1. Create a custom column to hold the link(s)

Click image for larger version

Name:	series_link.jpg
Views:	928
Size:	63.1 KB
ID:	197447

2. Set fields to exclude from metadata paste

Click image for larger version

Name:	exclude on paste.jpg
Views:	170
Size:	205.8 KB
ID:	197448

That list is not complete, e.g. I haven't put rating in the list

3. Set up copy and paste shortcuts (if not done already)

Click image for larger version

Name:	shortcuts.jpg
Views:	172
Size:	108.9 KB
ID:	197450

USAGE

1. Set up link for first book in Series

Click image for larger version

Name:	create link for first book.jpg
Views:	172
Size:	87.2 KB
ID:	197451

2. Copy metadata from first book - ctrl+c

Click image for larger version

Name:	ctrl+c.jpg
Views:	178
Size:	186.3 KB
ID:	197452

3. Select Multiple Books

Click image for larger version

Name:	select multi books.jpg
Views:	157
Size:	178.8 KB
ID:	197455

4. Paste metadata into selected books - ctrl+v

Click image for larger version

Name:	ctrl+v.jpg
Views:	164
Size:	192.8 KB
ID:	197453

5. All Done

Click image for larger version

Name:	et voila.jpg
Views:	177
Size:	209.4 KB
ID:	197454


There can be more than one link, links can be 'anything' e.g. http://, file://, calibre://, onenote://, mailto: etc



BR

Last edited by BetterRed; 10-30-2022 at 06:51 AM.
BetterRed is online now   Reply With Quote
Old 10-30-2022, 06:52 AM   #7
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,718
Karma: 29711016
Join Date: Mar 2012
Location: Sydney Australia
Device: none
↑ ↑ ↑

It would be handy to have a way of selecting the fields to be pasted at the time of doing the paste, perhaps via a list of fields with checkboxes that was saved on a per library basis.

The exclude field tweak is global, which can make it cumbersome to use with multiple libraries.

Not sure if that would be best done in the core or a plugin.

BR

Last edited by BetterRed; 10-30-2022 at 07:02 AM.
BetterRed is online now   Reply With Quote
Old 10-30-2022, 09:05 AM   #8
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: 12,444
Karma: 8012886
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
This is easy to do with bulk search & replace using template mode. Any existing URL identifier will be replaced with the one in the template.

I strongly suggest you make a backup of your library before running amok with this stuff.
Attached Thumbnails
Click image for larger version

Name:	Clipboard02.png
Views:	186
Size:	50.4 KB
ID:	197459  
chaley is offline   Reply With Quote
Reply

Tags
bulk edit metadata, identifier


Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
adding series information to the title in bulk grasim Library Management 4 05-04-2022 11:33 AM
Adding class attributes in bulk kuvera Sigil 4 03-31-2014 06:36 AM
Bulk Metadata + Adding Covers Josieb1 Library Management 2 07-31-2012 12:46 PM
Possible to change author name format when bulk adding or importing? himitsuhieki Library Management 6 08-19-2011 09:58 PM
Adding in Bulk to Library nikoleinox Library Management 3 06-13-2011 11:50 AM


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


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