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.
 

A little XML help? :)
Author
Previous Topic Next Topic
xXThe EntityXx
Nobody in Local
Deepwater Hooligans
#1 - 2014-03-27 18:21:09 UTC
First off I'm not sure if this is the place for questions, if this isn't supposed to be here please move/delete it.

https://www.fuzzwork.co.uk/blueprints/xml/24692/30/5

I'm trying to pull data from here, particularly the "actualquantity" for each "material name" under the "basematerials" section. I however can't figure out for the life of me how to call this particular set of data. I've pulled from eve-central API before the this format is different, and I know nothing but absolute basics when it comes to XML.

http://gyazo.com/05b62642fadd2ad36141862e5126c8ed

http://gyazo.com/bf00b3d9494c68fc5f73a2cf5a7bd6f6

This is what i tried, the first one gives a "The Xpath query did not return any data" so it's pretty obviously wrong. The second gives a parse error. I've done some heavy googling but all the guides I've found are pulling from HTML from websites which looks completely different.

All help is appreciated, maybe I'll learn a little more about XML. :)
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2014-04-12 21:15:25 UTC
What I'd suggest you do is pull all of the condensed attribute with
"//basematerials/[@condensed]" then put that through a split function =split(A1,";")

So you get all the materials, in a way that's simple to look up with a vlookup (and you don't have to care so much about the order stuff comes out in) And it means you can pull the whole lot with just one or two lookups. Smile

if you really just want to get the isogen from base materials
//basematerials/material[@name='isogen']/@actualquantity

will probably do it.

=importxml("https://www.fuzzwork.co.uk/blueprints/xml/24692/30/5","//basematerials/material[@name='Isogen']/@actualquantity")

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter