EVE Search - Sticky:Rubicon SDE is out.

All Channels

EVE Technology Lab

Sticky:Rubicon SDE is out.

» Click here to find additional results for this topic using Google

Monitor this thread via RSS [?]

Pages: 1 2 3 [4] :: one page
Author	Thread Statistics \| Show CCP posts - 6 post(s)
Celebrain 1st Steps Academy Fidelas Constans 0	Posted - 2014.02.26 18:59:00 - [91] - Quote 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 EVE University Ivy League 0	Posted - 2014.02.26 22:04:00 - [92] - Quote 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 2734	Posted - 2014.02.26 22:27:00 - [93] - Quote Juderet Belmar wrote: 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. Ahh, I'll update it for next time. 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) Steve Ronuken for CSM 9! https://forums.eveonline.com/default.aspx?g=posts&m=4236322 http://www.fuzzwork.co.uk/ Twitter: @fuzzysteve on Twitter
Manhim Cyan Ventures The Serenity Initiative 4	Posted - 2014.03.06 23:57:00 - [94] - Quote 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 2783	Posted - 2014.03.07 00:03:00 - [95] - Quote 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) Steve Ronuken for CSM 9! https://forums.eveonline.com/default.aspx?g=posts&m=4236322 http://www.fuzzwork.co.uk/ Twitter: @fuzzysteve on Twitter
Desmont McCallock 367	Posted - 2014.03.08 16:26:00 - [96] - Quote Looks like Rubicon 1.3 SDE is going to be late.
Darkblad Hilfe is like Free Entertainment 118	Posted - 2014.03.08 19:36:00 - [97] - Quote Appears so. But they're also still dropping some minor patches. I'm currently getting build 737539 by the launcher. EVE Infolinks -+-áOld and new-áPortraits
Darkblad Hilfe is like Free Entertainment 123	Posted - 2014.03.10 18:36:00 - [98] - Quote there we go http://cdn1.eveonline.com/data/Rubicon_1.3_95173_db.zip EVE Infolinks -+-áOld and new-áPortraits
Steve Ronuken Fuzzwork Enterprises Vote Steve Ronuken for CSM 2813	Posted - 2014.03.10 20:47:00 - [99] - Quote 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/ Steve Ronuken for CSM 9! https://forums.eveonline.com/default.aspx?g=posts&m=4236322 http://www.fuzzwork.co.uk/ Twitter: @fuzzysteve on Twitter
Manhim Cyan Ventures The Serenity Initiative 4	Posted - 2014.03.10 22:05:00 - [100] - Quote North American mirror updated: http://cyanventures.org/dumps/
Ydnari Estrale Frontiers Project Wildfire 309	Posted - 2014.03.10 22:37:00 - [101] - Quote Steve Ronuken wrote: 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/ Any chance you could make mapDenormalize.itemName a VARCHAR column again? Can't add an index on it when it's LONGTEXT (without faffing around making it a prefix index or something). Thanks as always for the conversions into a usable format --
Steve Ronuken Fuzzwork Enterprises Vote Steve Ronuken for CSM 2813	Posted - 2014.03.10 22:47:00 - [102] - Quote Ydnari wrote: Steve Ronuken wrote: 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/ Any chance you could make mapDenormalize.itemName a VARCHAR column again? Can't add an index on it when it's LONGTEXT (without faffing around making it a prefix index or something). Thanks as always for the conversions into a usable format alter table mapDenormalize change itemName itemName varchar(80); Took 21 seconds. https://www.fuzzwork.co.uk/dump/rubicon-1.3-95173/mapDenormalize-varcharname.sql.bz2 Steve Ronuken for CSM 9! https://forums.eveonline.com/default.aspx?g=posts&m=4236322 http://www.fuzzwork.co.uk/ Twitter: @fuzzysteve on Twitter
Ydnari Estrale Frontiers Project Wildfire 309	Posted - 2014.03.10 23:03:00 - [103] - Quote Yep I changed it locally already, was wondering if you would change it as part of the conversion process for future dumps? Ta. (Otherwise I'll just bung it into my post-processing scripts). --
Juderet Belmar EVE University Ivy League 0	Posted - 2014.03.10 23:05:00 - [104] - Quote Steve Ronuken wrote: Juderet Belmar wrote: 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. Ahh, I'll update it for next time. Ah, you lied ... I am sure you will fix it next time Something else: Further above in the thread someone asked about the missing attributes for the new deployables like the Mobile Depot. Is this a bug or intended, also where to get the data if not from dgmattributetypes?
Steve Ronuken Fuzzwork Enterprises Vote Steve Ronuken for CSM 2813	Posted - 2014.03.10 23:30:00 - [105] - Quote Juderet Belmar wrote: Steve Ronuken wrote: Juderet Belmar wrote: 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. Ahh, I'll update it for next time. Ah, you lied ... I am sure you will fix it next time Something else: Further above in the thread someone asked about the missing attributes for the new deployables like the Mobile Depot. Is this a bug or intended, also where to get the data if not from dgmattributetypes? oop https://www.fuzzwork.co.uk/dump/rubicon-1.3-95173/invTraits.sql.bz2 I've updated the loader. Steve Ronuken for CSM 9! https://forums.eveonline.com/default.aspx?g=posts&m=4236322 http://www.fuzzwork.co.uk/ Twitter: @fuzzysteve on Twitter
Juderet Belmar EVE University Ivy League 0	Posted - 2014.03.10 23:51:00 - [106] - Quote Steve Ronuken wrote: Juderet Belmar wrote: Steve Ronuken wrote: Juderet Belmar wrote: 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. Ahh, I'll update it for next time. Ah, you lied ... I am sure you will fix it next time Something else: Further above in the thread someone asked about the missing attributes for the new deployables like the Mobile Depot. Is this a bug or intended, also where to get the data if not from dgmattributetypes? oop https://www.fuzzwork.co.uk/dump/rubicon-1.3-95173/invTraits.sql.bz2 I've updated the loader. I suspect the missing attributes are because they manually pick the ones which get exported. Great, that was fast and the traits now show up correctly ... maybe I should vote for you Just my thoughts on the quality of the dump db: The more I work on my tool with the dump db the more I must sigh about all the inconsistencies and complicated / unintuitive designs, tons of unused data can be found next to incomplete data and so on... but better a bad data dump than none
Desmont McCallock 374	Posted - 2014.03.13 19:28:00 - [107] - Quote tl;dr Pilot's License Extensions (PLEX) market group is missing from SDE. Reporting inconsistency in data for SDE Rubicon 1.3. Plex item (ID: 29668) is set with marketGroupID: 1923 but there is no such ID in invMarketGroups. Summoning CCP Creber Cattus or CCP Prism X...
Meat Ongrard The Irukandji Ineluctable. 0	Posted - 2014.03.14 22:35:00 - [108] - Quote Steve Ronuken wrote: https://www.fuzzwork.co.uk/dump/rubicon-1.0-93082/ https://www.fuzzwork.co.uk/dump/sqlite-latest.sqlite.bz2 (look ma! It's a symlink I'll try to keep pointing at the latest version!) https://www.fuzzwork.co.uk/dump/mysql56-rubicon-1.0-93082.tar.bz2 https://www.fuzzwork.co.uk/dump/rubicon-1.0-93082/postgres-rubicon-1.0-93082.sql.bz2 (floats converted to numerics) Next time, lets just start the thread with this post
Desmont McCallock 375	Posted - 2014.03.15 10:09:00 - [109] - Quote For your own sanity just run this query and your SDE will be whole again. insert invMarketGroups values (1923,Null,'Pilot''s License Extensions (PLEX)', 'Special ISK-priced capsuleering licenses offered as an alternative to regular piloting contracts.', Null, 1)
Desmont McCallock 381	Posted - 2014.05.17 14:18:00 - [110] - Quote Beware Rubicon 1.4 SDE is still missing the marketGroup entry for the PLEX.
Ydnari Estrale Frontiers Project Wildfire 331	Posted - 2014.05.30 13:35:00 - [111] - Quote Kronos SDE is up: http://content.eveonline.com/data/Kronos_1.0_98431_db.zip my teapot is ready

Pages: 1 2 3 [4] :: one page
First page \| Previous page \| Next page \| Last page

COPYRIGHT NOTICE
EVE Online, the EVE logo, EVE and all associated logos and designs are the intellectual property of CCP hf. All artwork, screenshots, characters, vehicles, storylines, world facts or other recognizable features of the intellectual property relating to these trademarks are likewise the intellectual property of CCP hf. EVE Online and the EVE logo are the registered trademarks of CCP hf. All rights are reserved worldwide. All other trademarks are the property of their respective owners. CCP hf. has granted permission to EVE-Search.com to use EVE Online and all associated logos and designs for promotional and information purposes on its website but does not endorse, and is not in any way affiliated with, EVE-Search.com. CCP is in no way responsible for the content on or functioning of this website, nor can it be liable for any damage arising from the use of this website.