Saturday, 7 December 2013

Unlocking The Power of JEveAssets

jEveAssets is a desktop tool that helps players manage their assets in EVE Online. It has a number of different ways to display data from assets, wallet, market orders, industry jobs, etc and even more ways to tweak and filter exactly what is displayed.

JEveAssets handles multiple characters on multiple accounts fine. Since it gets the data from API queries you have to setup API Keys for each account first (through CCP's account management page) and then configure the Key ID and Verification Code for each account before JEveAssets can query the keys.


The most basic way to change what JEveAssets shows you is with the "tools" menu which gives you a number of options to open different tabs that display the data in different ways. Most of that is pretty straightforward, just click the menu item and a tab opens.


Most players will probably find the Values, Tracker and ISK tabs most useful at first. Other tabs like Assets and Transactions can be incredibly useful but can be daunting to use properly in the beginning. Traders and Industrialists (or anyone with a lot of assets / transactions) will find it's very well worth learning to use these tabs well!

Many (but not all) tabs have data cells arranged in rows and columns (the aforementioned Assets and Transactions tabs for example). In these tabs you can drag column headers and move them around to rearrange the order the columns are displayed in. You can double-click a column header to select it and then single click it to sort the data). You can also right click on any cell to open a menu containing a number of powerful features.

Transactions tab with right-click menu open

If for example you click on the highlighted Eve-Marketdata menu item shown in the screenshot above, it will automatically open your browser and look up the selected item (PLEX in the example above) on the Eve MarketData website.

Probably the most powerful feature is Filters. Filters are the key to unlocking the full power of JEveAssets. Without filters the Assets and Transactions tabs would be practically useless for any half serious Trader or Industrialist. There's just way too much data to find what you're looking for quickly (far less make much sense of it all) without filtering. But with filters, these tabs are extremely powerful.

For example here's an un-filtered Transactions tab.


The screenshot only contains the first few lines of the list but the full, unfiltered list has nearly 5,000 entries. So let's make it more readable by filtering the list to only show a single item 30 Day Pilot's License Extension (PLEX)

Under the Name column (the item name) right-click on 30 Day Pilot's License Extension (PLEX) to open a menu like in the screenshot below.


Then click on Contains to add a filter like in the next screenshot


When the filter is added the list automatically refreshes to only show PLEX like so


The filtered list contains just 129 lines (vs nearly 5,000 unfiltered) and makes it much easier to see how my PLEX sales have been doing lately.

You can use filters to sort by any data cell not just the item name, you can filter by date, price, owner (character name), region, station, etc., you can use different filter methods like "contains", "does not contain", "equals", etc., and you can even use multiple filters too.

For example to further reduce the PLEX list above you could use 2 filters to only show items that are named 30 Day Pilot's License Extension (PLEX) AND are in a particular region. Which in the example I've been using throughout this article lists just a single PLEX and looks like this

Owner name removed to protect the innocent

Hopefully this will help some of you unlock the full power of JEveAssets and get better use out of it!

7 comments:

  1. You've just saved me an incredible amount of spread-sheeting! Thanks!

    One question though: Does it track P.I. and goods on planets too?

    ReplyDelete
    Replies
    1. You're welcome!

      I don't know if it shows PI goods on planet or in customs offices There isn't a tab that's specifically for PI but the Stockpile tab is probably what you want to look into for tracking any kind of goods.

      You might want to look at the Industry Jobs tab too. Maybe that tracks PI jobs too. I don't think it does but I don't do Industry or PI myself so I might be missing something there.

      Delete
    2. The Materials tab does have an "include planetary materials" checkbox but it's not showing anything for me on moons or in COs and I'm virtually certain I still have a fair bit left over from long abandoned projects on at least a dozen moons.

      Delete
    3. Those are corp assets and if you entered character APIs, the program wouldn't pull that data. I've asked our CEO to create a corp API in the hope the program will let us see what we have in our POS and POCOs :)

      Delete
    4. oh dear god man. CAn't spreadsheet very well as a trader. It's just too much information. Been playing with custom tools, and after going through exide-db, django, AJAX, Varokhs candlestick graphs app, and god knows how many others, come to the conclusion that AJAX with an SQL backbone is pretty much the way you're going to have to crunch the thousdands of transactions and journal entries a day, and at that point, eve-mogul and it'ssoon to be counterpart EVE-Merchant already do it.

      For now, depending on your goals, creating reports in eveHQ and having an xml link to their folders and html files is your best bet for summaries of goods and such.

      Still looking for a nice program to automatically append transactions together in an xml file or database for easy access to excel, but haven't found something ideal yet.

      Delete
  2. Does is handle corporation wallets and transactions?

    ReplyDelete
    Replies
    1. Apparantly it does.

      https://code.google.com/p/jeveassets/wiki/ReadMe#Corporation_API_Key

      I've never used corporation api keys with it though so I have no idea how it handles them. All of my characters are in NPC corporations. =)

      Delete