These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Extracting item data
Author
Previous Topic Next Topic
Havoc Zealot
Ministry of War
Amarr Empire
#1 - 2013-02-19 06:00:26 UTC  |  Edited by: Havoc Zealot
How can I extract the item name and ID from a data dump of a specific type such as only T2 modules?

I have been copy and pasting by hand it is is terrible.

Trying to get this data from here

http://eve-files.com/chribba/typeid.txt
Rob Crowley
State War Academy
#2 - 2013-02-19 07:58:58 UTC
Havoc Zealot wrote:
How can I extract the item name and ID from a data dump of a specific type such as only T2 modules?

If you have the SDE dump you can use "select it.typeName,it.typeID from invTypes it, dgmTypeAttributes ta, invGroups ig where ta.attributeID=633 and (ta.valueFloat=5 or ta.valueInt=5) and ig.categoryID = 7 and it.typeID=ta.typeID and it.groupID=ig.groupID" to get all T2 Modules.

If you were trying to get it just from that linked text file you probably best use a RegExp: "^.*II$" which of course is much less error-proof than using all available information in the SDE and won't work if you want to filter by another attribute that can't be parsed from the name.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2013-02-19 10:24:49 UTC
The meta level of the module is, indeed, stored in attribute 633. I'd suggest using coalesce(valueInt,valueFloat) to get the value for it.


The 'meta type' is also stores, in the table invMetaTypes, and defined in invMetaGroups (tech 1, tech 2, storyline, officer, etc). so you can grab it from there. Using category 7 (defined in invCategories, as a module) to restrict it to just modules (as in the query Rob put up)

select typename,invTypes.typeid from invTypes,invMetaTypes,invGroups where invMetaTypes.typeid=invTypes.typeid and
invMetaTypes.metaGroupID=2 and invTypes.groupID=invGroups.groupID and invGroups.categoryID=7;


Of course, rigs are categorized as modules, so you'll have to bear that in mind.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter