Catobase

Nuggett · 11-11-2005, 08:01 AM

Does Catobase work with 6.5a and if so how... I am getting all kinds of error problems (and I noticed a lot of other people are).

Am I best to revert back to the 6.12 patch.

Any help is appreciated as this is a great utility.

f.montoya · 11-11-2005, 08:18 AM

If Catobase is your number one priority, go back to 6.12. With 6.5a or b it's hit or miss at best.

Nuggett · 11-11-2005, 08:22 AM

Thanks... I would rather use 6.5b, but i will revert.

Bluenoser · 11-11-2005, 08:32 AM

CATO works fine with 6.5 if you don't mind editing your "ltrans" file.

Nuggett · 11-11-2005, 08:56 AM

I've been reading that, but do you have a step-by-step of what you need to do.

I have no problem doing that.

Thks.

Nuggett · 11-13-2005, 09:34 PM

Here is my problem with Catobase.. I am not sure if it is because I am using 6.5, but here are the errors I get.

I am using OOTP 6.5a...

1) When I go to import stats, the first error I get is a Type Mismatch error that stats the abbreviations of the teams for the current year are new and do not match the previous years. Why does this happen and how do I fix it. It does say I can continue and fix later.

2) The next error is a Run Time Error "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key or relationship. Change the date in the field or fields that contain duplicate dates, remove the index or redefine the indexes to permit duplicate entries and try again"

I have not seen this error before and I have a couple of years already in my database (which were inputted with no problems)...

Is this a normal error and how can I fix it.

Thanks for any help.

enuttage · 11-15-2005, 06:01 PM

Nuggett,

First things first, check to make sure that none of your team abbreviations in the game are the same.

e.g. Carolina = CAR and Caracas = CAR

If that's the case, you'll need to alter any same abbreviations to be different.

If that's not the problem, check back. I'm no pro, but I know that error.

-E

p.s. I'm really rusty on this, so I could be off. Someone please correct me in order to help Nuggett, if that's the case.

Nuggett · 11-15-2005, 06:34 PM

That makes sense, but here are a couple of other questiosn...

1. When starting an import, should each year directed to its own individual folder.

2. If you have Baltimore in one year and Baltimore in another year, shouldn't he abbreviation for both be BAL and BAL.

3. When looking at the team info and Code numbers, should #1 ecah year be the same team (if #1 in 2003 is Anaheim, #1 in 2004 should be Anaheim)... When I get this error the teams are out of sync from previous years.

Thanks again for any help... If this does not make sense, pelase let me know.

Nuggett · 11-19-2005, 05:16 PM

Anyone....

Nuggett · 11-25-2005, 08:10 PM

Does anyone have any answer for the above... I also do not understand stand why for my team info the Code Numbers for the first 2 years that I have inputted and the new year (for which i am having trouble) are different.

Anyone...

SandMan · 11-25-2005, 08:50 PM

Quote:

Originally Posted by Nuggett

Does anyone have any answer for the above... I also do not understand stand why for my team info the Code Numbers for the first 2 years that I have inputted and the new year (for which i am having trouble) are different.

Anyone...

Did you edit anything in the team names or abbreviations. It appears that you have a null or blank at the end of the team name or abbreviation. If you did not open the team at the team setup then this could not happen. But I would go to each team and simply reenter the abbreviation with no spaces or blanks at the end......

Nuggett · 11-25-2005, 09:38 PM

I did nothing... Do you mean to just reenter the team... what do you mean by leaving a blank at the end.

Arakiss19 · 11-26-2005, 01:51 AM

What is Catobase? I'm new here, sorry.

f.montoya · 11-26-2005, 03:01 AM

Quote:

Originally Posted by Arakiss19

What is Catobase? I'm new here, sorry.

See this thread.

http://www.ootpdevelopments.com/boar...d.php?t=106496

SandMan · 11-26-2005, 09:52 AM

Quote:

Originally Posted by Nuggett

I did nothing... Do you mean to just reenter the team... what do you mean by leaving a blank at the end.

If you did nothing then the error should not be there. Yes I mean to go to the team setup and re-enter the team name and abbreviation at that screen within the game. A null character at the end causes problems because to a computer "THIS" is not "THIS ".

This info is if you are creating your leagues. If you are using a roster set then the issue is with the set. CATOBASE does not change info it reads it. Also the game does not change TEAMID without user intervention or an import. IS this file imported each year or did you change database??? IF so that is where the problem is. I don't use roster sets so I could not help you with this....

Nuggett · 11-26-2005, 11:45 AM

I will try that, but liek I said I did nothing to change the ID numbers... I have been using a roster set, and import from one version of OOTP to another (currently using 6.5)... The only thing I can think is in my last import it changed the Team ID numbers.

When you say change the number, do you mean in the game or in Catobase... If it is in the game, where do I do this...

Thanks for any help... This could be the problem and get me back on track.

Nuggett · 11-26-2005, 12:04 PM

Think I know the problem, but do not know how the fix it...

The Teams' IDs in the first 2 season are consistent, but in my current year (an upgarde to 6.5), the ID's are different. This must have happened in the import to the 6.5 version. For example my Original Team ID #1 was Anaheim, now Team #1 is Baltimore...

Is there a way in the game that I can manipulate the Team IDs to make Anaheim, #1, etc... If this is not the case, how can this be done.

Thks

Arakiss19 · 11-26-2005, 01:07 PM

Quote:

Originally Posted by f.montoya

See this thread.

