Modding OOBs

[norb]

I wonder if open office is putting quotes in the cells. I don't have it or I would check. If someone would just paste the csv output of some lines from an open office csv we could see what the problem is.

[Marching Thru Georgia]

Norb:
I did some checking concerning Open Office after Little Powell mentioned it, and it turns out that the program puts extra commas in for blank cells. So all rows need to be exactly the same length and no extra columns beyond the last cell that contains data. It's definitely not the program to use in modding SOW. It might be a good idea to mention this in the SDK manual.

[Jim]

I did a test with version 3.2.0 of Open Office Calc. With the default settings, it was adding a quotation mark as a delimiter around each text field. This does not work at least for battlescript.csv files:

Default values:
"Time","ID NAME","Command","X Coord","Z Coord","time var"
,"TDIH Day 1",,,,
10:00:00 AM,"OOB_U_GGMeade","hideunit",,,
10:00:00 AM,"OOB_C_JLongstreet","Ahideunit",,,
10:00:00 AM,"OOB_C_RRansom","Ashowunit",,,
10:00:00 AM,"OOB_C_RRansom","detach",,,
10:00:00 AM,"OOB_C_RRansom","Amoveto",96252,90783,
10:00:00 AM,"OOB_C_RRansom","orders:attack",,,
10:00:00 AM,"OOB_C_RRansom","Tactics:5",96252,90783,
10:00:00 AM,"OOB_U_GSykes","courier:OOB_U_SWCrawford:loadscreen:Courier:TD_1_1",,,
10:00:01 AM,"OOB_U_GSykes","hideunit",,,
10:00:20 AM,,"logmsg:courier:TD_1_1",,,
,,,,,
10:40:00 AM,,"endscenario",,,


When you open a csv file in OO, a dialog box pops up. In the separator section of this popup, the default in 'Text delimiter' is: ". If you erase this and then open the file, it saves the resulting csv file without the extra "s and the resulting battlescript.csv file runs correctly. So far I have not found a way to make this the default behavior so you have to remember to do it every time you load a csv file with OO. :unsure:

With text delimiter value erased on load:

Time,ID NAME,Command,X Coord,Z Coord,time var
,TDIH Day 1,,,,
10:00:00 AM,OOB_U_GGMeade,hideunit,,,
10:00:00 AM,OOB_C_JLongstreet,Ahideunit,,,
10:00:00 AM,OOB_C_RRansom,Ashowunit,,,
10:00:00 AM,OOB_C_RRansom,detach,,,
10:00:00 AM,OOB_C_RRansom,Amoveto,96252,90783,
10:00:00 AM,OOB_C_RRansom,orders:attack,,,
10:00:00 AM,OOB_C_RRansom,Tactics:5,96252,90783,
10:00:00 AM,OOB_U_GSykes,courier:OOB_U_SWCrawford:loadscreen:Courier:TD_1_1,,,
10:00:01 AM,OOB_U_GSykes,hideunit,,,
10:00:20 AM,,logmsg:courier:TD_1_1,,,
,,,,,
10:40:00 AM,,endscenario,,,

-Jim

[norb]

Thanks Jim.