Is there any way to determine a team's next opponent from export files?

cavebutter · 06-22-2020, 01:25 PM

I'm working on some new tools for solo games and I'm wondering if there is any way at all to determine a given team's schedule from the export files. It seems like no, but figured I would ask. I know that the leagues.csv has a field for the location of the league schedule, and that may be my best bet, but I would have to build a parser for that first, and that seems like a bear.

Thanks!

cavebutter · 06-22-2020, 02:53 PM

Made a little progress:

The good part:
I'm able to manually export the schedule file and it has team ID's populated for each game.

The bad part:
The xml shows GAME day="-31" as well as day="124". That is, positive and negative integers to identify the day, and I am not sure how to interpret that.

1 theory I have is that the value of the day field is relative to the game date that the file was extracted, but that seems unlikely. For one thing, my sample data comes from early September and there many more positive than negative values.

And that's it. I am out of theories. Anyone have an idea?

cavebutter · 06-22-2020, 03:09 PM

The negative day values are probably for spring training. I am going to go with that assumption. Thanks for the help, Rubber Duck!

06-22-2020, 01:25 PM	#1
cavebutter All Star Starter Join Date: Dec 2005 Location: Los Angeles Posts: 1,164	Is there any way to determine a team's next opponent from export files? I'm working on some new tools for solo games and I'm wondering if there is any way at all to determine a given team's schedule from the export files. It seems like no, but figured I would ask. I know that the leagues.csv has a field for the location of the league schedule, and that may be my best bet, but I would have to build a parser for that first, and that seems like a bear. Thanks! __________________ MySQL, MyStruggle - A self-indulgent blog about my attempts to roll my own MySQL Database with OOTP Logo Gallery

06-22-2020, 02:53 PM	#2
cavebutter All Star Starter Join Date: Dec 2005 Location: Los Angeles Posts: 1,164	Made a little progress: The good part: I'm able to manually export the schedule file and it has team ID's populated for each game. The bad part: The xml shows GAME day="-31" as well as day="124". That is, positive and negative integers to identify the day, and I am not sure how to interpret that. 1 theory I have is that the value of the day field is relative to the game date that the file was extracted, but that seems unlikely. For one thing, my sample data comes from early September and there many more positive than negative values. And that's it. I am out of theories. Anyone have an idea? __________________ MySQL, MyStruggle - A self-indulgent blog about my attempts to roll my own MySQL Database with OOTP Logo Gallery

06-22-2020, 03:09 PM	#3
cavebutter All Star Starter Join Date: Dec 2005 Location: Los Angeles Posts: 1,164	The negative day values are probably for spring training. I am going to go with that assumption. Thanks for the help, Rubber Duck! __________________ MySQL, MyStruggle - A self-indulgent blog about my attempts to roll my own MySQL Database with OOTP Logo Gallery Last edited by cavebutter; 06-22-2020 at 03:13 PM.