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 Conversion for Citadel

First post
Author
Previous Topic Next Topic
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#1 - 2016-04-28 01:03:50 UTC  |  Edited by: Steve Ronuken
Mysql
https://www.fuzzwork.co.uk/dump/sde-20160427-TRANQUILITY.tbz2

csv files:
https://www.fuzzwork.co.uk/dump/sde-20160427-TRANQUILITY/

sqlite:
https://www.fuzzwork.co.uk/dump/sde-20160427-TRANQUILITY/eve.db.bz2

Postgres:
https://www.fuzzwork.co.uk/dump/sde-20160427-TRANQUILITY/postgres-20160427-TRANQUILITY.dmp.bz2


Please bear in mind that this is a new conversion method, so if you have any trouble, let me know.

Main differences would be in universe data, and the non-yamlised tables from the older sde. They should all be fine, but I don't feel comfortable promising they're identical. 95% sure?

(Side effect: Postgres is now going to be using Boolean columns where appropriate. because it's easier for me to import, rather than having to cast things)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
KnifeOrSpoon
Contraposition Industries Inc
#2 - 2016-04-28 06:11:03 UTC
As usual... love your work mate :)
Althalus Stenory
Flying Blacksmiths
#3 - 2016-04-28 13:31:21 UTC
Thanks Steve !

EsiPy - Python 2.7 / 3.3+ Swagger Client based on pyswagger for ESI
Soldarius
Dreddit
Test Alliance Please Ignore
#4 - 2016-04-28 14:44:50 UTC
You're doing God's work, Steve. Many thanks.

http://youtu.be/YVkUvmDQ3HY
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#5 - 2016-04-29 16:49:16 UTC  |  Edited by: Steve Ronuken
Aineko Macx
#6 - 2016-04-30 05:58:08 UTC  |  Edited by: Aineko Macx
Thanks from me as well!

I've noted that some inventor blueprints do not have an entry in industryActivityProbabilities for activity = 8. These are:
Standup M-Set Missile Precision I Blueprint (37378)
Standup M-Set Missile Projection I Blueprint (37380)
Standup M-Set Energy Neutralizer Projection I Blueprint (37382)
Standup M-Set Energy Neutralizer Economy I Blueprint (37384)
Standup M-Set Electronic Warfare Projection I Blueprint (37390)
Standup M-Set Electronic Warfare Economy I Blueprint (37392)
Standup M-Set Structure Target Multiplexing I Blueprint (37394)
Standup M-Set Scan Resolution I Blueprint (37396)

I haven't looked at the original SDE yaml files but I assume it's missing there.

EDIT: There's more stuff missing:

Capital Capacitor Booster II (41493) doesn't appear as product in industryActivityProducts. There's probably more...

iveeCore 3.0: The PHP engine for industrial activities and CREST library
Medusa The Gorgon
Temple of the Serpent
The Gorgon Empire
#7 - 2016-05-01 07:41:21 UTC
Our project relies on postgresql with evesde schema. This is the first update without it. Have I miss notification from you that you stop seed it?
This update has it https://www.fuzzwork.co.uk/dump/yc118-2-116998/

Can you return it back?

Thank you.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#8 - 2016-05-01 18:33:01 UTC
Medusa The Gorgon wrote:
Our project relies on postgresql with evesde schema. This is the first update without it. Have I miss notification from you that you stop seed it?
This update has it https://www.fuzzwork.co.uk/dump/yc118-2-116998/

Can you return it back?

Thank you.



I'll look into how I can update it to include that.

The process for me importing and converting is very different now. I _should_ be able to force it into the schema.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Nick Starkey
Native Freshfood
Minmatar Republic
#9 - 2016-05-01 20:17:22 UTC
Just wanted to thank you for doing this as well. Big smile

I've made a signature. I hope you're enjoying it. www.evetrademaster.com - web based asset manager & profit tracker
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#10 - 2016-05-02 02:20:54 UTC
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#11 - 2016-05-02 02:23:30 UTC
Aineko Macx wrote:
Thanks from me as well!

I've noted that some inventor blueprints do not have an entry in industryActivityProbabilities for activity = 8. These are:
Standup M-Set Missile Precision I Blueprint (37378)
Standup M-Set Missile Projection I Blueprint (37380)
Standup M-Set Energy Neutralizer Projection I Blueprint (37382)
Standup M-Set Energy Neutralizer Economy I Blueprint (37384)
Standup M-Set Electronic Warfare Projection I Blueprint (37390)
Standup M-Set Electronic Warfare Economy I Blueprint (37392)
Standup M-Set Structure Target Multiplexing I Blueprint (37394)
Standup M-Set Scan Resolution I Blueprint (37396)

I haven't looked at the original SDE yaml files but I assume it's missing there.

EDIT: There's more stuff missing:

Capital Capacitor Booster II (41493) doesn't appear as product in industryActivityProducts. There's probably more...



It's looking that way, yes.

(The cap cap booster II invention is bugged in game. Currently produces a heavy booster)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#12 - 2016-05-02 11:37:25 UTC
Medusa The Gorgon wrote:
Our project relies on postgresql with evesde schema. This is the first update without it. Have I miss notification from you that you stop seed it?
This update has it https://www.fuzzwork.co.uk/dump/yc118-2-116998/

Can you return it back?

Thank you.



Done!

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Medusa The Gorgon
Temple of the Serpent
The Gorgon Empire
#13 - 2016-05-02 14:56:11 UTC
Steve Ronuken wrote:
Done!

Thank you very much! Is it OK for you to provide schema version for future conversions?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#14 - 2016-05-02 17:26:08 UTC
Medusa The Gorgon wrote:
Steve Ronuken wrote:
Done!

Thank you very much! Is it OK for you to provide schema version for future conversions?



Now that I've got it working, it's just another script to run.

So no trouble at all :)

I'll see about creating a latest link too.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter