{{ transformations:FileListAction.png}}
====== LIST OF FILES ======
Category: Create / Generate\\

\\ 
=====Description=====
This action creates a table with a list of files in the specified folder and their attributes.\\

\\ 
=====Use cases=====
The created file list can be used later for iterations or file commands.\\

\\ 
=====Action settings=====
^ Setting  ^ Description  ^
|Folder<sup>*</sup>|The folder to extract the list of files from.|
|Columns|Provides options to select the types of data to return as fields in the dataset.  See below.|
|Subfolders|Provides options to scan through subfolders within the chosen folder.  See below.|
<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\
\\ 
====Columns====
These options define the columns that will be included in the generated dataset. At least one option must be selected. 
^Option^Description^
|File name with pull path|Returns the fully-qualified file name including absolute path.  Default.|
|File name only|Returns the file name only, excluding path.|
|File extension|Returns the file's extension only.|
|Size|Returns the file's size, in bytes.|
|Date created|Returns the date the file was originally created.|
|Date modified|Returns the date the file was last edited.|
|Read-only|Returns a Boolean (TRUE/FALSE) value defining whether the file is set to read-only mode, or is editable (read/write).|
|Date last accessed|Returns the date the file was most recently accessed.|

\\ 
====Subfolders====
^Option^Description^
|Scan subfolders|When selected, additional options are presented to define the //scan depth// and //scan error handling//.|
|Scanning depth|The number of subfolder levels, under the parent folder, the action will scan within.  e.g. "1" will scan through the\\ subfolders found //directly// under the parent folder only; "2" will scan through the subfolders of the subfolders\\ (i.e. 2 levels deep) found under the parent folder.|
|Ignore scan errors|Select to ignore any errors produced when scanning subfolders for files.  This is useful for avoiding errors when\\ scanning folder depths that may not exist in all subfolders.|

\\ 
=====Community examples=====
  * [[https://community.easymorph.com/t//1475/1|Finding all projects with particular action]] ([[https://community.easymorph.com/uploads/short-url/cM8AssOT6zQXD8JDr9adUAy2sDM.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Documents//; Action position: //1//)
  * [[https://community.easymorph.com/t//1766/1|Load only workbooks with given number of sheets]] ([[https://community.easymorph.com/uploads/short-url/AbWPlfPVBecqgZUBVTYlljwb9NO.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Get file names to load//;\\ Action position: //1//)
  * [[https://community.easymorph.com/t//2063/2|Embedded connection - search for type email server]] ([[https://community.easymorph.com/uploads/short-url/c6uoEKu1XMEc4EFbUol4r0cQS2B.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Projects with email connectors//; Action position: //1//)

\\ 
=====Shortcuts=====
Fast ways to create the action:
  * Press the "Add data" menu button. Pick "Generate data".
  * Drag a folder with various file types into the application window.  Select "Generate a list of files in the folder".

\\ 
=====See also=====
  * [[transformations:folderlist|List of folders]]
  * [[transformations:iterate|Iterate]]
  * [[transformations:iterateprogram|Iterate external program]]