|
||||
|
|
OOTP 14 - General Discussions Discuss the new 2013 version of Out of the Park Baseball here! |
|
Thread Tools |
01-29-2014, 09:34 PM | #1 |
OOTP Stats Master
Join Date: Mar 2009
Location: Maine
Posts: 3,075
|
Open Office users needed to help test historical Import creator??
With all the questions that pop up on how to import historical players in ootp and how troublesome it is to do, I've created an Open Office spreadsheet that will create the .txt file that one can use to make the process a little less painful.
It includes all the players in the master.csv and their ids. Simply enter the players name and year in the appropriate cells and OO creates the format needed for the .txt file. Once done, copy that data to notepad or any txt editor and save it. It's ready to use in ootp to import your historical players. Create as many players as you'd like. The only limit is the number of players in the master.csv Any help, comments good or bad are appreciated.. beta version is here and includes a read me file. EDIT: Fixed a couple of minor errors, added missing bbrefids and updated the link. 1/30 12:10 AM https://www.dropbox.com/s/y8h2jefk8r...20Importer.rar Last edited by Bigrod; 01-30-2014 at 12:08 AM. |
01-29-2014, 10:26 PM | #2 |
Minors (Double A)
Join Date: Nov 2010
Posts: 137
|
The solution: Don't use Open Office.
|
01-29-2014, 11:32 PM | #3 |
OOTP Stats Master
Join Date: Mar 2009
Location: Maine
Posts: 3,075
|
And why do you say that...??
Last edited by Bigrod; 01-29-2014 at 11:38 PM. |
01-30-2014, 12:13 AM | #4 |
Hall Of Famer
Join Date: Aug 2011
Location: Tampa Bay, Massachusetts
Posts: 2,928
|
Yeah, I'm confused at that, too.
As for the spreadsheet itself, it works like a charm. Very well done; can't see much wrong with it, though I obviously haven't tried every player. Just as an fyi, though, the "example" for entering the player and the year would import a 53-year-old Babe Ruth. Not sure if that was intentional or not. Last edited by Fyrestorm3; 01-30-2014 at 12:19 AM. |
01-30-2014, 12:14 AM | #5 |
OOTP Stats Master
Join Date: Mar 2009
Location: Maine
Posts: 3,075
|
Edited the first post as I fixed a couple of minor errors, added in missing bbrefids, and updated the link in the first post..
I also found that the names do not use periods, so don't add those after Initials or JR, Sr, etc. Fixed Ivan De Jesus (The Son) he now shows correctly as Ivan De Jesus Jr |
01-30-2014, 09:14 AM | #6 |
Hall Of Famer
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,807
|
what am I doing wrong?
__________________
Go today don't wait for tomorrow It isn't promised, all the time you get borrowed Don't live your life for other people Don't bottle your emotions till they crack and fill a couple just sorrows Take your mind and refocus go get a paper write your goals out Throw your middle fingers to all your haters "Stay Strong" |
01-30-2014, 12:59 PM | #7 |
Hall Of Famer
|
You would prefer to pay Microsoft instead of using Open Source software that fulfills the same function?
__________________
Rusty Priske Poet, Canadian, Baseball Fan ```````````````````````````````````````` |
01-30-2014, 01:03 PM | #8 |
Hall Of Famer
Join Date: Aug 2011
Location: Tampa Bay, Massachusetts
Posts: 2,928
|
|
01-30-2014, 04:22 PM | #9 |
Hall Of Famer
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,807
|
thanx so used to doing it the other way just typing in a name threw me off.
__________________
Go today don't wait for tomorrow It isn't promised, all the time you get borrowed Don't live your life for other people Don't bottle your emotions till they crack and fill a couple just sorrows Take your mind and refocus go get a paper write your goals out Throw your middle fingers to all your haters "Stay Strong" |
01-30-2014, 06:00 PM | #10 | |
OOTP Stats Master
Join Date: Mar 2009
Location: Maine
Posts: 3,075
|
Quote:
I also have a schedule creator that I created that works similar to this. You can do a season's schedule in just a few hours. As you fill in your matchups, OO auto creates the schedule and fills in random start times. I haven't released it to the public yet as I've got one formula that I just can't figure out how to get it to work... The formula is basically: IF the 4th character of a teams abbreviation (BOSA) is A then vlookup that team to get the away="" team number, else hlookup the opposing team to get the home="" team number. |
|
01-30-2014, 06:05 PM | #11 | |
OOTP Stats Master
Join Date: Mar 2009
Location: Maine
Posts: 3,075
|
Quote:
|
|
01-30-2014, 06:30 PM | #12 | |
Hall Of Famer
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,807
|
Quote:
__________________
Go today don't wait for tomorrow It isn't promised, all the time you get borrowed Don't live your life for other people Don't bottle your emotions till they crack and fill a couple just sorrows Take your mind and refocus go get a paper write your goals out Throw your middle fingers to all your haters "Stay Strong" |
|
01-30-2014, 06:47 PM | #13 |
Hall Of Famer
Join Date: Dec 2005
Posts: 15,741
|
Bigrod, couldn't Markus integrate this kind of tool into OOTP15?
|
01-30-2014, 06:59 PM | #14 |
OOTP Stats Master
Join Date: Mar 2009
Location: Maine
Posts: 3,075
|
|
01-30-2014, 07:07 PM | #15 |
Hall Of Famer
Join Date: Dec 2005
Posts: 15,741
|
Yes. It sure would be a time saver.
|
01-30-2014, 07:40 PM | #16 | |
OOTP Stats Master
Join Date: Mar 2009
Location: Maine
Posts: 3,075
|
Quote:
To me it's very simple to do, but has a bit of a learning curve to it.. I got volunteered to help Curt come up with a working schedule for his Iron Pigs lg. He's extremely picky on schedules. Even worse, he had an odd number of teams and that's the hardest of all schedules to make. I made it for him...took a couple of phone calls to teach him how to use it, but once he learned, he loved it. He was able to do his schedule in a day rather than weeks, but he had his number of games and matchups already figured out so all he had to do was enter them in. You still have to manually figure out your matchups/# of games. Div., Non Div. and interleague. OO keeps a running count of everything as well as showing the number of games vs. each other. so there's no mistake of messing that up. I suppose I could create a simpler version that you could cut and paste in an existing schedule and then use a random formula that mixes up the matchups year to year as well as a random time generator that creates day only, night only and a mix of start times...that's an easy one. I think I could figure it so that all it would take to randomly mix things is to just hit the shift + F9 key (This recomputes formulas in OO) and it would auto rearrange everything. each time you used those keys. Oh well, another thought for another day |
|
01-30-2014, 07:47 PM | #17 |
OOTP Stats Master
Join Date: Mar 2009
Location: Maine
Posts: 3,075
|
To me it would be simple, but I gave up on coding after dos died so I've no clue about ootp's coding. If I did I'd reverse engineer it and add full audio play by play.
All ootp needs to do is build the list as you enter or select multiple names. Once your done, hit a save button and ootp creates the .txt file saved to a folder of your choice and ready for import. Once saved, you get 2 more choices. Import from that list now or exit. |
01-30-2014, 09:02 PM | #18 |
Hall Of Famer
|
I have to say that this is pretty cool, and I've done groups of imports before several times and I can't believe I've never thought of this before. I don't have Open Office installed so I didn't test it, but using the screen shot from The Game used this method to create a spreadsheet, and even with the creation I still think it saved me time, but it is worth it going forward.
So thanks for sharing, and I think that this is a really great idea that saves quite a bit of time. |
01-31-2014, 06:30 AM | #19 |
Hall Of Famer
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,807
|
What I basically want to do in both my MLB & EBL league in the next few seasons is have my team play a 4 game series vs each team in the o. 2020 will have 32 ML and 28 EBL teams. I plan on using 1993 MLB for 2020 EBL but would like to use interleague after that but still focus on divisions while having interleague spread throughout the season. August is extremely boring to me, gotta find a way to keep me playing a 162 games even when my team has a 20 game lead. Most GMO schedules accomplish what I want but the start times are all 705.
__________________
Go today don't wait for tomorrow It isn't promised, all the time you get borrowed Don't live your life for other people Don't bottle your emotions till they crack and fill a couple just sorrows Take your mind and refocus go get a paper write your goals out Throw your middle fingers to all your haters "Stay Strong" |
01-31-2014, 07:07 PM | #20 | |
OOTP Stats Master
Join Date: Mar 2009
Location: Maine
Posts: 3,075
|
Quote:
that will randomly change all your start times to anything from 1PM to 8:05PM in 5 minute increments. Your formula would look something like this. =IF(I6="";VLOOKUP(RANDBETWEEN(1;86);$K$6:$T$91;2;0 ) ;I6) Once you've got your new times built, clear out the old times and paste in the new times. You could save just your vlookup time table as a template. Then when you wanted to change game times, just open your schedule in notepad copy it and paste it into OO using space as the delimeter and your game times would auto change. Copy your new schedule and paste it into notepad and save it as an lsdl file and your done. Last edited by Bigrod; 01-31-2014 at 07:17 PM. |
|
Bookmarks |
|
|