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 07-24-2014, 03:52 PM   #1
tarisea
Connoisseur
tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.
 
Posts: 85
Karma: 6288
Join Date: Dec 2012
Device: iphone
Manage Authors Link Column

In Metadata there is a link to Manage Authors that has Author, Author Sort and Link. How do I create a custom column to show whatever I put in the Link column. I don't want to put a url in there just a reference word.

Can I create the custom column showing the Link column?

Thanks
tarisea is offline   Reply With Quote
Old 07-24-2014, 05:22 PM   #2
BookJunkieLI
Addict
BookJunkieLI could sell banana peel slippers to a Deveel.BookJunkieLI could sell banana peel slippers to a Deveel.BookJunkieLI could sell banana peel slippers to a Deveel.BookJunkieLI could sell banana peel slippers to a Deveel.BookJunkieLI could sell banana peel slippers to a Deveel.BookJunkieLI could sell banana peel slippers to a Deveel.BookJunkieLI could sell banana peel slippers to a Deveel.BookJunkieLI could sell banana peel slippers to a Deveel.BookJunkieLI could sell banana peel slippers to a Deveel.BookJunkieLI could sell banana peel slippers to a Deveel.BookJunkieLI could sell banana peel slippers to a Deveel.
 
Posts: 281
Karma: 3136
Join Date: Jan 2010
Location: Long Island
Device: Nook, REB 1100, Ebookwise 1500, Jb-Lite, PRS-650, PB302, Asus T-90MT
I can't get into calibre at the moment to check for sure but I'm fairly certain the answer is yes.

You would create a custom column using the 'Column built from other columns' type and then either the 'contains' or the 'test' function.

It would look something along the lines of:

Code:
{column:test(Link,No Link)}
or
Code:
{column:contains(value,Link,No Link)}
Change the bold text for the appropriate column/values. I suspect the 'test' function is what you want as it's a true/false value while 'contains' expects to match a certain pattern. You can read more about them here:
http://manual.calibre-ebook.com/temp...l#if-then-else

http://manual.calibre-ebook.com/temp...-function-mode
BookJunkieLI is offline   Reply With Quote
 
Advertisement
Old 07-24-2014, 08:41 PM   #3
tarisea
Connoisseur
tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.
 
Posts: 85
Karma: 6288
Join Date: Dec 2012
Device: iphone
I think you misunderstand. I want it to show whatever is in the column. much the same way that author_sort is. I have set up a new column with "column built from other columns and {Link} but it doesn't work. I also tried {author_link} neither one works. What field will it recognize?
tarisea is offline   Reply With Quote
Old 07-24-2014, 09:35 PM   #4
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: 4,035
Karma: 2925589
Join Date: Mar 2012
Location: NSW Australia
Device: none
Quote:
Originally Posted by tarisea View Post
I think you misunderstand. I want it to show whatever is in the column. much the same way that author_sort is. I have set up a new column with "column built from other columns and {Link} but it doesn't work. I also tried {author_link} neither one works. What field will it recognize?
@tarisea - Maybe that field is not exposed - see calibredb list command

BR
BetterRed is offline   Reply With Quote
Old 07-24-2014, 10:32 PM   #5
theducks
Grand Sorcerer
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: 15,292
Karma: 6022733
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by BetterRed View Post
@tarisea - Maybe that field is not exposed - see calibredb list command

BR
IIRC that field is only available through Manage.
theducks is offline   Reply With Quote
Old 07-24-2014, 11:00 PM   #6
tarisea
Connoisseur
tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.
 
Posts: 85
Karma: 6288
Join Date: Dec 2012
Device: iphone
ok if I can't use that can anyone make another suggestion. Basically I just want to assign each author one of 3 of four categories. and I have a lot of authors so I only want to do it once. if i had been able to use link I could have just put the category there, that way every time I added a John Sandford novel it would have automatically populated the custom column I would have created with FICTION.

