Saving .CVS files from OpenOfficeCalc Ver 2

If you have the desire to modify SR2010 here is where you can discuss and share your designs and ideas. NOTE: Mods are a change to the original program and are not supported by BattleGoat Studios.

Moderators: Balthagor, Legend, Moderators

Post Reply
felinis
Lt. Colonel
Posts: 229
Joined: Jan 10 2006
Location: Baltimore

Saving .CVS files from OpenOfficeCalc Ver 2

Post by felinis »

The problem - Microsoft Excel will edit the SR2010 .CVS data files and save them just fine.

Since many of us only have access to Excel at work, we have to use OpenOffice Calc., the latest verion of which is 2.2. But Calc will not save your .CVS files in the same format that it read them in - it places double quotation marks around all cells that contain text. The SR2010 Map Editor doesn't like this and will choke reading the file.

The solution - Back up your target .CVS file. Read the .CVS file into Calc and set up your column sizes and split screen as you like it. Make your edits. Save it as an OpenOffice (.ods) file. Do not close Calc, but perform a second "Save As". Save the spreadsheet as a .CVS file. Calc will offer to save it as an Open Office file instead of a .CVS. Choose .CVS.
You will be prompted for formatting info - leave the data seperator as a comma character, but for the string delimiter, delete the double quote default and make the string delimiter null, nothing, nada, no character, not even a space. Save your work to the appropriate filename.

The next time you make an edit, open the .ods file instead of the .CVS file. All of your formatting will still be there, editing will be a snap and your "Save As" .CVS files will be usable without the extra step.

This seems to work fine for the SRUNITS.CVS file, but I cannot vouch for other data files. The output of the SRUNITS file is not exactly like the original - in the original, the column header labels are in double quotes. In this new saved version, there are NO strings in double quotes, but that doesn't seem to matter.
"We have met the enemy and he is us."
Post Reply

Return to “Mods”