Home | Webstore
Latest News: FHM 5 Available - OOTP 19 Available! - MLB Manager 2018 Available Now

Perfect Team is LIVE!

  

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

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

Reply
 
Thread Tools
Old 06-30-2012, 08:10 PM   #61
Spindel
All Star Reserve
 
Spindel's Avatar
 
Join Date: Oct 2003
Location: Lambertville, NJ
Posts: 714
Thanks: 96
Thanked 305x in 137 posts
Here's a question. We're in the middle of our Ammy draft, and I've just added two new owners. How do I get them access to the draft? Last time I updated OU, it buggered up the draft. (We were only 3 picks in, so it wasn't a big deal at the time.) I just don't want to do something that will delete everyone's lists and picks again.
__________________
ULB - Commissioner, Owner of the Phoenix Fire
Home Page | Report | File | StatsLab | ULB on Twitter | ULB Forum

Simcentral.net

My MLB Uniforms
Spindel is offline   Reply With Quote
Old 07-01-2012, 11:02 AM   #62
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 866
Thanks: 1
Thanked 115x in 67 posts
Quote:
Originally Posted by Spindel View Post
Here's a question. We're in the middle of our Ammy draft, and I've just added two new owners. How do I get them access to the draft? Last time I updated OU, it buggered up the draft. (We were only 3 picks in, so it wasn't a big deal at the time.) I just don't want to do something that will delete everyone's lists and picks again.
It *shouldn't* cause any problems... picks are based off of teams, not human owners, so it should have no effect. However, if you want, feel free to zip up the OOTPOU/draft/<year> directory to back it up.