Any ideas?
tarisea is offline   Reply With Quote
Old 07-24-2014, 11:19 PM   #7
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: 4,035
Karma: 2925589
Join Date: Mar 2012
Location: NSW Australia
Device: none
@tarisea - Maybe you could make use of the User Category feature, you could create a category (fiction) and populate it with fiction writers, and another (script writers) with playwrights, screen writers etc.

You get to it via Alter Tag Browser->Manage Authors tags etc->Manage User categories. See Tag Browser for doco.

Added : And I just stumbled on this related plug-in ==>> [GUI Plugin]User Category

BR

Last edited by BetterRed; 07-25-2014 at 12:13 AM.
BetterRed is offline   Reply With Quote
Old 07-25-2014, 12:51 AM   #8
tarisea
Connoisseur
tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.
 
Posts: 85
Karma: 6288
Join Date: Dec 2012
Device: iphone
this would work if i can create a custom column that displays what user category it is in. can it be done?
tarisea is offline   Reply With Quote
Old 07-25-2014, 01:58 AM   #9
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: 4,035
Karma: 2925589
Join Date: Mar 2012
Location: NSW Australia
Device: none
Quote:
Originally Posted by tarisea View Post
this would work if i can create a custom column that displays what user category it is in. can it be done?
@tarisea - Not sure, but my guess is no.

A 'standard' category item (author, publisher etc) can be in more than one user category. Example Kerstin Ekman could be in the Crime and Favourites User Categories.

Maybe one of the template genii can some up with some trick.

You can create VLs based on User Categories - @<user_cat_name>:true.

You could request an enhancement that the author_link field be exposed as a column you can use in a column template - like author_sort.

BR
BetterRed is offline   Reply With Quote
Old 07-25-2014, 07:59 AM   #10
chaley
"chaley", not "charley"
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: 5,923
Karma: 1673776
Join Date: Jan 2010
Location: France
Device: Many android devices
I added a new formatter function "author_links()". It probably will be in next week's release.

The documentation for the function is:
Quote:
author_links(val_separator, pair_separator) -- returns a string containing a list of authors and that author's link values in the form author1 val_separator author1link pair_separator author2 val_separator author2link etc. An author is separated from its link value by the val_separator string with no added spaces. author:linkvalue pairs are separated by the pair_separator string argument with no added spaces. It is up to you to choose separator strings that do not occur in author names or links. An author is included even if the author link is empty.
You would use this new function in a composite column (col built from other cols). In your case where the links are really lists of keywords separated by (I assume) commas, the following template would strip the author names then merge all the keywords into a single list, removing duplicates. I don't know if that is what you want.
Code:
program: 
	list_union(
		'', 
		re(
			list_re(author_links(':', ' & '),
				' & ', 
				'^.*:(.)', 
				'\1'), 
			'&', 
			','),
		',')
EDIT: the new function is in source now and will be in the next calibre release.

EDIT2: If you are up to making a python custom template function, the map from author to the associated link is "mi.author_link_map".

Last edited by chaley; 07-25-2014 at 10:30 AM. Reason: edit: fix when probably available. I thought today was Thursday.
chaley is offline   Reply With Quote
Old 07-25-2014, 10:50 AM   #11
tarisea
Connoisseur
tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.
 
Posts: 85
Karma: 6288
Join Date: Dec 2012
Device: iphone
chaley thank you for your response. when I used your program I got the error:

EXCEPTION: Formatter: unknown function author_links near author_links

What I want is so simple. I have over 500 authors. I want to be able to divide them into 4 or 5 categories and have a column that shows what category they are in without having to manually add every book.

eg. every time I add a John Grisham boom the column should automatically say "ReadList". Jodi Picoult "MyAuthors". Ann Rice "MyAuthors". The first time I add a new author I will assign it but after that it should be automatic.

So whether it is putting the Category in the Manage Authors Links column:

Author: John Grisham
Author Sort: Grisham, John
Link: ReadList

Author: Jodi Picoult
Author Sort: Picoult, Jodi
Link: MyAuthors

And then a column made from other columns that shows the Link column

or

The User Category plugin that I can add the Authors to and then have a column that will show the User Category that the author belongs to.

or something else entirely.

Please there has to be a way. Help

