Bulk-copying identifier values

[tn4w]

Hello,

I'm looking for a way to bulk-copy identifier values of selected books. I've added books with an identifier named asin.

In particular, I'd like to copy ASINs of books without a zip format with a certain keyword in the title and with a size over 20 MB. From the UI, I could successfully select books that match the following search criteria by sorting them by size.

keyword and not formats:"=zip"

However, there doesn't seem a way to bulk-copy their ASINs from the UI.

Then, I tried the calibredb list command. Not sure if formats:"!=zip" is in effect as the result seems the same with formats:"=zip".

calibredb list --search title:"keyword" identifiers:asin:true --fields identifiers,title formats:"!=zip"

Also, with the command, it is possible to specify a size?

[theducks]

Originally Posted by tn4w

Hello,

calibredb list --search title:"keyword" identifiers:asin:true --fields identifiers,title formats:"!=zip"

Also, with the command, it is possible to specify a size?

from the calibredb list doc

--fields, -f

The fields to display when listing books in the database. Should be a comma separated list of fields. Available fields: author_sort, authors, comments, cover, formats, identifiers, isbn, languages, last_modified, pubdate, publisher, rating, series, series_index, size, tags, template, timestamp, title, uuid Default: title,authors. The special field "all" can be used to select all fields. In addition to the builtin fields above, custom fields are also available as *field_name, for example, for a custom field #rating, use the name: *rating

But, isn't size really format dependent? I might see word or page count (custom column populated by the count pages PI) being of use.

You got me puzzled. ASIN (like ISBN) is a unique value assigned to an single book. How would you do BULK operations (as apposed to batch operations)?

[JSWolf]

Originally Posted by theducks

from the calibredb list doc

But, isn't size really format dependent? I might see word or page count (custom column populated by the count pages PI) being of use.

You got me puzzled. ASIN (like ISBN) is a unique value assigned to an single book. How would you do BULK operations (as apposed to batch operations)?

What he wants is something like Extract ISBN but for ASIN instead of ISBN.

But for now, ASIN extraction is a manual process.

[tn4w]

Originally Posted by JSWolf

But for now, ASIN extraction is a manual process.

Thanks for the info.

For now, I resort to a third-party SQL program. This query seems to do the job.

SELECT identifiers.val FROM books LEFT JOIN data ON books.id = data.book LEFT JOIN identifiers ON identifiers.book = books.id WHERE title LIKE '%keyword%' AND data.format IN ( 'AZW3' ) AND data.format NOT IN ( 'ZIP' ) AND data.uncompressed_size >= 20000000 AND identifiers.type = 'asin';