EVE Search - New Dev Blog: The Return of the Data Export

Check My IP Information

All Channels

EVE Information Portal

New Dev Blog: The Return of the Data Export

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

Monitor this thread via RSS [?]

Pages: 1 2 3 :: [one page]

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

Vessper Indicium Technologies	Posted - 2008.07.30 14:43:00 - [2] \o/ Thanks guys - - - EveHQ Character App \| Item Database
Red Panda VMF-214 Blacksheep	Posted - 2008.07.30 14:51:00 - [3] error in the link to MSSQL : http://www.microsoft.com/sql/editions/express</a link here : http://www.microsoft.com/sql/editions/express --------- Red Panda --------- ()_() ( '_') (")(") I need Bamboo !!
Salvis Tallan Gallente The Shadow Order Vanguard.	Posted - 2008.07.30 14:55:00 - [4] rabble rabble rabble!!! Thanks for getting it to us. More types of fiels beyond the MSSQL backup file will be done soon, keep checking the page and also http://wiki.eve-id.net ------

CCP Taera	Posted - 2008.07.30 15:09:00 - [5] 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

Dal Rath	Posted - 2008.07.30 15:12:00 - [6] Quote: Along with the backup itself you will get a .SQL file called ebs_DATADUMP.sql cough404cough

CCP t20	Posted - 2008.07.30 15:15:00 - [7] ebs_DATADUMP.sql temporarily here.

Cesar Malari Gunfleet Logistics	Posted - 2008.07.30 16:10:00 - [8] Quote: Removal of table crpNPCCorporationTrades. Can someone at CCP say why this was done? I was just in the process of putting the finishing touches on a tool that used this table from the trinity data dump to find the closest place that sold a given NPC-supplied item (skillbooks, T1 BPOs, POS parts), even if it wasn't in my region. It was very helpful in helping me find where some POS parts were being sold.
Meissa Anunthiel	Posted - 2008.07.30 16:11:00 - [9] Anyone knows how to get the T2 BPC produced when using invention on T1 BPOs? I can't seem to find that information in the dump (there's a workaround with joining invBlueprintTypes and invTypes and checking techlevel 1 or 2, but that doesn't work for ammo)
Cesar Malari Gunfleet Logistics	Posted - 2008.07.30 16:27:00 - [10] Originally by: Meissa Anunthiel Anyone knows how to get the T2 BPC produced when using invention on T1 BPOs? I can't seem to find that information in the dump (there's a workaround with joining invBlueprintTypes and invTypes and checking techlevel 1 or 2, but that doesn't work for ammo) From the T1 BPC, get the item produced by it (invBluePrintTypes.productTypeID), then find the T2 item(s) by looking in invMetaTypes.typeID where metaGroupID=2 and parentTypeID=the T1 item typeid. Match the T2 item id to invBluePrintTypes.productTypeID, giving you the BP's item ID as blueprintTypeID. Example for Null L: select * from invTypes where typename='Thorium Charge L Blueprint' select * from invBlueprintTypes where blueprintTypeID=1150 select * from invMetaTypes where parentTypeID=235 and metaGroupID=2 select * from invBlueprintTypes where productTypeID=12787 select * from invTypes where typeid=12788