Thanks
tarisea is offline   Reply With Quote
Old 07-25-2014, 11:00 AM   #12
chaley
"chaley", not "charley"
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: 5,923
Karma: 1673776
Join Date: Jan 2010
Location: France
Device: Many android devices
Quote:
Originally Posted by tarisea View Post
chaley thank you for your response. when I used your program I got the error:

EXCEPTION: Formatter: unknown function author_links near author_links
The function was added to calibre today. Unless you run from source it won't be available to you until next week.
Quote:
What I want is so simple. I have over 500 authors. I want to be able to divide them into 4 or 5 categories and have a column that shows what category they are in without having to manually add every book.

eg. every time I add a John Grisham boom the column should automatically say "ReadList". Jodi Picoult "MyAuthors". Ann Rice "MyAuthors". The first time I add a new author I will assign it but after that it should be automatic.

So whether it is putting the Category in the Manage Authors Links column:

Author: John Grisham
Author Sort: Grisham, John
Link: ReadList

Author: Jodi Picoult
Author Sort: Picoult, Jodi
Link: MyAuthors

And then a column made from other columns that shows the Link column

or

The User Category plugin that I can add the Authors to and then have a column that will show the User Category that the author belongs to.

or something else entirely.

Please there has to be a way. Help

Thanks
I have built a solution for you. As I said, it will be in next week's calibre release.

If you want to do something *right now* then you can build a custom template function (Preferences / Advanced / Template Functions). The function would have access to the underlying data (the author -> author link map) from which you can extract the info and format it however you want.

Do note that you have never specified what should happen if there is more than one author. I assumed that you would want to merge the information.
chaley is offline   Reply With Quote
Old 07-28-2014, 08:04 PM   #13
Inferno
Connoisseur
Inferno began at the beginning.
 
Posts: 58
Karma: 10
Join Date: Apr 2012
Device: android tablets
Not quite the same but similar, I wish there was a way for authors to link to their alias without having to put "author name a & author aka name". eg "Stephen King & Richard Bachman"

While I have done that for many authors (it helps when looking for books by that author) it becomes horridly complicated when some authors have four and even more aka's.
Inferno is offline   Reply With Quote
Old 07-28-2014, 08:52 PM   #14
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: 4,035
Karma: 2925589
Join Date: Mar 2012
Location: NSW Australia
Device: none
@Inferno - I add a '*' onto the end of the pseudonym name. Thus The Cuckoo's Calling has Robert Galbraith * as its author, in the Author Link for Robert Galbraith * I have the URL to my 'AuthorInfo/J. K. Rowling' folder.

The '*' tells me its a pseudonym, the author link tells me the 'real' name.

Maybe if Author ends in '*' I can extract the 'name' from chaley's new author_links() function into a new '#pseudonym' custom column - e.g. 'J. K. Rowling' from 'file:///E:/Calibre%20Libraries/TestInfo/AuthorInfo/J.%20K.%20Rowling/'.

BR
BetterRed is offline   Reply With Quote
Old 07-29-2014, 02:47 AM   #15
Sabardeyn
Guru
Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.
 
Sabardeyn's Avatar
 
Posts: 630
Karma: 1242364
Join Date: May 2009
Location: The Right Coast
Device: PC (Calibre), Nexus 7 2013 (Moon+ Pro), HTC HD2/Leo (Freda)
Hmm... I created a custom column #pseudonym in which I list any pen names the author released the story under.
Sabardeyn is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Suggestion: Add filter to manage tags, authors etc. Peter Walters Library Management 6 04-04-2012 06:21 AM
Can I generate Additional Authors column which shares Authors data? GeekyGal Library Management 4 10-04-2011 10:17 PM
Manage Authors Dialog? mdibella Library Management 7 02-23-2011 03:47 AM
calibre 0.7.45 Error when trying to manage authors, etc Bertrand Calibre 2 02-12-2011 01:23 PM
& sign in Manage authors bigpallooka Calibre 7 11-04-2010 07:16 PM


All times are GMT -4. The time now is 06:18 AM.


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