¶ Description
Returns a list of files from a directory and its subdirectories.
¶ Parameters
Parameters:
- Dossier à lister
- Contenu à lister
- Filtrage par nom des fichiers
- Sortie
- Format date et heure
- Lire la taille des fichiers
- Récursion dans les sous-dossiers
- Si aucun fichier trouvé
¶ About
The ListFiles action does reads a directory tree and returns file names and locations. This is often used in conjunction with the FileOpen functionalities, as input pin.
This action outputs a table with the following columns:
| Column Name | Content |
|---|---|
| filePath | Full file path with file name |
| fileName | file name and extension only |
| created | creation date |
| modified | last modification date |
| lastAccessed | last access date |
| absolutePath | full path, without the file name |
| isHidden | hidden attribute, 1/0 |
| isReadable | Read Only Attribute, 0/1 |
| isWritable | Write Protected Attribute, 0/1 |
| isExecutable | Executable attribute, 1/0 |
| Size | Size of the file |
The parameters are as follows:
- File filter: set the filter based on the file name or extension. For example, 2017.* will return all the files containing 2017 in the name. This is an easy way to open files stored with dates in the name.
- Directory to list: set the root directory to analize.
- Output: set the sort criteria to return the file names:
- All files sorted by name
- All files sorted by time
- All files sorted by size
- First file (by name, by time, or by Size)
- Last file (by name, by time or by size)
- Date-time format: set the time format to return in the columns: created, Modified, and Last Accessed
- Get File Size: a Boolean parameter to specify whether to return the file size in the table
- Recurse in (sub)directories: Boolean parameter to specify whether to browse sub directories, or only return information from the selected root directory.
- If no files are found:
- Return an empty table: this is the default option. No error flag is generated
- Abort ETL process with a warning: an warning is generated, but process can still run.
- Abort ETL process with an error: the node turns red, and all is aborted
