The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
|
The UniWiki's software has been successfully upgraded on the 2024-06-22. If you notice any issues, please tell us about them using Wiki Communication Channels.
|
Wiki Manager, Arin Mara
|
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 |
Information on R.A.M.
|
dgmExpressions.csv.bz2 |
Information regarding expressions
|
dgmEffects.csv.bz2 |
Information regarding effects, such as launching missiles, scaling damage, and the effects skills have.
|
warCombatZones.csv.bz2 |
A small file that updates regularly. Contains information about combat zones (FW I think?)
|
staOperationServices.csv.bz2 |
Information about what station types offer what services (speculation)
|
invMetaGroups.csv.bz2 |
A small file about meta group ids, such as Tech I, Tech II, Faction, Officer, etc
|
industryActivitySkills.csv.bz2 |
Containes information about the skills required to manufacture any blueprint.
|
chrBloodlines.csv.bz2 |
Contains information on what race each bloodline belongs to, descriptions.
|
skinShip.csv.bz2 |
What skins can be used on what ships
|
crpNPCCorporationTrades.csv.bz2 |
Information on what each NPC corp sells.
|
mapUniverse.csv.bz2 |
Possibly to differentiate between K-space and J-space? (speculation)
|
invItems.csv.bz2 |
Information about itemID and typeID, and some others
|
staStations.csv.bz2 |
Information about stations, their security level, location, name, reprocessing level, and much more.
|
mapLocationWormholeClasses.csv.bz2 |
Each location's wormholeClassID
|
invCategories.csv.bz2 |
Category IDs and category names
|
eveGraphics.csv.bz2 |
Information regarding grapics such as graphicID, graphic location, race, and description.
|
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
|