Router-CIM Automation Suite

RCIM_AS_2020_Header


RCIM_AS_2020_Header


Previous topic Next topic  

RCIM_AS_2020_Header


Previous topic Next topic  

Import Material

 

Use this option when bringing materials into Router-CIM Automation Suite from either a Comma Delimited or Spreadsheet file or from an Automation export file.

 

IM_Options

 

Import from a CSV or Spreadsheet

This window will allow you to import materials into the material database from a saved Excel Spreadsheet (.xls), Comma Delimited file (.csv). The fields for each column are user definable except in the case of the Automation Material database file, which will fill in the fields automatically.

 

IM_CSV_Wizard_File

 

Once you have selected the correct Excel Spreadsheet (.xls), Comma Delimited file (.csv) from the File Explorer and selected open, you will need to define each column so that Router-CIM Automation Suite will know where to put the information:

 

IM_CSV_Wizard_Headings

 

The available data types for each field are:

 

Material Description

Material Code

X-Dim

Y-Dim

Thickness

Min. Drop Off

Bridge Width

Left Edge Allowance

Right Edge Allowance

Top Edge Allowance

Bottom Edge Allowance

Irregular Stock Edge Allowance

Rotation

Cut Scrap

Use Scrap

Inventory Scrap

Scrap Cut Distance from

Material Handling Code

Attribute 1

Attribute 2

Attribute 3

Attribute 4

Attribute 5

Z0 is top

Cost

Nest Type (0; Priority;1:Price;2:Yield)

Jobs per Cart

Open Cart Threshold

Quantity

Priority

Alt. Materials Decrease

Ignore

 

Once the columns have been defined, select the 'Import' button:

 

IM_CSV_Wizard_Finish

 

Import from an Automation Export File

If you are importing from an Automation export file, once selected, a windows browser will open allowing you to select the appropriate .MTL file to import.

 

MatImport_Automation_File

 

Once you select 'Open' Router-CIM Automation Suite will import the MTL file. If no materials need to be overwritten, you will see this:

 

IM_Auto_Complete

 

If the material is already in the database, Router-CIM Automation will overwrite the material currently in the database:

 

IM_Auto_Overwrite