3.1.13.4.8.2.  CSV

If CSV is selected, the Export CSV dialog box opens.

3.1.13.4.8.2.1. Settings

Make the settings and then confirm with OK.

  • File name: Select via ... Export path and file name.

  • Separator: Select the desired separator [Separator] from the list box.

  • Text identifier [Sign of text identification]: Select the desired one from the list box.

  • Ignore result groups that occur more than once [Ignore duplicate clusters]:

  • Fields: Under Fields, specify the variables [Variables] or topology attributes whose values are to be included in the CSV file.

    [Tip]Tip

    Already used settings are saved.

    In the list field, select the variable combination to be used in the report. When moving the cursor over an entry, all variables are shown with their description in a tooltip.

    Otherwise determine other variables and attributes.

    Click on the button button opens the User-defined variables [Custom variables] dialog box.

    Here, you can specify variables which later will be displayed in the report at each part additionally.

    First click on Add to insert a new line.

    • Variable type:

      Double-click in the line under Variable type to open a list box with the following selection options:

      • ERP

      • Table

      • Topology

    • Variable:

      Via double-click into the line under "Variable" a list field with the following options opens:

      • Input options for variable type ERP:

        When selecting "ERP" the ERP variables of the table are read and shown in a list. You can also enter the value yourself.

      • Input options for variable type Table:

        When selecting "Table" the table variables of the search directory (search source) are read and shown in a list. You can also enter the value yourself.

      • Input options for variable type Topology: First, the term "Topology" is displayed in the cell. Click on it.

        -> Now a dialog showing all topological features is opened.

        At desired features, check the option.

        In this example, the topological attributes "Cylinder" and "Hole" are activated. (Also sub-attributes are possible.)

        In this example, the topological attributes "Cylinder" and "Hole" are activated. (Also sub-attributes are possible.)

    • Labeling:

      Enter a labeling by clicking on it. This will be displayed in the report later.

    • Unit:

      Optionally you can state a unit.

      If the variable has no own unit, the entered unit is displayed.

      If the variable has a unit, the value is converted. (Currently conversion is only possible at the type "Variable".)

      Example:

      The diameter in the table is given in inches. You have stated mm as unit. -> The value is automatically converted from inches to mm.

  • Only export parts with the following status [Export only parts with the following states]: This option is only relevant for duplicate analysis. The status can be marked there. See Section 3.1.13.2, “ Duplicate Analysis.

    • No status

    • This part is a duplicate

    • This part is not a duplicate

    • This part has to be analyzed

  • Export status [Export state]: This option is only relevant for duplicate analysis. The status can be marked there. See Section 3.1.13.2, “ Duplicate Analysis.

  • Activate multithreading [Enable multithreading]: Possibly useful to speed up the process for large files if table variables are to be included in the CSV. Activation should have a positive effect, especially with SSDs and network drives.

3.1.13.4.8.2.2. Result

Example for CSV result table with standard variables and the variable types 'ERP' (Column G), 'Table' (column H) and 'Topology' with one feature (column I):

Example for CSV result table with standard variables and variable type "Topology" with two attributes (Cylinder and RoundHole):

  • MASTER marks a search part, CHILD a result part.

  • Path: respective catalog path

  • Accordance: Percentages in relation to master part

  • The topology [Topology] type is followed by the desired topological attributes, in the example above for "Cylinder" and "RoundHole".

    This is the syntax within a topological field:

    Features separated by |

    Attributes within a feature separated by #

    Exemplary excerpt from above figure:

    1x (D = 33 mm# L = 5 mm# Orientierung = Außen# α = 360 °) | 1x (D = 19 mm
     # L = 14.911 mm# Orientierung = Außen# α = 360 °) | 1x (D = 8 mm# L = 14.233 mm
     # Orientierung = Außen# α = 360 °)