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.
12Next page
 

Static Data Export & Image Export for Incarna 1.1

First post
Author
Previous Topic Next Topic
CCP Spitfire
C C P
C C P Alliance
#1 - 2011-09-06 07:37:55 UTC  |  Edited by: CCP Stillman
Here’s the Static Data Export and Image Export Collection for Incarna

Static data export:
http://content.eveonline.com/data/Incarna_1.1.45834_db.zip

Image export collection: Types:
http://content.eveonline.com/data/Incarna_1.1_imgs_Types.zip

Image export collection: Renders:
http://content.eveonline.com/data/Incarna_1.1_imgs_Renders.zip

Image export collection: Icons:
http://content.eveonline.com/data/Incarna_1.1_imgs_Icons.zip

CCP Spitfire | Marketing & Sales Team @ccp_spitfire
Desmont McCallock
#2 - 2011-09-09 06:03:48 UTC  |  Edited by: Desmont McCallock
SDD for sqlite:
inca11-sqlite3-v1.db
Dragonaire
Here there be Dragons
#3 - 2011-09-09 15:05:45 UTC
Someone going to make this a sticky or is it going to continue to slide down the page ;)

Finds camping stations from the inside much easier. Designer of Yapeal for the Eve API. Check out the Yapeal PHP API Library thread.
TorTorden
Tors shibari party
#4 - 2011-09-15 11:54:20 UTC
Was looking around for a MySql version of this and found this one, Jerotire's "Incarna_1.1.45834_db_mysql_v2.zip"

For some reason this wouldn't set up into the db I specifed but made a db called "evedata1_dbo"
No real biggie, just mentioning it since I was curious why the database I thought it was loading into was empty Ugh

Removing line 21 and 22 from the sql file sorts this out np.
Luminocity
The Dark Revenants
PLEASE NOT VIOLENCE OUR BOATS
#5 - 2011-09-18 03:05:35 UTC  |  Edited by: Luminocity
Jerotire's "Incarna_1.1.45834_db_mysql_v2.zip" seems to be using extended inserts which is a no-go for a 867 MB dump as import scripts have no way of slicing it up into manageable parts...
TorTorden
Tors shibari party
#6 - 2011-09-19 08:46:45 UTC
Easy fix, load it up on your local computer and make a mysqldump from there without extended inserts.
Zifrian
The Frog Pond
Ribbit.
#7 - 2011-09-20 00:23:27 UTC  |  Edited by: Zifrian
Missing the following blueprint icons in the Types image zip:

Blueprint ID - Blueprint Name
15942 - Ammatar Navy Small EMP Smartbomb Blueprint
15946 - Ammatar Navy Medium EMP Smartbomb Blueprint
15948 - Ammatar Navy Large EMP Smartbomb Blueprint
15950 - Federation Navy Small Plasma Smartbomb Blueprint
15954 - Federation Navy Medium Plasma Smartbomb Blueprint
15956 - Federation Navy Large Plasma Smartbomb Blueprint
15958 - Imperial Navy Small EMP Smartbomb Blueprint
15960 - Imperial Navy Micro EMP Smartbomb Blueprint
15962 - Imperial Navy Medium EMP Smartbomb Blueprint
15964 - Imperial Navy Large EMP Smartbomb Blueprint
15966 - Republic Fleet Tracking Enhancer Blueprint
15968 - Federation Navy Tracking Link Blueprint
16029 - 800mm Repeating Artillery II Blueprint
16032 - 150mm Light AutoCannon II Blueprint

I've sent in a bug report.

Maximze your Industry Potential! - Download EVE Isk per Hour!

Import CCP's SDE - EVE SDE Database Builder
Fortune Taker
#8 - 2011-09-20 03:31:24 UTC
Dragonaire wrote:
Someone going to make this a sticky or is it going to continue to slide down the page ;)


This was sticky

Hey CCP Navigator, why no more sticky?
Johnathan Roark
Quantum Industries
#9 - 2011-09-20 15:57:00 UTC
Fortune Taker wrote:
Dragonaire wrote:
Someone going to make this a sticky or is it going to continue to slide down the page ;)


This was sticky

Hey CCP Navigator, why no more sticky?



Someone used the cheap glue, I suggest guerrilla glue.

EVEVERIFY - A recruiting API Verification and Audit Tool

Also try out Yapeal for your php api needs
Chloey Armstrong
University of Caille
Gallente Federation
#10 - 2011-09-27 10:03:17 UTC
Nice dumps!

Are there tables included regarding Planetary Interaction (the different commodoties and relations between them) ?
Sir Arland
Deep Core Mining Inc.
Caldari State
#11 - 2011-10-05 09:39:48 UTC
Any reason to have two "Placeables" categories (27 and 49)?

The 27 seems to be useless in datadump.

Chloey Armstrong wrote:
Are there tables included regarding Planetary Interaction (the different commodoties and relations between them) ?


planetSchematics and planetSchematicsTypeMap tables, second one provide the relations between PI commodities
Joel McBeth
Science and Trade Institute
Caldari State
#12 - 2011-10-06 02:02:25 UTC
Quote:
-- Adding a whole lot of foreign key constraints to signify the relationship between the new tables and the current ones.
-- Seriously.. am I the only one really tired of all the pro-protoss players being so Colossus reliant in every matchup?!
-- And what the **** is up with the proposed High Templar nerf?! Can we get a colussus nerf so that people at least attempt to find new plays!


