??? - Importing historical schedules

Matrix Games Forums

Forums Register Login Photo Gallery Member List Search Calendars FAQ

My Profile Inbox Address Book My Subscription My Forums Log Out

??? - Importing historical schedules

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [Current Games From Matrix.] >> [Sports] >> PureSim Baseball >> ??? - Importing historical schedules

Page: [1]

Message

<< Older Topic Newer Topic >>

??? - Importing historical schedules - 7/13/2006 2:20:27 AM

SittingDuck

Posts: 1166
Joined: 9/1/2002
Status: offline

Q: Does PS2007 have the authentic schedules imported via the Lahman database? Or is there a generic schedule that is used?

I have only simmed a few years so not sure at this point.

If I need to import the authentic schedules, where is a database for that?

Post #: 1

RE: ??? - Importing historical schedules - 7/13/2006 2:37:43 AM

henry296

Posts: 418
Joined: 5/12/2006
Status: offline

Many seasons are included. If you are playing a season with a real schedule you will be prompted to use it. I have used real schedules from 1921-1935.

(in reply to SittingDuck)

Post #: 2

RE: ??? - Importing historical schedules - 7/13/2006 4:34:31 AM

fmonster

Posts: 217
Joined: 6/16/2003
From: Cartersville, Ga. USA
Status: offline

www.retrosheet.org is the place for actual schedules and they can be imported,...... so I am told.

I will be firing up a historical "replay" this weekend if I get some time to myself.

Good luck!

_____________________________

Matrix Games Owned

- American Civil War
- Forge Of Freedom
- John Tiller's Campaign Series
- TOAW III
- War In The Pacific
- War In The Pacific AE
- War Plan Orange
- SP:WaW
- Brother Against Brother
- Carriers at War

(in reply to SittingDuck)

Post #: 3

RE: ??? - Importing historical schedules - 7/13/2006 5:00:40 AM

akw4572

Posts: 96
Joined: 2/6/2005
Status: offline

quote:

ORIGINAL: SittingDuck

Q: Does PS2007 have the authentic schedules imported via the Lahman database? Or is there a generic schedule that is used?

I have only simmed a few years so not sure at this point.

If I need to import the authentic schedules, where is a database for that?

At the beginning of a season, click on options/utilities from your team home page (I believe that's where it is), and the option to import a schedule is there. It automatically takes you to some retrosheet schedules that are included.

(in reply to SittingDuck)

Post #: 4

RE: ??? - Importing historical schedules - 7/13/2006 5:14:16 AM

rwd59

Posts: 46
Joined: 7/3/2006
From: LA (Lower Alabama)
Status: offline

It always tells me that you can't import once the season starts even when I try before spring training starts. How about a step by step on when and how to do it?

(in reply to akw4572)

Post #: 5

RE: ??? - Importing historical schedules - 7/13/2006 5:15:46 AM

SittingDuck

Posts: 1166
Joined: 9/1/2002
Status: offline

Thanks for all that, guys. Arrgh - the retrosheet schedules start getting sporadic come the '60's.

(in reply to akw4572)

Post #: 6

RE: ??? - Importing historical schedules - 7/13/2006 5:58:19 AM

akw4572

Posts: 96
Joined: 2/6/2005
Status: offline

quote:

ORIGINAL: rwd59

It always tells me that you can't import once the season starts even when I try before spring training starts. How about a step by step on when and how to do it?

Actually I belive you have to do it AFTER spring training. Someone correct me if I'm wrong. I'm running a long term sim on my gaming machine, so I can't check, sorry.

(in reply to rwd59)

Post #: 7

RE: ??? - Importing historical schedules - 7/13/2006 6:28:06 AM

motnahp

Posts: 1837
Joined: 8/22/2005
Status: offline

You are correct. The only time you can import a schedule is after spring training. Puresim also supports schedules from OOTP.

(in reply to akw4572)

Post #: 8

RE: ??? - Importing historical schedules - 7/13/2006 7:14:33 AM

rwd59

Posts: 46
Joined: 7/3/2006
From: LA (Lower Alabama)
Status: offline

I have tried it then too. Same error message.

(in reply to motnahp)

Post #: 9

RE: ??? - Importing historical schedules - 7/14/2006 12:27:27 AM

KG Erwin

Posts: 8981
Joined: 7/25/2000
From: Cross Lanes WV USA
Status: offline

For info on importing OOTP6 schedules into Pure Sim, see this thread:

http://www.matrixgames.com/forums/tm.asp?m=1173380

I've successfully imported a historical OOTP schedule into a historical draft association. As long as the league/division setups match, you should be OK.

< Message edited by KG Erwin -- 7/14/2006 12:29:45 AM >

(in reply to rwd59)

Post #: 10

RE: ??? - Importing historical schedules - 7/14/2006 7:06:53 AM

motnahp

Posts: 1837
Joined: 8/22/2005
Status: offline

I've actually imported two types of OOTP schedules and both have worked great with PS. I'm now in the process of editing one of the OOTP schedules and seeing if my edited version works with PS.

The only version I saw for my one league, two divisions, 7 teams per division format had an odd distribution of games. Teams would play their other 6 division foes 20 times each, and play teams in the opposite division 6 times each.

I'm using the site retrosheet.org to see who actually played whom on which date. I'm leaving in all the doubleheaders. In the cases where a game was rained out and never rescheduled, I decided to go ahead and make the teams play, so everyone gets 162 games.

As far as the editing process goes, it takes about an hour per month to write down the actual games played, then input the correct numbers into the document. I can see myself doing many such schedules in the future. It's a bit tedious and boring, but will feel good to be "historically accurate".

(in reply to KG Erwin)

Post #: 11

RE: ??? - Importing historical schedules - 7/14/2006 4:10:37 PM

Abev

Posts: 228
Joined: 8/11/2005
Status: offline

quote:

ORIGINAL: motnahp

The only version I saw for my one league, two divisions, 7 teams per division format had an odd distribution of games. Teams would play their other 6 division foes 20 times each, and play teams in the opposite division 6 times each.

motnahp would this work for you?

Current Configuration: 
162 games, 14 teams/League, 2 divisions (7 teams/division)
Balanced Schedule


1	13	1	1	2
2	13	1	1	2
3	13	1	1	2
4	13	1	1	2
5	13	1	1	2
6	13	1	1	2
7	12	1	2	1
8	12	1	2	1
9	12	1	2	1
10	12	1	2	1
11	12	1	2	1
12	12	1	2	1
13	12	1	2	1

I never tried this configuation with my scheduler before so I figured I'd give it a shot. To read the output:
This is a master schedule output. Assume it is a schedule for "team #0" thats your team.

Col 1 is the team you are playing
Col 2 is how many games you play them
Col 3 is the number of 2 game series you play them
Col 4 is the number of 3 game series you play them
Col 5 is the number of 4 game series you play them

As for who the other teams play, when "0 plays 1", "2 will always play 3", "4 will always play 5", etc... Let me know if you want a text output to see if it will work in your assn.

(in reply to motnahp)

Post #: 12

RE: ??? - Importing historical schedules - 7/15/2006 9:42:20 AM

motnahp

Posts: 1837
Joined: 8/22/2005
Status: offline

Abev, thanks for the response, but I actually finished editing the OOTP .txt schedule. I made it match the ACTUAL 1979 AL schedule and tried it out on a test assn.

I fixed a couple of my own typos and thought I had it ready. When I looked again at the schedule calendars, a "mystery game" appeared on day 155. That particular game DID NOT appear anywhere in the text document.....strange. I just deleted everything on day 155 and wrote them again. This time, all appears well.

A month or so ago, I downloaded a schedule maker (possibly yours?) from a link either on the PS or OOTP site. The schedule maker looked great and was very user friendly, but it "demanded" a two league setup and I couldn't use it for my AL-only assn. I will definitely be looking to use it in the future.

For now, although it's a little boring, it's also a little fun to "create my own" schedules by editing a .txt document. It would go much quicker if there were a "comma" key on the keypad.

(in reply to Abev)

Post #: 13

RE: ??? - Importing historical schedules - 7/15/2006 4:21:46 PM

Abev

Posts: 228
Joined: 8/11/2005
Status: offline

quote:

ORIGINAL: motnahp

Abev, thanks for the response, but I actually finished editing the OOTP .txt schedule. I made it match the ACTUAL 1979 AL schedule and tried it out on a test assn..

A month or so ago, I downloaded a schedule maker (possibly yours?) from a link either on the PS or OOTP site. The schedule maker looked great and was very user friendly, but it "demanded" a two league setup and I couldn't use it for my AL-only assn. I will definitely be looking to use it in the future.

Not mine, probably the Stickware scheduler.

For as much customization as everyone wants, it would almost make sense to create a super tiny visual basic app that would help write the text file for people, as opposed to putting in a few params and having a schedule spit out.

(in reply to motnahp)

Post #: 14

RE: ??? - Importing historical schedules - 7/16/2006 5:12:50 AM

motnahp

Posts: 1837
Joined: 8/22/2005
Status: offline

I have ZERO programming experience, but am pretty quick and accurate with data entry-type applications. It was fairly easy to edit the .txt document for 1979. I've already got the 1980 schedule copied onto calendars and will be "creating" my 1980 .txt document schedule very soon.

(in reply to Abev)

Post #: 15

RE: ??? - Importing historical schedules - 7/17/2006 7:39:30 AM

motnahp

Posts: 1837
Joined: 8/22/2005
Status: offline

Finished the 1980 .txt schedule last night. I had one typo error in 1,134 lines of data. Once I cleared it up, everything tested good.

Anyone out there had any experience editing the .csv type skeds from OOTP? They "look" like easy-to-edit Excel documents, but I could never get mine to edit at all.

(in reply to motnahp)

Post #: 16

RE: ??? - Importing historical schedules - 7/17/2006 3:39:35 PM

Abev

Posts: 228
Joined: 8/11/2005
Status: offline

quote:

ORIGINAL: motnahp

Finished the 1980 .txt schedule last night. I had one typo error in 1,134 lines of data. Once I cleared it up, everything tested good.

Anyone out there had any experience editing the .csv type skeds from OOTP? They "look" like easy-to-edit Excel documents, but I could never get mine to edit at all.

If you know MS Access, you could import the csv file into an Access table then manipulate the data with the help of update queries.

(in reply to motnahp)

Post #: 17

RE: ??? - Importing historical schedules - 7/23/2006 9:56:27 AM

Schedule King

Posts: 10
Joined: 7/20/2006
Status: offline

quote:

ORIGINAL: motnahp

I'm using the site retrosheet.org to see who actually played whom on which date. I'm leaving in all the doubleheaders. In the cases where a game was rained out and never rescheduled, I decided to go ahead and make the teams play, so everyone gets 162 games.

Just so you know, you're recreating work I already did quite some time ago. I have, in simple text file format, every MLB original schedule from 1878-2006 sitting on my hard drive. Those files were the basis for the schedule files available on Retrosheet. (I sent the files over and volunteers proofed them against schedules published in newspapers or TSNs and any discrepancies uncovered were corrected. It's because of this proofing process that the entire run of 1878-2006 isn't available on Retrosheet - there were more files than there were volunteers or time to check over all of them.)

The files I have are the most up-to-date and actually supercede the files available on Retrosheet. The next most up-to-date versions are those available in this thread over on the OOTP boards: http://www.ootpdevelopments.com/board/showthread.php?t=85752

The files available on Retrosheet, sadly, are the least up-to-date. Some day I'm going to get back in touch with Retrosheet and get the files updated and get more added to what's available... some day...

(in reply to motnahp)

Post #: 18

RE: ??? - Importing historical schedules - 7/23/2006 10:22:27 AM

PadresFan104

Posts: 1223
Joined: 8/8/2005
Status: offline

King... Mind if I host those schedules on my website if the PureSim community finds them usefull?

(in reply to Schedule King)

Post #: 19

RE: ??? - Importing historical schedules - 7/23/2006 12:21:04 PM

motnahp

Posts: 1837
Joined: 8/22/2005
Status: offline

Sked King, I am VERY appreciative of your efforts.

For my particular tastes, I wanted an AL-only schedule and didn't see how to get just the AL without bringing the NL along with it (PS would expect all 26 teams and not just my 14).

Interestingly enough, less than 24 hours ago I Googled my way to that same OOTP thread and was able to get the 1981 "pre-strike" sked I had been seeking. I had lost my link to the thread (I remember using it many months ago).

There's been a lot of schedule "chatter" on this board lately. I will certainly write down this link where I can refer to it whenever needed.

(in reply to Schedule King)

Post #: 20