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.
 

Rubicon SDE is out.

First post
Author
Previous Topic Next Topic
Evanova Android
Traquenard Labs
#21 - 2013-11-19 23:42:31 UTC
Rob Crowley wrote:
Evanova Android wrote:
The iconIDs.yaml file is illformed. There are "iconFile" entries that don't have single quotes (') around them, causing some parsers to think there are doubles instead of strings.
The quotes should be there if only for consistency's sake. But AFAICS all of those instances contain a "_", so it's really on the parsers if they can't tell it's a string.


Yes, and that's the problem, consistency. Either they all have quotes or they don't...Either way but one way only is consistency.

Evanova - The Android App for Eve Online
Golden Gnu
Lobach Inc.
#22 - 2013-11-20 12:34:56 UTC
@Steve Ronuken
Thank you for the MySQL conversion Big smile

Creator of jEveAssets - the asset manager

"Download is the meaning of life, upload is the meaning of intelligent life"
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#23 - 2013-11-21 12:08:50 UTC
update invTypes set volume=200 where typeid=33400;

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#24 - 2013-11-21 16:18:47 UTC
Spc One
The Chodak
Void Alliance
#25 - 2013-11-25 16:05:27 UTC  |  Edited by: Spc One
Gaius Henry
The Scope
Gallente Federation
#26 - 2013-11-25 17:05:59 UTC
CCP Prism X wrote:
Why do you guys still do your dumps in MSSQL?! Nobody uses that bleep except you! Come join the NoSQL Revolution already! Evil


NoSQL usually refers to non-relational databases. But this dump _is_ relational (boys, if it's relational!). Also NoSQL databases usually don't handle big data very well.

I'd go with MySQL/PostgreSQL/whatever runnable on Linux at least.

Usually unofficial MySQL dumps lack of foreign keys.
Aineko Macx
#27 - 2013-11-27 11:00:15 UTC
Gaius Henry wrote:
Also NoSQL databases usually don't handle big data very well.

Citation needed.
Quote:
Usually unofficial MySQL dumps lack of foreign keys.

I put together some ALTER TABLE commands to add them a while back. It's based on Crucible 1.1 so might need adaptation: http://pastebin.com/5dS84J8X

iveeCore 3.0: The PHP engine for industrial activities and CREST library
CCP Creber Cattus
C C P
C C P Alliance
#28 - 2013-11-29 16:30:45 UTC
Updated version of the SDE is now available. Rubicon 1.0.4

Get it here
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#29 - 2013-11-29 18:09:58 UTC
Rob Crowley
State War Academy
#30 - 2013-11-29 18:53:09 UTC
CCP Creber Cattus wrote:
Updated version of the SDE is now available. Rubicon 1.0.4

Cool. CCP Creber Cattus best Cattus! Btw, did you misspell Creeper Cactus?

Though you can all thank me for doing some of the SDE fixes manually yesterday. I knew that would bring us an updated SDE within 24 hours.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#31 - 2013-11-29 20:16:22 UTC
oops, missed the certMasteries table.

updated the release. if you already have it, you just need certMasteries.sql.bz2

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Captain Thunk
Explode. Now. Please.
Alliance. Now. Please.
#32 - 2013-11-30 01:23:56 UTC
Haven't checked V1.04 but V1.0 didn't have extra dgmAttribute data concerning the mobile siphons - things like the ranges.
CCP Creber Cattus
C C P
C C P Alliance
#33 - 2013-11-30 01:54:53 UTC
Rob Crowley wrote:

Cool. CCP Creber Cattus best Cattus! Btw, did you misspell Creeper Cactus?

No, correctly spelled... it's actually Latin Blink

Captain Thunk wrote:
Haven't checked V1.04 but V1.0 didn't have extra dgmAttribute data concerning the mobile siphons - things like the ranges.

I'm at home now... might remember to check for you after the weekend if it is stored in dgmAttributes or if it is somewhere else. No promises though as I might forget.
Golden Gnu
Lobach Inc.
#34 - 2013-12-03 11:19:26 UTC
@CCP Creber Cattus
Fat Cat Lol

Creator of jEveAssets - the asset manager

"Download is the meaning of life, upload is the meaning of intelligent life"
Leviticus Payne Thuel
Deep Core Mining Inc.
Caldari State
#35 - 2013-12-03 13:32:57 UTC
Spc One wrote:
All Items & ID's:

http://www.netsky.org/db_rubicon1.0by_Spc_One.txt



All Items & ID's with description:

http://www.netsky.org/db_rubicon1.0Desc_by_Spc_One.txt

Smile



Is there any way to have the items only available in the market put into a text or xls file? I cannot get the sql stuff to work on my machine.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#36 - 2013-12-03 13:37:35 UTC
Leviticus Payne Thuel wrote:
Spc One wrote:
All Items & ID's:

http://www.netsky.org/db_rubicon1.0by_Spc_One.txt



All Items & ID's with description:

http://www.netsky.org/db_rubicon1.0Desc_by_Spc_One.txt

Smile



Is there any way to have the items only available in the market put into a text or xls file? I cannot get the sql stuff to work on my machine.



Grab the invTypes.xls.bz2 file from my site, unzip it with 7zip.

Then you want just the stuff on the market, look for everything with an entry in the marketgroupid column.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Leviticus Payne Thuel
Deep Core Mining Inc.
Caldari State
#37 - 2013-12-03 17:41:20 UTC
Thank you so much, this really helps me out. +1 for you my good sir. Big smile
Leviticus Payne Thuel
Deep Core Mining Inc.
Caldari State
#38 - 2013-12-03 18:49:05 UTC
On a second note I am curious if there is a simple way to import multiple typeids, such as all the ore types for example, and see 5 different values from each xml item:

max buy, avg buy, min sell, avg sell, volume all.

So I would have a simple layout of items on the left and the 5 values for each item to the right.

I can do this using a single API key for each item but that's 7000+ items in the market.

So do I need a single API key for each item to see those 5 results for each or can I write a VBA code that looks at all 7000 items and pulls the data from each individual xml?


thanks in advance to anyone who knows this solution.
iwannadig
Doomheim
#39 - 2013-12-04 05:34:16 UTC
How to get such database, but for Dust 514?
Rob Crowley
State War Academy
#40 - 2013-12-04 08:23:36 UTC
iwannadig wrote:
How to get such database, but for Dust 514?
Well, some Dust stuff is in the SDE, e.g. there are some items in the invTypes table. There are also Dust icons in the toolkit. One thing that seems to be missing so far is catma attributes of the items. I don't think those were made available by CCP yet.