[7.6.0 - version 12] GESI - Google Sheets ESI Add-On - Update install instructions

Blacksmoke,

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 = ;

data.forEach(function(order) {
if (order[3] === location_id) {
if (order[1]) {
if(order[6] > maxBuy) {
maxBuy = order[6];
}
} else {
if(order[6] < minSell) {
minSell = order[6];
}
}
}
});
return [[minSell, maxBuy]];

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.

1 Like

Bump because I don’t want the thread to get locked.

2 Likes

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.

Would want to delete the row for your character(s) from the Auth Data sheet that is hidden by default.

I’m assuming you’re planning on having each user copy the sheet, so they each have their own copy?

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.

Could some one help me to make one cell to automatically pull highest PLEX buy order price from jita 4-4.

I have installed the add on but don’t understand how the code works.

You’d be better of using another aggregate API for that, such as https://market.fuzzwork.co.uk/api/ or https://chrome.google.com/webstore/detail/evepraisal-tools/lklblimoabndhjineeemkldkjllinmlj.

In order to do this in GESI you would have to fetch all the market orders for PLEX within the forge, then manually filter that down.

Hi,

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

[{"cost":167973.45,"name":"Basic","payout":1679734.5},{"cost":335946.9,"name":"Standard","payout":2015681.4},{"cost":503920.35,"name":"Bronze","payout":2351628.3},{"cost":671893.8,"name":"Silver","payout":2687575.2},{"cost":839867.25,"name":"Gold","payout":3023522.1},{"cost":1007840.7,"name":"Platinum","payout":3359469}]

Would parseArray be the correct way to get individual numbers out of this and what would be a valid column_name parameter for parseArray?

I have also tried the =parseArray(“characters_character_skills”,“skills”,A2) example but also didn’t get aything besides error messages.

TIA,

Zoltan

parseArray would be the way to get the data out, but would have to be done for each type. The function would be like

=parseArray("insurance_prices","levels",A2) where the data is in cell A2.

1 Like

Hi,

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…

Zoltan

1 Like

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 :confused:

image

1 Like

No problem - thank you very much for the prompt answer! :slight_smile:

Hello Blacksmoke16
Is there still a way to use GESI without the marketplace installation?
The procedure lined out in the Dev blog doesn’t seem to work any more.
https://developers.eveonline.com/blog/article/using-esi-with-google-sheets

Thanks for the help.

It would be doable but I don’t have a guide. Still waiting on Google to approve it.