0 of 0
About this mod
xEdit script to Export all data of a record into a .csv file
- Permissions and credits
- Changelogs
DESCRIPTION:
using FNVEdit, export all data of a record into .csv format
tested in FNVEdit 4.1.5f
sample google sheets link on how i used the export script output to determine if armor is non-playable, same mesh used for male and female, male only mesh, female only mesh, etc. by exporting Armor and Armor Addon on main esm using basic ExportRecordsSelected script.
4 scripts, each have similar yet different function:
1) ExportRecordsSelected - export selected (single or multiple) records into a csv file with same name.
2) ExportRecordsSelectedRelated - same as 1) but also exports related records found in Referenced By and Soft References like texture set from RadiationSuitM [TXST:00053362], non recursive meaning direct relation only.
3) ExportRecordsSelectedConflict - export records but gets latest values if other plugins are loaded after.
4) ExportRecordsSelectedRelatedConflict - same as 3) but also exports records found in Referenced By and Soft Reference.
USAGE:
1) Install FNVEdit
2) Download this mod and extract the "Edit Scripts" folder to the same folder you installed FNVEdit, there should already be an Edit Scripts folder there.
3) Run FNVEdit and load all mods you want to load.
4) Once FNVEdit has loaded, right click on a record or highlight multiple records then right click, can also right click on plugin.
5) Select "Apply Script..."
6) Expand Script dropdown menu and look for the script, press OK.
7) Check Message Box to see if its Done
8) go to FNVEdit folder and check generated .csv file (same name as script), enlarge column or row width as desired to see full data.
9) transfer data to a proper excel format or google sheets to use indexmatch/lookup for data manipulation
DISCLAIMER:
found other export scripts but didn't find anything that exports every record.
fields with hash values are still hash and its rounded off so not really usable (Folder Hash = -2748540860015611020 but in the GUI its textures\armor\enclavescientist).
created more than a year ago so i forgot some technical details about the script. script runner JIP becoming popular so i found a use for it again.
copied mod page format from qolore7.
AI-assisted script.
using FNVEdit, export all data of a record into .csv format
tested in FNVEdit 4.1.5f
sample google sheets link on how i used the export script output to determine if armor is non-playable, same mesh used for male and female, male only mesh, female only mesh, etc. by exporting Armor and Armor Addon on main esm using basic ExportRecordsSelected script.
4 scripts, each have similar yet different function:
1) ExportRecordsSelected - export selected (single or multiple) records into a csv file with same name.
2) ExportRecordsSelectedRelated - same as 1) but also exports related records found in Referenced By and Soft References like texture set from RadiationSuitM [TXST:00053362], non recursive meaning direct relation only.
3) ExportRecordsSelectedConflict - export records but gets latest values if other plugins are loaded after.
4) ExportRecordsSelectedRelatedConflict - same as 3) but also exports records found in Referenced By and Soft Reference.
USAGE:
1) Install FNVEdit
2) Download this mod and extract the "Edit Scripts" folder to the same folder you installed FNVEdit, there should already be an Edit Scripts folder there.
3) Run FNVEdit and load all mods you want to load.
4) Once FNVEdit has loaded, right click on a record or highlight multiple records then right click, can also right click on plugin.
5) Select "Apply Script..."
6) Expand Script dropdown menu and look for the script, press OK.
7) Check Message Box to see if its Done
8) go to FNVEdit folder and check generated .csv file (same name as script), enlarge column or row width as desired to see full data.
9) transfer data to a proper excel format or google sheets to use indexmatch/lookup for data manipulation
DISCLAIMER:
found other export scripts but didn't find anything that exports every record.
fields with hash values are still hash and its rounded off so not really usable (Folder Hash = -2748540860015611020 but in the GUI its textures\armor\enclavescientist).
created more than a year ago so i forgot some technical details about the script. script runner JIP becoming popular so i found a use for it again.
copied mod page format from qolore7.
AI-assisted script.