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.
 

(need help) XML import to spreadsheet from skill attributes and rank
Author
Previous Topic Next Topic
Samuel Sachs
#1 - 2017-01-22 15:25:33 UTC
Hi,

sitting here a couple hours and try to get the import from attributes and rank for skills in a spreadsheet, but tbh i am lost and maybe someone can help me with this.

https://api.eveonline.com/eve/SkillTree.xml.aspx

My try:

=importxml("https://api.eveonline.com/eve/SkillTree.xml.aspx?keyID="&C1&"&vCode="&E1&"", "eveapi/result/rowset[@name='skills']/row/@rank")


But no luck so far, i am sure i am just to much of a noob and fail with missing a simple command but as i said im lost and my brain is dry after a few hours working with this...

SheetMon_V2 a gdocs spreadsheet what pulls lots of stuff, feel free to make a copy :-)
Blacksmoke16
Resilience.
#2 - 2017-01-22 16:04:30 UTC
Here you go

=IMPORTXML("https://api.eveonline.com/eve/SkillTree.xml.aspx?keyID="&N1&"vCode="&O1,"//rowset[@name='skills']//rank")

The rank is just text in an element not an attribute so you do not need the @ symbol.
Samuel Sachs
#3 - 2017-01-22 21:33:09 UTC  |  Edited by: Samuel Sachs
Thank you man!

One thing what is confusing my 2 braincells at this moment is when you open this sheet and you see what calls i make, then you see the attributes are not matching, any idea why ???

On the very bottom you see no attributes from the panic module but im not sure if my call is wrong?

https://docs.google.com/spreadsheets/d/14teKdDOmErPupoDVrrzcD_IrO5MdoK-gF1Fk1Fgjha4/edit#gid=1898299580

SheetMon_V2 a gdocs spreadsheet what pulls lots of stuff, feel free to make a copy :-)