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.
 

SDE - Mosaic converted.

First post
Author
Previous Topic Next Topic
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#1 - 2015-04-28 12:52:02 UTC  |  Edited by: CCP Phantom
Aineko Macx
#2 - 2015-04-28 16:09:51 UTC
salacious necrosis
Garoun Investment Bank
Gallente Federation
#3 - 2015-04-29 01:59:40 UTC
Nice job as always Steve. Any thoughts on how to table the skins data? Looks like a pretty straightforward schema for three tables with obvious xrefs.

Use EveKit ! - Tools for EVE Online 3rd party development
Cyborgu Hurtini
Native Freshfood
Minmatar Republic
#4 - 2015-04-29 06:15:40 UTC
Thanks Steve!
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#5 - 2015-04-29 11:46:27 UTC
salacious necrosis wrote:
Nice job as always Steve. Any thoughts on how to table the skins data? Looks like a pretty straightforward schema for three tables with obvious xrefs.



I've not looked at it yet Smile

I was planning to do it today, but persistent connections to my server are acting up from this location. Tonight maybe.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#6 - 2015-04-30 13:45:00 UTC
Updated version for 1.2 released

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Zifrian
The Frog Pond
Ribbit.
#7 - 2015-04-30 14:39:10 UTC
Steve Ronuken wrote:
Updated version for 1.2 released

Do you know what those changes were? I also see icons image file went to 1.2 but not the types file, which has missing data.

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

Import CCP's SDE - EVE SDE Database Builder
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#8 - 2015-04-30 16:28:29 UTC
I think it was mostly the refine numbers.


Now available:
https://www.fuzzwork.co.uk/dump/mosaic-1.2-112318/skins.sql.bz2


(It'll be in the main export from now on)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Galattico Bontius
Doomheim
#9 - 2015-05-01 22:13:12 UTC
Thanks Steve, much appreciated.
Althalus Stenory
Flying Blacksmiths
#10 - 2015-05-10 12:27:06 UTC
Thanks Steve, as always, for these conversions :)

I have a question regarding skins: with Mosaic, skin blueprints should have been replaced by "skin objects"

But as I was looking at the invTypes table, I saw these rows (in the latest sqlite export) :
(typeID, typeName)
33634, Maelstrom Krusual Edition Blueprint
33650, Stabber Krusual Edition Blueprint
33666, Rifter Krusual Edition Blueprint
34250, Tempest Krusual Edition Blueprint
34256, Vargur Krusual Edition Blueprint
(This is not a full extract, but there are 82 blueprints after searching)

Aren't these blueprints supposed to be removed from the SDE database ?

It's not a big problem, but I was thinking older skin blueprint won't be anymore in the SDE.

Thanks ! :)

EsiPy - Python 2.7 / 3.3+ Swagger Client based on pyswagger for ESI
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#11 - 2015-05-10 19:00:03 UTC
Althalus Stenory wrote:
Thanks Steve, as always, for these conversions :)

I have a question regarding skins: with Mosaic, skin blueprints should have been replaced by "skin objects"

But as I was looking at the invTypes table, I saw these rows (in the latest sqlite export) :
(typeID, typeName)
33634, Maelstrom Krusual Edition Blueprint
33650, Stabber Krusual Edition Blueprint
33666, Rifter Krusual Edition Blueprint
34250, Tempest Krusual Edition Blueprint
34256, Vargur Krusual Edition Blueprint
(This is not a full extract, but there are 82 blueprints after searching)

Aren't these blueprints supposed to be removed from the SDE database ?

It's not a big problem, but I was thinking older skin blueprint won't be anymore in the SDE.

Thanks ! :)



If they're in the export, they're in the data from CCP.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Nevyn Auscent
Broke Sauce
#12 - 2015-05-12 21:57:10 UTC
It's not possible for you to provide a Microsoft SQL Server backup is it Steve? For those of us not 100% conversant with converting between programs.
CCP's SDE was compatible nicely with it, but since they've dropped all the manufacturing data out of the DB into the yaml files it's become... well.... not much use for a lot of people.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#13 - 2015-05-12 22:05:37 UTC
Nevyn Auscent wrote:
It's not possible for you to provide a Microsoft SQL Server backup is it Steve? For those of us not 100% conversant with converting between programs.
CCP's SDE was compatible nicely with it, but since they've dropped all the manufacturing data out of the DB into the yaml files it's become... well.... not much use for a lot of people.


https://forums.eveonline.com/default.aspx?g=posts&t=324435&find=unread may be of interest.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Airi Cho
Dark-Rising
Wrecking Machine.
#14 - 2015-06-02 22:41:34 UTC
your links have typos in the links:


broken:
https://www.fuzzwork.co.uk/dump/mosaic-1.2-112318/postgres-mosaic-1.2-112318.sql.bz2

correct:
https://www.fuzzwork.co.uk/dump/mosaic-1.2-112318/postgres-mosaic-1.2.112318.sql.bz2