| Pages: [1] :: one page |
|
|
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Arcii
Amarr
Secret Squirrel Readiness Group
Wildly Inappropriate.
   |
Posted - 2010.12.10 22:43:00 -
[1]
Hi,
I know multiple topics have already been posted in the past on how to get prices from eve-central into Google Spreadsheet, but none have actually discussed my problem. At the moment I have a spreadsheet which pulls the prices of a few PI products from eve-central api. I have one import line pulling multiple items at once (sell prices) and one import line pulling the price of a single product (buy price). For some reason they do not always update. Sometimes only one of the two manages to update, while the other gives the error that data could not be collected. Every now and then, neither will update prices. For a spreadsheet that needs to work, I find this rather frustrating. Does anyone know why this is happening and/or what I can do about it? Also, I can't find any way to set a refresh rate. Thanks for any help.
Arcii
|
Nikolai Kondratiev
Sphere Design Inc.
|
Posted - 2010.12.10 22:59:00 -
[2]
Refresh rate on Google Spreadsheet's importXML seems to be around an hour. Which must generate some huge traffic to Eve Metrics/Central with people not closing the spreadsheet tab on their browser.
So I always guessed that EM/EC had some anti-spam feature against Google and would block it every now and them.
If you want to control the refresh rate (i.e make it faster), you can add a random parameter to the URL to make google think the URL is different.
So if you wanted to get a refresh every minute, you could create a cell with the current time (without seconds) and concatenate that with XML's URL (that would add something like "&randomParameter=2010-12-10 17:42" at the end). Ofc don't do exactly that with EM/EC feeds, they'll hate you even more 
_
WTS Capital BPOs |
Arcii
Amarr
Secret Squirrel Readiness Group
Wildly Inappropriate.
|
Posted - 2010.12.11 00:01:00 -
[3]
Thanks for that information. I think I heard about that trick somewhere. I'll see if I can find the details again. Still though, the refresh rate itself does not really bother me. It's that apparently the two price checks do not always manage to get an update at the same time. It's like EC only allows you to pull an update once per so many seconds/minutes, so I can't have to importxml lines. Any idea?
|
Nikolai Kondratiev
Sphere Design Inc.
|
Posted - 2010.12.11 00:35:00 -
[4]
Depending on the size of your item list, it might be worth grouping them in a single one.
Or maybe check Google's scripting language to deal with updates (and end up with a "refresh price" button that will leave a decent delay between 2 queries) instead of the multiples importXML all hammering the server together, and also let you refresh price on demand (ofc only if that scripting language allows pulling data from another server and has some decent XML parsing functions, if not you might as well create a real application)
_
WTS Capital BPOs |
|
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |