You can prepare the Part cutlist in another program, and then import that list into PLUS 1D, for instance, you may have the part cutlist in a spreadsheet application.
There are two ways to transfer a Part List to PLUS :
1) Using the Windows Clipboard, by simple Copy and Paste : You can copy a single cell, a single column, or row, or the entire table.
2) Using a Comma Separated Value (CSV) file : simply specify the "Import Column" in the "Column Mapping Table". You can alos save these settings for repeated imports.
Import via CSV files, is very flexible as
Import using CSV file dialog:
This dialog is used when you want to import Parts from a CSV file. A CSV file consists of a set of records where fields are separated by delimiters (comma’s or tabs or semicolon or spaces). Each record should be present in a single line.
Delimiter: It is the character used to separate fields in the record in your file. By default the delimiter is comma. The software automatically tries to guess the delimiter, but you can override it if required.
No Of Lines to Skip: If your file has some Non Data Lines at the start, you should specify those lines to be skipped in this edit box.
First row has headers: If your file has got a header before data then you can check this option. This will be used by the package as column header in the Data Preview table .
The import column with and without header is shown below:
Csv With Header:
Csv Without Header:
Save Settings: Saved Formats are a handy way to save your current settings and are useful if you have to import the same format frequently. These settings are automatically loaded the next time you try to import the data.
Data Preview Table: This table shows first few lines of the CSV file as a preview of the data in the file. If First row has header is checked, then the data of the first line will be used as header, otherwise the column will be named as Col1, Col2, Col3.etc. Any changes you make to the settings are immediately reflected in this table.
Column Mapping Table:
The Table consists of the following columns:
Item: This column displays the fields that have to be imported in the Part Table. This is read only, and automatically set depending on what you are importing.
Import Column: Here you specify from which column the data for a particular item is to be read. It contains a combo box which displays the list of column available in the File. There is a special choice list Expression.
Example: This is a read only column to give an idea of the type of data expected.
Default: Here, user can specify default values if you have selected expression in the import column.
Expression : If you select expression, you can import multiple columns into a single field by using the column name prefixed by $, in the Default column. For instance specifying $1-$2 will make the data in the field equal to the value of col1 and col2. You can also use $N which is replaced by the line number (for generating unique names). This could be very useful if you want to automatically name the imported parts as Material-Length combination. If the material column is 2, and length column is 3, this can be accomplished by simply setting the value of default to $2-$3.
The CSV file is shown below:
Note that the fields can be separated by by any type of delimiter. Here the delimiter is Space. The Settings and the Mapping of fields in file to that in package is shown below:
In expression you can use the following functions:
$SC, $SS, $SA, $SN
$SC(ABC123XYZ, 4, 6) returns 123
$SC($1, 1, 3) when column1 is PLT5*400 returns PLT
$SS(ABC#XYZ, #, 1) returns ABC
$SS($1, *, 2) when column1 is PLT5*400 returns 400
$SA(ABC123) returns ABC
$SA($1) when column1 is PLT5*400 returns PLT
$SN(ABC123) returns 123
$SN($1) when column1 is PLT5*400 returns 400
NOTE:-You can combine these functions also.
For example if a column looks like as
1p100 PLT8*260 2 S355 7369 3.9 119.6
1p101 PLT8*89 12 S355 89 0.0 0.4
1p102 PLT8*60 90 S355 60 0.0 0.2
1p103 PLT8*76 16 S355 76 0.0 0.3
1p104 PL10*316 4 S355 317 0.2 7.9
1p105 PL10*277 4 S355 647 0.3 10.4
Format of column2 is :-MaterialCodeThickness*Width . You can combine these functions as
$SA($SS($1, *, 1)) returns MaterialCode
$SN($SS($1, *, 1)) returns Thickness.
$SS($1, *, 2) returns Width.