MobileRead Forums - View Single Post

Sidetrack · 11-15-2010, 03:18 PM

Hello everyone,

New to the world of Calibre and Mobileread, and I'm finding both wonderful. (also I need a way to get rid of the pesky 'Hello Sidetrack, you've never posted' message). The forums have been great to glean information so I can bring my existing collection into Calibre and organize it. I'm managing some duplicates as I do.

To compensate for some of my Garbage In, without full blown SQL available, some things that would help me (and maybe others) are some "canned SQL" functions:

unique, as in title:unique author:unique

or some other way to filter duplicate or unique terms, like maybe

expanded relational operators as in format:>1

which might turn a search like format:txt and (format:zip or format:lrf or ... ) in to format:txt and format:>1

Also, options to unmerge/split a record might be nice as well for cases when multiple editions that should be separated have gotten grouped together.

I'm finding ways to accomplish most of this within Calibre, but maybe not the best and fastest ways (enlighten me?).

This is the sort of slicing and dicing available in databases; is it worth coding in to the interface?

11-15-2010, 03:18 PM	#1
Sidetrack Enthusiast Posts: 39 Karma: 10 Join Date: Jan 2009 Location: South Pacific Device: Kindle DX	Initial Collection Organizing Hello everyone, New to the world of Calibre and Mobileread, and I'm finding both wonderful. (also I need a way to get rid of the pesky 'Hello Sidetrack, you've never posted' message). The forums have been great to glean information so I can bring my existing collection into Calibre and organize it. I'm managing some duplicates as I do. To compensate for some of my Garbage In, without full blown SQL available, some things that would help me (and maybe others) are some "canned SQL" functions: unique, as in title:unique author:unique or some other way to filter duplicate or unique terms, like maybe expanded relational operators as in format:>1 which might turn a search like format:txt and (format:zip or format:lrf or ... ) in to format:txt and format:>1 Also, options to unmerge/split a record might be nice as well for cases when multiple editions that should be separated have gotten grouped together. I'm finding ways to accomplish most of this within Calibre, but maybe not the best and fastest ways (enlighten me?). This is the sort of slicing and dicing available in databases; is it worth coding in to the interface?