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-01-2010, 07:32 AM   #91
Sweetpea
Grand Sorcerer
Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.
 
Sweetpea's Avatar
 
Posts: 8,050
Karma: 22708134
Join Date: Dec 2008
Location: Krewerd
Device: AVTN8; BBMini; Onyx Boox T68; SGN8
Quote:
Originally Posted by chaley View Post
Yes, it would be possible to create a text column type that is actually an enumeration. There are, of course, complexities. The biggest is ensuring that all the places that can change the contents respect the enumeration values. This will touch metadata editing, drag & drop, the CLI (I think), and the library GUI.
Aren't there always

Quote:
Originally Posted by chaley View Post
Nope. T'is all or nothing.
I figured (but I might have overlooked something!)

Quote:
Originally Posted by chaley View Post
Thinking about it, you can get a poor-man's enumeration type using a normal and a composite column. The normal column would be used to enter the information. The composite column would use a switch statement to limit the text. For example, if the first column is integer, then the switch would test for 1, 2, etc. If the value is not one of those, it takes the default.
Hmm, that might work... Let me play with that!
Sweetpea is offline   Reply With Quote
Old 12-01-2010, 11:56 AM   #92
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,818
Karma: 1216136
Join Date: Jan 2010
Location: France
Device: Many android devices
Quote:
Originally Posted by Sweetpea View Post
Would it be possible to make a custom composite column that limits the text you can add?
Would an enumeration type that forces inclusion of the empty string be useful? In other words, would having a column that allows [one, two, three] and the empty string be of use?
chaley is offline   Reply With Quote
Old 12-02-2010, 06:40 AM   #93
Sweetpea
Grand Sorcerer
Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.
 
Sweetpea's Avatar
 
Posts: 8,050
Karma: 22708134
Join Date: Dec 2008
Location: Krewerd
Device: AVTN8; BBMini; Onyx Boox T68; SGN8
Quote:
Originally Posted by chaley View Post
Would an enumeration type that forces inclusion of the empty string be useful? In other words, would having a column that allows [one, two, three] and the empty string be of use?
Yes.

I tried the two-column layout. It works, but it's not practical. So, I'll mis-use the boolean till there's a true enumeration field
Sweetpea is offline   Reply With Quote
Old 12-02-2010, 11:38 PM   #94
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,818
Karma: 1216136
Join Date: Jan 2010
Location: France
Device: Many android devices
Quote:
Originally Posted by Sweetpea View Post
Would it be possible to make a custom composite column that limits the text you can add?

Example: I now use the "tri-state boolean" to keep track of read/to-be-read/reading books. But, I'd like to use the normal boolean for other columns. But I can't have both (or can I?).
An enumeration column type will be in the next release.

When you create the column, you specify the comma-separated list of valid values. The true list of valid values is None + the supplied list, and for this reason you cannot provide an empty value in the list. The default value for the column is None.

Last edited by chaley; 12-03-2010 at 12:00 AM. Reason: I had to put None back in to make lots of things work
chaley is offline   Reply With Quote
Old 12-03-2010, 03:00 AM   #95
Sweetpea
Grand Sorcerer
Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.Sweetpea ought to be getting tired of karma fortunes by now.
 
Sweetpea's Avatar
 
Posts: 8,050
Karma: 22708134
Join Date: Dec 2008
Location: Krewerd
Device: AVTN8; BBMini; Onyx Boox T68; SGN8
Quote:
Originally Posted by chaley View Post
An enumeration column type will be in the next release.

When you create the column, you specify the comma-separated list of valid values. The true list of valid values is None + the supplied list, and for this reason you cannot provide an empty value in the list. The default value for the column is None.
Thanks!
Sweetpea is offline   Reply With Quote
Old 12-09-2010, 12:16 PM   #96
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,818
Karma: 1216136
Join Date: Jan 2010
Location: France
Device: Many android devices
Question for you template-language users ...

I have a partial implementation of an 'advanced' template language. Before I submit it to kovid for review, I want a sanity check. I might be making something that no one else can use.

The overarching goal is to make the template language into a 'real' programming language, at least up to a point. In the current language, all items are constants. For example, the replacement in a switch statement is a constant; you can't replace the source with something computed, such as another field.

Subgoals:
1) use as much of the existing template stuff as I can
2) make it easy to parse (efficiency)
3) support sequences of expressions (aka statements)

What I have is a language where everything is a function. A constant is a function that returns itself. A name not followed by a '(' is a reference to a local variable, otherwise it is a call of a function.

