Generate a CSV listing of a folder
Run FileList against the samples folder with /USECOLUMNS Name,Size,Extension,LastChange to produce a four-column CSV row per file. /NOTITLE and /NOHEADER strip the banner and column headers, /NOUTF8BOM suppresses the leading BOM that would otherwise corrupt the first cell, /LISTSEPARATOR forces a comma so the output is portable regardless of the host's regional settings, and /DATEFORMAT DateTimeISO normalizes the timestamps.
Return the listing as a typed CF query
Calls the wrapper's searchAsQuery() helper which lets FileList's CSV header row drive the column names, parses each row into a typed CF query (Size as integer, LastChange as timestamp), and round-trips through query-of-queries so the return is a standard CF query usable for QoQ sort/filter.
# FileList - Help
Source: https://www.jam-software.com/filelist
```
FileList V4.4.1
Prints a list of all files in a file system branch
FILELIST [/OPTION] Path(s) [>list.csv]
/ADDITIONALCOLUMNS Includes a set of comma-separated columns. For accepted columns, see /USECOLUMNS
/ATTRIBUTEFILTER Allows to specify one or more attributes. Example: To show
hidden read-only files call
FileList /ATTRIBUTEFILTER RH
Accepted filters are:
* Show all files and folders
R Read-only files
H Hidden files
S System files
D Folders
A Archive files
C Compressed files
P Sparse files
T Temporary files
O Offline files
L Reparse points
E Alternate and encrypted files
/DATEFORMAT Allows to specify a format for date values. Possible formats are:
Date Formats the displayed time to show the date only.
DateTimeShort Shows the date and time as hours and minutes.
DateTimeLong Shows the date and time including also seconds.
DateTimeISO Formats the displayed time to ISO-Standard.
TimeShort Formats the displayed time to show hours and minutes only.
/EXCLUDE Allows to specify one or more exclusion filters, separated with semicolons.
Any path matching any of the filters will be excluded.
The wildcards * and ? may be used. Path fragments like
*\System32\*.DLL may be used as well.
/FULLPATH Outputs full path of each file instead of separate columns for
file name and file path
/INCLUDE Allows to specify one or more inclusion filters, separated with semicolons.
Each path has to match at least one of the filters to be included.
The wildcards * and ? may be used. Path fragments like
*\System32\*.DLL may be used as well.
/LISTSEPARATOR Allows you to set the character used for separating the columns.
By default the list separator from the "Regional Settings" of
the Windows Control Panel is used. Add the new list separator
character after /LISTSEPARATOR separated by a space.
Use TAB to assign the tabulator as separator between columns. When
using the tabulator, columns will be exported without quotes.
/MAXDATE Only files whose last change date is older than given date
will be displayed. Use format "yyyy-mm-dd"
/MAXLEVEL Only files whose directoy level is below or equal to the given value
will be displayed. See also: DIRLEVEL
/MINDATE Only files whose last change date is later than given date
will be displayed. Use format "yyyy-mm-dd"
/MINLEVEL Only files whose directoy level is higher than or equal to the given value
will be displayed. See also: DIRLEVEL
/MINPATHLENGTH Allows to specify a minimum path length. Files whose full path has fewer
characters than the input value will be excluded from the list.
/MINSIZE Allows to specify a minimum file size in Bytes. Files which
have a size smaller than the input value will be excluded
from the list.
/NOHEADER Leaves out the column headers and only prints the raw data
/NOTITLE Omits the two title lines.
/NOUTF8BOM Omits the UTF8-BOM from the output.
/PRINTSHELLCOLUMNLIST Prints a list of all shell columns available for the specified folder.
/USECOLUMNS Allows to specify a list of columns and their order to use. Default columns will
not be extended, but replaced. Accepted are the following predefined columns and all
columns available with the shell (referenced by their canonic name):
ALLOCATED Adds a column with the size on disk (allocated space) of each file.
ATTRIBUTES Adds a column with the attributes that are set
for each file.
AUTHORS Extracts the name of the author from
MS Office documents.
CREATIONDATE Adds a column with the date each file was created.
DIRLEVEL Shows the depth of each file. This is relative to the
initial path.
EXTENSION Extracts the extension part of each file.
FILES Adds a column with the number of files contained in a folder. (Only
if folders are included with the listing)
FIXCOLUMN Adds a column that can be filled with custom content.
For example: /USECOLUMNS "Name,Size,FixColumn Content 1,Allocated,FixColumn Content 2"
FOLDERS Adds a column with the number of folders contained in a folder. (Only
if folders are included with the listing)
FRN Adds a column with the unique NTFS file reference
number.
FULLPATH Adds a column with the combined path and name of each file.
LASTACCESS Adds a column with the date each file was last accessed.
LASTCHANGE Adds a column with the date each file was last changed.
LASTSAVEDATE Extracts the last save date from MS Office documents.
MD5 Adds a column with the MD5 checksum of each file.
NAME Adds a column with the name of each file.
OWNERS Adds a column with the owner of each file.
PATHLENGTH Adds a column with the length of the full path of each file.
PATHWITHOUTNAME Shows the containing path of each file.
SHA256 Adds a column with the SHA256 checksum of each file.
SIZE Adds a column with the size of each file.
VERSIONS Extracts the version number of binary files.
```
