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
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 06-19-2013, 09:17 PM   #241
soadeathdealer
Hall Of Famer
 
soadeathdealer's Avatar
 
Join Date: Nov 2009
Location: VA
Posts: 2,144
I have a suggestion for the next version . widgets so that we can put the standings on say wp or any other website and it update automatically. and also widgets that can be put on pages and they show news feed from the ootp thu the csv files that is used in ootpou .
__________________
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 06-26-2013, 04:39 PM   #242
EKomrska15
All Star Starter
 
Join Date: Mar 2007
Posts: 1,522
When setting up it asks for rating scale, talent scale and so on. You options of ratings or scouted....

If the league uses scouts what should we choose? We use ratings 1-20

Also, we are using an inaugural draft in my other new league I'm putting together. During the draft will teams be seeing their scouts ratings or OSA's rating?
EKomrska15 is offline   Reply With Quote
Old 06-29-2013, 03:24 PM   #243
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by EKomrska15 View Post
When setting up it asks for rating scale, talent scale and so on. You options of ratings or scouted....

If the league uses scouts what should we choose? We use ratings 1-20

Also, we are using an inaugural draft in my other new league I'm putting together. During the draft will teams be seeing their scouts ratings or OSA's rating?
New in OOTP 14 is the ability to export the csv files using the OSA ratings, which works well for scouted leagues. In the CSV setup in OOTP, you should be able to switch from true ratings to OSA ratings. Set it to OSA ratings and use the 1-20 scale in OU, and you should be good to go.
__________________
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 06-29-2013, 05:28 PM   #244
soadeathdealer
Hall Of Famer
 
soadeathdealer's Avatar
 
Join Date: Nov 2009
Location: VA
Posts: 2,144
Re: Online Utilities (OU) for OOTP 13

Getch u ever add to ootpou the ablity as admin to hit complete draft and it finishes the draft based on the gm settings? I.e. auto,use list and so on? I just setup the draft in ootpou and will start it next Monday so wanted to know

Sent from my ADR6350 using Tapatalk 2
__________________
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 07-09-2013, 08:41 PM   #245
molarmite
Hall Of Famer
 
molarmite's Avatar
 
Join Date: Jul 2005
Location: Minnesota
Posts: 4,914
Blog Entries: 1
My utilities, Sim Results, dont have the design on the top or on some pages. My server and reports set up in the admin page appear to be correct. I can still access my reports from the utility. Any idea?
__________________
From the wise mind of Davey Eckstein

"Now all you need is a signature. A quote or initial, perhaps."


