ImportXML Revisited
Ойындар
Eve Business Insider takes an investigative approach to Dynamic Spreadsheeting and API based methods in the context of production or market trading for Eve Online. Subscribe for more content!
Start an account and get 250,000 SP:
secure.eveonline.com/signup/?i...
Music:
"Spellbound" Kevin MacLeod (incompetech.com)
Licensed under Creative Commons: By Attribution 3.0 License
creativecommons.org/licenses/b...
Revised Tradesheet Template:
docs.google.com/spreadsheets/...
Link to the typids.csv by fuzzwork:
www.fuzzwork.co.uk/resources/t...
Пікірлер: 63
Yes please, i wanna learn programming with API's :)
I found your channel because of the old market spreadsheet videos about a year ago and when trying to find them again was glad to see new uploads including this one. I guarantee you there a lot of interest. Subbed, notifications on and I really can't wait for the full video. Trying to get back into my manufacturing empire
Love the new format for these videos. The thumbnails in particular caught my eye and brought me to your channel. Would love to see an API level video that you mentioned.
I love your videos. Your videos have contributed to over 10b of my assets because they are what helped me make the isk to buy them :) I would love to see some videos that dive into the programming.
Thanks would love to see more of those
Yes, please continue to make these videos.
an api programming video at this level of detail would be perfect!
thank you for that visual view of dynamic spreadsheeting.
Just to point out; you can change the config cell B15 to =JOIN(",",FILTER(Lookups!B2:B,ISNUMBER(Lookups!B2:B))) which will return all Type Ids in B column, comma separated, with no extra commas, removing the need to manually update it!
that's man :D I def would love to see more vids and tutorials. keep them coming for sure.
Great videos man, keep up the good work!
Great presentation, very insightful! Thanks.
please talk about eve api based programming!
Hopefully we get some more stuff soon. Love EBI's work.
Yes always interesting in more. Im starting out so my needs are simple for now but like to grow as you release more videos. Thanks
please keep making videos like this one!!!! make one like the dynamic spreadsheet video but for programming your own api pulls
Thx a lot for the Tradesheet. I could steal (ahem) a good chunk of it and use it for my own needs.
Great video! How did you make prices updating in your spreadsheet?
Yes Pls! Highly interested in a Tutorial for Excel as well :)
Got into Moon mining, and this is what i needed. Nice.
Yes there's interest for more!
very good exposé, i have my excel for all my production using API since years because google dont like when i want see the profit on every bpo of the game xD I really want see a tutorial about api interaction when using C# if possible ^^
o hi boki, i just saw your avatar pic :D and then recognised your voice,
Could i see an updated video on how to make these sheet sense i only buy and sell 30 items
More, more, more! (...please!)
Is there a way to also Import the volume per day of an item? I would assume it would be something similar to "s&minmax=min" and "b&minmax=max".
Hey guys. How can i pull prices from other trade hubs then Jita with this sheet? And would you say eve-market have up to date prices? People are saying they are showing old prices more often then not. Would love more of this. Good job.
Imported Xml content can not be parsed. on the results sheet when I copy
Api programming would be cool. I tried creating your sheet though all the results come out at 0 what can I use, and how can I see the raw data?
more of these videos please
Video about making this in programming language like ruby or python would be so cool :)
How do I see prices from another region?
Yes please, I would love to be able to program my own 'spreadsheets,' to assist in eve.
hey can you pls make an update Video for ESI API
I think that the more advanced tutorial would be awesome!! I think the web based/traditional database route would be neat...especially with how easy jQuery is to use as well and some small databases like noSql db's or something like that are to use... #twocents
Awesome video! Can you make one about the basics of using API with PHP (pheal)? It's extremely difficult to find a decent tutorial about it. Just too many different methods. I basically want to grab market data and system data (system industry index) as XML for all the items I have stored every few hours and save them in a database. But I always fail when trying to establish a connection (curl-error) With that data I later on plan to calculate Profit over night (including research and materials) for my dear corp members :-)
i'd be interested in something with C# , vb or .net if you can make something in those formats. i'm learning java, xml and json next.
Has anyone got this working in excel?
I would like a tutorial on programing please.
I would be very interested in Programming languages if you do another video Thank you
Yes please, do make tutorials about how to interact with eve DB through heavier programming languages...
How does one go about editing the Google sheet Template? I did D/L it to my Google Drive, but its still read only. I asked for permission, but can't even tell where the permission request went to. :) Many thanks, your vids are fantastic for Industry-oriented aspects of Eve.
@robdiggler5385
7 жыл бұрын
Roland make a copy
hey when are you going to hook us up with a new vid covering all of this stuff I'm sure half the eve community would love to have this kind of stuff.
I have a console based java app that i built a while ago that does basically exactly what you were talking about at the end if you're interested It's semi-efficent, and the code looks terrible (I did it before I really knew what exactly I was doing) but it works great and lets you search by arbitrary price margins.
It would be great if you create a programming tutorial
It would be very fine if you do something with the EVE API, EVE Central and Java.
There are several different things I am trying to look up the sell price, but they return zero, despite this clearly not being the case.
Can you Update thisPlease!!
Tutorial on programming Languages please with API's
Would love to learn some programming mate
yes please!
Ways of playing EVE ranged from press f1 and sit for hours to this😂
The move to SWAGGER in a few months changes most things which is unfortunate if you have an entire set up based on the old DB access methods. If you want to go to Excel now then a utility like "JSON buddy" makes creating a CSV from the JSON download from the new API about as easy as I could imagine it ever might be. Within ten with JSON and the Eve Swagger Interface (ESI) even someone who does not know 1 iota of Java or JSON will be downloading the data they need and formatting it into CSV for load into whatever spreadsheet of database program they have. The download is something I only perform a few times a day (3 or 4 at most) and the overhead in terms of time once you have the JSON worked out is perhaps a minute? At the end of the day actually getting the data in a readable form should not be the challenge. It's what you do with that data, how you use whatever analysis tools you have to find the best deals that counts. Actually getting it should be really simple, and I think the move to SWAGGER probably is a big step in that direction - as long as you either know the basics of JSON or use a tool like JSON Buddy to do most of the donkey work for you.
API programming please!!
please make tutorials for idiots like me on how to make my own spreadsheet for a corp, assert pulls, market pulls, ore buy back, pi production, everything eve realted... would be nice if you could touch on advanced game mechanics as well, like wh farming and stuff...
Ah! No Real working file for Excel.... Fail
@EveBusinessInsider
7 жыл бұрын
Excel methods exist similar to ImportXMl, and I will cover those in future videos. Sorry about that! =)
@WaleedHassan
7 жыл бұрын
i will Looking Forward to that one very impatiently really!!! Also i looked your older Google Doc sheet. they don't work anymore. Dunno why!
Pls I need :]
I am preferring to try and find a program where someone else has already done the work for me. I have stumbled onto Evernus but it's not very user friendly. If you have experience with these programs I would much prefer it if you show us how to use them rather than showing us how to make our own. HUGE CBF. No point reinventing the wheel, show us the simplest way.
A programming instructional would be great!