Historical Template Help

jparker2112 · 03-14-2019, 01:42 PM

Does anybody have a HOF or All-Time Greats template or QS that has the all-timers at an early age...like everybody is age 21? Instead of them being at their peak (age 28, 32, etc..) . Id like to have a world where all the greats from years gone by start at the same age and see how that new world transpires statistically and such....anybody have an easy way to start this aside from manually editing every player one by one?

Thanks in advance!

NoOne · 03-14-2019, 08:18 PM

maybe check mods forum? google with "site:www.ootpdevelopments.com" will help too. if the instructions exist or a template exists you'll find it. good possibility that perso doesn't even look at forums anymore, and can't inform you about it.

you can make a .txt file to import to game with the players. if someone has created one, even if a few years old, it'd save you a lot of time for this sort of project.

alternatives are random start leagues for the real historical players (and look into other options in settings related to historical players). maybe you can import teams and cut the fat. as far as dob, you could fix that quickly with a simple sql statement or a little work in a spreadhseet and replace teh dob column with adjusted DoB relative to difference in league year and imported year they came from. could make them all the same relative to import year, anyway. or if you want them all 21, that's even easier.

side note: if everyone is elite, that will have a significant impact on the stats you see.

basically everyone will be like a the bulk of a normal league... guys with ~70contact might be ~.250BA in peak years, lol.

you'll want some scrubs too and some average guys... and some better than average etc etc... distribution is key in how the stats will play out.

jparker2112 · 03-14-2019, 08:40 PM

ok..i get that. let me ask this...is it possible to transfer ONLY players from a prior OOTP version w/o going thru and "importing from older versions"? Can i take a players.dat file from OOTP 15 and use those players and their info in OOTP 19?

NoOne · 03-16-2019, 05:43 PM

you export the players from both leagues, then re-use their playerIDs while copying over the rest.

keys for this to be easy -- same named teams in same order, so same divisions and everyrthing same initially... you can change them after import... teamID will be different, so you likely have to exclude that in the pasting or fixing it before copying. also, you need too ensure at least as many players exist in the destination league. easy to create many new players in bulk. just go to free agent screen and it's in availabel actions or somewhere in gui. can enter "354" new players to create etc...

About team id -- may need some tricks there. ie sort by team name may help, but probably already that way and by division. team ids are incremental and unique. so, if team A in division A starts with team id of "31" in one league and "55" in destination leauge, then you have to add 24 to all team id's as you copy/paste etc... simply make a temp column of data that says "=a1+14" then appl that in a series to last row. (faster than click and drag when it is this many rows... look up last row# first. it will auto increment a1, a2 , a3 in the equation... then copy/paste "special" only numeric values and no formulas.... all fixed.)

you know this because even though team id may shift, it still will order things i nteh same way.... all the way down to the mil teams. so, if you name things the same way, even though team id may shift, it's a simply +/- funciton to fix them to new leauge's values. with a spreadsheet, you can do all these things in a matter of minutes or even seconds if you are familiar with the process.. .do it once and fumble through it and the next time will be easier and so on. even if oyu don't know what you are doing now, it won't take long to learn it.

best to use a spreadhseet rather than a word processor for this. make sure to export with column headers tomake it easier to see playerID and Team ID.

the idea here is that you cannot create players through an import of a league player list. playerid's are a special case in a this database. they are a primary key. if they are not incremental and unique it won't work properly. if they don't exist, they cannot work. these must be created by the system. they are invovled in more than one table -- rDB. just because it's output in 1 file does not mean all that info comes from one table.

so, if you copy a playerID over that does not exist, it throws a wrench in the clockwork. as long as you replace everything else and re-import, it'll be fine. (team id is a unique key too with similar repercussions)

anything that is used as unique identification will work this way. (not names or addresses, dob, ratings etc... these are not unique. they are meant to be able to change. stick to those and you are fine)

EDIT:

does 15 have all the same ratings? if not you will have to manufacture some. e.g. if personality didn't exist you'd have to create that data... again, very easy to do in bulk with a spreadsheet. can either give everyone 100/200 or even Random(0:200) etc etc... throw in some "if" statements.. like if potential > X rand(100:200) to make those guys better etc etc...

impossible to recreate the ootp info. so you ahve to fill in the blanks for any 'new' column of data that didn't exist in 2015. also, ensure order is of columns is exactly the same. if they change that, it's an effort to prevent this or some spring cleaning thing of the db's etc etc. easy way to prevent those with less technical knowledge from doing this.

