Quote:
Originally Posted by The Game
I have the file below that was given to be by Mitchkenn, I think, but in order to upload them i have to weirdly copy aspects of them and then paster it into a new txt file. i want to know if there is an easier way.
I am working on an All NLB file. 44 teams, every player all at once. Editing this file is tedious and could take me all 2024.
|
This is how I do it on Mac.
- Copy the ID and debut year for each player to be imported into the first two columns of a new .xlsx file.
- Save that file as your backup copy.
- Save it again as a normal .csv file
- Manually change the .csv suffix in your file directory to .txt
That file is the one you add in the IMPORT HISTORICAL PLAYERS dialogue box, with minors DB selected and all the other settings EG make bads you want.
Works a treat for me, without fail. not sure you can do the same on Windows, though.
Now regarding that old file we've both been using for ages. The issue is that for 24, a project began to bring those old 049 IDs into line with BBRef. so many of them no longer work. So I normally keep the players names in the original .xlsx file I create (then delete them in the .csv copy) for ready reference after you do the import so you can see which one(s) didn't go through.
I am SLOWLY fixing that file as I do new imports into my Everyman League save, but that is only one season every fortnight or so. Like your project, that means it is some way off completion.
Hope that helps.
G