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.
 

Problem with importxml function

Author
Loki106
Brutor Tribe
Minmatar Republic
#1 - 2015-04-14 20:05:07 UTC
So, I'm trying to create a spreadsheet in google spreadsheets to calculate prices of ships and items, so I can count these up, import them and add a markup. I use eve-central api to pull xml prices, using the 'importxml' function, if I load the spreadsheet they will all pull correctly, however after some time, some of them will will return a '#N/A' result as can be seen here: http://i.imgur.com/DVbMKJF.png , because of this my further calculations won't work. The second problem lies in 'evec_api/marketstat/type/sell/max' for some reason I can only use this one, and not '/evec_api/marketstat/type/sell/min' which won't pull data for some reason. If someone could help me, that'd be appreciated as I have no clue what I'm doing wrong.
Nolen Cadmar
Caldari Provisions
Caldari State
#2 - 2015-04-15 20:58:28 UTC
import xml has been hit or miss with Eve-Central since around xmas. It seems that it may be due to EC's incorrect, or incomplete formatting?

Steve Ronuken wrote a GoogleDocs script that does the importing for you.

https://github.com/fuzzysteve/eve-googledocs-script/blob/master/EveCentralPrices.gs

Nolen's Spreadsheet Guru Services

Pre-made spreadsheets available covering market, manufacturing and more!

Custom requests welcome!

Sheet Screenshots