These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

EVE Stats - Wallet grapher
Author
Previous Topic Next Topic
iskflakes
#81 - 2012-06-30 00:05:44 UTC
Well spotted. I investigated and found the problem was an odd duplication bug caused by a particular API not working the way I thought it did, which was causing MySQL to throw exceptions (duplicate primary keys), so no new asset data was being fully added to the assets table, and the asset statistics weren't regenerating. While I was there I also spotted an unrelated bug and fixed it, which will be handy if I ever start graphing asset locations.

Incidentally this bug also caused the "top assets" page to display an incomplete list if you have any containers.

Anyway, the good news is that although the assets haven't been appearing on the graphs, all the raw API call data is saved, so I'm going to delete all asset data and replay the raw data, which should take a few million years to complete, but at least all the data will be there (including the last few days).

During the replay the site may be slow, and the top assets list and graph asset data may appear to be not updating (they are though). If I've made any manual edits to your graphs (A few of you have requested it) these might be undone as the raw data is replayed, just let me know if there's anything else that needs correcting.

Other good news: I improved the asset performance while I was working on it, turns out one SQL query was using 100% of my CPU when it was running, and it typically takes minutes to complete.

-
Hongus Gwag
Doomheim
#82 - 2012-07-02 17:14:12 UTC
I keep getting a message saying 'badkeyID' any idea why this might be? I created the key by following the link from the site.

Also, this is a lovely looking tool, hope I can get it working :)
iskflakes
#83 - 2012-07-02 17:29:46 UTC
Do you get that message when trying to sign up for EVE stats, or when trying to add this key to an existing account?

If you are adding a new key to an existing account then you need to sign that key up for EVE Stats seperately first.

Generally this message means you've got some extra text in the "Key ID" field. Check there are no spaces, or letters, which would cause the KeyID to be invalid. The KeyID should just be a number.

-
iskflakes
#84 - 2012-07-05 19:46:52 UTC
It has been suggested that I add an indication of daily/weekly/monthly profit for traders.

Would anybody else find this useful?

-
Tubrav Sadarts
Viscous Logistics
#85 - 2012-07-06 11:34:33 UTC
iskflakes wrote:
It has been suggested that I add an indication of daily/weekly/monthly profit for traders.

Would anybody else find this useful?


Very much so, yes.

My Idea for improving T2 Invention!
Lord Drokoth
Hostile.
PURPLE HELMETED WARRIORS
#86 - 2012-07-06 22:04:27 UTC
iskflakes wrote:
It has been suggested that I add an indication of daily/weekly/monthly profit for traders.

Would anybody else find this useful?


Thats a rather tidy example right there.. simple and effective...
Ill assume the displayed growth is between the start points and the current time for each time period.
Pretty sure many people will benefit from the extra snippet of info.. especially when the traders grow larger.

Thanks for putting it together so quickly too.

Kudos.
L.D
Tubrav Sadarts
Viscous Logistics
#87 - 2012-07-06 23:03:44 UTC
I do like the estimated profits, although of course they're completely wrong for the past week. Not much can be done about that since manufacturing jobs (as far as I know) have no API equivalent to market orders... or do they? Since until all my stuff is manufactured and returns to my assets, there's a gaping hole in my asset value...

My Idea for improving T2 Invention!
iskflakes
#88 - 2012-07-06 23:26:55 UTC
Industry jobs is one of the holes in EVE Stats right now, the other major one being contracts (contract some assets to someone and EVE Stats won't know about them). There are APIs for both, which means in principle both could be added as new colors on the graph (so you could see your estimated value in industry jobs go up and down).

Currently the way the site is programmed if you've got industry jobs or contracts enabled on your API key it will gather that data, but no code has been written to display it. Maybe at some point in the future I'll bother, but right now I'm not going to.

Estimating profits (and actually asset value) is impossible to do properly for many reasons. Assets do not have a single price, only an estimated price that I have to come up with using eve-central data, and profits depend on so many factors. I don't think it's possible to give more than a rough estimate, but that is still useful, which is why I display it :)

Another feature that's been suggested is a way to tag certain parts of the graph with descriptions, so in your case you could add "Manufacturing job started here" at an appropriate place, and there could be some global tags like "Inferno released here". Haven't decided if I want this feature yet, it could create a lot of unnecessary clutter.

-
Ayana Mayuko
Mayuko Sisters' Trading Enterprises Ltd.
#89 - 2012-07-15 18:02:46 UTC
iskflakes wrote:
Another feature that's been suggested is a way to tag certain parts of the graph with descriptions, so in your case you could add "Manufacturing job started here" at an appropriate place, and there could be some global tags like "Inferno released here". Haven't decided if I want this feature yet, it could create a lot of unnecessary clutter.


Bumping to tell you for the billionth time to add this.

:)
Dunan Sanis
Perkone
Caldari State
#90 - 2012-07-22 21:25:13 UTC
It's down! Everybody jump ship! Sell your accounts, burn your monitor, demagnetize your HDD!
iskflakes
#91 - 2012-07-22 23:11:14 UTC
Technical difficulties are courtesy of my DNS provider and their terrible customer service.

Enjoy!

-
iskflakes
#92 - 2012-07-23 15:35:53 UTC
Update: I've setup a new DNS server, EVE Stats should now be accessible again.

There's one bug I know about with historic data from players who have only ever had a single market order up briefly. I'll fix it in the next few days. It won't affect new data.

-
SanitySlayer Amarrian
Imperial Shipment
Amarr Empire
#93 - 2012-07-24 15:47:59 UTC
Hey Isk, just curious about the 21 hour gap on my graph (Kath Yeva) where no information was collected. Could this have something to do with the new DNS server? Just asking incase it gets into the habit of picking my API every 21 hours :)
iskflakes
#94 - 2012-07-25 11:03:17 UTC
That gap is present for DNS related reasons yes. It should be a one off, and the missing data might even be floating around somewhere on the system. I'll look into it.

-
SanitySlayer Amarrian
Imperial Shipment
Amarr Empire
#95 - 2012-07-26 09:07:20 UTC
Ok no worries :) just thought i'd check.
ZehNarume
Pulling The Plug
PURPLE HELMETED WARRIORS
#96 - 2012-08-09 16:30:30 UTC
Bump for great continued service \o/
Virppi Jouhinen
Xiphias Ltd.
#97 - 2012-08-09 17:30:21 UTC
Very nice! I can get rid of my perl script now.

Elinor - lightweight semi-automatic daytrading helper Current version: 1.1.2 Beta
iskflakes
#98 - 2012-08-09 18:12:52 UTC
That's the idea.

Ridding the world of perl, one script at a time.

(By the way, you can actually download your raw data form EVE Stats, which is something you might be interested in doing seeing as you already have a script).

-
Virppi Jouhinen
Xiphias Ltd.
#99 - 2012-08-09 18:44:28 UTC
The only problem I got atm is that it doesn't want to load the data. I've been waiting for an hour now.

Elinor - lightweight semi-automatic daytrading helper Current version: 1.1.2 Beta
Hongus Gwag
Doomheim
#100 - 2012-08-09 20:51:48 UTC
This is a lovely tool that gets better looking the longer you use it for, nice work!

One suggestion though, and this may allready be possible I'm just missing it; would it be possible to log in with a username/pass instead of api info? Often I'm on lots of different computers and finding my api info each time is a pain.