Anybody have this problem with BOSI?

John Manard · 02-14-2005, 10:42 AM

Okay I used the exporter to get CSVs after the end of my 2004 season for CATO. I had never set up Bosi yet. So i decided to do it now. When I do intial setup this is what i get ? Any thoughts?

Error inserting team(You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ',,,,,,,0,2,5,5,5,5,'Cal Ripken','BAL',1,1,0,1,,,,,,,1)' at line)<br>Please report the following query -- <br>insert into bosi_TEAM(LEAGUE_ID,OOTP_TEAM_ID,CITY,NAME,AAA_NAM E,AA_NAME,A_NAME,LEAGUE_NAME_ID,Steal,HitandRun,Bu ntHit,SPHook,Pitcha,Iw,Pinchh,Pinchr,Sq,CurStart,R otSize,CurStartAAA,CurStartAA,CurStartA,Manager,AB BREV,Dh,Human,Qualified,HumanMinor,SacBunt,Squeeze Bunt,RPHook,LLMatchup,GuardLines,CornersIn,DIVISIO N_ID)VALUES (1,1,'Baltimore','Orioles','Ottawa','Bowie ','Aberdeen',1,,,,,,,,,0,2,5,5,5,5,'Cal Ripken','BAL',1,1,0,1,,,,,,,1)

DaveHorn · 02-14-2005, 10:59 AM

BOSI is not an end of season tool. I'm not sure if this caused your problem or not, but if you want to use BOSI the best place to start would be at the very beginning or your next season before you sim any single days (including FA, Spring Training). Roll the league file over and then immediately set up BOSI using the new 2005 data.

If you did that and you are just using CSV exporters from CATO, I believe CATO uses a slightly older version of the exporters. Get the regular CommishJoe exporters, not the one that comes with CATO.

John Manard · 02-14-2005, 11:26 AM

Well i was pretty sure i was using the exporter versions of CSVs but maybe i was wrong. I really wanted BOSI to capture my first season but I might have to just let it use the new season im already in. Thanks.

DaveHorn · 02-14-2005, 12:44 PM

Yeah, if you have already simmed the first season, its too late to use BOSI with it. You'll still have their 2004 data when you import career stats, you just wont have any info in BOSI about what happened during the 2004 season.

BOSI pretty much should be updated after every sim. Its meant to be an in-season tool, not a historical tool.

John Manard · 02-14-2005, 01:54 PM

yeah i wanted to use Bosi from the get go but didnt have space on my server. Oh well. Ill just be happy with what i have

02-14-2005, 10:42 AM	#1
John Manard Minors (Single A) Join Date: Aug 2003 Location: Richmond, VA Posts: 97	Anybody have this problem with BOSI? Okay I used the exporter to get CSVs after the end of my 2004 season for CATO. I had never set up Bosi yet. So i decided to do it now. When I do intial setup this is what i get ? Any thoughts? Error inserting team(You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ',,,,,,,0,2,5,5,5,5,'Cal Ripken','BAL',1,1,0,1,,,,,,,1)' at line)<br>Please report the following query -- <br>insert into bosi_TEAM(LEAGUE_ID,OOTP_TEAM_ID,CITY,NAME,AAA_NAM E,AA_NAME,A_NAME,LEAGUE_NAME_ID,Steal,HitandRun,Bu ntHit,SPHook,Pitcha,Iw,Pinchh,Pinchr,Sq,CurStart,R otSize,CurStartAAA,CurStartAA,CurStartA,Manager,AB BREV,Dh,Human,Qualified,HumanMinor,SacBunt,Squeeze Bunt,RPHook,LLMatchup,GuardLines,CornersIn,DIVISIO N_ID)VALUES (1,1,'Baltimore','Orioles','Ottawa','Bowie ','Aberdeen',1,,,,,,,,,0,2,5,5,5,5,'Cal Ripken','BAL',1,1,0,1,,,,,,,1)

02-14-2005, 10:59 AM	#2
DaveHorn All Star Starter Join Date: Aug 2003 Posts: 1,146	BOSI is not an end of season tool. I'm not sure if this caused your problem or not, but if you want to use BOSI the best place to start would be at the very beginning or your next season before you sim any single days (including FA, Spring Training). Roll the league file over and then immediately set up BOSI using the new 2005 data. If you did that and you are just using CSV exporters from CATO, I believe CATO uses a slightly older version of the exporters. Get the regular CommishJoe exporters, not the one that comes with CATO. __________________ Dave HFTC Commish

02-14-2005, 12:44 PM	#4
DaveHorn All Star Starter Join Date: Aug 2003 Posts: 1,146	Yeah, if you have already simmed the first season, its too late to use BOSI with it. You'll still have their 2004 data when you import career stats, you just wont have any info in BOSI about what happened during the 2004 season. BOSI pretty much should be updated after every sim. Its meant to be an in-season tool, not a historical tool. __________________ Dave HFTC Commish

02-14-2005, 11:26 AM	#3
John Manard Minors (Single A) Join Date: Aug 2003 Location: Richmond, VA Posts: 97	Well i was pretty sure i was using the exporter versions of CSVs but maybe i was wrong. I really wanted BOSI to capture my first season but I might have to just let it use the new season im already in. Thanks.

02-14-2005, 01:54 PM	#5
John Manard Minors (Single A) Join Date: Aug 2003 Location: Richmond, VA Posts: 97	yeah i wanted to use Bosi from the get go but didnt have space on my server. Oh well. Ill just be happy with what i have