Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Gribzor
Advanced Engineering and Research
|
Posted - 2011.02.19 19:03:00 -
[1]
Hey guys,
I'm making a bunch of spreadsheet for myself to use with EVE manufacturing, but I'm having a hard time importing data from EVE Market CSV files.
Even though I can of course enter the prices myself in one worksheet and link all the other worksheets to that data, it would be one hell of a lot easier to automatically do it with a macro.
Unfortunatly, it looks to be not as easy as I hoped to import data into Google Docs. Seems to be possible with Google Scripting (or what it is called), but I haven't figured out how to do it.
Any of you guys importing data into Google Docs, and if so, how do you do it?
Tnx!
|
Lutz Major
|
Posted - 2011.02.20 21:09:00 -
[2]
I don't think that it is possible to automatically (scripting) upload local files to google docs.
You must upload them manually or store them on the internet always under the same name, then you can simply hit reload and google docs will fetch the new content.
|
Sigras
|
Posted - 2011.02.21 06:07:00 -
[3]
Edited by: Sigras on 21/02/2011 06:08:14 there used to be a good tutorial on eve metrics about how to use the importXML feature to import the XML files from eve metrics/eve central
Anyway type into the cell
=ImportXML("http://api.eve-central.com/api/marketstat?typeid=34®ionlimit=10000002", "/EveCentral/type/Jita/sell/minimum")
I think that's what it is
Anyway, eve central seems to be down ATM so more on this when they come back up, but the long and short of it is that eve-central.com provides an updating XML of current market prices, "typeid=34" means thats the type ID we're going to be looking at (I think its trit) and "regionlimit=10000002" is the region we're using to look up the prices (I think its jita)
if you type that first part into a web browser it will show you an XML file with all of the data in it, the second part just tells google docs where to point to in the XML to pull the data because that XML has a TON of data in it.
In this case, we're looking into the jita region at the minimum sell orders.
Edit Grrrr . . . then I re-read the OP and figured out that wasnt what you were talking about . . .
|
Cerrydwin
|
Posted - 2011.02.25 02:23:00 -
[4]
Interesting... I briefly had that running for the last month or two that eve metrics was up, but I'm having trouble with eve central. I can get to the xml response directly, but using an ImportXML query never seems to load in google spreadsheets.
for reference: =ImportXML("http://api.eve-central.com/api/marketstat?typeid=16634®ionlimit=10000002", "/evec_api/marketstat/type/sell/avg") which should input the average Jita sell order price for atmospheric gases.
I also tried "type/sell/avg" and "/marketstat/type/sell/avg"as my xpath query, with no luck. Is anyone using this successfully?
|
UfoTRADER
Relentless Technologies Quod Erat Demonstrandum
|
Posted - 2011.03.16 21:01:00 -
[5]
Edited by: UfoTRADER on 16/03/2011 21:05:16
Originally by: Cerrydwin Edited by: Cerrydwin on 25/02/2011 02:31:24 Interesting... I briefly had that running for the last month or two that eve metrics was up, but I'm having trouble with eve central. I can get to the xml response directly, but using an ImportXML query never seems to load in google spreadsheets.
for reference: =ImportXML("http://api.eve-central.com/api/marketstat?typeid=16634«ionlimit=10000002", "/evec_api/marketstat/type/sell/avg") which should input the average Jita sell order price for atmospheric gases.
I also tried "type/sell/avg" and "/marketstat/type/sell/avg"as my xpath query, with no luck. Is anyone using this successfully?
update: the following query will produce the Jita average sell prices for all raw moon materials in alphabetical order, in one column and 20 rows.
=ImportXML("http://api.eve-central.com/api/marketstat?typeid=16634&typeid=16643&typeid=16647&typeid=16641&typeid=16640&typeid=16650&typeid=16635&typeid=16648&typeid=16633&typeid=16646&typeid=16651&typeid=16644&typeid=16652&typeid=16639&typeid=16636&typeid=16649&typeid=16653&typeid=16638&typeid=16637&typeid=16642«ionlimit=10000002", "/evec_api/marketstat/type/sell/avg")
Instead of «ionlimit=10000002, it has a registered icon.
=ImportXML("http://api.eve-central.com/api/marketstat?typeid=16634&typeid=16643&typeid=16647&typeid=16641&typeid=16640&typeid=16650&typeid=16635&typeid=16648&typeid=16633&typeid=16646&typeid=16651&typeid=16644&typeid=16652&typeid=16639&typeid=16636&typeid=16649&typeid=16653&typeid=16638&typeid=16637&typeid=16642&R E G I O N limit=10000002", "/evec_api/marketstat/type/sell/avg")
This one is wrong, which I also ran into on multiple browsers and multiple operating systems
&typeid=16642«ionlimit=10000002",
hoursStatistics from the last X specified hours. typeidCan be specified more than once minQminimum quantity in an order to consider it for the statistics regionlimitRestrict statistics to a region. usesystemRestrict statistics to a system.
Example, =importXml("http://api.eve-central.com/api/marketstat?&hours=6&typeid=11549&usesystem=30000142&minQ=5000","//buy/max")
|
Jin Kass
|
Posted - 2011.03.16 22:05:00 -
[6]
Edited by: Jin Kass on 16/03/2011 22:08:21 This evening i tried to import eve central datas by the 'importxml' function of google doc.
It worked but the only values i get back were all "0.00" i don't know why.
So i used the "importdata" to import the whole .xml sheet in the spreadsheet and all fields were 0.00.
Some would say that eve central was down but typing the xml adress in a new browser window opened it with the right values.
Someone could tell me why?
|
UfoTRADER
Relentless Technologies Quod Erat Demonstrandum
|
Posted - 2011.03.16 22:20:00 -
[7]
Originally by: Jin Kass Edited by: Jin Kass on 16/03/2011 22:08:21 This evening i tried to import eve central datas by the 'importxml' function of google doc.
It worked but the only values i get back were all "0.00" i don't know why.
So i used the "importdata" to import the whole .xml sheet in the spreadsheet and all fields were 0.00.
Some would say that eve central was down but typing the xml adress in a new browser window opened it with the right values.
Someone could tell me why?
Paste your =importxml value and I will look at it, but I have ran into a multitude of weirdness at times. I can't for certain determine if it's EC or Google, but in more cases than not I suspect it's Google not liking the =importxml.
|
Jin Kass
|
Posted - 2011.03.16 22:48:00 -
[8]
It work now, but didn't change anything since the last time...
|
Jin Kass
|
Posted - 2011.03.17 07:54:00 -
[9]
New issue:
Google doc only support 50 xml import per spreadsheet.
Anyone find a way to pass through this limit?
|
Ramakilla
|
Posted - 2011.04.14 21:00:00 -
[10]
Found out how to work around the limit without using multiple spreadsheets. I'm pretty stoked right now. |
|
Mordiss Nex
|
Posted - 2011.05.12 21:46:00 -
[11]
Originally by: Ramakilla Found out how to work around the limit without using multiple spreadsheets. I'm pretty stoked right now.
Would you be so kind as to share please? |
Gelvina
|
Posted - 2011.06.29 11:46:00 -
[12]
You can import multiple items with one XML command..
=importXML("http://api.eve-central.com/api/marketstat?typeid=34&typeid=35&typeid=36&typeid=37&typeid=38&typeid=39&typeid=40&typeid=11399&minQ=5000®ionlimit=10000002","//all/median")
that imports all the mineral prices in jita for example.. it fills up the cells below the one you put this in.
|
Joe SMASH
You Got A Purty Mouth
|
Posted - 2011.06.29 14:00:00 -
[13]
Google is your friend! http://thisurlnotfound.com/2011/06/carebear-mode-using-spreadsheets-in-space/ -----------------------------------
More stuff goes here. |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |