Hi, I was trying to import my highlights to add new books I read since the last time I imported them but I am getting this error

Error: database disk image is malformed at f.handleError (plugin:obsidian-kobo-highlights-importer-plugin:599:19) at c.step (plugin:obsidian-kobo-highlights-importer-plugin:326:31) at Repository.parseContentStatement (plugin:obsidian-kobo-highlights-importer-plugin:17700:22) at Repository.eval (plugin:obsidian-kobo-highlights-importer-plugin:17659:29) at Generator.next (<anonymous>) at eval (plugin:obsidian-kobo-highlights-importer-plugin:54:61) at new Promise (<anonymous>) at __async (plugin:obsidian-kobo-highlights-importer-plugin:38:10) at Repository.getAllContentByBookTitleOrderedByContentId (plugin:obsidian-kobo-highlights-importer-plugin:17654:12) at HighlightService.eval (plugin:obsidian-kobo-highlights-importer-plugin:17491:40)

How can I fix it?

I have this error when I run the plugin in Obsidian

Error: bookmark seems to link to a non existing content: OEBPS/xhtml/73_Chapter.xhtml
    at HighlightService.eval (plugin:obsidian-kobo…ter-plugin:17348:17)
    at Generator.next (<anonymous>)
    at fulfilled (plugin:obsidian-kobo…porter-plugin:41:24)

Obsidian: 1.5.8
Plugin: 1.5.4

I don't know how to properly debug this. I appreciate all the help that can be provided.

Make it possible to use a template to create the exported notes with.

Why
It could be useful for all who read books in foreign languages
For example, I still learn English and regularly come across words in books that I don’t know. And I mark them in Kobo «for learn».

Because learning words is very inconvenient with Kobo. And Obsidian has a useful Anki plugin for learning words.

What
Make an option to import in a separate note in Obsidian all words that are marked as «saved»
If Kobo has such data, it would be cool to indicate the date when the word was marked when importing. To remove duplicates. Or at least indicate the book within which they are marked.

I'm not sure what is causing my vault to send an error message every time I try to install this plugin, is there a way to install manually?

I was looking through the code and found these two typos.

src/settings/Settings.ts
38:        this.add_temaplte_path();
59:    add_temaplte_path(): void {

the function is both declared and called as a misspelling. So everything is working fine of course, however it could be a recipe for a bug down the track.

I have fixed it on a branch and can push if I get granted access :~)

In Obsidian, you can link to a specific heading.
Translated to exported highlights, I would like to be able to link to a specific highlight.

