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 02-05-2011, 08:08 AM   #1
Jabby
Jr. - Junior Member
Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.
 
Posts: 586
Karma: 2000358
Join Date: Aug 2010
Location: Alabama
Device: Archos, Asus, HP, Lenovo, Nexus and Samsung tablets in 7,8 and 10"
Question about creating columns

I think I posted this in the wrong forum earlier. I'll try again.

I am trying to find a way to create a column that will hold and display the author's last name only. I created such a column but I have to hand enter the name. I use this to create my download file name, (Poe-Raven, The.epub)

I would also like to know how I can get the new title_sort field to display as a column and also use it to create my download name. I have been doing this by had as well.

Any help would be greatly appreciated.

Thanks and regards - John
Jabby is offline   Reply With Quote
Old 02-05-2011, 11:24 AM   #2
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: 43,744
Karma: 22446736
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
You have to create a composite column and use the template language. See User Manual for details on the template language. This is not an area of the code I work on/use, so I can't be more specific than that.
kovidgoyal is offline   Reply With Quote
Advert
Old 02-06-2011, 01:33 AM   #3
pchrist7
Addict
pchrist7 is kind to children and small, furry animalspchrist7 is kind to children and small, furry animalspchrist7 is kind to children and small, furry animalspchrist7 is kind to children and small, furry animalspchrist7 is kind to children and small, furry animalspchrist7 is kind to children and small, furry animalspchrist7 is kind to children and small, furry animalspchrist7 is kind to children and small, furry animalspchrist7 is kind to children and small, furry animalspchrist7 is kind to children and small, furry animalspchrist7 is kind to children and small, furry animals
 
pchrist7's Avatar
 
Posts: 385
Karma: 6514
Join Date: Aug 2010
Location: Denmark
Device: Kindle 3 3G+Wifi, Oasis
Need more info

Quote:
Originally Posted by Jabby View Post
I think I posted this in the wrong forum earlier. I'll try again.

I am trying to find a way to create a column that will hold and display the author's last name only. I created such a column but I have to hand enter the name. I use this to create my download file name, (Poe-Raven, The.epub)

I would also like to know how I can get the new title_sort field to display as a column and also use it to create my download name. I have been doing this by had as well.

Any help would be greatly appreciated.

Thanks and regards - John
Hi John
I need to see an example of the info you have in the Authors and Author_sort fields too figure this out.

However if you create a custom column, choose Column Type as "Column built from other columns", enter
Code:
{title_sort}
in the template field should work.
But maybe I'm not quite understanding your request.
pchrist7 is offline   Reply With Quote
Old 02-06-2011, 09:25 AM   #4
Archon
Zealot
Archon , Klaatu Barada Niktu!Archon , Klaatu Barada Niktu!Archon , Klaatu Barada Niktu!Archon , Klaatu Barada Niktu!Archon , Klaatu Barada Niktu!Archon , Klaatu Barada Niktu!Archon , Klaatu Barada Niktu!Archon , Klaatu Barada Niktu!Archon , Klaatu Barada Niktu!Archon , Klaatu Barada Niktu!Archon , Klaatu Barada Niktu!
 
Archon's Avatar
 
Posts: 110
Karma: 5176
Join Date: Dec 2010
Device: Mac OSX, iPad, iPod, & Nook
Let me just question your concept a little by saying there are many authors with the same last name that could be lumped together in your 'download' (I assume you mean save-to-disk).

This could become a problem for you later when you have 4 authors named Brown and you can't remember who wrote which book.

For instance, if you saved your whole library in that format how could you find all the books written by Dan Brown vs all the books written by John Brown or Sandra Brown?

Just a suggestion.
Happy Sunday
Archon
Archon is offline   Reply With Quote
Old 02-06-2011, 12:55 PM   #5
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: 29,659
Karma: 54369090
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by Archon View Post
Let me just question your concept a little by saying there are many authors with the same last name that could be lumped together in your 'download' (I assume you mean save-to-disk).

This could become a problem for you later when you have 4 authors named Brown and you can't remember who wrote which book.

For instance, if you saved your whole library in that format how could you find all the books written by Dan Brown vs all the books written by John Brown or Sandra Brown?

Just a suggestion.
Happy Sunday
Archon
I'm with you:

2100 books: (only 2 Browns )
3 Andersons
3 Greens
3 Hamiltons
4 Jones

Lots of 2's (Many not related)
theducks is offline   Reply With Quote
Advert
Old 02-06-2011, 09:25 PM   #6
Jabby
Jr. - Junior Member
Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.
 
Posts: 586
Karma: 2000358
Join Date: Aug 2010
Location: Alabama
Device: Archos, Asus, HP, Lenovo, Nexus and Samsung tablets in 7,8 and 10"
Quote:
Originally Posted by pchrist7 View Post
Hi John
I need to see an example of the info you have in the Authors and Author_sort fields too figure this out.

However if you create a custom column, choose Column Type as "Column built from other columns", enter
Code:
{title_sort}
in the template field should work.
But maybe I'm not quite understanding your request.
I entered "books_john, Books, {title_sort}" into the column create box. It was accepted and I restarted Calibre. I then went to have the column displayed and it wasn't in the list of possibles.

Beats me.

Regards -John
Jabby is offline   Reply With Quote
Old 02-06-2011, 10:06 PM   #7
Jabby
Jr. - Junior Member
Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.
 
Posts: 586
Karma: 2000358
Join Date: Aug 2010
Location: Alabama
Device: Archos, Asus, HP, Lenovo, Nexus and Samsung tablets in 7,8 and 10"
Quote:
Originally Posted by theducks View Post
I'm with you:

2100 books: (only 2 Browns )
3 Andersons
3 Greens
3 Hamiltons
4 Jones

Lots of 2's (Many not related)
Archon is right; I meant "save to disk".

I created an additional column the I use to hand enter the last name of the author. The original, full name, column is still there so there is no confusion in Calibre. And since the metadata is still intact the file name has no effect on the readers.

But it helps with the Sony which allows sorting by file name - no change to the display. Where it is really handy is with the JetBook Lite. It is a pure DOS file system so I setup folders with genre names and place the books in them. I wanted the last name only so that it would be an author sort but would take up minimum space allowing me to see as much of the title as possible.

The question is moot now. Since I have to set up some sort of template to have my "lastname" field automated and I am to lazy to learn how to do that, I will just leave well enough alone.

My best to all- John
Jabby is offline   Reply With Quote
Old 02-07-2011, 01:44 AM   #8
pchrist7
Addict
pchrist7 is kind to children and small, furry animalspchrist7 is kind to children and small, furry animalspchrist7 is kind to children and small, furry animalspchrist7 is kind to children and small, furry animalspchrist7 is kind to children and small, furry animalspchrist7 is kind to children and small, furry animalspchrist7 is kind to children and small, furry animalspchrist7 is kind to children and small, furry animalspchrist7 is kind to children and small, furry animalspchrist7 is kind to children and small, furry animalspchrist7 is kind to children and small, furry animals
 
pchrist7's Avatar
 
Posts: 385
Karma: 6514
Join Date: Aug 2010
Location: Denmark
Device: Kindle 3 3G+Wifi, Oasis
Quote:
Originally Posted by Jabby View Post
I entered "books_john, Books, {title_sort}" into the column create box. It was accepted and I restarted Calibre. I then went to have the column displayed and it wasn't in the list of possibles.

Beats me.

Regards -John
Hi John
Sorry to ask this, but .. did you remember to click Apply when creating the custom column before leaving the costum column window ?
pchrist7 is offline   Reply With Quote
Old 02-07-2011, 05:01 AM   #9
Jabby
Jr. - Junior Member
Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.
 
Posts: 586
Karma: 2000358
Join Date: Aug 2010
Location: Alabama
Device: Archos, Asus, HP, Lenovo, Nexus and Samsung tablets in 7,8 and 10"
Quote:
Originally Posted by pchrist7 View Post
Hi John
Sorry to ask this, but .. did you remember to click Apply when creating the custom column before leaving the costum column window ?
Yes I did, but thanks for the reminder.

My solution was about the same sort of thing. The column was created but displayed off screen and then, I didn't remember that you had to create the column for each library. Oh well, I'll just chalk it up to "old timers disease", with my apologies to the forum members.

Regards - John

Last edited by Jabby; 02-07-2011 at 05:04 AM.
Jabby is offline   Reply With Quote
Old 02-07-2011, 09:43 AM   #10
Manichean
Wizard
Manichean is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.Manichean is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.Manichean is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.Manichean is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.Manichean is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.Manichean is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.Manichean is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.Manichean is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.Manichean is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.Manichean is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.Manichean is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.
 
Manichean's Avatar
 
Posts: 3,130
Karma: 91256
Join Date: Feb 2008
Location: Germany
Device: Cybook Gen3
If this is still relevant, this template should do what you wanted to do in your original post for the first of the authors:
Code:
{author_sort:re(\,.*,)}
Manichean is offline   Reply With Quote
Old 02-07-2011, 12:26 PM   #11
Archon
Zealot
Archon , Klaatu Barada Niktu!Archon , Klaatu Barada Niktu!Archon , Klaatu Barada Niktu!Archon , Klaatu Barada Niktu!Archon , Klaatu Barada Niktu!Archon , Klaatu Barada Niktu!Archon , Klaatu Barada Niktu!Archon , Klaatu Barada Niktu!Archon , Klaatu Barada Niktu!Archon , Klaatu Barada Niktu!Archon , Klaatu Barada Niktu!
 
Archon's Avatar
 
Posts: 110
Karma: 5176
Join Date: Dec 2010
Device: Mac OSX, iPad, iPod, & Nook
Manichean's solution works to create the custom column when you use the 'Column built from other columns' and paste it into the 'Template' field and then restart.

I named my custom column 'lastname' for the sort field and Author Lastname to display but you can call it what you wish. Just adjust the 'save to disk' statement I have here accordingly.

Then just put this into the 'save to disk' field for naming the files.
{#lastname}_{title}

Then I got this file saved to disk for example:
Dickson_Call Him Lord.epub

It still saves the files with the .jpg cover and the .opf file you will have to sort out and trash if you don't need them.

Interesting problem. I learned something today.
The day is a success.

Archon
Archon is offline   Reply With Quote
Old 02-07-2011, 04:23 PM   #12
Jabby
Jr. - Junior Member
Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.
 
Posts: 586
Karma: 2000358
Join Date: Aug 2010
Location: Alabama
Device: Archos, Asus, HP, Lenovo, Nexus and Samsung tablets in 7,8 and 10"
Quote:
Originally Posted by Manichean View Post
If this is still relevant, this template should do what you wanted to do in your original post for the first of the authors:
Code:
{author_sort:re(\,.*,)}
Its still relevant and thanks.
I'm just starting some regex tutorials but I'm still pretty confused. I'll sort it in time (maybe?).

Regards -John
Jabby is offline   Reply With Quote
Old 02-07-2011, 04:30 PM   #13
Jabby
Jr. - Junior Member
Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.Jabby ought to be getting tired of karma fortunes by now.
 
Posts: 586
Karma: 2000358
Join Date: Aug 2010
Location: Alabama
Device: Archos, Asus, HP, Lenovo, Nexus and Samsung tablets in 7,8 and 10"
Quote:
Originally Posted by Archon View Post
Manichean's solution works to create the custom column when you use the 'Column built from other columns' and paste it into the 'Template' field and then restart.

I named my custom column 'lastname' for the sort field and Author Lastname to display but you can call it what you wish. Just adjust the 'save to disk' statement I have here accordingly.

Then just put this into the 'save to disk' field for naming the files.
{#lastname}_{title}

Then I got this file saved to disk for example:
Dickson_Call Him Lord.epub

It still saves the files with the .jpg cover and the .opf file you will have to sort out and trash if you don't need them.

Interesting problem. I learned something today.
The day is a success.

Archon
I'm going to give this a shot and get back to you and Manichean.

Thanks to both -John
Jabby is offline   Reply With Quote
Old 02-08-2011, 05:40 AM   #14
Manichean
Wizard
Manichean is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.Manichean is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.Manichean is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.Manichean is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.Manichean is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.Manichean is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.Manichean is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.Manichean is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.Manichean is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.Manichean is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.Manichean is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.
 
Manichean's Avatar
 
Posts: 3,130
Karma: 91256
Join Date: Feb 2008
Location: Germany
Device: Cybook Gen3
Quote:
Originally Posted by Jabby View Post
Its still relevant and thanks.
I'm just starting some regex tutorials but I'm still pretty confused. I'll sort it in time (maybe?).

Regards -John
There's a regex tutorial available here for non-technical users.
Manichean is offline   Reply With Quote
Old 02-08-2011, 06:37 AM   #15
Lady Fitzgerald
Wizard
Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.
 
Lady Fitzgerald's Avatar
 
Posts: 2,013
Karma: 251649
Join Date: Apr 2010
Location: Tempe, AZ, USA, Earth
Device: JetBook Lite (away from home) + 1 spare, 32" TV (at home)
Quote:
Originally Posted by Manichean View Post
There's a regex tutorial available here for non-technical users.
I'm sorry but by the time I reached "Hey, neat! This is starting to make sense!
", I was so confused, my eyes were crossing and glazing over and I had the starts of a headache. Seriously, it may make sense to you but it won't to everyone (especially me; having ADD, I had serious trouble trying to stay focussed on it).
Lady Fitzgerald 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
Curious - what custom columns are you creating/using? texasnightowl Calibre 16 05-28-2015 10:26 AM
Creating columns Jabby Library Management 0 02-04-2011 05:46 PM
Been away for a few releases...question about custom columns support texasnightowl Calibre 3 10-14-2010 09:48 AM
Creating custom columns is broken in 0.7.3 chaley Calibre 6 06-20-2010 03:40 AM
Question: Creating a Folder only for Classics Dr. Drib Sony Reader 7 08-22-2007 03:09 AM


All times are GMT -4. The time now is 05:58 AM.


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