An example might make the above clearer. Consider the following (which actually works but is rather silly):
Code:
{#enum:0>15s:'
  assign(a, field('title'));
  assign(b, switch(a, '[DE]', lowercase(a), $));
  b
'}
The first line (line breaks are optional) is the same as today's language. It names the field that you are working with and defines the format to apply after the template function(s) are run. The difference is that the trailing colon is followed by a single quote. This tells the template processor that the 'new style' language is being used.

The second line assigns the value of the metadata field 'title' to the local variable 'a'.

The call to 'switch' in the third line shows one difference. The first variable in a function call specifies the value that the function is to operate upon. The special local variable '$' means the initial field, in this case #enum. The second parameter is the regexp that switch is to apply. The third parameter is the value that switch will return if the regexp matches. This third parameter is a call of the function lowercase(a). The default value of the switch (no regexps match) is $ (#enum). The result of the switch will be the lowercase value in the variable 'a' if it contains either a D or an E, otherwise the value in $ (#enum). The result of switch is assigned to the variable b.

The last line simply names 'b', so that is its value. As it is the last line in the program, that is also the value of the program. Had this line been left out, the value of the assign (value of b) would be the result of the template.

Note the trailing single quote before the } character. This quote is required as a check that the expression is in the new template language.

As you can see in the example, constant strings are entered in quotes. Either single or double quotes can be used. Constants can also be numbers.

In addition to the standard functions, the extended language has:
  • cmp(x, y, lt, eq, gt) -- treating x and y as numbers, if x < y then return lt else if x == y then return eq else return gt
  • concat(x, y) -- return a string x + y (x . y in PHP)
  • field(x) -- lookup x in metadata and return that value.
  • strcmp(x, y, lt, eq, gt) -- like cmp, only treat x and y as strings
  • substr(x, start, end) -- return the start'th through the end'th characters of x. If end == 0, then use length(x).

I know that I don't have looping constructs, but I don't see any need for them.

Have I missed something important? Any comments?
chaley is offline   Reply With Quote
Old 12-09-2010, 12:21 PM   #97
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 26,346
Karma: 5382313
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
It would be nice to support negative indices for substr for "length from the end"
kovidgoyal is offline   Reply With Quote
Old 12-09-2010, 12:26 PM   #98
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,818
Karma: 1216136
Join Date: Jan 2010
Location: France
Device: Many android devices
Quote:
Originally Posted by kovidgoyal View Post
It would be nice to support negative indices for substr for "length from the end"
It does.

The result is x[start:end]. As it makes no sense for end to be zero, I used zero to indicate x[start:]. There is no ambiguity with the start field, so no hack was required.
chaley is offline   Reply With Quote
Old 12-10-2010, 03:14 PM   #99
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,818
Karma: 1216136
Join Date: Jan 2010
Location: France
Device: Many android devices
The new language will be available in the next release.
chaley is offline   Reply With Quote
Old 12-10-2010, 03:59 PM   #100
Starson17
Wizard
Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.
 
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
Quote:
Originally Posted by chaley View Post
The new language will be available in the next release.
Thanks. (I don't have an immediate use, but it's nice to know the feature is there.)
Starson17 is offline   Reply With Quote
Old 12-26-2010, 08:09 AM   #101
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,818
Karma: 1216136
Join Date: Jan 2010
Location: France
Device: Many android devices
Example of use of the new language

As an example and a test of the new language, I have implemented the last recipe in the first post in the new template language. Results are under the spoiler.

In the process I 'improved' the language a bit. The possibility to add comments, the 'program:' keyword, use of '=' for assignment, and the print function will be available in the next release (0.7.36)

Metadata: Put series into the title, using either initials or a shortened form. Strip leading articles from the series name (any) (inspired by Gary_M_Mugford)

Spoiler:
The following program produces the same results as the original recipe, using only one custom column to hold the results of a program that computes the special title value.
Code:
    Custom column: 
    Name: #special_title
    Template: (the following with all leading spaces removed)
        program:
        #	compute the equivalent of the composite fields and store them in local variables
            stripped = re(field('series'), '^(A|The|An)\s+', '');
            shortened = shorten(stripped, 4, '-' ,4);
            initials = re(stripped, '[^\w]*(\w?)[^\s]+(\s|$)', '\1');

        #	Format the series index. Ends up as empty if there is no series index.
        #	Note that leading and trailing spaces will be removed by the formatter,
        # 	so we cannot add them here. We will do that in the strcat below.
        #	Also note that because we are in 'program' mode, we can freely use
        #	curly brackets in strings, something we cannot do in template mode.
            s_index = template('{series_index:0>2.0f}');

        #	print(stripped, shortened, initials, s_index);

        #	Now concatenate all the bits together. The switch picks between 
        # 	initials and shortened, depending on whether there is a space
        #	in stripped. We then add the brackets around s_index if it is
        #	not empty. Finally, add the title. As this is the last function in
        # 	the program, its value will be returned.
            strcat(
                switch(	stripped, 
                        '.\s', initials, 
                        '.', shortened,
                        field('series')),
                test(s_index, strcat(' [', s_index, '] '), ''),
                field('title'));

    Plugboard expression:
    Template:{#special_title}
    Destination field: title
It would be possible to do the above with no custom columns by putting the program into the template box of the plugboard. However, to do so, all comments must be removed because the plugboard text box does not support multi-line editing. It is debatable whether the gain of not having the custom column is worth the vast increase in difficulty caused by the program being one giant line.
chaley is offline   Reply With Quote
Old 12-26-2010, 10:41 AM   #102
Maggie-Me
Zealot
Maggie-Me plays well with othersMaggie-Me plays well with othersMaggie-Me plays well with othersMaggie-Me plays well with othersMaggie-Me plays well with othersMaggie-Me plays well with othersMaggie-Me plays well with othersMaggie-Me plays well with othersMaggie-Me plays well with othersMaggie-Me plays well with othersMaggie-Me plays well with others
 
Maggie-Me's Avatar
 
Posts: 146
Karma: 2594
Join Date: May 2009
Device: Kindle PW,Sony 700, Sony 950 (Daily Edition),Nook Color,iPad
[QUOTE=chaley;1141585]Several people are doing interesting and useful things with templates, plugboards, and composite fields. This thread is both a request that they share what they have done and a place to put the information.

Suggestions/recipes are summarized below. Don't hesitate to post corrections and useful variants.


Sorry if this has been covered, I take it you would use plugboards to write the title of the book to device (sony in my case) where would you enter this information to say add series number to begining of book title?

Thanks
Maggie-Me is offline   Reply With Quote
Old 12-26-2010, 11:00 AM   #103
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,818
Karma: 1216136
Join Date: Jan 2010
Location: France
Device: Many android devices
Quote:
Originally Posted by Maggie-Me View Post
Sorry if this has been covered, I take it you would use plugboards to write the title of the book to device (sony in my case) where would you enter this information to say add series number to begining of book title?
There are several recipes on the first post that do variants of what you are asking for. The one that seems closest is

Metadata: Show series - series index - title, with series as initials (Sony) (inspired by speakingtohe)

If you want the full series name instead of the series as initials, then use the following in the template:
Code:
{series}{series_index:0>2s| - | - }{title}
chaley is offline   Reply With Quote
Old 12-26-2010, 11:06 AM   #104
Maggie-Me
Zealot
Maggie-Me plays well with othersMaggie-Me plays well with othersMaggie-Me plays well with othersMaggie-Me plays well with othersMaggie-Me plays well with othersMaggie-Me plays well with othersMaggie-Me plays well with othersMaggie-Me plays well with othersMaggie-Me plays well with othersMaggie-Me plays well with othersMaggie-Me plays well with others
 
Maggie-Me's Avatar
 
Posts: 146
Karma: 2594
Join Date: May 2009
Device: Kindle PW,Sony 700, Sony 950 (Daily Edition),Nook Color,iPad
Quote:
Originally Posted by chaley View Post
There are several recipes on the first post that do variants of what you are asking for. The one that seems closest is

Metadata: Show series - series index - title, with series as initials (Sony) (inspired by speakingtohe)

If you want the full series name instead of the series as initials, then use the following in the template:
Code:
{series}{series_index:0>2s| - | - }{title}
thanks for quick response, I entered that in two places... Under "Send to Device" in preference and under "Device Plug In" for Sony, but doesn't add the series number to the reader. Am I entering to the right place?

thanks
Maggie-Me is offline   Reply With Quote
Old 12-26-2010, 11:13 AM   #105
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,818
Karma: 1216136
Join Date: Jan 2010
Location: France
Device: Many android devices
Quote:
Originally Posted by Maggie-Me View Post
thanks for quick response, I entered that in two places... Under "Send to Device" in preference and under "Device Plug In" for Sony, but doesn't add the series number to the reader. Am I entering to the right place?
No.

You need to set up a plugboard (preferences -> metadata plugboards). Choose the format 'device_db', then choose the device 'PRS505' (which covers all sonys). Fill in one of the template boxes with either the line from the original recipe or the line from my post. Set the destination field to 'title'. Save the plugboard.

If metadata management is set to automatic (preferences, send to device, metadata management), then the titles will be updated the next time you connect your Sony. If metadata management is set to something else, then you must resend your books.
chaley is offline   Reply With Quote
Reply

Tags
custom column

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
custom column i need a little help shinken Calibre 3 09-15-2010 04:41 AM
Using Custom Metadata in Save Template EJvdH Calibre 1 07-02-2010 07:06 AM
Accessories Decalgirl Kindle 2 custom skin template srmalloy Amazon Kindle 6 04-09-2010 10:55 PM
Donations for Custom Recipes ddavtian Calibre 5 01-23-2010 05:54 PM
Help understanding custom recipes andersent Calibre 0 12-17-2009 03:37 PM


All times are GMT -4. The time now is 01:34 PM.


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