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.
 

Google Docs/API asset import help

Author
Knitram Relik
State War Academy
Caldari State
#1 - 2016-11-03 23:12:25 UTC
I'm trying to set up a google sheet using the IMPORTXML function to all my character assets.

I kinda get it, but if someone could help me, that would be great. I know a little VBA and I'm a fast learner but I'm stumped on this one.

"The problem with quotes on the internet is that it's really hard to verify their authenticity." - Abraham Lincoln

CowRocket Void
Of Tears and ISK
ISK.Net
#2 - 2016-11-05 00:34:01 UTC
IMPORTXML will break. I'm Sure FuzzySteve knows a way.

bleeding shadow darkness > did i just saw a red procurer? :P

Zad Murrard
Frozen Dawn Inc
Frozen Dawn Alliance
#3 - 2016-11-05 09:38:05 UTC  |  Edited by: Zad Murrard
=importxml2(CONCATENATE("https://api.eveonline.com/char/AssetList.xml.aspx?","characterID="&$B3,"&keyID="&$C3,"&vCode="&$D3),"fill-xpath-here",E3)

or if using version without last parameter

=importxml2(CONCATENATE("https://api.eveonline.com/char/AssetList.xml.aspx?","characterID="&$B3,"&keyID="&$C3,"&vCode="&$D3),"fill-xpath-here")

Where B3 contains your char Id
C3 your keyID
D3 your vCode and
E3 some random number

where it says fill-x-path-here, replace it with your xpathquery

Use importxml2 as it is more reliable than importxml.

my version http://pastebin.com/f6KmLPtW
version which most like supports much more xpath queries http://www.chrisle.me/importxml2/

Depending on the version you use, you may or may not require the last parameter E3

xpath tutorial http://www.w3schools.com/xml/xpath_intro.asp

I recommend first constructing the full query, try eg. in IE. It should show you the xml, then you can play around with xpath to get what info you want. Also note that you can make multiple xpath queries in one importxml2 call
Astrid Farnsworth
Broke and Famous
#4 - 2016-11-07 03:43:18 UTC
I want somwting like this Hope It work out for you i hace +10 carácter and just wanna know hos muchas isk do i hace between all of the.

"Amateurs talk about tactics, but professionals study logistics." - Gen. Robert H. Barrow, USMC (Commandant of the Marine Corps) noted in 1980**strong text**

Knitram Relik
State War Academy
Caldari State
#5 - 2016-11-07 11:01:10 UTC
I found this:

https://forums.eveonline.com/default.aspx?g=posts&t=6419

It has everything I needed and more.

"The problem with quotes on the internet is that it's really hard to verify their authenticity." - Abraham Lincoln

Astrid Farnsworth
Broke and Famous
#6 - 2016-11-09 02:46:57 UTC
I know this app is good for pc, but the reason why i see it useful to have a google doc spread sheep is that you could access it from where ever. talking of Cellphone.

"Amateurs talk about tactics, but professionals study logistics." - Gen. Robert H. Barrow, USMC (Commandant of the Marine Corps) noted in 1980**strong text**