Skip to content
Little GolemMake your next move.

Download personal game history

Public forum discussion.

#1 · Maurizio De Leo

8 Sep 2021

I would like to record the games I have played on little golem in a database (BoardGameGeek). However manual data entry is very tedious.

Is there a way to download our own game history ? The data I would need is

Game (e.g. Polyomino)
GIF (eg. #2028057)
Players
Date Started
Date Ended
Number of Moves

I have been trying to find a quick way to do this, but the best I managed is the PlayerInfo pages which does not have start and end dates.

https://www.littlegolem.net/jsp/info/player_game_list.jsp?gtid=chess&plid=3380

#2 · mmKALLL

8 Sep 2021

After getting the game information, how would you enter it into the BGG database? What kind of format would be preferable for the data?
I think it might be possible to scrape this information from game SGF files, somewhat similar to how Tasuki's LG ranking got the rating data.

#3 · Maurizio De Leo

9 Sep 2021

I enter it manually.
BGG interface is quite quick for the same game, as it will copy the previous info (including location, i.e. Little Golem) and I need to change only the date.
I basically would just need to have an excel table open on another screen.
Currently I have to click on each game , read and then close the tab, which takes too much time.

#4 · Miwarre

10 Sep 2021

The only way I know to gather the info you need (except for the number of moves, which you have to compute yourself in some way) is by scraping the game pages, i.e. those with the URL's like https://www.littlegolem.net/jsp/game/game.jsp?gid=[gameid]. It may depend on the platform you are running on, but under Linux it is relatively easy to put up a script doing it quickly with curl and pup. Tell me if I can be of any help.

#5 · Maurizio De Leo

15 Sep 2021

I'm on windows.
I tried with Google sheet and "ImportXML" function, but the page structure is too complex and I don't want to put too much load on the server.
If you could do it without too much effort, it would be helpful.

#7 · Maurizio De Leo

16 Sep 2021

Thanks Nagy.
I had already found that link. My issue is that there is no "date" neither initial or end, so it doesn't help me in logging my plays.

#8 · eobllor

17 Sep 2021

Yes, the date is missing from the listing. Nevertheless, you can still scrape the page of each game, knowing its id (https://littlegolem.net/jsp/game/game.jsp?gid={your id here}), and search the content for string "Start time: ", then analyse what follows with a regular expression for a date in format "YYYY-MM-DD HH:mm".

Of course, that means you cannot just copy manually from the list, you should have the process automated.