Excel: Export Component and System Components

All Components and System Components are based on a Occurrences of an Item. “Occurrences” export, within the Reports and Export module, can be used to Export a list of System Components or Components

Export System Components:

System Components are Occurrences of Item that have a System- Classification. Filter can be used to export only Occurrences that are System Components:

1: Select which attributes to include

2: Select Filter

3: Select one of the filter drop-down menus

4: Select “more options”

5: Select “Connection → Item → More.. → Classification → System classification (in this example TFM System) → Code”

6. Select “ok”

7: Set to “Is not empty”

8: Select “Generate” to generate Excel-file or Select “PowerQuery” to create a Excel-file. Read more Power Query

Export Components

Components are Item Occurrences that are member of a System.

1: Select which attributes to include

2: Select Filter

3: Select one of the filter drop-down menus

4: Select “more options”

5: Select: “Connections → “Is member of System”

7: Set to “Is not empty” or/ and filter on System number.

8: Select “Generate” to generate Excel-file or Select “PowerQuery” to create a Excel-file. Read more Power Query