Importing MobileRead library into calibre library

[kovidgoyal]

If you want multiple URLs per book, and you dont want to write a metadata plugin, your best bet is a custom HTML column,which will alos display in the book details panel as clickable links.

EDIT: Or you can just add the links to the normal comments, which also support HTML.

[davidfor]

Originally Posted by Alexander Turcic

@BetterRed, @davidfor, I tested importing the extra metadata via an opf file (which would be another easy solution as I could include all the extra data in the opf while extracting the attachments from the MR database), but it appears that calibre then erases part of the existing metadata.

$ calibredb add ~/mrlibrary/AlexBell/255021/134208_What\ Diantha\ Did\ -\ Charlotte\ Perkins\ Gilman.mobi   

Backing up metadata
Added book ids: 8
Notifying calibre of the change

$ calibredb show_metadata 8

Title               : What Diantha Did
Title sort          : What Diantha Did
Author(s)           : Charlotte Perkins Gilman [Gilman, Charlotte Perkins]
Publisher           : Bellware
Tags                : romance, humanism, servant question
Languages           : eng
Timestamp           : 2015-01-30T12:18:08+00:00
Published           : 2015-01-24T13:00:00+00:00
Identifiers         : mobi-asin:cec96dd0-e53e-4f26-b392-166f8c160ce4
Comments            : <p class="description">'What Diantha Did' was serialised in 'The Forerunner' from November 1909 to October 1910, and published separately in 1910. The main themes are 'The servant question' and the grief caused by having to do work in which one is not interested; set against a background of future female in-laws who would be ashamed to earn their own living, and a fiance who believes that 'No man - that is a man - would marry a woman and let her run a business.'</p>

$ cat ~/mrlibrary/AlexBell/255021/metadata.opf        
<?xml version='1.0' encoding='utf-8'?>
<package xmlns="http://www.idpf.org/2007/opf" unique-identifier="uuid_id" version="2.0">
    <metadata xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:opf="http://www.idpf.org/2007/opf">
        <meta name="calibre:user_metadata:#uploader" content="{&quot;kind&quot;: &quot;field&quot;, &quot;#value#&quot;: &quot;alex&quot;, &quot;column&quot;: &quot;value&quot;, &quot;colnum&quot;: 1, &quot;is_multiple&quot;: null, &quot;is_multiple2&quot;: {}, &quot;search_terms&quot;: [&quot;#uploader&quot;], &quot;is_csp&quot;: false, &quot;is_category&quot;: true, &quot;table&quot;: &quot;custom_column_1&quot;, &quot;is_custom&quot;: true, &quot;is_editable&quot;: true, &quot;rec_index&quot;: 22, &quot;link_column&quot;: &quot;value&quot;, &quot;label&quot;: &quot;uploader&quot;, &quot;#extra#&quot;: null, &quot;datatype&quot;: &quot;text&quot;, &quot;name&quot;: &quot;Uploader&quot;, &quot;category_sort&quot;: &quot;value&quot;, &quot;display&quot;: {&quot;use_decorations&quot;: 0}}"/>
    </metadata>
</package>

$ calibredb set_metadata 8 ~/mrlibrary/AlexBell/255021/metadata.opf     

Title               : Unknown
Title sort          : Unknown
Author(s)           : Unknown
Publisher           : Bellware
Tags                : romance, humanism, servant question
Languages           : eng
Timestamp           : 2015-01-30T12:18:08+00:00
Published           : 2015-01-24T13:00:00+00:00
Identifiers         : mobi-asin:cec96dd0-e53e-4f26-b392-166f8c160ce4
Comments            : <p class="description">'What Diantha Did' was serialised in 'The Forerunner' from November 1909 to October 1910, and published separately in 1910. The main themes are 'The servant question' and the grief caused by having to do work in which one is not interested; set against a background of future female in-laws who would be ashamed to earn their own living, and a fiance who believes that 'No man - that is a man - would marry a woman and let her run a business.'</p>
Uploader            : alex
Backing up metadata
Notifying calibre of the change

The Uploader field was set correctly, but notice how Title, Title sort and Author are erased?

I have to admit I didn't test this, I just knew that calibre looked for the OPF when the books is added. But, I was assuming the OPF would contain all the metadata for the book.
[/QUOTE]
@davidfor, I love the idea of a metadata source plugin that could translate the attachment id to a relevant URL! Would that be very difficult to write?[/QUOTE]

The identifier part is easy. Just look at any of the metadata source plugins and implement the get_book_url method. If you want to add the search and metadata download parts, it depends on how the site the metadata comes from is coded.

[Jellby]

Originally Posted by eschwartz

See the OverDrive Link plugin, which does the same thing for OverDrive library links.

{identifiers:select(odid)} ==

UUID****-****-****-****-************@library1.lib.overdrive.com&\
UUID****-****-****-****-************@library2.lib.overdrive.com&\
UUID****-****-****-****-************@library3.lib.overdrive.com

And then maps those to the appropriate links.

Does it actually give several clickable links, or are these only links used internally to fetch metadata, invisible to the user?

[kovidgoyal]

With this commit: https://github.com/kovidgoyal/calibr...bcfb205a60f0e2

you can now put have any number of url identifiers in that become clickable links by doing:

url1:http://...
url2:http://...
and so on

[Jellby]

Thanks, I was thinking of saving the attachment ids with a scheme such as:

mr:epub_12345&mobi_23456&pdf_34567

I've written a metadata source plugin that picks up one of the formats (configurable) in the identifier and generates an url, with the get_book_url() method. Would it be possible to extend the feature such that it can return a list of 3-tuples instead of a single one (and use all the returned urls)?

[kovidgoyal]

Here you go:

https://github.com/kovidgoyal/calibr...c718b8830e69f2