Home | Webstore
Latest News: OOTP 26 Available - FHM 11 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 08-18-2014, 09:14 PM   #341
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Yeah, I noticed this in one of my OOTP 15 leagues. Highlights work, but the team is listed incorrectly. Seemed to start happening after one of the OOTP patches. I'll look into it.
__________________
Get the OOTP Online Utilities for online leagues!
Includes Gamecast, Development, Live Sims, Voting and more.
Check here for more details
Getch is offline   Reply With Quote
Old 08-23-2014, 12:27 PM   #342
MBarrett
All Star Reserve
 
MBarrett's Avatar
 
Join Date: Oct 2012
Location: Canada
Posts: 627
Hey Getch, our league could use some help. Our Draft isn't working properly, I exported and then uploaded both the draft.csv and draft_eligible_players.csv files to the OOTPOU/draft/2015/100 folder within our cgi-bin folder. The order is all set properly, but for some reason not all of the eligible players are showing up. Out of 400+ players in the file, only 16 are displaying in OOTPOU.

Any ideas/suggestions?
Login

Mike
MBarrett is offline   Reply With Quote
Old 08-23-2014, 01:42 PM   #343
Painmantle
Hall Of Famer
 
Painmantle's Avatar
 
Join Date: Apr 2006
Location: Greenfield ,IN
Posts: 3,053
Quote:
Originally Posted by MBarrett View Post
Hey Getch, our league could use some help. Our Draft isn't working properly, I exported and then uploaded both the draft.csv and draft_eligible_players.csv files to the OOTPOU/draft/2015/100 folder within our cgi-bin folder. The order is all set properly, but for some reason not all of the eligible players are showing up. Out of 400+ players in the file, only 16 are displaying in OOTPOU.

Any ideas/suggestions?
Login

Mike

When I had an issue like this I had to check the settings on the Admin page of the draft in the utilities. In the box Titled "Players shown" it should be a number higher than the total players in your draft. After making changes to the draft settings remember to click the save icon so they stick!
__________________
“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
Painmantle is offline   Reply With Quote
Old 08-23-2014, 06:51 PM   #344
MBarrett
All Star Reserve
 
MBarrett's Avatar
 
Join Date: Oct 2012
Location: Canada
Posts: 627
Quote:
Originally Posted by Painmantle View Post
When I had an issue like this I had to check the settings on the Admin page of the draft in the utilities. In the box Titled "Players shown" it should be a number higher than the total players in your draft. After making changes to the draft settings remember to click the save icon so they stick!
Tried that thanks. Still doesn't show any more players.
MBarrett is offline   Reply With Quote
Old 08-26-2014, 03:08 PM   #345
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by MBarrett View Post
Tried that thanks. Still doesn't show any more players.
This is probably because OOTP is splitting up your players.csv file into players1.csv, players2.csv. A bunch of leagues had this issue.

First, make sure that the "Split Large Files" is not checked in the CSV export configurations in OOTP. If that is not the case, you are probably hitting the OOTP issue with upgraded leagues:

http://www.ootpdevelopments.com/boar...-question.html

I think the fix is to delete the settings file which is located in the /settings folder (db_dump_... .cfg). Then define the settings again in OOTP. At least this is what someone told me fixed it.
__________________
Get the OOTP Online Utilities for online leagues!
Includes Gamecast, Development, Live Sims, Voting and more.
Check here for more details
Getch is offline   Reply With Quote
Old 08-27-2014, 12:28 PM   #346
MBarrett
All Star Reserve
 
MBarrett's Avatar
 
Join Date: Oct 2012
Location: Canada
Posts: 627
Quote:
Originally Posted by Getch View Post
This is probably because OOTP is splitting up your players.csv file into players1.csv, players2.csv. A bunch of leagues had this issue.

First, make sure that the "Split Large Files" is not checked in the CSV export configurations in OOTP. If that is not the case, you are probably hitting the OOTP issue with upgraded leagues:

http://www.ootpdevelopments.com/boar...-question.html

I think the fix is to delete the settings file which is located in the /settings folder (db_dump_... .cfg). Then define the settings again in OOTP. At least this is what someone told me fixed it.
Did this and unfortunately it didn't work. We're still only getting a handful of players displaying, and now none of their ratings are showing either.

We did just switch to the games new Feeder system for this draft, could that possibly have something to do with it?

Last edited by MBarrett; 08-27-2014 at 12:30 PM.
MBarrett is offline   Reply With Quote
Old 08-27-2014, 07:02 PM   #347
soadeathdealer
Hall Of Famer
 
soadeathdealer's Avatar
 
Join Date: Nov 2009
Location: VA
Posts: 2,144
Getch quick question for you and I know you have answered this before but there is just way to many pages to find it .

I have a commish that is using me for hosting and so i set up ootpou among other things for him . But his issue is that in ootpou there are players in the draft that are not in the draft in game so i am assuming its either an age thing or hidden players thing in game but i cant exactly remember . But i know that he said he does not have feeder league as wondering if you could highlight a solution or at least direct me in the right direction . thanks
__________________
Jerseys and caps/logos and more
http://s39.photobucket.com/albums/e1...%20and%20caps/


