General Information about Part Import

Why Use This Procedure?

This procedure is used to import and update parts from regular text files. Material to the type BOM list and operations to the type Operations can only be imported if this information does not already exist on the part. For example from CAD systems or customers.

In the window you configure and enter the order of the fields in the text files. These settings can be saved as templates for separate text files or generally. In connection with the import, you can select which part type and status new parts should be given if this information is missing in the file.

When saving, the part numbers will be inherited from the text file. A validation is made and New, Modified, Unchanged and Incorrect parts will be presented in different ways in the list.

Conditions for Part Import

Part import can be made from text files. The file must contain a part number column. Each part should take up one row in the text file. All fields that you want to import have to be positioned on the same row in their own columns. You can import existing part data when using the import type Parts.

For column separator you have to use tab, comma, or semicolon. The decimal separator in the price column should be period (.) or comma (,). The text file can also be created in for example Excel.

For parts you can import the following fields: Part number, Name, Part type, Standard price, Unit, Alternate unit, Conversion factor, Part code, Category, Product group, Drawing number, Revision, Additional name 1-4, Safety stock, Reorder point, EOQ, Min. quantity, Round-off quantity, Lead time, Supplier code, Supplier price, Supplier's part number, Customer code, Customer price and Customers part number.

For BOM lists you can import the following fields: Main part number, Part number, Name of the main part, Part type of the main part, Name, Part type, Quantity, Setup quantity, Extra %, Pos, Instruction (1 row) and For operation.

To operations you can import the following fields: Part number (to which the operations shall be linked, mandatory visible from the start), Operation (mandatory visible from the start), Work center (mandatory visible from the start, validation that they are registered), Operation name, Setup time, Unit time, Ineffective time %, Operation's capacity factor, Overlap, Queue time, Setup quantity, Extra (%), Time code (TC), Cost factor exception, Fixed lead time, Subcontractor, Currency, Supplier's part number, Staffing factor exception and Instruction.

You can then choose to include these fields in the import and it is also possible to change the order of the columns.

You cannot complement BOM lists or operation lists in this procedure.

Window Functions

Read more about the Window functions under Window Functions in the MONITOR Basics guide.