Hi folks.
There are a few simple steps which allow to export Hall of Fame records to HTML format so you can publish these online or use locally for filtering/sorting purposes.
1) download View attachment hall_of_fame.zip and extract to your "Documents\My games\Sid Meier's Civilization 5\Replays\" folder (from here and forward there will be Windows OS instructions)
2) verify there is hall_of_fame folder which contains media folder. It should look similar to this screenshot
3) download SQLite shell for your OS from here http://www.sqlite.org/download.html. For Win32/Win64 it is sqlite-shell-win32-x86-NNNNNNN.zip
4) extract sqlite3.exe to your "Documents\My games\Sid Meier's Civilization 5\Replays\" folder
5) Go to "Documents\My games\Sid Meier's Civilization 5\Replays\" folder
6) Copy HallOfFameDatabase.db to save place (to allow to restore if something went wrong)
7.1) If you have G&K version: execute sqlite3.exe HallOfFameDatabase.db ".read hall_of_fame/export_GK.sql"
7.2) If you have vanilla version: execute sqlite3.exe HallOfFameDatabase.db ".read hall_of_fame/export_Vanilla.sql"
8) It will create index.html file in hall_of_fame folder
9) Double click hall_of_fame/index.html to verify export is successful
10) Run CIV5 and verify hall of fame is not corrupted. If it is then restore HallOfFameDatabase.db from saved copy and ask question of forum
Note 0: If you do not know how to do execute command at 7th step then press Win+R buttons, and execute
C:\CORRECT_PATH_TO_REPLAYS_FOLDER\sqlite3.exe HallOfFameDatabase.db ".read hall_of_fame/export_Vanilla.sql".
Do not forget to replace CORRECT_PATH_TO_REPLAYS_FOLDER with correct path
Note 1: If you want publish your results on web site then you have to publish whole hall_of_fame folder, i.e. including index.html and media
Note 2: It is safe to perform export as many times as required
PS
There are also my posts
- how to merge vanilla and G&K Hall of fame records
- how to fix broken Hall of fame records
There are a few simple steps which allow to export Hall of Fame records to HTML format so you can publish these online or use locally for filtering/sorting purposes.
1) download View attachment hall_of_fame.zip and extract to your "Documents\My games\Sid Meier's Civilization 5\Replays\" folder (from here and forward there will be Windows OS instructions)
2) verify there is hall_of_fame folder which contains media folder. It should look similar to this screenshot
3) download SQLite shell for your OS from here http://www.sqlite.org/download.html. For Win32/Win64 it is sqlite-shell-win32-x86-NNNNNNN.zip
4) extract sqlite3.exe to your "Documents\My games\Sid Meier's Civilization 5\Replays\" folder
5) Go to "Documents\My games\Sid Meier's Civilization 5\Replays\" folder
6) Copy HallOfFameDatabase.db to save place (to allow to restore if something went wrong)
7.1) If you have G&K version: execute sqlite3.exe HallOfFameDatabase.db ".read hall_of_fame/export_GK.sql"
7.2) If you have vanilla version: execute sqlite3.exe HallOfFameDatabase.db ".read hall_of_fame/export_Vanilla.sql"
8) It will create index.html file in hall_of_fame folder
9) Double click hall_of_fame/index.html to verify export is successful
10) Run CIV5 and verify hall of fame is not corrupted. If it is then restore HallOfFameDatabase.db from saved copy and ask question of forum
Note 0: If you do not know how to do execute command at 7th step then press Win+R buttons, and execute
C:\CORRECT_PATH_TO_REPLAYS_FOLDER\sqlite3.exe HallOfFameDatabase.db ".read hall_of_fame/export_Vanilla.sql".
Do not forget to replace CORRECT_PATH_TO_REPLAYS_FOLDER with correct path
Note 1: If you want publish your results on web site then you have to publish whole hall_of_fame folder, i.e. including index.html and media
Note 2: It is safe to perform export as many times as required
PS
There are also my posts
- how to merge vanilla and G&K Hall of fame records
- how to fix broken Hall of fame records
