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.
 

Assets and Google Docs

Author
Carisamina
Perkone
Caldari State
#1 - 2012-03-02 17:39:34 UTC  |  Edited by: Carisamina
Is there a way to potentially use a join( or a concatenate( command in google docs to add values in the middle of an importXML( command?

Quote:
importXML(H1,"sum(//row[@itemid='1004889020808']//row[@typeid='16475']/@quantity)")


I want to potentially add a concatenate( to the typeid='' section of this pull. In hopes I can have the one pull in one cell then use =continue to continue the return value down. Say have one row with different typeid's and then have the concatenate condense them all into one formula. For example these items are in that same container I want to query the quantities on.

  • 16475
  • 6811
  • 11359
  • 566
  • 3947
  • 567
  • 5087
  • 6921
  • 6807
  • 7487



I have used a similar syntax with eve-central but the value was returned at the end of the URL not in the middle.

Quote:

importXml(concatenate(http://eve-central.com/api/marketstat?regionlimit=10000002&hours=71&typeid=,$B2,$D$9), "//sell/min")


That is what I used successfully for eve-central but now with the eve api I can't seem to get google to let me insert that kind of function in the middle of the importxml syntax.

I probably described this horribly, so sorry if I did. Any help would be greatly appreciated.

EDIT:

The more I think about this the more I think it can't be done. It worked for eve-central because the way you can query multiple &typeid= in one XML export. This isn't how the eve API works from my understanding. I guess I am going to have to import all contents of that container into a sheet and then Vlookup through that sheet to return only quantity values on our display sheet.

EDIT:

How can I get the eve API to only return the entire table of this location instead of querying specific sections?

Quote:
row itemID="1004889020808" typeID="17368" quantity="1" flag="116" singleton="1" rawQuantity="-1"


Using returns nothing (that format i used successfully with eve-central.

Quote:
importXML(H1,"//row[@itemid=1004889020808]")
Scrapyard Bob
EVE University
Ivy League
#2 - 2012-03-03 00:13:12 UTC
Well, what root goal are you trying to reach?

Asset values? Inventory levels? (In which case jEVEAsset's stockpile feature is probably the best choice.)
Carisamina
Perkone
Caldari State
#3 - 2012-03-03 01:45:43 UTC  |  Edited by: Carisamina
Inventory levels so we know when items are low so we can produce those items to bring stock back to an optimal level. It has to be viewed by multiple people, so that's why I wanted google docs.

EDIT:

Well after many hours I got it working the way I want. I got my buddy to write me a PHP script that shaved off most of the corp asset api XML and only left me with the usefull stuff I wanted, making it a million times easier to manipulate in google docs.