Award management

fvzwieten · 07-30-2012, 03:42 AM

Hi,

I am an avid SF literature reader and collector. I am managing all my e-books with Calibre. In the SF scene there are quite a few awards to be won. The 2 most well known are the Nebula and the Hugo awards, but there are plenty more. I would like to put this info into Calibre, but I am having a hard time on how to do this. A book can be "nominated" or "have won" an award, in a certain category (Novel, Novelette, Novella, Short Story) and in a certain year. All awards agree on the category, so I made a seperate column with fixed values for that. However, there could be a situation like this:

Won the "Nebula" Award for best "Novel" in "1987"
Won the "Hugo" Award for best "Novel" in "1988"
Nominated the "Arthur C. Clark" Award for best "Novel" in "1987"

Typically, an award has a number of nominees, and one or sometimes two win the award in a certain year.

Now, how to put all this into Calibre is the task at hand!

davidfor · 07-30-2012, 10:10 AM

Two things came to my mind with this:

- Use a series-like column. So a series could be "Nebula for Novel" with the year used as the series index. The decimal could be used to indicate the winner and nominees. The problem with this is what to do with multiple award winners.

- The other way is to use a tag type column. In this case, the tags would be hierarchical. So, "Nebula.Novel.1987" and "Hugo.Novel.1988". For the nominees, maybe "Nebula.Novel.1987.Nominee". With this, you can search for any part of the tag and the tag browser can show these as a hierarchy.

I sort of like the first one, but I think the second is more flexible and extendable.

fvzwieten · 07-30-2012, 11:54 AM

I like the second one. I made a custom field called Awards and made it hierarchical. Works nice. Now struggeling with searching in it. How to search for all Nebula Winners when the structure is "Nebula.1988.Winner"? I read about regexp but can't seem to get it right.

davidfor · 07-30-2012, 08:03 PM

The following found all Hugos for 1985 for my small test set.

Quote:

#awards:"Hugo" and #awards:"1985"

So, try:

Quote:

#awards:"Nebula" and #awards:"Winner"

chaley · 07-31-2012, 02:52 AM

Quote:

Originally Posted by fvzwieten

I like the second one. I made a custom field called Awards and made it hierarchical. Works nice. Now struggeling with searching in it. How to search for all Nebula Winners when the structure is "Nebula.1988.Winner"? I read about regexp but can't seem to get it right.

The easiest way to learn how to build searches on hierarchical columns is to use the tag browser. It will show you the syntax to do a full match and to match items in the front of the hierarchy. For example, in your case click on the "1988" in the Awards section of the tag browser. Each click will show you a different search. IIRC: there will be 5.

There is one search that the tag browser doesn't show: how to search for an internal match. For example, to find all 1988 regardless of the award, use

Code:

#award:=..1988

Note the 2 periods. One period there means that the text must be a prefix. Two periods means that the text must match an internal item in the hierarchy. The equals means it must match the entire prefix or item.

To summarize: to find all Nebula winners (not runner-up or whatever else there can be) use:

Code:

#award:=.Nebula and #award:=..Winner

fvzwieten · 07-31-2012, 03:51 AM

Both solutions work well. Thank you very much!

Just out of curiousity: Would it be possible to have some sort of positional search, where the position in the hierarchy is part of the search criteria. Also wildcarding is would be nice. Someting like #award:="Nebula.20*.Winner". This would then give all Nebula Winners from the last century.

chaley · 07-31-2012, 03:59 AM

Quote:

Originally Posted by fvzwieten

Both solutions work well. Thank you very much!

Just out of curiousity: Would it be possible to have some sort of positional search, where the position in the hierarchy is part of the search criteria. Also wildcarding is would be nice. Someting like #award:="Nebula.20*.Winner". This would then give all Nebula Winners from the last century.

The first one, positional searches, is only possible using regular expressions. The second, wildcarding, also can be done with regular expression searches. For example, your search would be written

Code:

#award:"~^Nebula\.20.*\.Winner$"

fvzwieten · 07-31-2012, 10:32 AM

Great! Thank you all for your help!

07-30-2012, 03:42 AM	#1
fvzwieten Junior Member Posts: 5 Karma: 478 Join Date: Dec 2010 Device: Bebook Neo	Award management Hi, I am an avid SF literature reader and collector. I am managing all my e-books with Calibre. In the SF scene there are quite a few awards to be won. The 2 most well known are the Nebula and the Hugo awards, but there are plenty more. I would like to put this info into Calibre, but I am having a hard time on how to do this. A book can be "nominated" or "have won" an award, in a certain category (Novel, Novelette, Novella, Short Story) and in a certain year. All awards agree on the category, so I made a seperate column with fixed values for that. However, there could be a situation like this: Won the "Nebula" Award for best "Novel" in "1987" Won the "Hugo" Award for best "Novel" in "1988" Nominated the "Arthur C. Clark" Award for best "Novel" in "1987" Typically, an award has a number of nominees, and one or sometimes two win the award in a certain year. Now, how to put all this into Calibre is the task at hand!

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Everything You Need to Know about the Hugo Award	jgaiser	General Discussions	6	05-15-2012 10:35 AM
Touch BookLover award	Mithradyr	Kobo Reader	15	08-11-2011 12:50 AM
Hugo award nominiees	ernietd	Deals and Resources (No Self-Promotion or Affiliate Links)	0	10-28-2008 07:45 PM

07-30-2012, 10:10 AM	#2
davidfor Grand Sorcerer Posts: 24,907 Karma: 47303748 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	Two things came to my mind with this: - Use a series-like column. So a series could be "Nebula for Novel" with the year used as the series index. The decimal could be used to indicate the winner and nominees. The problem with this is what to do with multiple award winners. - The other way is to use a tag type column. In this case, the tags would be hierarchical. So, "Nebula.Novel.1987" and "Hugo.Novel.1988". For the nominees, maybe "Nebula.Novel.1987.Nominee". With this, you can search for any part of the tag and the tag browser can show these as a hierarchy. I sort of like the first one, but I think the second is more flexible and extendable.

07-30-2012, 11:54 AM	#3
fvzwieten Junior Member Posts: 5 Karma: 478 Join Date: Dec 2010 Device: Bebook Neo	I like the second one. I made a custom field called Awards and made it hierarchical. Works nice. Now struggeling with searching in it. How to search for all Nebula Winners when the structure is "Nebula.1988.Winner"? I read about regexp but can't seem to get it right.

07-31-2012, 03:51 AM	#6
fvzwieten Junior Member Posts: 5 Karma: 478 Join Date: Dec 2010 Device: Bebook Neo	Both solutions work well. Thank you very much! Just out of curiousity: Would it be possible to have some sort of positional search, where the position in the hierarchy is part of the search criteria. Also wildcarding is would be nice. Someting like #award:="Nebula.20*.Winner". This would then give all Nebula Winners from the last century.

07-31-2012, 10:32 AM	#8
fvzwieten Junior Member Posts: 5 Karma: 478 Join Date: Dec 2010 Device: Bebook Neo	Great! Thank you all for your help!