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 09-06-2017, 09:10 AM   #981
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,293
Thanks: 361
Thanked 3,281x in 1,940 posts
Quote:
Originally Posted by Painmantle View Post
Well, What is the possible explanation for players in ootp18 being so poorly rated out of the gate when importing with the DataBase? I'm talking so poorly that the highest rated position player had a Rating of 12 (1-20 scale) and skill ratings were also proportionally and comparatively low when compared to past seasons using this DataBase with other versions of OOTP.
Since the database you are using did not change perhaps 18 is different than 17 in some way? Perhaps the missing columns even though unused throw something off.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 09-06-2017, 09:11 AM   #982
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,293
Thanks: 361
Thanked 3,281x in 1,940 posts
Quote:
Originally Posted by RANGER11JP View Post
Spritze,

Whatever did you do to yourself????
Injury plus infection = bad mojo.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 09-06-2017, 09:39 AM   #983
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,367
Thanks: 1,403
Thanked 1,204x in 774 posts
Quote:
Originally Posted by Spritze View Post
Injury plus infection = bad mojo.
dang! hope yer feeling better soon. Meanwhile, join the ranks of the unwalking wounded ... been on crutches more this year than not myself.
Take care man.
__________________
"This is my opening farewell " - Jackson Browne
“They make a desolation and call it peace.” ― Agha Shahid Ali
"Maybe she just has to sing, for the sake of the song - And who do I think that I am to decide that she's wrong." - Townes Van Zandt
"I saw a young man leaning on his wooden crutch - He called out to me, 'Don't ask for so much' And a young woman leaning in her darkened door She cried out to me, 'Why not ask for more?' " - Leonard Cohen
Before Mays, before DiMaggio, there was Oscar Charleston.
"All the lies about Babe Ruth are true." - Waite Hoyt

Avatar is the late great Townes Van Zandt. rip.

Last edited by mitchkenn; 09-06-2017 at 09:41 AM.
mitchkenn is offline   Reply With Quote
Old 09-06-2017, 08:43 PM   #984
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,294
Thanks: 1,782
Thanked 228x in 166 posts
Quote:
Originally Posted by Spritze View Post
Since the database you are using did not change perhaps 18 is different than 17 in some way? Perhaps the missing columns even though unused throw something off.
Where and what columns are missing? I used to be able to substitute Lahman's teams.csv and 17 would claim an error but create the team with no players. That was useful. Have not figured that out for 18 yet.
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 09-09-2017, 12:05 AM   #985
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,293
Thanks: 361
Thanked 3,281x in 1,940 posts
teams.csv has not changed.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Thank you for this post:
RANGER11JP (09-10-2017)
Old 09-10-2017, 07:15 PM   #986
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,294
Thanks: 1,782
Thanked 228x in 166 posts
Quote:
Originally Posted by Spritze View Post
teams.csv has not changed.
I am using LAHMAN's csv.
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 09-12-2017, 04:52 PM   #987
dpd376
Minors (Double A)
 
Join Date: Dec 2009
Posts: 102
Thanks: 86
Thanked 17x in 13 posts
Quote:
Originally Posted by RANGER11JP View Post
I am using LAHMAN's csv.
Do you mean the one in the default stats folder? I'm just started a test league with that and got ratings as high as 9 out of 10.
__________________
"I hate astroturf, but I love the game astroturf produces."
Bill James
dpd376 is offline   Reply With Quote
Old 09-12-2017, 05:54 PM   #988
Painmantle
Hall Of Famer
 
Painmantle's Avatar
 
Join Date: Apr 2006
Location: Greenfield ,IN
Posts: 3,038
Thanks: 615
Thanked 2,194x in 1,764 posts
Quote:
Originally Posted by Spritze View Post
Since the database you are using did not change perhaps 18 is different than 17 in some way? Perhaps the missing columns even though unused throw something off.
In this thread,

http://www.ootpdevelopments.com/boar...d.php?t=278336

you said it could be the missing fields causing the issue. Basically at this point I am forced to reimport every single player in every draft pool and that is a total pain in the butt.At this poin all the Db does in ootp18 is let me know who to import
__________________
“As soon as I got out there I felt a strange relationship with the pitcher's mound. It was as if I'd been born out there. Pitching just felt like the most natural thing in the world. Striking out batters was easy.” -Babe Ruth
“Ruth made a grave mistake when he gave up pitching. Working once a week, he might have lasted a long time and become a great star.”-Tris Speaker
My Dynasties
The Beantown Bambino

Last edited by Painmantle; 09-12-2017 at 05:58 PM.
Painmantle is offline   Reply With Quote
Old 09-15-2017, 06:23 PM   #989
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,293
Thanks: 361
Thanked 3,281x in 1,940 posts
https://www.dropbox.com/s/wcbm8q99jz...OTP18.zip?dl=0

LINK TO THE 18 VERSION
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Thank you for this post:
The Game (09-25-2017)
Old 09-15-2017, 06:24 PM   #990
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,293
Thanks: 361
Thanked 3,281x in 1,940 posts
https://www.dropbox.com/s/wcbm8q99jz...OTP18.zip?dl=0

