It seems that you're using an outdated browser. Some things may not work as they should (or don't work at all).
We suggest you upgrade newer and better browser like: Chrome, Firefox, Internet Explorer or Opera

×
It would be handy if the app could export the game list to a CSV file. (In your spare time...)
I agree, it would be handy.

In the mean time, I have an alternate solution for you: there's a deal aggregator site called IsThereAnyDeal.com (ITAD). You give it links to your public GOG/Steam account, and it collects your wishlist and games in your library.

From there you could go into the Settings and download a json or csv of the games in your "Colection".

This will only grab from GOG and Steam, not Humble/Epic/Origin/etc, because they rely on the game library being publicly visible.
avatar
mbeemer: It would be handy if the app could export the game list to a CSV file. (In your spare time...)
Better with tags, game time, etc.

:)
avatar
mbeemer: It would be handy if the app could export the game list to a CSV file. (In your spare time...)
Hey man! I made a tool to do just this since I needed it myself.

https://github.com/AB1908/GOG-Galaxy-Export-Script

Enjoy!
avatar
mbeemer: It would be handy if the app could export the game list to a CSV file. (In your spare time...)
avatar
AB1908: Hey man! I made a tool to do just this since I needed it myself.

https://github.com/AB1908/GOG-Galaxy-Export-Script

Enjoy!
Thanks! Looks like I've screwed up my python install but I'll poke at it.
avatar
mbeemer: It would be handy if the app could export the game list to a CSV file. (In your spare time...)
avatar
AB1908: Hey man! I made a tool to do just this since I needed it myself.

https://github.com/AB1908/GOG-Galaxy-Export-Script

Enjoy!
Dunno what's wrong, but my OSX setup will run gogrepoc but not your script. If some gurus could take a look and normalize it across OS's I'd appreciate it.
avatar
AB1908: Hey man! I made a tool to do just this since I needed it myself.

https://github.com/AB1908/GOG-Galaxy-Export-Script

Enjoy!
avatar
mbeemer: Dunno what's wrong, but my OSX setup will run gogrepoc but not your script. If some gurus could take a look and normalize it across OS's I'd appreciate it.
I'm incredibly sorry. I hadn't bothered to check for different platforms. If you could simply post the location of the DB, I could add it to the script. Heck, it's even simple enough for you to. Just change the variable at the top named database_location. I can't comment on where the database on your system is though. Maybe poke around a bit?
avatar
mbeemer: Dunno what's wrong, but my OSX setup will run gogrepoc but not your script. If some gurus could take a look and normalize it across OS's I'd appreciate it.
avatar
AB1908: I'm incredibly sorry. I hadn't bothered to check for different platforms. If you could simply post the location of the DB, I could add it to the script. Heck, it's even simple enough for you to. Just change the variable at the top named database_location. I can't comment on where the database on your system is though. Maybe poke around a bit?
I actually fixed that myself, and added a couple of lines to point it to the correct version of python. Now I'm getting:

Traceback (most recent call last):
File "./galaxy_library_export.py", line 48, in <module>
cursor.execute(owned_game_filtered_data)
sqlite3.OperationalError: unrecognized token: "{"

"One'na these days, I'm gonna hafta learn howta python!"
avatar
mbeemer: Dunno what's wrong, but my OSX setup will run gogrepoc but not your script. If some gurus could take a look and normalize it across OS's I'd appreciate it.
avatar
AB1908: I'm incredibly sorry. I hadn't bothered to check for different platforms. If you could simply post the location of the DB, I could add it to the script. Heck, it's even simple enough for you to. Just change the variable at the top named database_location. I can't comment on where the database on your system is though. Maybe poke around a bit?
I hacked your script, replacing your construction of 'owned_game_filtered_data' with a series of concatenations:

owned_game_filtered_data = "CREATE TEMP VIEW MasterDB AS SELECT DISTINCT(MasterList.releaseKey) AS releaseKey, "
owned_game_filtered_data = owned_game_filtered_data + "MasterList.value AS title, MC1.value AS metadata, MC2.value AS platformList, "
owned_game_filtered_data = owned_game_filtered_data + "GameTimes.minutesInGame AS time from MasterList, MasterList AS MC1, "
owned_game_filtered_data = owned_game_filtered_data + "MasterList AS MC2, GameTimes WHERE (((MasterList.gamePieceTypeId=" + str(originalTitleID[0])
owned_game_filtered_data = owned_game_filtered_data + ") OR (MasterList.gamePieceTypeId=" + str(titleID) + ")) AND ((MC1.gamePieceTypeId="
owned_game_filtered_data = owned_game_filtered_data + str(originalMetaID[0]) + ") OR (MC1.gamePieceTypeId=" + str(metaID[0])
owned_game_filtered_data = owned_game_filtered_data + "))) AND MC1.releaseKey=MasterList.releaseKey AND MC2.gamePieceTypeId="
owned_game_filtered_data = owned_game_filtered_data + str(releasesList) + " AND MC2.releaseKey=MasterList.releaseKey AND "
owned_game_filtered_data = owned_game_filtered_data + "GameTimes.releaseKey=MasterList.releaseKey ORDER BY title;"

I got a CSV with 2038 rows as opposed to the 2211 reported in GOG Galaxy 'owned games'. I have no idea how reliable these results are...

JUST SMART ENOUGH TO BE DANGEROUS...
avatar
mbeemer: Dunno what's wrong, but my OSX setup will run gogrepoc but not your script. If some gurus could take a look and normalize it across OS's I'd appreciate it.
avatar
AB1908: I'm incredibly sorry. I hadn't bothered to check for different platforms. If you could simply post the location of the DB, I could add it to the script. Heck, it's even simple enough for you to. Just change the variable at the top named database_location. I can't comment on where the database on your system is though. Maybe poke around a bit?
I runned the script i did not do nothing :/
Post edited May 14, 2020 by SonicScientist1987