Transport Kindle Words to Anki (General discussion) Language Learning Forum

Transport Kindle Words to Anki
Tags: Anki \| Vocabulary learning
Share with: Delicious Digg reddit Facebook StumbleUpon
Language Learning Forum : General discussion

11 messages over 2 pages: 1 2

Doitsujin
Diglot
Senior Member
Germany
Joined 5322 days ago
1256 posts - 2363 votes

Speaks: German*, English

Message 9 of 11

12 June 2014 at 10:44am | IP Logged

LtM wrote:

The Vocabulary Builder is terrific! When I was first exploring it, I was worried that all of my looked-up words would be jumbled together in a confusing mix, but the Kindle also groups them according to the individual books that they originate from (especially important to those of us who read multiple languages on our device).

I finally got a PW and did some tests. It turns out that Vocabulary Builder only works with books not tagged as Personal docs. (The Kindle firmware tags all non-Amazon Kindle books without CDE: EBOK and ASIN metadata entries als personal docs, but this can be fixed with the proper Calibre settings.)

BTW, the Kindle saves all looked up words in an sqlite3 database in /system/vocabulary/vocab.db. You can explore this database with the SQLite Manager Firefox add-on or directly manipulate the table with sqlite3. For more information, see this MR post.
BTW, SQLite Manager also allows you to export tables as .csv files that you can edit with a speadsheet program. (The most useful table is LOOKUPS.)

I'm still curious about emk's Kindle tool. Since emk seems to be awfully busy these days, I'd really appreciate it, if another HTLAL member could tell me more about this tool and maybe send me a download link via PM.

1 person has voted this message useful

emk
Diglot
Moderator
United States
Joined 5534 days ago
2615 posts - 8806 votes

Speaks: English*, French^B2
Studies: Spanish, Ancient Egyptian
Personal Language Map

Message 10 of 11

12 June 2014 at 1:15pm | IP Logged

Doitsujin wrote:

I'm still curious about emk's Kindle tool. Since emk seems to be awfully busy these days, I'd really appreciate it, if another HTLAL member could tell me more about this tool and maybe send me a download link via PM.

Please don't share links to my tool quite yet. Some of the features actually cost me money when people use them (particularly the Google Translate integration), and while I'm happy to provide them for free to HTLAL testers, I want to make sure that I don't have to remove any features from the free version once people have already created accounts. So I'm keeping it private while I figure out how much I can afford to give away.

And sorry, Doitsujin, for not responding to your PM more quickly. I've sent you an email.
1 person has voted this message useful

Doitsujin
Diglot
Senior Member
Germany
Joined 5322 days ago
1256 posts - 2363 votes

Speaks: German*, English

Message 11 of 11

17 September 2014 at 4:12pm | IP Logged

I've toyed around with the Kindle Vocabulary Builder app and I've found out that it's relatively easy to extract the looked-up words from the internal vocab.db sqlite3 database with the SQLite Manager Firefox plugin:

1. Connect your Paperwhite to your PC and copy vocab.db from the system\vocabulary folder to your PC.

2. Install the SQLite Manager plugin, select it from the Firefox Tools menu, select Connect Database and select your copy of vocab.db. (You'll need to change file extension filter to "all files (*.*)" to see it.)

3. Click the Execute SQL tab, enter one of the following 3 commands and click Run SQL:

a) Extract all words:

Code:

SELECT WORDS.lang, word, stem, usage, authors, title, category  FROM LOOKUPS JOIN WORDS on LOOKUPS.word_key=WORDS.id JOIN BOOK_INFO on LOOKUPS.book_key=BOOK_INFO.id;

b) Extract all mastered words:

Code:

SELECT WORDS.lang, word, stem, usage, authors, title, category  FROM LOOKUPS JOIN WORDS on LOOKUPS.word_key=WORDS.id JOIN BOOK_INFO on LOOKUPS.book_key=BOOK_INFO.id  where category=100;

c) Extract all not mastered words:

Code:

SELECT WORDS.lang, word, stem, usage, authors, title, category  FROM LOOKUPS JOIN WORDS on LOOKUPS.word_key=WORDS.id JOIN BOOK_INFO on LOOKUPS.book_key=BOOK_INFO.id  where category=0;

4. Select all rows, copy them to the clipboard and paste them into a spreadsheet for further processing.

Note that Vocabulary Builder does not store the actual dictionary definition in the sqlite3 database.

2 persons have voted this message useful

This discussion contains 11 messages over 2 pages: << Prev 1 2

If you wish to post a reply to this topic you must first login. If you are not already registered you must first register

Printable version

You cannot post new topics in this forum - You cannot reply to topics in this forum - You cannot delete your posts in this forum
You cannot edit your posts in this forum - You cannot create polls in this forum - You cannot vote in polls in this forum

This page was generated in 0.2188 seconds.