Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Japetus
Mors et Tributum The DNA Conglomerate
0
|
Posted - 2017.01.07 07:25:27 -
[1] - Quote
Ive done a search of this forum and google and haven't found an answer yet, not saying there isn't one but for what its worth I did try to find it on my own first.... my disclaimer is I have been told that my google search skills can be lacking at times.
Anyway I was writing some stuff in excel to make my life easier... I know how to pull Crest market data in it, I know how to use some of the eve API but is it possible to use the eve SSO in excel?
I know its mainly used for ppl making their own apps and programs or websites... but I have no clue how to go about it in excel.
I dont need a complete step by step, unless you have one handy... but if nothing else can you guys say if its possible or not and maybe point me in the right direction as to my figuring out the steps?
Thanks. |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
6357
|
Posted - 2017.01.07 18:38:06 -
[2] - Quote
https://groups.google.com/forum/#!topic/excel-ramblings/sm19u_UWVHg
Eve's SSO is standard oauth2, so you just need to work with that.
(if you can do python, look at XL wings. it's easier to work with than vba, as far as I'm concerned)
Woo! CSM XI!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Japetus
Mors et Tributum The DNA Conglomerate
0
|
Posted - 2017.01.08 03:30:31 -
[3] - Quote
Thanks!
So followup question about crest..
Ive been looking at the public crest options now that I know I can use it in excel...
http://eveonline-third-party-documentation.readthedocs.io/en/latest/crest/eve/eve_market.html
On that site I see I can either download a full regions market data which I can see a lot of possibilities with or I can focus the results down to say 1 regions sell orders of a specific item.
So My question is this... which is easier on both excel and on the crest server... getting the entire market once then refreshing it say every half hour or hour and using vlookup and index and such to index the bulk market orders
or would it be better to lookup multiple items with a very specific item query? So I would run multiple queries, again every half hour or so.
Also another question... I know i can get typeids in a large list... but is there a way to call a speicifc item ID and get its name? again it may be better to just download the whole list and just not refresh it very often but Im trying to learn the system as well as possible |
Japetus
Mors et Tributum The DNA Conglomerate
0
|
Posted - 2017.01.08 03:47:40 -
[4] - Quote
also on that note I wonder which would be better... a full download of itemTypes and use vlookup in the same worksheet..... do MANY individual small queries on a specific itemtype number to get the name.... or lastly just do it the old fasioned way and just download the SDE to a directory and just reference that file with the excel sheet
CCP are giving me too many options! lol |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
6357
|
Posted - 2017.01.08 04:37:57 -
[5] - Quote
I'd suggest getting the SDE to prevent a requirement to do lookups against the api, for static data :)
Either load it, or just import the sheet.
(tbh, I'd suggest using something other than excel to get the market data in the first place, and dump it in a database)
Woo! CSM XI!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Japetus
Mors et Tributum The DNA Conglomerate
0
|
Posted - 2017.01.08 06:50:44 -
[6] - Quote
Ofc i guess its pointless to do anything with crest since they are discontinueing it for that new api right? |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |