Modding Provinces.csv

[unmerged(174159)]

Basically I refuse to sit down and make modifications to provinces via a .inc file. There's the .csv sitting there, mocking me with it's apparently irrational additions and subtractions to the edits I try to make ergo, I will dispense with the .inc for the important things, like manpower, infrastructure, rares etc. :glare:

However everytime I try and edit it, it's currently throwing a fit and breaking on me. The entire planet becomes UNKNOWN STRING WANTED and the world turns that bleghy "You forgot to put any countries in you ree-tard" colour. My hypothesis is that this is something to do with using OpenOffice Calc. Is there a recommended product to fiddle with this? Or Should I just do it in notepad and use calc to reference as I work on it?

 

[Limith]

Basically I refuse to sit down and make modifications to provinces via a .inc file. There's the .csv sitting there, mocking me with it's apparently irrational additions and subtractions to the edits I try to make ergo, I will dispense with the .inc for the important things, like manpower, infrastructure, rares etc. :glare:

However everytime I try and edit it, it's currently throwing a fit and breaking on me. The entire planet becomes UNKNOWN STRING WANTED and the world turns that bleghy "You forgot to put any countries in you ree-tard" colour. My hypothesis is that this is something to do with using OpenOffice Calc. Is there a recommended product to fiddle with this? Or Should I just do it in notepad and use calc to reference as I work on it?

I had this before.

Provinces.csv is mis-formatted by Open Office on default export iirc. You need to make sure it outputs the format correctly. Otherwise, it will work. I used OO to edit it before.

 

[unmerged(174159)]

Could you give me the details of your custom export set up please?

 

[Lyrecryer]

Your better of having Notepad++.

 

[Slavick3000]

You need to set up Calc to read and write semi-colons as separators instead of commas. That's how you can get Excel to play nice with the *.csv files. Not sure how you would go about doing that in OpenOffice though.

 

[unmerged(174159)]

Your better of having Notepad++.

It's nice, but it's really annoying tbh mate. I like using excel/calc because I can freeze the top row and hide all the superfluous columns.

You need to set up Calc to read and write semi-colons as separators instead of commas. That's how you can get Excel to play nice with the *.csv files. Not sure how you would go about doing that in OpenOffice though.

I grabbed Excel 7 before I moved, so should be ok there.