Character Assets Not Always Loading

EVE Technology and Research Center EVE x Microsoft Excel Add-in
1

I am trying to create a stockpile of assets, specifically from the keepstar I live in. I have a table with Type IDs in a column. My formula is:

=IFERROR(SUM(EVEONLINE.CHARACTER_ASSETS([character id,[@ID], [keepstar id).quantity),0)

For some things it works, but for others it’s saying 0 because it’s either erroring or simply not pulling back the assets which I know are there.

When I open the add-in, sure enough I see “Error: Timeout waiting on backend (Character_Assets)”, so I imagine it’s timed out and not managed to bring back certain assets e.g. the amount of Tritanium I have. I also right-clicked the add-in window, went to Inspect, and then to Console window. There I saw an error about timining out.

I removed and re-added the character and then closed and re-opened Excel and it loaded correctly. I can’t give the error code in the console since i closed and re-opened Excel.

My main concern is that I only spotted it this time as I was testing something, but in the future I’d not necessarily know when it’s working for some assets and not others due to time out.

Has anyone else encountered this issue? If it can even be called an issue.

Thanks.

2

All assets need to be fetched, then we run a scrub of only the type_id, resolve it, then filter out based on location_id (since it can be nested a bit)

The pull is more sensitive on excel web, was this desktop 365 or web 365?
Not much we can change to help with this, and your approach is definetly the most efficient way to pull it, in terms of minimizing what the addin has to load and process.

Only thing that comes to mind would be trying to pull all the keepstar contents with just a location_id filter, and running a XLOOKUP on it. That way it’s not managing different variants of type_id + location_id that’d be cached in memory.