Nekopyat	Posted - 2008.07.30 16:57:00 - [11] Cool ^_^ I was just wondering what it took to get a data dump so I could fiddle around with a utility app. Though one question (less at the devs and more at others), can anyone suggest a quick way to get this data OUT of MSSQL without having to grab a copy from microsoft?
Chruker	Posted - 2008.07.30 17:04:00 - [12] congratulations of making such a bad choice on how to provide the dataexport \o/ seriously? just some bloody binary backup files that you cant do f.... with without havign a program installed on windows At least the previous sql files could easily be morphed/read/transformed... jezz ----- http://games.chruker.dk/eve_online ----- Top wishes: - No daily downtime - Faster training on sisi - Speedup IGB table rendering
Cesar Malari Gunfleet Logistics	Posted - 2008.07.30 17:07:00 - [13] Originally by: Nekopyat Though one question (less at the devs and more at others), can anyone suggest a quick way to get this data OUT of MSSQL without having to grab a copy from microsoft? Be patient. Within a day or so, someone will have exported the data to a SQL script for MySQL, CSV files, and probably even an Access file and posted links to either this thread, or some one in "EVE Technology Lab" forum. They won't be "official" of course, but someone will probably do it if you can't be bothered to install SQL Server Express yourself. If noone does a MySQL one by this weekend, I'll probably throw one together.
Kale Hirshel	Posted - 2008.07.30 17:18:00 - [14] Thank you so much.
Dronte Minmatar Quam Singulari	Posted - 2008.07.30 18:35:00 - [15] You can find SQL versions of the dumps on zofu's site: http://eve.no-ip.de/ea10/
Shar'ri Atal	Posted - 2008.07.30 19:32:00 - [16] Oh great, so now we require Windows and we require MSSQL. Why not just script the thing into two plain text files, one for the schema and one for the data in pure SQL commands. While you're at it put comments in there to flag any of the non-ANSI-SQL data types that MSSQL uses so we can process the thing into something sensible. MSSQL Express is annoyingly limited. Where as PostgreSQL for example isn't and is also free. If that's overkill then what about something that can be used by SQLite libraries. It's cross platform and can be linked into anything. EVE might be tied into Microsoft's monstrosity of a database but it doesn't mean that everyone else wants to be.
iulixxi EVE-RO	Posted - 2008.07.30 19:47:00 - [17] Will we have a data_map icons any time soon ? Iuli
Meissa Anunthiel	Posted - 2008.07.30 19:48:00 - [18] Edited by: Meissa Anunthiel on 30/07/2008 19:49:41 Originally by: Chruker congratulations of making such a bad choice on how to provide the dataexport \o/ seriously? just some bloody binary backup files that you cant do f.... with without havign a program installed on windows At least the previous sql files could easily be morphed/read/transformed... jezz I, on the other hand, thank them very much for making a 1+ hour operation with previous exports (inconsistencies, missing definitions, NULL data in non nullable fields, files to large for the desktop edition to work, etc.) now take 1 minute tops. In the unlikely event the gamer you are doesn't also have a windows installation to put the free version of SQL server to do an SQL export yourself, you'll have to wait, what? 2 days for others to post exports? [Edit: actually they're already available as of 1 hour ago, see OP...] Jeez
Burchov Lyrus Associates	Posted - 2008.07.30 19:51:00 - [19] Originally by: Shar'ri Atal Oh great, so now we require Windows and we require MSSQL. Why not just script the thing into two plain text files, one for the schema and one for the data in pure SQL commands. While you're at it put comments in there to flag any of the non-ANSI-SQL data types that MSSQL uses so we can process the thing into something sensible. MSSQL Express is annoyingly limited. Where as PostgreSQL for example isn't and is also free. If that's overkill then what about something that can be used by SQLite libraries. It's cross platform and can be linked into anything. EVE might be tied into Microsoft's monstrosity of a database but it doesn't mean that everyone else wants to be. This. While I'm very happy that the new database dump is finally released, it is extremely... annoying that it was done in this way instead of f.e. the sql files like the previous dumps. ________ Invention profit calculator
Ambo Dirty Deeds Corp. Axiom Empire	Posted - 2008.07.30 21:32:00 - [20] Edited by: Ambo on 30/07/2008 21:32:59 Originally by: Meissa Anunthiel Edited by: Meissa Anunthiel on 30/07/2008 19:49:41 Originally by: Chruker congratulations of making such a bad choice on how to provide the dataexport \o/ seriously? just some bloody binary backup files that you cant do f.... with without havign a program installed on windows At least the previous sql files could easily be morphed/read/transformed... jezz I, on the other hand, thank them very much for making a 1+ hour operation with previous exports (inconsistencies, missing definitions, NULL data in non nullable fields, files to large for the desktop edition to work, etc.) now take 1 minute tops. In the unlikely event the gamer you are doesn't also have a windows installation to put the free version of SQL server to do an SQL export yourself, you'll have to wait, what? 2 days for others to post exports? [Edit: actually they're already available as of 1 hour ago, see OP...] Jeez Agreed, the new format is much easier for me. Thank you. -------------------------------------- Trader? Investor? Just want to track your finances? Check out EMMA

Kayn Otar	Posted - 2008.07.30 22:25:00 - [21] I love that CCP makes this data available. A thousand-times thank you. But something doesn't smell right. If this is being done to promote the development of independent tools, then why are the data exports in a proprietary format? The SQL files could, at least, be converted to other formats. Thank goodness for the Eve Development Network!
Azia Burgi Caldari Science and Trade Institute	Posted - 2008.07.30 22:37:00 - [22] YAY! no more sleep for me for the next few days as I try to figure this mammoth out. I nominate CCP Prism X for God. Azia Burgi http://azia.geekandproud.co.uk BP Profit Calculator EVE Cemetery
Batolemaeus Caldari Free-Space-Ranger Morsus Mihi	Posted - 2008.07.30 22:40:00 - [23] Originally by: Azia Burgi I nominate CCP Prism X for God. Too late, he already won that title.
Chruker	Posted - 2008.07.30 23:35:00 - [24] Originally by: Batolemaeus Originally by: Azia Burgi I nominate CCP Prism X for God. Too late, he already won that title. nah, not since they decided to distribute binary files... ----- http://games.chruker.dk/eve_online ----- Top wishes: - No daily downtime - Faster training on sisi - Speedup IGB table rendering
Batolemaeus Caldari Free-Space-Ranger Morsus Mihi	Posted - 2008.07.31 01:13:00 - [25] Originally by: Chruker nah, not since they decided to distribute binary files... pushes Chruker into the Pit™
Eina Shadowlancer Jovian Labs Jovian Enterprises	Posted - 2008.07.31 08:26:00 - [26] Hugs for Prism X and bunjiboy(s?)
Garia666 Amarr T.H.U.G L.I.F.E White Core	Posted - 2008.07.31 08:28:00 - [27] I think its very cool of CCP to give such info to the community.. thanks ccp.. www.garia.net

CCP Prism X Gallente C C P	Posted - 2008.07.31 10:54:00 - [28] 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.

Gilgamoth Eldritch Storm The Matari Consortium	Posted - 2008.07.31 12:24:00 - [29] Thanks for all the hard work Prism X. Anything is better than nothing Regards, Gil Live on Eden Underground Radio every Wednesday 19:00 - 21:00 GMT.
Cesar Malari Gunfleet Logistics	Posted - 2008.07.31 14:12:00 - [30] Originally by: CCP Prism X 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. Well, I don't think it could help find "best possible trade routes", as it doesn't have the day-to-day pricing fluxuations, but I can see why you might be concerned. Any thoughts on adding something to the item database that at least uses that data to list the companies that sell a particular item? Sometimes when you're building a POS or need a specific skill, it's hard to remember where it is you have to go to pick it up. At least knowing a corp name, we could use existing tools.

Matalino Gallente Ki Tech Industries	Posted - 2008.07.31 16:15:00 - [31] Originally by: CCP Prism X 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. I can understand some of what you are saying, but as a counter point we have long past the point were NPC sales are in anyway secret, with resources such as Eve Central and the Item Database. (unless you are planning to remove it from there too?) Removing that table from the current official data dump only provides an advantage to those more experienced with the NPC market and Data Dumps, who know to go to the the previous data dumps and how to update that information. If you insist on providing such an advantage to us veterns, I guess we will need to accept it, but I think that it would be better for newer players and developers if you returned it to the official data dump, even if you flattened the supplyDemand field to contain a true/false value instead of the previous range of values that might be mined for additional information.

CCP Prism X Gallente C C P	Posted - 2008.07.31 16:54:00 - [32] 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.

Matalino Gallente Ki Tech Industries	Posted - 2008.07.31 17:27:00 - [33] Originally by: CCP Prism X 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. But we love you because you don't nerf stuff, only boost it. Originally by: CCP Prism X 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. Thank you for giving it another thought.
Alvara Kuiper Belt Industries	Posted - 2008.07.31 18:18:00 - [34] Personally I struggled with the previous dumps and usually gave up long before I compiled them myself. Now a sql backup file I'll have up and doing queries against it in 5 min or less. So thank you very much. Now back to Application Verifier logs while I try and get my work at work vista certified. Tired of Waiting to do research? Use Empire Research
Azazel Mordred Minmatar Cloak of Shadows	Posted - 2008.07.31 18:42:00 - [35] As an aside - the table "ramCompletedStatuses" seems to be missing.
Dal Rath	Posted - 2008.07.31 19:19:00 - [36] Quote: EVElopedia ... will, among other things, include a new and improved Item Database. ...which probably explains why nobody at CCP has bothered to update the existing Item Database yet... Whilst waiting for EVElopedia, which is coming SOON(tm), you can enjoy the Empyrian Age Item Database here NOW(tm)
Lord Fitz Project Amargosa	Posted - 2008.07.31 19:24:00 - [37] While I managed with the old format, the new one is a heap easier for me, but then MSSQL is my preferred format anyway. Like before it won't be too long before you find it in any format you like I imagine.
Epitrope The Citadel Manufacturing and Trade Corporation	Posted - 2008.07.31 23:49:00 - [38] First off, thanks to you and t20 for the updated export! As for crpNPCCorporationTrades: Originally by: CCP Prism X Something like finding out what is being sold in regions they've never been in would be a good example. This information is available in game by looking at the trade tab of an NPC corporation's info window. It's tedious and inconvenient, and I have certainly made the argument in the past that hard things tend not to be done, but I would say it isn't secret information (although the supplyDemand column was). (Plus, as Matalino mentioned, the E-O Item Database has it in a slightly less inconvenient form.) Originally by: CCP Prism X 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. I for one would be happy with just the sell orders. Right now I use the Trinity version of the crpNPCCorporationTrades table by just selecting corporationID, typeID where supplyDemand > 0. Prefiltering the exported table like that would avoid showing even the possibility of trade routes (which would have to be double-checked anyway because of the aforementioned price fluctuation).
Kojebo	Posted - 2008.08.01 01:02:00 - [39] What's the 'technical reason' for not implementing foreign keys?
Chruker	Posted - 2008.08.01 08:14:00 - [40] The invControlTowerResourcePurposes table is empty ----- http://games.chruker.dk/eve_online ----- Top wishes: - No daily downtime - Faster training on sisi - Speedup IGB table rendering

BigWhale Gallente Three WiseMen Association	Posted - 2008.08.01 10:26:00 - [41] One question, is MS SQL unable to produce an ANSI SQL text dump? Now, I'll have to rely to 3rd party to get a data dump or buy Windows license. :( I, for one, _don't_ welcome our proprietary data dump overlords... :( -- R, U & Y are letters, not words...
iulixxi Dracula Order Hydra Alliance	Posted - 2008.08.01 10:43:00 - [42] Edited by: iulixxi on 01/08/2008 10:45:34 MDB version here (36.9 M) Iulian
Dronte Minmatar Quam Singulari	Posted - 2008.08.01 12:44:00 - [43] Jeeeesus christ, stop whining about the format already!. Its not like you had to wait long, the community had released the first ANSI SQL, MySQL, PSQL etc. version without 2 hours!! of the initial release, and posted links to them, both in this thread and in the various threads on the tech lab forum and on #eve-dev on IRC. So all this really just sounds to me like you are just whining, for the sake of whining. I doubt any of you would have had any problem if it was released in .sql files even though you couldnt have used them for one reason or the other (historicly, the official CCP dumps didnt import without modifications into MySQL fx.) and therefor there has always been community adaptations of the data dumps that users has had no problems with. So please just stop whining, and be happy that CCP has managed to find a way, where we dont have to wait half a year on updated data dumps, but only a few hours till the first conversions hit the community scene. This stinks of being the standard "We oh so hate the Microsoft"
Chruker	Posted - 2008.08.01 14:06:00 - [44] Originally by: Dronte Jeeeesus christ, stop whining about the format already!. Its not like you had to wait long, the community had released the first ANSI SQL, MySQL, PSQL etc. version without 2 hours!! of the initial release, and posted links to them, both in this thread and in the various threads on the tech lab forum and on #eve-dev on IRC. For me it is more the matter of there being a 3rd party involved (mostly what differencies that might appear between different conversions) Originally by: Dronte I doubt any of you would have had any problem if it was released in .sql files even though you couldnt have used them for one reason or the other (historicly, the official CCP dumps didnt import without modifications into MySQL fx.) and therefor there has always been community adaptations of the data dumps that users has had no problems with. But at least the .sql files could be edited with simple search-n-replace to the point where your database engine of choice could digest them. You try doing that with the .bak crap Originally by: Dronte So please just stop whining, and be happy that CCP has managed to find a way, where we dont have to wait half a year on updated data dumps, but only a few hours till the first conversions hit the community scene. Right, I'll believe that when I see it. They still have to assign somebody during the launch and I think that is the biggest issue. And dont come here with some crap about this smells like a oh-microsoft-stinks. The issue is that they decided to go with a binary file that cant be as easily converted to something usefull as the .sql files could. So its a step in the wrong direction! The right step would have been to strive to provide something that would be directly importable by most database engine (be it standardized sql, csv, xml or similar). FInally, I really wonder how much work they did on this 'procedure to export'. It just looks tooo similar to the old schema with the issues it has. I had hoped they would have normalized the data and also split the typeActivityMAterial table up into the ramTypeMAterials and ramTypeRequirements ----- http://games.chruker.dk/eve_online ----- Top wishes: - No daily downtime - Faster training on sisi - Speedup IGB table rendering
Jesho Minmatar Swedish Aerospace Inc	Posted - 2008.08.01 14:25:00 - [45] Originally by: CCP Prism X 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. You can already get the same type of data from the Item database at eve-online.com all you have to do is to find the item your looking for and then go to the NPC tab, there you have the npc corps that sell this item. when you know the corp that sells the item it's easy to find out where those corps have station(s).
Cesar Malari Gunfleet Logistics	Posted - 2008.08.01 14:42:00 - [46] Originally by: Kojebo What's the 'technical reason' for not implementing foreign keys? If I had to guess, it's not so much a "technical" reason as a "performance" reason. If you have the FKs on there, they are checked for each insert/update, which takes time. In case you hadn't noticed, database performance is a giant issue for this game, so they likely don't have FKs on the live database. Now, as to why they don't add them to the export, well, that one I can't think of a reason for, other than that they don't want to bother doing it. Remember -- they're trying to get a nice, easy, repeatable process for themselves here....
Cesar Malari Gunfleet Logistics	Posted - 2008.08.01 14:44:00 - [47] Edited by: Cesar Malari on 01/08/2008 14:44:56 Originally by: BigWhale One question, is MS SQL unable to produce an ANSI SQL text dump? Natively? No. SQL Server doesn't ship with a tool like mysqldump. However, there is such a tool available -- the Database Publishing Wizard. Point it at a DB and it builds SQL scripts for the schema and/or data. I think this tool is also included in VS 2008. In fact, I was already kicked off that tool to dump the SQL out for my own MySQL export when I saw the community-provided ones were available, so never bothered to finish it.
Chruker	Posted - 2008.08.01 14:51:00 - [48] Oh, and all the rendered icons are blurry/out-of-focus ----- http://games.chruker.dk/eve_online ----- Top wishes: - No daily downtime - Faster training on sisi - Speedup IGB table rendering
Ami Nia	Posted - 2008.08.01 14:53:00 - [49] Originally by: Dronte Jeeeesus christ, stop whining about the format already!. Its not like you had to wait long, the community had released the first ANSI SQL, MySQL, PSQL etc. version without 2 hours!! of the initial release, and posted links to them, both in this thread and in the various threads on the tech lab forum and on #eve-dev on IRC. I strongly disagree. This is not an OS war or a MS hate cry. It's both a technical and a matter of principle. To begin with, CCP is supposedly supporting EvE on multiple platforms. Nobody on ANY of the officially supported platforms should ever need to access player-translated data. It is CCP that has to first-handedly provide usable files for each platform. It is not a question of how much time passes between the official files release and the translated files availability. It is the fact that CCP is to do the translations and consider them formally official files (or better yet release a platform independent, human readable, structured file). Second, each and every binary distribution of a data base is intrinsically an inferior distribution. Any sane data dump shall be in a pure text format, possibly understandable by humans to the extent of being editable with pure text tools (as in notepad). This is a well know fact in the computer science community. There are only two forces that can make a binary file superior: file size (for example for transmission over the net or for reduced storage requirements) and monopolistic format lockouts. If the first case is the reason to have a binary format, then the solution is to use a text format and then compress it with a well known patent free algorithm and into a well known patent free file format. Like zip, gz or bz. If the second case is the reason to have a binary format, then you are in fact admitting that you do not want any one (but those few you select) to be able to access the data. Technically the format CCP chose to distribute the data dump is: -) a great format for internal use if and only if the company is not mature enough to be open to move to a better platform (that is: MS SQL probably IS the better platform. Now. But there's no guarantee it will still be in 5 or 10 years. And CCP should be ready to adapt if things change). -) the kind of format an expert of MS SQL will recommend if he/she was to single handedly decide. What format to use when publicly releasing data should never be a single person decision, but always a committee consensus. And the manager should make sure the committee is both technically savvy and as heterogeneous as possible. -) a very bad format to use for releasing data that is officially destined to multiple platforms. Whining about the chosen format is therefore absolutely pertinent.
Hel O'Ween Gallente Biotronics Inc. Alternative Realities	Posted - 2008.08.01 15:25:00 - [50] Originally by: Cesar Malari Edited by: Cesar Malari on 01/08/2008 14:44:56 Originally by: BigWhale One question, is MS SQL unable to produce an ANSI SQL text dump? Natively? No. SQL Server doesn't ship with a tool like mysqldump. However, there is such a tool available -- the Database Publishing Wizard. Point it at a DB and it builds SQL scripts for the schema and/or data. I think this tool is also included in VS 2008. Also, SQL Server Management Studio Express (free download) is a useful tool for SQL Server Express 2005 -- EVEWalletAware - an offline wallet manager

Cesar Malari Gunfleet Logistics	Posted - 2008.08.01 16:00:00 - [51] Edited by: Cesar Malari on 01/08/2008 16:01:29 Originally by: Ami Nia To begin with, CCP is supposedly supporting EvE on multiple platforms. I don't believe CCP officially supports anything other than the EvE client on multiple platforms. The data dumps at this point exist as more of a "here, see what you can do with this" than an officially supported released product. Case in point: how long it took after the patch before we got this dump. Would it be better if CCP supplied this data in a more open format? Yes. However, if CCP doesn't feel it's worth their time to do the conversion, I'd rather they gave us what they've given us than nothing at all. In fact, if I had to choose one of two directions for further work on the data dump: make the export more cross-platform or include more data in the export, I'd pick #2. The community can convert the data rather easily. We can't see the data that's not released. Constructive suggestions are good (ie. the discussion over crpNPCCorporationTrades and the suggesting a more open format). Whining about the lack of 'official' support (I quote official here because none of this is officially supported -- try filing a petition about it) for our chosen platform mak may make them think we don't appreciate what they've given us. Which we do. We like having more data and more up-to-date data to play with.
BigWhale Gallente Three WiseMen Association	Posted - 2008.08.01 16:48:00 - [52] Well, I wanted to point out (what was already mentioned), that data dumps would most commonly be in a human readable form. I am sure that CCP had a very good reason why they made a binary dump in some obscure format. And I would present the same argument if they gave us Mysql InnoDB binary tables. It simply seems wrong to me. Binary files are a pain and now they are binary files tied to only one platform. I think that this format was the easiest way of doing TheDataDump. :) I dont blame them for that. The whole community was whining about it. Well, I would be willing to wait a bit more... :) -- R, U & Y are letters, not words...
Chainsaw Plankton IDLE GUNS IDLE EMPIRE	Posted - 2008.08.01 17:12:00 - [53] Edited by: Chainsaw Plankton on 01/08/2008 17:12:50 Originally by: CCP Prism X 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. you are lucky I just got back from the bathroom. otherwise I would have just shat myself there all I get to nerf are abaddons* *soon to include more amarr ships, and various other ships as well. I just installed flash again, that and I need to figure out what other ships shoot. also an eve-files account so I can have multiple signatures
DHU InMe Gallente JUSTICE Inc.	Posted - 2008.08.01 22:34:00 - [54] Originally by: Epitrope First off, thanks to you and t20 for the updated export! As for crpNPCCorporationTrades: Originally by: CCP Prism X Something like finding out what is being sold in regions they've never been in would be a good example. This information is available in game by looking at the trade tab of an NPC corporation's info window. It's tedious and inconvenient, and I have certainly made the argument in the past that hard things tend not to be done, but I would say it isn't secret information (although the supplyDemand column was). (Plus, as Matalino mentioned, the E-O Item Database has it in a slightly less inconvenient form.) Originally by: CCP Prism X 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. I for one would be happy with just the sell orders. Right now I use the Trinity version of the crpNPCCorporationTrades table by just selecting corporationID, typeID where supplyDemand > 0. Prefiltering the exported table like that would avoid showing even the possibility of trade routes (which would have to be double-checked anyway because of the aforementioned price fluctuation). If we could filter that junk. Some corporation have very ridiculous long list. I also wonder if it alway 100% acurate in game... Overhaul //todo remake EvE Links //todo remake RTFPN HELP
Eraggan Sadarr Phoenix Tribe	Posted - 2008.08.02 10:04:00 - [55] Thx for the dump I'm really glad you decided on a more friendly SQL Bak file so that we in the future might see some faster dumps Eve Market Scanner
Malrock Caldari Mea Culpa Enigma The Nexus Alliance	Posted - 2008.08.02 22:07:00 - [56] Edited by: Malrock on 02/08/2008 22:11:21 Originally by: CCP Prism X 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. 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. Reason is here & clear, and i for one fully support it, there are plenty of people out there who can make conversions to any format, the goal here is to have 1 official format coming off ccp AS FAST AS POSSIBLE, then let others do the 100000001 subformats used by anyone else. And before you go flaming about OS this and that; lets be happy we get anything at all, cause there's nothing saying that ccp must do anything for third party dev's. There is how ever one simple request. Math on production seems to be off no matter how i try to balance (specifically on t2 stuff), could we get say stored procedures in dump that have the official formulas in them for building, refining, etc ? Give us a visit.
Chruker	Posted - 2008.08.03 09:03:00 - [57] agtAgentOffers is also MIA, although I would expect the same excuse as with crpNPCCorporationTrade ----- http://games.chruker.dk/eve_online ----- Top wishes: - No daily downtime - Faster training on sisi - Speedup IGB table rendering
Cosy Gallente Porandor	Posted - 2008.08.04 00:23:00 - [58] is me or i dont see the overheat icon Originally by: CCP Mitnal Any complaints can be directed towards our Music Director
Azazel Mordred Minmatar Cloak of Shadows	Posted - 2008.08.04 17:06:00 - [59] Originally by: Cosy is me or i dont see the overheat icon Seems to be there - icon22_10
Althea Nar'agh StarHunt Fallout Project	Posted - 2008.08.05 07:55:00 - [60] Hi Prism, First of all thanks for these items we really needed them :) I have couple quick questions tho... Am using 64x64 icons and have unpacked: EmpyreanAge_1.0_img_icons.zip EmpyreanAge_1.0_img_types_dx9.zip Shiptypes / 32x32 : 232 files Shiptypes / 64x64 : 346 files What gieves? In plus 64_64/29266.png (Apotheosis) does not exist (but it's there in 32_32) so why the diffrence? and it's not the only one with diffrence, other example: Icons / 16x16 : 1604 files Icons / 32x32 : 1092 files Icons / 64x64 : 964 files And my second question, could we get an allianceToIcon mapping preaty please? Thanks War. War never changes. Training Monitor / iMonitor / iCEO iPOS iHelp

