| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Tomblinu
   |
Posted - 2008.08.26 18:59:00 -
[1]
Please point me in the right direction, or tell me what I've missed in my review. I've looked at the documentation for several third party accounting tools:
ò EMMA
ò EVE Asset Manager
ò Eve Commander
ò Eve Income Analyzer
ò Eve-MEEP (FAQ and screenshot pages not working)
ò ISK MEDIC
ò [Sexy] Offline Wallet
I want to view the stuff of all my pilots in a single view/table, where stuff ∈ {assets, market orders, market transactions, wallet journal}.
However, it is not clear to me that any of the tools I examined will aggregate information in the manner I'm seeking. Some might allow me to enter and view multiple pilots, one at a time, but I want a view that shows the union of all activity across all the pilots on both my accounts.
|
Tomar Lyonsbane
Sniggerdly
Pandemic Legion
|
Posted - 2008.08.27 11:54:00 -
[2]
www.eve-graph.com will do it for Wallet Journal and Wallet Transactions.
|
Ricdics
Corporate Placement Holding
|
Posted - 2008.08.27 12:30:00 -
[3]
 Originally by: Tomblinu
but I want a view that shows the union of all activity across all the pilots on both my accounts.
Why not just use the corp wallet? I dare say the majority of people wouldn't really have a use for what you are requesting. |
Tomblinu
|
Posted - 2008.08.27 22:16:00 -
[4]
Thanks for the suggestions!
I wasn't looking at Eve Graph because I can't run it locally or on my own web host, but from what I see, it does seem like a decent application.
As for using the corporate wallet, I was intending to have at least one pilot remain in an NPC corp, and I wasn't sure I wanted all my pilots in the same corp... but getting ready access to aggregate data might be reason enough to adjust my plans. Indeed, I founded a corporation earlier this week.
Another approach might be getting a tool to build just the database for me, and ignoring its own reporting in favour of my own (as yet still notional) SQL queries and such to get reporting out.
I guess that all these tools use databases, but some (e.g., the above-mentioned Eve Graph) don't look like they would allow me direct access to the database, and they don't all seem to have an export feature... and an export wouldn't get me much beyond having the set of directly API-exposed extracts anyhow.
Do you have any opinions on which applications might be best / simplest at making an aggregated database?
Or maybe I should just spend some time figuring out how to script it myself and learn how set up a "cron job" on my web host? Apparently cron jobs are all the rage!
All constructive input welcomed.
|
Mephistocles
Red Frog Investments
Blue Sky Consortium
|
Posted - 2008.08.28 00:12:00 -
[5]
I'm not 100% sure it would work, you might get Ray to confirm or deny if you ask nicely, but how about installing numerous copies (one for each pilot you want to access data) of Ray's SEXY wallet and have them all dump to the same database? You'd really only be using it to grab the data and sticking it in the db, and then create your own SQL queries to pull the data out that you want/need?
|
Shar Tegral
|
Posted - 2008.08.28 03:39:00 -
[6]
The upcoming release of Sexy II should be able to merge character data. I do know that one flaw in the current Sexy, with the idea of multiple toons into one database, is... it only tags "seller" in the corporate data stream, not the person data stream. Thus if you merge the personal data you lose the ability to know which toon "x event" happened with.
This is not to be confused with having multiple instances of sexy and then later merging the data yourself. I do this over a wide variety of players to get a feel for certain trends. (I don't care which transactions belong to who)
If you know some programming it should not be hard to modify things. If you are like me, a total hack who couldn't code himself out of a wet paper sack, you can always use some sort of MySql dump into another accessible format. (For me it is Access.)
To Shar -verb:
1 - To say what you mean.
2 - To say what it means.
3 - To say something mean. |
Veritech knight
|
Posted - 2008.08.30 00:45:00 -
[7]
I use eve-commander.com to do something somewhat like this..not one table but easily switchable between chars which you can link.
vk |
Tomblinu
|
Posted - 2008.08.30 01:45:00 -
[8]
Thanks for the further suggestions, guys.
Running multiple instances of [Sexy] sounds a bit messy, so I'll look forward to finding out more about [Sexy] II.
Flipping between tables in EVE Commander is exactly what I'm trying to avoid, so thanks for that report.
To see what I could do on my own, I tried pulling together an assets snapshot across my pilots: definitely not a process I'll do regularly, but instructive for me, since I'm pretty inexperienced with APIs, XML, SQL and so on.
I grabbed my pilots' XML data via wget; concatenated to a single table in a spreadsheet; installed MySQL so I could get at the data extract to match my asset data to the relevant invtype, grouptype and category type details; and then I made a report in my spreadsheet to which I manually attached a few important price figures... bottom line is that I have way too much inventory relative to my turnover.
Right now I messing around with the nightly dump data from EVE-Central to get some (admittedly rough) price data, but my SQL know-how is just enough that I can successfully kick-off queries in valid syntax... queries which turn out to successfully do the wrong thing, or so inefficient that they run for hours before I terminate the threads.
I've loaded all the price data, but I'm having trouble winnowing it down to just the most recent valid rows.
If I can make peace with these data sources, I might set up an API harvesting, MySQL-database-populating process on my web host with one of these "cron jobs" I hear about, and then look at reporting only on an ad hoc basis.
|
Ray McCormack
hirr
|
Posted - 2008.08.30 07:18:00 -
[9]
[SEXY] does allow for multiple characters. It tags personal and corporate transactions with the characterID. You just can't filter on that through the front-end at the moment. With the Report Writer in 0.2b you will be able to, along with a host of other options. Assets and Market Orders are incorporated and S&I jobs will follow in a later release. 0.2a was scheduled for closed testing this weekend; but has been pushed back by two weeks due to drunken parties and philandering.
|
Rho'varo
Minmatar
Diversified Operational Services
|
Posted - 2008.08.30 23:34:00 -
[10]
Originally by: Ray McCormack
0.2a was scheduled for closed testing this weekend; but has been pushed back by two weeks due to drunken parties and philandering.
Sounds like someone has their priorities in the right order!
I look forward to checking out the improvements at some point.
|
Tomblinu
|
Posted - 2008.08.31 16:41:00 -
[11]
Originally by: Ray McCormack
With the Report Writer in 0.2b you will be able to, along with a host of other options.
Thanks for the update, Ray; that sounds quite promising.
I managed to wrestle some meaning out of the eve-central.com API (much easier to use than the nightly dumps), but I don't fancy doing this as hoc processing on an ongoing basis, so I look forward to your 0.2a and or 0.2b.
|
|
Chribba
Otherworld Enterprises
Otherworld Empire
|
Posted - 2008.08.31 20:53:00 -
[12]
NEED SEXY!
Secure 3rd party service ■ Veldspar |
|
Ambo
Dirty Deeds Corp.
Axiom Empire
|
Posted - 2008.09.04 10:09:00 -
[13]
Just to let you know I have been working on this functionality for EMMA 1.0.
Currently, you can mix and match characters and corporations from any number of different eve accounts and the program will provide a combined view on thier assets, transactions, journal and orders. The normal EMMA reports will also combine the data from across multiple chars/corps. On top of that, I'm working on a total net worth report and a blance sheet report (Now feasible thanks to the assets and orders APIs.)
I had been working on it for a few months, progress is slower than last time because a) I'm being much more rigorous with testing, etc. b) It's involved learning a few new things along the way.
I've been on holiday the last 2 weeks or so but I'm back now and progress will resume in a few days. (If I don't get totally obsessed with Spore that is!) However, it's going to be some time before this is ready for release.
--------------------------------------
Trader? Investor? Just want to track your finances? Check out EMMA |
Tomblinu
Diversified Strategic Services
|
Posted - 2008.09.04 16:33:00 -
[14]
Originally by: Ambo
Just to let you know I have been working on this functionality for EMMA 1.0. [...] I've been on holiday the last 2 weeks or so but I'm back now and progress will resume in a few days. (If I don't get totally obsessed with Spore that is!)
That sounds like good stuff, Ambo; keep at it! I'll be extra-impressed if it aggregates assets from Spore as well, but maybe that's 2.0.
———
[WTS] Various Public Contracts from Diversified Strategic Services [DIVS] |
Caste Ling
|
Posted - 2008.09.06 06:59:00 -
[15]
Edited by: Caste Ling on 06/09/2008 06:59:29
I also use two accounts and three characters to do all of my transactions, and if I could combine all of these character's data into one source I'd actually consider using one of these management programs routinely.
As of now, my 'trade' is performed on all the characters and any attempts I've had at monitoring these characters in the available programs have lead to a big mess :P
--
Still utilizing my own spreadsheets - and they're getting extreme 
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |