by mchakko on Sun Sep 11, 2005 6:04 am
I think I know some of the problems, both related to using excel for editing, but both easily remedied.
1. Cyberfaces get messed up when editing roster because the relationship between appearance.dbf and players.dbf is based solely on the order of the fields in the spreadsheet, not by players having the same appearanceid and playerid. The trick is to sort by playerid and appearance id each time you save, that way everything is in the same order.
2. Excel for some reason changes some numerical fields to text, I believe the culprit is ISTRADEABLE or something. And this crashes a franchise. The way to fix is to open with a dbf editor, I used CDBF DBF Viewer editor, go to file, modify structure, and change the fields back to the correct "type". Use a working roster file as a base to see what type the fields are supposed to be.