Eve x Excel Add-in Version 1.8.0 Patch Notes

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

1.8.0 Patch notes

We’re updating to consume the openAPI specs to future proof the addin. This will touch on every endpoint that talks to ESI, testing has been as broad as possible but issues could still happen as the test scenarios don’t cover everything perfectly.

Highly advised to report issues in the #spreadsheets discord channel so we can fix them right away

Due to this upgrade the streaming functions have been removed due to their complexity and instability.

Removed endpoints

  • MARKET_ORDERS_STREAMING

  • MARKET_STRUCTURE_ORDERS_STREAMING

Fixes

  • Improved cache resolution

  • Lowered max page size of corporation_orders to 500 to improve excel web performance

  • Removed (active) and (paused) logic from skill queue as it was inexact and misleading, using excel date and comparing it to the items is a much more exact approach.

  • Improved internal error rate counters

New Scopes

  • esi-corporations.read_projects.v1
2

You are awesome! :grinning:

1 Like
3

It seems Character Minig is not working, not fatching any data after the update.

4

We’ve had some concurrency issue affecting this release, leading to incomplete data / N/A when refreshing multiple functions at once, a hotfix has just been released that can be fetched via CTRL+F5 in the sidebar to load in new files.

I’ll go check out character mining and see if it needs a new hotfix for that. Thanks for the report!

5

A bugfix for this is being released right now. CTRL+F5 in the sidebar to get the fixed version of 1.8

The verison will remain as 1.8, since I’ll be bumping it later to 1.8.1, this weekend hopefully, once I cover the concurrency issues properly.

6

1.8.2 is being released.

Sadly I’ll have to revert the API changes for now, the massive scale of concurrency was breaking down the implementation and I’ll be redoing the functionality.

Changes that remain are the scopes, removal of (paused) / (active) in skill queue, and removal of the STREAMING functions to retain an easier upgrade experience for anyone on 1.8/1.8.1

7

1.8.3 is in internal testing and it will include a function for all corp projects and singular corp project details.
I’ll update with a new post once we release it. :heart:

8

1.8.3 is out, and includes .CORPORATION_PROJECSTS(character_id) and .CORPORATION_PROJECT(project_id, character_id) functions

Let me know here or on discord if it acts up.
Some configurations might need some display love but AFAIK they should output the data.

9

Hello, every time an update comes I have to delete the Add-in and reinstall it to avoid my spreadsheet to be corrupted with the _xldudf_
This time however, after accepting the T&C the plug-in (V1.8.3) fails to install and although the side panel remains, the Add-in is not on the ribbon and also not in the installed Add-in list. The formulas are not recognized so definitely it is not working.
Am I the only one with this issue? I have not used the spreadsheet in a couple of days, so I guess it is related to the last update…

10

same for me - get message “unknown error fetching character for …….”