open All Channels
seplocked EVE Technology Lab
blankseplocked Incursion 1.5 Static Data Export & Image Export
 
This thread is older than 90 days and has been locked due to inactivity.


 
Pages: [1] 2

Author Topic

CCP Stillman

Posted - 2011.04.12 10:43:00 - [1]
 

Edited by: CCP Stillman on 19/05/2011 17:00:35
Here’s the Static Data Dump and Image Dump for Incursion 1.5

Static data export:
http://content.eveonline.com/data/Incursion_1.5_41540.zip

Image export types:
http://cdn1.eveonline.com/data/Incursion_1.4_imgs_Types.zip

Image export renders:
http://cdn1.eveonline.com/data/Incursion_1.4_imgs_Renders.zip

Image export icons:
http://cdn1.eveonline.com/data/Incursion_1.4_imgs_Icons.zip

Jercy Fravowitz
School of Applied Knowledge
Posted - 2011.04.12 16:10:00 - [2]
 

mssql singlefile script

mysql singlefile script
mysql one-file-per-table script

sqlite singlefile binary (also for EAM)
postgres-unquoted singlefile compatible script

innodb users please try loading the regular myisam version, then apply this script to change engine and add FKs, then report load/convert times here.

B0FROST
Posted - 2011.04.12 20:00:00 - [3]
 

Originally by: Jercy Fravowitz
conversions

With Catari gone, can I have your babies now? Wink






What? Too soon? Very Happy

Desmont McCallock
Posted - 2011.04.15 12:00:00 - [4]
 

I have a complain to make.

By removing the attributes info for non-published skills from the SDD (dgmTypeAttributes table), you managed to break EVEMon and disable any accuracy on the displayed info or training time for those skills.

A heads-up notice, in the future, on such changes would be much appreciated.

Khoernal Khorotid
Posted - 2011.05.01 04:25:00 - [5]
 

I'm trying to restore the .bak file into a new database and getting an error. This is the first time I've tried to do this.

I'm following these instructions from the other thread:

Quote:
summary:
open sql managment thing, rightclick database (the database tree header, not any specific database), restore database, from device, add the .bak file, select the db to restore, select the db to restore to, might have to adjust pathes in the other tab, go go go.


I have freshly installed ms sql server 2008 R2. I get as far as adding the .bak file to the 'specify backup' dialog. If I then click either Ok or Contents I get:

The media family on device 'I:\downloads\eve\Incursion_1.4_396867\DATADUMP201104061056.bak' is incorrectly formed. SQL Server cannot process this media family.

From some searching on the error it sounds like this means the download is corrupt. But I re-downloaded and got the same thing, and others are obviously getting it to work, so I must be doing something wrong.

I've also downloaded the singlel file script, so I could try that if someone would post some noob-level instructions for loading it.

Any help appreciated very much.

BoomChong Wong
Posted - 2011.05.01 04:51:00 - [6]
 

Edited by: BoomChong Wong on 01/05/2011 04:51:41
Additional info, if it makes a difference:

I am running Win 7 x64, and (because I'm a visual studio developer) already had copies of VS 2008 and VS 2010 installed, as well as MS Sql Server 2005 and MS Sql Server 2008. I'd never used those earlier sql versions. I freshly downloaded 2008 R2 for this eve data. I have not found any updates to apply to it via windows update. During the install I took all default options.

I also tried copying the backup files to my C drive, since I saw something on the net about someone having trouble restoring from an external hard drive (but I was using my 'I' drive which is internal), anyhow, no difference.


(BoomChong Wong == Khoernal Khoritid)

Jercy Fravowitz
School of Applied Knowledge
Posted - 2011.05.01 09:40:00 - [7]
 

Originally by: Khoernal Khorotid
The media family on device 'I:\downloads\eve\Incursion_1.4_396867\DATADUMP201104061056.bak' is incorrectly formed. SQL Server cannot process this media family.

a) make sure you are actualy using the right version of sql server. try deinstalling the older versions, or at least check what version is reported in help->about.
b) make sure the pathes in the other-tab of the restore dialog point at something that actualy exists and is writeable by you.
c) contact microsoft support. :P

BoomChong Wong
Posted - 2011.05.03 03:39:00 - [8]
 

Edited by: BoomChong Wong on 04/05/2011 16:14:18
Thanks for your help, I finally got it by uninstalling everything with 'SQL' in the name and reinstalling 2008 R2. Tellingly, when I tried to connect to the db engine (before restoring) it failed and I had to mess around to get connected to the engine. Once I got the engine connection going the backup imported flawlessly.

So it looks like I was somehow using 2008 R2 to connect to an old DB engine and that was the problem.

Enu Zembasi
Posted - 2011.05.09 15:52:00 - [9]
 

Edited by: Enu Zembasi on 10/05/2011 10:09:14
I just glimpsed over that data and I'm not sure... is there a table with all items in the game? Maybe its just buried inside all those relations that I'm not noticing it?
A few days ago certain site went down, with hosted information on NPC ships (damage dealt, resists, special abilities, HP and such - very detailed and nicely put) - is there some official database for that? Or someone used ship scanner on every NPC ship and put up his own database?

Regards,

EDIT: invTypes seems to be items list. It also holds info about NPC ships, so I answered my own question. Maybe it will help some1.

Wendi Watson
Organization Too Secret To Know
Posted - 2011.05.16 20:33:00 - [10]
 

With the changes to (most of) agent's divisions, along with quality, how soon can we expect an updated SDD?

Karlos Zhang
Posted - 2011.05.17 16:40:00 - [11]
 

Agreed. We're going to need a new data dump after the changes to agents.

Etil DeLaFuente
Posted - 2011.05.17 20:34:00 - [12]
 

We need an accurate (up-to-date) one.

How comes staStations or mapDenormalize lack some stations ? e.g "6Z-CKS VII" is nowhere, yet the station has been built in 2009! Or do we have to query the sov API and figure it out ?


Tonto Auri
Vhero' Multipurpose Corp
Posted - 2011.05.17 20:59:00 - [13]
 

Originally by: Etil DeLaFuente
We need an accurate (up-to-date) one.

How comes staStations or mapDenormalize lack some stations ? e.g "6Z-CKS VII" is nowhere, yet the station has been built in 2009! Or do we have to query the sov API and figure it out ?



You do.
Player-built outposts were never in SDD.

Ruziel
Minmatar
Twilight Military Industrial Complex
Posted - 2011.05.18 06:30:00 - [14]
 

Originally by: Etil DeLaFuente
We need an accurate (up-to-date) one.

How comes staStations or mapDenormalize lack some stations ? e.g "6Z-CKS VII" is nowhere, yet the station has been built in 2009! Or do we have to query the sov API and figure it out ?


Because Conquerable Stations aren't static data, therefore aren't in the Static Data Dump. They can (at least theoretically) change ownership day to day, so it it more appropriate to get that data from the dynamic API.

Etil DeLaFuente
Posted - 2011.05.18 08:31:00 - [15]
 

Edited by: Etil DeLaFuente on 18/05/2011 08:39:35
Edited by: Etil DeLaFuente on 18/05/2011 08:34:49
Player built stations can't be destroyed therefore should be included in the static dump, owner has nothing to do with it. 57 conquerable stations are already present in staStations, maybe because they were not player built ?

I just want to use the CharacterInfo API, which gives the last known location (a station in that case), and dig some infos about that location. Unfortunately, i can't because some stations don't exist and the sov api does not gives enough info, only the solarSystemName is present. Do i have to build my own station list based on db dump and sov api ?

edit : Actually the ConquerableStationList API gives the list i need, seems i'll have to build my own list after all.

CCP Stillman

Posted - 2011.05.19 16:57:00 - [16]
 

Added new SDE

Iurnan Mileghere
Singularity Foundation
Posted - 2011.05.19 19:58:00 - [17]
 

Will Incursion 1.5 have a new image export, or stay as-is from 1.4?

Tonto Auri
Vhero' Multipurpose Corp
Posted - 2011.05.19 20:49:00 - [18]
 

