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.
 

Dust items, SQL.

Author
Victoria Sin
Doomheim
#1 - 2013-09-03 10:41:29 UTC
Is there a way for me to filter out any items associated with DUST from the data dump? These things are really not relevant for an Eve tool.

I can do it from my tree structure, by deleting the `Dropsuit Modules' node, etc. Thought there might be a flag somewhere, or a table with foreign key I can join against, so I can ignore them at source.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2013-09-03 11:37:02 UTC  |  Edited by: Steve Ronuken
Try ignoring groups with a categoryid of 350001


(invTypes -> invGroups. you could then go to invCategories, but that's a pointless join)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

Victoria Sin
Doomheim
#3 - 2013-09-03 12:56:58 UTC
Steve Ronuken wrote:
Try ignoring groups with a categoryid of 350001


(invTypes -> invGroups. you could then go to invCategories, but that's a pointless join)


OK, thanks Steve. Will give it a shot.