EVE Technology Lab

Forum Index

EVE Forums » EVE Technology and Research Center » EVE Technology Lab » Need help with old api import xml for pulling kills

Topic is locked indefinitely.

Need help with old api import xml for pulling kills First post
Author

Previous Topic Next Topic

3
Errious Likes received: 3	#1 - 2015-08-24 19:12:56 UTC Hi, after google changed theyr docs i have some problems with my formulas, was working in the past but not anymore, maybe someone can tell me what is wrong now: =IMPORTXML("https://api.eveonline.com/map/Kills.xml.aspx","//row[@solarsystemid=30001914]/@factionkills\|//row[@solarsystemid=30001914]/@shipkills\|//row[@solarsystemid=30001914]/@podkills")

Dragonaire

Here there be Dragons

Likes received: 92

#2 - 2015-08-24 23:40:51 UTC

I don't know if it's your problem or not but I'd split it up into 2 queries: one for factionkills and the other for shipkills and then combine them some where else afterwards as needed or just do the import and then filter the raw import. The reason I say that is it could be that it tries to download the API twice( once for each part of the 'or') and is timing out because of it. It's just good practice to get once and use many vs possibly get many and use many which seems like what could happen with your current code.

Finds camping stations from the inside much easier. Designer of Yapeal for the Eve API. Check out the Yapeal PHP API Library thread.

Fuzzwork Enterprises Vote Steve Ronuken for CSM 6,759
Steve Ronuken Fuzzwork Enterprises Vote Steve Ronuken for CSM Likes received: 6,759	#3 - 2015-08-25 00:20:51 UTC importxml is now case sensitive on the xpath. So make sure it matches. (solarSystemID, factionKills, for example) Woo! CSM XI! Fuzzwork Enterprises Twitter: @fuzzysteve on Twitter


Errious Likes received: 3	#4 - 2015-08-25 11:30:00 UTC Tried to make it valid like Steve whrote but still not working, even if i try one call or combined, any ideas ? =IMPORTXML("https://api.eveonline.com/map/Kills.xml.aspx","//row[@solarSystemID=30001914]/@factionKills\|//row[@solarSystemID=30001914]/@shipKills\|//row[@solarSystemID=30001914]/@podKills")


Steve Ronuken Fuzzwork Enterprises Vote Steve Ronuken for CSM Likes received: 6,759	#5 - 2015-08-25 11:40:08 UTC alternate option: https://github.com/fuzzysteve/eve-googledocs-script/blob/master/kills.gs loads all kills into a separate sheet, which you can then use vlookup to get what you want. Woo! CSM XI! Fuzzwork Enterprises Twitter: @fuzzysteve on Twitter


Errious Likes received: 3	#6 - 2015-08-25 23:21:20 UTC This is perfect Steve, thank you ! Just a question because i think you read this, is it possible to pull specific kills from a specific system via eve api? Something like in Uedama died a charon worth xxx at date:time and other informations or is it only for zKillboard possible to do something like this? I like to make a spreadsheet to research about kills. Regards


Steve Ronuken Fuzzwork Enterprises Vote Steve Ronuken for CSM Likes received: 6,759	#7 - 2015-08-26 02:03:04 UTC Not via the eve api, no. That's limited to pulling kills from specific people, with specific api keys. (or with a specific hash). Zkill just has a great deal of these keys. https://neweden-dev.com/ZKillboard_API may be of interest, however. Woo! CSM XI! Fuzzwork Enterprises Twitter: @fuzzysteve on Twitter

EVE Technology Lab

Here there be Dragons

Fuzzwork Enterprises

Vote Steve Ronuken for CSM