Home | Webstore
Latest News: OOTP 26 Available - FHM 12 Available - OOTP Go! Available

Out of the Park Baseball 26 Buy Now!

  

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

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

Reply
 
Thread Tools
Old 05-30-2014, 10:20 PM   #1
Trebro
All Star Reserve
 
Join Date: Mar 2013
Posts: 753
Having an issue with the SPRITZE DB in ootp 15

Hi Guys,

So I am having a strange issue with the Spritze DB in OOTP15.

I am using the latest version.
I pointed to the correct historical ODB

When I import a historical player whose ID is in lowercase, everything is fine.

But when I import a historical player whose ID IS ALL IN CAPS, no stats import. The name, birthday, height, etc, all works fine. But the only part I care about, namely their position and ratings, don't import.

I checked the batting/fielding/pitching DBs, and the players do have stats there. Is this a case of the players in question having so little data to track that OOTP makes them fictionalized?

I'd assume I did something wrong, except the lowercase folks are importing just fine.

Any help appreciated.

Rob
Trebro is offline   Reply With Quote
Old 05-31-2014, 02:45 PM   #2
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
I can decap player ID's easily enough. They might have changed something in OOTP15. I just put a new version of the db out a few minutes ago. It still has caps of course. I'll try to get a decapitated version uploaded Sunday.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 05-31-2014, 03:26 PM   #3
Trebro
All Star Reserve
 
Join Date: Mar 2013
Posts: 753
Quote:
Originally Posted by Spritze View Post
I can decap player ID's easily enough. They might have changed something in OOTP15. I just put a new version of the db out a few minutes ago. It still has caps of course. I'll try to get a decapitated version uploaded Sunday.
Thanks! It's such a great addition to the game. Even if I only was able to use the names, it would have been a lot easier than creating the players myself.

Will the new version be in the same place you PMed me awhile back?
Trebro is offline   Reply With Quote
Old 05-31-2014, 04:15 PM   #4
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Same place. The issue is not caps it is that even though one picks neutered stats lots of stuff is pulled from the non-neutered stats. To fix this i just made both of the data sets the same. The new one on the ftp site has this change. Please post if this does fix the challenge.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 05-31-2014, 05:59 PM   #5
Carlton
Hall Of Famer
 
Carlton's Avatar
 
Join Date: Mar 2002
Posts: 3,765
They must be imported based on neutralized stats NOT real life stats

That is your issue, not the DB's

you can import the uppercase guys using lowercase in the import process as well.
__________________

"I am at that stage of my life where I keep myself out of arguments. I am 100% self sufficient spiritually, emotionally & financially. Even if you say 1+1=5, you are ABSOLUTELY CORRECT. Enjoy!"
Carlton is offline   Reply With Quote
Old 05-31-2014, 08:27 PM   #6
Trebro
All Star Reserve
 
Join Date: Mar 2013
Posts: 753
Quote:
Originally Posted by Spritze View Post
Same place. The issue is not caps it is that even though one picks neutered stats lots of stuff is pulled from the non-neutered stats. To fix this i just made both of the data sets the same. The new one on the ftp site has this change. Please post if this does fix the challenge.
Unfortunately, it does not. I tried Bud Fowler, Sol White, Grant Johnson, and Benjamin Boyd, all players that didn't work for me before, and they still didn't work. I even tried different import years, taking out the player adjustments for low ab/ip, etc but got same result from the 5/31 down.

But lower-case Frank Grant imported just fine.

Note to Carlton: I though of that, tried it both ways, no dice, that's why I went to the forums.

This effects a very small batch of players, even when just working with the Negro league guys, so even if I only get their names and have to guess at stats, it's still better than nothing. Just really strange.
Trebro is offline   Reply With Quote
Old 06-01-2014, 09:29 AM   #7
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
The Spritze HS Database has been decapitated and is available in the usual place.

Please let me know if this works more betterer.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 06-01-2014, 01:18 PM   #8
bobcat
Bat Boy
 
Join Date: Jul 2002
Posts: 7
Can someone please give me the site where I can download the Database.

Thanks
bobcat is offline   Reply With Quote
Old 06-01-2014, 01:42 PM   #9
txranger
Hall Of Famer
 
txranger's Avatar
 
Join Date: Dec 2008
Location: "Deep in the Heart Of"
Posts: 8,324
Send a PM to Spritze
__________________
https://drive.google.com/drive/folders/0BxdZAtwhTM3_ZUZHQlVqZGpYM0k?resourcekey=0-H3gEmEfFFsfLLEGvioYC2Q&usp=sharing








txranger is offline   Reply With Quote
Old 06-01-2014, 05:05 PM   #10
Trebro
All Star Reserve
 
Join Date: Mar 2013
Posts: 753
Quote:
Originally Posted by Spritze View Post
The Spritze HS Database has been decapitated and is available in the usual place.

Please let me know if this works more betterer.
Mr. Fowler is in his proper home at second base, with all stats imported.

Thanks for the help, and the amazing database!
Trebro 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 02:22 PM.

 

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 - 2025, vBulletin Solutions, Inc.
Copyright © 2024 Out of the Park Developments