00197496-01_UM_SiClusterMultiline_DE_EN - 第183页
Import Wizard for CSV Data CSV Import Column Mappings SIPLACE SiCluster Multiline SIPLACE SiCluster Multiline 183 9.2 9 . 2 C S V I m p o r t C o lu m n M a p p in g s CSV Import Column Mappings CSV import wizard for CSV…
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.
Import Wizard for CSV Data
CSV Import Column Mappings 9.2.1 Notes on Processing
184 SIPLACE SiCluster Multiline SIPLACE SiCluster Multiline
9.2.1
9.2.1 Notes on Processing
Notes on Processing
Disable columns can be recognized by their gray lettering.
There are various column dependencies:
▪ Board name - board name extension
▪ Number of boards - number of panels
▪ Number of orders – average batch size
For CSV import mode => PCB Data
The following selection fields are available for importing board data:
▪ Skip (ignore CSV table column)
▪ Board Name
▪ Board Name Extension
▪ Board Side Designators
▪ Number of Boards
▪ Number of Panels
▪ Order Number
▪ Number of Orders
▪ Average Batch Size
The target column Board Name Extension is an extension of the column Board Name and is combined
with this. The column Board Name Extension is only enabled if the column Board Name has already
been assigned.
The Board Side column is optional. If you do not make an entry here, all existing board sides will be im-
ported.
The Board Side column only accepts the values "top" and "bottom"; irrespective of your language setting.
Uppercase and lower case do not need to be observed.
For CSV Import Mode =>Minimum Line Cycle Times.
The following selection fields are available for importing minimum line cycle times.
▪ Board Name
▪ Board Name Extension
▪ Board Side Designators
▪ Minimum Line Cycle Times Column
The target column Minimum Line Cycle Times Column can be assigned multiple times.
In the CSV file, you can specify the line paths for which ideal cycle times apply in the header of the rel-
evant columns.