Easy way to edit province.csv?

[HalfTon Midget]

as the title suggests is there a way to edit the province.csv file?

What I'm looking to do is change all of province infra values to 100.
I've tried using a Excel like program (OpenOffice.org) but the game then stops during load-up and says there is a error with the province.csv file.

I would much rather ask how to edit the province file, then to write an event for increasing the infra (somewhere around 1500 command lines :wacko: )

Thank you in advance

 

[Ayeshteni]

Hmm, well editing the csv files are best done with a text editor (like notepad). However editing all province Infrastructure values to 100?

That will take a lot of manual work (I dont think there is a program out yet? could be wrong), that does it for you.

so open up with notepad...

Id;Name;Area;Region;Continent;Climate;Terrain;SizeModifier;AirCapacity;Infrastructure;City;Beaches;Port Allowed;Port Seazone;IC;Manpower;Oil;Metal;Energy;Rare Materials;City XPos;City YPos;Army XPos;Army YPos;Port XPos;Port YPos;Beach XPos;Beach YPos;Beach Icon;Fort XPos;Fort YPos;AA XPos;AA YPos;Counter x;Counter Y;Terrain variant;Terrain x;Terrain Y;Terrain variant;Terrain x;Terrain Y;Terrain variant;Terrain x;Terrain Y;Terrain variant;Fill coord X;Fill coord Y;;;;;;

tenth column is infrastructure, sooooooooooooooooooo, go down the list of provinces and change tenth column to 100

for example

5;PROV5;North Scotland;Scotland;Europe;Temperate;Clear;;;80;;0;1;2402;0;0;0;0;0;0;14385;1467;14387;1426;14458;1396;14436;1393;0;14426;1385;14420;1433;;;;;;;;;;;;;14376;1440;14450;1406;14426;1384;-1;-1

to

5;PROV5;North Scotland;Scotland;Europe;Temperate;Clear;;;100;;0;1;2402;0;0;0;0;0;0;14385;1467;14387;1426;14458;1396;14436;1393;0;14426;1385;14420;1433;;;;;;;;;;;;;14376;1440;14450;1406;14426;1384;-1;-1

make a big mug of coffee and have fun
EDIT: try not change seazone province to a 100 infrastructure.

Ayeshteni

 

[AlenlorDRot]

The Random Scenario Generator can create that.

Go to Province Options, check 'Set Minimum Infrastructure' and put 100 in the box 'Minimum Infrastructure'.

Uncheck all of the other province options because they change the terrain and resources.

Create the scenario and go to the db folder and your 100 infrastructure province.csv will be ready.

Make sure to keep a back up of the original just in case.

 

[HalfTon Midget]

thanks AlenlorDRot, I checked out the link/website. I have some questions though about the program.
If the only thing I wanted to change was the infra values, and I created the scenario. I would want to use it for the GC36. Would it change anything else?

I read it creates the scenario/campaign in a seperate folder and I would just need to move it to the main directory

 

[AlenlorDRot]

It will create an entire scenario, but you don't need all of that. You just need to go into the db folder that the generator makes and get the province.csv file.

Make sure to back up your original province.csv file because the generated one will have the same name and overwrite the original.

 

[unmerged(39808)]

1. Just open excel.
2. Use open file option
3. Choose province.csv
4. Change infra to 100%
5. Save
6. Exit excel

Remember to open Excel first and then the province.csv file. If you do it in that way all the inputs are going to be in separate columns. If you just double click on a file then any change you will make can corrupt the file.

If you do it my way it has to work for 100%.

 

[HalfTon Midget]

ok... alen, i used your program. Did as you mentioned, unchecked all boxes except set min infra, and set it to 100. Moved newly created province.csv to main game db directory. But when i went to create/launch a new GC36, It froze up....
As per Ayeshteni's caution I went through and checked that the seazone's (oceans) weren't changed, but as far as I can tell they all have 100 infra anyway..

Did I miss something? Or what?
Thank you

 

[unmerged(39808)]

Did you try my way?

 

[HalfTon Midget]

doomtrader.... yes i just tried it, but it now gives me an error message about the germany1936.inc file line 3.... eventhough line 3 in the .inc file is about landforts

Edit: I just put the original province.csv file bak into the db directory and the still locks up at the province load screen when I start a game

 

[AlenlorDRot]

I don't know what the problem could be as I've done it repeatedly without any problems. Certainly the save of the original should still be ok.

The landfort thing on line 3 of the german.inc file references a province id so it could mess up if the province file was corrupt.

My guess is that while you are opening the files to check them they are being corrupted. Try one from the scenario generator again without opening it.

 

[HalfTon Midget]

k, going with the premise that file was corrupted. Because I even tried replacing it with the original, which I did open up, and that was corrupted

So, I wiped HOI2 and reinstalled everything.....And used your program again to create the province file and

Holy Crap!!!!!!

It Worked
that was soooo EASY
This Is Awesome!!
I LOVE YOUR PROGRAM!!!!
Thank You for making it!!!!!!

 

[AlenlorDRot]

Sorry you had to reinstall everything. I was actually recommending that you create a new file with the generator and try it out without opening it. The generator uses a fresh version of the province file so it should have been able to give you a usable one.

But with a fresh install you know you are working with clean files. In the future I'd recommend making a folder in the game directory to store originals of any file you want to edit. It has saved me numerous times.

 

[HalfTon Midget]

yeah, I knew what you meant... but don't apologize for me messing my crap up :wacko:

I just wanted to make sure that there was nothing else that could have been messed up.

But like I said before that was the quickest/easiest mod I think I've ever done. And I also saw that I could have added more resources to the map if I wanted too....

The possibilities are almost endless for new maps

 

[johnmedgla]

Use CSVEd from http://home.hccnet.nl/s.j.francke/csved/csvedsetup.exe.

On the control panel, change 'Set Seperator' to Semi-Colon, make sure Start Row is set to 1, and 'Use as Column Captions' IS checked. Then just open province.csv and edit in blissful, trouble free ease!