List-CA – Create a list of conditions and actions

extras menu list ca

This function creates a list of all conditions and actions (CA – Condition, Action) from saved decision tables in the form of an Excel or CSV file. This supports search for specific components (retrieval).

list ca 01

Necessary parameters

Parameter [short form]
-List-CA "Directory name(s)" [‑lca]

Generates a list of all conditions and actions from decision tables starting from the “Directory name” directory. It is also possible to specify several directories, separated by the delimiter valid in the operating system (e.g. a semicolon ";" in Windows). If the directory specification is mis­sing, either the current working directory or, if specified, the directory name of the parameter RootDirectory is automatically used.

Optional parameters

Parameter [short form]
-Recursive [-rec]

This parameter causes all subdirectories to be searched, too.
-FileNamePattern "Name pattern" [‑fnp]

Restriction of the processing to files that match the specified name pattern.

Uppercase and lowercase letters are irrelevant.

For masking, you can use the characters
   *  for any string
   ?  for any single character

It is also possible to specify several patterns, separated by a comma or semicolon.
-DataModelLanguages …​ [‑dml]

Only used in exceptional cases if there are multiple language decision tables. LF‑ET supports at present German and English, see also: Language settings.

This parameter can be used to select precisely this language or those languages with which the list is to be created.

At present, possible parameter values include "de" and/or "en".
-SheetCompact …​ [‑sc]

Still "experimental" and only to be output in Excel: this option is used to produce, in another Excel sheet, a more compact list of conditions and actions that should support professional communication in particular.
-FileOut "File name" [‑fo]

The output is written to the “File-Name” file.

Permissible file extensions include: ".xls", ".xlsx", ".csv" and ".txt".

If the name ends with ".xls" or ".xlsx", the output is presented directly in MS Excel format. Otherwise, a text file will be created in CSV format.

If the file name is mis­sing, the default setting "LFET-List-CA.xlsx" will be used automatically.
-CreateMissingFolders [‑crmf]

This parameter causes output directories that do not exist yet to be automatically created.
-RootDirectory "Directory name" [‑rd]

This parameter causes all directories in the output relative to the directory specified here to be represented. If the entry for the directory is mis­sing, the directory resulting from the parameter -List-CA is automatically used.
-OpenDirectoryOut [‑odo]

This parameter causes the directory containing the file created by -FileOut to open automatically.

If the parameter -FileOut is mis­sing, generation of the output file with the preset name will be triggered at the same time.
-OpenFileOut [‑ofo]

This parameter causes the file created by FileOut to be automatically opened with the system editor relevant for the file type (e.g., Notepad, MS-Excel, etc.)

If the parameter -FileOut is mis­sing, generation of the output file with the preset name will be triggered at the same time.
-ColorHyperlinks [‑ch]

Hyperlinks in Excel files are not automatically selected in LF‑ET. By specifying this parameter, all hyperlinks are displayed in blue and underlined.
-DelimItem "x" [‑di]

The default column separator (;) can now be changed to another value.

This parameter is only relevant for output in CSV format.
-DelimText "y" [‑dt]

The default column separator (") can now be changed to another value.

This parameter is only relevant for output in CSV format.

Examples of use

A typical form of retrieval is e.g.:

lfetconsole.bat -List-CA -Recursive -OpenFileOut

or in short form:

lfetconsole.bat -list-ca -rec -ofo

Some columns may contain very long or extensive textual information (long folder names, complete texts for decision table, etc.). These columns are simply set very narrow in spreadsheet programs, such as. MS-Excel, so that it can clearly be seen whether a piece of information is included or not. If the content is to be viewed, the corresponding cell is simply marked and the complete content can be viewed in the activated formula bar.

Further information: