View Single Post
Old 03-16-2019, 06:35 PM   #3
NoOne
Banned
 
Join Date: Apr 2015
Posts: 7,273
Infractions: 0/1 (3)
you just need someone to export the 2019 players and then jump through a few hoops with a spreadsheet program to make it importable to your league.

or, just buy 20.

it can take a lot of effort if you are not familiar with a spreadsheet and very basics of a dB... like what a primary key's function is and why you can't create one with an import of player list from another league... the why isn't important... you can't create new players and playerID through an import of a player list.

so, you must re-use them. that means there needs to be at least that many players. easy to add players in bulk to FA screen. trick is to paste over players and re-use the playerID column from destination league exported list.

TeamID is another hiccup. as long as the league is the same size and same team names etc etc... it will be in the same order but may have a differet starting TeamID... again, easy to fix with a spreadhseet in a matter of seconds.

what's difference of first team's ID? if the new teams are TeamID+14, you have to add 14 to all team id before copy/pasting over the target league's export. say it's A-column... so, in some blank column type "=a1-14"... now a function called "series" can fill every cell below that subtracting 14 from a2, a3, a4 etc...

that should put every single player where they should be... even if the "350" players you created in FA to match total player number are not on a team... that will be copied over with the new teamIDs you created above... paste over old ones before copying/pasting to target league export.

columns cannot be out of order... rows can, though. or if that is an issue, likely not... can simply re-sort and it'll be fixed in seconds before you can import to ootp.

this can all be done in a matter of minutes. maybe less, if familiar with process and maybe setup a macro or something to avoid repeating loops of action. click a button and it's done the next time... etc.

Last edited by NoOne; 03-16-2019 at 06:41 PM.
NoOne is offline   Reply With Quote