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 Spreadsheet - Getting corp member counts for many corps
Author
Previous Topic Next Topic
Andraea Sarstae
Circle of Steel Inc.
#1 - 2015-09-28 06:17:18 UTC
What I'm trying to do is get the member count for any corporation that is in my alliance's contact list, which is nearly full, at over 2500 contacts. NRDS, Provi :-)

If I pull my shorter corp contact list, it works fine, but chokes when I try to do it for the big alliance list.

The error is "Internal error executing custom function", which doesn't tell me much. My guess is that either the google server or the Eve API doesn't like so many rapid fire queries, but I don't see anyway to batch request this information.

Does anyone have an ideas that might help me do what I want to do here, with just Google sheets? (Trying to keep this as simple and shareable as possible)

I'm thinking I might just have to get this data outside of Google sheets and import it myself, but I wanted to see if anyone had any tips here first.

Thanks!
salacious necrosis
Garoun Investment Bank
Gallente Federation
#2 - 2015-09-28 11:51:53 UTC
Andraea Sarstae wrote:
What I'm trying to do is get the member count for any corporation that is in my alliance's contact list, which is nearly full, at over 2500 contacts. NRDS, Provi :-)

If I pull my shorter corp contact list, it works fine, but chokes when I try to do it for the big alliance list.

The error is "Internal error executing custom function", which doesn't tell me much. My guess is that either the google server or the Eve API doesn't like so many rapid fire queries, but I don't see anyway to batch request this information.

Does anyone have an ideas that might help me do what I want to do here, with just Google sheets? (Trying to keep this as simple and shareable as possible)

I'm thinking I might just have to get this data outside of Google sheets and import it myself, but I wanted to see if anyone had any tips here first.

Thanks!


You didn't say, but I'm guessing you're using Google App Script since the error message complains about a custom function. Script execution is limited to 6 minutes as per quota. It doesn't always give a great error message when this happens, so I can't say for sure that this is your problem. If you invoke your script from the script debugger you can usually get better info.

The usual solution around this is to batch requests across multiple script calls using installable triggers. I use a spare google sheet to hold state between trigger invocations, but there are other fancier options.

Use EveKit ! - Tools for EVE Online 3rd party development
Andraea Sarstae
Circle of Steel Inc.
#3 - 2015-09-29 04:52:53 UTC
Yes, it's a google app script.

The runtime doesn't seem to be the issue, as it fails within 30 seconds or so.

I did step through using the debugger, but everything is fine doing that.

Just like a smaller set of contacts is okay. I think it's just the number of calls that are being made. I'll look into Installable Triggers. Thanks!