-
We have updated our Community Code of Conduct. Please read through the new rules for the forum that are an integral part of Paradox Interactive’s User Agreement.
WiSK said:
I believe this refers to provinces with mines, and sets whether they can get the "New Valuable Mineral" event.
I thought so too. When moving some mines in AGCEEP we forgot to change this value, and provinces without mines got those random events.idontlikeforms said:
When mines was set to 0 it stopped.
I know but i try to find application in which i can see values etc. in row and columns.
I have a question about province.csv...
I changed the name of the cities near the end of the lines. But when the AI colonize that province it never take the name in province.csv. So I cleared colonynames.csv except for one line and retried and it was the same situation again but with a random province name owned by the colonizer (New Castilla in this case). So how can I force the colonies to have the same name than the one I set in province.csv ?
I changed the name of the cities near the end of the lines. But when the AI colonize that province it never take the name in province.csv. So I cleared colonynames.csv except for one line and retried and it was the same situation again but with a random province name owned by the colonizer (New Castilla in this case). So how can I force the colonies to have the same name than the one I set in province.csv ?
Yeah. So for each city Ill have to do a dozen country code followed by
city name and province in colonynames.csv. I didn't change the city name for just one province. I changed the city names for all the provinces. So that would be like 15000 entries in colonynames....
city name and province in colonynames.csv. I didn't change the city name for just one province. I changed the city names for all the provinces. So that would be like 15000 entries in colonynames....
idontlikeforms said:
No, but that's what I think. I also think Mine refers to whether it has a mine or not, whereas the one I was talking about determines whether that mine can get the New Deposits event, ie increase in value. Without that the mine can run out at some point.
Yes but it save the csv using "," as separator. So you have to use wordpad to search&replace all "," by ";"
There's some setting that you can do to make it use ; instead of , for .csv files. I think some language settings default to that. I usually create a copy of the file with , substituted for ; and load that into Excel then change it back after saving. (I use the command-line utility sed to do the substitution since it's faster than doing search&replace in Wordpad.)Dalosein said:
Breaking the province.csv into columns
A couple suggestions on how to make reading and editing the province.csv file easier. There are two things that I did based upon earlier posts somewhere in the forum.
First you might want to set windows to automatically deal with using ; instead of , in the file. This option in windows xp (using the classic menu option) is in control pannel as "date/time/language/regional options." (You might have to use windows help to find the option in your version of windows). Once you find it then choose regional language options then regional options then standards and formats then next to the drop down box containing for example "English US" choose the customize button and in the list change the item next to "list separator" from , to ; (One note if you do this and then use excel later on for other non EUII work sheets and you use commands such as =left(a1,1,1) etc remember to use ; instead of , in the commands)
Then go to excel and open the province.csv file. Choose Data/text to columns/deliminated/ and choose ; and excel should break the file into columns. You can then save the file and each time you open it again it should be already in columns. You don't even see the ;'s anymore and you can just edit the column values without worrying about the ;'s. There is no need to undo this - as the file in this format works fine in the game. Just always remember to save the file as a csv file type and also make a copy of the original unchanged file just in case something goes wrong.
A couple suggestions on how to make reading and editing the province.csv file easier. There are two things that I did based upon earlier posts somewhere in the forum.
First you might want to set windows to automatically deal with using ; instead of , in the file. This option in windows xp (using the classic menu option) is in control pannel as "date/time/language/regional options." (You might have to use windows help to find the option in your version of windows). Once you find it then choose regional language options then regional options then standards and formats then next to the drop down box containing for example "English US" choose the customize button and in the list change the item next to "list separator" from , to ; (One note if you do this and then use excel later on for other non EUII work sheets and you use commands such as =left(a1,1,1) etc remember to use ; instead of , in the commands)
Then go to excel and open the province.csv file. Choose Data/text to columns/deliminated/ and choose ; and excel should break the file into columns. You can then save the file and each time you open it again it should be already in columns. You don't even see the ;'s anymore and you can just edit the column values without worrying about the ;'s. There is no need to undo this - as the file in this format works fine in the game. Just always remember to save the file as a csv file type and also make a copy of the original unchanged file just in case something goes wrong.
Just to amplify on this issue, if you use the search and replace function for ; -> , in some files that will be allright, but if you do that in text.csv, for example, you won't get a proper result, because there are commas that are part of the text and they will get changed to semi-colons when you switch back, really mucking things up.
Better is to use the trick of telling Windows you use ";" as a delimiter, not comma. I did that and my Microsoft Works program (I don't have Excel) immediately started opening .csv files from the game with properly lined up columns.
Better is to use the trick of telling Windows you use ";" as a delimiter, not comma. I did that and my Microsoft Works program (I don't have Excel) immediately started opening .csv files from the game with properly lined up columns.
How exactly can you 'tell' windows to do that? I use myself the 'excel' program from Open Office btw where you can at opening/saving of a csv file determine the delimiter, but an automatic method would be preferableDSYoungEsq said:Better is to use the trick of telling Windows you use ";" as a delimiter, not comma. I did that and my Microsoft Works program (I don't have Excel) immediately started opening .csv files from the game with properly lined up columns.