|
quixian -> RE: 32 Team NFL League Created (2/4/2008 11:41:56 PM)
|
Importing the madden stats was a bit tricky, I'll give you a quick run down on how I did it.
1. First, I copied the data from the original spreadsheet and formatted it so it would be laid out with the MaxFB designations for player positions and rating. A copy of that spreadsheet is attached - re-name the file to .zip to unzip and view the excel sheet.
2. Next, I exported the rosters from the VPNFL database to create a .csv file.
3. Then I compared the csv file to the madden roster and copied over the columns from the madden roster for the players' first and last names, player number, position, and ratings. The ratings on the madden sheet are in the same order as they appear in the csv file.
4. I then deleted the excess lines from the bottom or the csv file - you'll note that there should be 1727 lines of player data in the .csv file (the same number as the Madden sheet).
5. Lastly, I imported the data from the csv file back into the mdb file using the editor.
Of course, there were a few problems with doing it this way:
- There were a few players that were not deleted in the original mdb when I imported the new file. I think this is due to the fact that I imported less players to the mdb than were in the file originally (see step 4 above, where the excess lines were deleted from the csv file to be imported)
- The VPNFL file contained more accurate current player and roster information. Now, I am having to go back thru the file and correct rosters, depth charts, add rookies, remove retired players, et al. Still, it's been easier than simply inputting the ratings manually, which I was doing before the new roster editor was released.
So, despite the drawbacks, I hope you get some ideas from my procedure outlined above for how you want to handle the editing work. It's going to take me at least another week or two to get the rosters close to accurate, but at least the correct players and ratings are in the mdb at this point.
Regarding player portraits, you can find quite a few at the following link: http://web.mac.com/sixwilsons/SATMods/Photos.html - Note that these were created for use in 2nd and Ten football and will need to be modified accordingly to work in MaxFB.
|
|
|
|
