These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Clonerworks API for Blueprint Materials Required

Author
Louis Vitton
Viziam
Amarr Empire
#41 - 2013-11-19 08:51:08 UTC
Eoghan Gorthaur wrote:
Hey man,

Thanks for this API !

I will probably use it in my site :)


Hi mate,

There is an update i am releasing hopefully tomorrow night. In short adding a second API for the blueprint calcs that allows both json and xml output.

currently it is the same as a dev URL one in the main port but there is no material multiplier as the math for this is not right and its giving some weird results at times so just removed it for the moment.
Eoghan Gorthaur
Clepsydra Bureau
#42 - 2013-11-19 09:03:24 UTC
Louis Vitton wrote:

There is an update i am releasing hopefully tomorrow night. In short adding a second API for the blueprint calcs that allows both json and xml output.

currently it is the same as a dev URL one in the main port but there is no material multiplier as the math for this is not right and its giving some weird results at times so just removed it for the moment.


I really like the chance to use this in my site, it is not an industrial site, but a shopping one. With your API it will be easy to add a batch of items need for manufacturing to the shopping lists.

I will start to work on the integration during this week and probably will take me 2-3 weeks to do it. Will be using most sure the XML version of your API, but JSON would be ok too.

Thanks :)


Florian Bao
Black Box Technologies
#43 - 2013-11-19 13:48:00 UTC  |  Edited by: Florian Bao
hi,

looks really cool!

I wonder if you could help me write a correct =ImportXML( ) function so that I can import parts of this API into my lovely google spreadsheets!


