Router-CIM Automation Suite

rcim_2023_header


rcim_2023_header


Previous topic Next topic  

rcim_2023_header


Previous topic Next topic  

Excel and Comma Delimited (CSV)

 

The Excel and Comma Delimited (CSV) Import Wizard allows you to import parts from a file with an excel or comma-delimited format.  

 

Note: In order to use an Excel or Comma Delimited (CSV) to import Assemblies/Jobs instead of parts, please click here for more information.

 

Select File to Import

When you select the Excel and Comma Delimited (CSV) Import Wizard, a dialog box will appear where you can select an Excel or .CSV file to import into Router-CIM Automation Suite.

 

ExcelImportOpen

 

Once you have selected a file, Router-CIM Automation Suite will open the Import Wizard allowing you to format the import wizard based on your file setup.

 

ExcelImport

 

Assign Column Headings

Assigning Column Headings will allow you to select the data for each column in the imported file. The choices available in the pulldown list are:

 

Note: Part Name, Part Material and Quantity must be assigned to a column in order for Router-CIM Automation Suite to import a file.

 

Variable

Field Option

Description

Value Accepted

Ignore

Optional

Ignores entire column during the import process

N/A

Part Name

Required

The ‘Part Name’ variable will define the location of the part on the computer. This field should be reserved for the file path location.

File Path Location

Part Material

Required

This field is used for defining the material of the part. For a seamless transition through the RCIM import wizard, the material used should match the material description in the RCIM Materials Database.

Material Description

Quantity (Qty)

Required

This field is used for defining the number of parts needed.

Whole Number

X Dim

Macros Only

Defines the XDIM variable with use in a parametric macro

Real Number, 30 Character Maximum

Y Dim

Macros Only

Defines the YDIM variable with use in a parametric macro

Real Number, 30 Character Maximum

Z Dim

Macros Only

Defines the ZDIM variable with use in a parametric macro

Real Number, 30 Character Maximum

Ignore Panel

Macros Only

This variable controls if the ‘Panel’ layer of a parametric macro is ignored during the automation process

0 (No) or 1 (Yes)

Backside

Macros Only

This variable controls if an individual parametric macro has an associated backside macro

0 (No) or 1 (Yes)

Description

Optional

This variable controls the information included under the ‘Record Desc’ field located in the part properties window. Each part can be imported with a unique description for labeling purposes

80 Character Maximum

Label Info 1

Optional

This variable controls the information included under the ‘Label Field 1’ located in the part properties window. Each part can be imported with unique label information.

25 Character Maximum

Label Info 2

Optional

This variable controls the information included under the ‘Label Field 2’ located in the part properties window. Each part can be imported with unique label information.

25 Character Maximum

Label Info 3

Optional

This variable controls the information included under the ‘Label Field 3’ located in the part properties window. Each part can be imported with unique label information.

25 Character Maximum

Label Info 4

Optional

This variable controls the information included under the ‘Label Field 4’ located in the part properties window. Each part can be imported with unique label information.

25 Character Maximum

Label Info 5

Optional

This variable controls the information included under the ‘Label Field 5’ located in the part properties window. Each part can be imported with unique label information.

99 Character Maximum

Label Info 6

Optional

This variable controls the information included under the ‘Label Field 6’ located in the part properties window. Each part can be imported with unique label information.

99 Character Maximum

Label Info 7

Optional

This variable controls the information included under the ‘Label Field 7’ located in the part properties window. Each part can be imported with unique label information.

99 Character Maximum

Label Info 8

Optional

This variable controls the information included under the ‘Label Field 8’ located in the part properties window. Each part can be imported with unique label information.

99 Character Maximum

Rotate Part

Optional

This variable controls the part option to rotate the individual part. The rotation of the part occurs once the job has started to be processed and prior to the processing of the actual part itself.

0 (No) or 1 (Yes)

Rotate Angle

Optional

This variable controls the amount of rotation (1 degree increments) when the Rotate Part option is selected

Whole Numbers, 0 – 360

Knowledge Drawing

Optional

This variable defines the ‘Knowledge Drawing’ that will be used to process the part. This option can be different per part when ‘Code As Single Part Only’ is selected in the part properties window. This variable must be the same as the other parts within a job when nesting.

30 Character Maximum (must include .dwg)

DOIT File

Optional

This variable defines the ‘DOIT File’ that will be used to process the part. This option can be different per part when ‘Code As Single Part Only’ is selected in the part properties window. This variable must be the same as the other parts within a job when nesting.

30 Character Maximum (Must include .dat)

Post Processor

Optional

This variable defines the ‘Post Processor’ that will be used to process the part. This option can be different per part when ‘Code As Single Part Only’ is selected in the part properties window. This variable must be the same as the other parts within a job when nesting.

30 Character Maximum (must include .$pp)

Print Nests

Optional

This variable controls the option for printing the created nested sheet after a job has processed.

0 (No) or 1 (Yes)

Print Single Parts

Optional

This variable controls the option for printing the single part after a job has processed when ‘Code as Single Part Only’ is selected.

