Quote:
Originally Posted by Eugene Church
I unzipped them and they opened up in Open Office.
Thanks for the help.
Is there a "simple" way to put the players into my league using your spread sheet?
I'm willing to manually put them into my league each year, but if I can do it easier and quicker, that would be great.
Hey, you and Spitze did a tremendous job on the Historical Minor Leaguers... I hope you had some help on it... but if it's like the Beta Text Team... you only had a few active participants who did all the work on the News and PBP.
Kudos to you, Spitze and others who help on the Historical Minor League project.
|
The historical minors was all Markus (Programming), Spritze (Converting it all to ootp usable data) and I did the data collecting. That's it.
Unfortunately, there's no easy way to do it. You'll have to manually add the new players each year. However if you prepare now for the future, then you can get everything ready at once.
Note 1: The first column in all the open office files should be a sort column that can be used to keep everything in order as long as you sort by column A.
Note 2: The rosters.txt file column headings/labels are off by 3 cells. Move those over so that the data below lines up with them. Helps keeping one from getting confused and putting correct data in wrong cells.
1. Make a copy of and open the rosters.ods file and delete everything that you're not going to need for now and future years. Now you should have just the new player's for each year. Add up the number of new players left.
2. Now you need to create the same number of fake player's in your game and send them to free agency. Reason is that you can't just import new players without ootp ids.
Best way to do this is to add 1 more team to your league. Keep filling it with fake players and release them to free agency until you have the same number of players you're going to need for future years. You can delete the extra team once you have everyone in free agency.
3. Export the rosters and open it with OO (Open Office).
The free agents are at the bottom of the file. Replace those player's with the future new player's data. Don't touch the player ids as you must keep them.
You can delete everything after the Position column except the very last column containing eol. You need to keep the eol. eol tells ootp that row is done and it needs to go to the next row of data. If it's not there, things will not get imported.
If you want to, you can rate the players now. Just add the correct data in the correct column. Leave cells that don't apply to that particular player blank.
4. Now save the file as a csv and reimport the rosters and all your needed future players should be showing on the free agents screen.
5. On Jan. 1 of next year, all you have to do is to export rosters (make a copy first) then open it in OO and assign the team ids to the new players in the free agent section by replacing the 0 (zero) with the team id you want them on. The team ids can be found at the top of the rosters.txt file or the top row above the teams players.
6. Move any players that won't be playing that year but may return in a future year to free agency by replacing the team id with a zero.
If you want to move the player to/from team/free agent section, just cut and paste, but ootp should no what to do with them if you don't.
7 . Save the file as a csv file to your saved game's import/export folder and reimport. All should be great.
8. Do the same for the next year when it rolls around.
Stats..
Each year after you import the rosters. Export the players stats. Make copies. Open with OO and add the new player's stats save as csv. Change csv to txt and reimport.
It helps a lot to format the stats in the OO file first. Just insert a new row and copy the column headings from the stats.txt file to it. Cut and paste the data in the OO file to the correct column. When done just copy it to the stats.txt file.
When done...check everything in ootp to make sure all is correct.
Enjoy you're hard work!!
For the schedule...place that in ootp's schedules folder and import it. You don't have to wait till preseason to do it, But when preseason rolls around, double check to make sure it's still correct just in case.
Thinks I covered everything...good luck.
I'll be out of comission for the next few days as I need to prepare for some medical procedures (sucks to get old), but will be in and out when I can till June 1 or 2.
Rod