The FFH Editor

[Bringa]

I'm a little bit afraid my problems might be caused by OOo, but on the off-chance that I'm just stupid:

I'm trying to use the FFH editor to do my XML work. It looks like it loads fine etc, but when I hit Export <whatever>, nothing happens. Should I get a popup informing me of the successful export or something? And where would the editor put stuff? Would it just overwrite the xml dir in the mod dir from which you opened the .xls?

I'm using OpenOffice Calc because I don't have MS Office installed (and would much rather keep it that way)

For the time being I'm editing my XML values in SciTE, but the FFH editor is of course a hundred times more convenient (and a great idea!)

 

[BeefontheBone]

IIRC, the plugin for earlier office versions to allow them to export xml files has been released by MS, so if you ask Kael nicely he might be able to switch the editor itself over to that, which would hopefully let Calc handle it. Haven't tried the editor myself, so I'm not sure exactly how it functions.

 

[Kael]

I'm a little bit afraid my problems might be caused by OOo, but on the off-chance that I'm just stupid:

I'm trying to use the FFH editor to do my XML work. It looks like it loads fine etc, but when I hit Export <whatever>, nothing happens. Should I get a popup informing me of the successful export or something? And where would the editor put stuff? Would it just overwrite the xml dir in the mod dir from which you opened the .xls?

I'm using OpenOffice Calc because I don't have MS Office installed (and would much rather keep it that way)

For the time being I'm editing my XML values in SciTE, but the FFH editor is of course a hundred times more convenient (and a great idea!)

The language the editor uses is visual basic. OO doesn't have VB scripting so although OO can be used to view the editor the export functions won't work.

 

[Bringa]

Alright, thanks for the answer! I'll either see about acquiring a copy of office or I'll stick to using SciTE's mighty regexp replace voodoo for tiring XML changes.

 

[Yoshi2942]

I use the editor a lot - though I do wish three things regarding it:

1) That it had a page which would show the tech tree based upon the XY values in the spreadsheet (probably more work than it is worth, but still something that I always find myself wishing for).

2) A macro for importing the data, so that if I have already modified the XML file by hand and then want to start editing it in the editor - I don't have to start over.

3) That all XML files were included. -- ok, in reality -- I wouldn't need all, but there is atleast one XML file which should probably have been included - BuildingClassInfo... some changes to the buildings in the CIV4buildinginfo file require changes to the classinfo as well... otherwise the game will give an error pointing to CIV4buildinginfo when in fact, the error is in the classinfo -- time I found this out took me an hour to chase down what was going on.

Though, to be honest - the editor is a great little tool.

 

[xanaqui42]

I use the editor a lot - though I do wish three things regarding it:

If you can write VB, and you have MS Excel, you could do these changes. Personally, I prefer to edit the XML directly.

 

[Yoshi2942]

I figure that I could, but that would be of assistance to me - and the third issue was one which I only found by digging around, there are likely other such issues which Kael likely knows better than I would - as he is probably more intimately involved with the code than I ever will be. Plus, these are things that the next person who opens up the editor may feel that they want.

All good though - I was just mentioning some features I had wished were included. Even without them I find it a good tool for editing the Tech tree - especially because I use formulas to determine a Tech's cost; something which would be a nitemare to try just by hand editting the XML.

 

[Bringa]

Spoiler :

Now I have MS Excel, but the button doesn't work! When I click it, it only lets me edit the text in the button! How do I actually activate that button?

Nevermind, saving it in OOo removed the macros. D'oh!

 

[Yoshi2942]

Found a bug with the editor in version .21 -- The High priests have been divided up into the different religions, but in the specific UnitClassDefense/AttackMods -- it is still listed as a single High Priest. IF you place any value in the related cells, it will cause a CTD.

 

[Kael]

Found a bug with the editor in version .21 -- The High priests have been divided up into the different religions, but in the specific UnitClassDefense/AttackMods -- it is still listed as a single High Priest. IF you place any value in the related cells, it will cause a CTD.

Good point, I'll fix it.

 

[BlazeRedSXT]

I use the editor a lot - though I do wish three things regarding it:

1) That it had a page which would show the tech tree based upon the XY values in the spreadsheet (probably more work than it is worth, but still something that I always find myself wishing for).

2) A macro for importing the data, so that if I have already modified the XML file by hand and then want to start editing it in the editor - I don't have to start over.

3) That all XML files were included. -- ok, in reality -- I wouldn't need all, but there is atleast one XML file which should probably have been included - BuildingClassInfo... some changes to the buildings in the CIV4buildinginfo file require changes to the classinfo as well... otherwise the game will give an error pointing to CIV4buildinginfo when in fact, the error is in the classinfo -- time I found this out took me an hour to chase down what was going on.

Though, to be honest - the editor is a great little tool.

1. would be nice, but it would probably be more work than its truly worth.

2. Thats one I really wish was available.

3. I find that I would rather see the Improvements and Features xmls than the BuildingClass.

Cheers!