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.
 

TypeID to Market group
Author
Previous Topic Next Topic
Eregorn81
Black Fox Marauders
Pen Is Out
#1 - 2013-12-20 00:34:07 UTC
Hello,

I've been looking around for this data, but I can't find it in a nice format that I can use (.xlsx .csv .txt etc)
Can anyone point me to a data table that has rows of TyepID to MarketGroup for all marketable items?

for example:
3062 (250mm railgun II) <-> 555 (Medium Railguns)

p.s. Steve of Fuzzwork... you are awesome; I use your stuff all the time.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2013-12-20 04:50:21 UTC
select * from invTypes join invMarketGroups on (invTypes.marketgroupid=invMarketGroups.marketgroupid) where invTypes.typeid=3082;

https://www.fuzzwork.co.uk/dump/rubicon-1.0.4-93577/

invTypes
invMarketGroups

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Rob Crowley
State War Academy
#3 - 2013-12-20 12:39:09 UTC
Here you got it as a txt file: http://eve-files.com/dl/266540

The simple query I used:
select it.typeID,it.typeName,it.marketGroupID,img.marketGroupName from invTypes it join invMarketGroups img on (it.marketGroupID=img.marketGroupID)
Eregorn81
Black Fox Marauders
Pen Is Out
#4 - 2013-12-20 16:34:41 UTC
Thanks! That works perfectly.
Maffia Thug
Veteran Gamer's Network
#5 - 2014-01-02 18:18:40 UTC
Steve Ronuken wrote:
select * from invTypes join invMarketGroups on (invTypes.marketgroupid=invMarketGroups.marketgroupid) where invTypes.typeid=3082;

https://www.fuzzwork.co.uk/dump/rubicon-1.0.4-93577/

invTypes
invMarketGroups



I am having hell trying to figure out how to open up these types of files. I am assuming that I need to unzip them but I am having hell finding a program that will unzip them correctly. I would just love a DB Dump that is in excel format already. I think I have seen one but it kept opening up to some jibberish stuff.

Can you help me out with how to obtain that file or at least how to unzip and open up these types of file please?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#6 - 2014-01-03 00:34:18 UTC
Maffia Thug wrote:
Steve Ronuken wrote:
select * from invTypes join invMarketGroups on (invTypes.marketgroupid=invMarketGroups.marketgroupid) where invTypes.typeid=3082;

https://www.fuzzwork.co.uk/dump/rubicon-1.0.4-93577/

invTypes
invMarketGroups



I am having hell trying to figure out how to open up these types of files. I am assuming that I need to unzip them but I am having hell finding a program that will unzip them correctly. I would just love a DB Dump that is in excel format already. I think I have seen one but it kept opening up to some jibberish stuff.

Can you help me out with how to obtain that file or at least how to unzip and open up these types of file please?



Use 7zip to open them up.

you'll find excel/csv versions, as well as individual table dumps in sql.


Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Maffia Thug
Veteran Gamer's Network
#7 - 2014-01-04 00:28:40 UTC
Steve Ronuken wrote:
Maffia Thug wrote:
Steve Ronuken wrote:
select * from invTypes join invMarketGroups on (invTypes.marketgroupid=invMarketGroups.marketgroupid) where invTypes.typeid=3082;

https://www.fuzzwork.co.uk/dump/rubicon-1.0.4-93577/

invTypes
invMarketGroups



I am having hell trying to figure out how to open up these types of files. I am assuming that I need to unzip them but I am having hell finding a program that will unzip them correctly. I would just love a DB Dump that is in excel format already. I think I have seen one but it kept opening up to some jibberish stuff.

Can you help me out with how to obtain that file or at least how to unzip and open up these types of file please?



Use 7zip to open them up.

you'll find excel/csv versions, as well as individual table dumps in sql.




Thank you very much sir.