00197496-01_UM_SiClusterMultiline_DE_EN - 第182页
Import Wizard for CSV Data CSV Import Delimiters 182 SIPLACE SiCluster Multiline SIPLACE SiCluster Multiline 9.1 9 . 1 C S V I m p o r t D e lim it e r s CSV Import Delimiters CSV import wizard for CSV data - CSV import …
Import Wizard for CSV Data
SIPLACE SiCluster Multiline SIPLACE SiCluster Multiline 181
9
9 Import Wizard for CSV Data
Import Wizard for CSV Data
With the help of the CSV Import Wizard, you can import board data or the minimum line cycle times for
your production line.
▪The Configuration => Multi Line Recipes tab enables you to import job data for the boards to be pro-
duced.
▪The Configuration => Cycle Times tab enables you to import the minimum line cycle times for your
production line.
► Open the CSV Import Wizard in the relevant tab by clicking on the icon.
⇨ The CSV Import – Configuration dialog box will open.
⇨ The steps shown in this wizard depend on the function selected.
CSV import wizard for CSV data - CSV import configuration
► Select Import Mode.
PCB Data
Selects the importing of board data. The respective boards must be present in SIPLACE Pro.
Minimum Line Cycle Times
Selects the importing of minimum line cycle times for your production line.
► Select the CSV file path in *.csv or *.txt format.
► Click Next to confirm.
⇨ The CSV Import Delimiters dialog box will open.
NOTICE
Example with PCB data
The screenshots in this section show the process with PCB Data. The process with Minimum
Line Cycle Times is largely identical. Any differences will be explicitly indicated in the descrip-
tion.
Import Wizard for CSV Data
CSV Import Delimiters
182 SIPLACE SiCluster Multiline SIPLACE SiCluster Multiline
9.1
9.1 CSV Import Delimiters
CSV Import Delimiters
CSV import wizard for CSV data - CSV import delimiters
► Go to Field Delimiters and select the relevant delimiters for your CSV file.
▪ The most common characters (tab, comma etc.) can be selected with checkboxes. You can also en-
ter a character of your choice in the text box at Other.
▪ Multiple delimiters in sequence will be recognized as a single delimiter with the option Treat consec-
utive delimiters as one.
▪ A preview of the data separated with delimiters is shown at Result Preview. This preview enables
you, for example, to recognize format errors in the CSV files to be imported.
► Click Next to confirm.
⇨ The CSV Import Column Mappings dialog box will open.
Import Wizard for CSV Data
CSV Import Column Mappings
SIPLACE SiCluster Multiline SIPLACE SiCluster Multiline 183
9.2
9.2 CSV Import Column Mappings
CSV Import Column Mappings
CSV import wizard for CSV data - CSV import column mappings
Edit field: Column header mappings
The assignment of column headers enables you to link the table columns of the CSV file with the relevant
target columns.
Edit field: Results preview
The CSV Import - Column mapping contains a results preview in which the column mapping is clearly
shown.
► Click Next to confirm.
⇨ The CSV Import – Search Pattern dialog box will open.
Parameter Description
CSV File Source Col-
umn
Shows the relevant columns for the selected CSV file.
Multi-Line Target Col-
umn
There are various selection boxes available for the allocation, which vary ac-
cording to the CSV Import Mode selected. Once an allocation has been de-
fined, it will be hidden in the following selection boxes.
For details, see "9.2.1 Notes on Processing" [ ➙ 184].
Line path Only enabled for CSV Import Mode =>Minimum Line Cycle Times.
Double-click on this cell to select the line to be linked to these Minimum Line
Cycle Times.
Concatenator for
Board Name and
Board Name Exten-
sion
Enter the connection character (concatenator) between the Board Name and
Board Name Extension here. This input area for defining a connection charac-
ter for the Board Name and Board Name Extension is only enabled when both
target columns have been assigned.
Combine Order Num-
ber and Board Name
in Recipe Name
This is only available in CSV Import Mode => PCB Data.
This option is enabled if the Job Name and the Board Name have been select-
ed.
The production job number and the board name are then combined and added
to the recipe name.