List of Cardbox words

Louisa Atsas

unread,

Dec 17, 2020, 9:04:52 AM12/17/20

to Collins Zyzzyva

Hi, is there any way that I can see a list of my current cardbox words please?

Darren Chaitman

unread,

Apr 22, 2021, 12:23:44 AM4/22/21

to Collins Zyzzyva

Hello,

Looks like this was never answered.

I'm wondering the same thing, I would love to be able to see such a list or get it as a text file somehow.

Does anyone know if this is possible?

Cheers,

Darren

sch...@gmail.com

unread,

Jun 17, 2021, 8:03:40 PM6/17/21

to Collins Zyzzyva

Hi there,

You can get a list of the alphagrams. If you install a program called "DB Browser for SQLite," you can search the .db files that Zyzzyva uses to store cardboxes. You can get a list of the quiz questions/alphagrams from there.

The steps for a CSW19 cardbox would be would be:

1. Locate your data directory (in Preferences -> General -> Data Directory)

2. Within that directory, open /quiz/data/CSW19/Anagrams.db with DB Browser

3. Tab over to "Execute SQL"

4. Enter the following without quotes: "select question from questions"

You should see a single file list of alphagrams. From there you have several options. Ctrl+A -> Ctrl+C, or click on the word "question" in the results screen to select all and right click to copy to clipboard. I believe there are also options to export.

BTW - for power users, there are many other things you can do using this method - I've used it to do things like move all the fours to cardbox 2 unless I've seen them in the last 3 months. You can run any SQL command on the questions table, execute it, and save it back to Zyzzyva.