Player ID Map

[whaleheader]

I'm trying to port an existing online league from another game to OOTP. I exported all players to update teams, service time, and contracts. I currently track the other league in Access (with mapping to Lahman, MLB, BBRef, and a few systems).

The file format says,
//FILE FORMAT:
//Team Name, LastName, FirstName, NickName, UniformNumber, DayOB, MonthOB, YearOB, NationalityID, Nation, CityID, City, facial_type, Height (cm), Weight (kg), Bats, Throws, Position, ML Service, 40 man roster service, pro years, options used, Contact vL, Gap vL, Power vL, Eye vL, Avoid K vL, BABIP vL, Contract Vr, Gap Vr, Power vR, Eye vR, Ks vR, BABIP vR, Contact Pot, Gap Pot, Power Pot, Eye Pot, Ks Pot, BABIP Pot, HBP, Batter type, speed, steal, running, sac bunt, bunt hit,Move vL, Control vL, Movement vR, Control vR, Move Pot, Control Pot, HBP, WP, Balk, Stamina, Hold, GB%, Velocity, Infield Range, Infield Error, Infield Arm, DP, CatcherAbil, Catcher Arm, OF Range, OF Error, OF Arm, PExp, CExp, 1bExp, 2bExp, 3bExp, ssExp, LFExp, CFExp, RFExp, use expected, expected level, expected ab, expected avg, expected 2b, expected 3b, expected hr, expected bb, expected k, expected hbp, contract y1, contract y2, contract y3, contract y4, contract y5, contract y6, contract y7, contract y8, contract y9, contract y10, contract current year (0 = first year), extension y1, extension y2, extension y3, extension y4, extension y5, extension y6, extension y7, extension y8, extension y9, extension y10, greed, loyalty, play_for_winner, work_ethic, intelligence, leader ability, Stuff Overall, Stuff R/L split, Stuff Pot., Fastball (scale: 0-5), Slider, Curveball, Changeup, Cutter, Sinker, Splitter, Forkball, Screwball, Circlechange, Knucklecurve, Knuckleball, Fastball Pot.(scale: 0-5), Slider Pot., Curveball Pot., Changeup Pot., Cutter Pot., Sinker Pot., Splitter Pot., Forkball Pot., Screwball Pot., Circlechange Pot., Knucklecurve Pot., Knuckleball Pot., Hitter 3B/2B ratio

I find three extra unnamed columns at the beginning:
52908,0,0,,Trout,Mike,

I'm assuming the first three have something to do with (in this example) Mike Trout's ID. Is this true? If it is, where do I find a player map or am I missing something in the file?

I checked the master.csv and MiLBMaster.csv but neither has Trout identified as 52908.

Thanks in advance!

Edit: I just verified the first column is the player id on another site:

`player_id` int(11) NOT NULL,
`team_id` int(11) DEFAULT NULL,
`league_id` int(11) DEFAULT NULL,

[NoOne]

player id's are unique and created ondemand. so they can be different each time you create a new league. i don't even think the real 2018 players maintain same playerid value (not lehman's id, that remains, obviously)

this is why you can't just export a player list from one leauge and import to another it will corrupt the game's db tables.

-even a note in game saying you must only import from a list that was exported previously from that exact league.

you can, if you re-use existing player id's from destination league.. this requires same # of players, or at least 'more' in the destination league... then copy paste (with similar sorting applied) over that destination league's exported list but preserve the player id column and make team-id's congruent or re-use exisitng ones etc... takes a modicum of effort with a spreadsheet, but still some hoops to jump through nonetheless.

[whaleheader]

Well, that's disappointing.

I thought I'd be able to link up my existing database, update teams, service time and contracts, copy and paste the info into the proper format, and then import the file back into OOTP. When I finished I'd have my league's rosters in the game.

My league has 1233 players (both major and minor leaguers) currently under contract. The prospect of having to manually update that many players is not one that fills me with glee.

Anyway, I pulled the data into a mysql database to see if I can figure an easier way updating without having to manually update players. On the bright side, I'm learning how some of the underlying parts go together.

Any ideas on making this task easier will be appreciated.

Edit: Building on a key of name and DOB will have to do.

[whaleheader]

Well, this just got a little worse. Trout's birthdate in my fictional league is incorrect in the game. I verified the date on the game screen and in the mysql dump for the league. When I checked his DOB in the 2018 game version his birthdate is correct.

So, I need delete all the free agents in my fictional league and bring in another copy of all the players from the 2018 game and see if the data problem is fixed.

Grrr.

[whaleheader]

I ended up completely deleting the season to fix things. I'm rebuilding my setup using some of the things I've learned though the process. I'm also trying to document my experience to post when I'm done.

[NoOne]

if versed in sql, could fashing a command line to do what is needed - find replace where etc... between first name, last name etc you can have a unique search to replace each player if oyu are using MLB players these things will match up in a 1:1 fashion, of course.. once you get to fictionally created playrs, you'd have to make soem free agents then replace those specific players with new 'real' players.

you'd have to re-use existing id's of players and teams from the destination league.