Static Data Export: Difference between revisions

Line 1:

~~= How to~~ use the ~~fuzzwork dumps =~~

CCP makes available a Microsoft SQL Server data dump file of static data, as it appears in Tranquility Server, for use by the EVE community. This data dump is called the Static Data Export. Along with this dump Image Export collections are also made available. These resources can be found at the EVE developers [https://developers.eveonline.com/resource/resources resource] page. All resources provided by CCP are subject to the [https://developers.eveonline.com/resource/license-agreement license agreement] linked on page.

~~The fuzzwork dumps, also knows as~~ the ~~SDE (~~Static Data Export), are ~~very useful for many 3rd party applications~~. ~~They~~ can be found at [~~http~~://~~www~~.~~fuzzwork~~.co.uk www.fuzzwork.co.uk] under SDE~~, then under latest,~~ or more directly at [~~http~~://www.fuzzwork.co.uk/dump/latest www.fuzzwork.co.uk/dump/latest]~~. This article will go into detail on what each part is for, and how to access it~~.

= Fuzzwork SDE Conversions =

To aide fellow developers and players in consuming this data without having to extract or convert from Microsoft SQL Server format every time Steve Ronuken has hosted conversions in PostgreSQL, SQLite and MySQL readable formats. They can be found at [https://www.fuzzwork.co.uk Fuzzwork] under SDE or more directly at [https://www.fuzzwork.co.uk/dump www.fuzzwork.co.uk/dump]. Individual table data can be found in [//en.wikipedia.org/wiki/Comma-separated_values CSV] and [//en.wikipedia.org/wiki/SQL SQL] (MySQL) formats (compressed) here [https://www.fuzzwork.co.uk/dump/latest www.fuzzwork.co.uk/dump/latest].

== Opening a file from the SDE ==

~~Directly quoted~~ from ~~the site~~: ~~"To open~~ bz2 files~~, use~~ bunzip2 in linux, or something like ~~7zip~~ in windows"

To extract data from compressed files, use [https://ss64.com/bash/tar.html tar] for <code>.tar.bz2</code> files or [https://ss64.com/osx/bzip.html bunzip2] for <code>.bz2</code> files in linux, and something like [http://www.7-zip.org/ 7-zip] for either format in windows.

~~Each file come in two flavors, CSV and SQL. For~~ the ~~purpose of this guide I won't go into opening SQL~~ files~~, and rather assume that you will~~ be ~~using CSV files. It should be noted however~~ that ~~SQL can be extremely powerful, especially when using multiple databases, but~~ the ~~author of this guide doesn't know SQL~~. ~~(yet)~~

Once extracted the files can be opened in the appropriate application that supports the file format.

== What each ~~file does~~ ==

== What each table contains ==

{| class="wikitable sortable"

|-

! ~~File~~ name !! What it ~~does~~

! Table name !! What it contains

|-

| [https://www.fuzzwork.co.uk/dump/latest/agtAgents.csv.bz2 agtAgents.csv.bz2]|| Contains information regarding agents such as location, corporation, type, level, and locator (boolean)

@@ Line 1: / Line 1: @@
-= How to use the fuzzwork dumps =
+CCP makes available a Microsoft SQL Server data dump file of static data, as it appears in Tranquility Server, for use by the EVE community. This data dump is called the Static Data Export. Along with this dump Image Export collections are also made available. These resources can be found at the EVE developers [https://developers.eveonline.com/resource/resources resource] page. All resources provided by CCP are subject to the [https://developers.eveonline.com/resource/license-agreement license agreement] linked on page.
-The fuzzwork dumps, also knows as the SDE (Static Data Export), are very useful for many 3rd party applications.  They can be found at [http://www.fuzzwork.co.uk www.fuzzwork.co.uk] under SDE, then under latest, or more directly at [http://www.fuzzwork.co.uk/dump/latest www.fuzzwork.co.uk/dump/latest].  This article  will go into detail on what each part is for, and how to access it.
+= Fuzzwork SDE Conversions =
+To aide fellow developers and players in consuming this data without having to extract or convert from Microsoft SQL Server format every time Steve Ronuken has hosted conversions in PostgreSQL, SQLite and MySQL readable formats. They can be found at [https://www.fuzzwork.co.uk Fuzzwork] under SDE or more directly at [https://www.fuzzwork.co.uk/dump www.fuzzwork.co.uk/dump]. Individual table data can be found in [//en.wikipedia.org/wiki/Comma-separated_values CSV] and [//en.wikipedia.org/wiki/SQL SQL] (MySQL) formats (compressed) here [https://www.fuzzwork.co.uk/dump/latest www.fuzzwork.co.uk/dump/latest].
 == Opening a file from the SDE ==
-Directly quoted from the site:  "To open bz2 files, use bunzip2 in linux, or something like 7zip in windows"
+To extract data from compressed files, use [https://ss64.com/bash/tar.html tar] for <code>.tar.bz2</code> files or [https://ss64.com/osx/bzip.html bunzip2] for <code>.bz2</code> files in linux, and something like [http://www.7-zip.org/ 7-zip] for either format in windows.
-Each file come in two flavors, CSV and SQL.  For the purpose of this guide I won't go into opening SQL files, and rather assume that you will be using CSV files.  It should be noted however that SQL can be extremely powerful, especially when using multiple databases, but the author of this guide doesn't know SQL. (yet)
+Once extracted the files can be opened in the appropriate application that supports the file format.
-== What each file does ==
+== What each table contains ==
 {| class="wikitable sortable"
 |-
-! File name !! What it does
+! Table name !! What it contains
 |-
 | [https://www.fuzzwork.co.uk/dump/latest/agtAgents.csv.bz2 agtAgents.csv.bz2]|| Contains information regarding agents such as location, corporation, type, level, and locator (boolean)