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.
 

Looking for a typeID list

First post
Author
Previous Topic Next Topic
Kaylie Mydosa
Doomheim
#1 - 2016-05-06 03:05:13 UTC  |  Edited by: Kaylie Mydosa
Maybe someone can tell me where i can find this as a actual version as a txt or xls or something where i not need to study all the changes from formats from sde ?
Mr Mac
Dark Goliath
#2 - 2016-05-06 05:58:27 UTC
I think Desmont's tool can convert individual table (invTypes) to csv which can open in excel
Hel O'Ween
Men On A Mission
#3 - 2016-05-06 15:51:42 UTC  |  Edited by: Hel O'Ween
Link to Desmont's tool: https://forums.eveonline.com/default.aspx?g=posts&t=456458

If a MS Access database is fine for you, grab http://eve.basicaware.de/evewalletaware/download.html#downloaddb and look for the table invTypes. (That's the database update for my EWA)

EVEWalletAware - an offline wallet manager.
Kaylie Mydosa
Doomheim
#4 - 2016-05-06 18:00:21 UTC
Very kind to let me know about the application to work on that, but to be honest i have no clue how to use them and i have nothing to do with servers script language or anything like this, would be nice if someone can just create a list for the actual typeID´s and can share this with me and others Smile
Blacksmoke16
Imperial Academy
#5 - 2016-05-06 18:17:58 UTC
http://eve-services.net/Files/typeIDs.json

Exported just now from the latest SDE.

If you need a diff format such as CSV or something let me know.
Kaylie Mydosa
Doomheim
#6 - 2016-05-06 18:21:56 UTC
Blacksmoke16 wrote:
http://eve-services.net/Files/typeIDs.json

Exported just now from the latest SDE.

If you need a diff format such as CSV or something let me know.


Thank you for your efforts, but i can do nothing with this list, what i need is a list of items and their typeID´s thats all but what sounds so simple seems to be much more difficult as i think maybe, because i am not a programmer.
Desmont McCallock
#7 - 2016-05-06 19:38:30 UTC  |  Edited by: Desmont McCallock
Blacksmoke16
Imperial Academy
#8 - 2016-05-06 20:09:19 UTC  |  Edited by: Blacksmoke16
Try number 2: Plain text file with typeID and typeName

http://eve-services.net/Files/typeIDs.txt
Kaylie Mydosa
Doomheim
#9 - 2016-05-06 21:00:02 UTC
Blacksmoke16 wrote:
Try number 2: Plain text file with typeID and typeName

http://eve-services.net/Files/typeIDs.txt


My HERO Big smile

Thank you very much!

Funny to see all the advices but their made for guys who are way above my lvl of understanding 0100111001010101 Cool
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#10 - 2016-05-06 21:58:30 UTC
You _may_ find https://www.fuzzwork.co.uk/resources/typeids.csv to be more useful.

typeid,typename,typeid

For when you want to be able to vlookup in both directions.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Kaylie Mydosa
Doomheim
#11 - 2016-05-07 11:52:44 UTC
Steve Ronuken wrote:
You _may_ find https://www.fuzzwork.co.uk/resources/typeids.csv to be more useful.

typeid,typename,typeid

For when you want to be able to vlookup in both directions.


Thank you but also this is to much splitted text, the format is not usefull, plain text is exact what is what was needed.
Just for docs with vlookup usage.

I would like to see after future patches just a simple plain text itemID list available somewhere but i believe this is only player made and not supported from ccp ?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#12 - 2016-05-07 17:27:47 UTC
Kaylie Mydosa wrote:
Steve Ronuken wrote:
You _may_ find https://www.fuzzwork.co.uk/resources/typeids.csv to be more useful.

typeid,typename,typeid

For when you want to be able to vlookup in both directions.


Thank you but also this is to much splitted text, the format is not usefull, plain text is exact what is what was needed.
Just for docs with vlookup usage.

I would like to see after future patches just a simple plain text itemID list available somewhere but i believe this is only player made and not supported from ccp ?



CCP provide a data extract. Players convert that into other formats.

(and you're always getting it in a delimited format. The first one was tab delimited. Mine was comma delimited)

https://support.google.com/docs/answer/3093335?hl=en May be of some interest, for how to load it in, and keep it up to date.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Professor Humbert
Project Fruit House
#13 - 2016-05-09 07:23:04 UTC
Here's xlsx