Differences

This shows you the differences between two versions of the page.

--- transformations:filelist [2015/10/01 21:52] – dmitry
+++ transformations:filelist [2023/07/24 20:36] (current) – [Columns] add Date last accessed option craigt
@@ Line 1: / Line 1: @@
-===== File list =====
+{{ transformations:FileListAction.png}}
+====== LIST OF FILES ======
+Category: Create / Generate\\
-This transformation creates a table with list of files in specified folder. Such table can later be used for iterations.
+\\
+=====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]]
-**See also:**
-  * [[:iterations|Iterations]]
-  * [[iterateprogram|Iterate external program]]
-  * [[folderlist|Folder list]] transformation