Valor Process Preparation Import BOM with multiple lines of Manufacturers and MPN in one cell.

2023-09-28T05:41:09.000-0400
Manufacturing Systems Solutions Data Preparation Import and Export Data Analysis Auto-Assembly Station Configuration Assembly and Documentation Test Engineering Test ViewStation Libraries

Summary

BOM contains cells with multiple lines of Manufacturer and MPN.


Details

To import a BOM each information (Manufacturer, MPN) should be in its own cell.
BOM which contains multi line information in one cell cannot directly be imported.

image.png

To be able to import such BOM, Excel can be used to split multiple lines in a cell into separate cells.
Open the BOM in Excel
Count the maximum number of lines in a cell (Manufacturers and MPN) which has to be split 
Insert empty columns for the split cells accordingly
Select to column with multiple lines to be split
From Data Tab run Text to Columns.
Choose Delimited
Next step select only Other as delimiter and enter CTRL+J in the entry field.
Next step you may define a different destination for the cells.
Click Finish.




 

KB Article ID# KB000122115_EN_US

Contents

SummaryDetails

Associated Components

Valor Process Preparation