Home | Webstore
Latest News: OOTP Update 20.5.52 - OOTP 20 Available - FHM 5 Available

MLB All-Star Game Special: Save 50% on OOTP 20!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 20 > 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-03-2006, 01:47 AM   #21
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Thanks: 0
Thanked 79x in 45 posts
I discovered some logic problems. The program worked fine with young leagues, but with larger older leagues it was bogging down. It was the way I was reading in the data. I was basically looping through the file and when it came across the player, it would leave and go to the next. So, what was happening, the higher a player's ID, the longer it took to get the data.

So, I revamped it.

When you click on the CONTRACT button, it will go through the entire player list and load the player into memory, if he is still an active player. So, it no longer has to load the same file multiple times.

Very much quicker and gives me more flexibility. So, first I did the players file, which contains name, team, draft, etc. I picked out all the fields that were important. I converted the numbers to strings. So, instead of showing a 1 for right handed batter, it shows a R. I did a team lookup, so it will show the team ABR and team whole name. The team whole name will be loaded in as a tool tip I think.

So, I have about 20 categories from there. I will now do the players contracts. I am undecided on if I will just display his current salary or more information also, i.e. years on contract, etc.

Then I load in the stats. You will be able to pick CURRENT YEAR or LAST YEAR, or maybe even specify any year.

Then I lead in his ratings.

I may even put up some radio buttons to let you decide what group to load from. Maybe not load in his ratings, since you have that turned off.

The program evolved from a simple contract report to a full blown database.

I will allow you to save the data as a CSV file. This way, you could play with it in excel or you could also quickly load it back in.

One big thing about this program will be the CSV file it will create.

It will basically combine all the different files into one database. So you will not have to be an expert in Excel and link files together.

What I mean is that you can simply load in a normal CSV dump into excel. However, you get a very sloppy looking list. The field names are: player_name. I convert that field names while in my program. player_name becomes PlayerName; Position becomes POS.

Team is shown as the team ID. So, it will show a number for the team. You have to then look at the teams.cvs file and see what team is #1. I do that for you in the program.

With this program, you really do not need to use Excel, as you can sort by any field, up or down. I will add filters, so you can hide all players with less than a certain number of at bats or just show right handed hitters.

Later, print options will be available to print the data.

A lot of this can be done inside the OOTP program, but I plan to add much more. Like more stats, etc.

Since the concept of the program has changed, and my schedule is busy tomorrow, I won't have a new update for a couple of days. But you can use the current unfinished version for now.

Keep your eyes peeled to this section.
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
Comedian2004 is offline   Reply With Quote
Old 08-04-2006, 01:17 AM   #22
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Thanks: 0
Thanked 79x in 45 posts
CSV dump is now working.

Added several more fields to hitters and pitchers. Ratings come next.
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
Comedian2004 is offline   Reply With Quote
Old 08-04-2006, 04:47 PM   #23
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Thanks: 0
Thanked 79x in 45 posts
Added ratings and also team select. So, you can select just one team and have that team only listed in the grid. However, if you want to look at another team, you need to load the league again. (That will change)

Anyone try the new version?
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
Comedian2004 is offline   Reply With Quote
Old 08-04-2006, 04:51 PM   #24
pstrickert
Hall Of Famer
 
pstrickert's Avatar
 
Join Date: Dec 2005
Posts: 12,339
Thanks: 2,810
Thanked 3,616x in 2,017 posts
SUH-WEEEEEEEEEET!!!!!

This is shaping up to be a brilliant program!
pstrickert is offline   Reply With Quote
Old 08-05-2006, 11:14 PM   #25
Raidergoo
Hall Of Famer
 
Raidergoo's Avatar
 
Join Date: Mar 2003
Posts: 8,982
Thanks: 498
Thanked 596x in 305 posts
Um, wow!

10 seconds with MS Word and the CSV dump does exactly what I want. And about a billion times more.

This is a gem.
Raidergoo is offline   Reply With Quote
Old 08-28-2006, 05:07 PM   #26
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Thanks: 0
Thanked 79x in 45 posts
Solved the problem with the accented characters.. they now display correctly...

a simple "System.Text.Encoding.UTF7" had to be added.
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
Comedian2004 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 10:26 PM.

 

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