PS_TEAMS Utility
Posted: Sun Jul 08, 2007 10:29 pm
The PS_TEAMS utility is now available for download on the following website:
CrashDavis Website
A utility for historical associations experiencing problems not being able to import the retrosheet schedules.
As always, I recommend you backup the association .psa/.psx file that you are going to work with.
The following is a copy of the text file that comes with the utility. The following example assumes you began
an association prior to 1953, and how you can apply the fix so that the 1953 retrosheet schedule successfully
imports into PureSim. This same example would apply for any other relocation/expansion years.
PS_TEAMS v1.0.1.1
for PureSim Baseball 2007 CE 2-5 or v1.6+
PS_Teams is a utility that addresses several needs for historical associations. Its Primary purpose is to address/fix the problem
PureSimmers have when simming historical associations during francise relocation/expansion years and the inability of PureSim to
import Retrosheet schedules thereafter.
If you began a historical association prior to 1953 season, this problem of no longer being able to import Retrosheet schedules
rears its ugly head prior to beginning the 1953 season - thats when the Boston Braves relocated to Milwaukee.
Inside your associations database (*.psa), is a table called TEAMS that stores every team currently in your association. One of
the fields in that table is called FORCELAHMAN. This field lists each teams abbreviation. These team abbreviations were set at
the time you created your association and according to the year you began the association. These abbreviations are 'fixed' as
opposed to 'dynamic'. Meaning, they do not change ever during the life of your association.
Prior to 1953, the Boston Braves abbrev under FORCELAHMAN was BSN. PureSim (and Retrosheet/Lahman DB) expects to find a team
(Milwaukee Braves) with the team abbrev of ML1 in 1953. As was already stated, the team abbrev are 'fixed' tho. This is why -
when you reach year 1953 - PureSim no longer imports the Retrosheet schedule for 1953 or thereafter.
The fix to this problem is to change the team abbrev in your association to match the correct team abbrev as reported by
the Lahman DB. This is where the utility comes in handy for those who do not have MS Access.
The PS_TEAMS utility:
1) Unzip the utility to any directory you like. You can create a shortcut desktop icon if you like.
2) Start the program by double-clicking.
3) Choose the association database (*.psa) you want to work with and click Open.
4) Type 1953 into the Input Year box at the top left and click the Search Year button.
5) What appears in the upper left grid represents the Real Life teams for MLB as they were in 1953 - complete with league info,
division info (not applicable prior to 1969), team abbrev, team names, and ballpark. All of this info is pulled from the
LAHMANPS.MDB database located in your Matrix Games\PureSim Baseball 2007 directory. Everything in this grid is set to Read-Only
and cannot be edited since this is the master databasae that PureSim relies on when creating associations.
6) At the bottom left of your screen, you will see a grid that represents your associations current team configurations.
7) First locate and find the correct abbrev used for the 1953 Milwaukee Braves in the top left grid (look under TeamID field).
8) Now, locate the Milwaukee Braves abbrev (look under ForceLahman field) in your association grid (at bottom left).
9) Change the abbrev to match the correct abbrev as reported in step 7 (ML1).
10) IMPORTANT: after typing in the correct abbrev, move the cursor out of the cell you just edited using either the Tab-Key or
Arrow keys. Once you move the cursor out of the cell your changes will be automatically saved to your association database.
If you do not move the cursor out of the cell, any changes you make will not be saved.
11) You can click the Close button at the bottom right and exit the program.
12) Start PureSim
13) One of 2 things should happen:
a) If all preseason activities have already taken place (ie., draft, free-agent signing, Spring Training, etc) then PureSim
should auto-detect and import 1953 Retrosheet schedule immediately. Be sure you have not simmed any games prior to this.
or
b) you will need to complete preseason activities beforehand; as importing the retrosheet schedule is the last thing
PureSim does before the season is ready to be simmed.
14) That should have fixed the problem of importing the 1953 schedule.
As stated earlier, the PS_TEAMS utility addresses a couple of issues with regard to historical simming. Besides fixing the retrosheet problem,
you can use the utility to determine what ballparks each team actually played in each year. And compare them with ballparks your teams are
using in your association. As you click on each team in your association, their stadium name will appear in the box (bottom right) to the
right of your associations grid. Note: Changing stadiums still must be done from inside PureSim however.
In your association grid (bottom left) you can also change TeamName & NickName for any team.
In your association grid (bottom left) you can change the RegionID by matching it to any RegionsID in the upper right grid. This comes
in handy when a team relocates to an entirely different region/climate of the country.
Again, the upper right grid is the master from the Lahman DB that PureSim uses and therefore cannot be edited.
The TeamID, LeagueID, and DivisionID fields shown in your association grid (bottom left) cannot (and should never) be edited. Those
fields are locked so that they are not accidently edited. But they are shown just for informational purposes at this time.
FYI: LeagueID 1 = AL and LeagueID 2 = NL
Steven 'CrashDavis' Lucey
steven.lucey@insightbb.com
CrashDavis Website
A utility for historical associations experiencing problems not being able to import the retrosheet schedules.
As always, I recommend you backup the association .psa/.psx file that you are going to work with.
The following is a copy of the text file that comes with the utility. The following example assumes you began
an association prior to 1953, and how you can apply the fix so that the 1953 retrosheet schedule successfully
imports into PureSim. This same example would apply for any other relocation/expansion years.
PS_TEAMS v1.0.1.1
for PureSim Baseball 2007 CE 2-5 or v1.6+
PS_Teams is a utility that addresses several needs for historical associations. Its Primary purpose is to address/fix the problem
PureSimmers have when simming historical associations during francise relocation/expansion years and the inability of PureSim to
import Retrosheet schedules thereafter.
If you began a historical association prior to 1953 season, this problem of no longer being able to import Retrosheet schedules
rears its ugly head prior to beginning the 1953 season - thats when the Boston Braves relocated to Milwaukee.
Inside your associations database (*.psa), is a table called TEAMS that stores every team currently in your association. One of
the fields in that table is called FORCELAHMAN. This field lists each teams abbreviation. These team abbreviations were set at
the time you created your association and according to the year you began the association. These abbreviations are 'fixed' as
opposed to 'dynamic'. Meaning, they do not change ever during the life of your association.
Prior to 1953, the Boston Braves abbrev under FORCELAHMAN was BSN. PureSim (and Retrosheet/Lahman DB) expects to find a team
(Milwaukee Braves) with the team abbrev of ML1 in 1953. As was already stated, the team abbrev are 'fixed' tho. This is why -
when you reach year 1953 - PureSim no longer imports the Retrosheet schedule for 1953 or thereafter.
The fix to this problem is to change the team abbrev in your association to match the correct team abbrev as reported by
the Lahman DB. This is where the utility comes in handy for those who do not have MS Access.
The PS_TEAMS utility:
1) Unzip the utility to any directory you like. You can create a shortcut desktop icon if you like.
2) Start the program by double-clicking.
3) Choose the association database (*.psa) you want to work with and click Open.
4) Type 1953 into the Input Year box at the top left and click the Search Year button.
5) What appears in the upper left grid represents the Real Life teams for MLB as they were in 1953 - complete with league info,
division info (not applicable prior to 1969), team abbrev, team names, and ballpark. All of this info is pulled from the
LAHMANPS.MDB database located in your Matrix Games\PureSim Baseball 2007 directory. Everything in this grid is set to Read-Only
and cannot be edited since this is the master databasae that PureSim relies on when creating associations.
6) At the bottom left of your screen, you will see a grid that represents your associations current team configurations.
7) First locate and find the correct abbrev used for the 1953 Milwaukee Braves in the top left grid (look under TeamID field).
8) Now, locate the Milwaukee Braves abbrev (look under ForceLahman field) in your association grid (at bottom left).
9) Change the abbrev to match the correct abbrev as reported in step 7 (ML1).
10) IMPORTANT: after typing in the correct abbrev, move the cursor out of the cell you just edited using either the Tab-Key or
Arrow keys. Once you move the cursor out of the cell your changes will be automatically saved to your association database.
If you do not move the cursor out of the cell, any changes you make will not be saved.
11) You can click the Close button at the bottom right and exit the program.
12) Start PureSim
13) One of 2 things should happen:
a) If all preseason activities have already taken place (ie., draft, free-agent signing, Spring Training, etc) then PureSim
should auto-detect and import 1953 Retrosheet schedule immediately. Be sure you have not simmed any games prior to this.
or
b) you will need to complete preseason activities beforehand; as importing the retrosheet schedule is the last thing
PureSim does before the season is ready to be simmed.
14) That should have fixed the problem of importing the 1953 schedule.
As stated earlier, the PS_TEAMS utility addresses a couple of issues with regard to historical simming. Besides fixing the retrosheet problem,
you can use the utility to determine what ballparks each team actually played in each year. And compare them with ballparks your teams are
using in your association. As you click on each team in your association, their stadium name will appear in the box (bottom right) to the
right of your associations grid. Note: Changing stadiums still must be done from inside PureSim however.
In your association grid (bottom left) you can also change TeamName & NickName for any team.
In your association grid (bottom left) you can change the RegionID by matching it to any RegionsID in the upper right grid. This comes
in handy when a team relocates to an entirely different region/climate of the country.
Again, the upper right grid is the master from the Lahman DB that PureSim uses and therefore cannot be edited.
The TeamID, LeagueID, and DivisionID fields shown in your association grid (bottom left) cannot (and should never) be edited. Those
fields are locked so that they are not accidently edited. But they are shown just for informational purposes at this time.
FYI: LeagueID 1 = AL and LeagueID 2 = NL
Steven 'CrashDavis' Lucey
steven.lucey@insightbb.com