GreatAugustus
Chieftain
Microsoft Access 2010 provides a clear, easy to read tables to work with. You can build/create all sorts, from technologies to resources with them. You can export them into XML too.
You need to find the vanilla you want to edit. Once done examine and copy the table columns.
Heres an example of the new eras in my mod on MSA:
Here is how to do it for XML:
1. Right click the table you want to export, then click Export -> XML
2. Deselect the schema file option.
3. Vola! your XML file complete! however, some last minuete changes:
Delete the second line (<dataroot xmlnsd="urn:schemas-microsoft-comfficedata" generated="2012-05-20T09:14:36">)
<CivExEras>Rename where appropiate. For me I have to change this to "Eras".
<ID>11</ID>
(Insert "<Row>" here)
<Type>ERA: EARLY MODERN ERA</Type>
<Description>TEXT: EARLY MODERN ERA</Description>
<Strategy>TEXT: EARLY MODERN ERA STRATEGY</Strategy>
<ArtPrefix>MODERN</ArtPrefix>
<NoGoodies>0</NoGoodies>
<NoBarbUnits>0</NoBarbUnits>
<NoBarbCities>0</NoBarbCities>
<FirstSoundtrackFirst>0</FirstSoundtrackFirst>
<ResearchAgreementCost>0</ResearchAgreementCost>
<StartingUnitMultiplier>4</StartingUnitMultiplier>
<StartingDefenseUnits>8</StartingDefenseUnits>
<StartingWorkerUnits>4</StartingWorkerUnits>
<StartingExplorerUnits>3</StartingExplorerUnits>
<StartingGold>4000</StartingGold>
<StartingCulture>5000</StartingCulture>
<FreePopulation>4</FreePopulation>
<LaterEraConstructionMod>50</LaterEraConstructionMod>
<StartPercent>100</StartPercent>
<BuildingMatinencePercent>80</BuildingMatinencePercent>
<GrowthPercent>50</GrowthPercent>
<Trainpercent>100</Trainpercent>
<ConstructPercent>100</ConstructPercent>
<CreatePercent>100</CreatePercent>
<ResearchPercent>100</ResearchPercent>
<BuildPercent>100</BuildPercent>
<ImprovementPercent>100</ImprovementPercent>
<GreatPeoplePercent>100</GreatPeoplePercent>
<CulturePercent>100</CulturePercent>
<EventChancePerTurn>10</EventChancePerTurn>
<SoundtrackSpace>0</SoundtrackSpace>
<CityBombardEffectTag>NULL</CityBombardEffectTag>
<AudioUnitVictoryScript>NULL</AudioUnitVictoryScript>
<AudioUnitDefeatScript>NULL</AudioUnitDefeatScript>
(Insert "</Row>" here)
</CivExEras>
Now for SQL. The process is longer. It's up to you whenever it's worth it:
1. Download and install SQLite Database Browser at here.
2. Export the table in MSA into an ".txt" file.
3. don't check any boxes.
4. Then a window like this will pop up: Keep the settings.
5. Set to delimited: set the seperation - must be either commas or semicolons.
6. Include field names on first row checked
7. open SQLite Database Browser
8. Click new database (new file icon)
9. Save
10. click import -> Table from CSV File
11. Extract field names from first line checked
12. Export -> Database to SQL
Vola!
- XML
- SQL
You need to find the vanilla you want to edit. Once done examine and copy the table columns.
Heres an example of the new eras in my mod on MSA:
Here is how to do it for XML:
1. Right click the table you want to export, then click Export -> XML
2. Deselect the schema file option.
3. Vola! your XML file complete! however, some last minuete changes:
Spoiler :
Delete the second line (<dataroot xmlnsd="urn:schemas-microsoft-comfficedata" generated="2012-05-20T09:14:36">)
<CivExEras>Rename where appropiate. For me I have to change this to "Eras".
<ID>11</ID>
(Insert "<Row>" here)
<Type>ERA: EARLY MODERN ERA</Type>
<Description>TEXT: EARLY MODERN ERA</Description>
<Strategy>TEXT: EARLY MODERN ERA STRATEGY</Strategy>
<ArtPrefix>MODERN</ArtPrefix>
<NoGoodies>0</NoGoodies>
<NoBarbUnits>0</NoBarbUnits>
<NoBarbCities>0</NoBarbCities>
<FirstSoundtrackFirst>0</FirstSoundtrackFirst>
<ResearchAgreementCost>0</ResearchAgreementCost>
<StartingUnitMultiplier>4</StartingUnitMultiplier>
<StartingDefenseUnits>8</StartingDefenseUnits>
<StartingWorkerUnits>4</StartingWorkerUnits>
<StartingExplorerUnits>3</StartingExplorerUnits>
<StartingGold>4000</StartingGold>
<StartingCulture>5000</StartingCulture>
<FreePopulation>4</FreePopulation>
<LaterEraConstructionMod>50</LaterEraConstructionMod>
<StartPercent>100</StartPercent>
<BuildingMatinencePercent>80</BuildingMatinencePercent>
<GrowthPercent>50</GrowthPercent>
<Trainpercent>100</Trainpercent>
<ConstructPercent>100</ConstructPercent>
<CreatePercent>100</CreatePercent>
<ResearchPercent>100</ResearchPercent>
<BuildPercent>100</BuildPercent>
<ImprovementPercent>100</ImprovementPercent>
<GreatPeoplePercent>100</GreatPeoplePercent>
<CulturePercent>100</CulturePercent>
<EventChancePerTurn>10</EventChancePerTurn>
<SoundtrackSpace>0</SoundtrackSpace>
<CityBombardEffectTag>NULL</CityBombardEffectTag>
<AudioUnitVictoryScript>NULL</AudioUnitVictoryScript>
<AudioUnitDefeatScript>NULL</AudioUnitDefeatScript>
(Insert "</Row>" here)
</CivExEras>
Now for SQL. The process is longer. It's up to you whenever it's worth it:
1. Download and install SQLite Database Browser at here.
2. Export the table in MSA into an ".txt" file.
3. don't check any boxes.
4. Then a window like this will pop up: Keep the settings.
5. Set to delimited: set the seperation - must be either commas or semicolons.
6. Include field names on first row checked
7. open SQLite Database Browser
8. Click new database (new file icon)
9. Save
10. click import -> Table from CSV File
11. Extract field names from first line checked
12. Export -> Database to SQL
Vola!
- XML
- SQL