Found this guy in the comments?

I also get multiple errors when trying create the foreign key contraints in the bottom of the file. So far two can't be created because of a type mismatch and trying to create a foreign key on a table field that doesn't exist.

Msg 1769, Level 16, State 1, Line 89
Foreign key 'eveOwners_FK_owner' references invalid column 'itemID' in referencing table 'eveOwners'.
Msg 1750, Level 16, State 0, Line 89
Could not create constraint. See previous errors

ALTER TABLE eveOwners ADD CONSTRAINT eveOwners_FK_owner FOREIGN KEY (itemID) REFERENCES invItems(itemID)

There is no itemID in eveOwners.

Also, invItems.itemID is a bigint and eveNames.itemID is an int.

This is with SQL Server Express 2008.
Luminocity
The Dark Revenants
PLEASE NOT VIOLENCE OUR BOATS
#13 - 2011-10-10 10:07:08 UTC  |  Edited by: Luminocity
As the previously posted MySQL conversion seemed to have multiple shortcomings:

  • ..created a database named evedata1_dbo. This one should import into whichever database you specify..
  • ..used extended inserts making most every automated import scripts sh*t bricks. This one is the usual insert-per-each-row approach..
  • ..seemed to be incorrectly converted to UTF8 charset breaking a significant number of values (23509 in trnTranslations among others)
  • .. completely lacked data for the following tables: dgmAttributeTypes, eveUnits, ramAssemblyLineTypeDetailPerCategory, ramAssemblyLineTypeDetailPerGroup, ramAssemblyLineTypes, ramInstallationTypeContents

..I tried my luck at creating a new one. No guarantee it's any better but feel free to check it out:
incarna1.1.45834-mysql5-v2.zip (MySQL 5 singlefile)
Golden Gnu
Lobach Inc.
#14 - 2011-10-11 13:21:20 UTC  |  Edited by: Golden Gnu
-_-

Creator of jEveAssets - the asset manager

"Download is the meaning of life, upload is the meaning of intelligent life"
TorTorden
Tors shibari party
#15 - 2011-10-13 06:29:07 UTC  |  Edited by: TorTorden
Luminocity wrote:
As the previously posted MySQL conversion seemed to have multiple shortcomings:

  • ..created a database named evedata1_dbo. This one should import into whichever database you specify..
  • ..used extended inserts making most every automated import scripts sh*t bricks. This one is the usual insert-per-each-row approach..
  • ..seemed to be incorrectly converted to UTF8 charset breaking a significant number of values (23509 in trnTranslations among others)
  • .. completely lacked data for the following tables: dgmAttributeTypes, eveUnits, ramAssemblyLineTypeDetailPerCategory, ramAssemblyLineTypeDetailPerGroup, ramAssemblyLineTypes, ramInstallationTypeContents

..I tried my luck at creating a new one. No guarantee it's any better but feel free to check it out:
incarna1.1.45834-mysql5-v1.zip (MySQL 5 singlefile)


Just figured this out myself as well, I normaly don't realy use any of those tables much, but was trying to query some type attributes.
The weird bit is that when looking directly in the .sql file (with vim, damn near ordered 24gig of ram for the hell of it)I can see the lines there, *scratches head.

Guess Jercy spoiled us rotten..
Luminocity
The Dark Revenants
PLEASE NOT VIOLENCE OUR BOATS
#16 - 2011-10-13 07:39:56 UTC  |  Edited by: Luminocity
TorTorden wrote:
Just figured this out myself as well, I normaly don't realy use any of those tables much, but was trying to query some type attributes.
The weird bit is that when looking directly in the .sql file (with vim, damn near ordered 24gig of ram for the hell of it)I can see the lines there, *scratches head.

Guess Jercy spoiled us rotten..
My wild guess would be that one of the columns with that dump is created with an incorrect signature thus failing the data inserts..

On another note, I will probably be switching my dump from InnoDB to MyISAM soon as it is just static data anyway

EDIT: Here's the new version in MyISAM: incarna1.1.45834-mysql5-v2.zip
TorTorden
Tors shibari party
#17 - 2011-10-15 14:10:30 UTC
Just letting you know that your dump seemed to work much better (the tables have values in them now)

Great work.
Spymaster Alpha
EveTech Enterprises
#18 - 2011-11-03 23:12:08 UTC
Anyone have separate table files for MySQL? All I need is invGroups and invTypes, and I'd really rather not spend the many hours uploading the entire massive DB from a single file.
Neo Aboroni
Perkone
Caldari State
#19 - 2011-11-22 21:14:49 UTC  |  Edited by: Neo Aboroni
Since static export thread in the old forums was used to also report image server issues, I'm reporting these images again here:

http://image.eveonline.com/InventoryType/639_64.png
http://image.eveonline.com/Type/639_32.png

EDIT- Woot, thanks for fixing.
Cyerus
University of Caille
Gallente Federation
#20 - 2011-11-30 12:35:29 UTC
Any ETA on the Crucible expansion DB-dump?
12Next page