Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 1 post(s) |
Timcanpy Yvormes
Lero Industries
0
|
Posted - 2015.03.31 22:08:40 -
[1] - Quote
I'm trying to get a list of all the T2 rigs, i think i got all the Rigs from the Invtype Fuzzwork provide in his datadump, but now get the T2 is a problem
I'm getting my list via the group ID, and i get all rigs, seperate them is a big problem :S
How can i get only the T2? does any one know or could provide me one?
I also accept if u want to teach me and would apreciate that more than the list
I'm using google docs to do my spreadsheet
Kind Regards Tim. |
Tau Cabalander
Retirement Retreat Working Stiffs
4751
|
Posted - 2015.04.01 00:11:24 -
[2] - Quote
The EVE Technology lab forum is where API and data-dump experts hangout. |
Raphael Celestine
Celestine Inc.
55
|
Posted - 2015.04.01 03:59:50 -
[3] - Quote
You can check the tech level of an item in invMetaTypes - T2 has metaGroupID = 2
If you can handle an SQL query, this should pull everything in invTypes for the items you want:
SELECT * FROM invTypes JOIN invMetaTypes ON invTypes.typeID = invMetaTypes.typeID WHERE (groupID = 773 OR groupID = 774 OR groupID = 775 OR groupID = 776 OR groupID = 777 OR groupID = 778 OR groupID = 779 OR groupID = 781 OR groupID =782 OR groupID = 786) AND metaGroupID = 2 |
Selaria Unbertable
POS Mortem Renegades Of Silence
77
|
Posted - 2015.04.01 11:36:35 -
[4] - Quote
Raphael Celestine wrote:You can check the tech level of an item in invMetaTypes - T2 has metaGroupID = 2
If you can handle an SQL query, this should pull everything in invTypes for the items you want:
SELECT * FROM invTypes JOIN invMetaTypes ON invTypes.typeID = invMetaTypes.typeID WHERE (groupID = 773 OR groupID = 774 OR groupID = 775 OR groupID = 776 OR groupID = 777 OR groupID = 778 OR groupID = 779 OR groupID = 781 OR groupID =782 OR groupID = 786) AND metaGroupID = 2
Or shorter: SELECT * FROM invTypes JOIN invMetaTypes ON invTypes.typeID = invMetaTypes.typeID WHERE groupID IN(773, 774, 775, 776, 777, 778, 779, 781, 782, 786) AND metaGroupID = 2
I'd also use an INNER JOIN with USING(typeID) instead of ON. Eliminates duplicate column names. But basically this... |
Timcanpy Yvormes
Lero Industries
0
|
Posted - 2015.04.01 22:26:13 -
[5] - Quote
Thank you all for the aswer, it helped me alot |
Soldarius
Kosher Nostra The 99 Percent
1229
|
Posted - 2015.04.03 14:10:41 -
[6] - Quote
The way I do it is to maintain an external spreadsheet with every item in eve. Then link to it using a fairly simple importRange and VLookup function that uses an array of names for its input.
In this way, I can use the same technique for all my spreadsheets just by passing only a set of names into the function.
EX:
=ArrayFormula(vlookup(A2:A91,ImportRange("https://docs.google.com/spreadsheets/d/[spreadsheetKey]","itemTypes!A1:B"),2,0))
will fetch the itemType for every item in the column array at a2:a91.
If you ever intend to expand from just T2 rigs, you should consider something like this. It saves me a metric crap-tonne of extra work every time CCP changes an itemType.
http://youtu.be/YVkUvmDQ3HY
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |