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.
 

Wallet Export Tool
Author
Previous Topic Next Topic
Montevius Williams
The Scope
Gallente Federation
#1 - 2012-01-03 20:51:28 UTC
Where can I a simple wallet export tool that downloads to Excel or as a standalone desktop application.

Thanks

"The American Government indoctrination system known as public education has been relentlessly churning out socialists for over 20 years". - TravisWB
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2012-01-05 14:03:12 UTC
Well,. you can always use the API to export directly into a csv. Though it's not in nice discrete chunks. Just the last 1000 entries.

https://api.eveonline.com/char/WalletTransactions.csv.aspx?keyID=[your key id]&vcode=[your key's vcode]&characterID=[your character's id]

Will pull the last thousand entries from your wallet's transaction log into a csv file. You'll need to set up an API key using https://support.eveonline.com/api and give it access to your wallet's logs.


https://api.eveonline.com/char/WalletJournal.csv.aspx?keyID=[your key id]&vcode=[your key's vcode]&characterID=[your character's id]
Does the same for your Journal.


Eve Mentat's an option that might do what you want, and also handle the fiddly bits of converting ids into names. (All that data's in the static datadump, but you'll need a database for that)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Montevius Williams
The Scope
Gallente Federation
#3 - 2012-01-05 22:11:51 UTC
Steve Ronuken wrote:
Well,. you can always use the API to export directly into a csv. Though it's not in nice discrete chunks. Just the last 1000 entries.

https://api.eveonline.com/char/WalletTransactions.csv.aspx?keyID=[your key id]&vcode=[your key's vcode]&characterID=[your character's id]

Will pull the last thousand entries from your wallet's transaction log into a csv file. You'll need to set up an API key using https://support.eveonline.com/api and give it access to your wallet's logs.


https://api.eveonline.com/char/WalletJournal.csv.aspx?keyID=[your key id]&vcode=[your key's vcode]&characterID=[your character's id]
Does the same for your Journal.


Eve Mentat's an option that might do what you want, and also handle the fiddly bits of converting ids into names. (All that data's in the static datadump, but you'll need a database for that)



You sir, are a gentleman and a scholar.

Thank you!

"The American Government indoctrination system known as public education has been relentlessly churning out socialists for over 20 years". - TravisWB
Eshinto Sidahan
KillTronic
Fraternity.
#4 - 2012-02-09 12:08:39 UTC
Ok, first of all thanks for the info you provided so far, but upon filling out the blanks in the key i get the following response:

# error ParameterUserOrKeyIDRequired: Must provide userID or keyID parameter for authentication.

Is it because i just threw the line into the address bar of my browser? If so, where/how do i have to use the query to get a proper result^^
Furthermore, i do not need my own journal, but my corporations journal, how can i achieve that? And yeah, there are plenty of tools that do that for me, and i figured them out already, but none of them have the functionality i need. I want to be able to either sort the whole ist by type (mission tax, planetary export tax etc.) so i can then just copy/paste out the part i need, shove it into excel and calculate the sum (and i'm sure as hell not going to type in 1000's of single export tax transactions). EVE Mentat was at least able to filter the list by type, but then i cant copy the results (and it only display my own journal, not the corp journal - or i'm to stupid to find it); EVEWalletAware is just being ***** by not working properly, MEEP is crashing after i updated it yesterday , and i absolutely loathe EVEHQ - and i dont really want to waste like 500MB just to see my journal...
Anyway, on the old website there used to be the possibility to directly download the journal as either csv or xml, is that link gone now that they launched the new website? Because i can't seem to find it (and on that note, CCP failed with their plan to "integrate everything into one platform", on my quest to find that export link i was logged in at 4!! different websites...)

Enough wall of text, now i just hope someone can help me out with this.

Cheers
Ren Adal
Adal Engineering
#5 - 2012-02-09 12:33:54 UTC
You could take a look at EveNexus. It's compact and simple, and might suffice for your needs.

Btw, EveNexus also allows you to select the contents of the journal and transaction tables, which can easily be copy/pasted into an Excel worksheet.
Eshinto Sidahan
KillTronic
Fraternity.
#6 - 2012-02-09 14:05:55 UTC
So i installed EVE Nexus now, added my character API and it works very well - but it won't work with my Corporation API :/

any other tricks/programs available?

oh and i even installed EVE HQ again, but first it gives some jibberjabber about me using a 64bit OS, and then the Prism module won't load - yeah you guessed it - Transactions and Journal. everything else gets retrieved quite fine -.-
Markarian Aurelius
Caldari Provisions
Caldari State
#7 - 2012-02-11 00:42:52 UTC
Steve Ronuken wrote:
Well,. you can always use the API to export directly into a csv. Though it's not in nice discrete chunks. Just the last 1000 entries.

https://api.eveonline.com/char/WalletTransactions.csv.aspx?keyID=[your key id]&vcode=[your key's vcode]&characterID=[your character's id]

Will pull the last thousand entries from your wallet's transaction log into a csv file. You'll need to set up an API key using https://support.eveonline.com/api and give it access to your wallet's logs.


https://api.eveonline.com/char/WalletJournal.csv.aspx?keyID=[your key id]&vcode=[your key's vcode]&characterID=[your character's id]
Does the same for your Journal.


Eve Mentat's an option that might do what you want, and also handle the fiddly bits of converting ids into names. (All that data's in the static datadump, but you'll need a database for that)


This is what I've always done and it works great!
Eshinto Sidahan
KillTronic
Fraternity.
#8 - 2012-02-11 16:34:38 UTC
Markarian Aurelius wrote:
Steve Ronuken wrote:
Well,. you can always use the API to export directly into a csv. Though it's not in nice discrete chunks. Just the last 1000 entries.

https://api.eveonline.com/char/WalletTransactions.csv.aspx?keyID=[your key id]&vcode=[your key's vcode]&characterID=[your character's id]

Will pull the last thousand entries from your wallet's transaction log into a csv file. You'll need to set up an API key using https://support.eveonline.com/api and give it access to your wallet's logs.


https://api.eveonline.com/char/WalletJournal.csv.aspx?keyID=[your key id]&vcode=[your key's vcode]&characterID=[your character's id]
Does the same for your Journal.


Eve Mentat's an option that might do what you want, and also handle the fiddly bits of converting ids into names. (All that data's in the static datadump, but you'll need a database for that)


This is what I've always done and it works great!



that may well be, and i'm glad it does work for you, but the question here is: which journal did you export? your personal one or your corps' journal? and secondly, as i stated in a previous post, i keep getting an error message when i try to use the API directly.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#9 - 2012-02-11 17:08:25 UTC
An alternate option is to use something like YaPeal to yank your api data down into a local database, where you can then play with the results.

There's a quick how-to on my website, for using YaPeal with XAMPP.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
malaire
#10 - 2012-02-12 09:48:51 UTC
Eshinto Sidahan wrote:
Markarian Aurelius wrote:
Steve Ronuken wrote:
Well,. you can always use the API to export directly into a csv. Though it's not in nice discrete chunks. Just the last 1000 entries.

https://api.eveonline.com/char/WalletTransactions.csv.aspx?keyID=[your key id]&vcode=[your key's vcode]&characterID=[your character's id]

Will pull the last thousand entries from your wallet's transaction log into a csv file. You'll need to set up an API key using https://support.eveonline.com/api and give it access to your wallet's logs.


https://api.eveonline.com/char/WalletJournal.csv.aspx?keyID=[your key id]&vcode=[your key's vcode]&characterID=[your character's id]
Does the same for your Journal.


Eve Mentat's an option that might do what you want, and also handle the fiddly bits of converting ids into names. (All that data's in the static datadump, but you'll need a database for that)


This is what I've always done and it works great!



that may well be, and i'm glad it does work for you, but the question here is: which journal did you export? your personal one or your corps' journal? and secondly, as i stated in a previous post, i keep getting an error message when i try to use the API directly.


For corp use "corp" instead of "char" in that URL, e.g. https://api.eveonline.com/corp/WalletJournal.csv.aspx?...

If that doesn't work, also use "xml" instead of "csv" e.g. https://api.eveonline.com/corp/WalletJournal.xml.aspx?... and try to see if you can use those.

This list different APIs available: http://wiki.eve-id.net/APIv2_Page_Index

New to EVE? Don't forget to read: The Manual * The Wiki * The Career Options * and everything else
malaire
#11 - 2012-02-12 09:52:39 UTC
Eshinto Sidahan wrote:
Ok, first of all thanks for the info you provided so far, but upon filling out the blanks in the key i get the following response:

# error ParameterUserOrKeyIDRequired: Must provide userID or keyID parameter for authentication.

Is it because i just threw the line into the address bar of my browser? If so, where/how do i have to use the query to get a proper result^^

Should work in web browser. Try if this works for you: https://api.eveonline.com/char/Standings.xml.aspx?keyID=622063&vCode=vcode&characterID=91489386 (XML listing of standings for my alt).

ps. I used "vcode" as my vCode there instead of "fHshgFdsvd...." or something like that because this is for public use.

New to EVE? Don't forget to read: The Manual * The Wiki * The Career Options * and everything else
Eshinto Sidahan
KillTronic
Fraternity.
#12 - 2012-02-20 09:32:23 UTC
Thanks malaire, that did the trick! You just saved me from an awful lot of copypasta
Bussa Braun
Pator Tech School
Minmatar Republic
#13 - 2012-02-20 11:30:49 UTC
whats the difference between the KeyID and the CharacterID?

I keep getting this

# error InvalidCharacterID: Invalid characterID.
malaire
#14 - 2012-02-20 12:19:24 UTC
Bussa Braun wrote:
whats the difference between the KeyID and the CharacterID?

I keep getting this

# error InvalidCharacterID: Invalid characterID.

They are different IDs, one KeyID could be used to read API of several characters.

You can use https://api.eveonline.com/account/Characters.xml.aspx?keyID=622063&vCode=vcode to get list of all characterIDs for your keyID (using my alt as example.)

New to EVE? Don't forget to read: The Manual * The Wiki * The Career Options * and everything else
Moeziz
Ixian Technologies
#15 - 2012-02-24 01:34:32 UTC
Montevius Williams wrote:
Where can I a simple wallet export tool that downloads to Excel or as a standalone desktop application.

Thanks


I found the link to the "My Character" page.

https://community.eveonline.com/login.asp?r=%2Fingameboard.asp&t=%2Fcharacter%2Fskilltree.asp%3F