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

Forum Index

EVE Forums » EVE Technology and Research Center » EVE Technology Lab » Rubicon SDE is out.

Topic is locked indefinitely.

Rubicon SDE is out. First post
Author

Previous Topic Next Topic

Steve Ronuken

Fuzzwork Enterprises

Vote Steve Ronuken for CSM

Likes received: 6,759

#81 - 2014-02-22 17:38:14 UTC

Desmont McCallock wrote:

I'm almost done with the tool that imports the ' from now on extracted to another format' data back into MSSQL, but...

@CCP Creber Cattus
First, I have stumbled on a issue with the data types. In mapCelestialStatistics table the 'fragmented' and 'locked' columns are defined as "int" although they should be defined as "bit". This difference is causing me troubles when casting the type.

Also "pressure", "radius" and "mass" are defined as 'int' although they should be defined as "real" which results to incorrect data (data are different in previous SDE versions).

Is it possible to switch the data type to the correct type?

Second, in mapLandmarks table there is no 'radius' and 'importance' columns which leads to data loss as previous SDE versions contained data in those columns.
Is there an explanation to this?

Quote:

The reason for this change is that the radius and importance columns were only used for landmark authoring.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

655
Desmont McCallock Likes received: 655	#82 - 2014-02-22 18:27:48 UTC \| Edited by: Desmont McCallock Steve, although I can't find the source of the quote you posted, I trust it's true. Still issue No 1 remains.

Steve Ronuken

Fuzzwork Enterprises

Vote Steve Ronuken for CSM

Likes received: 6,759

#83 - 2014-02-22 18:35:53 UTC

Desmont McCallock wrote:

Steve, although I can't find the source of the quote you posted, I trust it's true. Still issue No 1 remains.

It's in the dev blog for the new update. http://community.eveonline.com/news/dev-blogs/eve-universe-static-data-export/

There are other issues with that update though. Like a bunch of empty tables (without the data being in the sqlite file)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter


Desmont McCallock Likes received: 655	#84 - 2014-02-22 19:05:39 UTC lol, Steve, although I read the dev blog when it was first published, I probably skipped that part. Haven't stumbled across any empty tables yet, but if you say so.

Doomheim 2,958
Darkblad Doomheim Likes received: 2,958	#85 - 2014-02-22 19:52:35 UTC \| Edited by: Darkblad Desmont McCallock wrote: lol, Steve, although I read the dev blog when it was first published, I probably skipped that part. Haven't stumbled across any empty tables yet, but if you say so. An empty one without a direct substitute within the sqlite is chrFactions, which I've learned the hard way. NPE – ISD – RIP


Steve Ronuken Fuzzwork Enterprises Vote Steve Ronuken for CSM Likes received: 6,759	#86 - 2014-02-22 19:58:09 UTC staStations, all the agent tables. All the corporation tables. (I've listed them in the comments on the devblog) Woo! CSM XI! Fuzzwork Enterprises Twitter: @fuzzysteve on Twitter


Desmont McCallock Likes received: 655	#87 - 2014-02-23 08:56:56 UTC Holly smokes, guys you are right. For the tool I'm doing I was working with a Rubicon 1.1.2 backup. Now that I restored the Rubicon 1.2 SDE, the whole hell broke lose. Calling CCP Creber Cattus and CCP Prism X to the rescue.


Desmont McCallock Likes received: 655	#88 - 2014-02-23 15:33:55 UTC \| Edited by: Desmont McCallock 1 Proudly presenting SDEExternalsToSql tool.

Celebrain

Aliastra

Gallente Federation

Likes received: 0

#89 - 2014-02-26 03:34:44 UTC

Trying to restore DATADUMP201401300958.bak from http://cdn1.eveonline.com/data/Rubicon_1.1.2_94438_db.zip to SQL Express 2008 R2 on Windows XP and getting the following error:

===================================

Specified cast is not valid. (SqlManagerUI)

Program Location:

at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseGeneral.PopulateGridWithBackupSetsFromDevices()
at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseGeneral.GetBackupSetsFromDevices()
at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseGeneral.textDeviceSelected_TextChanged(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnTextChanged(EventArgs e)
at System.Windows.Forms.TextBoxBase.OnTextChanged(EventArgs e)
at System.Windows.Forms.Control.set_Text(String value)
at System.Windows.Forms.TextBoxBase.set_Text(String value)
at System.Windows.Forms.TextBox.set_Text(String value)
at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseGeneral.buttonSelectDevice_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Steve Ronuken

Fuzzwork Enterprises

Vote Steve Ronuken for CSM

Likes received: 6,759

#90 - 2014-02-26 14:02:05 UTC

Celebrain wrote:

That's because it's a 2012 export. you'll need to upgrade.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

Celebrain

Aliastra

Gallente Federation

Likes received: 0

#91 - 2014-02-26 18:59:49 UTC

Steve Ronuken wrote:

That's because it's a 2012 export. you'll need to upgrade.

Yeah, I can see I misread the original post... welp, this means new laptop, new version of windows, so my project will be backburnered for a few more months... or until they actually give us the data without requiring this (i.e. finish the yaml versions). or I do have a desktop that can run 2012 (the same one that runs eve) but then that means no updates when I'm traveling.

Juderet Belmar

The Scope

Gallente Federation

Likes received: 0

#92 - 2014-02-26 22:04:31 UTC

Steve Ronuken wrote:

New conversions.

https://www.fuzzwork.co.uk/dump/sqlite-latest.sqlite.bz2
https://www.fuzzwork.co.uk/dump/postgres-latest.sql.bz2
https://www.fuzzwork.co.uk/dump/mysql-latest.tar.bz2

https://www.fuzzwork.co.uk/dump/rubicon-1.2-94438/

For mysql, you'll find the universe data in a separate file to import. the others have it embedded.

I'm /pretty/ sure it'll work, though the conversion tool I used had some data type issues. Seriously considering picking up a commercial tool for this. Smile

At first a big thanks for offering all the conversions, great job!

While coding a tool for EVE I noticed a bug in the table invtraits mysql56-rubicon-1.2-94438.sql found in mysql-latest.tar.bz2: The bonus attribute is an INT but it should be a DOUBLE since some trait boni have float values like the scan strength bonus of the Astero.

Steve Ronuken

Fuzzwork Enterprises

Vote Steve Ronuken for CSM

Likes received: 6,759

#93 - 2014-02-26 22:27:56 UTC

Juderet Belmar wrote:

Steve Ronuken wrote:

Ahh, I'll update it for next time. Smile

I'd suggest going to 1.1 rather than 1.2, as the 1.2 export's incomplete. (due to issues with the how the original export was done)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

Garoun Investment Bank Gallente Federation 4
Manhim Garoun Investment Bank Gallente Federation Likes received: 4	#94 - 2014-03-06 23:57:48 UTC \| Edited by: Manhim I just made a North American/Montreal mirror for Steve's MySQL dumps: http://cyanventures.org/dumps/ (Rubicon+ and Dust only at the moment)


Steve Ronuken Fuzzwork Enterprises Vote Steve Ronuken for CSM Likes received: 6,759	#95 - 2014-03-07 00:03:21 UTC 1 Manhim wrote: I just made a North American/Montreal mirror for Steve's MySQL dumps: http://cyanventures.org/dumps/ (Rubicon+ and Dust only at the moment) Confirming he talked to me first (Not that he needed to. It's still CCPs data. But it was nice) Woo! CSM XI! Fuzzwork Enterprises Twitter: @fuzzysteve on Twitter


Desmont McCallock Likes received: 655	#96 - 2014-03-08 16:26:42 UTC Looks like Rubicon 1.3 SDE is going to be late.


Darkblad Doomheim Likes received: 2,958	#97 - 2014-03-08 19:36:36 UTC Appears so. But they're also still dropping some minor patches. I'm currently getting build 737539 by the launcher. NPE – ISD – RIP


Darkblad Doomheim Likes received: 2,958	#98 - 2014-03-10 18:36:50 UTC there we go http://cdn1.eveonline.com/data/Rubicon_1.3_95173_db.zip NPE – ISD – RIP

Steve Ronuken

Fuzzwork Enterprises

Vote Steve Ronuken for CSM

Likes received: 6,759

#99 - 2014-03-10 20:47:37 UTC

That's rubicon 1.3 converted. Data looks to be better.

https://www.fuzzwork.co.uk/dump/mysql56-rubicon-1.3-95173.tbz2
https://www.fuzzwork.co.uk/dump/rubicon-1.3-95173/postgres-rubicon-1.3-95173.sql.bz2
https://www.fuzzwork.co.uk/dump/rubicon-1.3-95173/rubicon13.sqlite.bz2

https://www.fuzzwork.co.uk/dump/rubicon-1.3-95173/

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter


Manhim Garoun Investment Bank Gallente Federation Likes received: 4	#100 - 2014-03-10 22:05:17 UTC North American mirror updated: http://cyanventures.org/dumps/

First pagePrevious page3456Next page

EVE Technology Lab

Fuzzwork Enterprises

Vote Steve Ronuken for CSM

Doomheim

Aliastra

Gallente Federation

The Scope

Gallente Federation

Garoun Investment Bank

Gallente Federation