Excel parts lists import

Back  Home  Next

In addition to the automatically generated CAD parts lists also Excel parts lists can be generated and imported. To do so please proceed as follows:

 

Select the project in the structure view and click on the tab "parts lists", click in the opened window and on the button "save import template"

 

Excel_parts_list_import_1.png

Excel_parts_list_import_1.png

 

Open here an existing parts lists or the (empty) "Template-PartsList.xlsx".

 

Excel_parts_list_import_2

Excel_parts_list_import_2

 

Complete the Excel file - mandatory fields are:
- manufacturer
- order number
- count

Fill out the parameter sheet completely

 

Parameter sheet

Parameter sheet

 

To import a parts list please click on the buttons "Edit on" and "Import Excel parts lists"
 

Excel_parts_list_import_3

Excel_parts_list_import_3

 

The window with the detail informations can be opened by a double click on the parts list

 

Excel_parts_list_import_4

Excel_parts_list_import_4

 

Excel_parts_list_import_5

Excel_parts_list_import_5

 

 

Possible errors during the Excel import you can find here: Error_in_search_of_the_MDM_Id_ .