Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
1upnate
Empirical Holdings
0
|
Posted - 2014.04.19 01:08:00 -
[1] - Quote
Ive read many times that probably doing what I'm trying to do is a complete waste of time so if that is truly correct, stop me now! haha
What I'm trying to do: I want to be able to call mineral prices from the eve-central website into a MS Access database.
One I have the mineral prices in there, I can do just about everything else I need with just using inter-database relations and local imports and schtuff. ya know.
Anyways,not sure how the best way to go about doing it is. I'm decent with macros and visual basic so if thats the best way, thats fine.
If someone could just point me in the right direction, that'd be great... Thanks
p.s. |
Hel O'Ween
Men On A Mission
69
|
Posted - 2014.04.19 11:58:00 -
[2] - Quote
Well, first of all, you need to make up your mind about which method you want to use to access EVE Central's data. Online XML queries or daily dumps as CSV. See http://dev.eve-central.com/evec-api/ for details.
If that still leaves questions open, come back here and post them.
For the XML query, browse to my EWA's web site (see signature) and grab the source code package provided there, it's written in VB6. Locate the class module cEVECentral.cls. That should give you a decent start. EVEWalletAware - an offline wallet manager. |
1upnate
Empirical Holdings
0
|
Posted - 2014.04.19 23:31:00 -
[3] - Quote
although I understand your coding, I'm afraid I probably dont have enough experience to try and work with something like that myself. so say I go with the daily csv option... would that be able to be automated somehow? Obviously I'd like prices and such to automatically update when I open the database |
Hel O'Ween
Men On A Mission
69
|
Posted - 2014.04.21 14:36:00 -
[4] - Quote
Well, now you've spotted my weakness.
I have to admit that although I use Access as my database, I've never really used Access itself other than to create and maintain (empty) database.
Query Google for something like "ms access automate csv import". EVEWalletAware - an offline wallet manager. |
Tyrendian Biohazard
Ubiquitous Hurt Exodus.
274
|
Posted - 2014.04.24 19:41:00 -
[5] - Quote
I think I got what you are trying to do here. Hopefully this helps.
For a while I was using Powershell to dump market prices into text files for a personal project. I believe Powershell is capable of taking data and passing it to a database as well. I know you can dump it into a csv. I had the Powershell scripts setup in a batch job that ran every 5 minutes.
Note, I am by no means an expert on this. There may be better or more efficient ways of doing this. I barely look at code or scripting and most of this was what I put together from tutorials I read online.
Example:
http://api.eve-central.com/api/marketstat?typeid=29668&typeid=34&typeid=35&typeid=36&typeid=37&typeid=38&typeid=39&typeid=40&usesystem=30000142
NOTE: You need to copy/paste this link. Clicking it doesn't adjust for the & and you won't get all the data.
The link was used to pull market data from typeids and listed system (in this case, Jita). This can also be changed to do by region if wished. Using this link we could set it up in Powershell for manipulation.
[xml]$jita = (New-Object System.Net.WebClient).DownloadString("http://api.eve-central.com/api/marketstat?typeid=29668&typeid=34&typeid=35&typeid=36&typeid=37&typeid=38&typeid=39&typeid=40&usesystem=30000142")
From there, it really only takes one line to grab data you want and dump it in.
$jita.evec_api.marketstat.type | % {$_.buy.avg} | out-file -encoding UTF8 c:\EveData\JitaData\AverageBuy.txt
This line drills down in the XML, then takes the data from Buy > Average and outputs it to a .txt file (I added the UTF8 because the program I was using only could import information in that format).
You can use this same format to pull other data
$jita.evec_api.marketstat.type | % {$_.buy.max} | out-file -encoding UTF8 c:\EveData\JitaData\MaxBuy.txt $jita.evec_api.marketstat.type | % {$_.sell.min} | out-file -encoding UTF8 c:\EveData\JitaData\MinSell.txt
These two give you the maximum buy orders, and minimum sell orders off the same data pull.
Hopefully this helps. My twitch stream to help new players: http://www.twitch.tv/biohazrd51
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |