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 10-28-2013, 03:07 PM   #1
carlberger
Retired Reader
carlberger began at the beginning.
 
carlberger's Avatar
 
Posts: 4
Karma: 10
Join Date: Sep 2008
Location: St George, Utah
Device: iPad
Format column shows all books as ePub

All the books are shown as EPUB in the format column even though many are MOBI or AZW3 or multiple.

Any way to correct this problem?
Attached Thumbnails
Click image for larger version

Name:	Screenshot 2013-10-28 13.03.24.png
Views:	62
Size:	165.2 KB
ID:	114117  
carlberger is offline   Reply With Quote
Old 10-28-2013, 03:28 PM   #2
PeterT
Taking a break; Fed up
PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.
 
PeterT's Avatar
 
Posts: 6,102
Karma: 38639832
Join Date: Nov 2007
Location: Toronto
Device: Wife: Touch, Arc, Vox Me: Nexus 7, Glo
Is this a custom column? If so, what is it's definition?

I know I have a custom colum
Code:
Lookup name: formats
Column Heading: Formats
Column type: Column built from other columns
Template: {:'approximate_formats()'}
sort/search column by: text
and it work's perfectly.
PeterT is offline   Reply With Quote
Old 10-28-2013, 05:27 PM   #3
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: 2,316
Karma: 1664976
Join Date: Mar 2012
Location: NSW Australia
Device: none
@carlberger - it might be an idea to run Library Maintenance->Check Library

