Router-CIM Automation Suite

RCIM_AS_2018_Header


RCIM_AS_2018_Header


Previous topic Next topic  

RCIM_AS_2018_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