Azia Burgi Caldari Science and Trade Institute	Posted - 2008.08.05 15:41:00 - [61] What units have been used for the following: mapCelestialStatistics.orbitPeriod mapCelestialStatistics.rotationRate mapCelestialStatistics.pressure Any sensible suggestions? Azia Burgi http://azia.geekandproud.co.uk BP Profit Calculator EVE Cemetery

CCP Prism X Gallente C C P	Posted - 2008.08.05 16:30:00 - [62] 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.

Azia Burgi Caldari Science and Trade Institute	Posted - 2008.08.05 17:20:00 - [63] Originally by: CCP Prism X 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 I appreciate that you are at home i don't expect a reply until you are in the office, but I expect a reply at 09:05! Ingame pressure is listed as "very low" or "low". in the export it is listed as a figure. I'll assumed that this figure is MegaPascals, because that is the only unit type that refers to pressure. if orbitPeriod is seconds then there is a problem because i get a vastly different figure (when converting it to days) to what the game claims. i used orbitPeriod/60/60/24. rotationRate... is this rad/sec? does it refer to the planet rotating on its axis or to the planet orbiting the parent star? You also have some very lowgrav gas giants. other than that great export! hope you had a great holiday too btw (do we get to see the snaps?). Azia PS: the cemetery is running out of space... anything you can do? Azia Burgi http://azia.geekandproud.co.uk BP Profit Calculator EVE Cemetery
Rexthor Hammerfists The Movement	Posted - 2008.08.07 09:57:00 - [64] excuse me my ignorance as i have no idea about all this, id appreciate a simple answer for my simple mind ;) - will this make local checking programms possible again? - Any good reason for gateguns shooting drones and thus removing dronebased ships from pirating?
Vessper Indicium Technologies	Posted - 2008.08.07 12:38:00 - [65] Originally by: Rexthor Hammerfists excuse me my ignorance as i have no idea about all this, id appreciate a simple answer for my simple mind ;) - will this make local checking programms possible again? Nope - the export is static data on items, ships, materials, map information and so on, there's no real-time data that can be retrieved from this. - - - EveHQ Character App \| Item Database
Nelix Trist Caldari Nostromo Industries	Posted - 2008.08.07 15:12:00 - [66] So to be rather blatent... Now that we have this, what are the advantages and what applications can I get to make use of this information? Emm?"Cant touch this" den der der dum, der dum der dum KILLING THE BUG'S, BEFORE THEY KILL YOU
Azia Burgi Caldari Science and Trade Institute	Posted - 2008.08.08 00:35:00 - [67] Edited by: Azia Burgi on 08/08/2008 00:37:13 Originally by: Nelix Trist So to be rather blatent... Now that we have this, what are the advantages and what applications can I get to make use of this information? the advantages? the most up-to-date data straight from CCP towers. the applications you need are listed on in the devblog. However seeing you asked nicely you need: MS SQL Server Express 2005 http://go.microsoft.com/fwlink/?linkid=65212 This is the "framework" which allows you to host MSSQL databases off your local machine. SQL Server Management Studio Express http://go.microsoft.com/fwlink/?linkid=65110 This lets you manipulate the database in a graphical way, similar to MS Access. I can create an Access version if you are more comfortable using that. edit: darn links Azia Burgi http://azia.geekandproud.co.uk BP Profit Calculator EVE Cemetery
Chruker	Posted - 2008.08.08 01:18:00 - [68] Originally by: Althea Nar'agh Am using 64x64 icons and have unpacked: EmpyreanAge_1.0_img_icons.zip EmpyreanAge_1.0_img_types_dx9.zip Shiptypes / 32x32 : 232 files Shiptypes / 64x64 : 346 files The archives I've downloaded just have the 232 files in all the Shiptypes/sizes. Did you delete the your existing files first? And 29266.png is also present in all 4 sizes. Quote: Icons / 16x16 : 1604 files Icons / 32x32 : 1092 files Icons / 64x64 : 964 files There are several icons that are only in 16x16 sizes, so it doesn't make much sense enlarging those. You can see the icon sheets if you extract the iconXX.dds files using TriExporter. I haven't checked if the sheets have the same icons in different sizes or if they are just scaled by the client when generating the icons. And an additional comment to the files: EmpyreanAge_1.0_img_types_dx9.zip contains the directory with 2095 blueprint icons from EmpyreanAge_1.0_img_blueprints.zip effectively bloating the _dx9.zip file by 16 mb Finally to reiterate. All the rendered icons in EmpyreanAge_1.0_img_types_dx9.zip and EmpyreanAge_1.0_img_types_dx8.zip are blurry. ----- http://games.chruker.dk/eve_online ----- Top wishes: - No daily downtime - Faster training on sisi - Speedup IGB table rendering
Althea Nar'agh StarHunt Fallout Project	Posted - 2008.08.08 07:19:00 - [69] Edited by: Althea Nar''agh on 08/08/2008 07:20:59 hm Chruker thanks... and the extraction was in a separate path so... anyhow i'll try again see what comes out... EDIT: i actually downloaded the zips from eve-id so maybe my issue comes from there... War. War never changes. Training Monitor / iMonitor / iCEO iPOS iHelp
Nelix Trist Caldari Nostromo Industries	Posted - 2008.08.08 09:06:00 - [70] Originally by: Azia Burgi Edited by: Azia Burgi on 08/08/2008 00:37:13 Originally by: Nelix Trist So to be rather blatent... Now that we have this, what are the advantages and what applications can I get to make use of this information? the advantages? the most up-to-date data straight from CCP towers. the applications you need are listed on in the devblog. However seeing you asked nicely you need: MS SQL Server Express 2005 http://go.microsoft.com/fwlink/?linkid=65212 This is the "framework" which allows you to host MSSQL databases off your local machine. SQL Server Management Studio Express http://go.microsoft.com/fwlink/?linkid=65110 This lets you manipulate the database in a graphical way, similar to MS Access. I can create an Access version if you are more comfortable using that. edit: darn links Thanks for that reply. I'm not realy too up on all this SQL stuff nor Access. I've never had an eye for Databases. Sounds good though, the applications that some people could make out of this. Would be very helpfull. Emm?"Cant touch this" den der der dum, der dum der dum KILLING THE BUG'S, BEFORE THEY KILL YOU

iulixxi Dracula Order Hydra Alliance	Posted - 2008.08.09 11:57:00 - [71] Edited by: iulixxi on 09/08/2008 11:58:35 I also noticed some things are missing from this dump, for example: tables stastations and mapdenormalize are missing the stations from stationID 61000001 to 61000201 - thats 200 stations. In http://api.eve-online.com/eve/ConquerableStationList.xml.aspx they are listed but not in the data dump. What happend ? Some conquerable station are listed (60014861 to 60014928) and some are not ... Also my first post must have been missed some how (or ignored) so I will ask again: Will we have a data_map icons any time soon ? (Black rise region/constellation and systems, also some systems from the last data_map are missing). Thanks, Iulian
Gut Punch The Dead Parrot Shoppe Inc.	Posted - 2008.08.10 14:47:00 - [72] Prism X: Is is just me or did you guys change the list of items dump to include less of the base prices? Some of them are there but base prices available in the last dump aren't there now.
Sky Grunthor Minmatar The Dead Parrot Shoppe Inc.	Posted - 2008.08.10 14:48:00 - [73] Where are the png's for the militia ranks? The ones provided in the Dev Blog aren't any good because you didn't leave the background as transparent. And they aren't in any of the image data dumps. Search: Sky Grunthor
Fortuna Cournot Caldari Special Unit Omega Kraftwerk.	Posted - 2008.08.12 14:24:00 - [74] Thank you for the data export! I am missing some information, perhaps someone can help or explain what to do to obtain it. There are 80 products where i miss activities in the dump files. There are blueprints to build these activities, and there are bluprints where the products are used in other activities to build. Example Question: How to build a Capital Armor Plates ??? Thank you! Appendix: To get a list of Products some SQL: SELECT t.typeName RequiredMaterial FROM invtypes t JOIN typeactivitymaterials tam1 ON tam1.requiredTypeID = t.typeID JOIN invblueprinttypes bpt ON tam1.typeID = bpt.productTypeID JOIN invblueprinttypes bpt2 ON t.typeID = bpt2.productTypeID JOIN invtypes t2 ON bpt.blueprintTypeID = t2.typeID WHERE NOT EXISTS (SELECT tam2.typeID FROM typeactivitymaterials tam2 WHERE t.typeID = tam2.typeID) GROUP BY t.typeID ORDER BY t.typeName; There are 1823 Activites defined where these 80 products are used. Some SQL to fetch them: SELECT t.typeName RequiredMaterial, tam1.quantity, t2.typeName Blueprint FROM invtypes t JOIN typeactivitymaterials tam1 ON tam1.requiredTypeID = t.typeID JOIN invblueprinttypes bpt ON tam1.typeID = bpt.productTypeID JOIN invblueprinttypes bpt2 ON t.typeID = bpt2.productTypeID JOIN invtypes t2 ON bpt.blueprintTypeID = t2.typeID WHERE NOT EXISTS (SELECT tam2.typeID FROM typeactivitymaterials tam2 WHERE t.typeID = tam2.typeID) ORDER BY t2.typeName; Some of the Products with missing build activities: Antimatter Reactor Unit; Capital Antimatter Reactor Unit; Capital Armor Plates; Capital Capacitor Battery; Crystalline Carbonide Armor Plate; Deflection Shield Emitter; Electrolytic Capacitor Unit; Emp Pulse Generator; Fernite Carbide Composite Armor Plate; Fusion Reactor Unit; Fusion Thruster; Gravimetric Sensor Cluster; Graviton Reactor Unit; Ion Thruster; Ladar Sensor Cluster; Linear Shield Emitter; Magnetometric Sensor Cluster; ------ ineve.net Character Skill Showroom My EVE Link Collection
WolfSinger SilverShadow Gallente	Posted - 2008.08.12 16:41:00 - [75] I have to agree with a lot of the other people here. This should not have been released in only in a Microsoft proprietary format. Doing so prevents people using the MAC and Linux game clients from accessing this data without getting a Windows machine involved in the process somehow. Yes, itÆs true that several fan sites released text-based SQL versions of the database within a few hours, but we shouldnÆt need to depend on that. On top of that, this also makes their releases unofficial û data could have been changed either accidentally or maliciously, etcà At least if you guys release an SQL version, it can be trusted 100% DonÆt get me wrong here. We definitely appreciate the release of this data, but releasing it that way just adds extra steps for those of us who need it for a non-MS server û we either need to figure out a way to convert it ourselves, or wait for an unofficial conversion. As it is, I probably wasted about 3 hours getting SQL Server Express loaded, figuring out just how to load a .BAK file since I never used SQL server before, then wasted some more time trying to figure out a way to get the data exported and over to my Linux Web/MySQL server. Once someone released the .SQL version, it took me about 5 minutes to get it loaded successfully. Please consider this when you get ready to release the next one. But like I said, we do appreciate the data. As it is now, IÆve written a personal PHP/MySQL program to help me calculate blueprint efficiencies and research, and it figures out how much it costs to make items based on prices from eve-central. I wouldnÆt mind releasing to the general public if my poor little server and internet bandwidth could handle it. My next project: a refining/reprocessing calculator. Looks like you can get the results for modules and such from the typeActivityMaterials table. Batch size corresponds to invTypes.portionSize, but where is the refining reults info for ore, ice, and refinables? IÆve found some charts on fan sites that list this info, but IÆve also found errors (did the refining results for Glossy Compound change at some point?) Either IÆm not seeing it, or that data table just isnÆt included. Any help here would be appreciated.
Glengrant TOHA Heavy Industries	Posted - 2008.08.22 10:51:00 - [76] Edited by: Glengrant on 22/08/2008 10:52:09 Thanks for releasing the data and for thinking about how to make this more readily available from now on. But using MSSQL backup (as the sole format) is a terrible idea. SQL Server doesn't run on Linux: http://appdb.winehq.org/objectManager.php?sClass=application&iId=7218 So that's fairly annoying to those amongst us who said good bye to windows. Besides that even the majority of windows players won't use MSSQL for anything beyond getting the data from the backup as they have to upload to MySQL DBs on their webspace or use it sqlite or similar for offline tools. I don't see anybody here paying for SQL Server 2k5 licenses. Sure - somebody is likely nice enough to convert and publish in short order. And it's not that hard - which begs the question why CCP is not doing so themselves. I'm using MSSQL at work every day and also do plenty of exports - many of them get automated. It's fairly easy to dump data from MSSQL into a variety of formats (actually any conceivable format). Obviously I have insufficient info about the particular Eve DB - but what is so damn complicated about creating an automated export of some tables (possibly filtering some columns players aren't supposed to see) into a universally usable format (eg CSV with ASCII 1 as delimiter or some such)? But even better - why not create a read-only cache database with the data from the dumps that's publicly available? Similar to what you are already doing with the eve api. That would not only solve all problems regarding formats but also save most community eve web apps from having to import all that data and keeping it up-to-date. I assume that the bandwith and server demands would be a negligible tiny fraction of what CCP uses for Eve anyway. Thanks for listening --- ISK BUYER = LOOSER EVE TV- Bring it back!
Buildius Maximus	Posted - 2008.09.03 13:12:00 - [77] And where is the new updated export now that we have had a major patch?

