Home | Webstore
Latest News: OOTP 25 Available - FHM 10 Available - OOTP Go! Available

Out of the Park Baseball 25 Buy Now!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 25 > 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 10-29-2006, 03:55 PM   #61
Kaitiaki
Hall Of Famer
 
Kaitiaki's Avatar
 
Join Date: Mar 2002
Location: Ontario, Canada
Posts: 2,065
E-mailed to your webcomedian at yahoo address. Thanks for any help you can offer.

- Kai
__________________
BJHL: Commissioner; Owner: Wichita War Eagles
Kaitiaki is offline   Reply With Quote
Old 10-29-2006, 04:20 PM   #62
Kaitiaki
Hall Of Famer
 
Kaitiaki's Avatar
 
Join Date: Mar 2002
Location: Ontario, Canada
Posts: 2,065
Actually, got an error on the e-mail, saying it couldn't be delivered because it was too large.

I've uploaded the file to our website for you to download directly, if you wouldn't mind.

- Kai
__________________
BJHL: Commissioner; Owner: Wichita War Eagles
Kaitiaki is offline   Reply With Quote
Old 10-29-2006, 07:15 PM   #63
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
OK, got it, and will look at it when I have a chance.
__________________
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 10-30-2006, 12:54 PM   #64
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Ok, I found the problem right away. It was coming across this bit of history in a players log.

Traded from Port Royal to 133770\/\/|\| on 7/11/2008 (Going to 137: SS Tony Romano, P Gary Barcia. Going to PR: 3B Antonio Nieves).

The \ in the 'team' name was throwing my parsing of the date off. So, I added a line to strip the \/\/|\| out before it parsed and it ran all the way through with no interruptions.

Make sure you run AUHistory2 on the new league when done. Use the REMOVE DUPLICATE function, as it will also fix any bad dates that were imported. And make sure you run BULK CHANGES at the end of the year (or anytime during the season, dupes are not added), to add walk off homeruns and player hitting/rbi/etc. streaks.
__________________
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 10-30-2006, 03:03 PM   #65
Kaitiaki
Hall Of Famer
 
Kaitiaki's Avatar
 
Join Date: Mar 2002
Location: Ontario, Canada
Posts: 2,065
Ha! I love it. I absolutely hated that team name, and we gave the guy who came up with it no end of good-natured misery. He's since left the league, but he's gonna get more now, anyway.

Thanks a ton for the correction, Comedian. Much obliged. And I already have AUHistory2 installed for just such uses. OOTP2006 wouldn't be the same without you.

- Kai
__________________
BJHL: Commissioner; Owner: Wichita War Eagles
Kaitiaki is offline   Reply With Quote
Old 10-30-2006, 05:20 PM   #66
Kaitiaki
Hall Of Famer
 
Kaitiaki's Avatar
 
Join Date: Mar 2002
Location: Ontario, Canada
Posts: 2,065
Hmm. I hate to be a pest, but now that I'm home and tried it again (the program very nicely updates itself ), it still isn't working.

Having been given an idea what was causing the problem from your previous post, I had a batch editor go through every file in the league_news_box\players folder and replace every instance of "133770\/\/|\|" with "Leettown", and it still didn't work.

I was able to deduce, as well, that the first error it throws up every time I try is in the very first file. In p1.txt, it's complaining that 6/27/2013 is an invalid date. This is the entirety of that file:

Code:
Drafted in 3rd round, 58th overall pick, by Boston in 2012...
Injured on 9/6/2012 with a Pinched Nerve Neck, out for 6 days...
Injured on 6/27/2013 with a Inflamed Hip Muscle, out for 6 days...
Injured on 9/4/2013 with a Bruised Finger, out for 4 days...
Injured on 5/5/2014 with a Inflamed Groin Muscle, out for one week...
Had first career hit (double) on 7/29/2015, off Dave Monte (DUR)...
Hit first career homerun on 9/27/2015, off David Koski (ATH)...
There's absolutely nothing in there about the problem franchise. In fact, that franchise ceased to exist three years before the guy was even drafted.

I have to think I'm doing something obvious wrong, since you said it worked flawlessly for you yesterday, but I'm at a loss as to what it is. Any other ideas for me? Pretty please?

- Kai
__________________
BJHL: Commissioner; Owner: Wichita War Eagles
Kaitiaki is offline   Reply With Quote
Old 10-30-2006, 07:43 PM   #67
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Very odd. I just ran it again and it went through the entire league with no bad date popups. I even trapped it on user one and stepped through it and it converted it fine. He is ID 447 in the new version:

20120518 Drafted in 3rd round, 58th overall pick, by Boston in 2012.
20120906 Injured on 9/6/2012 with a Pinched Nerve Neck, out for 6 days.
20130627 Injured on 6/27/2013 with a Inflamed Hip Muscle, out for 6 days.
20130904 Injured on 9/4/2013 with a Bruised Finger, out for 4 days.
20140505 Injured on 5/5/2014 with a Inflamed Groin Muscle, out for one week.
20150729 Had first career hit (double) on 7/29/2015, off Dave Monte (DUR).
20150927 Hit first career homerun on 9/27/2015, off David Koski (ATH).

www.planetootp.com/players.zip is where you can download the converted player history.

C:\Program Files\Sports Interactive\OOTP Baseball 2006\data\saved_games\History.lg\news\txt\players

Change to your league.

NOTE: I did not run the duplicate checker on it.
__________________
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 10-31-2006, 12:46 AM   #68
Kaitiaki
Hall Of Famer
 
Kaitiaki's Avatar
 
