Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Iris Bravemount
The Golden Gaze
84
|
Posted - 2012.09.26 14:52:00 -
[1] - Quote
First of all, I'd like to know if the following things are possible:
1) Fetch the average price of a given item in a given station. (I am pretty sure you can do this, just want to be sure).
2) Fetch the required materials and the production time for a given BPO/BPC in my corp hangar.
3) Put the above two in an Excel or Google doc spreadsheet.
4) Being able to refresh the data in one (or just a few) click(s), without it refreshing automatically so as not to spam the API server needlessly.
Simple answers please, just YES/NO, maybe a link to a tutorial. I'll figure the rest out by myself. I accidentally... the bookmark. How much is it worth? |
Steve Ronuken
Fuzzwork Enterprises
671
|
Posted - 2012.09.26 15:06:00 -
[2] - Quote
1: Not from the Eve API. It has no market functionality. But there are sites like eve central, eve market data and eve marketeer which provide an api you can use. Consider using the percentile price, rather than the average. It's an average from a simulated buy/sell of 5% of the market. weeds out the highs and lows.
2: No api for this. The details are all in the database extract. There are a bunch of caveats you have to take into account with them. However, check out the blueprint calculator on the site in my sig. the bare tables or xml option would likely be of interest to you.
3: Entirely doable. Excel is easier, as it handles XML better.
4: Again, easily doable. You'd be using the import from web option which embeds the results as a datasource you can reload.
You'll probably also want to grab the typeid export from the front page of my site. most api stuff works on typeids, rather than typenames, so I dumped a csv of them in a form useful for vlookups (typeid, typename, typeid for bidirectional lookups) FuzzWork Enterprises http://www.fuzzwork.co.uk/ Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities. |
Iris Bravemount
The Golden Gaze
84
|
Posted - 2012.09.26 16:20:00 -
[3] - Quote
Steve Ronuken wrote:1: Not from the Eve API. It has no market functionality. But there are sites like eve central, eve market data and eve marketeer which provide an api you can use. Consider using the percentile price, rather than the average. It's an average from a simulated buy/sell of 5% of the market. weeds out the highs and lows.
Ok, that's what I thought. Thanks.
Quote: 2: No api for this. The details are all in the database extract. There are a bunch of caveats you have to take into account with them. However, check out the blueprint calculator on the site in my sig. the bare tables or xml option would likely be of interest to you.
If I can't fetch the ME and PE levels of my BPs somehow, I would still have to enter them all manually, which somewhat ruins the whole point of making my spreadsheet.
Quote:3: Entirely doable. Excel is easier, as it handles XML better.
I copied the example form the EvE central tutorial in Excel 2010 and got an error. Copied it into google docs and it worked. Got an idea for this one ?
Quote:4: Again, easily doable. You'd be using the import from web option which embeds the results as a datasource you can reload.
Good, thanks.
Quote:You'll probably also want to grab the typeid export from the front page of my site. most api stuff works on typeids, rather than typenames, so I dumped a csv of them in a form useful for vlookups (typeid, typename, typeid for bidirectional lookups)
Nice site. Will definately bookmark it. I accidentally... the bookmark. How much is it worth? |
Steve Ronuken
Fuzzwork Enterprises
671
|
Posted - 2012.09.26 17:34:00 -
[4] - Quote
ME and PE for blueprints are /kinda/ retrievable from the API. I was talking about the actual material requirements.
When I say kinda retrievable, you can pull the details from the industry api for the last bunch of jobs you've run. Which will include the numbers.
Everything else is manual, I'm afraid. The assets API doesn't hold it.
For excel:
Take your eve central api url http://api.eve-central.com/api/marketstat?typeid=34&typeid=35®ionlimit=10000002 for example. Then go to the data tab and hit 'import from web' (iirc). Paste in the url. It should ask a few questions then add it to the specified worksheet as a table. FuzzWork Enterprises http://www.fuzzwork.co.uk/ Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities. |
Iris Bravemount
The Golden Gaze
84
|
Posted - 2012.09.26 19:53:00 -
[5] - Quote
Thank you very much, you really helped me a lot!
So, if I enter the ME and PE levels manually, can I use your web based BPO calculator to send my input to it and get the required materials sent to my spreadsheet?
This way I could only put in the ME and PE levels and get all the calculations done with formulas and web imports for prices.
I accidentally... the bookmark. How much is it worth? |
Steve Ronuken
Fuzzwork Enterprises
671
|
Posted - 2012.09.26 20:35:00 -
[6] - Quote
Yup.
FuzzWork Enterprises http://www.fuzzwork.co.uk/ Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities. |
Iris Bravemount
The Golden Gaze
84
|
Posted - 2012.09.26 20:39:00 -
[7] - Quote
Steve Ronuken wrote:Yup.
Awesome! I accidentally... the bookmark. How much is it worth? |
Iris Bravemount
The Golden Gaze
84
|
Posted - 2012.09.26 22:04:00 -
[8] - Quote
Ok, I got this far:
http://www.fuzzwork.co.uk/blueprints/xml/12056/20/5
How can I also set my PE and Industry skill levels in the request? I accidentally... the bookmark. How much is it worth? |
Steve Ronuken
Fuzzwork Enterprises
671
|
Posted - 2012.09.27 09:37:00 -
[9] - Quote
Your ME and Production efficiency is handled there. (just to make sure we're talking about the right PE.)
I didn't implement the times on it, though those are simple enough for you to add locally.
If the BP PE is less than 0
time=productiontime*(1-((productionmodifier/productiontime)*(Blueprint PE-1)));
if it's higher:
time=productiontime*(1-((productionmodifier/productiontime)*(Blueprint PE/(1+Blueprint PE))));
Where time is the blueprints inherent times.
To get the time with your industry included:
time * (1 - (.04 * Your industry))
I may go and add the time calculations in to the xml output, but that'll be a while. (I'm at work) FuzzWork Enterprises http://www.fuzzwork.co.uk/ Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities. |
Iris Bravemount
The Golden Gaze
84
|
Posted - 2012.09.27 10:22:00 -
[10] - Quote
Steve Ronuken wrote:Your ME and Production efficiency is handled there. (just to make sure we're talking about the right PE.) I didn't implement the times on it, though those are simple enough for you to add locally. If the BP PE is less than 0 time=productiontime*(1-((productionmodifier/productiontime)*(Blueprint PE-1))); if it's higher: time=productiontime*(1-((productionmodifier/productiontime)*(Blueprint PE/(1+Blueprint PE)))); Where time is the blueprints inherent times. To get the time with your industry included: time * (1 - (.04 * Your industry)) I may go and add the time calculations in to the xml output, but that'll be a while. (I'm at work)
Oh, yeah, I may just as well put the formula in the spreadsheet, that should do.
Now I'm running into a completely different problem. When I manually type in something like this:
http://www.fuzzwork.co.uk/blueprints/xml/21038/50/5
I get an empty xml file. The map is there, but the content isn't, although it recognizes the TypeID correctly. Is there something else I need to put in the request URL ? I accidentally... the bookmark. How much is it worth? |
|
Steve Ronuken
Fuzzwork Enterprises
671
|
Posted - 2012.09.27 11:43:00 -
[11] - Quote
It works by the id of what you're making, rather than the ID of the blueprint that you're using. FuzzWork Enterprises http://www.fuzzwork.co.uk/ Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities. |
Iris Bravemount
The Golden Gaze
84
|
Posted - 2012.09.27 11:45:00 -
[12] - Quote
Steve Ronuken wrote:It works by the id of what you're making, rather than the ID of the blueprint that you're using.
Oh, ok ! I accidentally... the bookmark. How much is it worth? |
Iris Bravemount
The Golden Gaze
84
|
Posted - 2012.09.27 13:19:00 -
[13] - Quote
Hmm, your XML map spits out the mineral amounts in lines instead of columns because the various minerals are attributes of the "material" element, resulting in somthing like this:
< totalamount > < material type="tritanium" id="34" amount="123" > < material type="pyerite" id="35" amount="123" > < /totalamount >
Is there a way (or another site) to get something more like this?
< totalamount > < tritanium id="34" > 123 < /tritanium > < pyerite id="35" > 123 < /pyerite > < /totalamount > I accidentally... the bookmark. How much is it worth? |
Steve Ronuken
Fuzzwork Enterprises
671
|
Posted - 2012.09.27 14:17:00 -
[14] - Quote
Iris Bravemount wrote:Hmm, your XML map spits out the mineral amounts in lines instead of columns because the various minerals are attributes of the "material" element, resulting in somthing like this:
< totalamount > < material type="tritanium" id="34" amount="123" > < material type="pyerite" id="35" amount="123" > < /totalamount >
Is there a way (or another site) to get something more like this?
< totalamount > < tritanium id="34" > 123 < /tritanium > < pyerite id="35" > 123 < /pyerite > < /totalamount >
http://www.fuzzwork.co.uk/blueprints/xml2/12056/20/5/0/5
Type id, ME, Production efficiency skill, Blueprint PE, Industry FuzzWork Enterprises http://www.fuzzwork.co.uk/ Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities. |
Iris Bravemount
The Golden Gaze
84
|
Posted - 2012.09.27 14:21:00 -
[15] - Quote
Steve Ronuken wrote:Iris Bravemount wrote:Hmm, your XML map spits out the mineral amounts in lines instead of columns because the various minerals are attributes of the "material" element, resulting in somthing like this:
< totalamount > < material type="tritanium" id="34" amount="123" > < material type="pyerite" id="35" amount="123" > < /totalamount >
Is there a way (or another site) to get something more like this?
< totalamount > < tritanium id="34" > 123 < /tritanium > < pyerite id="35" > 123 < /pyerite > < /totalamount > http://www.fuzzwork.co.uk/blueprints/xml2/12056/20/5/0/5Type id, ME, Production efficiency skill, Blueprint PE, Industry
You rock :) I accidentally... the bookmark. How much is it worth? |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |