Home | Webstore
Latest News: OOTP Hotfix 21.1.33 - OOTP 21 Available - FHM 6 Available

OOTP Baseball 21 Available Now!

  

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

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

Reply
 
Thread Tools
Old 04-25-2018, 11:45 AM   #1
eriqjaffe
Hall Of Famer
 
eriqjaffe's Avatar
 
Join Date: May 2003
Location: Under The Christmas Fish
Posts: 6,857
Thanks: 360
Thanked 3,470x in 1,088 posts
OOTP Mobile Companion for Android

I'm proud to announce that something I have been working on for a while is now officially available. It's essentially a mobile-friendly interface for OOTP leagues, based largely on the layouts in MLB's app.

It uses the CSV (and, optionally, the HTML) generated by the game, and you get output that looks like this:



What you need is to have the CSV and HTML hosted somewhere on the internet. If you're in an online league that uses OOTP Online Utilities, you probably already have that, you just need to get the following paths from your commissioner. Or for solo leagues you can upload your own to whatever web hosting you have access to.
  1. CSV - wherever the CSV gets uploaded, usually something like this http://yourleague.com/csv
  2. HTML - wherever the "news/html" folder lives. So if your league's HTML is at http://yourleague.com/reports/news/html/index.html all you need is http://yourleague.com/reports.
Hopefully that makes sense. Once you provide that information, the app will download the CSV files and import them into an internal database in the app.

The app is compatible with Android 4.4 and up, and works with the CSV output from OOTP16 and newer.

__________________

Last edited by eriqjaffe; 04-25-2018 at 11:03 PM.
eriqjaffe is offline   Reply With Quote
19 thanks for this post:
andjbock (01-11-2019), BoofBonser26 (12-27-2018), bp_ (04-26-2018), CMH (04-27-2018), cody8200 (06-17-2018), darkcloud4579 (07-20-2019), Galeg (04-30-2018), GMGOD (07-14-2018), kq76 (06-30-2018), moonlightmerc (07-02-2018), old timer (06-18-2018), reds1 (06-17-2018), Rich Tiger Fan (06-21-2018), sjgmoney (04-25-2018), spacer15415 (06-18-2018), stealofhome (06-14-2018), TC Dale (06-19-2018), Ty Cobb (06-14-2018), Yarideki (08-12-2018)
Old 04-25-2018, 11:47 AM   #2
silvam14
Hall Of Famer
 
silvam14's Avatar
 
Join Date: Apr 2004
Location: Dedham, MA
Posts: 7,381
Thanks: 1,404
Thanked 6,240x in 2,227 posts
Wow! That’s amazing! Clearly a step in the right direction and something OOTP dev should seriously consider integrating into their products




Sent from my iPhone using Tapatalk
__________________
Senior "Nancy Boy" of the OOTP Boards
_______________________________________________
silvam14 is offline   Reply With Quote
Thank you for this post:
eriqjaffe (04-25-2018)
Old 04-25-2018, 12:10 PM   #3
eriqjaffe
Hall Of Famer
 
eriqjaffe's Avatar
 
Join Date: May 2003
Location: Under The Christmas Fish
Posts: 6,857
Thanks: 360
Thanked 3,470x in 1,088 posts
Heh. I just noticed a bug that prevents the app from launching. Hooray for my shoddy quality control!

I'll have an update out this evening, so don't download yet!
__________________

Last edited by eriqjaffe; 04-25-2018 at 11:03 PM.
eriqjaffe is offline   Reply With Quote
Old 04-25-2018, 11:04 PM   #4
eriqjaffe
Hall Of Famer
 
eriqjaffe's Avatar
 
Join Date: May 2003
Location: Under The Christmas Fish
Posts: 6,857
Thanks: 360
Thanked 3,470x in 1,088 posts
...and the 1.0.1 update is live, so now the app actually opens!
__________________
eriqjaffe is offline   Reply With Quote
Old 04-25-2018, 11:44 PM   #5
cavebutter
All Star Starter
 
cavebutter's Avatar
 
Join Date: Dec 2005
Location: Los Angeles
Posts: 1,078
Thanks: 354
Thanked 583x in 354 posts
Quote:
Originally Posted by eriqjaffe View Post
...and the 1.0.1 update is live, so now the app actually opens!


My turn to say it to you, eriqjaffe. This is really good stuff!


Sent from my iPhone using Tapatalk
__________________
MySQL, MyStruggle - A self-indulgent blog about my attempts to roll my own MySQL Database with OOTP

Logo Gallery
cavebutter is offline   Reply With Quote
Thank you for this post:
eriqjaffe (04-26-2018)
Old 04-27-2018, 09:33 AM   #6
jtnlange
Minors (Triple A)
 
jtnlange's Avatar
 
Join Date: Apr 2007
Location: Racine,WI
Posts: 218
Thanks: 241
Thanked 50x in 33 posts
Downloaded. Will try it out once I get home, but looks very cool. Nice and polished. Can't wait

Thanks

Trevor L.
jtnlange is offline   Reply With Quote
Thank you for this post:
eriqjaffe (04-27-2018)
Old 06-13-2018, 06:24 PM   #7
Ramzavail
Major Leagues
 
Ramzavail's Avatar
 
Join Date: Apr 2002
Location: NY
Posts: 436
Thanks: 97
Thanked 61x in 41 posts
awesome, is it possible to host it on google drive and have the app point to the google drive folder(s) ?
Ramzavail is offline   Reply With Quote
Old 06-14-2018, 12:34 PM   #8
Ty Cobb
All Star Starter
 
Ty Cobb's Avatar
 
Join Date: Mar 2013
Location: Grayling, MI
Posts: 1,592
Thanks: 791
Thanked 1,149x in 480 posts
Launched quickly on my Kindle Fire. Looks very helpful! Thanks a bunch for your tie and effort on this.
__________________
Baseball the way it was meant to be played...in the daytime while it snows.
Ty Cobb is offline   Reply With Quote
Old 06-19-2018, 07:25 AM   #9
Scott Vibert
Hall Of Famer
 
Join Date: Dec 2001
Location: My Computer
Posts: 8,018
Thanks: 309
Thanked 250x in 179 posts
Really cool.
Scott Vibert is offline   Reply With Quote
Old 06-19-2018, 10:29 AM   #10
Ramzavail
Major Leagues
 
Ramzavail's Avatar
 
Join Date: Apr 2002
Location: NY
Posts: 436
Thanks: 97
Thanked 61x in 41 posts
doesnt seem like google drive will work. Have any other ideas? free and easy ideas?
Ramzavail is offline   Reply With Quote
Old 06-30-2018, 03:27 PM   #11
eriqjaffe
Hall Of Famer
 
eriqjaffe's Avatar
 
Join Date: May 2003
Location: Under The Christmas Fish
Posts: 6,857
Thanks: 360
Thanked 3,470x in 1,088 posts
Quote:
Originally Posted by Ramzavail View Post
awesome, is it possible to host it on google drive and have the app point to the google drive folder(s) ?
That's actually a good idea, I'll have to dig into Google Drive integration.
__________________
eriqjaffe is offline   Reply With Quote
Thank you for this post:
kq76 (06-30-2018)
Old 06-30-2018, 04:40 PM   #12
kq76
Global Moderator
 
kq76's Avatar
 
Join Date: Nov 2002
Location: Vancouver, Canada
Posts: 8,913
Thanks: 1,237
Thanked 952x in 538 posts
Nice!

Do you have any plans to try to make it where you can upload changes to your organization? I realize you'd need cooperation from OOTP, but that would be awesome.
__________________
Support the Personal Bodyguard DH or the one-and-done DH
(I think they're both better than both the AL and NL games)
With the advent of openers, I prefer the Personal Bodyguard over the SP-only DH
and more flexible substitution rules.
kq76 is offline   Reply With Quote
Old 07-01-2018, 09:56 PM   #13
eriqjaffe
Hall Of Famer
 
eriqjaffe's Avatar
 
Join Date: May 2003
Location: Under The Christmas Fish
Posts: 6,857
Thanks: 360
Thanked 3,470x in 1,088 posts
Quote:
Originally Posted by kq76 View Post
Nice!

Do you have any plans to try to make it where you can upload changes to your organization? I realize you'd need cooperation from OOTP, but that would be awesome.
I'm not quite sure what you're asking about there. If you mean make changes and upload like you do in game, it's pretty unlikely.
__________________
eriqjaffe is offline   Reply With Quote
Old 07-14-2018, 03:23 AM   #14
GMGOD
Minors (Double A)
 
GMGOD's Avatar
 
Join Date: Oct 2005
Posts: 195
Thanks: 62
Thanked 4x in 3 posts
Infractions: 0/1 (1)
EXCELLENT. GOOD WORK. Can this be viewed as a utility link from the league website on an Iphone too?

Is there a cost for this?
__________________
The SIMBL "An Online League Specifically FOR the GM and BY the GM."

www.simbaseballleague.com

A Premier Online League Always Seeking Quality Owners- Join The SIMBL!
GMGOD is offline   Reply With Quote
Thank you for this post:
eriqjaffe (07-14-2018)
Old 07-14-2018, 07:51 PM   #15
eriqjaffe
Hall Of Famer
 
eriqjaffe's Avatar
 
Join Date: May 2003
Location: Under The Christmas Fish
Posts: 6,857
Thanks: 360
Thanked 3,470x in 1,088 posts
Quote:
Originally Posted by GMGOD View Post
EXCELLENT. GOOD WORK. Can this be viewed as a utility link from the league website on an Iphone too?

Is there a cost for this?
Thanks! There isn't an iPhone version, since I'd need a Mac to develop (or, at least, to submit to the App Store).

But it is free.
__________________
eriqjaffe is offline   Reply With Quote
Thank you for this post:
GMGOD (01-24-2019)
Old 08-10-2018, 11:44 AM   #16
The_Offspring187
Major Leagues
 
The_Offspring187's Avatar
 
Join Date: Apr 2002
Location: Tennessee
Posts: 307
Thanks: 100
Thanked 55x in 31 posts
Does anyone have a specific web hosting service they recommend? I'm looking for a free one but this is most likely the only thing I will be using it for so it probably won't need bells and whistles.

Sent from my LGLS755 using Tapatalk
The_Offspring187 is offline   Reply With Quote
Old 08-15-2018, 01:42 PM   #17
The_Offspring187
Major Leagues
 
The_Offspring187's Avatar
 
Join Date: Apr 2002
Location: Tennessee
Posts: 307
Thanks: 100
Thanked 55x in 31 posts
I keep getting a No Leagues Found in Remote CSV file error. I uploaded the csv but I can't figure out what is wrong. Any ideas?

Sent from my LGLS755 using Tapatalk
The_Offspring187 is offline   Reply With Quote
Old 08-16-2018, 09:30 AM   #18
eriqjaffe
Hall Of Famer
 
eriqjaffe's Avatar
 
Join Date: May 2003
Location: Under The Christmas Fish
Posts: 6,857
Thanks: 360
Thanked 3,470x in 1,088 posts
What is the path to the CSV? I'll take a look and see if I can figure out what's happening.
__________________
eriqjaffe is offline   Reply With Quote
Old 01-07-2019, 01:08 PM   #19
Ramzavail
Major Leagues
 
Ramzavail's Avatar
 
Join Date: Apr 2002
Location: NY
Posts: 436
Thanks: 97
Thanked 61x in 41 posts
Just got this to work. Looks awesome so far

Initial findings:

I think the font on the stats tab of the players page needs to be smaller or make the lines for each year bigger so it fits properly.

WHIP appears to be miscalculating. Every pitcher I look at have a WHIP + 10.00

When I click on leagues, to change to AAA or rookie ball, app crashes.

Last edited by Ramzavail; 01-07-2019 at 02:56 PM.
Ramzavail is offline   Reply With Quote
Thank you for this post:
eriqjaffe (01-07-2019)
Old 01-07-2019, 10:05 PM   #20
eriqjaffe
Hall Of Famer
 
eriqjaffe's Avatar
 
Join Date: May 2003
Location: Under The Christmas Fish
Posts: 6,857
Thanks: 360
Thanked 3,470x in 1,088 posts
Quote:
Originally Posted by Ramzavail View Post
I think the font on the stats tab of the players page needs to be smaller or make the lines for each year bigger so it fits properly.
I had actually done that originally, but there are so many columns to deal with that I felt a scrollable table was the best tradeoff to keep it readable. The tables are scrollable horizontally as well as vertically, and the top and left columns are sticky so you always kind of know where you are on the table.

Quote:
Originally Posted by Ramzavail View Post
WHIP appears to be miscalculating. Every pitcher I look at have a WHIP + 10.00
Yeah, I'm seeing that too. Can't believe I missed that. FWIW it's right on the leaderboards!

Quote:
Originally Posted by Ramzavail View Post
When I click on leagues, to change to AAA or rookie ball, app crashes.
That's a new one on me. Can you send me the path to the CSV? I'll try and look at that when I have time.

I am still planning on looking at Google Drive (and maybe other cloud storage) integration, it's just a matter of finding the time and energy.
__________________
eriqjaffe is offline   Reply With Quote
Thank you for this post:
Ramzavail (01-07-2019)
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:06 AM.

 

Major League and Minor League Baseball trademarks and copyrights are used with permission of Major League Baseball. Visit MLB.com and MiLB.com.

Officially Licensed Product – MLB Players, Inc.

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 © 2020 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

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