Quote:
Originally Posted by thehef
If you have to revert to one of the earlier (in this thread) suggestions and do much of the work manually, I'd recommend scaling back the scope of your changes. Get your team's milb system pretty accurate. Fool around with the top levels of your minor leagues for other teams. And leave it at that! 
|
That's exactly my thought process. After nearly giving up on this project, I had a bit of a revelation when I noticed in the restructured environment, every MLB team has only 1 affiliate at each level: AAA, AA, A+, A, R
I'm taking the approach now of "What is the Yankees AA affiliate?" In the old it was the Trenton Thunder. In the new, it is the Somerset Patriots. So I'm renaming the Trenton Thunder the Somerset Patriots, and figuring this out for each MLB affiliate. It could mean that I temporarily have 2 teams with the same name affiliated with different MLB teams, but it should all work out by the time I get through them all.
Doing this for each team. It will mess with each team's history, but it will assure I have the right structure with the right team names with the right players without worrying about having to change the Chattanooga Lookouts from a MIN affiliate to a CIN affiliate and then move all the players back to the MIN AA team (hope that makes sense).
I think this will get me most of the way there as I now have all the changes I need mapped out in Excel for AAA, AA, and A+ levels
At some point I'm going to have to figure out how to handle teams & leagues that no longer exist without losing the players in them, but I'll worry about that when the time comes.