Spritze DB's for OOTP11 - Page 20

actionjackson · 10-20-2011, 06:47 PM

Quote:

Originally Posted by plannine

I think something happened to the master file when you opened it (my guess you are using MS-Excel):
They show up for me (using Open Office Calc) in the Column AD without issue ,as:
Miami (FL)
Miami (FL) Dade North CC
Miami, FL
Miami, OH

Hmm...You're probably on to something there because I just took a look at Yonder Alonso in the unfettered, original Gambo-Spritze and he's fine even with Miami, FL as his school.

I'm also using Open Office Calc, and what may have happened is previous tinkerings may have been saved in my fettered, modified Gambo-Spritze. Once saved the dreaded " rear their ugly heads around any text, and even if one uses Find/Replace to rid the scourge of " the damage has already been done. Oh well, I'll dig out of it and post any other players with commas between words that are meant to take up only one cell for the sake of my fellow tinkerers (assuming there are any). Thanks for the correction. Good to know what part of my tinkering led me astray.

actionjackson · 10-20-2011, 11:44 PM

Next 20 players with commas that won't bother you if you play with Gambo-Spritze straight up, but will bother you if you make alterations to the Master.csv using a spreadsheet: Mike McClendon, James McDonald, Evan Meek, Vinegar Bend Mizell (comma in birthCity column), Logan Morrison, A J Murray, Chris Perez, Chad Reineke, Dusty Ryan, Gaby Sanchez, Humberto Sanchez, Omir Santos, Ossee Schreckengost (comma in nameNote column), Frank Sellman (nameNote column), Kanekoa Texeira, Josh Tomlin, Jose Uribe (nameNote column), Danny Valencia, Jonathan Van Every, and Jonny Venters.

actionjackson · 10-21-2011, 12:16 AM

Final four "College Comma" players: Jordan Walden, Jared Wells, Bobby Wilson, and Lance Zawadzki. Thanks again Gambo and Spritze for making OOTP even more awesome for us historical players.

You guys rule.

Spritze · 10-21-2011, 12:50 AM

Alla them commas in de whole Spritze db were removed while ago. Had some in cities and such as well. DB is commaless now and has been for a while. Don't know if Gambo changed them in his version. I simply used find and replace and replaced them with a {space}.

actionjackson · 10-21-2011, 01:00 AM

Quote:

Originally Posted by Spritze

Alla them commas in de whole Spritze db were removed while ago. Had some in cities and such as well. DB is commaless now and has been for a while. Don't know if Gambo changed them in his version. I simply used find and replace and replaced them with a {space}.

The Gambo-Spritze was the one I was speaking of, but I found the 64 critters and am happy to say that order has been restored to my copy of it.

actionjackson · 10-21-2011, 09:32 PM

Quote:

Originally Posted by DXMachina

I found six of them in the DB I'm using: Lou Gehrig (!), Harry Little, Bob Purkey, John Simmons, Joe Tepsic, and George Ulrich. I removed the historical database.odb and restarted the league using just the edited csvs. I now see the usefulness of the odbs. The initial load takes forever with the csvs.

Add one to this list: Jack Lamabe.

thehef · 11-07-2011, 12:55 AM

Since there don't appear to be read-me files for the various v12 Spritze & Gambo/Spritze db's on Padrefans' mods site, I was wondering if some of the posts (in this long thread) that apply to v11 (or earlier) db's might apply. Something that essentially provides the info like what was in previous versions' read-me files... Thanks

Spritze · 11-07-2011, 12:25 PM

Here Be Read Me.

thehef · 11-11-2011, 04:13 AM

Spritze - a few questions...

1. To which database(s) does the above readme file apply?
2. Is the Gambo / Spritze DB w/Transactions for OOTP 12 a "original team" db or a "most associated with" one?
3. From the readme: "The PCL database players have been added as well." Are these only the non-MLB PCLers? Do the PCLers import as free agents or are they set up to import to a PCL team, if one exists?
4. From the readme: "Seamheads Cuban and Negro Players are in process as are the 1889-1900 18th Century Players." In process meaning not included in this db but will be soon? Or am I misinterpreting?
5. There was a Spritze / Garlon db for previous versions of OOTP where 50 Negro League stars were added, other Negro/Major Leaguers had their stats backwardly-extended, insignificant WWII replacement & Federal League players were deleted, etc., etc. Does this database exist in any form that will work with OOTP v12?

Thanks in advance

Spritze · 11-11-2011, 10:53 PM

Quote:

Originally Posted by thehef

Spritze - a few questions...

