Import Slits From Comma Separated Value (CSV) File

You can prepare the Slit cutlist in another program, and then import that list into PLUS Slitting, for instance, you may have the slit cutlist in a spreadsheet application.

There are two ways to transfer a Slit List to PLUS Slitting:

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 also 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 Slits 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 Slit 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 $0 which is replaced by the line number (for generating unique names). This could be very useful if you want to automatically name the imported slits 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:

See Also