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.
 

ebs_DATADUMP >> invItems missing [typeName] attribute data

First post
Author
Previous Topic Next Topic
m Light
I N E X T R E M I S
Tactical Narcotics Team
#1 - 2016-03-10 15:38:01 UTC
o7


The DATADUMP201603090946.bak is missing type name data.

" [ebs_DATADUMP].[dbo].[invTypes].[typeName]"



Is data schema change or I'm missing something.
Desmont McCallock
#2 - 2016-03-10 16:02:31 UTC
8 rows don't have typeName.
1 is an unpublished with description "Massive Environment".
7 are DUST 514 items, which are not critical for EVE Online.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2016-03-10 22:07:06 UTC
m Light wrote:
o7


The DATADUMP201603090946.bak is missing type name data.

" [ebs_DATADUMP].[dbo].[invTypes].[typeName]"



Is data schema change or I'm missing something.




Just checking, you know the official SDE stopped having type data in database export months ago? It's all in the yaml file now.


https://www.fuzzwork.co.uk/dump/yc118-3-117575/YC118-3-117575.bak.bz2 may be of interest if you didn't know. I've reimported the data back in. (7zip will uncompress the backup file)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
m Light
I N E X T R E M I S
Tactical Narcotics Team
#4 - 2016-03-16 20:47:36 UTC
Steve Ronuken wrote:
m Light wrote:
o7


The DATADUMP201603090946.bak is missing type name data.

" [ebs_DATADUMP].[dbo].[invTypes].[typeName]"



Is data schema change or I'm missing something.




Just checking, you know the official SDE stopped having type data in database export months ago? It's all in the yaml file now.


https://www.fuzzwork.co.uk/dump/yc118-3-117575/YC118-3-117575.bak.bz2 may be of interest if you didn't know. I've reimported the data back in. (7zip will uncompress the backup file)



O7
Many thanks for response and link.


I apologise in advance for using logic in this issue!

As I’m aware EVE is using SQL 2014 Enterprise as back end DB.
The previous SQL backup includes item types and item groups.

Someone makes decision to export data from SQL to yame that is fine.
The question is why exclude that data from SQL when it was there in the first place!
I need to create component to import yaml back to SQL where it was in the first place.

I’m sure that someone from CCP can present business case that justifies that, and it goes blaaa blaaa blaaa.


m Light
Desmont McCallock
#5 - 2016-03-16 20:51:22 UTC
The decision was made 4 years ago to slowly export all data used in the SDE to yaml, sqlite files. The community has already created tools to import those files back to SQL Server.
m Light
I N E X T R E M I S
Tactical Narcotics Team
#6 - 2016-03-16 20:56:29 UTC
Desmont McCallock wrote:
The decision was made 4 years ago to slowly export all data used in the SDE to yaml, sqlite files. The community has already created tools to import those files back to SQL Server.


Well I stated that is fine to export as yaml.



O7
Many thanks for response and link.


I apologise in advance for using logic in this issue!

As I’m aware EVE is using SQL 2014 Enterprise as back end DB.
The previous SQL backup includes item types and item groups.

Someone makes decision to export data from SQL to yame that is fine.
The question is why exclude that data from SQL when it was there in the first place!
I need to create component to import yaml back to SQL where it was in the first place.

I’m sure that someone from CCP can present business case that justifies that, and it goes blaaa blaaa blaaa.


m Light
m Light
I N E X T R E M I S
Tactical Narcotics Team
#7 - 2016-03-16 22:41:54 UTC
Desmont McCallock wrote:
The decision was made 4 years ago to slowly export all data used in the SDE to yaml, sqlite files. The community has already created tools to import those files back to SQL Server.



100% == 100 mil ISK ty
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#8 - 2016-03-16 23:12:54 UTC  |  Edited by: Steve Ronuken
Should be noted:

The change happened a few months ago Blink

The file I linked is an sql server backup file, which is fully integrated.

Converting it over is part of my process to create the other versions, so it'll stick around for a fair time. (Once it's entirely released in yaml, I may not. But that'd be because I could do the entire thing, without intervention, on my server. Which won't run sql server, until MS release an express edition on linux. Which I doubt will happen before 2017)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
m Light
I N E X T R E M I S
Tactical Narcotics Team
#9 - 2016-03-17 01:57:45 UTC  |  Edited by: m Light
The short answer on how to get full MS SQL db not provided by CCP is https://forums.eveonline.com/default.aspx?g=posts&t=456458
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#10 - 2016-03-17 13:01:54 UTC
m Light wrote:
The short answer on how to get full MS SQL db not provided by CCP is https://forums.eveonline.com/default.aspx?g=posts&t=456458



bad link?

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Desmont McCallock
#11 - 2016-03-17 13:16:12 UTC
Steve Ronuken wrote:
m Light wrote:
The short answer on how to get full MS SQL db not provided by CCP is https://forums.eveonline.com/default.aspx?g=posts&t=456458



bad link?
No. It's just the underlying url is malformed. The link is just the link to EVESDEToSQL forum thread.