Work with table data

Fusion Manufacturing Extension

This feature is part of an extension. Extensions are a flexible way to access additional capabilities in Fusion. Learn more.

Some dialogs in the Fusion Manufacturing Extension consist of tables you can use to manage and edit information in one location; for example, the Process Material Library.

nest study

In these tables, you can edit, sort, import, export, and copy and paste data, as well as create and apply different views.

Show and hide columns and edit information

  1. To show or hide columns, right-click a column header, select Display Columns, then select which columns you want to show.

  2. To sort by property, click the appropriate column header.

  3. To move a column to the left or right, click and drag it to its new location.

  4. To filter the list, right-click a column header and set the filter values you want.

    For example, in the Process Material Library, to only show certain types of materials, right-click the Material header, select Filter by Material, and select the materials you want.

  5. To edit individual values in the table, make changes to them directly in the list. (Gray cells cannot be edited.)

  6. To duplicate, delete, or change the visibility of an item, right-click its row in the table and click Duplicate, Delete, or Visibility.

    Not all these options are available for every table in the Fusion Manufacturing Extension. When you duplicate an item, a copy is created in the table and its name is appended with "(Copy)".

Create and Apply Views

A view is a custom layout of the table that shows the columns and filters you want. Each table has a default view, and you can create your own.

To apply a view:

  1. Right-click in the table and select Apply View.
  2. Select the view you want.

To save a view:

  1. After making changes to a view, right-click inside the table and select Save View.
  2. Enter a name for the view.

Any view you create is stored with your Fusion account, so you can use it with any model you are working with, as long as you are signed in. It is not stored with a nest study, so if someone else opens your project, they will not have access to your custom view.

Edit Multiple Cells at Once (Multi Edit)

  1. Within a column, select the cells you want to change using Shift- or Ctrl-click.
  2. Right-click the selection.
  3. Select Multi Edit from the context menu.
  4. In the dialog that opens, enter the new value for the cells.

Copy and Paste within the Table

You can copy and paste within the table using standard Windows shortcuts:

You can copy and paste one cell to another cell as you normally would, or paste values to multiple cells.

To copy and paste a value to multiple cells:

  1. Copy a cell; for example, a Width value in the Packaging dialog.

    table example - copy cell

  2. Select multiple target cells (using Shift- or Ctrl-click).

    table example - target cells

  3. Paste the copied value onto the selected cells.

    table example - pasted cells

To copy and paste a row to the whole table:

  1. Click the space to the left of the row to select it.

    table example - select row

  2. Copy the row.

  3. Click the upper left corner of the table to select the full table as your paste destination.

    table example - select all

  4. Paste the row.

    The copied row is pasted to all rows in the table.

Import and Export Data

You can import and export all or parts of a table to comma-separated values (CSV) or eXtensible markup language (XML) files. This can be useful for:

To export from the table:

  1. In the table, select the cells you want to export.
  2. Right-click the selection and select Export.
  3. Enter a file name and path for the export and click OK.

The appropriate data, including column headers, are exported to the file.

To import data to the table:

  1. Prepare the CSV or XML file that you want to import.

    For example, you can make changes to a file you previously exported from the table, or you might have a spreadsheet that you created using data from your work environment. Make sure your column headers match those in the table, so that Fusion can place the data correctly. The order of columns does not matter, as long as the header names match.

  2. In the table, click anywhere in a row to designate that row as the start point for data import.

    The cells you import will be inserted starting in this row, into the appropriate column headers.

  3. Right-click inside the table and select Import.

  4. Navigate to the file you want to import and click OK.

The file is imported and the appropriate cells are replaced starting at the row you selected. If the imported file has columns that are not present in the current table view, they are not imported.