PS_TEAMS Utility

[CrashDavis]

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

[KG Erwin]

Fantastic, Crash! Thank you very much for this utility. This is exactly what I needed. [&o]

One quick question, though -- will this work with imported OOTP schedules, too?

[CrashDavis]

Did not test with imported OOTP schedules. But if you can tell me where i can find one, I'll see what I can do.

[KG Erwin]

ORIGINAL: CrashDavis

Did not test with imported OOTP schedules. But if you can tell me where i can find one, I'll see what I can do.

Here: http://www.ootpdevelopments.com/board/s ... hp?t=85752

[akcranker]

I don't do historical associations but regardless this is a great utility to add to the mods for Puresim and I'm sure alot of simmers are extremely grateful!!!

Thanks Crash!!!

[CrashDavis]

One quick question, though -- will this work with imported OOTP schedules, too?

No, will not work with OOTP schedules. You can import their schedule. But the schedule will not match
the historical (real life) schedule from that year. I used 1953 as a test.

[Leegen]

WOW!!!  Talk about perfect timing.  This is just what the doctor ordered to fix the crash in my association, Crash.  My expansion teams werent given abbreviations and that was causing the null error that wouldn't let me do the amateur draft.  Also corrected team affinity problems and sped up the draft considerably.  Thanks a million!!!

[CrashDavis]

Leegen wrote:

This is just what the doctor ordered to fix the crash in my association, Crash. My expansion teams werent given abbreviations and that was causing the null error that wouldn't let me do the amateur draft. Also corrected team affinity problems and sped up the draft considerably. Thanks a million!!!

It fixed something I wasn't even testing for??? Is that "in the grove" or what? [:D]
Seriously, glad it helped. I'm a bit puzzled as to why it did not assign your expansion teams abbrev tho. I don't remember that happening to me, but it been awhile since I had an expansion year.


KG wrote:

will this work with imported OOTP schedules, too?

Just to follow up on my last post:
I think I understand now why some were saying that they needed to have teams in a certain order in their association to get the correct matchups. They must have been refering to the OOTP schedules (and I thought they meant the retrosheet schedules).
If I interpret my 1953 test from above correctly, then indeed OOTP requires that the teams in your association be in exactly the same order as they are in the OOTP schedule.
Whereas, with Retrosheet schedules, its all about the correct team abbrev being present.

Thinking out loud:
If you had a 16 team fictional league, and you wanted to use the real life 1940 schedule, you
could assign all 16 real life team abbrev from 1940 to your 16 fictional teams....and theoretically...the 1940 retrosheet schedule should import. I don't know if my thinking out loud made any sense there or not.

[puresimmer]

ORIGINAL: KG Erwin

Fantastic, Crash! Thank you very much for this utility. This is exactly what I needed. [&o]

One quick question, though -- will this work with imported OOTP schedules, too?

Nice work!

Shaun