New Gambo DB Coming --- Addressing the Public's Complaints and Giving Them what they desire!

[clamel]

The size of this DB is enorm.
It was going fine for master only MLB, but getting those extra minors in recked everything.
Bigtime Runtime error, even after ccleaner, defrag fast PC big disk....

Guess one have to delete a lot of Negro league players one way or the other.
Any tip ???

[SittingDuck]

well, now here's a question first.

did you put the db in it's own directory or did you overwrite the stuff in the stats folder?

[clamel]

All on it´s own as always. I never mix these files.
The real-stats works fine but it´s only with neut stats I get runtime.

I deleted all stats from pre-1900 and then it works fine as far as I can see.
Guess it´s the massive load of stats that brakes the PC.

[clamel]

Something is a bit strange with the 2 different MASTER.csv files.

Lets take a shot at this. We use Hiraku Irabu from Japan as an example

In one you could easy see that he has a "starting" year of 1988, and the other is in 1997.
Then we look at batting.csv batting2.csv pitching.csv and pitching2.csv
He has "lines" in the real stat files from the year 1997 and in the neutralize stats files he has lines from 1988.

Then we asume we use neutralized stats for the dynasty of course.
We pick the year of 1990 as a start of our dynasty.

Now the problem starts....
Irabu will import in 1990 whatever master-file you use.
This will create big problem if you use the master-file there Irabu is starting in 1997 (the real year he came to US)
Since he has "lines" in the batting and pitching csv-files from the year 1988 he will ALWAYS import in 1988 whatever master-file you use.

THEN coming to the year of 1997 he will import AGAIN as a new player.
So summarixe will see Irabu in 1990 in both cases, but using the masterfile with 1997 as a start year we get Irabu numder TWO in 1997 in a Yankee uniform. Where the first Irabu plays we of course doesn´t know.

This was a fact I saw in old DB when the starting year in the masterfile isn´t the same as the first "line" in the batting.csv file. If you got different years you will get TWO players with the name Irabu.

This is a reflection of what I have experienced in many tries.
Of course the fact that I have done something wrong is almost close at hand, but I understood that it was just to pick one of the master-files depending on what you liked, have it named master.csv and then start.

I think the starting year in the master file MUST be the same as the "first" year line in the batting.csv and other csv-files or you will get doubles when doing import.

[clamel]

Other stuff that need to be asked.

I see a ton of japan players in batting.csv and batting2,csv that has no names in any of the master.csv files.
Of course they never pop into the game, for better or worse.
Some of these japs are in the old Gambo masterfile from GamboDB30 w 1977 Ready.zip file

The other way around for minor leaguers like Shawn Sonnier. He is in the both master.csv files with no starting year in any, so also NO stats in any stat-files so he stays out of the game.

I can find many missmatches that troubles me.
Any answers from anybody


By the way scratching Irabu in the batting.csv file until he actually appeared in 1997 did work. He doesn´t come into the league until 1997 and no doubles.
Stopping any japs from getting into the MLB earlier can be stopped with deleting only the lines in the batting.csv file.

[SittingDuck]

I can't even get the game to load up the Gambo master.csv file anymore. It just gets stuck on 'Loading Database'.

For me, this is a non-working mod.

[Gambo]

Originally Posted by clamel

Other stuff that need to be asked.

I see a ton of japan players in batting.csv and batting2,csv that has no names in any of the master.csv files.
Of course they never pop into the game, for better or worse.
Some of these japs are in the old Gambo masterfile from GamboDB30 w 1977 Ready.zip file

The other way around for minor leaguers like Shawn Sonnier. He is in the both master.csv files with no starting year in any, so also NO stats in any stat-files so he stays out of the game.

I can find many missmatches that troubles me.
Any answers from anybody

By the way scratching Irabu in the batting.csv file until he actually appeared in 1997 did work. He doesn´t come into the league until 1997 and no doubles.
Stopping any japs from getting into the MLB earlier can be stopped with deleting only the lines in the batting.csv file.

Your 1st question about Hiraku Irabu is simple. The master file is for Hideki Irabu not Hiraku so the stat lines your looking at do not matter. irabuhi01 (hideki) and irabuhi95? (hiraku)