Originally by: Iurnan Mileghere
Will Incursion 1.5 have a new image export, or stay as-is from 1.4?

Anything changed pertaining images?

Matthew
Caldari
BloodStar Technologies
Posted - 2011.05.19 21:52:00 - [19]
 

Originally by: Tonto Auri
Anything changed pertaining images?


Blueprint Copy icons...

Epitrope
The Citadel Manufacturing and Trade Corporation
Posted - 2011.05.19 22:30:00 - [20]
 

Originally by: CCP Stillman
Added new SDE


Sometimes it's useful to have both the old and the new versions. The toolkit page doesn't have a log, and the link got edited out of the first post, so for posterity's sake, here's a link to the Incursion 1.4 SDE:

http://cdn1.eveonline.com/data/Incursion_1.4_39687.zip

Tonto Auri
Vhero' Multipurpose Corp
Posted - 2011.05.20 00:40:00 - [21]
 

Originally by: Matthew
Originally by: Tonto Auri
Anything changed pertaining images?


Blueprint Copy icons...

I don't see any change. They're still indistinguishable from originals.

Iurnan Mileghere
Singularity Foundation
Posted - 2011.05.20 13:15:00 - [22]
 

Originally by: Tonto Auri
Originally by: Matthew

Blueprint Copy icons...

I don't see any change. They're still indistinguishable from originals.


Then you're missing something, because the icons have a clear and obvious difference. BPCs are now much lighter and have scan lines.

Tonto Auri
Vhero' Multipurpose Corp
Posted - 2011.05.20 18:53:00 - [23]
 

Originally by: Iurnan Mileghere
Then you're missing something, because the icons have a clear and obvious difference. BPCs are now much lighter and have scan lines.


kk, show me?
http://img32.imageshack.us/i/bpcs20110519.png/Please visit your user settings to enable images.

http://img32.imageshack.us/i/bpcs20110519.png/

Adrielle Firewalker
Minmatar
Amarr Will Eat Itself
Posted - 2011.05.20 19:13:00 - [24]
 

Does anyone have any conversion tools for this? The MSSQL output is pretty useless for me. Sad

EveDataRules
World Domination Inc
Posted - 2011.05.21 01:02:00 - [25]
 

Edited by: EveDataRules on 21/05/2011 01:01:56
http://www.evedata.org/eve-incursion-1.5-myisam.sql.gz

MySQL MyISAM version of the database export to tide people over; there were a few conversion errors.

Adrielle Firewalker
Minmatar
Amarr Will Eat Itself
Posted - 2011.05.21 01:25:00 - [26]
 

Thanks very much! Very Happy

Hel O'Ween
Men On A Mission
EVE Trade Consortium
Posted - 2011.05.27 14:31:00 - [27]
 

Originally by: Adrielle Firewalker
Does anyone have any conversion tools for this? The MSSQL output is pretty useless for me. Sad


Maestro AnySQL is a nice product for the occassional "data-from-this-to-that-format" tasks.

J'J'J'Jita
Ch'Ch'Ch'Chia Corp
Posted - 2011.05.28 01:23:00 - [28]
 

Edited by: J''J''J''Jita on 28/05/2011 01:29:22
edit: nevermind, found threads

Luminocity
Posted - 2011.05.28 14:26:00 - [29]
 

Edited by: Luminocity on 28/05/2011 14:27:38
I'm not sure why the fresh conversion links haven't been posted but they seem to be available here:
http://eve.no-ip.de/inc15/

Props to Jercy Fravowitz..

Also, CCP, stop being cheap and modifying the initial post - it's confusing. Just make a new thread or at least a fresh post in the old thread when a new dump is out... (don't worry we'll pay for it :D)

Edit: How ironic that I should need to edit this post after saying that..

dragonyte
Posted - 2011.05.29 05:16:00 - [30]
 

What is the database name suppose to be? I am getting System.dta.sqlclient.sqlerror: the backup set holds a database other then the existing.... I ran the script that was with the static dump in the database i created...is there an "offical" name we are suppose to use?


Pages: [1] 2

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only