william1993 Posted December 15, 2016 Share Posted December 15, 2016 how does one open the pstats file to do the scheduling fixes? Link to comment Share on other sites More sharing options...
Ragin Cajun Posted December 15, 2016 Share Posted December 15, 2016 I believe it's Microsoft Access (or something similar)...or nothing. But don't quote me as I've never done any editing. Link to comment Share on other sites More sharing options...
woolymuffler Posted December 15, 2016 Share Posted December 15, 2016 <p>I was afraid someone would ask that <img alt="" data-src="//content.invisioncic.com/g322608/emoticons/smile.png.142cfa0a1cd2925c0463c1d00f499df2.png" src="<___base_url___>/applications/core/interface/js/spacer.png" /></p><p> </p><p> The easiest way is if you have Microsoft Access. Make a copy of pstats.dat as a backup, then rename pstats.dat to pstats.mdb. Open that, make the changes and then rename the mdb file back to pstats.dat.</p><p> </p><p> </p><p> The free way is to use Apache Open Office Base (basically a free MSOffice) but it is much harder to use. I'm going to describe it verbally since I don't see how to do screenshots.</p><p> </p><p> Before anything else, make a backup copy of pstats.dat</p><p> </p><p> Download and install OpenOffice if you don't already have it (easy to find on google).</p><p> </p><p> Start OpenOffice Base (OpenOffice has a whole suite of programs; Base is their version of MSAccess)</p><p> </p><p> A Wizard opens; select the radio button "connect to an existing database" (bottom button) and then in the dropdown choose ODBC (last option in list). DON'T choose either of the Microsoft Access options in the dropdown because the OpenOffice Access driver is buggy and will crash while you are editing the database. Click Next</p><p> </p><p> On the "Set up a connection to an ODBC database" screen, click Browse.</p><p> On the Data Source popup, click Organize.</p><p> </p><p> In the ODBC Data Source Administrator popup, User DSN tab, click Add.</p><p> </p><p> In the driver selection popup, select Microsoft Access Driver (this way you are using the Access driver built into windows instead of the buggy OpenOffice driver).</p><p> </p><p> In the ODBC Microsoft Access Setup popup, put a name in the Data Source Name field (anything will work, I call mine pstats). Then click the Select button under database. Browse to the location of your pstats.dat file, change the dropdown of List Files of Type from Access Databases to All files and then select pstats.dat. Click Ok</p><p> </p><p> Click OK on ODBC Microsoft Access Setup</p><p> </p><p> Click OK on ODBC Data Source Administrator</p><p> </p><p> You now should be back in OpenOffice Data Source popup and see the data source you just created. Select it and click okay.</p><p> </p><p> Click Next on "Set up a connection to an ODBC database" screen.</p><p> </p><p> Next again on User Authentication screen (no password on DB)</p><p> </p><p> Click Finish on the "Decide How to proceed etc..." screen (be sure "Open the database for editing" is checked)</p><p> </p><p> Just hit save on the next screen (Base creates a temp database)</p><p> </p><p> And with any luck, the database will be open in edit mode. Double-click the teams table and make your edits (you can also put in real team names here and have them available at beginning of dynasty)</p> Link to comment Share on other sites More sharing options...
woolymuffler Posted December 15, 2016 Share Posted December 15, 2016 Also, most of those Base steps are just for the first time you are editing. Once the ODBC connection is created, you can reuse it and the whole thing is much easier. Link to comment Share on other sites More sharing options...
william1993 Posted December 15, 2016 Author Share Posted December 15, 2016 well I have Access so I can just do it that way Link to comment Share on other sites More sharing options...
woolymuffler Posted December 15, 2016 Share Posted December 15, 2016 Cool, Access is definitely the best way to go if you can. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.