If your looking for the most logical method to do this then you have to eliminate all the one time, next time methods. While they may seem like logical approaches, they create a situation that must be repeated with new changes.
I am building something automated, long term as well as logical. This consists of two scripts for now. The first follows simple and permanent steps.
- It parses the station production pages using my already existing parsing class that I wrote. This retrieves the items a station has listed as producing.
- Then it deletes the mined commodities as well as useless things such as newb equipment and station modx.
- Then it converts Matt Cons to Power Cons.
- Then it takes the list remaining items listed as produced by that station and iterates through them and parses the corresponding item page on JOSSH. This gives us the currently accurate ingredients.
- Then it reads my item files that list what each production item is used to make. If and only if it is a commodity.
- Then it compares the makes list for that item to the list of items produced by that station. Eliminating all items not produced there. Thus leaving a list of items produced by that commodity at that station.
- Finally it arranges all this data in an multidimensional array and then serializes it and stores it in the database.
- Then it moves to the next station.
You might think this is silly since the data is incorrect. But if Istvan gets time to finish JOSSH later this year, it will be accurate and quick.
The second script deals with the inaccuracies of the data.
- It grabs the serialized arrays from the database.
- Iterates through the arrays removing and adding items as listed above.
- Resaves the data in new table.
When JOSSH is fixed this script will simply not be run. And should there be new, non-updated changes. I can easily add them and run the script again. Any new info should be easy to obtain from fixes.txt.
So in the short term, it's a lot of work. Much less so since I'm using class objects that I have already written over time. In the long term it's low maintenance and sweet.
I have moved through the Sol and Oct Stations and am currently looking through the Quant stations. You can see what I have don so far
here.