03-14-2019, 01:42 PM	#1
jparker2112 All Star Reserve Join Date: Nov 2012 Location: Denver CO Posts: 800 Blog Entries: 1	Historical Template Help Does anybody have a HOF or All-Time Greats template or QS that has the all-timers at an early age...like everybody is age 21? Instead of them being at their peak (age 28, 32, etc..) . Id like to have a world where all the greats from years gone by start at the same age and see how that new world transpires statistically and such....anybody have an easy way to start this aside from manually editing every player one by one? Thanks in advance!

03-14-2019, 08:18 PM	#2
NoOne Hall Of Famer Join Date: Apr 2015 Posts: 7,167	maybe check mods forum? google with "site:www.ootpdevelopments.com" will help too. if the instructions exist or a template exists you'll find it. good possibility that perso doesn't even look at forums anymore, and can't inform you about it. you can make a .txt file to import to game with the players. if someone has created one, even if a few years old, it'd save you a lot of time for this sort of project. alternatives are random start leagues for the real historical players (and look into other options in settings related to historical players). maybe you can import teams and cut the fat. as far as dob, you could fix that quickly with a simple sql statement or a little work in a spreadhseet and replace teh dob column with adjusted DoB relative to difference in league year and imported year they came from. could make them all the same relative to import year, anyway. or if you want them all 21, that's even easier. side note: if everyone is elite, that will have a significant impact on the stats you see. basically everyone will be like a the bulk of a normal league... guys with ~70contact might be ~.250BA in peak years, lol. you'll want some scrubs too and some average guys... and some better than average etc etc... distribution is key in how the stats will play out. Last edited by NoOne; 03-14-2019 at 08:25 PM.

03-16-2019, 05:43 PM	#4
NoOne Hall Of Famer Join Date: Apr 2015 Posts: 7,167	you export the players from both leagues, then re-use their playerIDs while copying over the rest. keys for this to be easy -- same named teams in same order, so same divisions and everyrthing same initially... you can change them after import... teamID will be different, so you likely have to exclude that in the pasting or fixing it before copying. also, you need too ensure at least as many players exist in the destination league. easy to create many new players in bulk. just go to free agent screen and it's in availabel actions or somewhere in gui. can enter "354" new players to create etc... About team id -- may need some tricks there. ie sort by team name may help, but probably already that way and by division. team ids are incremental and unique. so, if team A in division A starts with team id of "31" in one league and "55" in destination leauge, then you have to add 24 to all team id's as you copy/paste etc... simply make a temp column of data that says "=a1+14" then appl that in a series to last row. (faster than click and drag when it is this many rows... look up last row# first. it will auto increment a1, a2 , a3 in the equation... then copy/paste "special" only numeric values and no formulas.... all fixed.) you know this because even though team id may shift, it still will order things i nteh same way.... all the way down to the mil teams. so, if you name things the same way, even though team id may shift, it's a simply +/- funciton to fix them to new leauge's values. with a spreadsheet, you can do all these things in a matter of minutes or even seconds if you are familiar with the process.. .do it once and fumble through it and the next time will be easier and so on. even if oyu don't know what you are doing now, it won't take long to learn it. best to use a spreadhseet rather than a word processor for this. make sure to export with column headers tomake it easier to see playerID and Team ID. the idea here is that you cannot create players through an import of a league player list. playerid's are a special case in a this database. they are a primary key. if they are not incremental and unique it won't work properly. if they don't exist, they cannot work. these must be created by the system. they are invovled in more than one table -- rDB. just because it's output in 1 file does not mean all that info comes from one table. so, if you copy a playerID over that does not exist, it throws a wrench in the clockwork. as long as you replace everything else and re-import, it'll be fine. (team id is a unique key too with similar repercussions) anything that is used as unique identification will work this way. (not names or addresses, dob, ratings etc... these are not unique. they are meant to be able to change. stick to those and you are fine) EDIT: does 15 have all the same ratings? if not you will have to manufacture some. e.g. if personality didn't exist you'd have to create that data... again, very easy to do in bulk with a spreadsheet. can either give everyone 100/200 or even Random(0:200) etc etc... throw in some "if" statements.. like if potential > X rand(100:200) to make those guys better etc etc... impossible to recreate the ootp info. so you ahve to fill in the blanks for any 'new' column of data that didn't exist in 2015. also, ensure order is of columns is exactly the same. if they change that, it's an effort to prevent this or some spring cleaning thing of the db's etc etc. easy way to prevent those with less technical knowledge from doing this. Last edited by NoOne; 03-16-2019 at 06:14 PM.

03-14-2019, 08:40 PM	#3
jparker2112 All Star Reserve Join Date: Nov 2012 Location: Denver CO Posts: 800 Blog Entries: 1	ok..i get that. let me ask this...is it possible to transfer ONLY players from a prior OOTP version w/o going thru and "importing from older versions"? Can i take a players.dat file from OOTP 15 and use those players and their info in OOTP 19?