04-16-2013, 07:12 PM | #61 |
Calibre Plugins Developer
Posts: 4,679
Karma: 2162246
Join Date: Oct 2010
Location: Australia
Device: Kindle Oasis
|
@BetterRed - back in step 1 of the wizard there is a "Fields..." button. Use this to define what columns in the library you are going to be importing values into, so that it appears as a column in the second step of the wizard.
|
04-16-2013, 09:21 PM | #62 | |
null operator (he/him)
Posts: 20,983
Karma: 27620706
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
Quote:
Aaah, I see my blunder I switched from using a list and a RegEx to a CSV, with columns Author, Title, FixCover - I didn't flip the Author & Title column numbers. There is in fact no need for me to import values, the books are presented in 'marked:imported_list', which is sort of what I expected to happen, but I never got that far. From there I can do a bulk edit to change the Fix Cover column to True. But if I did want to import a Yes/No column (where Undefined is allowed) then what values do I put in the CSV - 'Y'/'N'/' ', True/False/Null, Yes/No/Undefined... No matter what I tried the column would always show as 'No' in Preview and all the books would be a Mismatch. Which made me think it was using the column as part of its matching process. Happy to work up a sample if required. One, hopefully small, Change Request - In the Step 2 could we have an option to Display - All Books, Matching Books or Non-Matching Books Two, maybe not too hard, Change Request - would it be possible to add a new method of importing the list. This would be a list of Calibre Library File Paths as in Code:
E:\Calibre Libraries\Workshop\Bill Bloggs\Temple Bar Tales (58)\cover.jpg E:\Calibre Libraries\Workshop\Bill Bloggs\Chancery Towers Downfall (54)\cover.jpg E:\Calibre Libraries\Workshop\Olivia Waters\Hard Times at the FT (53)\Hard Times at the FT - Olivia Waters.pdf E:\Calibre Libraries\Workshop\Suzanne Peters\The Giant Squid is Dancing (69)\The Giant Squid is Dancing - Suzanne Peters.mobi At the moment I use Notepad++ macros to massage the list into a CSV file, which I feed into Import List, which applies its fuzzy logic to match the csv rows to the Calibre database which works most of the time, but... I'm sure you can intuit what I'm thinking BTW this PI is a work of art, it should be hung up at Tate Modern for the next Turner Prize Thanks BR Last edited by BetterRed; 04-17-2013 at 07:08 PM. Reason: Add Change Request |
|
04-20-2013, 10:40 AM | #63 |
Calibre Plugins Developer
Posts: 4,679
Karma: 2162246
Join Date: Oct 2010
Location: Australia
Device: Kindle Oasis
|
@BetterRed - I just took a quick look at the code, and it should accept any of "1", "y", "yes" or "true" in your csv file (and casing variants) if your custom column is defined as a boolean column. If it still isn't working for you send me a sample CSV.
As for (2) I'm not really sure where you are going with that. But it should be possible to do what you want from the clipboard tab with an appropriate regex? |
04-20-2013, 06:49 PM | #64 | |
null operator (he/him)
Posts: 20,983
Karma: 27620706
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
Quote:
What about One - after the matching an option to show All, Matching or Non Matching books. I had < 10 unmatched in a list of 300, they were awkward to find. They were caused by punctuation in titles etc, hence I needed to fix them. Re clipboard and regex. The path lists come from using Windows Search & Spotlight on Calibre Library folders. Most of my colleagues are non compos mentis when it comes to regex's. The need to put the bool into the input csv went away once I discovered I would get a marked list of all the matched books - I wanted all the books in the list to have 'Yes', so bulk metadata edit did that. I'll try the boolean again in a test library in the next couple of days - and let you know what happens. BR Update 1 - woke up for a simple process to produce a csv, with title, author columns with fewer mismatches - so we now have no need for Change Two (read from a directory list). We would still like Change One - option to display All, Matched and Mismatched Still have replicate problems with bools on my TODOs Last edited by BetterRed; 04-21-2013 at 05:21 PM. |
|
04-24-2013, 07:03 PM | #65 |
null operator (he/him)
Posts: 20,983
Karma: 27620706
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
Re: bools (yes/no; true/false): Mea Culpa - I was not setting column number to correct value (3) in first screen, I was leaving it as zero (0). Maybe it could be validated, column zero (0) not allowed, and two fields can't have same column number.
I found the Select All Unmatched books button, and figured out that one can then use the Green arrows to step up and down through the Unmatched books... but its very slow to step through them, lots of disk I/O. It was quicker to use Page Down and look for Red Lines. I had a list of 78 books with 3 mismatches, up against a library of ~3500 books. From another search I had a list of 350+ books with 4 mismatches against a library of 20,000+. Using the Select Unmatched and the Green down arrow, I almost had time to make a coffee Given my druthers, I'd rather have the Select All Unmatched books button collapse the list accordingly. Plus similar buttons for Select All and Select all Matched and dispense with the Green Arrows. Actually that would map to a tristate radio button group. Minor cosmetic issue - if the LHS of Step 2: Match list of... does not need a horizontal scroll bar, but the RHS does need one, then the vertical alignment of the two lists gets a bit unaligned - it can be a bit disconcerting. This plugin is proving itself invaluable, especially in combination with the Reading List PI My colleagues said to say , I'll just say Good On Yer Cobber - have a great Anzac Day BR |
09-06-2013, 10:28 AM | #66 |
Well trained by Cats
Posts: 30,439
Karma: 58055868
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Is anyone else having problems closing this PI after a successful import?
Calibre 1.2 on XP I had to quit Calibre to get the dialog to go away |
09-06-2013, 01:44 PM | #67 | |
Addict
Posts: 344
Karma: 1222222
Join Date: Aug 2009
Location: Florida
Device: Sony PRS-505
|
Quote:
I have found that if I minimize Calibre and reopen the PI is closed. |
|
09-06-2013, 10:06 PM | #68 |
Well trained by Cats
Posts: 30,439
Karma: 58055868
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
|
09-07-2013, 06:49 AM | #69 | |
Calibre Plugins Developer
Posts: 4,679
Karma: 2162246
Join Date: Oct 2010
Location: Australia
Device: Kindle Oasis
|
Quote:
The dialog itself is just invoked with a standard Qt .show() call on the QWizard window (since the window is modeless). There is a little bit of code that executes to save window position and your preferences but I can't see how that would affect anything. To verify it you could open the plugin zip file, edit line 59 of wizards.py and comment out this line like as follows: Code:
#self.finished.connect(self._on_dialog_closing) |
|
09-07-2013, 10:41 AM | #70 |
Addict
Posts: 344
Karma: 1222222
Join Date: Aug 2009
Location: Florida
Device: Sony PRS-505
|
Your welcome! It is a lot faster...
Kiwidude: It doesn't happen to me all the time. Small lists seem to work well. Bigger lists (or one with more data?)...well it seems I have to minimize to get rid of the PI window. I usually have several programs open at once and my computer is slow anyway so I didn't figure it was the PI. I really love this PI! |
09-07-2013, 07:41 PM | #71 | |
Well trained by Cats
Posts: 30,439
Karma: 58055868
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Quote:
Thanks |
|
09-11-2013, 03:05 PM | #72 | ||
Junior Member
Posts: 4
Karma: 10
Join Date: Sep 2013
Device: Kobo Aura HD, Cybook Odyssee HD Frontlight
|
Modification: XPath-"tag list"
I had the problem of multiple values for "tags" in XPath, and the preview showed additional lines without title, but with author(s) and one tag per line.
After some time of experiments (yeah, no XPath 2.0, no string-join) I looked in the code (I have/had no experience with Python ) and modified it: Quote:
Quote:
With this changes I was able to correctly import multiple values for tags (and all other fields I wanted to do so) with XPath. I tested also the update of existing entries - this was ok (means: no duplicate values, missing values were added). Perhaps this can be (configurable? checkbox?) implemented to this great plugin, if it is useful. (I really like the possibility to fill my custom columns with data ) |
||
09-23-2013, 05:19 PM | #73 |
Connoisseur
Posts: 92
Karma: 1000100
Join Date: Oct 2010
Device: Samsung tab 3 & Nook Simple Touch with Glow light
|
Web Page Problem
I seem to be having a basic problem inserting the URL:
example using your original Joe Abercrombie example, but with Goodreads: 1. Selected Joe Abercrombie book in my calibre 2. Used Search the Internet for Goodreads by Author URL is: http://www.goodreads.com/search?q=Joe+Abercrombie note page lists 1-19 of 29 results 3. Opened Import List 4. on Predefined tab, selected Goodreads Shelves: Fantasy then clicked Edit 5. Copy and paste above URL into Web Page, Download from url: and then click Preview 6. That's it. Just sits there... ??? No books shown and the Next button never highlighted. Source info seems logical, xpaths are prefilled in ... What am I doing wrong? Last edited by Tom SKP; 09-23-2013 at 05:24 PM. |
09-25-2013, 02:00 PM | #74 | |
Calibre Plugins Developer
Posts: 4,679
Karma: 2162246
Join Date: Oct 2010
Location: Australia
Device: Kindle Oasis
|
Quote:
Every different type of webpage needs a custom settings profile defined for it. If you compare the two web pages involved you will see that they contain significantly layout. The example I give on the front page will work on Fantastic Fiction for any Fantastic Fiction author. However I have not included with this plugin an equivalent for Goodreads, yet you are trying settings as though I had . You arem mixing a shelf results page settings with a search results page settings, hence it does not work correctly. However it is I think an interesting suggestion that I do include an equivalent of that Fantastic Fiction profile for Goodreads, which will parse the first page of search results. That would give you exactly what you want. Keep an eye out for a new version of the plugin, I will try to include it if it is indeed possible... |
|
09-25-2013, 02:33 PM | #75 |
Connoisseur
Posts: 92
Karma: 1000100
Join Date: Oct 2010
Device: Samsung tab 3 & Nook Simple Touch with Glow light
|
Thanks Kiwidude,
I am slowly learning... I think??? and I thank you future changes.... I may have discovered a way around it: For Goodreads, and the Fantasy genre I was as you deduced, using the Goodreads Fantasy Shelf Predefined set up.. and it failed. Bus messing around, it appears that if I use the Goodreads Awards Hugo format it does seem work But again, I see that with Goodreads I will get only one page, while with Fantastic Fiction I will get ALL the author's books in one shot. A better result! It appreas that the databases of the two sites are pretty equivalent. So, I will be using FF for most of my work for now on due to that reason What I am doing is updating all my authors, and new ones, to have a choice to include a lot of their books that I did not have listed in Calibre. Your PI, as I get better at using it will save me an awful lot of work of crosschecking lists! BTW, I used the PI last year to import my wife's extensive book list (which I had converted into a CSV) into a Calibre for her! Thanks again |
Tags |
column types |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
[GUI Plugin] Reading List | kiwidude | Plugins | 1406 | 10-16-2024 08:28 PM |
[GUI Plugin] Manage Sony x50 Reader Book List | kpw | Plugins | 170 | 10-02-2014 08:23 PM |
Import List plugin idea thread | kiwidude | Development | 45 | 08-13-2012 06:05 AM |
[GUI Plugin] WebOS Kindle-Import | CranstD | Plugins | 0 | 01-24-2012 03:36 PM |
[GUI Plugin] Plugin Updater **Deprecated** | kiwidude | Plugins | 159 | 06-19-2011 12:27 PM |