45 lines
1.7 KiB
Plaintext
45 lines
1.7 KiB
Plaintext
FINAL PLAYER-TO-SBAPLAYER ASSIGNMENT SUMMARY
|
|
=======================================================
|
|
|
|
ASSIGNMENT BREAKDOWN:
|
|
Tier 1 (bbref_id): 6,764 players
|
|
Tier 2 (exact name): 5,367 players
|
|
Manual existing: 30 players
|
|
Manual new: 62 players
|
|
Emergency new: 9 players (ERROR)
|
|
TOTAL ASSIGNMENTS: 12,232 players
|
|
|
|
NEW SBAPLAYER RECORDS TO CREATE:
|
|
Total new records: 16
|
|
Albert Almora (temp ID 3234) - 5 players
|
|
Diego Castillo (temp ID 3235) - 9 players
|
|
Javy Guerra (temp ID 3236) - 5 players
|
|
Luis Garcia (temp ID 3237) - 12 players
|
|
Evan Phillips (temp ID 3238) - 9 players
|
|
Francisco Mejia (temp ID 3239) - 10 players
|
|
Mike Soroka (temp ID 3240) - 4 players
|
|
Tom Eshelman (temp ID 3241) - 6 players
|
|
Jose Garcia (temp ID 3242) - 2 players
|
|
Logan Allen (temp ID 3243) - 7 players
|
|
Luis H Garcia (temp ID 3244) - 8 players
|
|
Tom Hatch (temp ID 3245) - 2 players
|
|
Danny Coulombe (temp ID 3246) - 2 players
|
|
JC Mejia (temp ID 3247) - 2 players
|
|
Kody Funderburk (temp ID 3248) - 1 players
|
|
Tyler Phillips (temp ID 3249) - 1 players
|
|
|
|
CAREER STAT TRACKING ENABLED FOR:
|
|
12,161 players linked to existing SbaPlayers
|
|
62 players will have career stats after new SbaPlayer creation
|
|
TOTAL: 12,232 players will have career stat tracking
|
|
|
|
FILES GENERATED:
|
|
- player_sbaplayer_assignments.csv (ready for API updates)
|
|
- new_sbaplayers_to_insert.csv (new SbaPlayer records to create first)
|
|
|
|
NEXT STEPS:
|
|
1. Review the assignment files for any issues
|
|
2. Create new SbaPlayer records via API (new_sbaplayers_to_insert.csv)
|
|
3. Update all player.sbaplayer_id fields via API (player_sbaplayer_assignments.csv)
|
|
4. Verify career stat tracking works correctly
|