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.
 

Eve API - itemID mappings

First post
Author
Previous Topic Next Topic
Regra Stark
Republic University
Minmatar Republic
#1 - 2013-08-20 00:03:06 UTC
Is there an up to date map between ItemID --> ItemName? Is this posted anywhere by CCP?

Background: I am pulling in the XMl asset list from the API and I would like map each itemID with it's in game name
Grauth Thorner
Vicious Trading Company
#2 - 2013-08-20 00:22:13 UTC
Regra Stark wrote:
Is there an up to date map between ItemID --> ItemName? Is this posted anywhere by CCP?

Background: I am pulling in the XMl asset list from the API and I would like map each itemID with it's in game name

I usually hate it when people who are not ISD/CCP 'forward' threads to certain parts of the forum, but in this case it's for your own good... Try it at the Technology Lab, the people in this forum know a lot more about your question than the average person here xD

View real-time damage statistics in-game

>EVE Live DPS Graph application forum thread

>iciclesoft.com
Obvious Cyno
The Scope
Gallente Federation
#3 - 2013-08-20 00:37:02 UTC
Grauth Thorner wrote:
Regra Stark wrote:
Is there an up to date map between ItemID --> ItemName? Is this posted anywhere by CCP?

Background: I am pulling in the XMl asset list from the API and I would like map each itemID with it's in game name

I usually hate it when people who are not ISD/CCP 'forward' threads to certain parts of the forum, but in this case it's for your own good... Try it at the Technology Lab, the people in this forum know a lot more about your question than the average person here xD


Confirming we're all scrubs and idiots in GD.
Tippia
Sunshine and Lollipops
#4 - 2013-08-20 00:44:08 UTC
Just download the static data dump and do a SELECT itemID, itemName FROM invItems NATURAL LEFT JOIN invNames LIMIT; and there you go…

…but are you sure it's actually itemIDs you want to use?
Regra Stark
Republic University
Minmatar Republic
#5 - 2013-08-20 17:56:18 UTC  |  Edited by: Regra Stark
Tippia wrote:
Just download the static data dump and do a SELECT itemID, itemName FROM invItems NATURAL LEFT JOIN invNames LIMIT; and there you go…

…but are you sure it's actually itemIDs you want to use?




Every itemName from invNames seems to be moons, planets, stations, and gates only.

I'm pulling an XML of my characters assets, each asses has an itemID attribute, I would like to find out what item that itemID belongs to from my assets. How do I go about doing that? I can't seem to find tritanium in any of the DB tables.....
ISD LackOfFaith
ISD Community Communications Liaisons
ISD Alliance
#6 - 2013-08-20 20:18:13 UTC
Thread has been moved to EVE Technology Lab.

Also, you probably are thinking of "typeID" and "typeName".

The difference between a type and an item is the difference between "Velator" and "ISD LackOfFaith's Velator". One is a specification for a particular kind of item (the Velator ship), which contains details about its attributes, and the other is a specific real "instance" of the item.

Try this:

select typeID, typeName from invTypes;

ISD LackOfFaith

Captain

Community Communication Liaisons (CCLs)

Interstellar Services Department

I do not respond to Eve Mail or anything other than the forums.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#7 - 2013-08-20 20:55:41 UTC
itemID isn't what you want. It's the unique id in TQ's database for that stack.

Not hugely useful to you, with no direct mapping to what it is, anywhere by in TQ.

Now, the typeid is probably what you want. Tritanium is Typeid 34. This is in the table invTypes. (if you want the table in xls format, it's on my site. Along with a mysql/postgres/sqlite conversion)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Regra Stark
Republic University
Minmatar Republic
#8 - 2013-08-21 18:17:37 UTC
Sorry, for some reason my edit didn't post, I had found out about typeID by messing around in the DB after my last post. Thanks for all the help guys my new indy tool is awesome =D
Grauth Thorner
Vicious Trading Company
#9 - 2013-08-22 20:27:43 UTC
Regra Stark wrote:
Sorry, for some reason my edit didn't post, I had found out about typeID by messing around in the DB after my last post. Thanks for all the help guys my new indy tool is awesome =D

Yeah that seems to happen quite a lot, same when replying to a post.. That's why I always ctrl-a > ctrl-c before I post anything :p Anyway good that you found your answer

View real-time damage statistics in-game

>EVE Live DPS Graph application forum thread

>iciclesoft.com