CSVExport¶
Description¶
Exports the file system branch of the currently selected directory in a CSV file.
Syntax¶
CSVExport (ExportPath : <String>, ExportFullBranch : <Boolean>, IncludeHeader : <Boolean>, IncludeUnit : <Boolean>, AppendToFile : <Boolean>)
Parameters¶
- ExportPath
The full path of the export file (including the exported file name). You can use environment variables as well as “%DATE%” and “%TIME%” in the file path.
- ExportFullBranch
Indicates, if the export will include the full directory branch or only expanded directories.
- IncludeHeader
Indicates, if a header with general information about the root directory/drive will be included.
- IncludeUnit
Indicates, if size units and thousand separator will be included in the export, or if sizes are exported as plain numbers.
- AppendToFile
Indicates, if the export will be appended to an existing file, or if an existing file will be overwritten.
Example¶
$SOS.CSVExport("C:\Temp\SOS\csvexport.csv", $false, $True, $true, $false)
SOS.CSVExport "C:\Temp\SOS\csvexport.csv", False, True, True, False
Produces a report in CSV format, stored at “C:TempSOScsvexport.csv”. It will contain only the expanded directories, not the full directory branch. Header and unit sizes will be included. If a file of this name already exists, the existing file will be overwritten by this file.
Remarks¶
CSV files are actually plain text files. So you can also use the TextExport with a file with the extension “csv” as export file name to produce an CSV export.