Historical database issues go here

[dewelar]

Negro Leaguer Jim Zapp (zappji01 / zapp--001jam) is listed on the database with facial type Caucasian.

[LansdowneSt]

Originally Posted by dewelar

Negro Leaguer Jim Zapp (zappji01 / zapp--001jam) is listed on the database with facial type Caucasian.

Thanks. fixed.

[luckymann]

Working off a slightly dated version of the 26 DB bud, but noticed a few potential anomalies in the NeL Class of 1930:

• Jim West should have DOB April 23, 1905 in Birmingham AL
• Johnny Markham DOB should be October 1, 1908
• Jabbo Andrews YOB should be 1907

Thanks

G

[LansdowneSt]

Originally Posted by luckymann

Working off a slightly dated version of the 26 DB bud, but noticed a few potential anomalies in the NeL Class of 1930:

• Jim West should have DOB April 23, 1905 in Birmingham AL
• Johnny Markham DOB should be October 1, 1908
• Jabbo Andrews YOB should be 1907

Thanks

G

already fixed, fixed, and already fixed

[jeffblake]

Deleted

[pholmer]

I was importing players into my game and the players came back with numbers instead of names, i.e. 23 7 and 17 10. All the other bio information was there, birthdate, hometown, etc. The bios also contained historical ID, from which I got the player's name from the master.csv file. However, it was rather time consuming and I had 168 pages of numbers/no names in the list, about 3,500 names.

My question is: has anyone else encountered this problem and is there a way to change a large batch of numbers into names?

[LansdowneSt]

Originally Posted by pholmer

I was importing players into my game and the players came back with numbers instead of names, i.e. 23 7 and 17 10. All the other bio information was there, birthdate, hometown, etc. The bios also contained historical ID, from which I got the player's name from the master.csv file. However, it was rather time consuming and I had 168 pages of numbers/no names in the list, about 3,500 names.

My question is: has anyone else encountered this problem and is there a way to change a large batch of numbers into names?

Never seen or heard of that. Post the list used to import them. Also describe the steps taken from the moment you opened the import pop-up. My guess is the source document or some missed step/import location navigation but need more info.

There is no way to replace the name fields with the proper names en masse. You could randomize every name in your game though but I don't think that is what you are going for. I'd prob have sorted them, deleted them and troubleshot it rather than one-by-one-fixing. Impressed you even tried!

[Carplos]

In theory couldn't he export the rosters using the normal export rosters tool and copy/paste names (assuming he has them in a table format to do so) and reimport them?

Does that mess anything up with a historical save?

[LansdowneSt]

Originally Posted by Carplos

In theory couldn't he export the rosters using the normal export rosters tool and copy/paste names (assuming he has them in a table format to do so) and reimport them?

Does that mess anything up with a historical save?

I’ve never exported rosters so unsure what it produces but if you have a unique ID for both lists you could set up a VLOOKUP in the broken fields so it auto grabs the correct one as you paste the formula over the broken fields. Then copy the column and paste as value.

[Patsy Tebeau]

I may be missing something but for some reason when I import some players from the 19th century Cuban League, the game will attach pitching stats along with the actual years and teams they played for that seem to have been pulled out of nowhere since it often happens with position players and both seamheads and b ref have no record of these stats. I just use the B ref tag for import and no matter what position they're listed as on there it will just import them as a starting pitcher or relief pitcher every time.

[LansdowneSt]

Originally Posted by Patsy Tebeau

I may be missing something but for some reason when I import some players from the 19th century Cuban League, the game will attach pitching stats along with the actual years and teams they played for that seem to have been pulled out of nowhere since it often happens with position players and both seamheads and b ref have no record of these stats. I just use the B ref tag for import and no matter what position they're listed as on there it will just import them as a starting pitcher every time.

If you are saying that the players are legit but they have fake/erroneous pitching lines that ought not exist, review the back and forth on this thread I had with Caridnals-BK and follow the same process for providing me the info necessary to find, review and edit the players in question.

In the meantime, as Commish edit their experience to make P experience zero. but the real solution is to provided the info so I can edit at the database source.

[Patsy Tebeau]

I'll provide a few more examples once I get back home but one is Alfredo Arcano who has these pitching stats listed. They seem like they can possibly be legit maybe and I know B ref has less info than seamheads for these players in some cases, but I can't imagine seamheads would miss including something like that and I'm trying to figure out where these stats came from, since I imported using the BR. I'm not super familiar yet with how the coding of the database works.

https://www.seamheads.com/NegroLgs/p...rID=arcan01alf
https://www.baseball-reference.com/r...d=arcano000alf

[LansdowneSt]

Originally Posted by Patsy Tebeau

I'll provide a few more examples once I get back home but one is Alfredo Arcano who has these pitching stats listed. They seem like they can possibly be legit maybe and I know B ref has less info than seamheads for these players in some cases, but I can't imagine seamheads would miss including something like that and I'm trying to figure out where these stats came from, since I imported using the BR. I'm not super familiar yet with how the coding of the database works.

https://www.seamheads.com/NegroLgs/p...rID=arcan01alf
https://www.baseball-reference.com/r...d=arcano000alf

They are not legit. They have been removed. The database is fed through the same provider as BBR but after that it is essentially self contained and get get altered over the years intentionally or in error. I have no idea where the erroneous pitching stats came from but remove them when found (as my time permits).

[Patsy Tebeau]

Originally Posted by LansdowneSt

They are not legit. They have been removed. The database is fed through the same provider as BBR but after that it is essentially self contained and get get altered over the years intentionally or in error. I have no idea where the erroneous pitching stats came from but remove them when found (as my time permits).

Thank you

[Patsy Tebeau]

Not sure if it's still like this since my version of the game is a year old but it imports Tip O'Neill with the hispanic facial type

[LansdowneSt]

Originally Posted by Patsy Tebeau

Not sure if it's still like this since my version of the game is a year old but it imports Tip O'Neill with the hispanic facial type

Looks like Lukas fixed it on September 15, 2023.

[dewelar]

I can't seem to find an entry for Negro Leaguer Augustus Saunders (saundau01 / saunde000aug) in either the MLB or MiLB master file.

[LansdowneSt]

Originally Posted by dewelar

I can't seem to find an entry for Negro Leaguer Augustus Saunders (saundau01 / saunde000aug) in either the MLB or MiLB master file.

I don't see him either. I'll have to input all his info and create him.

[Fonzie13]

Any idea if the problem I've referenced in this thread is being fixed?

St. Louis Browns players missing from league/team history
https://forums.ootpdevelopments.com/...d.php?t=364731

[justtxyank]

Wait...maybe I'm wrong but I think the whole STL/BAL thing is out of order right now in the historical database?

I've always operated under the understanding that the Brown Stockings -> Browns (Van der Ahe) -> Cardinals and that it was Brewers -> Browns ->Orioles.