The second phase includes the comparison of what formats are in the book folders (according to your computer's file management software) versus what the calibre has recorded in its database as being there. It might give a clue as to why that formats column is spurious.

They can get out of synch if you add/delete/rename files in book folders other than via calibre - if you stick with calibre to do those things then you should not get any problems of that nature.

BR
BetterRed is offline   Reply With Quote
Old 10-28-2013, 06:04 PM   #4
carlberger
Retired Reader
carlberger began at the beginning.
 
carlberger's Avatar
 
Posts: 4
Karma: 10
Join Date: Sep 2008
Location: St George, Utah
Device: iPad
Nope, standard column

Not a custom column. Nor is it fixed by running maintenance.

Looks like I'll try your script and let you know!

Thanks
carlberger is offline   Reply With Quote
Old 10-28-2013, 06:59 PM   #5
PeterT
Taking a break; Fed up
PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.
 
PeterT's Avatar
 
Posts: 6,102
Karma: 38639832
Join Date: Nov 2007
Location: Toronto
Device: Wife: Touch, Arc, Vox Me: Nexus 7, Glo
I'm confused... as far as I know Calibre does NOT have a format column; you have to create one yourself....
PeterT is offline   Reply With Quote
Old 10-28-2013, 08:37 PM   #6
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: 2,316
Karma: 1664976
Join Date: Mar 2012
Location: NSW Australia
Device: none
I think there was a time when Formats could be shown as a column (i.e what you see in Book Details Formats), but because it created performance problems the approximate_formats() function was provided, either then or later the support for Formats as a column was dropped.

Maybe the OP's Formats column is an artifact of an earlier version of calibre

BR

Last edited by BetterRed; 10-28-2013 at 08:40 PM.
BetterRed is offline   Reply With Quote
Old 10-28-2013, 10:13 PM   #7
DoctorOhh
US Navy, Retired
DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.
 
DoctorOhh's Avatar
 
Posts: 8,572
Karma: 12369681
Join Date: Feb 2009
Location: North Carolina
Device: Nexus 7
Quote:
Originally Posted by BetterRed View Post
I think there was a time when Formats could be shown as a column (i.e what you see in Book Details Formats), but because it created performance problems the approximate_formats() function was provided, either then or later the support for Formats as a column was dropped.
While you are correct that the basic easy click custom column for formats does now use the {:'approximate_formats()'} function, the basic formats column using {formats} is still a supported optional custom column and was not dropped.

Quote:
Originally Posted by carlberger View Post
Not a custom column.
It is a custom column. The formats column was never a provided column in any version of calibre which means either you or whoever created the library created this custom column.

As PeterT indicated if the column says epub for every entry it is most likely a problem with the custom column template. Follow PeterT's example and you should be fine.

Last edited by DoctorOhh; 10-28-2013 at 10:19 PM.
DoctorOhh is online now   Reply With Quote
Old 10-28-2013, 10:43 PM   #8
davidfor
Wizard
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 4,245
Karma: 3677994
Join Date: Jul 2011
Location: Australia
Device: Kobo Touch, Kobo Glo
Quote:
Originally Posted by carlberger View Post
Not a custom column. Nor is it fixed by running maintenance.
Put the cursor over the column heading. This will display the lookup name for the column. If it starts with a "#", it is a custom column and you can look at its definition in preferences. If it doesn't, tell us the name of the column.
davidfor is offline   Reply With Quote
Old 10-28-2013, 11:43 PM   #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: 2,316
Karma: 1664976
Join Date: Mar 2012
Location: NSW Australia
Device: none
Quote:
Originally Posted by DoctorOhh View Post
While you are correct that the basic easy click custom column for formats does now use the {:'approximate_formats()'} function, the basic formats column using {formats} is still a supported optional custom column and was not dropped.
@DoctorOhh - Thanks for the clarification - I must have had the {formats} variant, back then I didn't even know templates existed, let alone what they were - still don't know much more than that they do exist

BR
BetterRed is offline   Reply With Quote
Old 10-29-2013, 01:29 AM   #10
DoctorOhh
US Navy, Retired
DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.
 
DoctorOhh's Avatar
 
Posts: 8,572
Karma: 12369681
Join Date: Feb 2009
Location: North Carolina
Device: Nexus 7
Quote:
Originally Posted by BetterRed View Post
back then I didn't even know templates existed, let alone what they were - still don't know much more than that they do exist
You and I both.
DoctorOhh is online now   Reply With Quote
Old 11-01-2013, 09:40 AM   #11
carlberger
Retired Reader
carlberger began at the beginning.
 
carlberger's Avatar
 
Posts: 4
Karma: 10
Join Date: Sep 2008
Location: St George, Utah
Device: iPad
Could have sworn there was a simple click box in the preferences.
Made a custom one based on the script above and works like a charm. Just had to rename it to Format2.

carlberger is offline   Reply With Quote
Old 11-01-2013, 04:28 PM   #12
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: 2,316
Karma: 1664976
Join Date: Mar 2012
Location: NSW Australia
Device: none
Quote:
Originally Posted by carlberger View Post
Could have sworn there was a simple click box in the preferences.
@carlberger - there was such a thing - sort of

The Quick create link for Formats in the Add column dialogue, originally created this template {formats}.

It was changed, for performance reasons and after considerable discussion at MB, to create this template {:'approximate_formats()'}

BR

PS : I can't recall when the change was made - quite a while back - maybe last year even.

Last edited by BetterRed; 11-01-2013 at 04:37 PM. Reason: add ps:
BetterRed is offline   Reply With Quote
Old 11-01-2013, 04:56 PM   #13
PeterT
Taking a break; Fed up
PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.
 
PeterT's Avatar
 
Posts: 6,102
Karma: 38639832
Join Date: Nov 2007
Location: Toronto
Device: Wife: Touch, Arc, Vox Me: Nexus 7, Glo
Approximate_formats was added in 0.8.70, 21 September 2012.
PeterT 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
Single column ePUB becomes 2 column when converted to Kindle (mobi) rmcape Conversion 0 09-21-2013 12:52 PM
Not all .mobi books showing in Format column Alcohol Library Management 9 01-05-2013 06:33 AM
Q: multi-column PDF to single column mobi format converstion auburn1975 Calibre 7 01-28-2012 06:11 PM
Custom Column - Book Format (ie mobi, epub etc) jphphotography Calibre 3 01-17-2011 12:34 AM
Server shows column headers, but not books, when accessed via mobile phone browser Starson17 Calibre 7 12-29-2009 04:49 PM


All times are GMT -4. The time now is 04:57 AM.


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