View Single Post
Old 07-13-2020, 02:01 PM   #9
cavebutter
All Star Starter
 
cavebutter's Avatar
 
Join Date: Dec 2005
Location: Los Angeles
Posts: 1,163
First of all, thank you so much for the feedback! There is no other way for me to get better than to have people other than me try this out. Thank you, thank you, thank you. I will respond as best I can in-line.

Quote:
Originally Posted by ALB123 View Post
Hey Cavebutter... I noticed on the Depth Chart spreadsheet if you click on the depthchart_sp or depthchart_bp sheet there are two boxes titled "Pitching Ratings v R".

I'm sure you meant to have one of the boxes titled "Pitching Ratings v L", right?
That's correct, one of the chart titles is incorrect. They both should be pulling data from the correct columns though. This will be corrected in the next point release.

Quote:
Originally Posted by ALB123 View Post
Also, this is just nitpicking, but did you intentionally title the sheet "depthchart_bp" instead of "depthchart_rp"? Ya know because OOTP refers to non-starting pitchers as RP not BP. Before some wiseguy jumps on this, I'm well aware that some non-starters are CL, but that was not the point.
In the category of "It made sense to me at the time...", I made one sheet for starters ("SP") and one for the bullpen ("BP"). I see how that can be unclear and I will change that in the next release.

Quote:
Originally Posted by ALB123 View Post
For some reason, the created spreadsheet: New York Yankees-02-24-1990_depth_chart.xlsx is an empty 89kb file. It has all of the charts and individual pages, but there are no player names and no data at all. I have properly entered in the directory where all of my data files are from the OOTP Export to csv files feature - C:\Users\Chris\Documents\Out of the Park Developments\OOTP Baseball 21\saved_games\1981 Yankees OOTP 21.lg\import_export\csv. The csv files, such as players.csv, teams.csv, leagues.csv, etc. are all present and accounted for and they all contain the appropriate data for your application. I ran a test and I know your program will not proceed if you entered in the wrong directory because it can't find those files it needs. I'm then selecting 100 for MLB and 10 for NY Yankees and I receive the message "All set! Your depthchart is..." indicating all was well. As I said, it produces the spreadsheet, but there is nothing occupying any of the fields you created. You may have noticed that I ran this application of yours on in-game date 02/24/1990. Does it have anything to do with running it during the off-season?
Sure does. The application pulls current year stats. More specifically, it pulls stats from the current calendar year. So, I believe that you can run the depth charts on 12/31 and get good data, but not on 1/1. There's probably an easy way to change it. Will look into it for a future release.

Quote:
Originally Posted by ALB123 View Post
Likewise, I am not any having success with the gameday workbook option. I launch the application and select the feature I want. It asks for the location of my data files, just like the Depth Chart option does. I enter it and the Small Database is successfully created and the program is connected to it - all good signs. Then I enter in 100 for MLB and 10 for the Yankees. Next, I need to paste the location of the file that was created when I exported the league schedule. I placed the file named ILN_BGN_G162_SL1_D2_T7_T7_SL2_D2_T6_T6.lsdl in the same directory (mentioned previously) with all of the csv files for simplicity. Your app mentions that if I don't provide the correct location of that schedule file it will quit and I'll be left pulling my hair out. Of course, as soon as I press Enter something appears on the screen but its gone 1/10th of a second later when the app quits completely.

Does this gamebook workbook option need to be run on Day 1 of the regular season at the earliest or something? I use the up/down arrows that shows 6 dates with either game information or no game/All-Star Game, etc. I clicked the down arrow until I got to the opening week of my upcoming 1990 season. It shows me 6 days' worth of dates and opponents including the scheduled starting pitcher. Based on that, I stopped thinking that running this gameday workbook option during Preseason mattered at all, but maybe it does?
So, keep in mind that the schedule file is league-specific. That is, even if you have leagues that are structured identically, you will still need to export the schedule file associated with that league. Reason being that those schedule files include the team_id that I use to tie everything together.

Also, not entirely clear from what you wrote, but I am assuming that you ran this tool in the offseason as well. I should have been more clear in the docs, but the gameday utility will show your games over the next 7 days, NOT your next 7 games.

Quote:
Originally Posted by ALB123 View Post
Any thoughts on this matter? If anyone who's had success with this amazing tool feels like giving my files a shot on their system, let me know and I'll 7Zip the necessary files and post a download link. I don't mean to be so rude. I know everybody only has so much free time, why waste any of it on my problems? I hope I haven't offended Cavebutter or anyone who's read this post. Thank you.
Again, I really appreciate the feedback! I'd like this to be useful to people other than just myself.

So, try running this again during the regular season and let me know how it works out.
__________________
MySQL, MyStruggle - A self-indulgent blog about my attempts to roll my own MySQL Database with OOTP

Logo Gallery

Last edited by cavebutter; 07-13-2020 at 02:36 PM.
cavebutter is offline   Reply With Quote