formats column

Philosopher · 01-07-2011, 05:35 AM

Someone was kind enough to show me how to create an isbn column.

How can I create a column which displays the formats?

Thanks.

chaley · 01-07-2011, 05:46 AM

Just as you did for isbn, create a custom column 'built from other columns'. The template is {formats}

iceman31ad · 01-07-2011, 05:23 PM

i am wanting to get the column to show only one format at a time aka i want it to show a yes or no if it has mobi and another to show if it has epub and so on ... so you think that is possible and if it's already been covered im sorry ... just trying to find a way to keep it up to date automatically i know i can make a column that says mobi with yes/no and so on for each format and edit by hand you get the idea what i am wanting to do hope you can help

Lady Fitzgerald · 01-07-2011, 05:37 PM

If I understand you correctly, what you are proposing may be unnecessarily complicated. Just make a format column the way chaley suggested. To view one format only, open the Tag browser (the button with the little luggage tag on it), click on the Format bitton, then click on the one you want to display. That will display only the books with that format.

Of course, I may have totally misunderstood you.

I hope your little girl is feeling better.

theducks · 01-07-2011, 06:12 PM

Quote:

Originally Posted by iceman31ad

i am wanting to get the column to show only one format at a time aka i want it to show a yes or no if it has mobi and another to show if it has epub and so on ... so you think that is possible and if it's already been covered im sorry ... just trying to find a way to keep it up to date automatically i know i can make a column that says mobi with yes/no and so on for each format and edit by hand you get the idea what i am wanting to do hope you can help

Why bother

with all that, when you can use the luggage tag (or search tool) format section?

formats:mobi
formats:epub
then all you see is:

iceman31ad · 01-07-2011, 07:01 PM

i have received over 2000 ebooks in all sorts of formats some in multiple formats and some where the meta data is there but nothing else and most of these are for my wife for use on her kindle. and i want to be able to sort it out example i want to all epub books and see if it has a mobi format or not then so a batch conversion and know if the conversion took any other way and you have to go one by one. or worse yet print a page and search does this make any sense now

edit

thought how can you make a column query wither a format is there i know you have the tab but can you get it to just display the info in the column with out hand editing

aka a column that asks is mobi there yes or no
i was thinking the code to make it work would be {format}*(mobi=true)* but i all i got was a listing with mobi=true after it
been up with a sick little girl for 2 days so plaese if its not posible just say so if its complicated give it a try its beyond me i know but if you are going to say its too hard and tell me to do it the way i have been doing it please don't bother

kiwidude · 01-07-2011, 07:39 PM

That was a long sentence

What the others are suggesting is that perhaps your best bet is just to use the search engine rather than using custom columns as it should give the same effect.

For instance to find all the books that have EPUB but do not have MOBI, type this into the search box:
format:epub and not format:mobi

theducks · 01-07-2011, 08:00 PM

Quote:

Originally Posted by kiwidude

That was a long sentence

What the others are suggesting is that perhaps your best bet is just to use the search engine rather than using custom columns as it should give the same effect.

For instance to find all the books that have EPUB but do not have MOBI, type this into the search box:
format:epub and not format:mobi

And then use the save search tool to the right so the S-O can use the saved name.
Extremely useful with more complex searches

formats:true and not formats:epub <-show me books that need conversion to epub but hide empty books

iceman31ad · 01-07-2011, 08:18 PM

ok thats not how i wanted to do it but it does what i want to do with out having to check each one individually thank you both

and yes i did try reading the instruction manual but that thing needs a true toc

theducks · 01-07-2011, 08:45 PM

Quote:

Originally Posted by iceman31ad

and yes i did try reading the instruction manual but that thing needs a true toc

What we need is a 'loose leaf' Calibre cookbook

With easy to find "Desired Results", step by step instructions

I want to do for...
Kindle User:
Sony user:
Drop box:
MAC:
Ubuntu:
Win7:
XP:

I don't know about you, but screen width has become precious (and I only added 3 small columns and hid a few) on my widescreen monitor.
So using a filter/saved search to do something that saves screen width, gets my

iceman31ad · 01-07-2011, 09:52 PM

yea that sounds better

chaley · 01-08-2011, 04:17 AM

@iceman31ad: you can do what you want. Showing you will need to wait until tomorrow, as today is fully booked.

If you want to give it a try, use something like
{formats:contains(epub,Yes,No)}

iceman31ad · 01-14-2011, 03:09 PM

well it looks like that is half way there i tried tweaking it but i keep getting errors like it always says no

chaley · 01-14-2011, 03:21 PM

Use {formats:contains(EPUB,Yes,No)}

The test is case-sensitive

iceman31ad · 01-14-2011, 10:12 PM

ok i am an idiot i didnt think about case at all

01-07-2011, 05:35 AM	#1
Philosopher Connoisseur Posts: 77 Karma: 12 Join Date: Jun 2010 Device: Kindle	formats column Someone was kind enough to show me how to create an isbn column. How can I create a column which displays the formats? Thanks.

01-07-2011, 05:23 PM	#3
iceman31ad Junior Member Posts: 8 Karma: 10 Join Date: Dec 2010 Device: kindle	ok lets see if you can help me i am wanting to get the column to show only one format at a time aka i want it to show a yes or no if it has mobi and another to show if it has epub and so on ... so you think that is possible and if it's already been covered im sorry ... just trying to find a way to keep it up to date automatically i know i can make a column that says mobi with yes/no and so on for each format and edit by hand you get the idea what i am wanting to do hope you can help Last edited by iceman31ad; 01-07-2011 at 05:25 PM. Reason: been up for 2 days with a sick little girl

01-07-2011, 07:01 PM	#6
iceman31ad Junior Member Posts: 8 Karma: 10 Join Date: Dec 2010 Device: kindle	i have my reasons i have received over 2000 ebooks in all sorts of formats some in multiple formats and some where the meta data is there but nothing else and most of these are for my wife for use on her kindle. and i want to be able to sort it out example i want to all epub books and see if it has a mobi format or not then so a batch conversion and know if the conversion took any other way and you have to go one by one. or worse yet print a page and search does this make any sense now edit thought how can you make a column query wither a format is there i know you have the tab but can you get it to just display the info in the column with out hand editing aka a column that asks is mobi there yes or no i was thinking the code to make it work would be {format}(mobi=true) but i all i got was a listing with mobi=true after it been up with a sick little girl for 2 days so plaese if its not posible just say so if its complicated give it a try its beyond me i know but if you are going to say its too hard and tell me to do it the way i have been doing it please don't bother Last edited by iceman31ad; 01-07-2011 at 07:13 PM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
2 column PDF book to 1 column possible?	SeaBookGuy	Calibre	19	07-01-2013 02:30 AM
Q: multi-column PDF to single column mobi format converstion	auburn1975	Calibre	7	01-28-2012 06:11 PM
PDF with two column	Gho57	Amazon Kindle	10	05-16-2011 01:01 AM
Convert Epub and Msreader formats to Kindle formats	bruc79	Calibre	17	06-22-2010 04:50 AM
pdf to lrf with 2 column and 1 column pages in same file	danielwille	Sony Reader	3	11-12-2008 10:57 AM

01-07-2011, 05:46 AM	#2
chaley Grand Sorcerer Posts: 11,740 Karma: 6997045 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	Just as you did for isbn, create a custom column 'built from other columns'. The template is {formats}

01-07-2011, 05:37 PM	#4
Lady Fitzgerald Wizard 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)	If I understand you correctly, what you are proposing may be unnecessarily complicated. Just make a format column the way chaley suggested. To view one format only, open the Tag browser (the button with the little luggage tag on it), click on the Format bitton, then click on the one you want to display. That will display only the books with that format. Of course, I may have totally misunderstood you. I hope your little girl is feeling better.

01-07-2011, 07:39 PM	#7
kiwidude Calibre Plugins Developer Posts: 4,636 Karma: 2162064 Join Date: Oct 2010 Location: Australia Device: Kindle Oasis	That was a long sentence What the others are suggesting is that perhaps your best bet is just to use the search engine rather than using custom columns as it should give the same effect. For instance to find all the books that have EPUB but do not have MOBI, type this into the search box: format:epub and not format:mobi

01-07-2011, 08:18 PM	#9
iceman31ad Junior Member Posts: 8 Karma: 10 Join Date: Dec 2010 Device: kindle	ok thats not how i wanted to do it but it does what i want to do with out having to check each one individually thank you both and yes i did try reading the instruction manual but that thing needs a true toc

01-07-2011, 09:52 PM	#11
iceman31ad Junior Member Posts: 8 Karma: 10 Join Date: Dec 2010 Device: kindle	yea that sounds better

01-08-2011, 04:17 AM	#12
chaley Grand Sorcerer Posts: 11,740 Karma: 6997045 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	@iceman31ad: you can do what you want. Showing you will need to wait until tomorrow, as today is fully booked. If you want to give it a try, use something like {formats:contains(epub,Yes,No)}

01-14-2011, 03:09 PM	#13
iceman31ad Junior Member Posts: 8 Karma: 10 Join Date: Dec 2010 Device: kindle	well it looks like that is half way there i tried tweaking it but i keep getting errors like it always says no

01-14-2011, 03:21 PM	#14
chaley Grand Sorcerer Posts: 11,740 Karma: 6997045 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	Use {formats:contains(EPUB,Yes,No)} The test is case-sensitive

01-14-2011, 10:12 PM	#15
iceman31ad Junior Member Posts: 8 Karma: 10 Join Date: Dec 2010 Device: kindle	ok i am an idiot i didnt think about case at all

Advert

Advert