Time Trial Leaderboards to Excel File(Application)

[PR1VATEJ0KER]

I made this in 30mins while I should be doing other work(debugging for 1hour..like a boss).

Gran Turismo Leaderboard Exporter
Run as an administrator on Win7

Copy the URL of the Time Trial event to the Text Box,
Click Load, Wait.. (~5seconds)

Leaderboard will load and be displayed.
Click File --> Export to Excel 2007(~10seconds)

Can be used for statistical purposes, historical leaderboard recording,
creating graphs/curves of the times. Whatever you can think of.

I made this on Windows 7, It may not work on other OS.



Other reasons it may not work are:
you don't have permission to run it in this place(desktop)
Or you dont have permission to write the temporary file to you're C: drive. (Change this location in 'Tools')
Or you're firewall is blocking the connection.
When bandwidth is really low it may take too long to get info and timeout.

The risk is your own(minimal)

Let me know if it works for you, or post any graphs/statistical analysis you come up with
PM me if you would like the source code.

 

[Kilmore]

Dude that looks sweet. I will surely try this, thanks! 👍

 

[JevL]

The leaderboard won't be displayed for me, it's just empty..?

 

[PR1VATEJ0KER]

The leaderboard won't be displayed for me, it's just empty..?

If the leaderboard shows up empty, it means you were able to get the leaderboard information.
but you don't have sufficient permissions to write the temporary file.

To resolve you must 'Run as administrator'
or change where the temp file is being saved (tools--> temp files)

 

[Toyinster]

The leaderboard won't be displayed for me, it's just empty..?

me too.

 

[JevL]

If the leaderboard shows up empty, it means you were able to get the leaderboard information.
but you don't have sufficient permissions to write the temporary file.

To resolve you must 'Run as administrator'
or change where the temp file is being saved (tools--> temp files)

I did that, still doesn't work.

 

[PR1VATEJ0KER]

I did that, still doesn't work.

Damn,
I've got it to work on another notebook, laptop and pc in my house.
All as administrator.
Can I ask what Operating System you are on?

Also if you change where the temp file goes, does it actually appear there?

 

[JevL]

Damn,
I've got it to work on another notebook, laptop and pc in my house.
All as administrator.
Can I ask what Operating System you are on?

Also if you change where the temp file goes, does it actually appear there?

W7. And no, there isn't a 'temp.txt' file.

 

[PR1VATEJ0KER]

W7. And no, there isn't a 'temp.txt' file.

If it couldn't make the temp.txt, it couldn't grab the info from the webpage.
That could mean your firewall is preventing the connection.

Edit:

I found a computer at home that has this same situation, where the info cannot be accessed & leaves an empty leaderboard. I disabled the firewall & anti-virus and unfortunately it still would not work.

The only way I can fix this for now is to debug on the other machine.