LINK TO THE 18 VERSION
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
4 thanks for this post:
dpd376 (09-17-2017), JT_Dutch (11-21-2017), mitchkenn (09-16-2017), RANGER11JP (09-16-2017)
Old 09-16-2017, 11:27 AM   #991
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,367
Thanks: 1,403
Thanked 1,204x in 774 posts
many thanks for your hard work. when i get a new game started, i'm going to use this data base. Get well soon.
__________________
"This is my opening farewell " - Jackson Browne
“They make a desolation and call it peace.” ― Agha Shahid Ali
"Maybe she just has to sing, for the sake of the song - And who do I think that I am to decide that she's wrong." - Townes Van Zandt
"I saw a young man leaning on his wooden crutch - He called out to me, 'Don't ask for so much' And a young woman leaning in her darkened door She cried out to me, 'Why not ask for more?' " - Leonard Cohen
Before Mays, before DiMaggio, there was Oscar Charleston.
"All the lies about Babe Ruth are true." - Waite Hoyt

Avatar is the late great Townes Van Zandt. rip.
mitchkenn is offline   Reply With Quote
Old 09-16-2017, 11:36 AM   #992
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,294
Thanks: 1,782
Thanked 228x in 166 posts
Quote:
Originally Posted by Spritze View Post
Hi Spritze,

Are you up to being able to write a short "Read Me" for this here? Some may be unaware or forgetful about it's function.

I hope you are feeling better.
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 09-16-2017, 01:39 PM   #993
ArcAngel
All Star Reserve
 
ArcAngel's Avatar
 
Join Date: Oct 2014
Location: Bremen OH USA
Posts: 971
Thanks: 161
Thanked 424x in 298 posts
Quote:
Originally Posted by RANGER11JP View Post
Hi Spritze,

Are you up to being able to write a short "Read Me" for this here? Some may be unaware or forgetful about it's function.

I hope you are feeling better.
Don't quote me, but what I did was make a new folder in my 18 data folder called "stats - spritze", extracted the contents of the above archive into it, then copied the csv files from the original stats folder into the new one.

When you create a new game, there's an ability to change the path of the data folder, but don't remember exactly where it is off the top of my head.
ArcAngel is offline   Reply With Quote
Old 09-16-2017, 04:26 PM   #994
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,294
Thanks: 1,782
Thanked 228x in 166 posts
Quote:
Originally Posted by ArcAngel View Post
Don't quote me, but what I did was make a new folder in my 18 data folder called "stats - spritze", extracted the contents of the above archive into it, then copied the csv files from the original stats folder into the new one.

When you create a new game, there's an ability to change the path of the data folder, but don't remember exactly where it is off the top of my head.
Okay, that help's some. I want to try some experiments with the csv files.
Thanks!
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 09-17-2017, 03:26 AM   #995
szathkey
Minors (Double A)
 
szathkey's Avatar
 
Join Date: Jun 2008
Posts: 106
Thanks: 25
Thanked 0x in 0 posts
New 18yr old DB

In December when the game imports the draft class it seems like the db won't import players into the draft class, but instead populates the league with about 10 or so free agents?

Is anyone else seeing this? Any solutions found?

Thanks everyone.
szathkey is offline   Reply With Quote
Old 09-17-2017, 04:05 PM   #996
dpd376
Minors (Double A)
 
Join Date: Dec 2009
Posts: 102
Thanks: 86
Thanked 17x in 13 posts
Quote:
Originally Posted by szathkey View Post
In December when the game imports the draft class it seems like the db won't import players into the draft class, but instead populates the league with about 10 or so free agents?

Is anyone else seeing this? Any solutions found?

Thanks everyone.
Yeah, I'm seeing this too. I get a message saying the historical database can't be found, and I triple checked the import path on the historical settings page.
__________________
"I hate astroturf, but I love the game astroturf produces."
Bill James
dpd376 is offline   Reply With Quote
Old 09-18-2017, 01:07 AM   #997
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,293
Thanks: 361
Thanked 3,281x in 1,940 posts
Quote:
Originally Posted by szathkey View Post
In December when the game imports the draft class it seems like the db won't import players into the draft class, but instead populates the league with about 10 or so free agents?

Is anyone else seeing this? Any solutions found?

Thanks everyone.
This is an OOTP18 bug that keeps returning. The players would appear in the draft a year late in previous incarnations of this bug.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 09-18-2017, 03:17 PM   #998
szathkey
Minors (Double A)
 
szathkey's Avatar
 
Join Date: Jun 2008
Posts: 106
Thanks: 25
Thanked 0x in 0 posts
I ran it out for a few seasons and the same thing happened in 1872 and 1873.

This is the bug that they have still not been able to recreate if I remember correctly, yes?
szathkey is offline   Reply With Quote
Old 09-18-2017, 05:03 PM   #999
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,293
Thanks: 361
Thanked 3,281x in 1,940 posts
Quote:
Originally Posted by szathkey View Post
I ran it out for a few seasons and the same thing happened in 1872 and 1873.

This is the bug that they have still not been able to recreate if I remember correctly, yes?
Yes
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 09-23-2017, 05:17 PM   #1000
dpd376
Minors (Double A)
 
Join Date: Dec 2009
Posts: 102
Thanks: 86
Thanked 17x in 13 posts
Quote:
Originally Posted by Spritze View Post
This is an OOTP18 bug that keeps returning. The players would appear in the draft a year late in previous incarnations of this bug.
So if I install an earlier version of OOTP18 and set the draft for Feb.10 and the import for Jan.10 it should import correctly right? Do you know which was the last version that imported players a year late instead of not at all?
__________________
"I hate astroturf, but I love the game astroturf produces."
Bill James
dpd376 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 08:11 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