The source of truth is the picks.txt file for the draft. So if anything goes wrong (again, it shouldn't), you can manually edit/compare the old and new file to see what might have gone screwy. Adding a human manager wouldn't touch this file.

And as Tom said earlier, I'm on vacation but still have internet access... can't do any work on OU though. Tom's answers to the draft were correct, 19/22 for HS/Col leagues, and we'll hopefully get some sort of draft import working soon.
__________________
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-03-2012, 04:16 PM   #63
ingey1968
Minors (Rookie Ball)
 
ingey1968's Avatar
 
Join Date: Dec 2007
Posts: 41
Thanks: 2
Thanked 2x in 2 posts
Thanks

Last edited by ingey1968; 07-03-2012 at 04:47 PM.
ingey1968 is offline   Reply With Quote
Old 07-14-2012, 09:06 PM   #64
Tiesenberg
Minors (Triple A)
 
Join Date: Nov 2002
Posts: 283
Thanks: 9
Thanked 34x in 17 posts
This is my first time having setup and used the utilities for a league of my own and I seem to have run into a small hurdle that I can't seem to find the answer for.

I am using the utility for a solo league I am beginning in 2012 with the intent of creating realignment/expansion in 2013. I've simmed 25 days into the 2012 season and was hoping to take a look at the results of the sim.

I've updated the league reports and the csv files into what I am fairly certain (easily could be wrong) right places, yet when I try and generate the admin material for the "LAST SIM", nothing comes about. I get the following:

Last Update of Sim Report N/A
Current Time Sun Jul 15 01:03:09 2012
League Date of Sim Reports N/A
Current Date in CSV Files 2012-4-22

Similarly, within the development section, upon creating the reports I get the following:

Last Development Update Sun Jul 15 00:50:24 2012
Current Time Sun Jul 15 01:03:37 2012
League Date of Last Development 2012-4-22
Current Date in CSV Files 2012-4-22

With that also said, I see no developmental changes at this point. Is this likely a result of having scouting on but not having scouted due to the fact that I am not a GM? (Or possibly the fact that I'm a mere 25 days into the league?

Here's a link to the utilities:
Login

And a link to the league main page if that provides any help.

MLB 32


As an aside, I want say how great the installation guide/readme was. As someone with limited experience doing such web savy stuff, I find the guide to be extremely useful in getting most everything up and running.

Thanks,
-Matt
Tiesenberg is offline   Reply With Quote
Old 07-15-2012, 12:03 PM   #65
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 866
Thanks: 1
Thanked 115x in 67 posts
Quote:
Originally Posted by Tiesenberg View Post
I've updated the league reports and the csv files into what I am fairly certain (easily could be wrong) right places, yet when I try and generate the admin material for the "LAST SIM", nothing comes about.
You need to set the Sim Length in Days in the admin screen.

Quote:
With that also said, I see no developmental changes at this point. Is this likely a result of having scouting on but not having scouted due to the fact that I am not a GM? (Or possibly the fact that I'm a mere 25 days into the league?
Two things here. In general, the first time you run development you won't see any results, as it is creating a baseline report to compare all future sims against.

However, in your case, you are using scouts. OOTP doesn't export the scouting reports on players, so OU can't show development on scouted leagues. You can change OU to show actual values (look at the main Admin screen), but you'll then see actual values instead of scouted values, which probably isn't what you want.
__________________
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-15-2012, 01:01 PM   #66
Tiesenberg
Minors (Triple A)
 
Join Date: Nov 2002
Posts: 283
Thanks: 9
Thanked 34x in 17 posts
Quote:
Originally Posted by Getch View Post
You need to set the Sim Length in Days in the admin screen.
I had set the sim length - in this case to 25. Just re-checked admin panel and the settings are blank. I re-entered the numbers, clicked save and tried to generate the reports, same result. Also, after generating the report, my sim length boxes become blank again.


Quote:
Originally Posted by Getch View Post
Two things here. In general, the first time you run development you won't see any results, as it is creating a baseline report to compare all future sims against.

However, in your case, you are using scouts. OOTP doesn't export the scouting reports on players, so OU can't show development on scouted leagues. You can change OU to show actual values (look at the main Admin screen), but you'll then see actual values instead of scouted values, which probably isn't what you want.
In this case I need to then make a decision, use in-game scouting or turn that off and then be able to use the development reports properly?

Thanks again.
Tiesenberg is offline   Reply With Quote
Old 07-16-2012, 11:02 AM   #67
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 866
Thanks: 1
Thanked 115x in 67 posts
Quote:
Originally Posted by Tiesenberg View Post
I had set the sim length - in this case to 25. Just re-checked admin panel and the settings are blank. I re-entered the numbers, clicked save and tried to generate the reports, same result. Also, after generating the report, my sim length boxes become blank again.
Try manually creating the lastSim directory in OOTPOU (so "www/cgi-bin/OOTPOU/lastSim"). Looks like it wasn't created somehow.

Quote:
In this case I need to then make a decision, use in-game scouting or turn that off and then be able to use the development reports properly?
Pretty much. I've asked for scouting reports to be added as a csv dump, but my guess is that is too much for OOTP to support. I find using rough scales such as 1-10 and 2-8 simulate scouting enough to add that imprecision that scouting has.
__________________
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-18-2012, 12:34 PM   #68
Mr.Opinion
All Star Reserve
 
Mr.Opinion's Avatar
 
Join Date: May 2003
Location: SkiFree Lodge
Posts: 880
Thanks: 7
Thanked 28x in 17 posts
When adding email addresses to the distribution list for the ammy draft, do I use "john@doe.com, jane@doe.com", minus the quotes?
__________________
Mr.Opinion is offline   Reply With Quote
Old 07-18-2012, 03:42 PM   #69
Mr.Opinion
All Star Reserve
 
Mr.Opinion's Avatar
 
Join Date: May 2003
Location: SkiFree Lodge
Posts: 880
Thanks: 7
Thanked 28x in 17 posts
Quote:
Originally Posted by Getch View Post
However, in your case, you are using scouts. OOTP doesn't export the scouting reports on players, so OU can't show development on scouted leagues. You can change OU to show actual values (look at the main Admin screen), but you'll then see actual values instead of scouted values, which probably isn't what you want.

Actually, a bigger question here. We are a scouted league, so that makes us not be able to use the ratings in the ammy draft. So, by turning off the ratings, the player list is a total mess. Is there any way to make it so that the list gets alphabetized for finding players easier? Right now a 'find' will work mostly, but OOTPOU also has some issues with 'non-english' names, making it hard to find those with ~ and such over the names.

EDIT: NEVER MIND. I figured it out!
__________________

Last edited by Mr.Opinion; 07-18-2012 at 03:46 PM.
Mr.Opinion is offline   Reply With Quote
Old 07-19-2012, 10:38 AM   #70
BleedingCubbyBlue
All Star Reserve
 
BleedingCubbyBlue's Avatar
 
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 601
Thanks: 5
Thanked 1x in 1 post
Quote:
Originally Posted by Mr.Opinion View Post
When adding email addresses to the distribution list for the ammy draft, do I use "john@doe.com, jane@doe.com", minus the quotes?
Admittedly I haven't tried in the current version, but in previous versions you had to send to a distribution list. I send them to an email on my server which has a rule set to forward to all our league members.

If it works now to have the list that would be great.
__________________

BleedingCubbyBlue is offline   Reply With Quote
Old 07-19-2012, 01:46 PM   #71
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 866
Thanks: 1
Thanked 115x in 67 posts
Quote:
Originally Posted by Mr.Opinion View Post
but OOTPOU also has some issues with 'non-english' names, making it hard to find those with ~ and such over the names.
You need to set the option to "Replace Foreign Characters" in the CSV Export setup screen in OOTP.

Quote:
Admittedly I haven't tried in the current version, but in previous versions you had to send to a distribution list. I send them to an email on my server which has a rule set to forward to all our league members.
Still works the same way... you need to set up a distribution list. Entering a list of emails won't work.
__________________
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-21-2012, 05:00 AM   #72
mankle
Minors (Double A)
 
Join Date: Jun 2011
Posts: 121
Thanks: 12
Thanked 24x in 15 posts
I'd also like to inquire about ratings for scouting leagues. I found that when I turn ratings on a particular scale (rather than "scouted"), players on my own team would be displayed with their scouted ratings, but players in the amateur draft pool would be listed at their actual (neither a team scout or the OSA) ratings.

is there a way to see scouted or OSA ratings of the players in the draft pool? or is that just not possible now?
__________________
ASBA - Commissioner, GM California Angels
mankle is offline   Reply With Quote
Old 07-21-2012, 12:08 PM   #73
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 866
Thanks: 1
Thanked 115x in 67 posts
Quote:
Originally Posted by mankle View Post
I'd also like to inquire about ratings for scouting leagues. I found that when I turn ratings on a particular scale (rather than "scouted"), players on my own team would be displayed with their scouted ratings, but players in the amateur draft pool would be listed at their actual (neither a team scout or the OSA) ratings.

is there a way to see scouted or OSA ratings of the players in the draft pool? or is that just not possible now?
Not possible, as the csv dumps only contain the true values. We've asked for an enhancement to support it.

FYI, the values you see are the true values, so it sounds like your scouts are spot on for your team.
__________________
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-21-2012, 01:18 PM   #74
mankle
Minors (Double A)
 
Join Date: Jun 2011
Posts: 121
Thanks: 12
Thanked 24x in 15 posts
Quote:
Originally Posted by Getch View Post
Not possible, as the csv dumps only contain the true values. We've asked for an enhancement to support it.

FYI, the values you see are the true values, so it sounds like your scouts are spot on for your team.
Ah crap. Ok, thanks Getch!
__________________
ASBA - Commissioner, GM California Angels
mankle is offline   Reply With Quote
Old 07-24-2012, 04:48 PM   #75
MEspo
Bat Boy
 
Join Date: May 2004
Posts: 13
Thanks: 0
Thanked 0x in 0 posts
I'm trying to set up a manual draft. I click generate, but the panel on the left still says draft not generated. Any help would be appreciated.
MEspo is offline   Reply With Quote
Old 07-24-2012, 11:25 PM   #76
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 866
Thanks: 1
Thanked 115x in 67 posts
Quote:
Originally Posted by MEspo View Post
I'm trying to set up a manual draft. I click generate, but the panel on the left still says draft not generated. Any help would be appreciated.
There's two Generate buttons, one that uses the draft.csv import, and one that uses the manual draft order. If you are doing the manual draft order, click the Generate below the area that sets the order.
__________________
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-25-2012, 12:27 AM   #77
MEspo
Bat Boy
 
Join Date: May 2004
Posts: 13
Thanks: 0
Thanked 0x in 0 posts
Quote:
Originally Posted by Getch View Post
There's two Generate buttons, one that uses the draft.csv import, and one that uses the manual draft order. If you are doing the manual draft order, click the Generate below the area that sets the order.
Yeah, I tried that and it shows if the teams are human or computer controlled, but still says the draft not generated.
MEspo is offline   Reply With Quote
Old 07-25-2012, 12:02 PM   #78
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 866
Thanks: 1
Thanked 115x in 67 posts
Quote:
Originally Posted by MEspo View Post
Yeah, I tried that and it shows if the teams are human or computer controlled, but still says the draft not generated.
Did you set the number of rounds?
__________________
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-25-2012, 12:16 PM   #79
mankle
Minors (Double A)
 
Join Date: Jun 2011
Posts: 121
Thanks: 12
Thanked 24x in 15 posts
Hey Getch,

Trying to set up the amateur draft.... I set up the order list in a .txt file the way it says in the older Readme and uploaded to the proper folder, but when I set up the # of rounds, and click generate, it says: Error: Could not find file OOTPOU/draft/2014/100/draft.csv

How do i fix this?

EDIT: Never mind... figured it out. I edited the .csv files.
__________________
ASBA - Commissioner, GM California Angels

Last edited by mankle; 07-25-2012 at 12:41 PM.
mankle is offline   Reply With Quote
Old 07-26-2012, 11:11 AM   #80
Mr.Opinion
All Star Reserve
 
Mr.Opinion's Avatar
 
Join Date: May 2003
Location: SkiFree Lodge
Posts: 880
Thanks: 7
Thanked 28x in 17 posts
Quote:
Originally Posted by Getch View Post
You need to set the option to "Replace Foreign Characters" in the CSV Export setup screen in OOTP.



Still works the same way... you need to set up a distribution list. Entering a list of emails won't work.
I don't know what to say, but a list of email addresses is working in my league. Just as an FYI.
__________________
Mr.Opinion 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 05:29 AM.

 

Major League Baseball trademarks and copyrights are used with permission of MLB Advanced Media, L.P. Minor League Baseball trademarks and copyrights are used with the permission of Minor League Baseball. All rights reserved.

The Major League Baseball Players Association (www.MLBPLAYERS.com ) is the collective bargaining representative for all professional baseball players of the thirty Major League Baseball teams and serves as the exclusive group licensing agent for commercial and licensing activities involving active Major League baseball players. On behalf of its members, it operates the Players Choice licensing program and the Players Choice Awards, which benefit the needy through the Major League Baseball Players Trust, a charitable foundation established and run entirely by Major League baseball players. Follow: @MLB_Players; @MLBPAClubhouse; @MLBPlayersTrust

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 © 2017 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

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