10-22-2012, 12:48 PM | #31 |
Calibre Plugins Developer
Posts: 4,673
Karma: 2162246
Join Date: Oct 2010
Location: Australia
Device: Kindle Oasis
|
@SFReader2012 - I just took a look at the CSV file, thanks. It comes down to some nasty quality data coming out of LibraryThing. I have put in place a workaround for the next plugin version which handles this situation appropriately.
|
10-22-2012, 04:52 PM | #32 |
Junior Member
Posts: 4
Karma: 10
Join Date: Oct 2012
Device: Kindle for Android
|
Thanks. Very prompt and helpful response. Look forward to the revised plugin in due course.
|
Advert | |
|
10-22-2012, 05:49 PM | #33 |
Calibre Plugins Developer
Posts: 4,673
Karma: 2162246
Join Date: Oct 2010
Location: Australia
Device: Kindle Oasis
|
Beta for version 1.1
Ok, this is a major advancement of this plugin, in three key areas:
It would appreciated if a few of you could give this build a whirl before I officially release it to see if you can break it etc. Last edited by kiwidude; 10-25-2012 at 04:49 PM. Reason: Removed attachment as officially released |
10-25-2012, 07:22 AM | #34 |
Gadget Freak
Posts: 1,169
Karma: 1043832
Join Date: Nov 2007
Location: US
Device: EE, Note 8
|
Beta for version 1.1
|
10-25-2012, 07:42 AM | #35 |
Calibre Plugins Developer
Posts: 4,673
Karma: 2162246
Join Date: Oct 2010
Location: Australia
Device: Kindle Oasis
|
@Gunnerp245 - thanks for feeding back. I think I am going to release it as is tonight since no-one has reported an issue, just need to update all the screenshots.
As for the regex, you can take a look at any of the Goodreads examples included with the plugin for what they do which should hopefully help. Point both series and series index at the same text, then use something like these: Series field: "Include matching text" of: \(([^,\.]+) Series index field: "Include matching text" of: #([\d\.]+) |
Advert | |
|
10-25-2012, 04:51 PM | #36 |
Calibre Plugins Developer
Posts: 4,673
Karma: 2162246
Join Date: Oct 2010
Location: Australia
Device: Kindle Oasis
|
v1.1.0 Released
Changes in this release:
To those of you who tried the beta in the post above a few days ago, please force another download of the plugin (it has the same version number as the beta but I did find a couple of things to fix). |
10-25-2012, 08:26 PM | #37 | |
Gadget Freak
Posts: 1,169
Karma: 1043832
Join Date: Nov 2007
Location: US
Device: EE, Note 8
|
Fantastic!
Quote:
An update to my original post https://www.mobileread.com/forums/sho...0&postcount=11. I desired to know the date I added books to my Goodreads 'to read shelf' (I use recommendations to find interesting books). Adding a custom column in calibre;
Spoiler:
Excellent kiwidude! |
|
10-29-2012, 01:32 PM | #38 |
Reader
Posts: 3
Karma: 10
Join Date: Jul 2010
Device: PRS-300
|
I've exported two Goodreads accounts as csv files, and attempted to import them such that 'My Rating' from one file goes in one custom column, and into a different custom column when I import the second file. [MyRating1; MyRating2]
(I'm actually doing this for many fields, but let's keep the example simple!) These two accounts have several common/matching books, so the same book will be in both files. It appears that the second import erases the information in the columns related to the first file as it populates the columns related to the second file. Is there a way to prevent this? |
10-29-2012, 01:45 PM | #39 |
Calibre Plugins Developer
Posts: 4,673
Karma: 2162246
Join Date: Oct 2010
Location: Australia
Device: Kindle Oasis
|
@tcrabb - I'm not quite sure exactly what you are doing?
You should have two separate CSV configurations setup. One will populate a MyRating1 column, and have no field defined to import for MyRating2. And vice versa. You import from file 1, that creates all the books and populates MyRating1. You then load the configuration for file 2. When you hit the Step 2 match screen, it will show some books already exist (from your first file). At this point you use the Update Metadata feature, and tick only the MyRating2 column to be updated for those selected books. All the other books (which are new that you have created empty books for) should have values automatically set for MyRating2. Even if you did put both MyRating1 and MyRating2 in your same configuration, then it should still work, provided on the Update metadata screen for the selected rows you make sure to only tick the MyRating2 column. |
10-29-2012, 03:03 PM | #40 |
Well trained by Cats
Posts: 30,377
Karma: 58053698
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Just got around to trying this to build a list of missing series (using the Clip board).
The creation of (missing) Empty books works Great but some data was not available. Some questions: How to merge non-included/incomplete data? ex. Nomads of Gor (1969) ISBN 0-7592-5445-1 I can trap all fields shown: the date 1969 is not acceptable to Calibre (failed to show up in Published), it needs to be 1/1/1969 I need to pad a fake MM/DD/ The Author name, series name, is not available, I would like to force it: John Norman and Gor The series index is not available, but is implied by the position in the list (first is 1) BTW I am snagging series info off of the Wikipedia page for the Author |
10-29-2012, 03:40 PM | #41 |
Calibre Plugins Developer
Posts: 4,673
Karma: 2162246
Join Date: Oct 2010
Location: Australia
Device: Kindle Oasis
|
@theducks - I just used this expression for your example:
Code:
(?P<title>.*?) \((?P<pubdate>.*)\) ISBN (?P<identifier:isbn>.*) I had no issues with populating the published date with just that 1969 - calibre created the empty book with a date of 1 Jan 1969 with no extra help. |
10-29-2012, 04:50 PM | #42 | |
Well trained by Cats
Posts: 30,377
Karma: 58053698
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Quote:
Ah! I did not realize I could edit fields. |
|
10-29-2012, 05:49 PM | #43 | |
Reader
Posts: 3
Karma: 10
Join Date: Jul 2010
Device: PRS-300
|
Quote:
Thanks! |
|
12-09-2012, 07:48 AM | #44 |
Zealot
Posts: 109
Karma: 419
Join Date: Aug 2012
Location: Spain
Device: Kindle Touch
|
A question about quotes in CSV files: When using quotes to delimit fields, if inside the data are already quotes, the field is badly chopped.
For example, if the CSV contains Code:
"Mi book","This is a "description" of the book","My author" With other programs (like Notepad++), it's possible to have quotes inside the fields, because it only keep in mind the first quotes after the field separator and the last before new separator. Is it possible for the plugin working at the same way? Last edited by Pepin33; 12-09-2012 at 07:50 AM. |
12-09-2012, 08:31 AM | #45 |
Calibre Plugins Developer
Posts: 4,673
Karma: 2162246
Join Date: Oct 2010
Location: Australia
Device: Kindle Oasis
|
@Pepin33 - that's a pretty ugly CSV file . This plugin actually uses a standard python library (csv) to read the file. Looks like it doesn't handle this situation...
|
Tags |
column types |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
[GUI Plugin] Reading List | kiwidude | Plugins | 1405 | 08-31-2024 05:29 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 |