Importing Phistory in Catobase

Aordolin · 10-27-2005, 10:03 PM

Wondering if anyone has had this problem, but pretty much for that last 15 seasons of my league (25 total) Cato does not import all of the players histories, actually it imports a very small percentage, maybe 5-10%. Same for the Draft History. Now I have found a work around to get the Draft picks in there, I import twice, once to my DB and once to a blank test DB and just copy the seasons Draft picks onto my main DBs Draft table using Access. Getting player history in is a chore. Im not going to say what I do because honestly its probably a bit embarressing the amount of time I do spend. But I am nothing if not anal for details lol. I have spent hours (weeks/months more likely) pouring over every table and entry in the DB learning quite alot about where the information is stored but still not finding the reason why it stopped importing. My only guess is that something in the DB or something in the player text files Cato does not like but I have yet to find it. So all you Cato experts out there have you had a similar problem and have you every fixed it? or do you just live without it like I probably should? Or do you have an idea of what might cause it. Thanks.

SandMan · 11-01-2005, 09:12 AM

This is a known problem. I have trashed many leagues because of this.... earlier not now.....

What happens is that a player retires midseason, his p# is changed to a r# in the game. You change his number in the txt file to a p# to get everything to process correctly in CATOBASE, but if you do not change his r#.txt file to a p#.txt file the program reads through the histories does not find it and CATOBASE with its lack of error handling simply stops reading players histories at this point. Then every subsequent year it stops reading at the same place or earlier if you have another player retire and this happens again. This then affects the draft lists because this is read from the player history.

The fix is to rename the r file to a p and then change it back in game after running catobase. But you need to catch it early otherwise you need to delete seasons back to the error and then rebuild them using the csv files, and this will mess up - YIKES - player history records.......

Aordolin · 11-04-2005, 09:34 PM

i dont think this is it. first off im using 6.12 and there isnt inseason retirements there. also it imports all the history and draft correctly if i import the stats as a single season by itself.

SandMan · 11-04-2005, 10:01 PM

Quote:

Originally Posted by Aordolin

i dont think this is it. first off im using 6.12 and there isnt inseason retirements there. also it imports all the history and draft correctly if i import the stats as a single season by itself.

Did you check to see if you have any r# players in the ltrans.txt. Everytime I had this issue it was an error in the ltrans. Could be something else though. It took me quite a while to duplicate this in 6.5 and then when I did I just deleted the retirements to see what happens and it processed, good thing it was a test league because I also lost the players history and last season played stats......

Aordolin · 11-04-2005, 10:53 PM

im going to check that out this weekend. ive tried everything else it seems.

chrisj · 02-27-2006, 02:10 AM

So does anyone else have any suggestions for this issue? There are no r#.txt players in my ltrans file...

theasfl · 04-10-2006, 06:26 PM

Quote:

Originally Posted by chrisj

So does anyone else have any suggestions for this issue? There are no r#.txt players in my ltrans file...

Im using 6.12 and dont have any r#s anywhere. When I go in the game there arent any retired players listed.

Ive had problems with the draft log in cato since the league's first season (this is the 3rd), but I attributed that to it being a 100 round draft with trades occuring during it....

does anyone have any idea how to fix the problem if it isnt due to retired players?

Shortstop#9 · 04-10-2006, 11:52 PM

this has happened to me and I have figured a way to fix, but it requires access or another prgram that can edit the database file. It takes a little longer, but it seems to work fine for me.

***if you are going to try this, i strongly recommend you backup you league database file before you play around with it. Better to be safe the sorry.***

you import the season as normal and the import the season to a new catobase database. open both mdb files in access, and open the Phistory tbas for both. then i filter out every entry thats not from the current year on both databases. then i select all the lines from the new "temp" database, copy and paste them right over the lines from your old "real" database and save it.

cato also has a problem with the team's draft history and this fix will work for that page the same way.

after this open you real database and create the web pages like normal and everything should work out fine.

theasfl · 04-11-2006, 03:33 AM

I found the number where this last season's p-histories stopped updating and Im hoping creating a p# file there will fix the problem...unfortunately I wont be able to find out for a few days.

Chappy · 10-16-2006, 02:03 PM

Quote:

Originally Posted by Shortstop#9

this has happened to me and I have figured a way to fix, but it requires access or another prgram that can edit the database file. It takes a little longer, but it seems to work fine for me.

***if you are going to try this, i strongly recommend you backup you league database file before you play around with it. Better to be safe the sorry.***

you import the season as normal and the import the season to a new catobase database. open both mdb files in access, and open the Phistory tbas for both. then i filter out every entry thats not from the current year on both databases. then i select all the lines from the new "temp" database, copy and paste them right over the lines from your old "real" database and save it.

cato also has a problem with the team's draft history and this fix will work for that page the same way.

after this open you real database and create the web pages like normal and everything should work out fine.

Thanks, SS, this post saved the NPBL's catobase! Or, at least, made it more accurate.

I didn't bother filtering anything - I just copied all of the data in the current year catobase's phistory table into the 'real' catobase phistory table. None of the duplicate records copy by default, leaving me with exactly what I need in the real phistory table.

10-27-2005, 10:03 PM	#1
Aordolin All Star Reserve Join Date: Apr 2004 Location: Houston, TX Posts: 586	Importing Phistory in Catobase Wondering if anyone has had this problem, but pretty much for that last 15 seasons of my league (25 total) Cato does not import all of the players histories, actually it imports a very small percentage, maybe 5-10%. Same for the Draft History. Now I have found a work around to get the Draft picks in there, I import twice, once to my DB and once to a blank test DB and just copy the seasons Draft picks onto my main DBs Draft table using Access. Getting player history in is a chore. Im not going to say what I do because honestly its probably a bit embarressing the amount of time I do spend. But I am nothing if not anal for details lol. I have spent hours (weeks/months more likely) pouring over every table and entry in the DB learning quite alot about where the information is stored but still not finding the reason why it stopped importing. My only guess is that something in the DB or something in the player text files Cato does not like but I have yet to find it. So all you Cato experts out there have you had a similar problem and have you every fixed it? or do you just live without it like I probably should? Or do you have an idea of what might cause it. Thanks.

02-27-2006, 02:10 AM	#6
chrisj All Star Reserve Join Date: Feb 2002 Location: Edmonton, Alberta (but still wishing I was in Halifax, Nova Scotia, Canada) Posts: 834	So does anyone else have any suggestions for this issue? There are no r#.txt players in my ltrans file... __________________ Canadian Baseball League -- Commissioner -- Calgary GM

11-01-2005, 09:12 AM	#2
SandMan Hall Of Famer Join Date: Aug 2003 Posts: 2,946	This is a known problem. I have trashed many leagues because of this.... earlier not now..... What happens is that a player retires midseason, his p# is changed to a r# in the game. You change his number in the txt file to a p# to get everything to process correctly in CATOBASE, but if you do not change his r#.txt file to a p#.txt file the program reads through the histories does not find it and CATOBASE with its lack of error handling simply stops reading players histories at this point. Then every subsequent year it stops reading at the same place or earlier if you have another player retire and this happens again. This then affects the draft lists because this is read from the player history. The fix is to rename the r file to a p and then change it back in game after running catobase. But you need to catch it early otherwise you need to delete seasons back to the error and then rebuild them using the csv files, and this will mess up - YIKES - player history records.......

11-04-2005, 09:34 PM	#3
Aordolin All Star Reserve Join Date: Apr 2004 Location: Houston, TX Posts: 586	i dont think this is it. first off im using 6.12 and there isnt inseason retirements there. also it imports all the history and draft correctly if i import the stats as a single season by itself.

11-04-2005, 10:53 PM	#5
Aordolin All Star Reserve Join Date: Apr 2004 Location: Houston, TX Posts: 586	im going to check that out this weekend. ive tried everything else it seems.

04-10-2006, 11:52 PM	#8
Shortstop#9 Bat Boy Join Date: Aug 2002 Posts: 7	this has happened to me and I have figured a way to fix, but it requires access or another prgram that can edit the database file. It takes a little longer, but it seems to work fine for me. *if you are going to try this, i strongly recommend you backup you league database file before you play around with it. Better to be safe the sorry.* you import the season as normal and the import the season to a new catobase database. open both mdb files in access, and open the Phistory tbas for both. then i filter out every entry thats not from the current year on both databases. then i select all the lines from the new "temp" database, copy and paste them right over the lines from your old "real" database and save it. cato also has a problem with the team's draft history and this fix will work for that page the same way. after this open you real database and create the web pages like normal and everything should work out fine.

04-11-2006, 03:33 AM	#9
theasfl Hall Of Famer Join Date: Apr 2004 Location: Coral Springs, FL or Orlando, FL (UCF) Posts: 7,988	I found the number where this last season's p-histories stopped updating and Im hoping creating a p# file there will fix the problem...unfortunately I wont be able to find out for a few days. __________________ All-Sports Fantasy League The ASFL 22 different games, 9 sports. Please check out the website (www.theasfl.com/asfl2/). The league is free- if you're interested please fill out the signup form and/or email the commissioner. Miami Talons (ABL): 2004, 2005 & 2008 Champs