Pages: [1] |
1. Googledocs API ImportXML noob question - in EVE Technology Lab [original thread]
Omega Flames wrote: try wrapping the entire import in ARRAYFORMULA() I tried using: Quote: =ARRAYFORMULA(ImportXML("https://api.eveonline.com/map/Kills.xml.aspx", "(//row[@solarsystemid="&JOIN(" or @solarsystemid=",$A2:$A9)&"]/@sh...
- by Hustomte - at 2013.08.16 06:18:00
|
2. Googledocs API ImportXML noob question - in EVE Technology Lab [original thread]
Do I need to start a new thread for this?
- by Hustomte - at 2013.07.26 06:03:00
|
3. Googledocs API ImportXML noob question - in EVE Technology Lab [original thread]
Anyone know how to fix this?
- by Hustomte - at 2013.06.14 03:33:00
|
4. Googledocs API ImportXML noob question - in EVE Technology Lab [original thread]
That is very close to what I wanted, but it sums all the systems into one cell (instead of listing ship kills per hour for each system). Here is what I have currently (that is inefficient but working) http://bit.ly/117s0BC Thank you again for ...
- by Hustomte - at 2013.05.29 22:21:00
|
5. Googledocs API ImportXML noob question - in EVE Technology Lab [original thread]
I am still hoping someone in the community knows how to fix this please.
- by Hustomte - at 2013.05.21 21:25:00
|
6. Googledocs API ImportXML noob question - in EVE Technology Lab [original thread]
bump for great justice
- by Hustomte - at 2013.04.30 02:44:00
|
7. Googledocs API ImportXML noob question - in EVE Technology Lab [original thread]
Thank you Steve for the feedback, I get a parse error though, plus it was mad at me for not matching quotes. I think this is really close though, is there more documentation somewhere that I haven't been able to find yet?
- by Hustomte - at 2013.04.14 18:35:00
|
8. Googledocs API ImportXML noob question - in EVE Technology Lab [original thread]
I have come to the conclusion that Eve's API is not xpath compliant (or not useful anyway). Eve-Central (and the rest) have a much easier xpath to work with in Googledocs. Does anyone know if Crest is going to make Eve's API not be such a pain? I...
- by Hustomte - at 2013.04.14 07:10:00
|
9. Google Docs Ore Buy spreadsheet? - in EVE Technology Lab [original thread]
I put together a 15% off Jita Google spreadsheet for you. This link is publicly view-able, but not editable (to prevent trolls). You however can go to File -> Make a Copy and save your own sheet and edit that one to your hearts content http...
- by Hustomte - at 2013.04.14 06:36:00
|
10. Googledocs API ImportXML noob question - in EVE Technology Lab [original thread]
Actually, how would I do multiple systems for LOLz? =ImportXML("https://api.eveonline.com/map/Kills.xml.aspx", "sum(//row[@solarsystemid="&JOIN("@solarsystemid=",$A2:$A9)]/@shipkills)") Do I have JOIN before the xpath or in it like above? ...
- by Hustomte - at 2013.04.12 06:36:00
|
11. Googledocs API ImportXML noob question - in EVE Technology Lab [original thread]
Nevermind, I solved it after searching for clues in various forum posts. The above solution for shipkills in a system was: =ImportXML("https://api.eveonline.com/map/Kills.xml.aspx", "sum(//row[@solarsystemid=30000142]/@shipkills)") This now ret...
- by Hustomte - at 2013.04.12 06:09:00
|
12. Googledocs API ImportXML noob question - in EVE Technology Lab [original thread]
Hello Forums, I tried searching for my issue first, with no luck. So here it goes. Since I am new to the Eve API, and to Googledocs spreadsheets, I am trying to make something simple, but its turning out to be more complicated than I thought. I ...
- by Hustomte - at 2013.04.12 01:16:00
|
13. List of system ids? - in EVE Technology Lab [original thread]
This was AWESOME, thank you!
- by Hustomte - at 2013.04.12 00:51:00
|
14. EvE SkillWatch Gadget - in EVE Technology Lab [original thread]
Thank you, a complete uninstall/reinstall fixed it.
- by Hustomte - at 2012.01.20 18:31:00
|
15. EvE SkillWatch Gadget - in EVE Technology Lab [original thread]
This gadget is broken for me... it says "Cannot access API, check connection"... problem is, the connection is fine, and the new API with vcode and ID is also fine and working (eve mon etc). So apparently this gadget broke a few days ago for some...
- by Hustomte - at 2012.01.19 13:11:00
|
Pages: [1] |
First page | Previous page | Next page | Last page |