Leagues

OOTP

POTD: Vermont/Co-Commish
MTBL: League Closed
The Show: Jacksonville Bombers
RFTP : Braves/co-commish: League Closed
HRBL: Commish: League Closed

DDSPF

WWPF- Miami

CSFL- Tampa

USFL: New Orleans

DDSCF

SNCFL: Florida/ JMU
soadeathdealer is offline   Reply With Quote
Old 08-27-2014, 10:59 PM   #348
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by MBarrett View Post
Did this and unfortunately it didn't work. We're still only getting a handful of players displaying, and now none of their ratings are showing either.

We did just switch to the games new Feeder system for this draft, could that possibly have something to do with it?
Ratings may be because you have the "hide ratings" option in the CSV export setup. If you use scouts, set it to OSA ratings, otherwise make it set to true ratings.

Make sure you have the OOTP 15 version if you use feeder leagues, otherwise not all players show up.
__________________
Get the OOTP Online Utilities for online leagues!
Includes Gamecast, Development, Live Sims, Voting and more.
Check here for more details
Getch is offline   Reply With Quote
Old 08-27-2014, 11:00 PM   #349
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by soadeathdealer View Post
Getch quick question for you and I know you have answered this before but there is just way to many pages to find it .

I have a commish that is using me for hosting and so i set up ootpou among other things for him . But his issue is that in ootpou there are players in the draft that are not in the draft in game so i am assuming its either an age thing or hidden players thing in game but i cant exactly remember . But i know that he said he does not have feeder league as wondering if you could highlight a solution or at least direct me in the right direction . thanks
The feeder age limit thing changed it seems with the new options for feeder league draft eligibility. Try changing the ages limits to be one higher or lower in OU Draft Admin screen until they match. That's what I had to do in my league.
__________________
Get the OOTP Online Utilities for online leagues!
Includes Gamecast, Development, Live Sims, Voting and more.
Check here for more details
Getch is offline   Reply With Quote
Old 08-27-2014, 11:07 PM   #350
soadeathdealer
Hall Of Famer
 
soadeathdealer's Avatar
 
Join Date: Nov 2009
Location: VA
Posts: 2,144
Quote:
Originally Posted by Getch View Post
The feeder age limit thing changed it seems with the new options for feeder league draft eligibility. Try changing the ages limits to be one higher or lower in OU Draft Admin screen until they match. That's what I had to do in my league.
you have to do that prior to the draft start right as I dont see the option after u import the draft.csv
__________________
Jerseys and caps/logos and more
http://s39.photobucket.com/albums/e1...%20and%20caps/


Leagues

OOTP

POTD: Vermont/Co-Commish
MTBL: League Closed
The Show: Jacksonville Bombers
RFTP : Braves/co-commish: League Closed
HRBL: Commish: League Closed

DDSPF

WWPF- Miami

CSFL- Tampa

USFL: New Orleans

DDSCF

SNCFL: Florida/ JMU
soadeathdealer is offline   Reply With Quote
Old 08-30-2014, 04:55 PM   #351
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by soadeathdealer View Post
you have to do that prior to the draft start right as I dont see the option after u import the draft.csv
If you have feeder leagues, there should be a Feeder Leagues section int the Draft Admin screen under the Draft Email section. Importing draft.csv only imports the draft order, but has no effect on the players in the draft pool.
__________________
Get the OOTP Online Utilities for online leagues!
Includes Gamecast, Development, Live Sims, Voting and more.
Check here for more details
Getch is offline   Reply With Quote
Old 08-30-2014, 05:00 PM   #352
soadeathdealer
Hall Of Famer
 
soadeathdealer's Avatar
 
Join Date: Nov 2009
Location: VA
Posts: 2,144
Quote:
Originally Posted by Getch View Post
If you have feeder leagues, there should be a Feeder Leagues section int the Draft Admin screen under the Draft Email section. Importing draft.csv only imports the draft order, but has no effect on the players in the draft pool.
yea but he doesn't have feeder leagues from what hes told me
__________________
Jerseys and caps/logos and more
http://s39.photobucket.com/albums/e1...%20and%20caps/


Leagues

OOTP

POTD: Vermont/Co-Commish
MTBL: League Closed
The Show: Jacksonville Bombers
RFTP : Braves/co-commish: League Closed
HRBL: Commish: League Closed

DDSPF

WWPF- Miami

CSFL- Tampa

USFL: New Orleans

DDSCF

SNCFL: Florida/ JMU
soadeathdealer is offline   Reply With Quote
Old 08-31-2014, 12:20 PM   #353
MBarrett
All Star Reserve
 
MBarrett's Avatar
 
Join Date: Oct 2012
Location: Canada
Posts: 627
Quote:
Originally Posted by Getch View Post
If you have feeder leagues, there should be a Feeder Leagues section int the Draft Admin screen under the Draft Email section. Importing draft.csv only imports the draft order, but has no effect on the players in the draft pool.
We're having a similar problem now, Utilities is displaying players that aren't in the in-game draft pool. It seems like it's grabbing all players from the Feeder leagues, regardless of them being included in this years draft.
MBarrett is offline   Reply With Quote
Old 09-01-2014, 09:43 PM   #354
soadeathdealer
Hall Of Famer
 
