Question about player stats history updating

[Hockey13Playa]

Like the title says, question about a players stats history



If you see where my green arrow is pointing... I updated the Dodgers abbreviation to be LAD instead of LAN, same for the Angles... , Mets, Yankees, Cubs, White Sox... I would like for this to update all the previous seasons in the database. Is there an easy way to do this? Its a OCD pet peeve of mine.

Appreciate the community's help! You guys all rock!

[Hockey13Playa]

Bump. Anybody? Another example is the "KCA" I'd like to make "KC. Is there a easy way to update this for all years prior?

KCA -> KC
LAN -> LAD
CHN -> CHC
CHA -> CHW

ETC... I can update these in a clean sweep for the current season and beyond but looking for a way to edit prior to 2014.

[Jupiter]

Originally Posted by Hockey13Playa

Like the title says, question about a players stats history



If you see where my green arrow is pointing... I updated the Dodgers abbreviation to be LAD instead of LAN, same for the Angles... , Mets, Yankees, Cubs, White Sox... I would like for this to update all the previous seasons in the database. Is there an easy way to do this? Its a OCD pet peeve of mine.

Appreciate the community's help! You guys all rock!

Sadly, I do not know of a way. I hope there is one, because this is one of my (albeit minor) annoyances with the game. The worst for me was when I was running a league where the White Sox team was abbreviated CHA, although I would have preferred it to be CWS. This did not bother me terribly until I realized 10 years too late that the league evolution had expanded the league to Charlotte and also abbreviated that team as CHA. This made for some fairly messy player histories.

[Matt Arnold]

It's a double edged sword. It's one thing changing the abbreviation, but when Montreal moved to Washington, their historical stats should show MTL not WAS for the seasons they were in Montreal. It probably comes down to how they are stored in the database.

[Thundercrack]

can't be changed for prior seasons.

[Jupiter]

Originally Posted by UWHabs

It's a double edged sword. It's one thing changing the abbreviation, but when Montreal moved to Washington, their historical stats should show MTL not WAS for the seasons they were in Montreal. It probably comes down to how they are stored in the database.

This is a valid point. Personally, it would not bother me if the abbreviation stayed the same throughout the life of the franchise, since I tend to think of it as an indicator of the franchise they are with rather than where they play. But I suspect many people would disagree with me. And even for my fairly laid-back view of how I would like it to work, the order is important. If the abbreviation were always WAS even though the franchise was in Montreal for decades, that would not bother me. But if the abbreviation started out as MON and then stayed that way after the team moved, that would annoy me quite a bit. Luckily, I believe currently it can be switched manually (I rarely play historical games or relocate my fictional franchises, so I have only faced this once or twice) but the user has to remember to do it immediately.

Personally, I think it would be wonderful to have an overriding history of franchise locations, names, and abbreviations that could be defined for ranges of years in the team setup. So you could go back retroactively and define the A's as being the Philadelphia, Kansas City, and Oakland A's (which appropriate abbreviations) for the specific years that are applicable and then have this flow through to player histories and update appropriately even if the change was made decades later.

[sprague]

Yes you can. A bit of work.

In the main settings, export stats. They will go to 3 notebook files in the import-export folder.
Open them. Make the change, save them, then re-import the stats into the game.

I only suggest using this for changes in the first year of starting a new game- you can lose a few things doing this after a league has been running a few years

[Hockey13Playa]

Originally Posted by sprague

Yes you can. A bit of work.

In the main settings, export stats. They will go to 3 notebook files in the import-export folder.
Open them. Make the change, save them, then re-import the stats into the game.

I only suggest using this for changes in the first year of starting a new game- you can lose a few things doing this after a league has been running a few years

I literally created the modern day league and started making my league changes and settings. Haven't simmed a single day in game so I would suspect doing the steps you just mentioned wouldn't/shouldn't mess anything up, right?

Edit: I'd assume this is a one time mass edit correct? I don't have to edit every year for every player right? Meaning if I open those 3 files and update KCA to KC it will change it league wide all at once, correct?

[Hockey13Playa]

Ok so I exported the three stats files and did a mass find replace of what I wanted to update... for some reason when I "Erase all MLB stats" then import them all they are not updating... any ideas why the changes are showing up?

These are text docs... its easiest to update in word, does this effect why they are not updating? It's telling me the import was successful...

[dave1927p]

Originally Posted by UWHabs

It's a double edged sword. It's one thing changing the abbreviation, but when Montreal moved to Washington, their historical stats should show MTL not WAS for the seasons they were in Montreal. It probably comes down to how they are stored in the database.

would be nice to see this information in the team history too...can never tell when a team moved.

[Hockey13Playa]

Originally Posted by Hockey13Playa

Ok so I exported the three stats files and did a mass find replace of what I wanted to update... for some reason when I "Erase all MLB stats" then import them all they are not updating... any ideas why the changes are showing up?

These are text docs... its easiest to update in word, does this effect why they are not updating? It's telling me the import was successful...

Bump, sorry to be a pest but I'd really like to get this figured out... I have just edited the original text files and. removed all MLB stats... went to a player to check and all stats were gone which is good. I then imported my "updated" stats and they are showing the oringal ones. Why are my modified files not uploading? Those are what I have in the saved games/my saved game/import_export.

Help?!

[Hockey13Playa]

Anyone? I started my game. Exported the three text files. Edited all histories/team abbreviations and saved the files. I then erased all MLB stats and reimported. Nothing is updating. Tried summing a day, commissioner mode, closing and reopening OOTP, nothing seems to work.

[Lukas Berger]

Originally Posted by sprague

Yes you can. A bit of work.

In the main settings, export stats. They will go to 3 notebook files in the import-export folder.
Open them. Make the change, save them, then re-import the stats into the game.

I only suggest using this for changes in the first year of starting a new game- you can lose a few things doing this after a league has been running a few years

Originally Posted by Hockey13Playa

Anyone? I started my game. Exported the three text files. Edited all histories/team abbreviations and saved the files. I then erased all MLB stats and reimported. Nothing is updating. Tried summing a day, commissioner mode, closing and reopening OOTP, nothing seems to work.

You can't do what Sprague suggested, it won't work.

The abbreviations are linked to the team id in the db. Changing the abbreviations in the text files will have no effect whatsoever on how they show up in game.

The only way to change that is to change the abbreviation for the linked team in the game itself. Sorry

[Hockey13Playa]

Originally Posted by lukasberger

You can't do what Sprague suggested, it won't work.

The abbreviations are linked to the team id in the db. Changing the abbreviations in the text files will have no effect whatsoever on how they show up in game.

The only way to change that is to change the abbreviation for the linked team in the game itself. Sorry

I appreciate the response! So there is no way to update/change the team ID to display what I want? I am Royally screwed?

[Lukas Berger]

Originally Posted by Hockey13Playa

I appreciate the response! So there is no way to update/change the team ID to display what I want? I am Royally screwed?

Changing the abbreviation for the team itself should change the abbreviations for past seasons linked to that team's id as well as the current season. Hasn't it done that for you?

[Hockey13Playa]

Originally Posted by lukasberger

Changing the abbreviation for the team itself should change the abbreviations for past seasons linked to that team's id as well as the current season. Hasn't it done that for you?

Well I started a new game... I am taking my modern league and trying to get everything as accurate as can be.. from rules, to awards, to league settings and financials... and one thing that really bugs me and is an OCD is the "NYA" and not being "NYY" along with all the other incorrect abbreviations for other teams. So I changed the abbreviation in the manner like you said... I haven't simmed one day in game, I am setting everything up and I changed all teams to what I'd like their abbreviations to be, see my Yankess picture below:



So you can see all three spots where you enter in an ID I updated it to say "NYY". I hit enter after editing each so make sure they have stuck or taken place. Now when I go to any Yankees player it still says "NYA" See Derek Jeter:



I don't understand why this isn't updating? I've updated it in every spot I can think of.. those three line items as well as the three fielding, pitching, and batting career stats text files.

[The Game]

Originally Posted by Hockey13Playa

Bump. Anybody? Another example is the "KCA" I'd like to make "KC. Is there a easy way to update this for all years prior?

KCA -> KC
LAN -> LAD
CHN -> CHC
CHA -> CHW

ETC... I can update these in a clean sweep for the current season and beyond but looking for a way to edit prior to 2014.

You can't change the past. once i got past 2012 or 2013. I changed all the team to what they should be NYY vs NYA, NYM vs NYM CWS vs CHA etc. So i have players histories that will show CHA for 10 years then CWS for the last few.

[Hockey13Playa]

Originally Posted by The Game

You can't change the past. once i got past 2012 or 2013. I changed all the team to what they should be NYY vs NYA, NYM vs NYM CWS vs CHA etc. So i have players histories that will show CHA for 10 years then CWS for the last few.

Arghhh... whats the point of being able to export the stat files then to edit and re import? There's absolutely no way for us to make that change? I know its purely "cosmetic" but my OCD is flying sky high right now

[Lukas Berger]

You can change the past. Just simply changing the abbreviation should do it. It does it for leagues other than MLB at least, I just did it in the *** earlier tonight.

I'm not sure I've ever actually tried it in MLB though.

Let me test it out and see what happens.

Originally Posted by Hockey13Playa

Arghhh... whats the point of being able to export the stat files then to edit and re import? There's absolutely no way for us to make that change? I know its purely "cosmetic" but my OCD is flying sky high right now

As to the point, it's so that you can edit and change stats, add them, switch the teams they're linked to. etc. You can build a rl league not included in OOTP from scratch and include accurate player stats. It's a really useful tool, but it's just that the game overwrites any changes you make to that one field, the team id field.

[Lukas Berger]

Hmm, guess it doesn't work for MLB. No idea why, though it probably has to do with the fact that MLB was built through a Lahman db originally. I'll add this to my list of stuff to ask Markus about.