|
||||
|
|
OOTP Mods - Schedules Create your very own game schedules, or share historical schedules |
|
Thread Tools |
05-31-2006, 05:42 PM | #1 |
Hall Of Famer
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
|
What format are the new schedules in and.......
what's involved in converting mine over?
|
05-31-2006, 11:28 PM | #2 |
Hall Of Famer
Join Date: May 2002
Location: Longmont, CO
Posts: 3,162
|
I plan to go into some detail in here soon about the format. It can be somewhat complicated if you dig down into all the details, but it can offer a lot of hands-off simplicity for the user.
The plan is to convert all the OOTP6 format files into the new format ASAP. Not sure how long that may take, but I hope a big chunk a least will be done by the end of this weekend. Are yours from there? |
06-01-2006, 10:45 AM | #3 |
All Star Starter
Join Date: Dec 2001
Location: Somewhere to the left of 2nd base
Posts: 1,598
|
How involved would it be to develop a program to take a .csv and convert it to the .xml? I've looked at a file, and if I had the BASIC I was raised on back in the 70's and 80's, I could whip something up rather quickly (2-4 hours + debugging ... maybe a day) but I don't know VB that well.
Like, how to open a source file: 10 open(1,"Datafile.csv") as read and a destination file: 20 open(2,"schedule.xml") as write define an array 30 dim ParsedInputLine(4) etc I have a program all layed out in my head, I just can't translate it into VB ... help?
__________________
MWT Did Tennesee Delaware Mississppi's New Jersey? Idaho ... Alaska! Last edited by SSG Troyer; 06-03-2006 at 11:24 PM. |
06-01-2006, 09:21 PM | #4 |
Hall Of Famer
Join Date: May 2002
Location: Longmont, CO
Posts: 3,162
|
I doubt it would be tough for someone to put together something like that. In fact a carefully constructed spreadsheet could put most of it together.
I already have a program to do the conversion, but it is for software generally used for computational processing that I believe exceedingly few people here have. Thus I plan to just run it on my machine then post the resulting files. The processing will not take that long - I really think this weekend can see a lot of the posted V6 format schedules transferred over. Cataloging and putting them online might be the most time-consuming part. But after that huge burst of those initial files, I figure I can convert things for people within a day whenever I am around. Still anyone who could make a conversion tool, particularly something that would be easy for anyone to download and use, is welcome to do so. I just hope to make a lot of the need for it go away soon then to be able to relatively promptly take care of that work as it comes up beyond that. |
06-01-2006, 09:49 PM | #5 |
Hall Of Famer
Join Date: Feb 2002
Location: Up There
Posts: 15,412
|
I certainly wouldn't mind be able to having a conversion utility that could run on my system... then I wouldn't have to bug gmo so much...
|
06-02-2006, 12:45 AM | #6 |
All Star Starter
Join Date: Dec 2001
Location: Somewhere to the left of 2nd base
Posts: 1,598
|
Well, when you get a chance ... lord knows, I've got a lot of other work to do before I hit the first continue ...
48 teams, 2 sub-leagues (24 per), 3 divisions (8 per) each. 2x3x8. 70 divisional (10 each, 5H, 5A) 96 non-divisional (6 each, 3H, 3A) No interleague aka ILN_BGN_G166_SL1_D1_T8_D2_T8_D3_T8_SL2_D1_T8_D2_T8 _D3_T8_C_ 166 games total I have a .xls with what I've done if that would help, and if you haven't gotten around to it by the time I'm ready, I'll start taking some VB classes ...
__________________
MWT Did Tennesee Delaware Mississppi's New Jersey? Idaho ... Alaska! |
06-02-2006, 01:03 PM | #7 |
Minors (Double A)
Join Date: Mar 2005
Posts: 108
|
I also have a plan in my head to create some kind of converter to convert the old schedules to the new format. Unfortunately I have to go to work soon, but I'll see about messing around with it tonight if I get a chance.
But basically, it would mean reading a line of the old schedule, then converting that to the new format if that helps anyone. EDIT: I've written a rough program that will convert the old 6.0/6.5 schedules to the new format and am working on making sure all the other requirements in the file are met. Hopefully I'll have some kind of batch converter created later today if time permits. Last edited by LeafsFan2005NC; 06-03-2006 at 01:08 PM. |
06-02-2006, 05:56 PM | #8 | |
Hall Of Famer
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
|
Quote:
Please? |
|
06-04-2006, 01:16 AM | #9 |
Minors (Double A)
Join Date: Mar 2005
Posts: 108
|
I have created a working program to convert the old format schedules over. There's a little bit to tweak so that you can customize the file name (at present I've used the default major_league_ml_c_YYYY.lsdl filename) and options for the Interleague flag to be turned on and whether the teams play balanced or unbalanced schedules.
Other than that little tweak, the program allows you to choose the old format file, choose the start date of the season, number of games played by each team, number of leagues and divisions (2 leagues and up to 4 divisions at this point, but I can change that if necessary) and number of teams in each division. You can also choose whether the all-star game is played and the day the game is to be played on. |
06-04-2006, 11:03 AM | #10 |
Minors (Single A)
Join Date: May 2002
Posts: 76
|
Great news, LeafsFan. There are 6.5 schedules posted in the ootp6 mod forum to suit all my needs; I'm looking forward to utilizing to fruits of your labor! Thanks.
|
06-04-2006, 11:14 AM | #11 |
Hall Of Famer
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
|
Bring it on, Leafs!
|
06-06-2006, 12:48 AM | #12 |
All Star Starter
Join Date: Dec 2001
Location: Somewhere to the left of 2nd base
Posts: 1,598
|
I finally wrote an Excel module to convert my spreadsheet into a .lsdl sans header information, which I then text-edited in.
The module reads a sheet I called "DayByDay", and has four columns with a header row of game day, h, a, and time. The module is very specific to my schedule, but could be reletively easily converted to others. But, I guess, anyone who would bother could have just as easily written their own ... nonetheless, if anyone cares, here it is ... Code:
Sub CreateIt() Dim x As Integer Dim line As String Set fs = CreateObject("Scripting.FileSystemObject") Open "c:\ootpb2006\Schedule.lsdl" For Output As #1 Worksheets("DayByDay").Activate line = "{GAME}" Print #1, line For x = 2 To 3985 line = "{GAME day=" & Chr(34) & Cells(x, 1) & Chr(34) _ & " time=" & Chr(34) & Cells(x, 4) & Chr(34) _ & " away=" & Chr(34) & Cells(x, 3) & Chr(34) _ & " home=" & Chr(34) & Cells(x, 2) & Chr(34) _ & " /}" Print #1, line Next x Close #1 End Sub
__________________
MWT Did Tennesee Delaware Mississppi's New Jersey? Idaho ... Alaska! Last edited by SSG Troyer; 06-06-2006 at 12:52 AM. |
Bookmarks |
|
|