Alright, two things.
1) Gonna try to make it clearer where I'm at right now. My hope is that this clarifies what I'm doing, but also gathers some suggestions on how to streamline the process
The goal is to put every xml tag in C2C, and every use of those tags, into Excel form. The process currently is the following:
i) Find all tags being used, by looking at the Schema files.
ii) Find all the uses of those tags. This is a multi-step process:
a) For each folder (currently only Units folder) I paste every Infos file into a separate Excel worksheet. Using Excel's Find All feature, I take every tag in the folder's schema, one by one, and do a search. This tells me in which Infos file the tag shows up. A tag may also show up in different ways inside the same file.
Doing this for the core files was pretty quick. Paste 9 files into excel, and boom. Checking for uses in the modules files, however, is proving very time-consuming. There are literally dozens and dozens of relevant xml files just for units stuff, and they're all in separate folders.
Not nearly as time consuming of the modding work that gets done around here
But still, if someone has an idea on how to streamline/speed up this process, it would be massively appreciated.
b) After I know all of these uses of the tags, I put them into the templates that Koshling's app uses to scan the XML files, and convert into beautiful table form.
Here's the things about these templates. Each template relates to one set of tags. All the tags used by PromotionInfos.xml (both core and modules) are an example of these sets. You tell the templates what the uses of the tags are, and they take all of them and export them into Excel.
For every unit (core or modular), that uses a tag in the template, they'll find it. However, one of their tags may not be in the template, because I didn't know they used it. That's the reason why I need to get all of the Infos into Excel so I can search through them faster. My concern being that one of those units in the Modules folder may use a tag that none of the core units use.
I may even know that a tag exists, and that it is used by a core unit, for example in PromotionInfos. If, however, another unit uses the same tag in SpawnInfos or whatever, that use won't show up until I find it by doing the ii) a) step.
This is why I pointed out that the templates work in sets of tags. I found that the tag was being used in promotions, so I put the use in that template, but it didn't export the spawninfos' use.
Alright, so about the tag translations.
2) How does this attachment look? I've only done AutomateInfos, and it's still a WIP, mostly for you guys to tell me if you like the way the information's presented. You can use the little arrows in each column to sort by that column, and to search and filter the data based on values in that column
