Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Block Ukx
|
Posted - 2007.07.12 18:47:00 -
[1]
I normallly log into my account, save the WalletTransactions.csv to disk, and do the anaysis in excel.
Anyone knows how to download the wallet export information straight into excel using the API key?
Thanks in advanced.
|
Eddie Knight
Empirius Enigmus Navy Dark Matter Coalition
|
Posted - 2007.07.13 06:23:00 -
[2]
It depends a lot on how you can implement it and what format you want to do it in. What I mean is that Excel can read various formats and the simplest would be .csv (comma separated values) in which each row has the values on each column separated by commas.
Another easy way to do it (if you have Excel 2007) is to use the .xlsx format which is actually XML code. The only problem you'll have is if you want to use .xls files since those are binary.
Because the first two formats are easy to generate I will only tell you about the third. I found the following ways:
PHP and PEAR http://www.sitepoint.com/article/pear-spreadsheet_excel_writer
PHP only http://paggard.com/projects/xls.generator/ (commercial product)
.Net http://www.activexls.com/ (commercial product)
_____________
|
Miranda Duvall
Gallente OPM Holdings
|
Posted - 2007.07.13 06:50:00 -
[3]
If you can get it in xml format from the api site, you can import it directly into excel.
make it a web datasource, url see documentation. for passing the key it goes like this: http://apiurl/whatever.xml.aspx?charID=123456789&apiKey=blablabla&accountID=9876544321
just find the ID's and the key you need, import it into an empty sheet in excel and see what happens... you can probably figure it out from there
My Skills -Invention HowTo |
Miranda Duvall
Gallente OPM Holdings
|
Posted - 2007.07.13 08:26:00 -
[4]
try this URL for the XML version: http://api.eve-online.com/corp/WalletJournal.xml.aspx?userID=123456&apiKey=abracadarbraabracadarbraabracadarbraabracadarbraabracadarbra&characterID=987654321&accountKey=1000
replace the placeholders with your own key and user&charID
for the CSV use WalletJournal.csv.aspx, the rest of the URL is the same
My Skills -Invention HowTo |
Miranda Duvall
Gallente OPM Holdings
|
Posted - 2007.07.13 08:30:00 -
[5]
Hmmm i just found out there's no testing this:
use the URL once and it gives you the data, after that you're forbidden to ask for the same data again:
<error code="102">Expected beforeRefID = 987654321: wallet previously loaded.</error>
This means you can never have multiple tools/sheets needing the same data
My Skills -Invention HowTo |
Block Ukx
|
Posted - 2007.07.13 11:54:00 -
[6]
I can download the server csv data into an xmlhttp object using a script in excel. But I havenĈt figure out how to parse the xmlhttp.response into a new sheet. Instead, IĈm using brute force. IĈm saving the data into a .csv file and then opening it into an excel sheet.
This is how the last bit of my script looks
Set fs = CreateObject("Scripting.FileSystemObject") Set fname = fs.CreateTextFile("c:\tempwallet.csv", True) fname.WriteLine xmlhttp.responseText fname.Close
Workbooks.OpenText Filename:="c:\tempwallet.csv", DataType:=xlDelimited, ConsecutiveDelimiter:=True, Comma:=True
I was wondering if there is a way to dump the data into an excel sheet without using the temp file.
|
Miranda Duvall
Gallente OPM Holdings
|
Posted - 2007.07.13 15:55:00 -
[7]
Try it the way i described it, it will give you a sheet full of data which you can VLOOKUP etc from other sheets
My Skills -Invention HowTo |
Imuran
|
Posted - 2007.07.14 01:25:00 -
[8]
Taking a slightly diffent approach: Writing an VB.NET ap that amongst other goodies downloads the data into an access database that can then be manipulated in Excel.
Limited to the Office 2000 products so I have not got the luxury of some of the later toys.
|
Vaeldan Athargan
Copperhead Arsenal
|
Posted - 2007.07.14 14:32:00 -
[9]
Originally by: Miranda Duvall Hmmm i just found out there's no testing this:
use the URL once and it gives you the data, after that you're forbidden to ask for the same data again:
<error code="102">Expected beforeRefID = 987654321: wallet previously loaded.</error>
This means you can never have multiple tools/sheets needing the same data
If you read the docs, it says you can only request this data once an hour. So it is okay to cron the job, but if you are building an app, you'll need to account for this, informing the user or using a timer as EveMon does.
|
Miranda Duvall
Gallente OPM Holdings
|
Posted - 2007.07.15 22:04:00 -
[10]
cron??? blashemy!!! there is no cron on windows, its called scheduled task... unix is evil!!
OK i'm done ranting...
I thought results were just cached, meaning you would need to wait an hour to get FRESH data.
My Skills -Invention HowTo |
|
Sunset Atrea
Minmatar Sunset Asset Management
|
Posted - 2007.07.19 13:28:00 -
[11]
I was playing around with this at work this morning.
You can do Data > Import External Data > Import Data (Office 2003) and simply type in the URL of the specific .CSV thing you want. Excel will then import the CSV, and you get the Formatting wizard.
You can then Comma deliminate, and sort out your sheet. Right clicking on the data and selecting "Update Data" or writing a macro on a button will refresh the data.
Problem: For market transactions you only get a week's worth of data, and I have no idea how to merge this data into a complete recordset without a LOT of manipulation, and without duplicate records.
The data would require a lot of manipulation, and probably automation to make it worth my while using it.
I will be developing something (hopefully) in my spare time, but I reckon a database is the way to aim, with some sort of GUI.
I am more familiar with Excel than PHP so right now Excel is my best available solution, although it may lack functionality.
|
Tonto Auri
|
Posted - 2007.07.19 19:51:00 -
[12]
Originally by: Miranda Duvall cron??? blashemy!!! there is no cron on windows, its called scheduled task...
http://nncron.ru/
Welcome to reality... -- Thanks CCP for cu<end of sig> |
Sunset Atrea
Minmatar Sunset Asset Management
|
Posted - 2007.07.20 15:13:00 -
[13]
Okay after another day @ work, i've now got a marco that will merge my data for me. I still don't want to directly link to my API info as I haven't tried error handling from a blank document yet.
Right now, I have to manually download the files to my HD, which is okay, cause if my spreadsheet ****s up I will have backups and not have to wait an hour.
All i've sorted so far is Corp Market Journal and Corp Wallet, and after every update new information is inserted into my holding spreadsheet.
The only problem I can see with this is that excel is limited to 60k or so rows, which is limiting. I may have to convert this to Access or MySQL/PHP sooner rather than later. Most likely i'll convert it to Access and add a GUI front end for stats and stuff. |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |