|
||||
|
|
OOTP 17 - General Discussions Everything about the latest Out of the Park Baseball - officially licensed by MLB.com and the MLBPA. |
|
Thread Tools |
05-24-2016, 07:49 PM | #1 |
All Star Reserve
Join Date: Oct 2003
Posts: 738
|
Import / Export rosters
I am expanding using my own house rules, which means I kinda do it offline and use the trade feature to move players around. Is it simple to export rosters, edit teams and then import? I've never done it before; I'm not sure if there are things I need to look out for, etc, or what program I need to edit them.
|
05-24-2016, 10:26 PM | #2 |
All Star Reserve
Join Date: Aug 2010
Posts: 946
|
It's pretty easy if you use Excel or a spreadsheet program. Go to Game Settings > League Settings then click Export Rosters. That will export your league's rosters to a text file in the import_export folder, which is located in your league's folder in Documents (if you're using a PC). Open the text file with Excel. When the Text Import Wizard comes up, click Delimited then click Next. Then click Tab and Comma and click Finish.
At this point, the easiest way to move players around is to copy and paste the appropriate team IDs and team names (which should be columns C and D) onto the same cells in front of the players' names you want to move. Once you have moved all those, save the file as a .csv file in the import_export folder. Then click on Import Rosters and select that file. Once it imports, all your players should be moved to their new teams. If you need any more help, you can PM me here and I'll do what I can for you. |
06-08-2016, 04:38 PM | #3 |
Minors (Double A)
Join Date: Feb 2004
Posts: 140
|
I'd be careful with this. I did this with a league in OOTP15 and the import process apparently rebuilt the stats for all of the imported players; in doing so, it flipped a bit of data for college/HS stats, counting them as part of a player's major league stats for history purposes. I don't know if this is still the case in OOTP17 or not, but it's something to be wary of.
|
06-10-2016, 06:52 PM | #4 | |
All Star Reserve
Join Date: Aug 2010
Posts: 946
|
Quote:
|
|
06-13-2016, 02:03 PM | #5 | |
Minors (Double A)
Join Date: Feb 2004
Posts: 140
|
Quote:
It's unfortunate, because we run our free agency outside of the game and then assign the players to teams manually; generating import files from our FA system to get the players on teams would be a TON faster. |
|
06-13-2016, 05:01 PM | #6 |
Hall Of Famer
Join Date: Apr 2015
Posts: 7,167
|
for any mass edit, it is defnitely better for you to learn how to make use of import/export and avoid any problems associated - minor learning curve, really.
if it's individual edits, it may not be faster. however, you still might realize some time savings. looking through a spreadsheet is alot faster than clicking through players then clicking editor every single time. you can also use find and replace feature for things like team id. learn a bit more and you can write scripts to automate common things (anything that is repitition that follows a consistent logic can be automated). |
06-14-2016, 09:01 AM | #7 |
Minors (Double A)
Join Date: Feb 2004
Posts: 140
|
Oh, absolutely. We at least have scripts to add FA contract information into the player text files, and those save a ton of time. I hadn't played much with import/export rosters though because a) exporting was already well covered by csv file dumps, and b) I had been warned that using the Import function *could* lead to unforeseen consequences. Which the one time I tried it, it did*. Compare the career totals between this guy's html and his StatsLab page (where I am specifically filtering out college stats):
Player Report for #11 Julian Rubio Player Report for #11 Julian Rubio - StatsLab for OOTP15 Note the extra 13 wins in the html. This happened for every player we imported. * I resorted to trying this because I had found that I had entered all of our FA info, then found that there was another issue with the file so I had to roll it back. Rather than spending an entire afternoon re-entering FA data, I figured I would dump it from the file where all the players had been entered, then reimport it later. It worked, but it messed with college/hs stats. There are other old threads around detailing that. |
11-12-2016, 02:48 PM | #8 |
Minors (Single A)
Join Date: Jul 2013
Posts: 51
|
I work with big data for a living but so imagine my frustration whenever I try to import rosters there is an error.
Inevitably I will find duplicate players missing players etc. Any idea on what I may be missing? I've checked the Text file every line appears to have commas located in correct places, there are no duplicate player ids, all players are mapped to team ids or are free agents, all lines end in EOL etc etc Here is the process I would normally use to edit rosters: 1) export from OOTP 2) open file in excel as comma delimited 3) edit ratings etc of players 4) save as CSV 5) open CSV in Notepad and save as TXT 6) Import rosters Any help or thoughts would be greatly appreciated. Thanks |
11-12-2016, 02:51 PM | #9 |
All Star Reserve
Join Date: Aug 2010
Posts: 946
|
Don't save the .csv file as a .txt file. Just leave it as a .csv and import that file. It shoukd work then.
|
07-10-2017, 12:17 PM | #10 | |
All Star Reserve
Join Date: Apr 2003
Posts: 572
|
Quote:
|
|
01-21-2018, 06:30 PM | #11 |
Bat Boy
Join Date: Jan 2018
Posts: 2
|
Where is the export folder?
I feel really silly asking this but I cant find the folder that the exports are going to. I have attempted to toggle the hidden folder on and off in Windows but I dont have the same file structure that is displayed on the screen. I have seen you all talking about hw easy the process is and I would agree if I could just track down the file.
I also wanted to mention that the system tells me the file has been exported and does not have an error message of any kind which leads me to believe that it is there somewhere. I am referring to OOTP 17 to be clear. |
01-21-2018, 09:42 PM | #12 | |
All Star Reserve
Join Date: Aug 2010
Posts: 946
|
Quote:
|
|
01-22-2018, 01:04 PM | #13 |
Bat Boy
Join Date: Jan 2018
Posts: 2
|
Import Export
Ok so many I am doing it wrong. That path doesnt exist for some reason. I am trying to export the player data in the system prior to starting a career. Have a business trip and coming up and cant install the files on my computer but figured I would glance at the data while I am gone. If I havent played a game in the season, would that effect the folder being visible. Just did a clean reinstall prior to checking.
|
01-22-2018, 01:18 PM | #14 | |
All Star Reserve
Join Date: Aug 2010
Posts: 946
|
Quote:
|
|
Bookmarks |
|
|