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.
- Board index Supreme Ruler 2010 General Discussion Modifying the Game - 2010 Mods
-
- It is currently Apr 23 2024
- All times are UTC-05:00
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
-
- Lt. Colonel
- Posts: 229
- Joined: Jan 10 2006
- Location: Baltimore
Saving .CVS files from OpenOfficeCalc Ver 2
"We have met the enemy and he is us."
Jump to
- General
- ↳ News
- ↳ Introductions
- Supreme Ruler 2030
- ↳ General Discussion - 2030
- ↳ Issues and Support (Formerly Beta Testing)
- ↳ Suggestions - 2030
- Galactic Ruler
- ↳ General Discussion - GR
- ↳ Suggestions - GR
- ↳ Issues and Support
- Supreme Ruler The Great War
- ↳ General Discussion - SRGW
- ↳ Suggestions - SRGW
- ↳ Issues and Support
- Supreme Ruler Ultimate
- ↳ General Discussion - SRUltimate
- ↳ Suggestions - SRU
- ↳ Issues and Support
- Modding
- ↳ Modding Show & Tell
- ↳ Modding Issues & Support
- Multiplayer
- ↳ Looking for a Game
- AAR - After Action Reports
- ↳ After Action Reports
- Supreme Ruler 1936
- ↳ General Discussion - SR1936
- Supreme Ruler Cold War
- ↳ General Discussion - SRCW
- ↳ Suggestions - SRCW
- ↳ Development Updates
- ↳ Issues & Support
- Supreme Ruler 2020
- ↳ General Discussion - 2020
- ↳ Development - 2020
- ↳ Production & Economy - 2020
- ↳ Military - 2020
- ↳ Diplomacy - 2020
- ↳ Feature Highlights - 2020
- ↳ Multiplayer Games
- ↳ Scenarios, Mods and More - 2020
- ↳ Support & Issues - 2020
- Supreme Ruler 2010
- ↳ General Discussion
- ↳ Scenarios
- ↳ Balance
- ↳ AI - Artificial Intelligence
- ↳ Wish List
- ↳ Modifying the Game - 2010
- ↳ Design Scenarios, Grouping Regions, Creating Missions
- ↳ Mods
- ↳ Departments - 2010
- ↳ Land and Terrain
- ↳ Diplomacy - State Department
- ↳ Economics - Treasury Department
- ↳ Production - Commerce Department
- ↳ Department of Interior - Research and Social Services
- ↳ SR2010 Support
- ↳ Military - Defense and Operations Departments
- ↳ After Action Reports
- ↳ Multiplayer Games
- Off Topic
- ↳ Off Topic Comments
- ↳ Message Board Technical Problems
- Archived
- ↳ SRU Multiplayer Games
- ↳ SRGW Multiplayer Games
- ↳ SR1936 Multiplayer Games
- ↳ SRCW Multiplayer Games
- ↳ Modding SRGW
- ↳ Modding SRUltimate
- ↳ Modding 1936
- ↳ Modding SRCW