sonybookid: identifier defunct?

[Vortex]

I'm trying to clean up the identifiers in my libraries, get them down to just the ones that work as links from under 'Ids:' on the book details panel. I have a load of books with just sonybookid identifiers in the format:

sonybookid:CBUSCEHCH026HH0F

I see the Sony ebook store closed down and was taken over by Kobo. Can these identifiers be converted to something that works, or will I have to run the metadata download to find working identifiers for them?
Thanks.

[theducks]

Working identifiers? You have metadata. The fact that Sony closed stores does not invalidate existing metadata.


identifiers is a index (catalog number) of specific sources found (used) to generate what you see, or log additional sources. indicated identifiers will restrict data collection to those with matches. A typical one is ISBN.

blank = search for anything

theducks:B42 would be a valid (but totally bogus ) identifiers entry that could indicate a shelf location in a personal Library

[Vortex]

Sorry, I thought that was clear.

I'm trying to clean up the identifiers in my libraries, to get them down to just the ones that work as links from 'Ids:' on the book details panel. For example, the identifier: goodreads:5470 shows as 'Goodreads' on the book details panel on the righthand side of Calibre under the cover image where it says:

Ids: Goodreads

If you click where it says Goodreads it opens this link in your browser:

https://www.goodreads.com/book/show/5470.1984

The sonybookid identifiers don't show up under Ids:, and the site is gone, so I'm just trying to ascertain whether they are of any use before I remove them. I would just run 'Download Metadata & Covers' but it invariably makes mistakes so I have to manually check every one, and I'd rather not.

[BetterRed]

@Vortex - you should be able to replace those sonybookid IDs with nothing in Bulk Metadata Edit->Search and Replace using a regular expression

As always take care with using regex's in Bulk S&R. Before using it on the backed-up target library, I would first test the regex on a small recoverable Test library.

BR

[theducks]

Originally Posted by BetterRed

@Vortex - you should be able to replace those sonybookid IDs with nothing in Bulk Metadata Edit->Search and Replace using a regular expression

As always take care with using regex's in Bulk S&R. Before using it on the backed-up target library, I would first test the regex on a small recoverable Test library.

BR

FWIW
I could not get it (the nothing part) to work for me when I went to try so I could write a detailed instruction
Search Identifiers check
Identifier type: <type selected> check
Search Pattern .+ check

OK Braaap
Destination field Identifiers Braaap

It wants an identifier type none is not a choice

[BetterRed]

Originally Posted by theducks

It wants an identifier type none is not a choice

Hmmm... then I can only think of backdoor ways to do it.

I didn't try to do it myself, a) I couldn't figure a way to search for a specific ID type and b) my regex cheat sheets weren't at hand.

BR

[chaley]

Originally Posted by theducks

FWIW
I could not get it (the nothing part) to work for me when I went to try so I could write a detailed instruction
Search Identifiers check
Identifier type: <type selected> check
Search Pattern .+ check

OK Braaap
Destination field Identifiers Braaap

It wants an identifier type none is not a choice

I just tried it and it works fine.

The trick is to set the id to an empty value. That removes it. Here is an example screen capture:

[Vortex]

I just tried a Google search for "sonybookid". LOL, this thread is the first thing in the list of results. I guess that's why no one seems to be able to answer my question...

The only identifiers I have had a problem removing (or editing) are the double-barrel type ones, like:

uri:http:
urn:http:
urn:urn:
urn:uuid:
urn:isbn:
etc, etc.

Only way you can do anything with them is to convert the second colon to a Vertical Bar character '|'. Like this:

uri:http|

Is there any regex I can use to mass convert any second Colon in any identifier (in any position in a list) to a Vertical Bar?
Thanks.

[theducks]

Originally Posted by chaley

I just tried it and it works fine.

The trick is to set the id to an empty value. That removes it. Here is an example screen capture:

Ah
Another Press 'Start'