1. To which database(s) does the above readme file apply?
2. Is the Gambo / Spritze DB w/Transactions for OOTP 12 a "original team" db or a "most associated with" one?
3. From the readme: "The PCL database players have been added as well." Are these only the non-MLB PCLers? Do the PCLers import as free agents or are they set up to import to a PCL team, if one exists?
4. From the readme: "Seamheads Cuban and Negro Players are in process as are the 1889-1900 18th Century Players." In process meaning not included in this db but will be soon? Or am I misinterpreting?
5. There was a Spritze / Garlon db for previous versions of OOTP where 50 Negro League stars were added, other Negro/Major Leaguers had their stats backwardly-extended, insignificant WWII replacement & Federal League players were deleted, etc., etc. Does this database exist in any form that will work with OOTP v12?

Thanks in advance

1. Spritze High School DB 2. That is a Gambo db, I've never used it. 3. Non-ML PCL players are Free Agents, OOTP does not support the historical PCL. 4. Semi-soon - I get 60-90 new players completed each month. 5. This is/was a Gambo db. I never used it.

Gambo's db's use the Spritze db as a base and then he removes a lot of players and portions of their careers. I prefer to leave them in because I'd rather have my minor leagues made up of real players rather than fill them up with fictional fellas. Simply personal preference.

thehef · 11-12-2011, 01:48 PM

How are PCL players indicated in the high school db? A somewhat-less-than-semi-thorough spot-check reveals the following types of players in the csv files: 1) players who will import to MLB teams, and 2) “IND” players who appear to be either Negro Leaguers, Asians, pre-1900 leaguers, and Federal Leaguers.

I’m probably missing something obvious or misinterpreting something… Thanks in advance.

Spritze · 11-12-2011, 04:00 PM

They will be in the NEXT version. The indicator light is college = pcl player

I am also planning on adding a few cephalopods if I have the time. It appears there are NONE in the current databases.

thehef · 11-13-2011, 01:38 AM

PCL-ers in the next db. Got it. Thanks Spritze...

(Cepahalopods. That would be interesting.)

Re:

Quote:

"Non-ML PCL players are Free Agents, OOTP does not support the historical PCL..."

Based upon the answer in this post - http://www.ootpdevelopments.com/boar...ml#post3218529 - to the question posed by me right above it, actually OOTP would support it if csv files were in order, correct?

Oh, and speaking of that answer, just what db are you using that imports all of those cats you refer to, including PCLers? One that has not yet been made available?

Spritze · 11-13-2011, 08:46 AM

The Spritze High School db includes everybody (cats included) at age 18 (unless they debuted earlier IRL, then they come in then). The next version will include the PCL. It will be available when OOTP13 comes out.

Spritze · 11-13-2011, 08:51 AM

Quote:

Originally Posted by thehef

Re: Based upon the answer in this post - http://www.ootpdevelopments.com/boar...ml#post3218529 - to the question posed by me right above it, actually OOTP would support it if csv files were in order, correct?

I've not been able to make this work without keeping the PCL totally seperate from the Majors. No player transfers or transactions between and betwixt.

Germaniac · 11-17-2011, 01:41 AM

Sorry if this is a stupid question

I've never used any db other than what came with OOTP ...

... but: Do I have to start a new league for this to work or can I simply copy your OOTP12 db in the game folder ??

thehef · 11-17-2011, 04:10 AM

Spritze, if I wanted to use one of the modded db's, but wanted to exclude one group or another (for example, Japanese pros or minor leaguers), could I simply delete those from the master.csv file, and not worry about any data that still exists in batting, pitching, fielding, etc., files for those deleted records? Or would add'l file editing be required?

Spritze · 11-17-2011, 02:46 PM

Quote:

Originally Posted by thehef

Spritze, if I wanted to use one of the modded db's, but wanted to exclude one group or another (for example, Japanese pros or minor leaguers), could I simply delete those from the master.csv file, and not worry about any data that still exists in batting, pitching, fielding, etc., files for those deleted records?

Yes, This is what I do when I make the Asian Only and No Asians Allowed db's.

Spritze · 11-17-2011, 02:48 PM

Quote:

Originally Posted by Germaniac

Sorry if this is a stupid question

I've never used any db other than what came with OOTP ...

... but: Do I have to start a new league for this to work or can I simply copy your OOTP12 db in the game folder ??

You do not need to start with the modded db BUT as Player Debut Years will be different you will miss a few players and even possibly double some up if you don't.

Germaniac · 11-18-2011, 05:28 AM

Quote:

Originally Posted by Spritze

You do not need to start with the modded db BUT as Player Debut Years will be different you will miss a few players and even possibly double some up if you don't.

A few missing players wouldn't be something I had a problem with (unless they are premium players) ... and double players ... is it possible to delete them ??

But I have another question: Where exactly do I put the downloaded file ????