Join Date: Mar 2002
Location: Ontario, Canada
Posts: 2,065
Quote:
Originally Posted by Comedian2004 View Post
www.planetootp.com/players.zip is where you can download the converted player history.
Once again, much obliged. I have no idea why the conversion itself doesn't want to cooperate, but the .zip file does the trick nicely.

I promise I don't have any more leagues to convert, so I won't pester you again.

If you're ever in southern Ontario, I owe you a beer.

- Kai
__________________
BJHL: Commissioner; Owner: Wichita War Eagles
Kaitiaki is offline   Reply With Quote
Old 11-01-2006, 10:51 AM   #69
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Well, I spent a month in Toronto during the winter, so I won't be there. But, if you are ever in Orlando, look me up and buy me lunch.

I know it sure is nice to have that old history back. Does it look like yours converted over pretty well?
__________________
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 11-02-2006, 12:01 PM   #70
D Love
All Star Reserve
 
Join Date: Mar 2002
Location: Queens, NY
Posts: 908
I've been quite busy this Fall so I haven't been able to do much with OOTP2006... so I just stumbled on this one! This is awesome! Exactly what I was looking for!! Many many thanks!
D Love is offline   Reply With Quote
Old 04-07-2007, 08:30 AM   #71
StyxNCa
Hall Of Famer
 
StyxNCa's Avatar
 
Join Date: Dec 2004
Location: Victoria, Texas
Posts: 3,136
How long is it supposed to take, generally, to update player histories wirh history 6.x? It starts out quick but then quickly starts to slow to the point that when I finally decided to exit the program, a players name had been showing for 2 1/2 hours.

Also, I don't see their histories on the screen as the program runs. All I have is a small bar showing their name.
StyxNCa is offline   Reply With Quote
Old 04-07-2007, 08:42 AM   #72
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
That means it hung up. Check out that players name or the players name before him, find out their number and look at thier history file and see if there is problems in it.

If not, get me the 6.5 league and a CSV dump from the converted league and I will convert it for you.
__________________
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 04-07-2007, 08:54 AM   #73
StyxNCa
Hall Of Famer
 
StyxNCa's Avatar
 
Join Date: Dec 2004
Location: Victoria, Texas
Posts: 3,136
Quote:
Originally Posted by Comedian2004 View Post
That means it hung up. Check out that players name or the players name before him, find out their number and look at thier history file and see if there is problems in it.

If not, get me the 6.5 league and a CSV dump from the converted league and I will convert it for you.
If I can't get it to work I will just send the entire league folder, except the photos.
StyxNCa is offline   Reply With Quote
Old 04-07-2007, 09:23 AM   #74
StyxNCa
Hall Of Famer
 
StyxNCa's Avatar
 
Join Date: Dec 2004
Location: Victoria, Texas
Posts: 3,136
It was working for a while, longer than before anyway, but when looking at the text files, every player had the exact same history.
StyxNCa is offline   Reply With Quote
Old 05-03-2007, 01:36 PM   #75
marky32082
Minors (Triple A)
 
marky32082's Avatar
 
Join Date: Jun 2004
Location: Chicago
Posts: 283
I feel like I read somewhere that it does....but does this fine program work when going from 6.5 to 2007? or is it a 2006 only program?
__________________
These pretzels are making me thirsty!
marky32082 is offline   Reply With Quote
Old 05-03-2007, 01:50 PM   #76
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
The current version works from 6.x to 2007. I just modified it to work with 2007, so currently there is no version that works for 2006. However, if there is a request, I can create one quickly.

Follow the instructions carefully and it should work fine, but since the history of your 6.x league can have some funky data in the history files, it could have problems, but I can easily solve the issues. So far I have a perfect record in converting the history in the ones that bombed out.

MAKE SURE YOU BACK UP the OOTP2007 player history folder before running it
__________________
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 05-12-2007, 10:00 PM   #77
whizkid1950
Minors (Double A)
 
whizkid1950's Avatar
 
Join Date: Feb 2004
Location: Wake Forest, NC
Posts: 173
AU65History

GREAT utility - thank you
whizkid1950 is offline   Reply With Quote
Old 05-16-2007, 09:31 AM   #78
marky32082
Minors (Triple A)
 
marky32082's Avatar
 
Join Date: Jun 2004
Location: Chicago
Posts: 283
If this is happening
http://www.ootpdevelopments.com/boar...d.php?t=147626

is it going to screw up the imported histories? I haven't had a chance to try Steve Kuffrey's suggestion or use this program yet but I should soon and wanted to figure out if it even mattered.

Thanks!
__________________
These pretzels are making me thirsty!
marky32082 is offline   Reply With Quote
Old 05-16-2007, 09:36 AM   #79
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Before you use my program to import the player's history, back up the 2007 history. (That is if you have played any games AFTER your imported from 6.x). If not, the history folder will be empty. If it is empty then no need to backup. This is the ONLY folder that is written to by my history6x program.

As far as the lines with history that are incorrect. About the only solution is to use my newest program to edit the history. You can bulk search for phrases and even remove lines. (Like remove all lines with a certain phrase in it)
__________________
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 05-18-2007, 10:12 AM   #80
marky32082
Minors (Triple A)
 
marky32082's Avatar
 
Join Date: Jun 2004
Location: Chicago
Posts: 283
Program worked like a charm. To solve my problem I am getting quite used to using the "EDIT HISTORY" option.
__________________
These pretzels are making me thirsty!
marky32082 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 09:32 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 - 2024, vBulletin Solutions, Inc.
Copyright © 2020 Out of the Park Developments