Eve x Excel Add-in Version 1.6.0 Patch notes

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

The 1.6 patch is going out as we speak to production.

New function:

EVEONLINE.CORPORATION_MEMBERTRACKING(character_id_or_entity)

  • Requires a director role in your corporation of the character_id supplies.
  • Returns all members of corporation, their location_id, ship_type_id, last login/logoff and registration date.
  • Includes an image and name of the character and if the location_id is a station it will be resolved as an additional .location card.

Note: Requires a new sign in for the proper scopes to be added to the token, it should show the new scope being added on a new sign in if you had previously signed in with the character.

Fixes.

  • Concurrent blueprint_explosions no longer bleed into each other results.
  • Character/corporation_blueprints now always return a location_id, location is returned if cached assets are available (most applicable to corporation_blueprints)
  • Fixed function reference site link in sidebar.
  • If a character fails to refresh its token, due to invalidation or such, the character name will be returned in the error message.
  • ACTIVE_CHARACTER() now fetches character cards with character location and character ship data fields.
2

Character Location_Solar_System_ID returns a system I ‘was’ in’ not where I am in.

I am flying around do some market runs, and I want to update the regional market of the system I am in. To run quick numbers comparing in EXCEL. Maybe something nearby, a few ISK plus or minus, I might grab.

The character location seems to be slow in updating my position.

3

The character location is cached for about a minute on our side, ESI docs say its cached for 5 seconds.

If we’re calling with a location + ship, we check each data point for its cache (and fetch it if needed) and combine it into the card. So in theory it should just be a minute between updates on our end. Rest is up to ESI actually reporting it accuractely.

1 Like
4

Thank you… that was so quick.

Do you live in the forum? :grinning:

5

hah, nono I don’t live here :smiley: I’ve just been working on the addin and I like to check in on the forums as I finish the day.