I’ve been using the function you coded for me for a NPC and it’s worked great. I now want to use it for a specific structure. Here’s what I’ve got…identical to your function except for the endpoint…but it’s returning only a single value. Must be more to this than meets the eye. If you got a couple minutes, great. If not, I’ll keep poking around until I get it!
function typePriceDataStructure(location_id) {
var data = GESI.markets_structures_structure(location_id);
var minSell = Number.POSITIVE_INFINITY;
var maxBuy = 0;
var result = ;
I’m not sure what you’re trying to do here? As it stands this method is just iterating over the first page of orders within the provided structure. Since this endpoint is not limited to a specific type, this function isn’t really helpful. You would want to also pass in a type_id and check that order[8] === type_id, so that you limit the minSell and maxBuy to that type. You should also use -1 as the page param to make sure you are getting all pages of orders.
I’m kind of lost here. There is a guide posted to the dev blogs just a few weeks ago with a notice that this is all already out of date. A few replies above you link to something you call ‘examples’ but this is just a changelog with no examples that I can find. Can someone please link current examples to get us started. I want to just execute a script that imports all my wallet transactions for a period of time.
@Aynder Just follow the setup guide, then type =characters_character_wallet_transactions() in a cell.
Feel free to join the discord server if you need more help.
Also just to clarify. That blog post was made over a year ago for when GESI was not an add-on. The update saying it is now out of date is more so related to the first 60% of it that dealt with installing it. As back then you had to create a dev application, copy files over etc versus now where you just install the add-on. The functionality towards the bottom is the same, however the specific examples prob wont work as the order the response columns and function parameters have changed since it was made.
I updated the install instructions in the readme as it should be installed via sheets not the marketplace (unless you want to enable it for everyone in your organization i guess).
In sheets: Go to Add-Ons => Get add-ons => Search for GESI, and click the + Free.
Maybe a blonde question, how to log out from a sheet?
I would like to prepare a sheet, test is with my account but force any furhter user to login with EVE SSO to make GESI fetch the data according to the individual Eve user.
My idea was to prepare a sheet and to let some people use it on their own. Any user should use the Eve-SSO login first in order to fetch his individual data.
It’s not my intention to let them share data.
But I would prefer to have only one sheet I maintain while the users use it as a kind of service.
Hope this makes sense to you.
Right yea, you maintain a master sheet that is read only. People that want to use it would go to like file => make a copy, then do the SSO flow on their personal copy. While all the functions and logic you had on the master would be used against their data.
So assuming you delete your Auth Data sheet, it would be recreated/populated by each user themself.
I’m trying to understand how to use the parseArray function. I am trying to get insurance data from insurance_prices and get typeids in column B and data like this in column A
hm, =parseArray(“insurance_prices”, “levels”, A2) also gives an error… any other ideas?
EDIT: I love google imitating every idiot idea M$ had with Excel - like changing the syntax in foreign language versions…
I have to write =parseArray(“insurance_prices”;“levels”;A2) - note the semicolon instead of comma…
I don’t know if it is a new problem (i.e. I haven’t used GESI before), but I’m having trouble installing the add-on on a Google Sheet.
Namely, it doesn’t show up in the search results for the “Get add-ons” dialog; and if I directly click on the install button on the marketplace, I get a message which reads:
Am I missing any steps, or shall I indeed wait until the add-on undergoes that verification process?
I submitted GESI for verification a while ago, just waiting on Google to approve it. Unfortunately I’m also at the limit for an unverified app. Sorry but not much more I can do than wait
