Home | Webstore
Latest News: FHM 5 Available - OOTP 19 Available! - MLB Manager 2018 Available Now

Perfect Team is LIVE!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 19 > 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, 12:45 PM   #1
eriqjaffe
Hall Of Famer
 
eriqjaffe's Avatar
 
Join Date: May 2003
Location: Under The Christmas Fish
Posts: 6,705
Thanks: 278
Thanked 2,992x in 981 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.

__________________


I'm also the commissioner of the OTBA. Drop me a line if you'd like to join!

Last edited by eriqjaffe; 04-26-2018 at 12:03 AM.
eriqjaffe is offline   Reply With Quote
18 thanks for this post:
andjbock (01-11-2019), BoofBonser26 (12-27-2018), bp_ (04-26-2018), CMH (04-27-2018), cody8200 (06-17-2018), 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, 12:47 PM   #2
silvam14
Hall Of Famer
 
silvam14's Avatar
 
Join Date: Apr 2004
Location: Dedham, MA
Posts: 7,061
Thanks: 1,270
Thanked 5,726x in 2,074 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, 01:10 PM   #3
eriqjaffe
Hall Of Famer
 
eriqjaffe's Avatar
 
Join Date: May 2003
Location: Under The Christmas Fish
Posts: 6,705
Thanks: 278
Thanked 2,992x in 981 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!
__________________


I'm also the commissioner of the OTBA. Drop me a line if you'd like to join!

Last edited by eriqjaffe; 04-26-2018 at 12:03 AM.
eriqjaffe is offline   Reply With Quote
Old 04-26-2018, 12:04 AM   #4
eriqjaffe
Hall Of Famer
 
eriqjaffe's Avatar
 
Join Date: May 2003
Location: Under The Christmas Fish
Posts: 6,705
Thanks: 278
Thanked 2,992x in 981 posts
...and the 1.0.1 update is live, so now the app actually opens!
__________________


I'm also the commissioner of the OTBA. Drop me a line if you'd like to join!
eriqjaffe is offline   Reply With Quote
Old 04-26-2018, 12:44 AM   #5
cavebutter
All Star Starter
 
cavebutter's Avatar
 
Join Date: Dec 2005
Location: Los Angeles
Posts: 1,018
Thanks: 320
Thanked 548x in 337 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, 10:33 AM   #6
jtnlange
Minors (Double A)
 
jtnlange's Avatar
 
Join Date: Apr 2007
Location: Racine,WI
Posts: 195
Thanks: 170
Thanked 41x in 28 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, 07:24 PM   #7
Ramzavail
Major Leagues
 
Ramzavail's Avatar
 
Join Date: Apr 2002
Location: NY
Posts: 400
Thanks: 57
Thanked 55x in 35 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, 01:34 PM   #8
Ty Cobb
All Star Reserve
 
Ty Cobb's Avatar
 
Join Date: Mar 2013
Location: Northern Michigan
Posts: 557
Thanks: 302
Thanked 653x in 213 posts
Launched quickly on my Kindle Fire. Looks very helpful! Thanks a bunch for your tie and effort on this.
__________________
"Baseball was one-hundred percent of my life."
Ty Cobb is offline   Reply With Quote
Old 06-19-2018, 08:25 AM   #9
Scott Vibert
Hall Of Famer
 
Join Date: Dec 2001
Location: My Computer
Posts: 7,950
Thanks: 263
Thanked 221x in 155 posts
Really cool.
Scott Vibert is offline   Reply With Quote
Old 06-19-2018, 11:29 AM   #10
Ramzavail
Major Leagues
 
Ramzavail's Avatar
 
Join Date: Apr 2002
Location: NY
Posts: 400
Thanks: 57
Thanked 55x in 35 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, 04:27 PM   #11
eriqjaffe
Hall Of Famer
 
eriqjaffe's Avatar
 
Join Date: May 2003
Location: Under The Christmas Fish
Posts: 6,705
Thanks: 278
Thanked 2,992x in 981 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.
__________________


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:
kq76 (06-30-2018)
Old 06-30-2018, 05:40 PM   #12
kq76
Global Moderator
 
kq76's Avatar
 
Join Date: Nov 2002
Location: Vancouver, Canada
Posts: 8,850
Thanks: 1,167
Thanked 928x in 523 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 one-and-done DH or the SP-only DH
(I think they're both better than both the AL and NL games)
and more flexible substitution rules.
kq76 is offline   Reply With Quote
Old 07-01-2018, 10:56 PM   #13
eriqjaffe
Hall Of Famer
 
eriqjaffe's Avatar
 
Join Date: May 2003
Location: Under The Christmas Fish
Posts: 6,705
Thanks: 278
Thanked 2,992x in 981 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.
__________________


I'm also the commissioner of the OTBA. Drop me a line if you'd like to join!
eriqjaffe is offline   Reply With Quote
Old 07-14-2018, 04:23 AM   #14
GMGOD
Minors (Double A)
 
GMGOD's Avatar
 
Join Date: Oct 2005
Posts: 191
Thanks: 60
Thanked 3x in 2 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, 08:51 PM   #15
eriqjaffe
Hall Of Famer
 
eriqjaffe's Avatar
 
Join Date: May 2003
Location: Under The Christmas Fish
Posts: 6,705
Thanks: 278
Thanked 2,992x in 981 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.
__________________


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:
GMGOD (01-25-2019)
Old 08-10-2018, 12:44 PM   #16
The_Offspring187
Major Leagues
 
The_Offspring187's Avatar
 
Join Date: Apr 2002
Location: Tennessee
Posts: 302
Thanks: 96
Thanked 52x in 29 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, 02:42 PM   #17
The_Offspring187
Major Leagues
 
The_Offspring187's Avatar
 
Join Date: Apr 2002
Location: Tennessee
Posts: 302
Thanks: 96
Thanked 52x in 29 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, 10:30 AM   #18
eriqjaffe
Hall Of Famer
 
eriqjaffe's Avatar
 
Join Date: May 2003
Location: Under The Christmas Fish
Posts: 6,705
Thanks: 278
Thanked 2,992x in 981 posts
What is the path to the CSV? I'll take a look and see if I can figure out what's happening.
__________________


I'm also the commissioner of the OTBA. Drop me a line if you'd like to join!
eriqjaffe is offline   Reply With Quote
Old 01-07-2019, 02:08 PM   #19
Ramzavail
Major Leagues
 
Ramzavail's Avatar
 
Join Date: Apr 2002
Location: NY
Posts: 400
Thanks: 57
Thanked 55x in 35 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 03:56 PM.
Ramzavail is offline   Reply With Quote
Thank you for this post:
eriqjaffe (01-07-2019)
Old 01-07-2019, 11:05 PM   #20
eriqjaffe
Hall Of Famer
 
eriqjaffe's Avatar
 
Join Date: May 2003
Location: Under The Christmas Fish
Posts: 6,705
Thanks: 278
Thanked 2,992x in 981 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.
__________________


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-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 08:37 AM.

 

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