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.
 

Wallet Journal Dump to XLS
Author
Previous Topic Next Topic
Zhentar
Players vs. EVE
Goonswarm Federation
#1 - 2012-01-06 14:19:40 UTC
Good morning,

I'm trying to [hopefully] find or [if all else fails] create a simple way of tracking a corporate wallet in excel. I've managed, thanks to this forum, to finally create an XML query that will return the API as it updates; however, this overwrites the old information each time, and I'm trying to save this data longitudinally.

I'm led to believe, through reading this forum and barely grasping the idea, that I'll need the API to constantly update into a database, which I can then pull out of when I want the data? Is that something that's manageable for a [very] basic coder, or am I starting to get in over my head? :)
Jenn Makanen
Doomheim
#2 - 2012-01-06 15:18:10 UTC  |  Edited by: Jenn Makanen
I'd suggest looking at something like Yapeal (http://code.google.com/p/yapeal/), which you can schedule to keep up to data with the database. (mysql works here. XAMPP (http://www.apachefriends.org/en/xampp.html) is a package which should give you pretty much everything you want).

And if you install the mysql odbc drivers, you can hook it directly into Excel for pulling out data. (Excel is substantially better at handling external data sources than open office's calc. Sure you can manage it with open office basic, but that's hardly as simple as just sticking in the xml url into a dialog box, and then getting the data out of it)


As an aside, you might be able to use Excel's import from web option to pull in the data from the api. and it has an option (hit the properties button) for appending new data to existing xml tables.

Edit: - Ignore the excel append option. it just adds it all again. no dedupe.

Database is still a good idea though.
Zy'or Tealon
Deep Core Mining Inc.
Caldari State
#3 - 2012-01-06 20:54:53 UTC
I'll whip you up a little program.