It is not complicated; at least not on linux. I had done this several months ago. But I hope the procedure still works.
(1) Downloaded the latest release of the program offline-chess-puzzles from https://github.com/brianch/offline-chess-puzzles/releases (the file for linux is offline-chess-puzzles-2.0.0-linux.tar.gz, but there are also files for windows 7 and 10).
(2) In a terminal extract the program by running the command:
tar xvf offline-chess-puzzles-2.0.0-linux.tar.gz
I did it in the directory ~/.local, and it created a sub-directory offline-chess-puzzles
(3) Download lichess_db_puzzle.csv.bz2 from https://database.lichess.org/#puzzles
(4) Extract the program by running the following command:
bunzip2 -d lichess_db_puzzle.csv.bz2
It unzips the puzzles database and gives you the csv file - csv files can be opened with exel or similar programs, but this one is rather big. There are ways (at least on linux) to split the file into many small parts.
(5) Move the csv file to the directory /path-to/offlinep-chess-puzzles/puzzles (in my case is ~/.local/offline-chess-puzzles/puzzles).
(6) In /path-to/offlinep-chess-puzzles/, run the command
./offline-chess-puzzles &
You have a nice and simple to use GUI. You can filter puzzles by themes or rating and so on.
(7) You can also prepare a file similar to the above csv file using exel or some other spreadsheet program (on linux there is gnumeric) and load that file. Or if you like to write some bash or perl or python, you can filter out puzzles with some rating range or theme and create a pgn file or an epd file, and load it in another program like scid. But to do this, you will have to study the csv file a little (just a couple of rows of the file; and to just get a few rows, you don't have to open the file; try something like
head -10 file-name > new-file.csv
which will print top 10 lines in a new file. Study the format of the file to see what column has what information.
It is not complicated; at least not on linux. I had done this several months ago. But I hope the procedure still works.
(1) Downloaded the latest release of the program offline-chess-puzzles from https://github.com/brianch/offline-chess-puzzles/releases (the file for linux is offline-chess-puzzles-2.0.0-linux.tar.gz, but there are also files for windows 7 and 10).
(2) In a terminal extract the program by running the command:
tar xvf offline-chess-puzzles-2.0.0-linux.tar.gz
I did it in the directory ~/.local, and it created a sub-directory offline-chess-puzzles
(3) Download lichess_db_puzzle.csv.bz2 from https://database.lichess.org/#puzzles
(4) Extract the program by running the following command:
bunzip2 -d lichess_db_puzzle.csv.bz2
It unzips the puzzles database and gives you the csv file - csv files can be opened with exel or similar programs, but this one is rather big. There are ways (at least on linux) to split the file into many small parts.
(5) Move the csv file to the directory /path-to/offlinep-chess-puzzles/puzzles (in my case is ~/.local/offline-chess-puzzles/puzzles).
(6) In /path-to/offlinep-chess-puzzles/, run the command
./offline-chess-puzzles &
You have a nice and simple to use GUI. You can filter puzzles by themes or rating and so on.
(7) You can also prepare a file similar to the above csv file using exel or some other spreadsheet program (on linux there is gnumeric) and load that file. Or if you like to write some bash or perl or python, you can filter out puzzles with some rating range or theme and create a pgn file or an epd file, and load it in another program like scid. But to do this, you will have to study the csv file a little (just a couple of rows of the file; and to just get a few rows, you don't have to open the file; try something like
head -10 file-name > new-file.csv
which will print top 10 lines in a new file. Study the format of the file to see what column has what information.