Part list import - Overview

 

Options at the Part list to import lists from external files

 

The options at the part list to import data from external files are:-

 

- File - Import

- File - Import wizard

 

These are also options on the Toolbar.

 

File - import

 

The import dialog is shown. This lists the files to import in the last directory used for import. The default directory is the 'Path for import data'.

 

mct2399-01.png

 

At the right the 'Format' box allows you to select the format used in the external file. It can be one of the standard formats the program recognizes or a user defined format - (these are shown at the foot of the list of options).

 

- Select a file to import

 

The program moves to the new or amended part list.

 

File - Import Wizard

 

The program displays a dialog showing the available files (the default directory is the ‘Path for import data’).

 

mct2397-01.png

 

At the bottom right is a ‘Format’ box. The options are:-

 

User defined order ASCII/Unicode

User defined order Excel (XLS)

User defined order Excel (XLSX)

 

- Select the format

 

Typically external files of this sort come from a spreadsheet or have been exported as ASCII files.

 

- Use the dialog to locate the file to import

 

When the file is imported the data found is displayed in a grid on the screen,

 

mct2397-02.png

 

Use this grid to identify each column of data and which field in the Part list the data relates to. This defines the format and layout of the import file.

 

See the following help topics.

 

Parts - Import

Parts - Import Wizard

 

 

See also