Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Gilbaron
Free-Space-Ranger Nulli Secunda
1501
|
Posted - 2014.08.27 06:35:00 -
[1] - Quote
hello everyone
i basically just want the blueprints parsed into a google docs so that i can work from there
i want everything in the doc, because i know how to work from there
the one thing that i don't know is how to import it in the doc
can someone help me with the xpath part of the importxml thing ?
(row itemID="1337" locationID="1337" typeID="973" typeName="Arbitrator Blueprint" flagID="4" quantity="-1" timeEfficiency="20" materialEfficiency="10" runs="-1"/)
i basically just want the itemID, locationID, typeID, typeName ... in columns in the document.
how would the importXML function look ? Build your empire ! Start today ! Rent Space in Perrigen Falls and Feythabolis Contact me for details :)
|
Gilbaron
Free-Space-Ranger Nulli Secunda
1564
|
Posted - 2014.08.27 06:35:27 -
[2] - Quote
hello everyone
i basically just want the blueprints API parsed into a google docs so that i can work from there
i want everything in the doc, because i know how to work from there
the one thing that i don't know is how to import it in the doc
can someone help me with the xpath part of the importxml thing ?
(row itemID="1337" locationID="1337" typeID="973" typeName="Arbitrator Blueprint" flagID="4" quantity="-1" timeEfficiency="20" materialEfficiency="10" runs="-1"/)
i basically just want the itemID, locationID, typeID, typeName ... in columns in the document.
how would the importXML function look ?
Build your empire !
Start today ! Rent Space in Perrigen Falls and Feythabolis
Contact me for details :)
|
Gilbaron
Free-Space-Ranger Nulli Secunda
1501
|
Posted - 2014.08.27 07:43:00 -
[3] - Quote
okay, got it. whoever decided that viewing the doc in the browser showed uppercase, while the importXML from google docs would only work in lowercase deserves to be shot.
=IMPORTXML(https://api.eveonline.com/corp/Blueprints.xml.aspx?vCode=1337&characterID=1338&keyID=1338;"//@typeid")
works flawless
next question:
where can i get the info which ItemID a BlueprintItemID makes ? and who decided that info didn't belong in the blueprints API ?
:CCP Build your empire ! Start today ! Rent Space in Perrigen Falls and Feythabolis Contact me for details :)
|
Gilbaron
Free-Space-Ranger Nulli Secunda
1564
|
Posted - 2014.08.27 07:43:24 -
[4] - Quote
okay, got it. whoever decided that viewing the doc in the browser showed uppercase, while the importXML from google docs would only work in lowercase deserves to be shot.
=IMPORTXML(https://api.eveonline.com/corp/Blueprints.xml.aspx?vCode=1337&characterID=1338&keyID=1338;"//@typeid")
works flawless
next question:
where can i get the info which ItemID a BlueprintItemID makes ? and who decided that info didn't belong in the blueprints API ?
:CCP
Build your empire !
Start today ! Rent Space in Perrigen Falls and Feythabolis
Contact me for details :)
|
Acid Kanshi
AIFAM
52
|
Posted - 2014.08.27 09:44:00 -
[5] - Quote
Quote:where can i get the info which ItemID a BlueprintItemID makes ? and who decided that info didn't belong in the blueprints API ?
That info is in the data dump. EVE-Cost is a manufacturing tool for EVE players. http://www.eve-cost.eu |
Acid Kanshi
AIFAM VERY BEST
53
|
Posted - 2014.08.27 09:44:37 -
[6] - Quote
Quote:where can i get the info which ItemID a BlueprintItemID makes ? and who decided that info didn't belong in the blueprints API ?
That info is in the data dump.
EVE-Cost is a manufacturing tool for EVE players.
http://www.eve-cost.eu
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
3747
|
Posted - 2014.08.27 11:34:00 -
[7] - Quote
If you want that, grab the industryActivityProducts table from my site (available as xls), and upload it to gdoc. Then you can vlookup it.
You may wish to filter it down to just activityID 1 Woo! CSM 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4148
|
Posted - 2014.08.27 11:34:29 -
[8] - Quote
If you want that, grab the industryActivityProducts table from my site (available as xls), and upload it to gdoc. Then you can vlookup it.
You may wish to filter it down to just activityID 1
Woo! CSM 9!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Gilbaron
Free-Space-Ranger Nulli Secunda
1501
|
Posted - 2014.08.27 16:52:00 -
[9] - Quote
Steve Ronuken wrote:If you want that, grab the industryActivityProducts table from my site (available as xls), and upload it to gdoc. Then you can vlookup it.
You may wish to filter it down to just activityID 1
<3
Build your empire ! Start today ! Rent Space in Perrigen Falls and Feythabolis Contact me for details :)
|
Gilbaron
Free-Space-Ranger Nulli Secunda
1564
|
Posted - 2014.08.27 16:52:14 -
[10] - Quote
Steve Ronuken wrote:If you want that, grab the industryActivityProducts table from my site (available as xls), and upload it to gdoc. Then you can vlookup it.
You may wish to filter it down to just activityID 1
<3
Build your empire !
Start today ! Rent Space in Perrigen Falls and Feythabolis
Contact me for details :)
|
|
Amalgation
Badger Industrial
0
|
Posted - 2014.08.28 00:08:00 -
[11] - Quote
How did you even get that far?
I can't get the API to give me anything, whatsoever.
https://api.eveonline.com/corp/Blueprints.xml.aspx?keyID=MyID&vCode=myVCode will only return
Quote:Illegal page request! Please verify the access granted by the key you are using!
even with a full access API. What did you do to get it work at all? |
Amalgation
Badger Industrial
0
|
Posted - 2014.08.28 00:08:37 -
[12] - Quote
How did you even get that far?
I can't get the API to give me anything, whatsoever.
https://api.eveonline.com/corp/Blueprints.xml.aspx?keyID=MyID&vCode=myVCode will only return
Quote:Illegal page request! Please verify the access granted by the key you are using!
even with a full access API. What did you do to get it work at all? |
Gilbaron
Free-Space-Ranger Nulli Secunda
1502
|
Posted - 2014.08.28 00:13:00 -
[13] - Quote
https://api.eveonline.com/corp/Blueprints.xml.aspx?vCode=myvcode&characterID=mycharacterid&keyID=mykeyid
this works for me Build your empire ! Start today ! Rent Space in Perrigen Falls and Feythabolis Contact me for details :)
|
Gilbaron
Free-Space-Ranger Nulli Secunda
1564
|
Posted - 2014.08.28 00:13:08 -
[14] - Quote
https://api.eveonline.com/corp/Blueprints.xml.aspx?vCode=myvcode&characterID=mycharacterid&keyID=mykeyid
this works for me
Build your empire !
Start today ! Rent Space in Perrigen Falls and Feythabolis
Contact me for details :)
|
Amalgation
Badger Industrial
0
|
Posted - 2014.08.28 00:14:00 -
[15] - Quote
Ah. I missed the Character ID part. First time I've had to throw that in with my stuff, threw me. |
Amalgation
Badger Industrial
0
|
Posted - 2014.08.28 00:14:54 -
[16] - Quote
Ah. I missed the Character ID part. First time I've had to throw that in with my stuff, threw me. |
Gilbaron
Free-Space-Ranger Nulli Secunda
1502
|
Posted - 2014.08.28 00:17:00 -
[17] - Quote
to be honest, i have absolutely no idea why that works
the character ID i'm using isn't even in the corp. Build your empire ! Start today ! Rent Space in Perrigen Falls and Feythabolis Contact me for details :)
|
Gilbaron
Free-Space-Ranger Nulli Secunda
1564
|
Posted - 2014.08.28 00:17:45 -
[18] - Quote
to be honest, i have absolutely no idea why that works
the character ID i'm using isn't even in the corp.
Build your empire !
Start today ! Rent Space in Perrigen Falls and Feythabolis
Contact me for details :)
|
Gilbaron
Free-Space-Ranger Nulli Secunda
1502
|
Posted - 2014.08.28 00:19:00 -
[19] - Quote
oh, and it also works without the character ID. weird. it was only in there because i just copied the query part from another sheet. and i don't even know why it was in that first sheet.
https://api.eveonline.com/corp/Blueprints.xml.aspx?vCode=myvcode&keyID=mykeyid Build your empire ! Start today ! Rent Space in Perrigen Falls and Feythabolis Contact me for details :)
|
Gilbaron
Free-Space-Ranger Nulli Secunda
1564
|
Posted - 2014.08.28 00:19:52 -
[20] - Quote
oh, and it also works without the character ID. weird. it was only in there because i just copied the query part from another sheet. and i don't even know why it was in that first sheet.
https://api.eveonline.com/corp/Blueprints.xml.aspx?vCode=myvcode&keyID=mykeyid
Build your empire !
Start today ! Rent Space in Perrigen Falls and Feythabolis
Contact me for details :)
|
|
Dragonaire
Here there be Dragons
60
|
Posted - 2014.08.28 15:17:00 -
[21] - Quote
For char/ section APIs using an account type key you have to use characterID most other places and times with character or corporation keys that have only one char assigned to them you don't but as you've found the API server generally ignore extra stuff. I've found it easier to just always send the characterID part and not worry which type of key I have. Finds camping stations from the inside much easier. Designer of Yapeal-á for the Eve API. Check out the Yapeal PHP API Library thread for more information. |
Dragonaire
Here there be Dragons
65
|
Posted - 2014.08.28 15:17:13 -
[22] - Quote
For char/ section APIs using an account type key you have to use characterID most other places and times with character or corporation keys that have only one char assigned to them you don't but as you've found the API server generally ignore extra stuff. I've found it easier to just always send the characterID part and not worry which type of key I have.
Finds camping stations from the inside much easier.
Designer of Yapeal-á for the Eve API.
Check out the Yapeal PHP API Library thread for more information.
|
Ugurtan
The Dark Space Initiative Scary Wormhole People
8
|
Posted - 2014.11.09 19:20:47 -
[23] - Quote
Gilbaron, are you managing to get the columns you want with a single importXML call, or do you have to use one for every attribute you want in the spreadsheet? Toying around with xpath for a while now, but dont get how i can import the whole row line with a single import XML. This works fine with other XML structures like the eve central where you can get what you want with a single import call, but I guess thats because the results are all of type element and not attribute?
if anyone has figured that out some help would be appreciated.
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |