Home | Webstore
Latest News: OOTP Update 20.6 - OOTP 20 Available - FHM 5 Available

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 20 > OOTP Mods > OOTP Mods - Database Tools

OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome

Reply
 
Thread Tools
Old 01-07-2019, 10:38 PM   #21
Ramzavail
Major Leagues
 
Ramzavail's Avatar
 
Join Date: Apr 2002
Location: NY
Posts: 413
Thanks: 64
Thanked 56x in 36 posts
I'll PM you the csv.

as far as the font, it appears to be really predicated on the font setting on your phone. I had it on largest and it looked like this.



I put it on default and it looks perfect.

Last edited by Ramzavail; 01-07-2019 at 10:40 PM.
Ramzavail is offline   Reply With Quote
Old 01-07-2019, 11:37 PM   #22
Ramzavail
Major Leagues
 
Ramzavail's Avatar
 
Join Date: Apr 2002
Location: NY
Posts: 413
Thanks: 64
Thanked 56x in 36 posts
Also noticed that holds and blown saves aren't marked in the boxscores. Can send examples if need be.

Sent from my Pixel 3 using Tapatalk
Ramzavail is offline   Reply With Quote
Old 01-08-2019, 09:56 AM   #23
Ramzavail
Major Leagues
 
Ramzavail's Avatar
 
Join Date: Apr 2002
Location: NY
Posts: 413
Thanks: 64
Thanked 56x in 36 posts
More feedback regarding boxscores (not sure if the missing info is by design however): But overall the boxscores look awesome and well organized.

1. Doesn't look like the boxscore likes it when there is a defensive sub. No indent (like there is for a PH) and no position noted (IE. X. Player, as opposed to X. Player, SS) Also, no notification of position moved during game, doesn't state the 2nd or 3rd position the player played at.

2. Sometimes (and I haven't been able to figure out why or if there is a pattern) the ERA on the summary boxscore for the winning pitcher or losing pitcher is slightly off then in the detailed boxscore. IE. Losing pitching ERA 5.31 in summary, 5.34 in detail.
3. Hitting/Fielding missing info: 2-out RBI, Runners left in scoring position, Team LOB, SB/CS, Errors, PB
4. Pitching missing info: WP, Groundouts-Flyouts (Pitchers missing when either there is a 0 on groundout or Flyout or both)

Can provide examples now that you have my csv.
Ramzavail is offline   Reply With Quote
Old 01-08-2019, 09:57 PM   #24
Ramzavail
Major Leagues
 
Ramzavail's Avatar
 
Join Date: Apr 2002
Location: NY
Posts: 413
Thanks: 64
Thanked 56x in 36 posts
More feedback:

1. Click on a pitcher and look at the stats tab. I think ERA is calculating off of runs instead of earned runs. The stats tab ERA doesn't match the summary tab, I'm assuming that the summary is taking the info as is and the stats tab is recalculating?

2. Consider using a different font, I have to make the font settings on my phone to "small" in order to see the capital letter Q properly. On any other bigger size it looks like "ONS"

3. Not sure if this is a big deal or not, but if you are not completely done with all the games for the day, and you export the csv files, none of the boxscores will show up on the scoreboard in the app for that day.
Ramzavail is offline   Reply With Quote
Old 01-09-2019, 09:30 AM   #25
eriqjaffe
Hall Of Famer
 
eriqjaffe's Avatar
 
Join Date: May 2003
Location: Under The Christmas Fish
Posts: 6,780
Thanks: 329
Thanked 3,239x in 1,041 posts
Quote:
Originally Posted by Ramzavail View Post
1. Click on a pitcher and look at the stats tab. I think ERA is calculating off of runs instead of earned runs. The stats tab ERA doesn't match the summary tab, I'm assuming that the summary is taking the info as is and the stats tab is recalculating?
Good catch on the ERA calculation, it appears that I am using R instead of ER. I'll add that to the list of things to fix along with WHIP.

Quote:
Originally Posted by Ramzavail View Post
2. Consider using a different font, I have to make the font settings on my phone to "small" in order to see the capital letter Q properly. On any other bigger size it looks like "ONS"
I chose the font I did to be consistent with the HTML reports that the game puts out, but I can play around with it.

Quote:
Originally Posted by Ramzavail View Post
3. Not sure if this is a big deal or not, but if you are not completely done with all the games for the day, and you export the csv files, none of the boxscores will show up on the scoreboard in the app for that day.
That's a limitation of the CSV, and ties into your other issues with the box scores. If the HTML is available it's a lot better because the app actually grabs that and parses it, but the CSV by itself doesn't contain enough detail to create a 100% accurate box score so what you get there is the closest I can get.
__________________


I'm also the commissioner of the OTBA. Drop me a line if you'd like to join!
eriqjaffe is offline   Reply With Quote
Thank you for this post:
Ramzavail (01-09-2019)
Old 01-09-2019, 01:29 PM   #26
Ramzavail
Major Leagues
 
Ramzavail's Avatar
 
Join Date: Apr 2002
Location: NY
Posts: 413
Thanks: 64
Thanked 56x in 36 posts
gotcha okay cool
Ramzavail is offline   Reply With Quote
Old 02-27-2019, 02:52 PM   #27
Jocko_Doubleday
Bat Boy
 
Jocko_Doubleday's Avatar
 
Join Date: Jan 2018
Posts: 6
Thanks: 4
Thanked 0x in 0 posts
Trying to set up the app and I'm stuck

I'm trying to set up the app, and I'm stuck on the CSV link.



https://statsplus.net/fallclassicfederation/exports



That's where our export tracker is, but I don't know what else I need.
Jocko_Doubleday is offline   Reply With Quote
Old 03-12-2019, 12:21 PM   #28
Ramzavail
Major Leagues
 
Ramzavail's Avatar
 
Join Date: Apr 2002
Location: NY
Posts: 413
Thanks: 64
Thanked 56x in 36 posts
you just need to upload all the csv files into a folder and point the app to that folder.

as an example:

hxxp://blahblah.com/ramzavail/csv/
Ramzavail is offline   Reply With Quote
Old 07-20-2019, 12:58 AM   #29
Tzar
Minors (Rookie Ball)
 
Join Date: Jul 2010
Posts: 27
Thanks: 16
Thanked 14x in 8 posts
I keep getting a No Leagues Found in Remote CSV file error. The path to the csv is: http://marsolais.epizy.com/OOTP20/Toronto/csv/
Tzar is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 10:40 PM.

 

Major League Baseball trademarks and copyrights are used with permission of MLB Advanced Media, L.P. Minor League Baseball trademarks and copyrights are used with the permission of Minor League Baseball. All rights reserved.

The Major League Baseball Players Association (www.MLBPLAYERS.com ) is the collective bargaining representative for all professional baseball players of the thirty Major League Baseball teams and serves as the exclusive group licensing agent for commercial and licensing activities involving active Major League baseball players. On behalf of its members, it operates the Players Choice licensing program and the Players Choice Awards, which benefit the needy through the Major League Baseball Players Trust, a charitable foundation established and run entirely by Major League baseball players. Follow: @MLB_Players; @MLBPAClubhouse; @MLBPlayersTrust

Out of the Park Baseball is a registered trademark of Out of the Park Developments GmbH & Co. KG

Google Play is a trademark of Google Inc.

Apple, iPhone, iPod touch and iPad are trademarks of Apple Inc., registered in the U.S. and other countries.

COPYRIGHT © 2017 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Copyright © 2018 Out of the Park Developments