If my memory serves me right (I'm at work right now so I can't check it), my database folder includes just the world.xml (something I didn't find when I unzipped the downloaded file) ...

10-21-2011, 12:50 AM	#384
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	Alla them commas in de whole Spritze db were removed while ago. Had some in cities and such as well. DB is commaless now and has been for a while. Don't know if Gambo changed them in his version. I simply used find and replace and replaced them with a {space}. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

11-12-2011, 04:00 PM	#392
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	They will be in the NEXT version. The indicator light is college = pcl player I am also planning on adding a few cephalopods if I have the time. It appears there are NONE in the current databases. __________________ It's madness, madness, I tell you! For the love of God, don't do it! Last edited by Spritze; 11-12-2011 at 04:09 PM.

11-13-2011, 08:46 AM	#394
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	The Spritze High School db includes everybody (cats included) at age 18 (unless they debuted earlier IRL, then they come in then). The next version will include the PCL. It will be available when OOTP13 comes out. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

11-17-2011, 01:41 AM	#396
Germaniac Hall Of Famer Join Date: Apr 2011 Location: Frankenthal, Germany Posts: 3,058	Sorry if this is a stupid question I've never used any db other than what came with OOTP ... ... but: Do I have to start a new league for this to work or can I simply copy your OOTP12 db in the game folder ?? __________________ I'm going to have to meet my Maker some day. And if He asks me why I didn't let this boy play, and I say it's because he's black, that might not be a satisfactory answer. Happy Chandler, 1947

10-20-2011, 11:44 PM	#382
actionjackson Hall Of Famer Join Date: Apr 2009 Location: Toronto, ON Posts: 6,163	Next 20 players with commas that won't bother you if you play with Gambo-Spritze straight up, but will bother you if you make alterations to the Master.csv using a spreadsheet: Mike McClendon, James McDonald, Evan Meek, Vinegar Bend Mizell (comma in birthCity column), Logan Morrison, A J Murray, Chris Perez, Chad Reineke, Dusty Ryan, Gaby Sanchez, Humberto Sanchez, Omir Santos, Ossee Schreckengost (comma in nameNote column), Frank Sellman (nameNote column), Kanekoa Texeira, Josh Tomlin, Jose Uribe (nameNote column), Danny Valencia, Jonathan Van Every, and Jonny Venters.

10-21-2011, 12:16 AM	#383
actionjackson Hall Of Famer Join Date: Apr 2009 Location: Toronto, ON Posts: 6,163	Final four "College Comma" players: Jordan Walden, Jared Wells, Bobby Wilson, and Lance Zawadzki. Thanks again Gambo and Spritze for making OOTP even more awesome for us historical players. You guys rule.

11-07-2011, 12:55 AM	#387
thehef Hall Of Famer Join Date: Jun 2006 Posts: 5,345	Since there don't appear to be read-me files for the various v12 Spritze & Gambo/Spritze db's on Padrefans' mods site, I was wondering if some of the posts (in this long thread) that apply to v11 (or earlier) db's might apply. Something that essentially provides the info like what was in previous versions' read-me files... Thanks

11-11-2011, 04:13 AM	#389
thehef Hall Of Famer Join Date: Jun 2006 Posts: 5,345	Spritze - a few questions... 1. To which database(s) does the above readme file apply? 2. Is the Gambo / Spritze DB w/Transactions for OOTP 12 a "original team" db or a "most associated with" one? 3. From the readme: "The PCL database players have been added as well." Are these only the non-MLB PCLers? Do the PCLers import as free agents or are they set up to import to a PCL team, if one exists? 4. From the readme: "Seamheads Cuban and Negro Players are in process as are the 1889-1900 18th Century Players." In process meaning not included in this db but will be soon? Or am I misinterpreting? 5. There was a Spritze / Garlon db for previous versions of OOTP where 50 Negro League stars were added, other Negro/Major Leaguers had their stats backwardly-extended, insignificant WWII replacement & Federal League players were deleted, etc., etc. Does this database exist in any form that will work with OOTP v12? Thanks in advance

11-12-2011, 01:48 PM	#391
thehef Hall Of Famer Join Date: Jun 2006 Posts: 5,345	How are PCL players indicated in the high school db? A somewhat-less-than-semi-thorough spot-check reveals the following types of players in the csv files: 1) players who will import to MLB teams, and 2) “IND” players who appear to be either Negro Leaguers, Asians, pre-1900 leaguers, and Federal Leaguers. I’m probably missing something obvious or misinterpreting something… Thanks in advance.

11-17-2011, 04:10 AM	#397
thehef Hall Of Famer Join Date: Jun 2006 Posts: 5,345	Spritze, if I wanted to use one of the modded db's, but wanted to exclude one group or another (for example, Japanese pros or minor leaguers), could I simply delete those from the master.csv file, and not worry about any data that still exists in batting, pitching, fielding, etc., files for those deleted records? Or would add'l file editing be required?