Fuzzwork Mail - Fuzzwork Evemail, an ESI Evemail client.Includes Faction Warfare stats and leaderboards. EVEMissioneer - An EVE Online agent finder and explorer with optional SSO standings integration.Allows players to use their favourite calendar app on the desktop or mobile as also see events in their preferred time zone. - Convenient out-of-game access to character's calendar.EVE Workbench - EVE Workbench is a web based tool for the EVE community, allowing players to browse the market, create haul routes and browse & share fittings.Eve Fleet Simulator - Simulate fleet PvP and compare/analyse fits and hulls.GESI - Google Sheets script to interact with ESI.EVE Ref - EVE Online reference site with full item database and stats.PyEveLiveDPS - PyEveLiveDPS (PELD) is a live DPS calculator and grapher for many combat statistics.You can participate with CCP devs and third party devs by joining Tweetfleet on Slack and hopping into the #esi channel. Since Eve apps and websites come and go we will try to check each of the them periodically and keep the list up to date. Your product should be user friendly and beyond "beta" stages.Create a Pull Request with the name of your tool, the URL (or app name) of your tool, a category it should go into, and a very brief description of what it does.This is an attempt to keep an updated and maintained list of some of the many great tools and applications. Hover over the bottom right of cell H2 until drag down until you have covered all the rows of your asset data to apply this function to every row.There are those who play Eve Online using the game's given UI and there are those who manipulate the data and create tools to work within the Eve Online Universe. It is left as an exercise for the reader to figure out how this function works exactly.Īfter hitting enter you should see the name of the type_id at the beginning of the row show up. In cell H2, copy and paste the following function: =HLOOKUP("name", universe_types_type("en-us", INDIRECT(ADDRESS(ROW(), 1)), True), 2, FALSE)Īnd press enter. Go to cell H1 (or whichever column is blank after your asset's data) and enter the text "name". After looking at endpoints.gs you will find that the function name is universe_types_type. You can use the same method explained above to find the name of the function you will need to use in your spreadsheet for this endpoint. When using Google Scripts, the callback URL will look like /. You don't need to know exactly how it works, but you do need what's called a callback URL for EVE's servers to contact during the authentication process. ESI uses an authentication method called OAuth2. Next, you will have to make an application for EVE's Single Sign On (SSO). Navigate to in a different tab and copy the contents of GESI.gs, endpoints.gs, and functions.gs into three different script files in your Google Scripts project. This will open a new tab to an instance of that is tied to your spreadsheet. On the top bar of your spreadsheet click on Tools -> Script Editor. Go to and create a new blank spreadsheet.
This blog will walk through how to make a Google Sheet to track your character's in-game assets using authenticated calls with GESI without needing to write any code yourself. Luckily, with the help of community member Blacksmoke16's GESI, the process for making an ESI based Google Sheet is much more simple than it has ever been. The legacy APIs will be terminated on May 8th, 2018.Ĭome May 8th, the death of the XML API will also mean the death of many EVE based spreadsheets. Each blog will be published on the 8th of each month during the journey towards XML API and CREST’s termination date. This blog post is part of a series of blogs examining best practices for ESI development. For the latest instructions visit the setup instructions on the GESI GitHub repo. This guide was written for an older version of GESI.
0 kommentar(er)
