YesAX V3.1.2 - Software User Manual.pdf - 第210页

15 -6 SPC Data Logg ing The position tracking is OFF by default. To turn it on, go to Vision>Recipe Option and select the Track XY Position to ODBC Database Table checkbox. Onl y templates with “Check Pos.” turned on …

SPC Data Logging 15-5

UseMySQL=1

MySQLServer=localhost

MySQLUser=root

MySQLPassword=rootpassword

MySQLPort=3306

MySQLOption=3

UseMySQL is set to 1 to enable software to write data to MySQL database instead of MS Access.

Before dumping data to MySQL database, set up MySQL database either locally or on a remote

machine.

 NOTE

UseMySQL and UseSQLServer cannot be set to 1 at the same time. If it is,

software will ignore both requests and write data to the default Access database

instead.

MySQLServer: parameter specifies the name of the MySQL database server. If the installed

database locates in the local YesAX computer, the default parameter will be “localhost”. If

software cannot connect to the specified MySQL database, it will automatically switch back to

Access database.

MySQLUser: specifies the current user.

MySQLPassword: specifies the password for current user.

MySQLPort: specifies the network port used by the current database. The default value is 3306.

MySQLOption: specifies the current connection options for MySQL database. The default

value is set to 3.

With the parameters set, starting the YesAX software will cause the creation of YesDb database

in the MySQL database folder. (By default the full path for MySQL Server version 5.0 is:

C:\Program Files\MySQL\MySQL Server 5.0\data). It is important to let the software to create

the YesDb database automatically. Do NOT try to manually create the database or try to import

the database using the YesDb.mdb file created by the MS Access software. Doing so could

prevent the YesAX software from communicating with the MySQL database server.

To write data to MySQL database, install one extra software package on the local computer. The

name of the installation package is called “mysql-connector-odbc-3.51.26-win32.msi”. Double

click this file to start the installation. This package will install MySQL version 3.51 ODBC

driver on the local computer. This driver will allow YesVision/YesAX to have the ability to

write data to the MySQL database. If you don’t want to export data to the MySQL database,

there is no need to install the MySQL ODBC driver.

15.4 XY Position Tracking

YesAX software can be used to track the XY position of parts on PCBs. The feature is

implemented as an extension to the Marking Inspection feature of the AXI. Marking Inspection

is able to verify placement of any markings or parts using template matching. The feature

compares the “found” position with the “trained” position. If the difference is greater than a

preset tolerance the software will fail the inspection. To track the XY position, the software can

be instructed to log all the “found” positions on the selected parts.

15-6 SPC Data Logging

The position tracking is OFF by default. To turn it on, go to Vision>Recipe Option and select

the Track XY Position to ODBC Database Table checkbox. Only templates with “Check Pos.”

turned on in the Mark Parameters dialog will have their XY position tracked.

Sample Data Output

The XY Positions are sent via the ODBC to a separate table named XYPosTrack. The table has

the following fields:

Assy

Recipe Name

IDate

Inspection date and time stamp.

Serial number of the board inspected.

RefID.

Reference designator for the part

X reference position for the first mark

Y reference position for the first mark

DX1

X Offset position for the first mark

DX2

Y Offset position for the first mark

X reference position for the second mark of the same part

Y reference position for the second mark.

DX2

X Offset position for the second mark.

DY2

Y Offset position for the second mark.

WorkOrder

 NOTE

All positioning units are in microns.

Here is a sample output.

Operational Details

Marking inspection uses a search algorithm called Normalized Grayscale Correlation or in

layman terms “template matching”. All successful template matches generate an XY position of

the successful match. We call this XY position the “Found” position. A deviation is calculated

by subtracting the trained position from this found position. It is this deviation that gets stored

into the database as X and Y.

Each part can have one or more mark inspection boxes. If the part has only one mark inspection

box, only the X1 and Y1 fields in the database table will be filled. X2 and Y2 are for the second

mark inspection box. Having a pair of XY data points allows for the calculation of the rotational

deviation of a placement.

SPC Data Logging 15-7

Mark1 Mark2

Using Edge Locators for Position Tracking

In addition to using pattern matching you can also use the Edge Locator algorithm for position

tracking. Edge locator provides more accurate position tracking on targets with clear and well

defined horizontal and vertical edges. To use Edge locator for position tracking, train two marks

with the Edge Locator algorithm. The first mark should be trained to locate a vertical edge or

strip and the second mark should be trained to locate a horizontal edge or strip. The first mark

will provide the X position plus the angle data and the second mark provides the Y position data

to the database.

15.5 Robust Mode for Data Logging

In the normal operating mode for data logging, the software opens a link to the database during

software start-up and assumes the link to be there for all the subsequent data logging operations.

This mode of operation works well for most of the network environment. In environments where

the network traffic is heavy and a prolong connection to one computer cannot be guaranteed, the

YesAX software offers a more robust mode of data logging. In the Robust Mode, the software

tests the database connection before each batch of data logging operations. It is slightly slower

but far more reliable. To enable Robust Mode, edit the YesAX.ini file:

[ODBC_Report]

RobustMode=1

15.6 Process Alarm

YesAX allows users to setup various trigger conditions to raise process alarms. There are

currently two types of alarms, rate alarms and defect alarms. The rate alarm triggers when the

defect rate or the false call rate exceeds a preset level. The defect alarm triggers when a user-

specified defect condition has been reached.

15.6.1 Rate Alarms

The Rate Alarm triggers when the defect rate or false call rate exceeds the preset level. The

defect rate is measured as PPMO (Part Per Million Opportunities) and is calculated as:

Defects

-------------------------------- * 1,000,000

Opportunity for Defect

The opportunity for defects is the total number of tests performed. It is usually the sum of

Marking, Lead Bank, and Solder inspections.

The false call rate is also measured as PPMO and is calculated as:

False Call Count

-------------------------------- * 1,000,000

Opportunity for False Call