Eve Excel Add-in version 1.8.51 Patch notes - SDE update

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

1.8.51 is now released.

We’ve moved the invTypes.csv sourced from fuzzworks over for a english strings types.jsonl from the SDE.
So many new items are now parsing correctly and are finally searchable via .inventorysearch()

The addin had a fallback to ESI for completely missing types so this should help with that.
No new images were added to the image mapping, but that’s likely to come along the next SDE refresh, once we’ve confirmed nothing is breaking with this static data swap for the addin.

I’ll check in here more frequently to follow any issue reports, it’s easiest to tag me in discord if anything in 1.8.51 is misbehaving.

o7

1 Like
2

Thanks for the update.

Having issues with the eveonline.character_assets() API call now in 1.8.51 now though. I’ve been using it to get the assets of all logged in characters however with 1.8.51 it only ever returns a #value error.

Have tried logging the characters out and back in again but even then, no joy.

Have I missed something?

(I would have ping’d you in Discord but it appears to hate me and won’t let me post in the spreadsheets channel) :rofl:

1 Like
3

Since the 1.8.51 update I’m having an issue with EVEONLINE.CHARACTER_WALLET_TRANSACTIONS()

I keep getting #VALUE! error

All other retreives are working fine.

4

I have been having issues with eveonline.nn.assets() , also.

But it seems to be related to my PI sheets, not market or personal/corps inventory or manufacturing sheets.

This is nowhere near scientific data gathering.

edit:

Did a relog, now my wallet is not working either. I get a wrong value.

5

I’ve fixed the assets, the fallback to ESI wasn’t triggering. Undefined items were polluting the data for that.

I’ll take a look at the wallet.

1.8.52 contains the fix for #VALUE on assets. (New items not yet in my SDE)

1 Like
6

thank you

I have been screaming and yelling at my computer for the last hour, and weas just getting ready to send you a note.

7

I got it to work, reloaded the Add-in and reloged helpd to fix it.

8

Top stuff :slight_smile: - Thanks for the quick fix. Looks like the character_assets() call is working now (at least for me).

9

Now, my excel is crashing about 5 minutes after opening. :sob:

Working my way through the file one tab at a time.

transpose(eveonline.character_assets(,,<location)) this is giving me

a #value error,

a #name error, or

a large number of cells with a sum of 230,000+ Biomass.

it picks and choses one of the three before crashing.

10

(post deleted by author)