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.

11

How can I get 1.8.52, looks like I am horked on Character_Assests as well.

I logged out and did CTR-F5 on the Eve Online plug in pane.

1 Like
12

Me too - Excel on Mac. It only wants to pull 1.8.51

13

Friend, how do we solve the problem with =EVEONLINE.CORPORATION_ASSETS() ?

14

1.8.53 is releasing, I actually forgot to change the text to 1.8.52 for that minor hotfix. Sorry about the confusion. :slight_smile:

Assets search via string that is an exact match is being fixed. Fixing .CATEGORY() and adding couple of images.

2 Likes
15

Thanks @Hundasuupa looks like my character_asset calls were fixed.

1 Like
16

@Hundasuupa I promised to send ship types that have no image (image cannot be loaded, instead #FIELD! message is shown) so you can add those images in next release. Thank you :folded_hands:

81008 - Squall

81040 - Avalanche

81046 - Deluge

81047 - Torrent

85087 - Tholos

89647 - Pioneer Consortium Issue

89649 - Outrider

91174 - Perseverance

17

These were added in 1.8.56, I just forgot to answer you here on the forums. o7

1 Like