Register Guidelines E-Books Search Today's Posts Mark Forums Read

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

Notices

Reply
 
Thread Tools Search this Thread
Old 12-27-2019, 11:38 AM   #1
ShaunBlake
Member
ShaunBlake began at the beginning.
 
Posts: 15
Karma: 10
Join Date: May 2018
Device: Nexus 6P; Nexus 7; Windows 10
Question Unable to display ASIN in Custom Column

I found some threads regarding ASINs and tried to display them by adding a Custom Column but my column is empty. I don't know if I munged the construction or my records are missing that datum. Here's what my column looks like:
("Colum header" = "ASIN"; "Lookup name" = "#asin"; "Type" = "Column built from other colums")

I actually would like help in two areas: proper construction of such a query, and how/where ASINs are found in a book's records. If you can help with either, I will be immensely grateful and will email (or FAX, if you prefer) big hugs.
ShaunBlake is offline   Reply With Quote
Old 12-27-2019, 12:02 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: 24,861
Karma: 34300019
Join Date: Aug 2009
Location: The Central Coast of California
Device: K4NT(Fixed,New Bat.), Galaxy Tab A, Kobo Aura2
{identifiers} is the home of ASIN and others and that field is a bit different from others in that it has 2 sections: identifier type (eg ASIN, UPC ) and the identifier value)

(this is the S&R part of Bulk mode MDE)
The source setup to copy from {identifiers} is in red. (your type choices will reflect what is available in YOUR library)

My TESTLIB example used my Comments type field, (blue destination), so choose any field type that will accept your values (string)
Attached Thumbnails
Click image for larger version

Name:	Identpick.JPG
Views:	50
Size:	79.4 KB
ID:	175907  
theducks is offline   Reply With Quote
Old 12-27-2019, 04:20 PM   #3
BetterRed
null operator
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: 15,812
Karma: 18782456
Join Date: Mar 2012
Location: Sydney Australia
Device: none
This works for ISBN's:

Click image for larger version

Name:	Annotation 2019-12-28 081637.jpg
Views:	46
Size:	45.6 KB
ID:	175911

Try changing the template to {identifiers:select(asin)}

BR
BetterRed is offline   Reply With Quote
Old 12-28-2019, 02:08 PM   #4
ShaunBlake
Member
ShaunBlake began at the beginning.
 
Posts: 15
Karma: 10
Join Date: May 2018
Device: Nexus 6P; Nexus 7; Windows 10
Hi, BetterRed, thanks for helping!

Quote:
Originally Posted by BetterRed View Post
This works for ISBN's:

Try changing the template to {identifiers:select(asin)}
BR
Hmm … I'm using asin:


I used your suggestion and put the ASIN in Comments; that was successful. Nevertheless it doesn't appear in the Custom Column. Because you have it working properly, are you unable to intuit what I'm not doing or am doing wrong?

Thanks muchly for you help: I'm pleased to know that I can get the ASINs!
ShaunBlake is offline   Reply With Quote
Old 12-28-2019, 02:10 PM   #5
ShaunBlake
Member
ShaunBlake began at the beginning.
 
Posts: 15
Karma: 10
Join Date: May 2018
Device: Nexus 6P; Nexus 7; Windows 10
oops!

Quote:
Originally Posted by ShaunBlake View Post
Hmm … I'm using asin:

My cloud must have dried up!
Attached Thumbnails
Click image for larger version

Name:	Edit_cust_cols.png
Views:	53
Size:	17.6 KB
ID:	175924  
ShaunBlake is offline   Reply With Quote
Old 12-28-2019, 05:13 PM   #6
BetterRed
null operator
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: 15,812
Karma: 18782456
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Sorry I gave you a bum steer, the identifier should have been 'amazon'.

BR
BetterRed is offline   Reply With Quote
Old 12-28-2019, 05:57 PM   #7
ShaunBlake
Member
ShaunBlake began at the beginning.
 
Posts: 15
Karma: 10
Join Date: May 2018
Device: Nexus 6P; Nexus 7; Windows 10
Quote:
Originally Posted by BetterRed View Post
Sorry I gave you a bum steer, the identifier should have been 'amazon'.

BR
Well, let me cook it up—maybe cooking in a crock pot will make it okay.
ShaunBlake is offline   Reply With Quote
Old 01-03-2020, 03:05 PM   #8
ShaunBlake
Member
ShaunBlake began at the beginning.
 
Posts: 15
Karma: 10
Join Date: May 2018
Device: Nexus 6P; Nexus 7; Windows 10
Thumbs up Back in bidness!

On the 1st and 2nd I received notifications from MobilRead about new responses to my post (which were all triggered by my last update re: cooking a bum steer) and that prompted me to add one more, and a big to BetterRed.

Got my query working (thanks, Red; it was counter-intuitive) and the column populated properly. (Also got a few surprises–it's amazing what data are lurking in the metadata and book innards! And what's missing!)

Thanks to all who looked, and those who were able to contribute,
ShaunBlake is offline   Reply With Quote
Reply

Tags
asin, custom column

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using RE to extract pattern from custom column into another custom column activedirectory Library Management 1 12-15-2019 08:07 PM
Feature: custom column description to display as an hint Horus68 Library Management 6 10-18-2019 06:28 AM
Custom Column to display Virtual Libraries thinkblot Library Management 2 12-28-2016 02:09 PM
Display Custom Column at Startup MULTIVAC Calibre 6 04-21-2015 12:45 PM
Custom column to display number of chapters? crackshot91 Library Management 10 09-08-2012 04:56 PM


All times are GMT -4. The time now is 02:57 AM.


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