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

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

Market Discussions

 
  • Topic is locked indefinitely.
 

Transaction Extractor
Author
Previous Topic Next Topic
Johnny Frecko
Federal Navy Academy
Gallente Federation
#1 - 2012-02-24 20:42:44 UTC
o/

Before you jump around and say this has been posted before, I know.
Now, as to why i'm re-posting.

I searched far and wide for a wallet program to handle my needs.
which are
Get transactions from date X to Y and summerize all the items, how much were sold, how much were bought, profit.
I was using Wallet Aware, But it broke on the last update, i couldn't get it to work anymore.

So i decided i'll do my own thing.
I figured how to get my last 1000 transactions, some excel magic, and i got what i needed.
problem is, i have over 8000 transactions per month.
So, i'm posting here, hoping that someone has some information.
The answers i need are:

1)Is there a way to extract more than the last 1000 transactions from the wallet, if so, how.
2)is there a way to specify dates for the extraction(For example, from 1/1/10 to 1/1/11)
3)Can eve mentat(that does gather all this information) export to excel?

Sorry to bother you, and have a nice day
Thur Barbek
Republic University
Minmatar Republic
#2 - 2012-02-24 21:16:50 UTC
Disclaimer - i know nothing about the api programming.

Cant you just import the transactions more often than once per month? Since you get 1k transactions max and u need 8k per month do a import twice a week. Then just store the data and have your program delete month+ old data. You may have to write a check to find where the new and old data meet, then can delete the duplicate import entries.

Or if you want to save month+ old data. Just have the program move that data to a separate database than your main one with the most recent month's data.
Johnny Frecko
Federal Navy Academy
Gallente Federation
#3 - 2012-02-24 21:23:53 UTC
I can do it twice a week, but if i have too many transactions on a few days i can lose information.
There is no way for me to count 1000 transactions in game,
And doing it daily to avoid this problem is a huge hassle.

And the only program i'm using is excel, removing duplicates isn't as easy as it seems, because having the exact same date/time for some item can just mean that it was sold twice from the same market order at the same time.

You'd be surprised how much that happens with so many transactions.

your help is much appreciated.