Static Data Export

From EVE University Wiki
Revision as of 03:03, 9 November 2016 by Eddie echerie (talk | contribs)
Jump to: navigation, search

Currently a placeholder for a page I'm working on

How to use the fuzzwork dumps

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

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" 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.

What each file does

File name What it does
ramActivities.csv.bz2 Describe what each R.A.M. does. See Manufacturing
invGroups.csv.bz2 Contains information on inventory groups, such as groupID, categoryID, and other metadata
agtAgents.csv.bz2 Contains information regarding agents such as location, corporation, type, level, and locator (boolean)
ramAssemblyLineTypeDetailPerCategory.csv.bz2 Example
dgmExpressions.csv.bz2 Example
dgmEffects.csv.bz2 Example
warCombatZones.csv.bz2 Example
staOperationServices.csv.bz2 Example
invMetaGroups.csv.bz2 Example
industryActivitySkills.csv.bz2 Example
chrBloodlines.csv.bz2 Example
skinShip.csv.bz2 Example
crpNPCCorporationTrades.csv.bz2 Example
mapUniverse.csv.bz2 Example
invItems.csv.bz2 Example
staStations.csv.bz2 Example
mapLocationWormholeClasses.csv.bz2 Example
invCategories.csv.bz2 Example
eveGraphics.csv.bz2 Example
mapDenormalize.csv.bz2 Example
crpActivities.csv.bz2 Example
chrRaces.csv.bz2 Example
chrFactions.csv.bz2 Example
invNames.csv.bz2 Example
invMetaTypes.csv.bz2 Example
dgmTypeEffects.csv.bz2 Example
crpNPCDivisions.csv.bz2 Example
crpNPCCorporationResearchFields.csv.bz2 Example
certMasteries.csv.bz2 Example
translationTables.csv.bz2 Example
planetSchematics.csv.bz2 Example
mapConstellations.csv.bz2 Example
dgmTypeAttributes.csv.bz2 Example
dgmAttributeCategories.csv.bz2 Example
crpNPCCorporationDivisions.csv.bz2 Example
skinLicense.csv.bz2 Example
invPositions.csv.bz2 Example
certSkills.csv.bz2 Example
staStationTypes.csv.bz2 Example
mapSolarSystems.csv.bz2 Example
invTraits.csv.bz2 Example
invControlTowerResourcePurposes.csv.bz2 Example
invContrabandTypes.csv.bz2 Example
mapLandmarks.csv.bz2 Example
invFlags.csv.bz2 Example
industryActivityMaterials.csv.bz2 Example
warCombatZoneSystems.csv.bz2 Example
staServices.csv.bz2 Example
mapConstellationJumps.csv.bz2 Example
mapCelestialStatistics.csv.bz2 Example
trnTranslations.csv.bz2 Example
mapSolarSystemJumps.csv.bz2 Example
dgmAttributeTypes.csv.bz2 Example
agtResearchAgents.csv.bz2 Example
ramAssemblyLineTypeDetailPerGroup.csv.bz2 Example
invTypeMaterials.csv.bz2 Example
mapJumps.csv.bz2 Example
invControlTowerResources.csv.bz2 Example
industryBlueprints.csv.bz2 Example
industryActivity.csv.bz2 Example
certCerts.csv.bz2 Example
invTypes.csv.bz2 Example
mapLocationScenes.csv.bz2 Example
chrAncestries.csv.bz2 Example
invUniqueNames.csv.bz2 Example
trnTranslationLanguages.csv.bz2 Example
trnTranslationColumns.csv.bz2 Example
skins.csv.bz2 Example
ramInstallationTypeContents.csv.bz2 Example
planetSchematicsTypeMap.csv.bz2 Example
mapRegions.csv.bz2 Example
invTypeReactions.csv.bz2 Example
industryActivityRaces.csv.bz2 Example
eveUnits.csv.bz2 Example
eveIcons.csv.bz2 Example
agtAgentTypes.csv.bz2 Example
staOperations.csv.bz2 Example
skinMaterials.csv.bz2 Example
ramAssemblyLineTypes.csv.bz2 Example
ramAssemblyLineStations.csv.bz2 Example
planetSchematicsPinMap.csv.bz2 Example
mapRegionJumps.csv.bz2 Example
invVolumes.csv.bz2 Example
invMarketGroups.csv.bz2 Example
industryActivityProducts.csv.bz2 Example
industryActivityProbabilities.csv.bz2 Example
crpNPCCorporations.csv.bz2 Example
chrAttributes.csv.bz2 Example