0 (No) or 1 (Yes)

Job Name

Optional

This variable controls the name of the job created in Router-CIM Automation Suite

30 Character Maximum. NO SPACES.

Filler Quantity (Filler Qty)

Optional

This variable controls the amount of filler parts that are available to nesting per the particular part

4 Numeric Character Maximum or -1

Start Point Longest Side

Optional

This variable controls the option to have the start point of the cut cycle be situated on the longest side of a particular piece of geometry for the particular part

0 (No) or 1 (Yes)

Nest Rotation

Optional

This variable controls the rotation of the part within the material that it will be nested with. The part and the material can have defined nest rotation variables that allow for nesting to handle the part different than what is defined on the nesting material

Same As Material; ALL; 0; 0 90; 0 90 180

Mirror

Optional

This variable controls whether a part will be the mirror image. Direction of the mirror is controlled by the variable ‘Mirror Type’.

0 (No) or 1 (Yes)

Mirror Type

Optional

Defines the axis on which the part will be mirrored

Horizontal or Vertical

Veneer Match Name

Optional

Name defined by the user to identify parts that need to be nested together

30 Character Maximum. NO SPACES.

Veneer Match Location Point

Optional

Location Point needed for the Veneer Matching feature in Router-CIM Automation Suite

X,Y Coordinate point. NO SPACES

Veneer Match Rotation

Optional

Veneer Match Rotation Field

Numeric value up to 3 numbers

Packing Direction

Optional

Defines the direction that the nesting engine will fill up the sheet with the parts defined by the job.

3 (Auto)

4 (Horizontal)

5 (Vertical)

Nesting Start

Optional

Defines the corner that the nesting engine will start to fill up the sheet with the parts defined by the job.

1 (Lower Left)

2 (Upper Left)

3 (Upper Right)

4 (Lower Right)

Sheet Origin

Optional

Defines the corner of the sheet that the output code files will base the X and Y axis direction on.

Ex. 1 would tell the code to be based off the lower left of the sheet meaning positive X and positive Y.

1 (Lower Left)

2 (Upper Left)

3 (Upper Right)

4 (Lower Right)

NC Code Extension

Optional

This will be the file extension that the output files will be created with. The extension is the only thing needed. You do not have to define the decimal point. Ex. TXT, CNC, OUT, etc.

Any 2 or 3 digit file extension that your CNC accepts

Output to Saw

Optional

This variable controls the 'Output to Saw' check box is checked.

0 (No) or 1 (Yes)

Variable

Optional

User defined fields for additional parametric macro variables


 

 

ExcelImportDropDown

 

Save Format (header rows and column headings)

You are able to save the data that is set up for a job by selecting 'Save Format (header rows and column headings)'.  You will be prompted for a name of the Saved Format:

 

ExcelImportDrop_Save_Format_V1

 

Selecting OK will add this name to the Saved Format list so that you can select this format at a later time instead of re-selecting each column.

 

Delete Selected Format

You may delete the saved selected format from the saved format list.

 

Part Material Field Selection

This option allows you to select whether you want Router-CIM Automation Suite to match the material in your excel or comma delimited file based on the material description or material code that you have set up in the Router-CIM Automation Suite Materials database.

 

Clear Current Column Format

If you select a saved format but need to start from the default column headings, select the 'Clear Current Column Format' button to set the column headings to the default.

 

Number of Header Rows

If your comma delimited file has header rows in it for any reason, you can bypass those and get straight to the data by specifying how many header rows to skip.

 

Import

Finally when you are done selecting your file and headings, you can import the file into Router-CIM Automation Suite and it will build a job from the selected data

 

Importing an Excel and Comma Delimited (CSV) to assign TAGGED variables within a Parametric Macro

If you are using an Excel or Comma Delimited file to change TAGGED variables in a parametric macro, you will need to format a column in the excel file to identify the variable name and equal it to the value you are needing.

 

ExcelImportTaggedVariable

 

When creating an import wizard format, you will set this column to 'Variable' from the drop-down options.

 

Importing an Excel and Comma Delimited (CSV) to Create an Assembly Job

If you are using an Excel or Comma Delimited file to reference Jobs in Router-CIM Automation Suite instead of a defined part, you will need to create a Macro Format Job import file (mjf).

 

To create this, it is simply identifying the job in the part name column of your Excel or Comma Delimited file followed by .MJF

 

ExcelImport-MJF

 

Once the Excel or Comma Delimited file has been defined, please refer to the beginning of this section and create an 'Import Wizard Format' to identify the columns needed for import.

 

When using an Excel or Comma Delimited file to import an assembly job already created in Router-CIM Automation Suite, you will need to define the 'Assembly Folder'. This will be a folder created in the Job Library that will contain the assembly jobs you create and will be calling from the MJF import file.

 

ExcelImport-AssemblyFolder

 

For more information on setting the 'Assembly Folder', please refer to the 'Import Wizard Settings' section.

 

When using an Excel or Comma Delimited file to create an assembly job, once imported, the job will look like this:

 

ExcelImport-AssemblyJob