[
molarmite is offline   Reply With Quote
Old 07-13-2013, 11:05 PM   #246
GMGOD
Minors (Triple A)
 
GMGOD's Avatar
 
Join Date: Oct 2005
Posts: 218
Infractions: 0/1 (1)
One quick question.

I got my computer back and went into FileZilla to upload my CSV files for OOTPOU and they aren't saved as CSV files now they are saved as spreadsheet in an overwritten or updated installation as OpenOffice.org.spreadsheets.

Is there a way to get these back to recognizing the CSV dump as just CSV files?

See attachment.

Any advice is very appreciated as I am setting back up.

Thanks man.
__________________
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!

Last edited by GMGOD; 06-24-2014 at 03:27 AM.
GMGOD is offline   Reply With Quote
Old 07-15-2013, 05:48 PM   #247
EKomrska15
All Star Starter
 
Join Date: Mar 2007
Posts: 1,522
Here is my league setup...Ran 100 year for history purposes

Released all players into free agency and scheduled free agency draft

I exported the csv and placed properly. However, it's not pulling the players in the free agency at all.

I wonder if the underlying issue is that initially there were players that did not sign with their teams from the previous years draft and were showing in a draft pool. I have since deleted the players and now they don't show up anymore in the draft players on the utility like they were before.

Any help....Can we use this utility for the free agent draft?

Last edited by EKomrska15; 07-15-2013 at 06:56 PM.
EKomrska15 is offline   Reply With Quote
Old 07-15-2013, 09:06 PM   #248
soadeathdealer
Hall Of Famer
 
soadeathdealer's Avatar
 
Join Date: Nov 2009
Location: VA
Posts: 2,144
Re: Online Utilities (OU) for OOTP 13

Quote:
Originally Posted by GMGOD View Post
One quick question.

I got my computer back and went into FileZilla to upload my CSV files for OOTPOU and they aren't saved as CSV files now they are saved as spreadsheet in an overwritten or updated installation as OpenOffice.org.spreadsheets.

Is there a way to get these back to recognizing the CSV dump as just CSV files?

See attachment.

Any advice is very appreciated as I am setting back up.

Thanks man.
Yes there is but u don't really need to unless ur opening them up . They ate in correct format but u opened it up with OpenOffice once and made OpenOffice the defualt for opening that type of document. Right click on the file and open with then select office Excel and check the make default check box then Ull be able to open it up as normal. I think that u.may not have Microsoft office Excel and that's y OpenOffice is default. U can still ftp the files to ootpou and use them with no issue .

Sent from my ADR6350 using Tapatalk 2
__________________
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 07-15-2013, 09:07 PM   #249
soadeathdealer
Hall Of Famer
 
soadeathdealer's Avatar
 
Join Date: Nov 2009
Location: VA
Posts: 2,144
Re: Online Utilities (OU) for OOTP 13

Quote:
Originally Posted by GMGOD View Post
One quick question.

I got my computer back and went into FileZilla to upload my CSV files for OOTPOU and they aren't saved as CSV files now they are saved as spreadsheet in an overwritten or updated installation as OpenOffice.org.spreadsheets.

Is there a way to get these back to recognizing the CSV dump as just CSV files?

See attachment.

Any advice is very appreciated as I am setting back up.

Thanks man.
Also try and use coffecup free ftp it is so much better to use and u wont have as many problems

Sent from my ADR6350 using Tapatalk 2
__________________
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 07-18-2013, 03:52 PM   #250
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by molarmite View Post
My utilities, Sim Results, dont have the design on the top or on some pages. My server and reports set up in the admin page appear to be correct. I can still access my reports from the utility. Any idea?
Sorry, missed this one (the rest I have talked to through PM).

The background image cannot be found:

http://vmlb.org/OOTPOU/images/report_header.jpg

This should be copied over when you run "Generate UI Files" from the Admin tab.
__________________
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 07-22-2013, 12:02 PM   #251
molarmite
Hall Of Famer
 
molarmite's Avatar
 
Join Date: Jul 2005
Location: Minnesota
Posts: 4,914
Blog Entries: 1
Quote:
Originally Posted by Getch View Post
Sorry, missed this one (the rest I have talked to through PM).

The background image cannot be found:

http://vmlb.org/OOTPOU/images/report_header.jpg

This should be copied over when you run "Generate UI Files" from the Admin tab.
Thank you.
__________________
From the wise mind of Davey Eckstein

"Now all you need is a signature. A quote or initial, perhaps."


[
molarmite is offline   Reply With Quote
Old 07-22-2013, 06:57 PM   #252
Jax Powers
Minors (Double A)
 
Join Date: Oct 2011
Posts: 141
d

IS there anyway to retrieve your password to log into the utilities, as commish this is a little embarrasing.
Jax Powers is offline   Reply With Quote
Old 08-02-2013, 05:00 PM   #253
EKomrska15
All Star Starter
 
Join Date: Mar 2007
Posts: 1,522
So we finished our free agent draft....

Now I want to load the amateur draft (game date is April 4th) draft is scheduled for June 5th. For some reason though it's not pulling the ammy guys it's pulling from the same list of players that were previously eligible for the draft...

What am I doing wrong?
EKomrska15 is offline   Reply With Quote
Old 08-06-2013, 09:09 AM   #254
EKomrska15
All Star Starter
 
Join Date: Mar 2007
Posts: 1,522
Quote:
Originally Posted by EKomrska15 View Post
So we finished our free agent draft....

Now I want to load the amateur draft (game date is April 4th) draft is scheduled for June 5th. For some reason though it's not pulling the ammy guys it's pulling from the same list of players that were previously eligible for the draft...

What am I doing wrong?
Nevermind I remembered I had to go into the draftutil.pm and change a setting.
EKomrska15 is offline   Reply With Quote
Old 08-07-2013, 10:03 AM   #255
Syxx34
All Star Reserve
 
Join Date: Jun 2006
Location: Coral Springs
Posts: 937
getch...i made a post outside of this but figure to add it here too

1) Is there a skin to match the ootp14 reports?



EDIT: Figured/fixed the problem

Last edited by Syxx34; 08-07-2013 at 10:41 AM.
Syxx34 is offline   Reply With Quote
Old 08-13-2013, 10:13 AM   #256
bwyant32
Major Leagues
 
bwyant32's Avatar
 
Join Date: Dec 2008
Location: Erie, PA
Posts: 309
Having tons of trouble with the LiveSim module. I've tried everything and the utility is not picking up any games. I've put logs into the cgi-bin/OOTPOU/liveSim/100 folder, I've uploaded game logs to the lgreports2 subfolder I created (because I use mysql for reports), I've tried it all. Anyone know any tricks or have detailed instructions on how to set this up?
__________________
Commish - Federal Sim League
bwyant32 is offline   Reply With Quote
Old 08-13-2013, 10:53 AM   #257
EKomrska15
All Star Starter
 
Join Date: Mar 2007
Posts: 1,522
Quote:
Originally Posted by bwyant32 View Post
Having tons of trouble with the LiveSim module. I've tried everything and the utility is not picking up any games. I've put logs into the cgi-bin/OOTPOU/liveSim/100 folder, I've uploaded game logs to the lgreports2 subfolder I created (because I use mysql for reports), I've tried it all. Anyone know any tricks or have detailed instructions on how to set this up?
I wish I could help. The read me section for that is down so I've never been able to get mine ready to even try.
EKomrska15 is offline   Reply With Quote
Old 08-16-2013, 01:57 AM   #258
Robmb
Bat Boy
 
Join Date: Sep 2010
Posts: 14
I can't seem to get the HTML development links to generate. The browser just times out. The generate development step, which I run first, finishes successfully. Any suggestions?
Robmb is offline   Reply With Quote
Old 08-16-2013, 07:43 AM   #259
EKomrska15
All Star Starter
 
Join Date: Mar 2007
Posts: 1,522
Quote:
Originally Posted by Robmb View Post
I can't seem to get the HTML development links to generate. The browser just times out. The generate development step, which I run first, finishes successfully. Any suggestions?
I once asked Getch the same question this is what he said

"Probably hitting a memory limit on the process. League got big enough that it took too much memory.

Any way to increase the memory? More and more people are hitting this so at some point I need to rewrite the dev utility to save on memory. Just loathing that day..."

Last edited by EKomrska15; 08-16-2013 at 07:49 AM.
EKomrska15 is offline   Reply With Quote
Old 08-16-2013, 09:42 AM   #260
Robmb
Bat Boy
 
Join Date: Sep 2010
Posts: 14
I understand. Thank you for your reply.
Robmb 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 03:36 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