What format are the new schedules in and.......

Cooleyvol · 05-31-2006, 05:42 PM

what's involved in converting mine over?

gmo · 05-31-2006, 11:28 PM

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?

SSG Troyer · 06-01-2006, 10:45 AM

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?

gmo · 06-01-2006, 09:21 PM

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.

Le Grande Orange · 06-01-2006, 09:49 PM

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...

SSG Troyer · 06-02-2006, 12:45 AM

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 ...

LeafsFan2005NC · 06-02-2006, 01:03 PM

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.

Cooleyvol · 06-02-2006, 05:56 PM

Quote:

Originally Posted by gmo

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?

PLEASE include a two division league with 7 teams in each league version. Ideally, with around 126 games per team.

Please?

LeafsFan2005NC · 06-04-2006, 01:16 AM

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.

AcesFull · 06-04-2006, 11:03 AM

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.

Cooleyvol · 06-04-2006, 11:14 AM

Bring it on, Leafs!

SSG Troyer · 06-06-2006, 12:48 AM

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

Note that, because the BBS takes the "less-than" and "greater-than" signs as something else, I had to replace them here with left- and right-braces.

06-01-2006, 10:45 AM	#3
SSG Troyer 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-02-2006, 12:45 AM	#6
SSG Troyer 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
LeafsFan2005NC 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-06-2006, 12:48 AM	#12
SSG Troyer 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 Note that, because the BBS takes the "less-than" and "greater-than" signs as something else, I had to replace them here with left- and right-braces. __________________ MWT Did Tennesee Delaware Mississppi's New Jersey? Idaho ... Alaska! Last edited by SSG Troyer; 06-06-2006 at 12:52 AM.

05-31-2006, 05:42 PM	#1
Cooleyvol 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
gmo Hall Of Famer Join Date: May 2002 Location: Longmont, CO Posts: 3,154	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, 09:21 PM	#4
gmo Hall Of Famer Join Date: May 2002 Location: Longmont, CO Posts: 3,154	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
Le Grande Orange Hall Of Famer Join Date: Feb 2002 Location: Up There Posts: 15,405	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-04-2006, 01:16 AM	#9
LeafsFan2005NC 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
AcesFull 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
Cooleyvol Hall Of Famer Join Date: Dec 2001 Location: Union City, TN Posts: 6,383	Bring it on, Leafs!