Also, there are numerous players who are have stat lines that are not included in the database. Most are Japanese players who are not included (in fact, no japanese players who didn't play in the US are included). I may include some of these players later but as of right now they are not included in either the master file so they will not import. They can simply be ignored. Now if you want to add Saduhara Oh (for example) all you need to do is create a master file entry for him).

Other players such as Sonnier are in the Master file but since there is no starting year they will not import. These are typically players who are from outside of Japan but never reached the majors. Once again, the ability to add these guys exists but as of right now they will not be creared.

I assure you that the database is structured properly for its design. Some pf the extra stuff could have been trimmed out but wasn't to promote some expansion and because it has no affect on the information.

[Greatgrampa]

Originally Posted by clamel

Other stuff that need to be asked.

I see a ton of japan players in batting.csv and batting2,csv that has no names in any of the master.csv files.
Of course they never pop into the game, for better or worse.
Some of these japs are in the old Gambo masterfile from GamboDB30 w 1977 Ready.zip file

The other way around for minor leaguers like Shawn Sonnier. He is in the both master.csv files with no starting year in any, so also NO stats in any stat-files so he stays out of the game.

I can find many missmatches that troubles me.
Any answers from anybody


By the way scratching Irabu in the batting.csv file until he actually appeared in 1997 did work. He doesn´t come into the league until 1997 and no doubles.
Stopping any japs from getting into the MLB earlier can be stopped with deleting only the lines in the batting.csv file.

I am not trying to be a PITA but do you think you could call Japanese players, Japanese rather than Jap. That is a derogatory term and really shouldn't be used here. Perhaps you don't realize that and so I am not going to say you are using that term intentionally, but in the future, could you call them Japanese instead of the term you are using? And no, I am not Japanese, but I spent a couple of years in Japan and I found these people to be very nice and not deserving of that term.
Anyway, sorry to get off subject here but just thought I would point this out to everyone here on the board. Not telling anyone what to do. This is just a suggestion. Thanks!

[clamel]

So sorry for the japanese. It´s called japaner in my language, since I´m not english speaking as first language.

I always thought that the forbidden word I mentioned was an accepted short word for something longer, but calling them japaner will probably now be even more confusing for them. Hopefully not

As we say in my country. A dear thing has many names ....

[dangarion]

Originally Posted by Greatgrampa

I am not trying to be a PITA but do you think you could call Japanese players, Japanese rather than Jap. That is a derogatory term and really shouldn't be used here. Perhaps you don't realize that and so I am not going to say you are using that term intentionally, but in the future, could you call them Japanese instead of the term you are using? And no, I am not Japanese, but I spent a couple of years in Japan and I found these people to be very nice and not deserving of that term.
Anyway, sorry to get off subject here but just thought I would point this out to everyone here on the board. Not telling anyone what to do. This is just a suggestion. Thanks!

Of course with the internet being global what may be a derogatory term in the US is not always a derogatory term anywhere else. Heck I don't even know if that term is derogatory in Japan. Anyway as you were...

[Greatgrampa]

Originally Posted by dangarion

Of course with the internet being global what may be a derogatory term in the US is not always a derogatory term anywhere else. Heck I don't even know if that term is derogatory in Japan. Anyway as you were...

Well, I can't tell other people what to do here, obviously, I just thought I would point out that in English, that is a derogatory term. Now, if you are a foreigner, and the word for the Japanese is Japaner, I don't think that would be derogatory at all. I am sure the Japanese have heard their name in most languages of the world, so I would assume that this wouldn't be derogatory. Hey, anyone can use whatever term they want for any nationality, all I am doing is suggesting that in English that using that term IS derogatory. Trust me on that one.

Anyway, I guess I should keep out of it. Not trying to tick anyone off here. All I know is that I wouldn't want to be called a Frog just because I am part French, or a Limey, just because I am part English. Enough said. My apologies if I sounded condescending. I wasn't trying to be!

[clamel]

Well calling swedes for that might then be wrong. Those folks should then be called swedish. Heck I don´t know for sure. I´m a swede, swedish or swedish. Whatever. One of them or two might then be derogatory term in english .. I´m truly confusius or whatever

I rest my case if I ever had one. I just obviously made a bad call, but as refs (oops referees that is) in most cases get away with it. No replay.
Let this drop. I´m sorry so lets not stir up a hornets nest and get back to the DB from Gambo.

[Greatgrampa]

Originally Posted by clamel

Well calling swedes for that might then be wrong. Those folks should then be called swedish. Heck I don´t know for sure. I´m a swede, swedish or swedish. Whatever. One of them or two might then be derogatory term in english .. I´m truly confusius or whatever

I rest my case if I ever had one. I just obviously made a bad call, but as refs (oops referees that is) in most cases get away with it. No replay.
Let this drop. I´m sorry so lets not stir up a hornets nest and get back to the DB from Gambo.

My apologies for bringing the subject up. Yes, let's get back to the main topic! I agree with that.

[Balldog]

I had David Justice import as a 2B?

[SteveP]

I am one of those people who have not been able to get this database to install in the game. Is there anyone who had this problem, figured out why, and then got it to work for them? I've tried various strategies, but nothing has worked.

[Gambo]

Originally Posted by Balldog

I had David Justice import as a 2B?

Doubt that had to do with the database since I just checked the fielding lines for him and there are no "blank" years or "2B" years.

[SittingDuck]

Originally Posted by SteveP

I am one of those people who have not been able to get this database to install in the game. Is there anyone who had this problem, figured out why, and then got it to work for them? I've tried various strategies, but nothing has worked.

What has been your situation? Where do you get with installation or whatever?

[SteveP]

Originally Posted by SittingDuck

What has been your situation? Where do you get with installation or whatever?

No further than the first step of Game creation. The computer just grinds away trying to load the database. Eventually I have to abort OOTP. I'm on a Mac, BTW, though I'm not sure that would matter.

[Gambo]

Sometimes it takes a while. I have no idea why. I think the world creation using recalculated numbers (essentially two databases) is time consuming and why Markus went with the .odb database system. (And mine is much larger) All I can recommend it letting it run. It will start importing eventually,

[SteveP]

Originally Posted by Gambo

Sometimes it takes a while. I have no idea why. I think the world creation using recalculated numbers (essentially two databases) is time consuming and why Markus went with the .odb database system. (And mine is much larger) All I can recommend it letting it run. It will start importing eventually,

Could you or anyone suggest parameters for "eventually"? I've let it run for more than an hour and never gotten further than about 3% loaded. I'd be willing to let it run all night, if other people said that's what they found is necessary. Otherwise, at some point I have to assume the loading process is stalled out.