CCP Explorer	Posted - 2008.09.04 22:52:00 - [78] 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 - [79] 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?

burning raven omen. Triumvirate.	Posted - 2008.09.05 21:05:00 - [80] Originally by: CCP Prism X 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? You rock my world, you are my saviour! Do you belive in destiny?

Z010	Posted - 2008.09.07 11:45:00 - [81] Originally by: CCP Prism X At least we're releasing them when we know the static data of every expansion is stable. That must account for something, no? Yes, at least we are not discussing when the next release will be! So, I'll learn some new tricks, or wait the two hours, or 24 hours for it to be a format I can use. Thanks Prism - for giving us something unimportant to complain about!
WolfSinger SilverShadow Gallente Caldari Deep Space Ventures	Posted - 2008.09.16 16:37:00 - [82] Still haven't seen anyone post about a MySQL realease of the 1.1 database, so I gave it a shot myself. Not even on EveDEV Network, and those guys are usually on the ball. Only took me about a week to figure out how to get MS Server SQL express installed, configured to accept connections, and then loaded wite DB dump Took another week to figure out that the converter I was using was messing up the table schema, making some fields too small. Got aroud this by setting all SMALLINT and TINYINT fields to just straight INT. All time I would have much rather spent PLAYING Eve. I uploaded the file to eve-files: http://dl.eve-files.com/media/corp/wolfsinger/eveEmpy11mySQL.zip Does not include foreign keys. Please give me some feedback on how I did. If I mucked something up, I'll try to fix it.
Cpt Bunny Gallente War inc	Posted - 2008.12.01 16:59:00 - [83] 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

CCP Fallout	Posted - 2008.12.01 19:16:00 - [84] 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

Mariokoli Mianana Gallente Cloak and Daggers Ocularis Inferno	Posted - 2009.02.11 17:59:00 - [85] Originally by: CCP Prism X 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. Blargh! I miss some of this information, but more for the silly trivia reasons, a la my "NPC Supply and Demand Revealed" post. In fact, while that post was little seen, I have an inkling that my post may have reveled some of the interesting information one could get from that table and led to its removal from the data dump... Still, I think that it should be more or less public knowledge what each NPC corporation is willing to buy and sell.
Mariokoli Mianana Gallente Cloak and Daggers Ocularis Inferno	Posted - 2009.02.11 18:13:00 - [86] Originally by: Azia Burgi What units have been used for the following: mapCelestialStatistics.orbitPeriod mapCelestialStatistics.rotationRate mapCelestialStatistics.pressure Any sensible suggestions? I've found that orbitPeriod and rotationRate are very likely in tenths (1/10) of a second. Pressure is in cPa or hundredths (1/100) of a Pascal. Values less than 10 Pa (1000 in the DB) are listed as "Very Low". These values are converted to days/hours and kPa respectively before being displayed.
Kendoori Jinwah	Posted - 2009.03.28 10:39:00 - [87] I've just imported the .bak database and noticed something that was not exported and don't know if it was left out intentionally, but the relationships between tables are not there. I'm going through and creating them each so when I pull up a data diagram, it's a little more concise as to what goes where. The ID labels are labeled nicely enough for me to figure it out but others might not. I don't think the EVE databases would not have relationship constraints so these relationships should be included as it helps first time users quickly identify what relates to what. Also, is there any way to determine where the current character is (Region/Constellation/Solar System) either using the API or some other method? I am starting to write a tool for keeping track of corp/alliance intel for solar systems and when a user reports intel, I'd like the utility to auto populate the solar system with the one the person repoting the intel (user) is currently in. Is this possible? Thanks for the data.


Pages: 1 2 3 :: [one 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.