07-29-2014, 02:42 AM | #16 | |
Well trained by Cats
Posts: 29,804
Karma: 54830978
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Quote:
(custom cols only link to Title) Author-> Pseudo (1-M) (includes the real name in the list) eg. Stephen King - Stephen King, Richard Bachman as well as any metadata variants of those Pseudo is related to a Real name author, not part of a single book as it is now being managed by us Title -> Pseudo or Title -> Real In reality we ARE really working with the Pen name {authors}, since all the pen name can exist there. a new table: Realname (1-M) needs to link to all the pen names in {authors} I sure can't code this. |
|
07-29-2014, 01:53 PM | #17 |
Guru
Posts: 644
Karma: 1242364
Join Date: May 2009
Location: The Right Coast
Device: PC (Calibre), Nexus 7 2013 (Moon+ Pro), HTC HD2/Leo (Freda)
|
We're dealing with one real person and multiple pen names (pseudonyms) and calling all of that one entity - an author. Trying to list this in the database exceeds calibre's (current?) functionality.
So we've defaulted to either:
If anyone can think of a 4th option I'm willing to listen. BTW, if you think this is bad, the comic and manga folks have it much worse. In many cases the Creator, Inker, Editor, Letterer, Author and Illustrator all need to be given credit! Hmm.. Wonder if it would be possible to create a search function that examined the database structure, identified all columns with names and was able to search through all of them consecutively with a single query? |
07-29-2014, 03:25 PM | #18 | |
Grand Sorcerer
Posts: 11,742
Karma: 6997045
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Quote:
Also note that the automatic user category feature of grouped search terms would create a category in the tag browser containing all the names, no matter what column they were found in. That would make it easier to find books that mention "Smith, John" in any of the illustrator, author, editor, or who-knows-what column. |
|
08-01-2014, 10:00 AM | #19 |
Zealot
Posts: 114
Karma: 6288
Join Date: Dec 2012
Device: iphone
|
For the record Chaley rocks. Thank you very much. The new column works perfect and does exactly what I wanted it to do.
Thank you. |
08-01-2014, 12:49 PM | #20 |
Connoisseur
Posts: 60
Karma: 2016606
Join Date: Apr 2012
Device: android tablets
|
I was daydreaming that a separate file that "linked" into calibre would be interesting. A file that could be shared of authors with their known pseudonyms and perhaps preferred genres.
Kind of like an old cat pedigree program I had that would link to the "shared" file to get information of the name entered "if" you wanted to. What can I say, must have been working on my library too long that day. |
08-01-2014, 12:53 PM | #21 | |
Connoisseur
Posts: 60
Karma: 2016606
Join Date: Apr 2012
Device: android tablets
|
Quote:
|
|
08-01-2014, 06:29 PM | #22 |
Zealot
Posts: 114
Karma: 6288
Join Date: Dec 2012
Device: iphone
|
By the way Chaley, now that that is working can I convince you to put in a couple of more link fields. Link2 Link3 link4. That would be great.
|
08-01-2014, 08:56 PM | #23 | |
null operator (he/him)
Posts: 20,572
Karma: 26954694
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
Quote:
And several 'authors' can link to the same folder - eg J. K. Rowling and Robert Galbraith. BR Last edited by BetterRed; 08-01-2014 at 10:38 PM. |
|
08-04-2014, 06:04 PM | #24 |
Guru
Posts: 644
Karma: 1242364
Join Date: May 2009
Location: The Right Coast
Device: PC (Calibre), Nexus 7 2013 (Moon+ Pro), HTC HD2/Leo (Freda)
|
Err... no, no it doesn't. Apparently it only works properly after I configure it, instead of reading my mind and just doing what I want automagically.
That is why I added the #psuedonym column separately rather than adding the pen name as a distinct author in and of itself (ie, theduck's method). I recognize it for the false name that it is and associate it to the book while still keeping the author's preferred name as the "primary" entity. |
|
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 05:21 AM |
Can I generate Additional Authors column which shares Authors data? | GeekyGal | Library Management | 4 | 10-04-2011 09:17 PM |
Manage Authors Dialog? | mdibella | Library Management | 7 | 02-23-2011 02:47 AM |
calibre 0.7.45 Error when trying to manage authors, etc | Bertrand | Calibre | 2 | 02-12-2011 12:23 PM |
& sign in Manage authors | bigpallooka | Calibre | 7 | 11-04-2010 06:16 PM |