What Lahman tables are used on import?

Krazi · 05-22-2003, 09:58 PM

I've written some code to take old BBPro all_stat reports and convert them into Lahman tables/csv files. I've recreated the following files

master.csv
batting.csv
pitching.csv
fielding.csv
FieldingOF.csv
Salaries.csv
teams.csv
teammaster.csv

I seem to be able to create a league in OOTP5 using just those tables from the actual Lahman data. However, I'm getting some problems with my jury-rigged data. When I go to create a historical league, it says Creating League. Then it goes to import players and does not actually import any. Then it saves the league and I get an error box: Year not found in database. When I click OK, it goes and generates the coaches and schedules. When it brings me into the league, there is no team info and no players. The jury rigged data has years of 2014 for all the data and that is the year I'm trying to import.

Any ideas or help would be wonderful. Thanks.

Krazi · 05-22-2003, 10:20 PM

OK, I fixed one problem. The players are importing now. There is a non-documented row at the beginning of the master table. It looks like it is just an incremental counter. Once I added that the players imported.

Still getting nothing for the teams though.

Krazi · 05-26-2003, 01:11 PM

Still getting the "year not found in database" error. I'm probably missing a table, but not sure which one.

alinkens · 05-28-2003, 07:33 AM

When you create the Master.CSV file you must make sure that EVERY field is surrounded by " unless its ONLY a number value. I found out that when Excel saves a CSV file it takes out the " on all of the fields.

Krazi · 05-28-2003, 11:59 AM

Is that for OOTP5 as well? I knew that was the case in version 4, but it seems to be importing the players fine without the quotes in v5.

THere is a problem when it's creating the teams. I get that error above and then the game crashes when it tries to do the schedule. If I go back into the game, the teams are there but they are all labeled (A) or (N). The players are on the correct teams and the abbreviation is fine, but the team name and nickname is missing. Also, the Stadium is listed as the team name. I think I'll go back over the teams.csv and see if maybe I'm missing a column somewhere. That seems to be the most likely culprit.

05-22-2003, 09:58 PM	#1
Krazi Minors (Single A) Join Date: Oct 2002 Location: Connecticut Posts: 61	What Lahman tables are used on import? I've written some code to take old BBPro all_stat reports and convert them into Lahman tables/csv files. I've recreated the following files master.csv batting.csv pitching.csv fielding.csv FieldingOF.csv Salaries.csv teams.csv teammaster.csv I seem to be able to create a league in OOTP5 using just those tables from the actual Lahman data. However, I'm getting some problems with my jury-rigged data. When I go to create a historical league, it says Creating League. Then it goes to import players and does not actually import any. Then it saves the league and I get an error box: Year not found in database. When I click OK, it goes and generates the coaches and schedules. When it brings me into the league, there is no team info and no players. The jury rigged data has years of 2014 for all the data and that is the year I'm trying to import. Any ideas or help would be wonderful. Thanks. __________________ Krazi HABLA - Chicago White Sox BBL - Sahara Pride MIBL - Connecticut Yankees

05-22-2003, 10:20 PM	#2
Krazi Minors (Single A) Join Date: Oct 2002 Location: Connecticut Posts: 61	OK, I fixed one problem. The players are importing now. There is a non-documented row at the beginning of the master table. It looks like it is just an incremental counter. Once I added that the players imported. Still getting nothing for the teams though. __________________ Krazi HABLA - Chicago White Sox BBL - Sahara Pride MIBL - Connecticut Yankees

05-26-2003, 01:11 PM	#3
Krazi Minors (Single A) Join Date: Oct 2002 Location: Connecticut Posts: 61	Still getting the "year not found in database" error. I'm probably missing a table, but not sure which one. __________________ Krazi HABLA - Chicago White Sox BBL - Sahara Pride MIBL - Connecticut Yankees

05-28-2003, 07:33 AM	#4
alinkens All Star Starter Join Date: Feb 2002 Location: CT Posts: 1,072	When you create the Master.CSV file you must make sure that EVERY field is surrounded by " unless its ONLY a number value. I found out that when Excel saves a CSV file it takes out the " on all of the fields. __________________ Owner of the Coast to Coast League's Regina Pride

05-28-2003, 11:59 AM	#5
Krazi Minors (Single A) Join Date: Oct 2002 Location: Connecticut Posts: 61	Is that for OOTP5 as well? I knew that was the case in version 4, but it seems to be importing the players fine without the quotes in v5. THere is a problem when it's creating the teams. I get that error above and then the game crashes when it tries to do the schedule. If I go back into the game, the teams are there but they are all labeled (A) or (N). The players are on the correct teams and the abbreviation is fine, but the team name and nickname is missing. Also, the Stadium is listed as the team name. I think I'll go back over the teams.csv and see if maybe I'm missing a column somewhere. That seems to be the most likely culprit. __________________ Krazi HABLA - Chicago White Sox BBL - Sahara Pride MIBL - Connecticut Yankees