Have you had a problem preventing you from moving forward in your franchise, and no troubleshooting advice can fix it? Have you reached 30 seasons in your franchise and want to keep going? Those are two major reasons to want to convert your franchise. Doing so will allow you to start over again with the converted roster, allowing you to retain your players. Below is a step-by-step guide for converting your franchise into a roster. I recommend avoiding conversion until you can see the preseason schedule, but it will work at any point. Before beginning, make sure you have the DB Editor, as well as a roster file to house the conversion. Any roster that is tested as working can be used, but I would recommend using a copy of the FF/FI Mod's default roster.
NOTE: Always make backup copies before making big changes.
Code: Select all
*0. Before beginning, make sure there are no players on the Practice Squad team in your franchise. All players should be on one of the main 32 teams, free agents, or retired.
*1. Open your franchise file in the DB Editor.
*2. Click on the PLAY table.
*3. Export the PLAY table as a CSV file.
*4. Open the CSV file in Microsoft Excel or LibreOffice Calc.
*5. If there are any players by the name of "New Player," delete them. They will usually be at the top of the file.
*6. Hold the 'CTRL' key and select the following columns: A through F, H through P, X, AN, BH, CA, CL, and DM. Right click on any of the slected columns, and click "Delete." These columns are not used in the roster file.
*7. Click anywhere in the PGID column and click "Sort & Filter," then click "Sort smallest to largest." This is not required, but will make the next steps a little clearer.
*8. Click anywhere in the TGID column and click "Sort & Filter," then click "Sort smallest to largest." The top values should be 0, then 1, 2, and so on.
*9. Scroll to the far right of the file, and click on any empty cell. Enter the number 1. Click outside of the cell with the number 1 in it, and click on the cell again and copy it.
*10. Go back to the TGID column and select every cell in it with a value from 0 through 28. Right click and select "Paste special." Next, select "Paste Special..." in that menu. Under "Operation", click on "Add". Click "OK". This will increase every cell selected by 1.
*11. Before doing anything else, scroll down to the last cell you have selected. Click on the first unhighlited cell with the value 29. Change it to 32.
*12. Select the cell that now says 32 and copy it. Select all the cells that say 29 BELOW the cell you just changed to 32, and paste. The selected cells should now all say 32.
*13. Change all of the cells that say 30 to 31 using the same method as step 12.
*14. Click on the first unhighlited cell that says 31, and change it to 30. Then repeat step 12, changing the remaining 31s below that cell to 30s. Now verify that all changes were made correctly.
*15. Scroll down and, if you wish, delete any player with a TGID of 1014. These are retired players. This step isn't required, but will reduce the clutter in your roster.
*16. Go back to the top of the file. Click anywhere in the PFNA column and click "Sort & Filter," then click "Sort A to Z."
*17. Next, click anywhere in the PLNA column and click "Sort & Filter," then click "Sort A to Z." This will filter your roster alphabetically.
*18. Select the PGID cell of the first player in the file. Change the value to 0. Now, click off that cell and select it again. Hold the 'CTRL' and 'SHIFT' keys, and press the 'DOWN ARROW' key. This will select every cell in the PGID column.
*19. While you have the PGID cells selected, go up to the "Fill" button and click it. Then click "Series...". Make sure the "Step Value" is set to 1 and click "OK". The values should now all be unique, starting at 0 and increasing by 1 each.
*20. Repeat steps 18 and 19, but for the POID column.
*21. Scroll to the far right of the file, and delete the "1" you created earlier. Additionally, delete the only cell in the DG column. This is the count of players in the roster, and you will have problems importing if this is not deleted. After this is done, save your CSV file.
*22. Open the DB Editor, and load the roster you intend to use to house your converted franchise.
*23. Go to the PLAY table. Once it has loaded, import your modified CSV file. Once it's finished importing, save and exit.
*24. Launch Madden, and once in, load the roster file that now has your players. Make sure you're in "Roster Management". Click on the Chicago Bears, and click "Player Management". Next, click "Depth Chart", and click "Auto Reorder." Once done, do this for all remaining teams. Save the roster when finished.
*25. You can test to make sure everything is working by playing an exhibition game. You only need to stay long enough to make sure there's no immediate crashes.
*26. If everything is working, you can go ahead and create your new franchise file. Enjoy continuing your franchise!
Additionally, if you'd like a visual guide, below is a video from madden07eurocat detailing the process using his own methods, most of which are the same or similar to mine.
https://www.youtube.com/watch?v=6P9PP3RVPHo
Below, in the spoiler, are the original three guides.
Spoiler: