open All Channels
seplocked EVE Technology Lab
blankseplocked API Export to XML Import to MS Ecell - Need Help
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

LadyOfWrath
Caldari
Ships N Stones
Quantum Forge
Posted - 2011.06.21 21:50:00 - [1]
 

I am working on a huge project for my corporation to somewhat automate some of the daily time consuming functions which take up most of our day. One of these is updating our spreadsheets to check true profit margins on various items we mass manufacture. Due to current RL workload on myself and my directors we just no longer have time to do this. I know from what little I have dug into I can export API in XML format then load it into MS Excell and specify what data to show, or I can link to eve-central. For example:

=importXML("http://eve-central.com/api/marketstat?usesystem=30000142&typeid=34&typeid=35&typeid=36&typeid=37&typeid=38&typeid=39&typeid=40","//type/sell/min")

The above formula can be used to call and display minerals, however since it pulls from eve-central direct they will eventually ban the IP. I am asking for some help to get this project started. Keep in mind this is a learning process for myself and I am trying to find the best approach for what we do. I am open to any ideas or help to teach me how to write this stuff. I figure once I can do a few things and get it going I can take off from there. Any help is appreciated.

Xander Hunt
Minmatar
Dead Rats Tell No Tales
Posted - 2011.06.22 18:43:00 - [2]
 

From what I know, the guy who hosts eve-central won't ban your IP so long you're using the service correctly. That said, i would strongly look into installing a proxy service that'll poke ANY API only after a set duration, while, your clients can hammer the hell out of your proxy, but only get the cached results.

I do this with my EVEMon clients at home and at work among three different OS's. I set the software (EVEMon for example) to talk to the public facing EVE API proxy service. The proxy will then decide if it needs to talk to the EVE API service. If it does, it'll download the raw XML data, cache it, then serve it back to the requesting client. If it doesn't need to talk to the API service, then it just sends the client the cached data. EVE-Central will never know you're hitting the service more than once.

So you'd then change your importXML to point to your proxy service and you won't have to worry about that particular detail of hammering another service.

Now, if you're not all into setting up a proxy service, contact me in-game and we can discuss details.


 

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only