OOTP Developments Forums - View Single Post

3fbrown · 09-30-2010, 05:53 PM

Just to respond to Spritze, I have done some experimenting with editing the master.csv file, and here is what I have found. Editing the databases works fine when edited with a text editor (TextEdit on Mac, Notepad on PC). It also works fine when edited with Excel on a PC. It fails when edited with Excel on a Mac, or with OpenOffice spreadsheet on either platform. I deleted the .odb file in all cases.

I don't know what any of this means, but my suspicion is that OpenOffice and Excel (sometimes) saves the files in such a manner that the format of the dates can be messed up, to the extent that OOTP cannot read some of them. But I don't really know, and it isn't my goal to troubleshoot to that extent. But I do hope this is not a problem in future releases, because I like to run my historical league with a certain logic that is not supported by currently available databases, so I would like to option of creating that database myself.

09-30-2010, 05:53 PM	#14
3fbrown Major Leagues Join Date: May 2008 Posts: 414	Just to respond to Spritze, I have done some experimenting with editing the master.csv file, and here is what I have found. Editing the databases works fine when edited with a text editor (TextEdit on Mac, Notepad on PC). It also works fine when edited with Excel on a PC. It fails when edited with Excel on a Mac, or with OpenOffice spreadsheet on either platform. I deleted the .odb file in all cases. I don't know what any of this means, but my suspicion is that OpenOffice and Excel (sometimes) saves the files in such a manner that the format of the dates can be messed up, to the extent that OOTP cannot read some of them. But I don't really know, and it isn't my goal to troubleshoot to that extent. But I do hope this is not a problem in future releases, because I like to run my historical league with a certain logic that is not supported by currently available databases, so I would like to option of creating that database myself.