Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Plugins

Notices

Reply
 
Thread Tools Search this Thread
Old 04-29-2018, 12:26 PM   #331
maxlinworm
Junior Member
maxlinworm began at the beginning.
 
Posts: 2
Karma: 10
Join Date: Feb 2018
Device: ipad
Importing from mendeley

Hi,

I'm migrating my extensive library from mendeley.

To do that, I exported my files from mendeley with the filenames: “AuthorLastName – BookTitle”

I added the mendeley files in calibre, extracting the metadata. So, my books in calibre contain only the author last name and the title.

Next, I exported a csv file with the complete metadata from mendeley. Then I tried to use this awesome plugin to update the incomplete calibre metadata. So, the plugin would update the incomplete book entry in calibre with the complete metadata from mendeley.

The problem was that the plugin never matches the books that I had added, because it searches form the author full name, and I only have the last name in calibre. So, the plugin doesn't match the metadata in the list to the book entry in calibre.

If I manually edit the plugin wizard search to remove the author first name, making it search only for the last name, it matches the book already in the calibre library and updates its metadata correctly. Trouble is I have a very large library, so manually editing the search is unfeasible.

Is there a way to make the search on the wizard use only the author last name as a parameter? In other words: to make the plugin wizard match the calibre entry only by the lastname of the author. In other words still: to remove the first name from the plugin wizard search criteria.

That way, the plugin would automatically update the incomplete calibre metadata (author last name and book title) obtained when I added to calibre the exported files form mendeley with the complete mendeley metadata.

Or does anyone have another suggestion?

I attached 3 printscreens for clarity. The first shows the books added from mendeley with incomplete metadata (authorLastName - BookTitle). The second shows the matching problem. And the third shows that the plugin matches the existing books if I remove the author's first name from the search.

Thanks in advance.
Attached Thumbnails
Click image for larger version

Name:	1.jpg
Views:	48
Size:	173.2 KB
ID:	163739   Click image for larger version

Name:	2.jpg
Views:	43
Size:	1.19 MB
ID:	163740   Click image for larger version

Name:	3.jpg
Views:	31
Size:	1.10 MB
ID:	163741  
maxlinworm is offline   Reply With Quote
Advert
Old 04-29-2018, 09:15 PM   #332
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 14,524
Karma: 24607224
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo: Touch, Glo, Aura H2O, Glo HD, Aura ONE
@maxlinworm: To do what you want, the plugin would need to be changed to do the matching in this way. Sorry, but I have no interest in making that change. It would be much better to change the book export from Mendeley to include the full authors name in the file name.

A workaround would be:
  1. Add a custom column called something like "Full Author Name".
  2. Add a column in your spreadsheet that has just the surname.
  3. During the import, match the surname column in the spreadsheet with the author in the library and populate the custom column with the full author name.
  4. After the import, use the find and replace to move the full author name from the custom column to the author column.

Something else that will work, is to edit the author via the "Manage Authors" dialog. If you fix the author names here, then all books by that author will be updated to use the same author. Of course, that doesn't work if you have authors with the same surname. For these, you would need to select the books in the library and use the bulk edit to change the author. Of course, this isn't practical if you basically have one book per author.
davidfor is online now   Reply With Quote
Old 05-15-2018, 10:40 AM   #333
redbaronix
Junior Member
redbaronix began at the beginning.
 
Posts: 1
Karma: 10
Join Date: May 2018
Device: IPAD-2
Importing from Amazon Wish List

Hi,

Anybody know how to import a wish list form Amazon Canada? Sorry if this was answered somewhere on MobileRead...couldn't find how to do this.

I've done it manually copy/paste the wish list (from print view) to CSV file but it's a pain.

Anyone has a better way?

Thanks
redbaronix is offline   Reply With Quote
Old 05-15-2018, 08:20 PM   #334
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 14,524
Karma: 24607224
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo: Touch, Glo, Aura H2O, Glo HD, Aura ONE
Quote:
Originally Posted by redbaronix View Post
Hi,

Anybody know how to import a wish list form Amazon Canada? Sorry if this was answered somewhere on MobileRead...couldn't find how to do this.

I've done it manually copy/paste the wish list (from print view) to CSV file but it's a pain.
You can't import from a page like this directly. You will need to login to Amazon to do this and the plugin doesn't support any sort of authentication.

What you can try is to save the page to disk and then import from that. From memory, the web page method can use a URL like "file:///path-to-saved-web-page". Once you have done this, you can save the import for next time.

Alternatively, save the page and edit it to make it into a CSV. That will take time, but sometimes it is the simplest way.
davidfor is online now   Reply With Quote
Old 05-17-2018, 10:17 PM   #335
Sarmat89
Zealot
Sarmat89 ought to be getting tired of karma fortunes by now.Sarmat89 ought to be getting tired of karma fortunes by now.Sarmat89 ought to be getting tired of karma fortunes by now.Sarmat89 ought to be getting tired of karma fortunes by now.Sarmat89 ought to be getting tired of karma fortunes by now.Sarmat89 ought to be getting tired of karma fortunes by now.Sarmat89 ought to be getting tired of karma fortunes by now.Sarmat89 ought to be getting tired of karma fortunes by now.Sarmat89 ought to be getting tired of karma fortunes by now.Sarmat89 ought to be getting tired of karma fortunes by now.Sarmat89 ought to be getting tired of karma fortunes by now.
 
Posts: 122
Karma: 2076832
Join Date: Nov 2015
Device: none
1. Is there a way to specify the codepage for the CSV files? By default, there are invalid characters instead of letters.
2. Is it possible to add the localization support?
Sarmat89 is offline   Reply With Quote
Old 05-17-2018, 11:26 PM   #336
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 14,524
Karma: 24607224
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo: Touch, Glo, Aura H2O, Glo HD, Aura ONE
Quote:
Originally Posted by Sarmat89 View Post
1. Is there a way to specify the codepage for the CSV files? By default, there are invalid characters instead of letters.
Not at the moment. Can you post or send me an example with the codepage to use to check?
Quote:
2. Is it possible to add the localization support?
It is possible, but it is a bit of work. It means going through all the code and converting each displayed string to a translatable string. And then someone writing the translations. I'll put it on the wishlist, but I'm not promising it any time soon.
davidfor is online now   Reply With Quote
Old 05-17-2018, 11:44 PM   #337
Sarmat89
Zealot
Sarmat89 ought to be getting tired of karma fortunes by now.Sarmat89 ought to be getting tired of karma fortunes by now.Sarmat89 ought to be getting tired of karma fortunes by now.Sarmat89 ought to be getting tired of karma fortunes by now.Sarmat89 ought to be getting tired of karma fortunes by now.Sarmat89 ought to be getting tired of karma fortunes by now.Sarmat89 ought to be getting tired of karma fortunes by now.Sarmat89 ought to be getting tired of karma fortunes by now.Sarmat89 ought to be getting tired of karma fortunes by now.Sarmat89 ought to be getting tired of karma fortunes by now.Sarmat89 ought to be getting tired of karma fortunes by now.
 
Posts: 122
Karma: 2076832
Join Date: Nov 2015
Device: none
A list in Windows encoding.
Attached Files
File Type: zip list_latin1.zip (688 Bytes, 12 views)
Sarmat89 is offline   Reply With Quote
Old 05-27-2018, 05:52 PM   #338
towermancn
Junior Member
towermancn began at the beginning.
 
Posts: 2
Karma: 10
Join Date: May 2018
Device: kindle paperwhite
can't open this plugin

I just tried to install this plugin, but can't see anything in preferences. I have the newest version of calibre. Does anybody know what happened? How can I see the Step 1?
Attached Thumbnails
Click image for larger version

Name:	importlist plugin error2.png
Views:	33
Size:	86.7 KB
ID:	164139  
towermancn is offline   Reply With Quote
Old 05-27-2018, 06:44 PM   #339
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 21,677
Karma: 20975546
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: K4NT, Galaxy Tab 2(RIP)
There are none (at that level/method)
Run the Plugin for options
theducks is offline   Reply With Quote
Old 05-27-2018, 09:36 PM   #340
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 14,524
Karma: 24607224
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo: Touch, Glo, Aura H2O, Glo HD, Aura ONE
@towermancn: As theducks said, there are no configuration options for the plugin at that level. The dialog you are looking at will show the options you select when using the plugin, but in an internal storage method. It is mainly intended for troubleshooting.
davidfor is online now   Reply With Quote
Old 05-28-2018, 03:23 PM   #341
towermancn
Junior Member
towermancn began at the beginning.
 
Posts: 2
Karma: 10
Join Date: May 2018
Device: kindle paperwhite
@davidfor @theducks
thanks! problem is solved!
towermancn is offline   Reply With Quote
Old 05-29-2018, 03:26 PM   #342
yonkyunior
Collectors
yonkyunior began at the beginning.
 
yonkyunior's Avatar
 
Posts: 67
Karma: 10
Join Date: Feb 2015
Device: Android
need help, for importing list from worldswithoutend,

http://worldswithoutend.com/lists_cl...f.asp?type=xml

Row
//*[@id="reportlist"]//div[@class="awardslisting"]

Title
p[@class="title"]/text()
Author
p[@class="author"]/text()

the marker show the right match, but, the field table empty..
Attached Files
File Type: txt worldswithoutend.txt (252.1 KB, 8 views)
yonkyunior is offline   Reply With Quote
Old 05-31-2018, 08:40 AM   #343
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 14,524
Karma: 24607224
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo: Touch, Glo, Aura H2O, Glo HD, Aura ONE
Quote:
Originally Posted by yonkyunior View Post
need help, for importing list from worldswithoutend,

http://worldswithoutend.com/lists_cl...f.asp?type=xml

Row
//*[@id="reportlist"]//div[@class="awardslisting"]

Title
p[@class="title"]/text()
Author
p[@class="author"]/text()

the marker show the right match, but, the field table empty..
The result of your expressions for the title and author include a carriage return and lot of extra spaces. You need to be a bit more specific with these The following seems to work:

Row
//div[@class="awardslisting"]

Title
p[@class="title"]/a/text()
Author
p[@class="author"]/a/text()
davidfor is online now   Reply With Quote
Old 05-31-2018, 10:08 AM   #344
yonkyunior
Collectors
yonkyunior began at the beginning.
 
yonkyunior's Avatar
 
Posts: 67
Karma: 10
Join Date: Feb 2015
Device: Android
Thumbs up

Quote:
Originally Posted by davidfor View Post
The result of your expressions for the title and author include a carriage return and lot of extra spaces. You need to be a bit more specific with these The following seems to work:

Row
//div[@class="awardslisting"]

Title
p[@class="title"]/a/text()
Author
p[@class="author"]/a/text()
great! THX
this setting almost reusable for the whole site lists.
yonkyunior is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[GUI Plugin] Reading List kiwidude Plugins 787 03-20-2018 11:39 AM
[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


All times are GMT -4. The time now is 06:23 AM.


MobileRead.com is a privately owned, operated and funded community.