|
|
| Author |
Thread Statistics | Show CCP posts - 9 post(s) |
|
CCP Taera
   |
Posted - 2008.07.30 14:29:00 -
[1]
The new Data Export has arrived, and its creator Prism X explains the process, implementation, and future of this powerful tool. Check out the blog here, or head straight to our Community area to download the Export.
Taera
Associate Community Manager
CCP Hf, EVE Online
Email |
|
|
CCP Taera
|
Posted - 2008.07.30 15:09:00 -
[2]
 Originally by: Red Panda
error in the link to MSSQL :
http://www.microsoft.com/sql/editions/express</a
link here : http://www.microsoft.com/sql/editions/express
Fixed!
Taera
Associate Community Manager
CCP Hf, EVE Online
Email |
|
|
CCP t20
|
Posted - 2008.07.30 15:15:00 -
[3]
ebs_DATADUMP.sql temporarily here.
|
|
|
CCP Prism X
Gallente
C C P
|
Posted - 2008.07.31 10:54:00 -
[4]
Oh my me, we're still on page one. I must be slipping. At least I managed to include the good old OS wars discussion in this blog. 
Anyways, I'm really sorry about those 404's there. I'm on vacation right now and wrote this up before leaving a couple of weeks ago. I'll be back in 100% capacity come next week and will find some opportunity to reply to other questions in here at that time. But there are two questions I'd like to answer now.
Why is crpNPCCorporationTrades missing?
Well, it should really never have been included. This is basicaly meta-data and could allow people to get an advantage they couldn't otherwise get in game. Something like finding out what is being sold in regions they've never been in would be a good example. Finding the best possible trade routes through some datamining would be another. 
I'm sorry if the mismatch has wasted anyones time.
Why are you forcing me to use MS products!
We're not really. Obviously some format had to be used and it has pros and cons for anyone involved. Using the same environment as our internal development environment makes everything very easy to maintain as well as offering us a very robust procedure to get this out with our expansions. My original idea was to include a non-official export as well but it became apparent that the robustness would suffer. If this format doesn't cut it for you in any way you can at least be glad that this data will now be released with expansions (I imagine it will be held back until we're sure we don't need to hotfix any live static data) and that still means you'll get your export from third parties a whole lot faster than.. a year.
I see it as a win for everyone involved although people with no access to MS platforms might have to wait a tad longer than others. That being said I'd erally rather want to discuss the export and it's uses rather than go into the oldest discussion in the industry.
Take care, I'll drop by after the weekend, if not sooner.
~ Prism X
EvE Database Developer
Relocating your character to a cozy, secure container since 2006.
Relocating your cozy, secure container to the EVE cemetery since 2008. |
|
|
CCP Prism X
Gallente
C C P
|
Posted - 2008.07.31 16:54:00 -
[5]
And in turn I can see where you are coming from but I don't agree with any imbalance between new and old players. The old dump is still out there and easy to find for anyone with an incentive. Obviously that statement is counter-productive to my original one but we don't keep on doing things just because there's a precedence for doing them. Especially not when we think they shouldn't be done.
Besides, EVE is an MMO. We nerf stuff in MMOs. Even data exports. C'mon, I don't get to nerf that much in my position here.
As to a true/false values, that might happen. I'll try and jot it down on my notebook when I get to work and bring it up when the time is right, before the next export.
~ Prism X
EvE Database Developer
Relocating your character to a cozy, secure container since 2006.
Relocating your cozy, secure container to the EVE cemetery since 2008. |
|
|
CCP Prism X
Gallente
C C P
|
Posted - 2008.08.05 16:30:00 -
[6]
I believe the units are accessible through ing-game celestial info as well as in eveUnits. I'm not at work though so I can't confirm it (and this is a fairly fresh machine so I can't VPN) and honestly I don't think I've ever given it any real thought
~ Prism X
EvE Database Developer
Relocating your character to a cozy, secure container since 2006.
Relocating your cozy, secure container to the EVE cemetery since 2008. |
|
|
CCP Explorer
|
Posted - 2008.09.04 22:52:00 -
[7]
Originally by: Buildius Maximus
And where is the new updated export now that we have had a major patch?
See here.
Erlendur S. Thorsteinsson
Software Director
EVE Online, CCP Games |
|
|
CCP Prism X
Gallente
C C P
|
Posted - 2008.09.05 15:47:00 -
[8]
I seem to managed to give you an empty invControlTowerResourcePurposes again.
Apologies for that. I believe a new dump will go up soon with that included but if you are impatient here are the inserts in T-SQL:
INSERT INTO invControlTowerResourcePurposes VALUES (1,'Online')
INSERT INTO invControlTowerResourcePurposes VALUES (2,'Power')
INSERT INTO invControlTowerResourcePurposes VALUES (3,'CPU')
As to the format:
We can go over this ad infinitum. Some people prefer this, others prefer that.
I'm not saying we'll never include any other format, I'm just saying that's not a priority and I'm not promising anything. I understand that some people have issues with using MS formats just like I have issues with MySQL pre-5.0 and everyone has their preference for anything.
At least we're releasing them when we know the static data of every expansion is stable. That must account for something, no? |
|
|
CCP Fallout
|
Posted - 2008.12.01 19:16:00 -
[9]
Originally by: Cpt Bunny
hi guys,
im working on a little market app, its a ms access DB, but im having problems getting the raw sql data imported, i dont know that much about sql tbh,
would anyone be able to help me aout with csv or even an access version of the raw data ?
would be happy to provide them with versions of my system once its running.
thanks in advace
Your best bet is to make an inquiry in our Tech Lab channel, if you've not yet done so.
Fallout
Associate Community Manager
CCP Hf, EVE Online
|
|
|
|
| |
|