02-20-2014, 09:45 AM | #1981 |
BLAM!
Posts: 13,478
Karma: 26012494
Join Date: Jun 2010
Location: Paris, France
Device: Kindle 2i, 3g, 4, 5w, PW, PW2, PW5; Kobo H2O, Forma, Elipsa, Sage, C2E
|
@Kumabjorn: Possibly not being psychic and knowing what you actually want to call it? .
Kidding aside: if it's doable, probably could put a text box+button to create it instead of instructions on how to it manually. Patch welcome . |
02-20-2014, 10:24 AM | #1982 |
Basculocolpic
Posts: 4,356
Karma: 20181319
Join Date: Jul 2010
Location: Sweden
Device: Kindle 3 WiFi, Kindle 4SO, Kindle for Android, Sony PRS-350 and PRS-T1
|
User could always change it later, I just believe that software should always aspire to make it as easy for the end user as possible, but I also realize that there are other approaches to UI, such as minimizing CPU resources.
|
02-20-2014, 10:57 AM | #1983 | |
Well trained by Cats
Posts: 29,812
Karma: 54830978
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Quote:
What if you already had a column with that name, but not associated with the PI? A mess if the PI did manage to run Besides, Adding a column requires a calibre restart before it can be used I do believe in cases of user defined column usage, that any PI uses them should do basic sanity check and report errors in simple terms (not rely on a crash report). 1) The PI has been initially configured (valid at the time). 2) When starting, the configuration is checked against the current Library to be sure that the columns exist and are of the correct types. |
|
02-20-2014, 11:00 AM | #1984 |
BLAM!
Posts: 13,478
Karma: 26012494
Join Date: Jun 2010
Location: Paris, France
Device: Kindle 2i, 3g, 4, 5w, PW, PW2, PW5; Kobo H2O, Forma, Elipsa, Sage, C2E
|
@theducks: Thanks for the gory details .
|
02-20-2014, 06:40 PM | #1985 | |
Basculocolpic
Posts: 4,356
Karma: 20181319
Join Date: Jul 2010
Location: Sweden
Device: Kindle 3 WiFi, Kindle 4SO, Kindle for Android, Sony PRS-350 and PRS-T1
|
Quote:
1. Can a plug-in scan the columns and determine their names? 2. Is there a specific reason Calibre needs to restart when a column is added? Thank you for a rational explanation. I'd send you karma if I wasn't on Tapatalk. |
|
02-20-2014, 07:50 PM | #1986 | |
Well trained by Cats
Posts: 29,812
Karma: 54830978
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Quote:
When you 'add' a column in the GUI and click Apply, that only sets up the task. The db must be detached, then the field is created (and all the linkage custom column magick happens) The restart allows the GUI to 'discover' and display the column . #1 can't happen until the column exists from #2 restart (attach horse to cart) BTW You probably noticed the many plugins need a restart when first installed. Same sort of thing. Get all the pieces in place then 'discover' them while building up the GUI. |
|
02-20-2014, 08:34 PM | #1987 |
Basculocolpic
Posts: 4,356
Karma: 20181319
Join Date: Jul 2010
Location: Sweden
Device: Kindle 3 WiFi, Kindle 4SO, Kindle for Android, Sony PRS-350 and PRS-T1
|
My comparison is with Excel, the db in Calibre looks exactly like a data sheet and you don't need to name those because each cell has a preordained moniker (z.34 etc) so can I assume that those don't exist in Calibre?
|
02-20-2014, 08:58 PM | #1988 | |
null operator (he/him)
Posts: 20,580
Karma: 26954694
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
Quote:
Being a database application, the underlying metaphor for Calibre is a card index Your file manager can present a tabular list of your files rather like Calibre presents your books, the underlying structure of your file system has a lot more in common with a calibres database than with a spreadsheet. The Properties sheet of a file is not dissimilar to the Book Information panel in calibre (press 'i') - I can't think of a parallel in a spreadsheet. A spreadsheet can do arithmetic inherently - a database can't, someone has to write some code BR Last edited by BetterRed; 02-20-2014 at 09:23 PM. |
|
02-20-2014, 10:17 PM | #1989 |
Well trained by Cats
Posts: 29,812
Karma: 54830978
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Spreadsheets are 'Cell Oriented'
Databases are Record Oriented (a whole row) in a flat file Calibre is a Relational database that is presented as a flat file. The card analogy is close (dead on if calibre had been done as an inefficient Flat file) (very simplified) You have : Books (titles). Books Have Authors, Publishers, Tags and may belong to Series with a Index position. Each of these is represented by a Key number. (the books table does not actually have the Publishers Name in it, it has the key number of the Publisher name that is in the Publishers table ( a Many to 1). Tags is a little more tricky. There is an intermediate table that has a record (line) for each tag (again a Key # from the Tags Table) that is assigned to the book (which is a link key to the book (a 1 to Many)) In a spreadsheet: if you don't use care when you sort on a column, you scramble the column because the cell is not locked to the row In a DB, the row is always kept together. Kovid has done a very nice job here. The way custom columns was implemented is Brilliant because it attaches to the core DB rather than modify the basic DB (You probably don't care how,as long as it works ) |
03-03-2014, 03:02 AM | #1990 |
Member
Posts: 15
Karma: 542812
Join Date: Feb 2014
Location: In london, england
Device: kindle 4 non touch
|
wher can i actually download it? on the internet
|
03-03-2014, 03:56 AM | #1991 |
null operator (he/him)
Posts: 20,580
Karma: 26954694
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
|
03-09-2014, 04:54 PM | #1992 |
Junior Member
Posts: 3
Karma: 10
Join Date: Mar 2014
Device: Kindle Paperwhite 2
|
I'm not sure if anyone have experienced this, but whenever i imported collection from calibre using collection manager, only one collection i have contain more than 1000 books, doesn't sync into the device (the collection is shown on the device but there are no books inside). Other collections work fine.
I assume it has something to do with large number of books that exceed the limit but may be i'm wrong. I can try to half the number of books in that collection and sync in, then do another batch to fill up, but i'm afraid all collections will rebuild itself rather than update the content within it and this will not work. Any solution please help !! |
03-09-2014, 06:18 PM | #1993 |
BLAM!
Posts: 13,478
Karma: 26012494
Join Date: Jun 2010
Location: Paris, France
Device: Kindle 2i, 3g, 4, 5w, PW, PW2, PW5; Kobo H2O, Forma, Elipsa, Sage, C2E
|
@kalkenji: I recall someone in the Kindle forum mentioning a similar issue with bog-standard collections with over 999 items, so I guess that, yeah, we can assume 999 is a hard limit.
|
03-09-2014, 07:51 PM | #1994 |
Ex-Helpdesk Junkie
Posts: 19,422
Karma: 85397180
Join Date: Nov 2012
Location: The Beaten Path, USA, Roundworld, This Side of Infinity
Device: Kindle Touch fw5.3.7 (Wifi only)
|
|
03-09-2014, 07:52 PM | #1995 |
Junior Member
Posts: 3
Karma: 10
Join Date: Mar 2014
Device: Kindle Paperwhite 2
|
Thanks NiLuJe. You just save my next 24hrs of frustration. i guess i will split the collection in half and name each differently.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
[GUI Plugin] Kindle Collections (Update) | NiLuJe | Plugins | 463 | 02-16-2024 12:43 AM |
Kindle Collections plugin | JosephWebber | Plugins | 1 | 08-21-2017 11:44 AM |
[GUI Plugin] WebOS Kindle-Import | CranstD | Plugins | 0 | 01-24-2012 03:36 PM |
Finding and using Kindle Collections Plugin | djchapple | Plugins | 2 | 08-03-2011 10:06 AM |
[GUI Plugin] Plugin Updater **Deprecated** | kiwidude | Plugins | 159 | 06-19-2011 12:27 PM |