| Pages: 1 2 :: [one page] |
|
|
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Haile Korhal
Professional Amateurs
9
   |
Posted - 2016.09.11 05:04:11 -
[1] - Quote
My search-foo is pretty terrible and I haven't found any real resources for helping me with this problem, so I thought I'd post here and see if anyone has encountered similar issues or can point me in the right direction. This is going to go everywhere, so please bare with me.
I'm trying to learn how to import market data from Eve Market, using Fuzzworks (thank you!) as my guide and sole repository of knowledge (if there are any others I'd love to see them!). I've got a spreadsheet built in Excel that pulls data out of Jita just to test the principle to see if I'm even on the right track, and it works; I've got lots of data. So I am now trying to pull the same data out of a citadel.
I found the station_ids of my target test citadel and plunked that into the import, and I'm getting nothing out of it. Or rather, I'm getting everything with a static value of price=0 out of it. So I started digging into it to see if I could figure out why. I've discovered something even more confusing. So let me build you picture.
I've got a tab with the citadel's information imported into it.
I've got a tab with all the typeids in Eve imported into it.
I've got a tab with Jita's information imported into it.
I look up various items in the in-game market, search them up in the typeids tab, and then search for that typeid in either market tab. I'm always coming up with "No Results." At first I thought "maybe it was due to it being a citadel and not having information." So I checked the Jita tab, no results either. I've searched for "Dragonfly I", "Helium Isotopes", "Capital Hyperspatial Velocity Optimizer II", "Wyvern", "Revenant", etc. But, there are similarities. Plagioclase exists in both sheets just fine, but there aren't any on sale in the market in the citadel, so it wasn't an adequate target for this test.
I'd like to be able to pull all the same information you can out of Jita, out of this citadel. I thought it would be as simple as replacing all of the identifiers for Jita with the identifiers for this citadel, but that has proven to be moot so far. Is this not something that can be done yet with Citadels?
So I guess what I am getting at is that I really have no idea what I am looking at because it just doesn't make sense. Why do some items show up, but others aren't? I'm using the url on the Fuzzworks site with my name, a station id (for the citadel) / a region id (for Jita), and buysell=s. Am I missing something important?
I can't really find any other resources for learning how to build a proper url to pull from the Eve Market except for on Fuzzworks (and I do have to admit, it is still extremely hard to decipher even there). I know I need to put in some more effort to 'learn this for myself' but I cannot honestly find any more documentation or resources that I can read at my level. It is either "too advanced" or "not holistic" enough to actually mean anything. I wouldn't have posted here without doing as much homework as I can, and I can say that I am finally stumped enough to post here.
If you have any guidance, links, or anything, please eve-mail me or reply here. I'd love a discussion where I can learn something new. Even just a simple link to "go read this" would be sufficient if it helps me towards my goal. Thank you in advance,
Egregious Spreadsheet Services - For Spreadsheets as a Service to businesses, corporations, and higher, look no further!
|
Blacksmoke16
Resilience.
24
|
Posted - 2016.09.11 20:48:30 -
[2] - Quote
https://market.fuzzwork.co.uk/api/
Check out the power query section towards middle of the page. Might help you out a bit. |
Haile Korhal
Professional Amateurs
9
|
Posted - 2016.09.11 20:57:20 -
[3] - Quote
Those urls look a bit weird, are they eve-central?
I'll take a look at the Power Query when I get home tonight. I believe I am utilizing that function, I've just called it a different name. The steps listed there do not look familiar, as in I don't believe I had them as an option. But, I haven't slept in a while so I'm probably just misremembering things. Thanks for the suggestion, I'll post the results when I get them.
I'm mostly concerned about why my pulled market information doesn't even contain the whole list from Jita; when I clearly pulled the whole typeids from the game.
Would the theory at least be the same for a citadel? As in, replace the Jita identification information, for example, with a target citadel? After digging to find the citadel stuff of course. I would hope similar information can be used from citadels as is possible with npc stations, especially if we're supposed to start using them in place of!
Thanks again. More testing will follow this evening/tomorrow morning.
Egregious Spreadsheet Services - For Spreadsheets as a Service to businesses, corporations, and higher, look no further!
|
Blacksmoke16
Resilience.
24
|
Posted - 2016.09.11 20:59:33 -
[4] - Quote
If you are using eve-central i would switch to steve's aggregate data. Should be much more accurate. |
Haile Korhal
Professional Amateurs
9
|
Posted - 2016.09.11 21:10:14 -
[5] - Quote
You know, I've been using fuzzworks for my entire sole repository of knowledge (because I cant seem to find reputable help anywhere else) and I hadn't yet stumbled across this particular part of his site. I hadn't heard of his own aggregate stuff, although if it is just for the regions or hubs, then it won't be super useful for me. I'll still look into it, however. It looks like yet more knowledge to plumb.
I have a very basic understanding of how html works, and I'm trying to learn xml and all the other fiddly bits with this import stuff. My newest project is taxing my limits of comprehension and pushing me towards new horizons. Until now I've stayed away from all of this stuff because "it's so hard" and I'm not unimpressed with its apparent complexity. I wonder, after having lurked through the Eve Technology Lab for over a year quietly, if there is some underlying subject matter that I need to know first before trying to get involved with this craziness. It's almost as though everyone's speaking a foreign language, and the worst part is, I understand what every word means, but not the sentence in itself!
The json dataset example above the Power Query section looks to be the information that I want. I just need to figure out how to use json or whatever its called. I suppose vlookups will work wonderfully, but only if it is formatted properly I wager. Is there a way to get it to push from that code-look-a-like to an excel table? Or does that happen automatically? (Curses not being able to work on this here!)
I'm learning so much!
Egregious Spreadsheet Services - For Spreadsheets as a Service to businesses, corporations, and higher, look no further!
|
Messenger Of Truth
Butlerian Crusade
57
|
Posted - 2016.09.12 12:17:42 -
[6] - Quote
I think you might be running into the problem where CCP don't expose sell orders in citadels via CREST. Ranged buy orders show up but not sell orders.
Trade Hub Price Checker: stop.hammerti.me.uk/pricecheck
Visit "Haulers Channel" in game for all matters courier-related.
Citadel name/system API: stop.hammerti.me.uk/api
|
Haile Korhal
Professional Amateurs
9
|
Posted - 2016.09.12 18:50:08 -
[7] - Quote
Oh damn, I had read about that somewhere but I was hoping it had changed. Well this complicates things. I don't suppose it is possible to get other information out of it then? If sell orders aren't exposed yet (which I hope they are soon!), is it possible to get anything else?
I doubt anyone knows, but any idea when CCP might be expanding this functionality for us? Would it be worth filing a suggestion support ticket?
Egregious Spreadsheet Services - For Spreadsheets as a Service to businesses, corporations, and higher, look no further!
|
Messenger Of Truth
Butlerian Crusade
57
|
Posted - 2016.09.12 20:29:05 -
[8] - Quote
According to a forum post from CCP last week, CCP have plans to do more API support for citadels, but the team that would/will be working on it is working on support for a mobile app at the moment. So there will be stuff...just not yet...
Trade Hub Price Checker: stop.hammerti.me.uk/pricecheck
Visit "Haulers Channel" in game for all matters courier-related.
Citadel name/system API: stop.hammerti.me.uk/api
|
Haile Korhal
Professional Amateurs
13
|
Posted - 2016.10.09 22:23:34 -
[9] - Quote
Has there been any news regarding this topic yet?
Can we pull from the API any citadel market data yet?
Where can I check to follow up on this, so I don't have to spam the Technology Lab every time I'm looking for an update?
I'm sure it has to be soon! Citadels have been out for a while, and those markets are getting pretty jam packed. Plus I really need to finish up my citadel market spreadsheet! Not only am I anxious for it, so is my customer. :o
Egregious Spreadsheet Services - For Spreadsheets as a Service to businesses, corporations, and higher, look no further!
|
Draconas109
The Society of Mutual Respect
Care Factor
56
|
Posted - 2016.10.17 00:53:18 -
[10] - Quote
+1 I want citadel market info in crest asap, having to do it all by hand is getting ridiculous |
|
|
Haile Korhal
Professional Amateurs
14
|
Posted - 2016.11.03 02:50:49 -
[11] - Quote
I am still learning about all of this craziness, but I believe I read somewhere that CREST is something like a 3d data architecture, which Excel uses a 2d architecture, so in order to get it to play together you have to flatten it. I believe I also read something about Fuzzworks saying 'it's possible, but hard' or something like that. Considering I don't want to get into programming an entire 3rd party tool, and I'd rather stay within the realm of a spreadsheet, I don't believe I can use CREST; unless I am completely not understanding what I am reading, and I will admit everything I've read about CREST seems to be written in some form of older than old english. lol-.-lol
So, while we still need CREST data for citadel stuffs, can we have that for XML so we can use that in a spreadsheet? Right now I have to manually fly to 24 different citadels spread out over vast distances, and manually copy their entire content (from the sell market) into a spreadsheet so I can crunch that raw data it into information. It's a lot of work. :/
I know how to find the Citadel station_id, why cant we just import like we do for stations? ccpls! :o
Egregious Spreadsheet Services - For Spreadsheets as a Service to businesses, corporations, and higher, look no further!
|
Blacksmoke16
Resilience.
30
|
Posted - 2016.11.03 02:56:44 -
[12] - Quote
https://market.fuzzwork.co.uk/api/
Look towards the top of the page for the 'Power Query' section. May be of some use for you. |
Haile Korhal
Professional Amateurs
14
|
Posted - 2016.11.11 18:54:35 -
[13] - Quote
Thank you for the reminder, I looked at that before when you first mentioned it and I looked at it again, can that pull the data out of a Citadel? That's what I'm trying to get at. I can't seem to get anything to pull anything out of a Citadel.
Anyway, I am thinking I need to redirect all of my attentions at this point. CCP mentioned ESI and I have never heard of that stuff before, could it do what I am looking to do?
1. Import list of items for sale in a citadel
That's it. I can use vlookup and sums and such to get the data to look how I want, but I'm having trouble getting the data into a spreadsheet to start with. Right now I fly to each citadel, which are several dozen jumps apart, and copy the market information one line at a time, by hand, into a spreadsheet, and then I can get it to act how I want.
If I need to learn ESI or CREST or XML for this, I want to, but I am finding it nearly impossible to teach myself. I really feel like I am missing something really basic that would be the key to unlocking all of this knowledge.
I know other people have said CREST doesn't expose such data, so I guess that's out until they do. But, I'm not a programmer, and I know very little scripting, but I'm willing to learn what I need to know in order to get this spreadsheet to work; I just need to know what I need to learn so I can go find it.
Egregious Spreadsheet Services - For Spreadsheets as a Service to businesses, corporations, and higher, look no further!
|
Blacksmoke16
Resilience.
32
|
Posted - 2016.11.11 19:15:56 -
[14] - Quote
IIRC market data is not in CREST atm except buy orders. Will have to wait for ESI market endpoints to get that.
So yea, are pretty much limited to only stations for the moment.
Once an endpoint is released you could prob make a script to get that information and put it into your sheet. However I don't know what you are doing with your sheet so depending on how many items/regions you are fetching it could take a while. At that point it may be better to use an aggregate like steve's. |
Haile Korhal
Professional Amateurs
14
|
Posted - 2016.11.11 20:07:39 -
[15] - Quote
Damn, that is what I was really afraid of. I don't suppose you know of a way to copy large amounts of data out of the market window by hand? The game only lets you select one row at a time, grr. Thank you for the quick reply, I'll continue to sit and stew. CCPlease!
I'm just trying to import a list of items, how many are for sale, and then the sum of their value (probably just an estimate off Jita value multiplied by their quantity).
Egregious Spreadsheet Services - For Spreadsheets as a Service to businesses, corporations, and higher, look no further!
|
Blacksmoke16
Resilience.
32
|
Posted - 2016.11.11 20:26:48 -
[16] - Quote
Could bring up that item in the market viewer, click 'export to file' at the bottom and then parse the data in that file by copy/pasting it into your sheet.
However not sure how you would parse which are buy and which are sell. |
Kendepp
Legion of xXDEATHXx Support
Legion of xXDEATHXx
14
|
Posted - 2016.11.18 19:25:18 -
[17] - Quote
Dear ccp, we REALLY need market data for our apps. Please give any info whether will you do it or not and any estimated date. I dont even know if i need to collect personal api for marketdata or to wait till you refresh your api code.
thx! |
GoldLeader
The Brave Dojo
Brave Collective
0
|
Posted - 2016.11.22 15:04:07 -
[18] - Quote
One more bump for this one.
CCP: This is the ONLY thing keeping my alliance from moving into a citadel. We can't reliably stock a citadel market if we can't reliably access the data. |
Haile Korhal
Professional Amateurs
20
|
Posted - 2016.12.02 12:02:43 -
[19] - Quote
Another bump for the original problem.
On another issue, I couldn't get the eve central API to work at all, it would never return a value no matter what I did with it, so I tried to use Eve Marketdata and I feel like I've gotten further with it, but I'm still getting an error where it says "imported content is empty." I built the query with the query builder for Google Docs API Features > Location Prices
API to use: price_type_station_sell_min
Your character name: Haile Korhal
type_id is in column: P
Data is in column: ??? I don't know what Data it is talking about. So I put in R because I dunno what to put in it.
Starting on row: 45
Ending on row: 69
Also, how do I parse it the Jita station id?
It gave me this: =ImportXML("http://eve-marketdata.com/api/price_type_station_sell_min.xml?char_name=Haile Korhal&type_id="&JOIN(",",$P45:$P69)&"&v="&JOIN(",",$R45:$R69), "/emd/val")
Whic returns that error. Here's a picture of the very few items I'm trying to get, and their TypeIDs which I pulled out of the Fuzzworks document.
Any recommendations?
Egregious Spreadsheet Services - For Spreadsheets as a Service to businesses, corporations, and higher, look no further!
|
Awkward Pi Duolus
Pator Tech School
Minmatar Republic
187
|
Posted - 2016.12.02 19:39:24 -
[20] - Quote
GoldLeader wrote:One more bump for this one.
CCP: This is the ONLY thing keeping my alliance from moving into a citadel. We can't reliably stock a citadel market if we can't reliably access the data.
This. It confused this life out of me when some of my orders were not showing up in downstream analysis, until I realized that CREST does not pull data from citadels.
CCP... what gives?
|
|
|
Akhillez
Sons-of-Liberty
Manifesto.
2
|
Posted - 2016.12.28 13:23:30 -
[21] - Quote
Bump....
Also, this is the only thread I've found anywhere on the internet about this issue. No market bloggers or youtubers or eve redditters seem to be concerned... but this seems like a HUGE problem with eve right now... Anyone have any more links of threads or posts or anything to watch for the first news of citadel support and walkthroughs of importing the citadel data to google sheets?
|
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
6330
|
Posted - 2016.12.28 15:25:32 -
[22] - Quote
It is being worked on.
It's because CCP are having to make the ACLs work with it, which is a trifle more complicated than just showing the market data.
When it gets released, I'll be updating my stuff with it 
Following the developers.eveonline.com blog is going to be worthwhile, and I'll almost certainly be yelling about it on twitter, and slack. and probably my blog.
Woo! CSM XI!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Akhillez
Sons-of-Liberty
Manifesto.
3
|
Posted - 2016.12.29 00:06:21 -
[23] - Quote
How can we help push CCP to focus on this? |
booty hunter
Sons-of-Liberty
Manifesto.
0
|
Posted - 2016.12.29 00:26:47 -
[24] - Quote
bump  |
Haile Korhal
Professional Amateurs
22
|
Posted - 2016.12.29 17:07:01 -
[25] - Quote
^ Yep, that's the only way imo. Show the developers that you're interested in an issue, and if enough people get behind it, they might actually see it.
Sadly they do already know about this issue (I'd home) since all of Eve runs off spreadsheets and 3rd party developer programs. They HAVE to have a plan in place not to leave all of us out to dry when it comes to market data. It's a big deal in Eve, our Spreadsheets in Space.
Steve's got the knowing of the numbers and if anyone figures it out it's going to be him! So we just have to sit tight and be patient and wait for a solution. It'll come, I have faith.
Egregious Spreadsheet Services - For Spreadsheets as a Service to businesses, corporations, and higher, look no further!
|
Akhillez
Sons-of-Liberty
Manifesto.
3
|
Posted - 2017.01.12 11:17:05 -
[26] - Quote
Bump, trying to keep this thread alive :) Come on CCP, hone in on this problem |
Dusty Meg
Echelon Research
Goonswarm Federation
101
|
Posted - 2017.01.12 14:28:18 -
[27] - Quote
Probably be out next week ish, Hopefully :)
Creater of the EVE animated influence map http://www.youtube.com/user/DustMityEVE
|
Conquerer Taygeta
4S Corporation
Goonswarm Federation
5
|
Posted - 2017.01.13 23:17:25 -
[28] - Quote
bump.... i need the market data from the citadels aswell for my project ;) |
Somi Zulfi
Pandemic Horde Inc.
Pandemic Horde
5
|
Posted - 2017.01.15 14:53:25 -
[29] - Quote
Definately needed. |
Ailbhe
Blackout Cartel
Solyaris Chtonium
0
|
Posted - 2017.01.16 20:39:05 -
[30] - Quote
Yeah, it frustrating doing it the old school way :( |
|
|
Mr Tesla
Eagles of Stars
15
|
Posted - 2017.01.20 07:45:39 -
[31] - Quote
Bump! It is very important. |
Somi Zulfi
Pandemic Horde Inc.
Pandemic Horde
5
|
Posted - 2017.01.20 13:44:56 -
[32] - Quote
Hoping for a good news soon :) |
Conquerer Taygeta
4S Corporation
Goonswarm Federation
5
|
Posted - 2017.01.31 17:41:28 -
[33] - Quote
Bump |
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
6408
|
Posted - 2017.01.31 19:37:52 -
[34] - Quote
No need to bump.
It's out now. (I've not quite implemented it yet on my market site, but it's out)
Only downside: you request the market per citadel. (but you get everything they have)
Woo! CSM XI!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Akhillez
Sons-of-Liberty
Manifesto.
3
|
Posted - 2017.02.12 04:01:53 -
[35] - Quote
So has anyone figured out how to get the price data into a google sheet yet? |
Somi Zulfi
Pandemic Horde Inc.
Pandemic Horde
9
|
Posted - 2017.02.13 14:50:12 -
[36] - Quote
Steve Ronuken wrote:No need to bump.
It's out now. (I've not quite implemented it yet on my market site, but it's out)
Only downside: you request the market per citadel. (but you get everything they have)
Greetings,
How can I extract that from your website tools?
Is it possible?
Thanks |
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
6465
|
Posted - 2017.02.13 16:06:19 -
[37] - Quote
Citadels are now implemented on my site :)
However, I'm just rolling them into the region, wrt the prices I'm providing via the api on the site.
Woo! CSM XI!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Somi Zulfi
Pandemic Horde Inc.
Pandemic Horde
9
|
Posted - 2017.02.13 19:35:43 -
[38] - Quote
Steve Ronuken wrote:Citadels are now implemented on my site :)
However, I'm just rolling them into the region, wrt the prices I'm providing via the api on the site.
do you have excel guide to querying through your api? |
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
6465
|
Posted - 2017.02.13 20:56:57 -
[39] - Quote
on the API page :D
Woo! CSM XI!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Somi Zulfi
Pandemic Horde Inc.
Pandemic Horde
9
|
Posted - 2017.02.17 10:45:28 -
[40] - Quote
Steve Ronuken wrote:on the API page :D
I put the id of the citdel but i got null values in return.... |
|
|
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
6484
|
Posted - 2017.02.17 12:50:00 -
[41] - Quote
As I said, I'm rolling citadel prices into the regional averages.
(in an attempt to keep the data down to a minimum)
Woo! CSM XI!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Somi Zulfi
Pandemic Horde Inc.
Pandemic Horde
9
|
Posted - 2017.02.17 13:06:56 -
[42] - Quote
Steve Ronuken wrote:As I said, I'm rolling citadel prices into the regional averages.
(in an attempt to keep the data down to a minimum)
is there any other way to get market data from a particular citadel?
As you may have gathered im a noob :) |
Haile Korhal
Professional Amateurs
29
|
Posted - 2017.02.17 20:52:10 -
[43] - Quote
I haven't looked into this much in a while, I am glad the data is out there. I assume that means there is a way to extract the information out of a particular Citadel now? My original use case was, I had a list of 20 Citadels spread across New Eden and I needed to extract the market data from them, so that the owning alliance knows the "stocks" some markets had, and could restock the markets as sales happened.
I will be looking into these things again in a couple of weeks, what a time to be alive! Thanks Steve for making these confusing things understandable to the likes of us normal folk.
Egregious Spreadsheet Services - For Spreadsheets as a Service to businesses, corporations, and higher, look no further!
|
Amodos Oblivion
Pandemic Horde Inc.
Pandemic Horde
0
|
Posted - 2017.03.09 21:45:15 -
[44] - Quote
Hello,
i'm trying to use API too, but i fail when i search for citadel market data, and i didn't find it on your website.
Is it still possible to get it ?
Thx ! |
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
6544
|
Posted - 2017.03.09 22:26:58 -
[45] - Quote
Right now, I'm not providing an API which gives order data down to that level.
If you want to pull a specific citadel's data, you'll have to do that yourself. Sorry about that.
Woo! CSM XI!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Professor JinMine
Project Fruit House
Solyaris Chtonium
2
|
Posted - 2017.03.10 17:25:57 -
[46] - Quote
Haile Korhal wrote:My original use case was, I had a list of 20 Citadels spread across New Eden and I needed to extract the market data from them, so that the owning alliance knows the "stocks" some markets had, and could restock the markets as sales happened.
Our corp uses a Google Spreadsheet that does exactly what you say.
Here are some screenshots
It's backed by a modified version of Google Script posted here some weeks ago (here's the forum link).
Unfortunately I don't have the permission to share the sheet...just wanted to let you now it can be done and how we do it. |
Amodos Oblivion
Pandemic Horde Inc.
Pandemic Horde
0
|
Posted - 2017.03.12 18:49:41 -
[47] - Quote
Steve Ronuken wrote:Right now, I'm not providing an API which gives order data down to that level.
If you want to pull a specific citadel's data, you'll have to do that yourself. Sorry about that.
Ok, but it's look like to have this data, you need structureID, but how get it ? I tried with ESI and the response was that it was private, or something like this.
Maybe i did wrong or corp can hide it ? |
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
6546
|
Posted - 2017.03.12 19:29:46 -
[48] - Quote
Amodos Oblivion wrote:Steve Ronuken wrote:Right now, I'm not providing an API which gives order data down to that level.
If you want to pull a specific citadel's data, you'll have to do that yourself. Sorry about that. Ok, but it's look like to have this data, you need structureID, but how get it ? I tried with ESI and the response was that it was private, or something like this. Maybe i did wrong or corp can hide it ?
The easiest way to get a structure ID is by bookmark, by job, by market order or by asset.
(there is a list of public structures. but you need to look at each one to find out where it is)
You also have to authenticate with SSO to be able to retrieve market orders from structures, with ESI. (this is so it can handle private markets)
That auth requirement makes it somewhat harder to manage in powerquery (I've yet to get that working. but I've only put in a few hours). Doing it with googledocs shouldn't be too hard. doing it in excel with xlwings should be dead easy.
Woo! CSM XI!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Amodos Oblivion
Pandemic Horde Inc.
Pandemic Horde
0
|
Posted - 2017.03.12 21:29:44 -
[49] - Quote
Steve Ronuken wrote:Amodos Oblivion wrote:Steve Ronuken wrote:Right now, I'm not providing an API which gives order data down to that level.
If you want to pull a specific citadel's data, you'll have to do that yourself. Sorry about that. Ok, but it's look like to have this data, you need structureID, but how get it ? I tried with ESI and the response was that it was private, or something like this. Maybe i did wrong or corp can hide it ? The easiest way to get a structure ID is by bookmark, by job, by market order or by asset. (there is a list of public structures. but you need to look at each one to find out where it is) You also have to authenticate with SSO to be able to retrieve market orders from structures, with ESI. (this is so it can handle private markets) That auth requirement makes it somewhat harder to manage in powerquery (I've yet to get that working. but I've only put in a few hours). Doing it with googledocs shouldn't be too hard. doing it in excel with xlwings should be dead easy.
Ok thanks i get it !
But as you said, to get the market of a structure we need SSO connection, and is it possible to do it with googlesheet ? If it's possible and you have any tuto :D |
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
6546
|
Posted - 2017.03.12 21:36:05 -
[50] - Quote
Amodos Oblivion wrote:
Ok thanks i get it !
But as you said, to get the market of a structure we need SSO connection, and is it possible to do it with googlesheet ? If it's possible and you have any tuto :D
No tutorial at the moment.
It's entirely possible to do though.
First you set up a new application on developers.eveonline.com, with the appropriate scopes.
Then you use something like postman ( https://www.getpostman.com/ ) to do the initial authentication, to get the refresh token.
Then, finally, in google sheets, you write a custom function which uses that refresh token to authenticate, then retrieve the data.
I'll try and get something written up.
Woo! CSM XI!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
|
|
Amodos Oblivion
Pandemic Horde Inc.
Pandemic Horde
0
|
Posted - 2017.03.12 21:43:00 -
[51] - Quote
Steve Ronuken wrote:Amodos Oblivion wrote:
Ok thanks i get it !
But as you said, to get the market of a structure we need SSO connection, and is it possible to do it with googlesheet ? If it's possible and you have any tuto :D
No tutorial at the moment. It's entirely possible to do though. First you set up a new application on developers.eveonline.com, with the appropriate scopes. Then you use something like postman ( https://www.getpostman.com/ ) to do the initial authentication, to get the refresh token. Then, finally, in google sheets, you write a custom function which uses that refresh token to authenticate, then retrieve the data. I'll try and get something written up.
xD
I'll watch it, looks like pretty cool but hard to make :D
Btw, thx for reactivity, you're insane bro ! |
Haile Korhal
Professional Amateurs
29
|
Posted - 2017.03.13 21:10:30 -
[52] - Quote
Steve is a monster at this stuff, it breaks my brain. Pretty much all of this is well over my head, which is unfortunate, because I want to be able to understand these things. I just have so much trouble teaching myself how these things should work. Sigh. I'll happily wait for tutorials though and maybe I can reverse engineer the method behind the madness.
Professor JinMine wrote:Haile Korhal wrote:My original use case was, I had a list of 20 Citadels spread across New Eden and I needed to extract the market data from them, so that the owning alliance knows the "stocks" some markets had, and could restock the markets as sales happened.
Our corp uses a Google Spreadsheet that does exactly what you say. Here are some screenshotsIt's backed by a modified version of Google Script posted here some weeks ago ( here's the forum link). Unfortunately I don't have the permission to share the sheet...just wanted to let you now it can be done and how we do it.
So... Your script pulls the "current sell orders" for items from all of your citadels and compares it to a list of pre-determined quantity thresholds so that you can know when a particular citadel's "stock of X" gets low, so someone can take more of x to it and list it for sale? That's amazing if so, I would love to have a point of contact to email questions to. I've been beating my head against this thing for going on 6 months now and I've all but given up. Knowing it's possible just blows my mind, why cant I figure it out? :(
Egregious Spreadsheet Services - For Spreadsheets as a Service to businesses, corporations, and higher, look no further!
|
Amodos Oblivion
Pandemic Horde Inc.
Pandemic Horde
0
|
Posted - 2017.03.14 19:43:55 -
[53] - Quote
Hello again,
i did what you said, use postman to get token. Btw, postman is really cool.
Then, i still use it to get the json market data.
I wanted to use a a script to extract data from this json (https://gist.github.com/paulgambill/cacd19da95a1421d3164)
I saved the json on my computer, but can't access it from googlesheet without if it's not on web, so i tried to use a site to store it (http://myjson.com/) but the file is too big.
i'm actully blocked, what can i do ? |
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
6550
|
Posted - 2017.03.14 20:08:56 -
[54] - Quote
https://www.fuzzwork.co.uk/2017/03/14/using-esi-google-sheets/
Finally got round to writing it :D
Woo! CSM XI!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Amodos Oblivion
Pandemic Horde Inc.
Pandemic Horde
0
|
Posted - 2017.03.14 20:50:02 -
[55] - Quote
Steve Ronuken wrote:https://www.fuzzwork.co.uk/2017/03/14/using-esi-google-sheets/
Finally got round to writing it :D
<3 Thx |
|
|
| |
|
| Pages: 1 2 :: [one page] |