SQLite DB Stuff

[21C]

Looking at the Ratings table from career.pbb in SQLiteStudio, the PlayerID is showing Integer for the Data Type but the actual data is a String (e.g. smitsc01).

I don't know if that is an error in SQLiteStudio (it opened the file as a SQLite 3 file) or the Ratings table in career.pbb is messed up. I was trying to get my team's player ratings changes over several seasons. I was able to work around it but I thought that I would mention it anyway.

Running version 9.12.

[Gary Gorski]

I see what you are saying - that probably should be a string in the database but it seems to work as it is. I will investigate more

[21C]

New issue but I thought that I would post it here rather than starting a new thread.

I was looking for player stats in the middle of a season to do some extended data manipulation - I am currently at December 24, 2028. I am looking at the following files in SQLiteStudio - career.pbb, commish.coa, [MyName].coa and the exported [MyLeague]Edit.db in the DB folder - exported on the same date Dec 24.

I see SeasonStats tables in career and [MyLeague]Edit but the [MyLeague]Edit one has no data - the same for the PlayoffStats table in [MyLeague]Edit. The tables for Cities, Coaches, Players and Teams are fully populated.

When I open SeasonStats in career, it appears fine for past seasons but the current season only shows players who have been involved in trades.

Am I looking in the wrong place? Is the current season data only available at the end of the season?

[Gary Gorski]

Yes the current season data will only be exported there at the end of the season