In the Kindle exporter that I use (https://github.com/hadynz/obsidian-kindle-plugin) this can easily be done, because

• the per-highlight template is editable (apart from the general template)
• there are variables for (for example) location

Ideally, this kind of structure makes it very flexible to export highlights.

Alternatively, just putting a heading above every highlight with the location (i.e. ### location {{ location_number }}) would do the trick even without customizable highlight templates.
We could then immediately "deep-link" to the specific highlights by using [[BookTitle#location loc_number]]

I am trying to run the test suite for this repo.
I am using the command

npm run test

However, when I run the tests, I get the following

Error: ENOENT: no such file or directory, open 'KoboReader.sqlite'

Is it possible to provide instructions on how to obtain the sqlite database used by the test suite?

Hello,
while trying to import my huge database (2695 highlights) I encountered this error:

"Bookmark column returned unexpected null"

After some trial and error, I found that my database, for some reason, had some highlights rows with a blank "text" column (not NULL, blank), and the plugin throws an error thinking the column is NULL.

Deleting those rows fixed the issue.

I suggest changing the SQL WHERE clause in the getAllBookmark() function to check if Text is not null and Text <> '' to fix it

Is it possible to add the page-number where the highlight was made? The highlights seem to be inserted in random order and by adding the page-number it will be easier sorting them.

Edited for clarification

By adding a variable for author name, it will be able to use it for linking to a author document.

Thanks for the plugin! Just great.
I would like to know if there is any chance to import all the book content to the note as well.
It would be very useful to me if I could read from the note the context where I did the highlight or comment.

Thanks!

Error: bookmark seems to link to a non existing content: ops/xhtml/appendixb.html at HighlightService.eval (plugin:obsidian-kobo-highlights-importer-plugin:17348:17) at Generator.next (<anonymous>) at fulfilled (plugin:obsidian-kobo-highlights-importer-plugin:41:24)

Upon selecting extract from the KoboReader.sqlite file, I receive this error. Unsure on how to proceed from here. Device details are as follows:
Kobo Libra 2
Software version: 4.37.21586 (42535ad976, 7/6/23)

First time downloading and trying to use the plugin from the community plugin store, and here is my settings. Thank you and appreciate any guidance.

Hello there :)

I got the following error when trying your plugin. Is there anything I can do to fix this?

plugin:obsidian-kobo-highlights-importer-plugin:17595 Error: filtering by contentId yielded more then 1 result: /mnt/onboard/Martraire, Cyrille/Living Documentation - Cyrille Martraire.kepub.epub!OEBPS!chap17.xhtml#leanpub-auto-accuracy-mechanism
    at Repository.eval (plugin:obsidian-kobo-highlights-importer-plugin:17442:15)
    at Generator.next (<anonymous>)
    at eval (plugin:obsidian-kobo-highlights-importer-plugin:50:61)
    at new Promise (<anonymous>)
    at __async (plugin:obsidian-kobo-highlights-importer-plugin:34:10)
    at Repository.getContentLikeContentId (plugin:obsidian-kobo-highlights-importer-plugin:17432:12)
    at HighlightService.eval (plugin:obsidian-kobo-highlights-importer-plugin:17311:35)
    at Generator.next (<anonymous>)
    at fulfilled (plugin:obsidian-kobo-highlights-importer-plugin:37:24)

Obsidian Book search is a great plugin for automatically creating notes for the books you are reading. It pulls meta data from the web and allows you to replace {{Variables}} in your notes much like this plugin does.

I would like to use book search to create the book note, and then kobo highlights import to get all my highlights and notes and add them to the same note. But currently I can't mix the two just yet as this plugin saves the highlights/notes, whipes all properties, re-applies the template, and then re-applies the highlights/notes.

This is ok if I am only using Kobo to get the meta data for my notes properties. But I just combined my two templates used for book search and kobo highlights import. I then transferred some of the properties from the book note to the highlight note such as Cover link, and rating and this plugin did not save the values but reverted them to their template form. Which sinse kobo highlight import does not recognizes coverUrl as a tag for example just left it as {{coverUrl}}

This issue lists Renovate updates and detected dependencies. Read the Dependency Dashboard docs to learn more.

Other Branches

These updates are pending. To force PRs open, click the checkbox below.

• ci(github-action): update actions/setup-node action to v3.6.0

Open

These updates have all been created already. Click a checkbox below to force a retry/rebase of any.

• fix(deps): update @types/better-sqlite3 to 7.6.4
• fix(deps): update esbuild to 0.18.2
• feat(docker-image)!: Update Node.js to v20
• feat(docker-image)!: Update mcr.microsoft.com/vscode/devcontainers/javascript-node Docker tag to v20
• Click on this checkbox to rebase all open PRs at once

Detected dependencies

As revealed in #91 , deleting a highlight in the kobo does not delete the highlight from its corresponding markdown file upon resyncing.

The ramification of this is that users will only ever be able to add additional highlights in the document. They cannot remove a highlight.

Examples of use case:

• a highlight is perhaps no longer relevant
• a highlight was created by accident and only noticed on initial sync

Add setting for using daily note path, to make the highlight creation date link navigate to daily note.

OPTIONAL: Make link creation optional?

On the new colour kobo ereaders there's an extra column in the Bookmark (Color) which is an int indicating the highlight colour of the highlight:

• 0 yellow
• 1 pink
• 2 blue
• 3 green

it would be great to be able to set different callouts for each of these in the plugin options!

great plugin , thank u

hello, is it possibile to have also chapter? So a note would populate like:

### Chapter 1
- Highlight
- Highlight

### Chapter 2
- Highlight
...
...

Thank's

It would be nice to be able to sync highlights to an existing file (such as notes created by Book Search). Initially, I considered using the ISBNs from the SQLite database and matching them with an ISBN field in the frontmatter for this purpose. However, the complexity arises due to the nature of ISBNs. Since a single book may have multiple ISBNs, varying with the publisher and edition, this method might result in incorrect identification of many books. A more reliable, albeit slightly unorthodox, approach could be to perform string matching between the book's title/author fields between the SQLite database and frontmatter.

Should this feature seem like a viable addition to the code base, I am happy to contribute by submitting a PR.

This issue lists Renovate updates and detected dependencies. Read the Dependency Dashboard docs to learn more.

Errored

These updates encountered an error and will be retried. Click on a checkbox below to force a retry now.

• ci(github-action): update renovatebot/github-action action to v40.1.7
• fix(deps): update @types/chai to 4.3.14
• fix(deps): update @types/node to 20.11.30
• fix(deps): update esbuild to 0.20.2
• fix(deps): update typescript to 5.4.3
• feat(deps): update mocha to 10.4.0
• feat(deps): update sql.js to 1.10.2
• feat(deps): update typescript-eslint monorepo to 7.4.0 (minor) (@typescript-eslint/eslint-plugin, @typescript-eslint/parser)
• ci(github-action)!: Update DeterminateSystems/magic-nix-cache-action action to v4
• feat(deps)!: Update chai to 5.1.0

Detected dependencies

Add the ability to include notes made in the export.

Relates to: bitwiseops#2

Painfully realised that currently when importing highlights, the entire highlights page is generated fresh.
This means that any caret references, edits to highlight notes are broken / overwritten on each import.

This limits the usefulness of the plugin quite severely as the highlights page can only then ever be used as a visual reference to read and remind ones self (or copy and paste 😵), and therefore not truly integrated into the Obsidian / Zettelkasten note making workflow.

I think the simplest solution around this would be to simply append new highlights / notes to the highlights file instead of overwriting the whole file completely with a fresh import. From memory the Kindle highlights plugin works this way.

Is it realistic to look into something like this? Would be immensely appreciated.
I want to help, but my programming chops are probably not going to do much.

I'd be happy to update and extend the documentation if needs be though.

Hey, why I am not getting the template details. They are stored on the kobo, like the descriptions etc. but nothing else.

Thanks in advance!

When i tried to extract notes from my kobo i get an error that something went wrong.
Kobo and plugin are up to date.

Here is the output of the console:

plugin:obsidian-kobo-highlights-importer-plugin: 17638 TypeError: Cannot read properties of undefined (reading 'values')

at Repository.eval (plugin:obsidian-kobo-highlights-importer-plugin:17399:14)

at Generator.next (<anonymous>)

at eval (plugin:obsidian-kobo-highlights-importer-plugin:54:61)

at new Promise (<anonymous>)

at __async (plugin:obsidian-kobo-highlights-importer-plugin:38:10)

at Repository.getAllBookmark (plugin:obsidian-kobo-highlights-importer-plugin:17396:12)

at HighlightService.eval (plugin:obsidian-kobo-highlights-importer-plugin:17330:41)

at Generator.next (<anonymous>)

at eval (plugin:obsidian-kobo-highlights-importer-plugin:54:61)

at new Promise (<anonymous>)`