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

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

Market Discussions

 
  • Topic is locked indefinitely.
 

Mosaic TypeIds List

First post
Author
Previous Topic Next Topic
Grasor
Ministry of War
Amarr Empire
#1 - 2015-05-15 15:02:57 UTC
Hello all,

I need to update my local database for a spreadsheet I use that pulls market data using API. As you may know it requires a database list to convert a numeric typeid to an actual item name (i.e. typeid 34 = tritanium).

Problem is I can't find an updated typeid list that includes current market information. The current version I'm using is very old and was the first one I came across during development so I don't know what site typically provides this information. Does anyone have a bead on a good place to find the document?

Thanks,
G

Who did who in the what now?
Pator Aumer
Vast Industries Inc
#2 - 2015-05-15 15:13:53 UTC  |  Edited by: Pator Aumer
Grasor wrote:
Hello all,

I need to update my local database for a spreadsheet I use that pulls market data using API. As you may know it requires a database list to convert a numeric typeid to an actual item name (i.e. typeid 34 = tritanium).

Problem is I can't find an updated typeid list that includes current market information. The current version I'm using is very old and was the first one I came across during development so I don't know what site typically provides this information. Does anyone have a bead on a good place to find the document?

Thanks,
G


http://eve-files.com/chribba/typeid.txt
https://www.fuzzwork.co.uk/tools/api-typename-to-typeid/

I am not 100% if these are up to date, you should look and creating the information yourself.

SELECT typeName FROM invtypes WHERE typeID=$typeID
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2015-05-15 17:32:02 UTC
http://www.fuzzwork.co.uk/resources/typeids.csv

It gets updated with each conversion.

https://www.fuzzwork.co.uk/dump/latest/invTypes.xls.bz2 is a full extract of the typeids table.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Grasor
Ministry of War
Amarr Empire
#4 - 2015-05-16 05:12:10 UTC
Awesome guys thanks a lot and I'll bookmark the fuzzworks site.

Who did who in the what now?