i tried a simple =ImportXML(http://dev.clonerworks.com/api2/bpcalc/xml/462) , but that does result in an parse error.
Kivorno
Myanapa Corsica
#44 - 2013-11-19 16:34:23 UTC  |  Edited by: Kivorno
A fantastic tool and will be making a lot of use of it!

Also would it be possible to add the use of implants as well?

Proud creator and developer of Eve-Merchant / Eve-Merchant Sprint

Louis Vitton
Viziam
Amarr Empire
#45 - 2013-11-20 10:24:15 UTC
Florian Bao wrote:
hi,

looks really cool!

I wonder if you could help me write a correct =ImportXML( ) function so that I can import parts of this API into my lovely google spreadsheets!


i tried a simple =ImportXML(http://dev.clonerworks.com/api2/bpcalc/xml/462) , but that does result in an parse error.


Hey mate,

I am working on some examples for this for you now and will share a page under this post once i am done.
I am by far no pro with xPath and google docs also but will assist as much as i can.

Also i planned to release some changes this even but i think it may be better to do it on the weekend as i wish to make a few more changes before i push it out.

I will look at the implants and it shouldnt be hard to put into the code.

Cheers,

louis

Thunder Jolt
Frozen Monkeys
#46 - 2013-11-20 10:59:11 UTC  |  Edited by: Thunder Jolt
Florian Bao wrote:
I wonder if you could help me write a correct =ImportXML( ) function so that I can import parts of this API into my lovely google spreadsheets!

i tried a simple =ImportXML(http://dev.clonerworks.com/api2/bpcalc/xml/462) , but that does result in an parse error.
Here is the base syntax to get all typeName for each material records under totalMaterials :

=ImportXML("http://dev.clonerworks.com/api2/bpcalc/xml/462","//totalMaterials/material/@typename")

I'm no expert but here's a little help :
in Xpath, // means take all occurences under the specified tree
And then with the @, you can recover the attribute value for each material record.

Warning : the attribute name (typename here) must be in lowercase even tho it's displayed as typeName in the xml output.

And then to get the list of minerals, same thing but with the amount attribute :

=ImportXML("http://dev.clonerworks.com/api2/bpcalc/xml/462","//totalMaterials/material/@amount")

Finally you can make only one call to the API with the concatenate function | but googledoc does not expand the result on multiple columns automaticaly :

=ImportXML("http://dev.clonerworks.com/api2/bpcalc/xml/462","//totalMaterials/material/@typename | //totalMaterials/material/@amount")

You should easily manage to make it work with that Smile
Florian Bao
Black Box Technologies
#47 - 2013-11-23 01:21:15 UTC
Thunder Jolt wrote:
Florian Bao wrote:
I wonder if you could help me write a correct =ImportXML( ) function so that I can import parts of this API into my lovely google spreadsheets!

i tried a simple =ImportXML(http://dev.clonerworks.com/api2/bpcalc/xml/462) , but that does result in an parse error.
Here is the base syntax to get all typeName for each material records under totalMaterials :

=ImportXML("http://dev.clonerworks.com/api2/bpcalc/xml/462","//totalMaterials/material/@typename")

I'm no expert but here's a little help :
in Xpath, // means take all occurences under the specified tree
And then with the @, you can recover the attribute value for each material record.

Warning : the attribute name (typename here) must be in lowercase even tho it's displayed as typeName in the xml output.

And then to get the list of minerals, same thing but with the amount attribute :

=ImportXML("http://dev.clonerworks.com/api2/bpcalc/xml/462","//totalMaterials/material/@amount")

Finally you can make only one call to the API with the concatenate function | but googledoc does not expand the result on multiple columns automaticaly :

=ImportXML("http://dev.clonerworks.com/api2/bpcalc/xml/462","//totalMaterials/material/@typename | //totalMaterials/material/@amount")

You should easily manage to make it work with that Smile


i love you
Louis Vitton
Viziam
Amarr Empire
#48 - 2013-11-23 02:43:27 UTC
Let me know how it all goes.
Steven Trux
Amarr Research Laboratories
#49 - 2013-11-23 10:25:04 UTC
Great tool, love it Blink

Could you update to rubicon please?
Louis Vitton
Viziam
Amarr Empire
#50 - 2013-11-24 06:22:41 UTC
Steven Trux wrote:
Great tool, love it Blink

Could you update to rubicon please?


The database is already on Rubicon. Only dev.clonerworks was not transferred.
dev.clonerworks.com has now been taken down for a while while i work on new content and then will update that on there.

Site has been update to new version of the API - v2.
Featuring the below:"


  • Site is now updated to bootstrap 3
  • API version 2 live on the site
  • Updated Doco and Examples also
  • Added Changes page which is still under construction
  • Added stats page
  • Added more back end logging
Louis Vitton
Viziam
Amarr Empire
#51 - 2013-11-26 00:59:36 UTC
Hi guys,

I am looking for suggestions for a new API to add to current ones i have.
Please let me know if you want anything new or anything changed!!!

Cheers,
Louis
Thunder Jolt
Frozen Monkeys
#52 - 2013-11-27 10:33:40 UTC
Louis Vitton wrote:
Hi guys,

I am looking for suggestions for a new API to add to current ones i have.
Please let me know if you want anything new or anything changed!!!

Cheers,
Louis
Hey Louis, there's something that would be really usefull to me but you'll think I'm lazy !
I have so many BPCs of different types that having the numbers + types of datacores needed for invention would help me a lot regarding automation.

I could retrieve the data from the SDE but I'm too lazy for now, I'm running with a very light version of the data dump for specific reasons.

Parsing assets -> extract BPCs of specific hangar -> call clonerworks API to retrieve datacores and Voila ! my buy list is done in a matter of seconds.

That's the main idea I had since I started using your API, if I think about something else I'll let you know Blink
Louis Vitton
Viziam
Amarr Empire
#53 - 2013-11-27 10:41:37 UTC
Thunder Jolt wrote:
Louis Vitton wrote:
Hi guys,

I am looking for suggestions for a new API to add to current ones i have.
Please let me know if you want anything new or anything changed!!!

Cheers,
Louis
Hey Louis, there's something that would be really usefull to me but you'll think I'm lazy !
I have so many BPCs of different types that having the numbers + types of datacores needed for invention would help me a lot regarding automation.

I could retrieve the data from the SDE but I'm too lazy for now, I'm running with a very light version of the data dump for specific reasons.

Parsing assets -> extract BPCs of specific hangar -> call clonerworks API to retrieve datacores and Voila ! my buy list is done in a matter of seconds.

That's the main idea I had since I started using your API, if I think about something else I'll let you know Blink



Hi mate,

I believe this will be easy to add a new API for this.
I will have a look after work.

Cheers,

Louis vitton
Howen
Sp4ce T3ch
#54 - 2013-12-01 16:00:15 UTC
Are there any subsystems blueprints?
Louis Vitton
Viziam
Amarr Empire
#55 - 2013-12-03 09:31:07 UTC
Hi guys,

Quick update.

The datacores api is done - check it out - this is only to invent!

xml example with my fav example 587 Rifter

http://api.clonerworks.com/api2/datacore2invent/xml/587

Json

http://api.clonerworks.com/api2/datacore2invent/json/587

Its simple just put the type ID you want to invent from and it will give you the datacores needed if any.

Howen,
Thank you for making me aware of this problem.
Subsystems should work and I have investigated while on lunch at work and located the fault.

I dont have any time untill the weekend but will resolve it then.

Cheers,

Louis
Thunder Jolt
Frozen Monkeys
#56 - 2013-12-03 10:48:18 UTC
Louis Vitton wrote:
Hi guys,

Quick update.

The datacores api is done - check it out - this is only to invent!

xml example with my fav example 587 Rifter

http://api.clonerworks.com/api2/datacore2invent/xml/587

Json

http://api.clonerworks.com/api2/datacore2invent/json/587

Its simple just put the type ID you want to invent from and it will give you the datacores needed if any.

Louis
Awwww yeah, thanks a lot mate !
I'll try this as soon as I get home, cheers ! Blink
Louis Vitton
Viziam
Amarr Empire
#57 - 2013-12-05 07:25:23 UTC  |  Edited by: Louis Vitton
Howen wrote:
Are there any subsystems blueprints?


Hi Howen,

I have resolved the issue that caused the subsystems not to display.

Here is an example of one:
Legion Engineering - Power Core Multiplier

http://api.clonerworks.com/api2/bpcalc/json/30169

http://api.clonerworks.com/api2/bpcalc/xml/30169
Thunder Jolt
Frozen Monkeys
#58 - 2013-12-05 09:24:01 UTC
Louis Vitton wrote:

http://localhost/api.clonerworks/public/api2/bpcalc/json/30169

http://localhost/api.clonerworks/public/api2/bpcalc/xml/30169
Might want to edit "localhost" :
http://api.clonerworks.com/api2/bpcalc/json/30169
http://api.clonerworks.com/api2/bpcalc/xml/30169

As for the Datacore API, it's working nicely for me, thanks Louis Blink
Louis Vitton
Viziam
Amarr Empire
#59 - 2013-12-06 01:52:18 UTC
Thunder Jolt wrote:
Louis Vitton wrote:

http://localhost/api.clonerworks/public/api2/bpcalc/json/30169

http://localhost/api.clonerworks/public/api2/bpcalc/xml/30169
Might want to edit "localhost" :
http://api.clonerworks.com/api2/bpcalc/json/30169
http://api.clonerworks.com/api2/bpcalc/xml/30169

As for the Datacore API, it's working nicely for me, thanks Louis Blink



Both updated. Thank you. Bit of an epic fail on my part lol.
Louis Vitton
Viziam
Amarr Empire
#60 - 2014-01-28 22:31:52 UTC
Database has been updated to Rubicon 1.1
Cache has also been cleared to prevent incorrect cached results.
Please report any errors