5.8.2.1.15.  Output
5.8.2.1.15.8.  Create CSV table
Prev  Next
5.8.2.1.15.8.  Create CSV table

The contents of the *.tab files in a directory can be read out and listed in a separate file (text or Excel file).

The *.csv file generated in this way can in turn be compared with original company tables.

[Note]Note

In many cases, it is better to use the Create deep links [Generate deeplinks] function instead of Create CSV table.

Create CSV table

Create CSV table

The steps:

  1. Select the directory to be read via Browse .... If the subdirectories are to be taken into account, activate the Edit subdirectories [Working on sub-folders] option.

  2. Specify the storage location under CSV file and confirm with OK.

Setting options:

  • If you don't make any settings, the table variables plus "NB", "LINA", "KT", "IDNR" and "NENN" will be exported.

  • Only use the following variables [Only use following variables]:

    If this check box is selected, only the variables written in the next edit line will be exported (and default variables if the 'Export CNS_* standard var' is checked).

  • Export CNS_ variables:

    If activated, export standard variables: CNS_FILENAME, CNS_NN, CNS_NB, CNS_NT, CNS_LINA, CNS_DATE, CNS_MIDENT. [If enabled, export default variables: CNS_FILENAME, CNS_NN, CNS_NB, CNS_NT, CNS_LINA, CNS_DATE, CNS_MIDENT.]..

  • Only export lines that fulfill the following condition [Export only lines matching the following conditions]: FORTRAN syntax must be used for this.

    Example: If you only want to export the first two rows, use the following condition:

    Standard name resolved

    Standard name resolved 

    B.EQ.15.OR.B.EQ.25

    [Note]Note

    The function does not work for value ranges.

  • Column separator:

  • Decimal separator

  • CSV quotation marks [CSV quotes]:

    CSV quotes to enclose the values from the CSV file.

    Value is set by option for "Create version for assistant".

  • CSV file: Storage location of the CSV file

  • Create version for assistants [Create version for assistant]:

    If this option is enabled, use " as CSV quotes and do not create rows with unit, type, and description

    If the generated file is NOT for an assistant, then quotation marks are not automatically set. Add quotation marks only on values which contain the separator.

  • Translate table values if possible [Translate table values if possible.]:

  • Value ranges:

    • Do not solve value ranges [Do not resolve value ranges]

    • Completely dissolve value ranges [Completely resolve value ranges]

    • Resolve value ranges with standard values

Prev Up Next
5.8.2.1.15.7.  Batch process generate deeplinks  Home 5.8.2.1.15.9.  Check out projects