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.
 

Attn : Google Docs Users

First post
Author
Previous Topic Next Topic
Lemkor Gengod
Stacmon Production and Trade Institue
#1 - 2015-04-22 21:22:54 UTC
If like me, you have spent the last few days scratching your head, trying to figure out why your spreadsheets using the Eve API were broken, and had been assuming it was due to the timeout issues that are being mentioned in many other posts......... It may not be!

It seems (Although I accept I may be the last person to notice) that Google has finally fixed an issue that has confused many of us for years, you now need to use capital letters in the second argument n the ImportXML command.

Eg

=importXML(ttps://api.eveonline.com/corp/WalletTransactions.xml.aspx?keyID=9999999&vCode=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx&characterID=1234567&accountKey=1006&rowcount=2560, "//row/@typeid")

now becomes

=importXML(ttps://api.eveonline.com/corp/WalletTransactions.xml.aspx?keyID=9999999&vCode=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx&characterID=1234567&accountKey=1006&rowcount=2560, "//row/@typeID")

as it always should have been.

My apologies to CCP FourFox and the rest of the Dev team who I may have cursed a few times over the last few days!Lol

LG
Soldarius
Dreddit
Test Alliance Please Ignore
#2 - 2015-04-23 15:39:54 UTC
Confirmed. I just checked it and the caps need to be caps. Now to go into every googlesheet I have (there are dozens) to make changes. Thx google. Roll

http://youtu.be/YVkUvmDQ3HY
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2015-04-23 16:51:49 UTC
Thanks for the heads up Smile

(I don't use them myself, but I know people who do)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Hel O'Ween
Men On A Mission
#4 - 2015-04-24 16:26:43 UTC
In other words: Google finally fixed their XPath parser to behave like expected.

EVEWalletAware - an offline wallet manager.