More actions
Added link to "official" documentation |
No edit summary |
||
| Line 5: | Line 5: | ||
== Opening a file from the SDE == | == 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" | 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. | 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) | ||
== What each file does == | == What each file does == | ||
{| class="wikitable sortable" | {| class="wikitable sortable" | ||
| Line 77: | Line 77: | ||
| [https://www.fuzzwork.co.uk/dump/latest/dgmTypeAttributes.csv.bz2 dgmTypeAttributes.csv.bz2]|| AttributeID of each item (typeID). See dgmAttributeTypes | | [https://www.fuzzwork.co.uk/dump/latest/dgmTypeAttributes.csv.bz2 dgmTypeAttributes.csv.bz2]|| AttributeID of each item (typeID). See dgmAttributeTypes | ||
|- | |- | ||
| [https://www.fuzzwork.co.uk/dump/latest/dgmAttributeCategories.csv.bz2 dgmAttributeCategories.csv.bz2]|| | | [https://www.fuzzwork.co.uk/dump/latest/dgmAttributeCategories.csv.bz2 dgmAttributeCategories.csv.bz2]|| What each categoryID is, and a categoryName | ||
|- | |- | ||
| [https://www.fuzzwork.co.uk/dump/latest/crpNPCCorporationDivisions.csv.bz2 crpNPCCorporationDivisions.csv.bz2]|| Example | | [https://www.fuzzwork.co.uk/dump/latest/crpNPCCorporationDivisions.csv.bz2 crpNPCCorporationDivisions.csv.bz2]|| Example | ||