soadeathdealer's Avatar
 
Join Date: Nov 2009
Location: VA
Posts: 2,144
Quote:
Originally Posted by MBarrett View Post
We're having a similar problem now, Utilities is displaying players that aren't in the in-game draft pool. It seems like it's grabbing all players from the Feeder leagues, regardless of them being included in this years draft.

yea the guy doesnt have feeders but he has the international leagues.
__________________
Jerseys and caps/logos and more
http://s39.photobucket.com/albums/e1...%20and%20caps/


Leagues

OOTP

POTD: Vermont/Co-Commish
MTBL: League Closed
The Show: Jacksonville Bombers
RFTP : Braves/co-commish: League Closed
HRBL: Commish: League Closed

DDSPF

WWPF- Miami

CSFL- Tampa

USFL: New Orleans

DDSCF

SNCFL: Florida/ JMU
soadeathdealer is offline   Reply With Quote
Old 09-03-2014, 12:43 AM   #355
Greeney03
Minors (Triple A)
 
Greeney03's Avatar
 
Join Date: Apr 2010
Posts: 230
Quote:
Originally Posted by MBarrett View Post
We're having a similar problem now, Utilities is displaying players that aren't in the in-game draft pool. It seems like it's grabbing all players from the Feeder leagues, regardless of them being included in this years draft.
Same issue here. Changed age limit for college to 22 and HS to 19, but I'm still seeing a lot of 15-16 yrs old in the pool.
__________________
CBL Commissioner & GM of San Diego Surf Dawgs

Last edited by Greeney03; 09-03-2014 at 12:48 AM.
Greeney03 is offline   Reply With Quote
Old 09-05-2014, 11:19 AM   #356
Greeney03
Minors (Triple A)
 
Greeney03's Avatar
 
Join Date: Apr 2010
Posts: 230
Also, our season just ended, and for some reason I can't generate a list of players for end of season awards.
__________________
CBL Commissioner & GM of San Diego Surf Dawgs
Greeney03 is offline   Reply With Quote
Old 09-07-2014, 10:22 AM   #357
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Can one of you with the draft feeder league problem zip up your csv files and PM where I can download them? I'll take a look.

I am a commish of a league with feeder leagues and had no issue last year. We're a few days away from this year's draft so I'll look again.
__________________
Get the OOTP Online Utilities for online leagues!
Includes Gamecast, Development, Live Sims, Voting and more.
Check here for more details
Getch is offline   Reply With Quote
Old 09-09-2014, 06:13 PM   #358
soadeathdealer
Hall Of Famer
 
soadeathdealer's Avatar
 
Join Date: Nov 2009
Location: VA
Posts: 2,144
Quote:
Originally Posted by Getch View Post
Can one of you with the draft feeder league problem zip up your csv files and PM where I can download them? I'll take a look.

I am a commish of a league with feeder leagues and had no issue last year. We're a few days away from this year's draft so I'll look again.
I can try to tonight. I do know this that in game i can search for the player not in the game pool but in the ootpou pool and find them . I did find a possible file coruption well the game date i had was in the offseason so i searched a player not on the ingame pool but was on ootpou pool and i find him but when i clicked on him i got a different player . But when i updated my game date to the updated game date the player i searched was the player i searched. I was thinking that ootpou was grabing hidden players but not sure .
__________________
Jerseys and caps/logos and more
http://s39.photobucket.com/albums/e1...%20and%20caps/


Leagues

OOTP

POTD: Vermont/Co-Commish
MTBL: League Closed
The Show: Jacksonville Bombers
RFTP : Braves/co-commish: League Closed
HRBL: Commish: League Closed

DDSPF

WWPF- Miami

CSFL- Tampa

USFL: New Orleans

DDSCF

SNCFL: Florida/ JMU
soadeathdealer is offline   Reply With Quote
Old 09-16-2014, 10:04 AM   #359
Recte44
Global Moderator
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: Oconomowoc, WI
Posts: 2,805
VORP and WAR not showing in Awards/AS voting for pitchers anymore.
__________________
Matt Rectenwald
Commissioner, GM: Las Vegas Hustlers, The Brewster Baseball Association- fictional league (JOIN NOW)
Recte44 is offline   Reply With Quote
Old 09-16-2014, 10:09 AM   #360
Painmantle
Hall Of Famer
 
Painmantle's Avatar
 
Join Date: Apr 2006
Location: Greenfield ,IN
Posts: 3,053
Quote:
Originally Posted by Painmantle View Post
When using ootpou15 the replays and highlights did NOT work, after reverting back to ootpou14 the issue with the teams was still there but the replays and highlights DID work


As we move to 1979 the last sim highlights and gamecast do not work at all. Everything else does what it is supposed to but those two produce nothing but the replay box, nothing ever happens
__________________
“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
Painmantle 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 08:14 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 - 2025, vBulletin Solutions, Inc.
Copyright © 2024 Out of the Park Developments