August 2018 SDE - Data missing in invTypes and August_Release_2018_1.0_Types

[Zifrian]

Missing data in the invTypes table for the latest SDE.

typeID	typeName	groupID	groupName	categoryID	categoryName
48419		68	Energy Nosferatu	7	Module
48599		303	Booster	20	Implant
48600		303	Booster	20	Implant
48615		303	Booster	20	Implant
48635		833	Force Recon Ship	6	Ship
48636		830	Covert Ops	6	Ship
48637		106	Cruiser Blueprint	9	Blueprint
48638		105	Frigate Blueprint	9	Blueprint
48642		1194	Special Edition Commodities	63	Special Edition Assets
48643		1194	Special Edition Commodities	63	Special Edition Assets
48644		1194	Special Edition Commodities	63	Special Edition Assets
48645		1194	Special Edition Commodities	63	Special Edition Assets
48649		1950	Permanent SKIN	91	Super Kerr-Induced Nanocoatings
48650		1950	Permanent SKIN	91	Super Kerr-Induced Nanocoatings
48651		1950	Permanent SKIN	91	Super Kerr-Induced Nanocoatings
48653		1950	Permanent SKIN	91	Super Kerr-Induced Nanocoatings
48654		1950	Permanent SKIN	91	Super Kerr-Induced Nanocoatings
48655		1950	Permanent SKIN	91	Super Kerr-Induced Nanocoatings
48656		1950	Permanent SKIN	91	Super Kerr-Induced Nanocoatings
48719		1950	Permanent SKIN	91	Super Kerr-Induced Nanocoatings
48720		1950	Permanent SKIN	91	Super Kerr-Induced Nanocoatings
48721		1950	Permanent SKIN	91	Super Kerr-Induced Nanocoatings
48722		1950	Permanent SKIN	91	Super Kerr-Induced Nanocoatings
48723		1950	Permanent SKIN	91	Super Kerr-Induced Nanocoatings
48724		1950	Permanent SKIN	91	Super Kerr-Induced Nanocoatings
48725		1950	Permanent SKIN	91	Super Kerr-Induced Nanocoatings
48726		1950	Permanent SKIN	91	Super Kerr-Induced Nanocoatings
48727		1950	Permanent SKIN	91	Super Kerr-Induced Nanocoatings
48728		1950	Permanent SKIN	91	Super Kerr-Induced Nanocoatings
48729		1950	Permanent SKIN	91	Super Kerr-Induced Nanocoatings
48730		1950	Permanent SKIN	91	Super Kerr-Induced Nanocoatings
48731		1950	Permanent SKIN	91	Super Kerr-Induced Nanocoatings
48732		1950	Permanent SKIN	91	Super Kerr-Induced Nanocoatings
48733		1950	Permanent SKIN	91	Super Kerr-Induced Nanocoatings
48734		1950	Permanent SKIN	91	Super Kerr-Induced Nanocoatings
48735		1950	Permanent SKIN	91	Super Kerr-Induced Nanocoatings
48748		1194	Special Edition Commodities	63	Special Edition Assets
48749		1194	Special Edition Commodities	63	Special Edition Assets
48750		1194	Special Edition Commodities	63	Special Edition Assets
48751		1194	Special Edition Commodities	63	Special Edition Assets
48752		1194	Special Edition Commodities	63	Special Edition Assets
48753		1194	Special Edition Commodities	63	Special Edition Assets
48754		1194	Special Edition Commodities	63	Special Edition Assets
48755		1194	Special Edition Commodities	63	Special Edition Assets
48756		1194	Special Edition Commodities	63	Special Edition Assets
48757		1194	Special Edition Commodities	63	Special Edition Assets
48758		1194	Special Edition Commodities	63	Special Edition Assets
48759		1194	Special Edition Commodities	63	Special Edition Assets
48760		1194	Special Edition Commodities	63	Special Edition Assets
48761		1977	Trinary Data Vaults	17	Commodity
48764		2002		17	Commodity
48765		2002		17	Commodity
48767		2002		17	Commodity
48768		2002		17	Commodity
48769		2002		17	Commodity
48770		2002		17	Commodity
48771		2002		17	Commodity
48772		2002		17	Commodity
48774		2002		17	Commodity
48775		2002		17	Commodity
48777		2002		17	Commodity
48778		2002		17	Commodity

Edit: Images where there - just missed them.

[Golden_Gnu]

This have been the case with the last two SDE releases:

TypeIDs without names in SDE

I was poking through the latest SDE, and found a whole bunch of type IDs that don’t have an associated name. If you put the TypeID into ESI, there are buy and sell orders for them. For instance, TypeID #48495. There 18 buy/sell orders for it in the Forge. It’s in Market Group 2058, which is “Minmitar” but lacks a description. The other items in that group are all Hyena SKINs. By process of elimination, it appears that #48495 is the Hyena Dawn of LIberation SKIN. So is this a case of bad data…

tl:dr
You can get the names from ESI universe/names

[Zifrian]

I haven’t seen anything stating that CCP wants us to use ESI for static data.

[Golden_Gnu]

The SDE will stay, don’t worry, that have been stated multiple times.
I wrote the tl:dr to give you a workaround for the missing names and linked the thread because it have a explanation to why the names may be missing.

[Zifrian]

Ahh understood!

I guess I could do that but I’m lazy and complaining on forums is easy!

Although, it seems the last list was fixed so maybe someone will see it and correct anyway.