A script to pull Kindle Vocabulary Builder DB and convert into Memrise course (kindle2memrise.py)

Another script (uploadAudio.py) can upload audio mp3s to the course.

The latest Kindle Paperwhite (second generation) offers the Vocabulary Builder feature. With Vocabulary Builder, you can look up words with the dictionary and memorize their definitions.

For my self-education I use http://memrise.com/ (both on my phone and desktop PC). I thought it would be great to pull words which I've checkded when reading English books on my Kindle and push them into my Memrise course.

1. The script reads through the vocab.db to look for all Engligh words (in table WORDS).
2. Each of the words (aka stems) is used for a definition lookup in the Cambridge Dictionary
3. Retreve word definitions, usage example, pronounciation, audio mp3 and insert into a new SQLite database memrise.db (the mp3 is written to the disk only, folder audio)
4. Each new word is written to a text file, in a format suitable for bulk words import into Memrise.

1. Get list of all words from the course
2. If a word still does not have any audio file...
3. ...retireves mp3 filename from the DB created in the 1st stage
4. Uploads the mp3 to Memrise

• Kindle Paperwhite (or newer)
• vocab.db file (retrieved from your Kindle, from /Volumes/Kindle/system/vocabulary/)
• python 3
• BeautifulSoup
• requests

I heavily sourced from two GitHub projects:

• cambridge-cli
• bulk-audio-upload

Also, I was using these documents and toold:

• BeautifulSoup
• requests
• Edit This Cookie!

And finally, my webpage:

• http://jhartman.pl

• Parametrize hardcoded things - especially language pair English-Polish
• Upload Audio files with prononciation

MBP:kindle-to-memrise jhartman$ ./kindle2memrise.py -h
usage: kindle2memrise.py [-h] [-kindleDB KINDLEDB]
                         [-dictionaryDB DICTIONARYDB] [-output OUTPUT]
                         [-revision REVISION] [-debug]

optional arguments:
  -h, --help            show this help message and exit
  -kindleDB KINDLEDB    Kindle vocabulary db filename (default: vocab.db)
  -dictionaryDB DICTIONARYDB
                        Memrise dictionary db filename (default: memrise.db)
  -output OUTPUT        Output file to import to memrise.com (default:
                        memrise.txt)
  -revision REVISION    Revision to output. Not specfied (default): last, 0 -
                        all
  -debug                Enable debug

At minimum, the tool does not require any parameters, it will search for vocab.db in the current folder and will write output files into the same, current folder.

Pay your special attention to memrise.txt which has been generated:

MBP:kindle-to-memrise jhartman$ tail memrise.txt
mere	Sam. Used to emphasize that something is not large or important. Example: It costs a mere twenty dollars.	mɪər
thinning	Rozcieńczać, rozrzedzać. To make a substance less thick, often by adding a liquid to it. Example: N/A	θɪn
carnivore	Zwierzę mięsożerne. An animal that eats meat. Example: N/A	ˈkɑːnɪvɔːr
embrace	Obejmować (się). If you embrace someone, you put your arms around them, and if two people embrace, they put their arms around each other.. Example: We are always eager to embrace the latest technology.	ɪmˈbreɪs

This is the file, which will be used for bulk word add into your Course.

Create a new Course.

In the course, add two new columns: Definition and Example.

Edit settings for both of new columns, edit attributes:

• Definition - edit settings:
  • Display - only Show after tests is selected
  • Testing - all options unselected
• Example - edit settings:
  • Display - all options unselected
  • Testing - only Tapping Tests Enabled is selected

Go to your Course, press Edit and in the Advanced options, look for Bulk add words:

Open memrise.txt in an editor (e.g. Notepad), select all, copy it and paste into Memrise Bulk Add form then press Add:

usage: uploadAudio.py [-h] [-dictionaryDB DICTIONARYDB] [-revision REVISION]
                      [-course COURSE] [-debug]

optional arguments:
  -h, --help            show this help message and exit
  -dictionaryDB DICTIONARYDB
                        Memrise dictionary db filename (default: memrise.db)
  -revision REVISION    Revision to output. Not specfied (default): last, 0 -
                        all
  -course COURSE        Memrise course ID
  -debug                Enable debug

1. Login to the memrise and export cookies (using Chrome Edit This Cookie! extension)
2. TBD