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.
 

Google Docs: Service invoked too many times for one day: urlfetch

First post
Author
Previous Topic Next Topic
CJ Alland
CB Trading
#1 - 2015-06-20 23:47:11 UTC
So from what I understand gdocs limits you on things that are kinda key to keeping a traders spreadsheet operational. Currently I have been using up the quota within a few hours of gaining access to it again.

https://developers.google.com/apps-script/guides/services/quotas

My question is has anyone yet managed to find away around this? It's making my trading a nightmare. I cannot trade more than a few billion isk a day before losing my coverage of the market.

o7
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2015-06-21 16:46:34 UTC
Other than multiple accounts, no real way round it.

Unless you can reduce the number of lookups you're doing. Or, I suspect in your case reduce the volume that you're pulling.

(more likely to be hitting 50MB per day, than 20,000 lookups per day. )

Really, I suspect the route you're going to have to take is one of the following:
Use Excel locally (a touch painful, but doable)
Learn a programming language, and write something in that to do the work, to display to a web page.


The second option is the better one, really. But requires more brain sweat. It is, however, significantly more flexible.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
CJ Alland
CB Trading
#3 - 2015-06-21 19:11:22 UTC
Steve Ronuken wrote:
Other than multiple accounts, no real way round it.

Unless you can reduce the number of lookups you're doing. Or, I suspect in your case reduce the volume that you're pulling.

(more likely to be hitting 50MB per day, than 20,000 lookups per day. )

Really, I suspect the route you're going to have to take is one of the following:
Use Excel locally (a touch painful, but doable)
Learn a programming language, and write something in that to do the work, to display to a web page.


The second option is the better one, really. But requires more brain sweat. It is, however, significantly more flexible.



Perhaps I can remove all of the T1 items from the lookup list. That would reduce the amout of items compared.

Not that I trade many of them.

I'm not sure if my problem is coming from adding a crest regional selling volume to the works or the just sheer volume of items I actually compare.

Why is there even a limit? Seems silly having an Import function if it's limited.



anyway,


The programing you mentioned. I don't know how to code, I can kinda read it but meh. Where would you suggest starting?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2015-06-21 21:54:07 UTC
Where to start is always a problem.

Knowing what you actually want is important.

In general I'd suggest, these days, learning python (for running something locally, using something like Requests for actually getting the data. Though evelink wraps that up for you.

Then maybe dumping the information into an sqlite database, before you process it. (I'm not a good teacher, I'm afraid)



Quick question:
How are you importing things? lots of importxml requests, or something like my loadRegionPrices script? The second is more efficient, as it makes one request for a bunch of items at a time.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
CJ Alland
CB Trading
#5 - 2015-06-21 22:30:13 UTC
Steve Ronuken wrote:
Where to start is always a problem.

Knowing what you actually want is important.

In general I'd suggest, these days, learning python (for running something locally, using something like Requests for actually getting the data. Though evelink wraps that up for you.

Then maybe dumping the information into an sqlite database, before you process it. (I'm not a good teacher, I'm afraid)



Quick question:
How are you importing things? lots of importxml requests, or something like my loadRegionPrices script? The second is more efficient, as it makes one request for a bunch of items at a time.



I'm using your script for importing prices but I changes it from Regional to System. Because I inter-region trade.