Can the My Word List be transferred to another device?

marshap · 12-13-2018, 10:41 AM

I have enabled the hidden vocabulary builder feature on my H2O. I have accumulated a substantial list of saved words and I would like to transfer the list to another Kobo. I presume the word list is contained in a database on the reader, but I cannot find it and don't know how to access it. Any ideas on how the list can be transferred to a new reader?

jackie_w · 12-13-2018, 11:57 AM

The answer to the easy part of your question ...

The list is stored in the WordList table of the Kobo device's database in /.kobo/KoboReader.sqlite

As to the best way (or any way) to export that to a different Kobo, I'm not sure. Perhaps one of the SQLite gurus will come along and offer some ideas.

geek1011 · 12-13-2018, 03:52 PM

Just do sqlite3 KoboReader.sqlite '.dump WordList' to a file, then run it in the new database to restore. Note that WordList is joined on column VolumeId, so it may not work unless you have the same file structure on the target kobo (I haven't used my words, so I can't say if it'll make a difference).

marshap · 12-14-2018, 11:39 AM

Thanks Geek1011, but I'm not schooled in sql and think it is too abstract for me. I'll just have to make a new list as my reading progresses. I would think Kobo would want to make it easy to transfer the list because not being able to is a good reason not to upgrade to a new device if the old one is still working.

12-13-2018, 10:41 AM	#1
marshap Enthusiast Posts: 26 Karma: 10 Join Date: Apr 2012 Device: Libra 2	Can the My Word List be transferred to another device? I have enabled the hidden vocabulary builder feature on my H2O. I have accumulated a substantial list of saved words and I would like to transfer the list to another Kobo. I presume the word list is contained in a database on the reader, but I cannot find it and don't know how to access it. Any ideas on how the list can be transferred to a new reader?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
checking the list of the books on the device without connecting the device itself	piosza	Library Management	2	06-28-2017 09:28 PM
Books transferred from Calibre to device not being recognised	Sarah900	Devices	4	12-20-2016 01:46 PM
Any method to keep book series sorted/grouped when transferred to device?	badbob001	Library Management	3	02-02-2015 01:36 PM
Kindle Fire Dictionary Word List idea	Euridice01	Kindle Developer's Corner	2	08-29-2012 11:20 AM
Process/modify files as they are transferred to a device?	snarkophilus	Calibre	4	01-06-2012 06:18 AM

12-13-2018, 11:57 AM	#2
jackie_w Grand Sorcerer Posts: 6,206 Karma: 16228558 Join Date: Sep 2009 Location: UK Device: Kobo: KA1, ClaraHD, Forma, Libra2, Clara2E. PocketBook: TouchHD3	The answer to the easy part of your question ... The list is stored in the WordList table of the Kobo device's database in /.kobo/KoboReader.sqlite As to the best way (or any way) to export that to a different Kobo, I'm not sure. Perhaps one of the SQLite gurus will come along and offer some ideas.

12-13-2018, 03:52 PM	#3
geek1011 Wizard Posts: 2,730 Karma: 6678757 Join Date: May 2016 Location: Ontario, Canada Device: Kobo Mini, Aura Edition 2 v1, Clara HD	Just do sqlite3 KoboReader.sqlite '.dump WordList' to a file, then run it in the new database to restore. Note that WordList is joined on column VolumeId, so it may not work unless you have the same file structure on the target kobo (I haven't used my words, so I can't say if it'll make a difference).

12-14-2018, 11:39 AM	#4
marshap Enthusiast Posts: 26 Karma: 10 Join Date: Apr 2012 Device: Libra 2	Thanks Geek1011, but I'm not schooled in sql and think it is too abstract for me. I'll just have to make a new list as my reading progresses. I would think Kobo would want to make it easy to transfer the list because not being able to is a good reason not to upgrade to a new device if the old one is still working.

Advert