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.
 

Oceanus 1.0 SDE is out.

First post
Author
Previous Topic Next Topic
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#1 - 2014-09-26 21:26:36 UTC
Official release is on:
http://community.eveonline.com/community/fansites/toolkit/



Conversions:
Mysql:
https://www.fuzzwork.co.uk/dump/mysql56-oceanus-1.0-105658.tbz2

Sqlite:https://www.fuzzwork.co.uk/dump/oceanus-1.0-105658/eve.db.bz2

Postgres
https://www.fuzzwork.co.uk/dump/oceanus-1.0-105658/postgres-oceanus-1.105658.sql.bz2

Postgres dump is now done in postgres format, for restoration with pg_restore. excludes privileges.




Everything else:
https://www.fuzzwork.co.uk/dump/oceanus-1.0-105658/



NEW:
https://www.fuzzwork.co.uk/dump/oceanus-1.0-105658/postgres-oceanus-evesdeschema-1.105658.sql.bz2

The same postgres conversion, but in a distinct schema 'evesde' rather than public

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Desmont McCallock
#2 - 2014-09-27 08:19:30 UTC  |  Edited by: Desmont McCallock
Missing data report:

- Rattlesnake Victory Edition Blueprint (typeID: 34153) is missing from the blueprints.yaml data.
- TypeID's 34121,34129,34131 of blueprints.yaml data have no related data to invTypes data.
Pete Butcher
The Scope
Gallente Federation
#3 - 2014-09-29 06:48:18 UTC
Something seems to be wrong. For example Micro Vigor Core Augmentation (16543) has null market group.

http://evernus.com - the ultimate multiplatform EVE trade tool + nullsec Alliance Market tool
Banko Mato
Republic University
Minmatar Republic
#4 - 2014-09-29 18:17:41 UTC
Pete Butcher wrote:
Something seems to be wrong. For example Micro Vigor Core Augmentation (16543) has null market group.



Maybe because they will be removed/replaced according to the dev blog:

DevBlog wrote:
The current metas 1-3 named MAPCs will be converted into the new Compact Compact Micro Auxiliary Power Core but the Vigors will be turned into Navy MAPCs over downtime.
Pete Butcher
The Scope
Gallente Federation
#5 - 2014-09-29 18:23:16 UTC
Banko Mato wrote:
Pete Butcher wrote:
Something seems to be wrong. For example Micro Vigor Core Augmentation (16543) has null market group.



Maybe because they will be removed/replaced according to the dev blog:

DevBlog wrote:
The current metas 1-3 named MAPCs will be converted into the new Compact Compact Micro Auxiliary Power Core but the Vigors will be turned into Navy MAPCs over downtime.


The logical thing to do is just to update the name + meta level, not remove the item into oblivion and add something new. After all, the item still exists in the DB.

But hell, we'll see tomorrow.

http://evernus.com - the ultimate multiplatform EVE trade tool + nullsec Alliance Market tool
Pete Butcher
The Scope
Gallente Federation
#6 - 2014-09-30 20:48:22 UTC
And so they merged it with existing item which costs 4x less. Great. And I thought they'll make a new Navy one without crashing that market.

All in all, the dump seems to be ok then.

http://evernus.com - the ultimate multiplatform EVE trade tool + nullsec Alliance Market tool
Azarion Sinak
678 lost souls
#7 - 2014-09-30 23:52:06 UTC  |  Edited by: Azarion Sinak
Any chance we are going to see a SQL Server dump? For the non DB stuff like Blueprints and such? Oh, and Tech Level?
Hel O'Ween
Men On A Mission
#8 - 2014-10-01 09:19:59 UTC
When working with MS SQL, try Desmont's excellent tool for importing the YAML files back into the database: https://forums.eveonline.com/default.aspx?g=posts&t=324435

EVEWalletAware - an offline wallet manager.
Pie Napple
Science and Trade Institute
Caldari State
#9 - 2014-10-04 10:14:31 UTC
I think i found a problem in the sqlite-conversion, with floats.

If you check the table industryActivityProbabilities, the probablities are all zero.
The same problem can be found in ramAssemblyLineTypes, where all the modifiers seems to be integers too.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#10 - 2014-10-04 11:37:10 UTC
Pie Napple wrote:
I think i found a problem in the sqlite-conversion, with floats.

If you check the table industryActivityProbabilities, the probablities are all zero.
The same problem can be found in ramAssemblyLineTypes, where all the modifiers seems to be integers too.



I just opened up the sqlite version, on my server, with the sqlite3 command line tool. The probabilities all show up in it?

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Pie Napple
Science and Trade Institute
Caldari State
#11 - 2014-10-04 13:40:44 UTC
Steve Ronuken wrote:
Pie Napple wrote:
I think i found a problem in the sqlite-conversion, with floats.

If you check the table industryActivityProbabilities, the probablities are all zero.
The same problem can be found in ramAssemblyLineTypes, where all the modifiers seems to be integers too.



I just opened up the sqlite version, on my server, with the sqlite3 command line tool. The probabilities all show up in it?


Sorry about that. I must have messed up mine, or not downloaded the latest one. I redownloaded and tried again. The latest version is correct, my old one it not.

A screenshot of the error: https://dl.dropboxusercontent.com/s/baqej476dnwa1jb/2014-10-04%20at%2015.37.png?dl=0

I thought i had downloaded the latest one... Sorry about the false alarm.
Madeline Doshu
Royal Damsels in Distress
#12 - 2014-10-13 17:02:35 UTC
I had thought they were getting rid of Data Interfaces for Invention in Oceanus. The Blueprints.yaml still indicates one non-consumed type for each blueprint that supports the invention activity.

Am I missing something?
Pie Napple
Science and Trade Institute
Caldari State
#13 - 2014-10-13 17:58:36 UTC
Madeline Doshu wrote:
I had thought they were getting rid of Data Interfaces for Invention in Oceanus. The Blueprints.yaml still indicates one non-consumed type for each blueprint that supports the invention activity.

Am I missing something?


Nope. I think that will come in phoebe though.
Desmont McCallock
#14 - 2014-10-13 18:43:23 UTC
Oceanus was phase 1 for Industry changes. Phoebe is phase 2. Pie is right.