EVEONLINE.CHARACTER_WALLET_TRANSACTIONS [busy -> no data]

Hi,

I’m just trying the new add in with the free online Version of Excel.
As soon as I’m using: =EVEONLINE.CHARACTER_WALLET_TRANSACTIONS() it stated ‘busy’ without any change. I tryed the page function as well: =EVEONLINE.CHARACTER_WALLET_TRANSACTIONS(;1) but nothing happend.

I can’t use the cool new excel feature right now. :frowning:

o7
Trabitat

P.S. I still can’t understand why the Add In is not working with the offline Excel Version 2021 on Windows…

1 Like

Hi, It’s likely the paging size for the wallet_transaction isn’t small enough for the data. I’ll look into it and see if I can find what number works for excel web, and make a hotfix for it.

Excel 2021 doesn’t work since the API the addon uses, the card json style attributes, was created recently in 2022 and the answer we go was due to business reasons microsoft can’t give the 2019/2021 version a backwards compatible patch for it to work. The API was reporting the wrong support initially so it looked like it should have worked, but that was a bug that was resolved.

Bit annoying that the addin store can’t tell users that before they download the addin. :frowning:

Hi Hundasuupa,

thanks for your reply and that you will take care of it! :pray:

o7 Trabitat

1 Like

Heya, have you managed to try this out again after 1.5 release?
Interested if my personal test data was enough or if the data varies too much for 200 per page.

I’ve been messing with the excel add-in today, and I get the same Busy error message in the web version of excel.

Other functions work well, but this is the first I’ve ran into that won’t pull any data.

Looks like the excel web detection has broken after some web changes from MS, I’m not getting a fallback page 1 either.

I’ll test this again for the pageload for page 1 and try creating some setting for this endpoint to customize the page size, for next patch.
This would be the first function to obtain a customized paging setting so we’ll see how it behaves after that.

Hi, I’m using web version of Office 365 and so far this formula was working fine:

=EVEONLINE.CHARACTER_WALLET_TRANSACTIONS(character_id;1)
=EVEONLINE.CHARACTER_WALLET_TRANSACTIONS(character_id;2)
=EVEONLINE.CHARACTER_WALLET_TRANSACTIONS(character_id;3)
...
=EVEONLINE.CHARACTER_WALLET_TRANSACTIONS(character_id;n)

Each line would fetch 200 records of wallet transactions. This way web version of Office would not crash because data retreives would be limited to 200 records. In my case just few weeks ago it stopped working. First 200 records are not being retrieved, I get #Bussy! message whil second batch of 200 records would retreive something inacurate. Any further fatch, no3, no4 or later would not retreive anything and just showing #Bussy!.

Did anyone find a solution for this issue?

Latest patch added functionality to automatically find the highest number of transactions that could be displayed in excel web. For that we raised the “max” to 500, most likely the payload limit enforced isn’t exactly 5mb or my maths was mathing. I’ll be looking at this soon and releasing a hotfix ASAP.

You can view some text about this update here,

1 Like

I’ve made a hotfix for the 1.7 verison that hopefully eliminates most #BUSY stuck issues for excel web. (If the function has paging)

Seems like the payload limit is actually 3.5mb :frowning: So we’ll work around it this way

If anyone finds a function that can encounter this issue that doesn’t require it feel free to ping me in discord so it can be added. I don’t check the forums as much.

1 Like

Thx, will try later if it works

1 Like

Hi, just wanted to leave a comment here also if someone ends up reading this topic. @Hundasuupa fixed the thing, it works now. Fetch is per 350 records. Thx

1 Like