Versions Compared

Old Version 8

changes.mady.by.user Adriane Hunt

Saved on

compared with

New Version Current

changes.mady.by.user Adriane Hunt

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Tip

Tip

  • You can use the toolbar buttons or right-click rows and columns to access editing options.

  • Drag between two column headers to make a column wider or narrower.

  • Standard Cut, Copy, and Paste editing commands are available for selected cells when you right-click a cell (you can undo these actions using Ctrl+Z).

Edit rows

Editing rows

Description

Filter

Removes all rows that contain the specified text from the selected cell in a column.

Filter Matching Options specify the position of the filter text within the search:

  • Starts With - If the specified filter text appears at the beginning of a cell, the entire row is removed

  • Contains - If the specified filter text appears anywhere within a cell in the selected column, the entire row is removed

  • Ends With - If the specified filter text appears at the end of a cell, the entire row is removed

    Filter Rows dialogImage Modified

Map Row to Column Headers

Maps the row of headers at the top of the BOM that define the data in each column to informational rows to define each column in the BOM.

  1. Select the row containing the informational headers (if it exists), then select Map Row to Column Headers on the toolbar.

    BOM Formatting pageImage Modified


  2. FactoryLogix analyzes the row and automatically determines the contents of the column.

    The results are shown in the Map Column Headers dialog.

    Map Column Headers dialogImage Modified


  3. If necessary, modify the information further if desired using the Column Definition drop-downs to map different or additional column headers.

Note

You can also modify individual column definitions on the BOM Formatting page by right-clicking a column header and selecting a new column definition from the menu.

  1. (Optional) Right-click a column header to display commands for sorting, filtering, grouping, and organizing column data.

Column editing commandsImage Modified

  • Sort Ascending - Sorts all column data in A-Z order.

  • Sort Descending - Sorts all column data in Z-A order.

  • Clear Sorting - Removes all sorting from column data and returns it to its original order.

  • Group by This Column - Groups data by the selected column.

  • Show Group Panel - Displays the message "Drag a column header here to group by that column". You can drag any column header onto the message to group by that column. When you see a Red X, the grouping is performed.

  • Hide Group Panel - Hides the grouping panel and message at the top of the dialog.

  • Show Column Chooser - Displays a dialog to show you which column is currently selected for grouping.

  • Best Fit - Fits selected column data to an ideal width.

  • Best Fit (all columns) - Fits all column data to an ideal width.

  • Filter Editor - Displays a dialog where you can specify filtering criteria for BOM data.

  • Show Search Panel - Displays the Search bar so you can search the selected column for specific data.

Note

The Filter Editor is also used in DataMiner (Analytics) and the Trace window (Production) For details about using the Filter Editor, see Filter BOM column data.


Filter Editor for BOM column dataImage Modified


  1. When you are satisfied with the BOM column data, select OK to return to the BOM Formatting page.

Delete Rows

Deletes selected rows of data from the BOM.

Edit columns

Editing columns

Description

Add Text

Adds a prefix or suffix to the text in a selected column. Empty cells in the column will also contain the prefix or suffix automatically.

  • Select Add Text, enter the desired text, then specify the position of the new text (Before or After the selected cell).

    Add Text dialog

Fill Down

In some cases, BOM line items span multiple rows, but not every column's data is repeated in each row.

  • Select a column, then select Fill Down. Any blank cell is filled with the data from above.

Delete Column

Removes a selected column from the imported BOM.

Merge

Merges two or more selected columns of data into a single column. You can also remove the original columns after the merge.


Merge Columns dialog

Split

Divides a single selected column into two or more columns and splits the column at the selected characters.

Split Columns dialog

You can also remove the original columns after the split.

Replace

Searches for and replaces the specified text from the selected cell to all the cells in the column that contain the specified text.

You can match whole words only and/or match replacement text by case.

Replace dialog

Create IPN Column

Allows you to create a new column from the selected column. The data in the new column may be appended with a prefix or suffix.

Create IPN Column dialog

Merge Existing References

Allows you to merge the references from an existing BOM with the imported BOM (primarily used for non-PCB assemblies).

...