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.
 

XML Fail?
Author
Previous Topic Next Topic
Mortaliton
Industrialist and Manufacturers Directorate
#1 - 2011-11-05 13:12:05 UTC  |  Edited by: Mortaliton
http://api.eve-central.com/api/marketstat?typeid=17437&typeid=1225&typeid=17432&typeid=17433&typeid=19&typeid=17466&typeid=17467&typeid=1223&typeid=17428&typeid=17429&typeid=22&typeid=17425&typeid=17426&typeid=11396&typeid=17869&typeid=17870&usesystem=30002659


This is my xml link. When used in a browser i get the page fine. In excel it returns all 0's in all table slots.

google didnt help and im baffled.

will have to copy and paste the link.

Mort.


volume max volume2 min
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00

If i refresh my other xml lists that alreadyy have data, they return 0s now to
Louis Vitton
Viziam
Amarr Empire
#2 - 2011-11-06 02:47:34 UTC
DO you have your heart set on using excel or would you consider using google doc's as this is simple in google docs and in excel i know it is alot more complex then just using the link from when i looked into it i think.

search the old forums there is some information there about how to make it work.

Cheers Louis
Mortaliton
Industrialist and Manufacturers Directorate
#3 - 2011-11-06 12:52:19 UTC  |  Edited by: Mortaliton
open office or excel. not one for google docs since ill need internet to edit it.

is there any other way to import xml into excel?

whats this i hear of a msql database?
Louis Vitton
Viziam
Amarr Empire
#4 - 2011-11-07 00:47:10 UTC
Here are a couple of links i have found which may help you i didn't get a chance to read all the way though them i was in a rush;


Cheers Louis

Also you shouldn't need a MySql database just to read the xml files in excel.