Home | Webstore
Latest News: OOTP 25 Available - FHM 10 Available - OOTP Go! Available

Out of the Park Baseball 25 Buy Now!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 25 > OOTP Mods > OOTP Mods - Database Tools
Register Blogs FAQ Calendar Today's Posts Search

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: 7,485
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
Old 04-25-2018, 11:47 AM   #2
silvam14
Hall Of Famer
 
silvam14's Avatar
 
Join Date: Apr 2004
Location: Dedham, MA
Posts: 9,746
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
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: 7,485
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: 7,485
...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,158
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
Old 04-27-2018, 09:33 AM   #6
jtnlange
Minors (Triple A)
 
jtnlange's Avatar
 
Join Date: Apr 2007
Location: Racine,WI
Posts: 255
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
Old 06-13-2018, 06:24 PM   #7
Ramzavail
All Star Reserve
 
Ramzavail's Avatar
 
Join Date: Apr 2002
Location: NY
Posts: 586
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
Hall Of Famer
 
Ty Cobb's Avatar
 
Join Date: Mar 2013
Location: Grayling, MI
Posts: 3,937
Blog Entries: 65
Launched quickly on my Kindle Fire. Looks very helpful! Thanks a bunch for your tie and effort on this.
__________________

“What’s the most you ever lost on a coin toss?”

“Everyone is an atheist until Templars begin marching in the rain.”
Absinthe makes the heart grow fonder.
Society's tolerance for violent criminals is dumbfounding.
"Alinsky works for me now."
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,182
Really cool.
Scott Vibert is offline   Reply With Quote
Old 06-19-2018, 10:29 AM   #10
Ramzavail
All Star Reserve
 
Ramzavail's Avatar
 
Join Date: Apr 2002
Location: NY
Posts: 586
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: 7,485
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
Old 06-30-2018, 04:40 PM   #12
kq76
Global Moderator
 
kq76's Avatar
 
Join Date: Nov 2002
Location: Vancouver, Canada
Posts: 10,697
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.
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: 7,485
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 (Triple A)
 
GMGOD's Avatar
 
Join Date: Oct 2005
Posts: 218
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
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: 7,485
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
Old 08-10-2018, 11:44 AM   #16
The_Offspring187
Major Leagues
 
The_Offspring187's Avatar
 
Join Date: Apr 2002
Location: Tennessee
Posts: 439
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: 439
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: 7,485
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
All Star Reserve
 
Ramzavail's Avatar
 
Join Date: Apr 2002
Location: NY
Posts: 586
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
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: 7,485
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
Reply

Bookmarks


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 12:45 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 © 2023 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

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