http://www.ootpdevelopments.com/boar...d.php?t=106496

WOW!!! Catobase is some great stuff. Thanks for the link.This game is very cool.

11-11-2005, 08:18 AM	#2
f.montoya Hall Of Famer Join Date: Nov 2004 Posts: 6,077	If Catobase is your number one priority, go back to 6.12. With 6.5a or b it's hit or miss at best. __________________ Fidel Montoya Asahi2 Baseball League ex-Commissioner(Historical League Since 2004) Ex-Web Host Current Mod Maker??

11-15-2005, 06:01 PM	#7
enuttage Hall Of Famer Join Date: Mar 2002 Location: Hill Country Posts: 2,431	Nuggett, First things first, check to make sure that none of your team abbreviations in the game are the same. e.g. Carolina = CAR and Caracas = CAR If that's the case, you'll need to alter any same abbreviations to be different. If that's not the problem, check back. I'm no pro, but I know that error. -E p.s. I'm really rusty on this, so I could be off. Someone please correct me in order to help Nuggett, if that's the case. __________________ The former GM of the WHBL Managua Four Roses *"The best way to find out if you can trust somebody is to trust them."* Last edited by enuttage; 11-15-2005 at 06:02 PM.

11-26-2005, 01:51 AM	#13
Arakiss19 Bat Boy Join Date: Nov 2005 Location: Pennsylvania Posts: 15	What is Catobase? I'm new here, sorry. __________________ I dream in black and white I dream 'cause I'm alive

11-11-2005, 08:01 AM	#1
Nuggett Minors (Triple A) Join Date: Dec 2002 Posts: 275	Catobase Does Catobase work with 6.5a and if so how... I am getting all kinds of error problems (and I noticed a lot of other people are). Am I best to revert back to the 6.12 patch. Any help is appreciated as this is a great utility.

11-11-2005, 08:22 AM	#3
Nuggett Minors (Triple A) Join Date: Dec 2002 Posts: 275	Thanks... I would rather use 6.5b, but i will revert.

11-11-2005, 08:32 AM	#4
Bluenoser Hall Of Famer Join Date: Mar 2002 Location: In The Moment Posts: 14,483	CATO works fine with 6.5 if you don't mind editing your "ltrans" file.

11-11-2005, 08:56 AM	#5
Nuggett Minors (Triple A) Join Date: Dec 2002 Posts: 275	I've been reading that, but do you have a step-by-step of what you need to do. I have no problem doing that. Thks.

11-13-2005, 09:34 PM	#6
Nuggett Minors (Triple A) Join Date: Dec 2002 Posts: 275	Here is my problem with Catobase.. I am not sure if it is because I am using 6.5, but here are the errors I get. I am using OOTP 6.5a... 1) When I go to import stats, the first error I get is a Type Mismatch error that stats the abbreviations of the teams for the current year are new and do not match the previous years. Why does this happen and how do I fix it. It does say I can continue and fix later. 2) The next error is a Run Time Error "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key or relationship. Change the date in the field or fields that contain duplicate dates, remove the index or redefine the indexes to permit duplicate entries and try again" I have not seen this error before and I have a couple of years already in my database (which were inputted with no problems)... Is this a normal error and how can I fix it. Thanks for any help.

11-15-2005, 06:34 PM	#8
Nuggett Minors (Triple A) Join Date: Dec 2002 Posts: 275	That makes sense, but here are a couple of other questiosn... 1. When starting an import, should each year directed to its own individual folder. 2. If you have Baltimore in one year and Baltimore in another year, shouldn't he abbreviation for both be BAL and BAL. 3. When looking at the team info and Code numbers, should #1 ecah year be the same team (if #1 in 2003 is Anaheim, #1 in 2004 should be Anaheim)... When I get this error the teams are out of sync from previous years. Thanks again for any help... If this does not make sense, pelase let me know.

11-19-2005, 05:16 PM	#9
Nuggett Minors (Triple A) Join Date: Dec 2002 Posts: 275	Anyone....

11-25-2005, 08:10 PM	#10
Nuggett Minors (Triple A) Join Date: Dec 2002 Posts: 275	Does anyone have any answer for the above... I also do not understand stand why for my team info the Code Numbers for the first 2 years that I have inputted and the new year (for which i am having trouble) are different. Anyone...

11-25-2005, 09:38 PM	#12
Nuggett Minors (Triple A) Join Date: Dec 2002 Posts: 275	I did nothing... Do you mean to just reenter the team... what do you mean by leaving a blank at the end.

11-26-2005, 11:45 AM	#16
Nuggett Minors (Triple A) Join Date: Dec 2002 Posts: 275	I will try that, but liek I said I did nothing to change the ID numbers... I have been using a roster set, and import from one version of OOTP to another (currently using 6.5)... The only thing I can think is in my last import it changed the Team ID numbers. When you say change the number, do you mean in the game or in Catobase... If it is in the game, where do I do this... Thanks for any help... This could be the problem and get me back on track.

11-26-2005, 12:04 PM	#17
Nuggett Minors (Triple A) Join Date: Dec 2002 Posts: 275	Think I know the problem, but do not know how the fix it... The Teams' IDs in the first 2 season are consistent, but in my current year (an upgarde to 6.5), the ID's are different. This must have happened in the import to the 6.5 version. For example my Original Team ID #1 was Anaheim, now Team #1 is Baltimore... Is there a way in the game that I can manipulate the Team IDs to make Anaheim, #1, etc... If this is not the case, how can this be done. Thks